maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #10837
Re: Default value on column in sql_mode=ORACLE
Hi Jerome,
I created an MDEV for this:
https://jira.mariadb.org/browse/MDEV-13501
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
References