editline | A small replacement for GNU readline for UNIX | Command Line Interface library

I have a test container for Mysql and I need to import the dump file after the container started. I've tried two options below.

Environment

• Mac OS Big Sur Ver 11.6
• MAMP Ver 6.5
• PHP Ver 7.4.21
• MySQL Ver 14.14 Distribute 5.7.34

Issue

I was using MySQL on MAMP but now having errors after restarted my mac.

First, I got this error.

I've compiled and built a C++ program (that uses SDL2, in case that matters) on Ubuntu 20.0.4, but when I try to run it, it just prints "Invalid argument". If I try to run it via gdb, it also prints "Invalid argument" and then "During startup program exited with code 126." (This before it hits a breakpoint set at main.)

Things I have tried:

• Verified that the execute bit is set on the file.
• Added the -no-pie linker flag, which makes it build a normal ELF executable rather than a relocatable one (see here). readelf and file now both agree it is an executable. file now prints:

ELF 64-bit LSB executable, x86-64, version 1 (SYSV), dynamically linked, interpreter /lib64/ld-linux-x86-64.so.2, BuildID[sha1]=432e038be2c1180ec019b585ffbca182a80f6c55, for GNU/Linux 3.2.0, with debug_info, not stripped

• Checked its library dependencies with ldd. A couple dozen libraries are listed but all appear to be found successfully.
• Tried executing it via sudo, in case it was some weird ownership/permission problem. Same error occurs.

My Makefile is pretty simple, but it ends up doing the whole compile & link process with just this one command:

I am writing a Linux program that interacts with some custom hardware via GPIO lines. It uses a timer periodically delivering SIGALRM in order to manage the timing of these interactions, and there is quite some work performed within the signal handler. The program offers a command-line interface, and I would love to have the line-editing convenience provided by libreadline. Unfortunately, it would seem libreadline does not cope well with those periodic signals. I also tried the readline compatibility mode of libedit (a.k.a. “editline”), with no luck.

Is there an easy way to have readline capability in a program that receives numerous SIGALRM signals?

When using libreadline, if the timer is running, some of the characters typed are randomly echoed twice. For example, typing "help" may result in "heelp" being displayed on the terminal. The issue is only apparent in the echo: the program does receive the word as typed (i.e. "help").

When using libedit in readline compatibility mode, if the timer is running, readline() returns NULL whenever it is interrupted by the SIGALRM signal.

When the timer is stopped, everything works as expected, both with libreadline and with libedit.

Ubuntu 20.04 with the latest apt packages libreadline-dev (version 8.0-4) and libedit-dev (3.1-20191231-1). The program will eventually be deployed on a Raspberry Pi running Raspberry Pi OS.

Here is an attempt at a minimal(ish), reproducible example:

I am using mysql Ver 14.14 Distrib 5.7.21, for Linux (x86_64) using EditLine wrapper.

I am having a table called companies and a table fundamentals.

I would like to join the latest values of fundamentals to the companies table, whereas latest is the created_at in fundamentals.

Please find below my minimum example on db-fiddle:

db-fiddle example

My current query looks like the following:

I'm working with Internet Speculative Fiction Database downloadable MySQL database. This query:

In MySQL I have a catalog table like this:

I'm trying to change the password of one of the users on a MySQL database.

When I do :

I'm getting a mysql create table syntax error and hoping someone can spot it before I loose my sanity.