Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
stevemuench opened this issue Sep 30, 2024 · 0 comments

Comments

@stevemuench
Copy link

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)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant