← Back to team overview

maria-developers team mailing list archive

Default value on column in sql_mode=ORACLE


Hello Alexander,

Do you know why STRICT_TRANS_TABLES is not set in sql_mode=ORACLE ?

The following script should not work:

set sql_mode=oracle;
create table t1 (c1 integer not null,c2 integer not null);
insert into t1 (c1) values(1);
Query OK, 1 row affected, 1 warning 


Follow ups