← Back to team overview

maria-developers team mailing list archive

Re: Default value on column in sql_mode=ORACLE


Hi Jerome,

I created an MDEV for this:


Thanks for reporting!

On 08/02/2017 02:07 PM, jerome brauge wrote:
> 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