[sqlite] Multiple line command pasted to shell is split in history

[Niall O'Reilly]

On 20 May 2016, at 17:35, Jaromir Obr wrote:

> Expected result:
> 
> SELECT REPLACE(ingredients,'enriched_','') as item_ingredients
> FROM baked_goods;
>
> Actual result:
> 
> FROM baked_goods;
>
> Note: It works well in MariaDB shell, in the same terminal

  Either way has its advantages.

  I find keeping the original line-folding more convenient for
  both readability and making corrections than having the line
  wrapped (often splitting a token) at the edge of the window.

  I can also why you and others might prefer UP/RETURN to
  UP/UP/RETURN/UP/UP/RETURN.


  Best regards,
  Niall O'Reilly

[sqlite] Multiple line command pasted to shell is split in history

[Jaromir Obr]

Hi, I've hit an issue with multiple line command.

Used SW:

   - sqlite3 3.11.0
   - bash 4.3-14
   - gnome-terminal 3.18.3
   - Ubuntu 16.04

Steps to reproduce:

   - Copy these two lines into clipboard:

SELECT REPLACE(ingredients,'enriched_','') as item_ingredients
FROM baked_goods;

   - Paste it to sqlite shell and press ENTER
   - Press the key UpArrow
   - See what you get

Expected result:

SELECT REPLACE(ingredients,'enriched_','') as item_ingredients
FROM baked_goods;

Actual result:

FROM baked_goods;

Note: It works well in MariaDB shell, in the same terminal

Regards

Jaromir Obr