← 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:

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