quicksql icon indicating copy to clipboard operation
quicksql copied to clipboard

Commented QuickSQL in Generated SQL Script Can't Be Pasted As Is into QuickSQL Again

Open stevemuench opened this issue 4 months ago • 0 comments

When you create a table with QuickSQL, the generated SQL script contains a commented version of the QuickSQL source like:

/*
person
    name

 Non-default options:
# settings = {"apex":"Y","db":"19c","pk":"IDENTITY"}

*/

Later, when you want to modify the schema, you typically start by pasting the QuickSQL source in the comment back into the QuickSQL editor as the baseline. However, the presence of the "Non-default options:" causes problems since QuickSQL treats that as a column name if pasted in verbatim. This line should be generated in a way that QuickSQL will ignore if pasted in verbatim.

-- create tables

create table person (
    id                        number generated by default on null as identity
                              constraint person_id_pk primary key,
    name                      varchar2(255 char),
    "Non-default options:"    varchar2(4000 char)
);

stevemuench avatar Sep 30 '24 13:09 stevemuench