Format SQL issue in the SQL Editor

[john-black-3k]

Hello,

I am executing the following query on the chinook sample database:

INSERT INTO ex1.people SELECT FirstName, LastName FROM customers;

Here, "ex1" is another database in the list and "people" is a table with 2 TEXT columns.

Clicking "Format SQL" in the toolbar removes the dot between "ex1" and "people", replacing it with a space. This causes part of the query to be underlined in red, because it is not valid anymore.

Thanks in advance!

[pawelsalawa]

Created issue #5226

[john-black-3k]

I have encountered another issue with "Format SQL" feature. Consider the following statement with a generated column:

CREATE TABLE products(
    name TEXT NOT NULL,
    price REAL NOT NULL,
    discount REAL NOT NULL,
    tax REAL NOT NULL,
    net_price REAL GENERATED ALWAYS 
        AS (price * (1-discount) * (1+tax))
);

Clicking "Format SQL" once surrounds the REAL after net_price with []. Pressing it again surrounds that with "" and so forth (press it 4 times).

Why is this quoting done?

Best regards!

[pawelsalawa]

The REAL should not be treated as reserved keyword. It's bug and will be fixed.

[pawelsalawa]

Created #5234 to fix it.