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

Boolean type uses the wrong case for the default value #42

Closed dmcghan closed 9 months ago

dmcghan commented 9 months ago

This Quick SQL:

test
  approved boolean /default N

Yields this SQL:

create table test (
    id          number generated by default on null as identity
                constraint test_id_pk primary key,
    approved    varchar2(1 char) constraint test_approved
                check (approved in ('Y','N')) default on null 'n'
);

Note the default value n is lower case.

vadim-tropashko commented 9 months ago

1.2.1