oracle / quicksql

A library for generating DDL SQL and entity-relationship-diagrams from Quick SQL code
Universal Permissive License v1.0
53 stars 11 forks source link

email address parsing error for column defaults #48

Closed damithkothalawala closed 9 months ago

damithkothalawala commented 9 months ago

how to replicate the issue

support support_email vc100 /default support@oracle.com

expected column

support_email varchar2(100 char) default on null 'support@oracle.com',

what I got is out of range 102399 for varchar length. Seems something to do with @ handling.

support_email varchar2(102399 char) default on null 'support@oracle.com',

vadim-tropashko commented 9 months ago

https://krisrice.io/quick-sql-standalone.html which runs 1.1.4 outputs:

create table support (
    id               number generated by default on null as identity
                     constraint support_id_pk primary key,
    support_email    varchar2(100 char) default on null 'support'
);

which is still a bug, albeit a different one

vadim-tropashko commented 9 months ago

1.2.1

damithkothalawala commented 9 months ago

Thank you 🙏🏻