[Maria-developers] Default value on column in sql_mode=ORACLE
2 Aug
2017
2 Aug
'17
12:07 p.m.
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 Regards, Jérôme.
11 Aug
11 Aug
1:26 p.m.
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
2690
Age (days ago)
2699
Last active (days ago)
1 comments
2 participants
participants (2)
-
Alexander Barkov -
jerome brauge