Boolean Datatype 23c (Was: Order of 'default' with boolean produces invalid SQL) about quicksql HOT 7 CLOSED

1.2.1:

create table foo (
    id     number generated by default on null as identity
           constraint foo_id_pk primary key,
    bar    varchar2(1 char) default on null 'y'
           constraint foo_bar check (bar in ('Y','N'))
);

from quicksql.

@vadim-tropashko this fixes the syntax issue, but will we ever have boolean support for database 23 and newer?

Let me know if separate issue needed for that please.

from quicksql.

Boolean datatype it is

from quicksql.

#boolean: yn           -- default
#boolean: native     -- 23c

from quicksql.

Brilliant. So if my db setting < 23, even if I put boolean, can we convert it to varchar2 for that scenario?

from quicksql.

db parameter is not used. If there is another db-dependent feature, then we might reintroduce it to influence the dependent options default values in bulk

from quicksql.

The db option is right there in the doc; will nuke it until further notice (that is, more than one db dependent parameter appearing in the future).

from quicksql.