github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/dm/tests/sql_mode/data/db2.increment.sql (about)

     1  set @@session.sql_mode='ONLY_FULL_GROUP_BY,NO_UNSIGNED_SUBTRACTION,NO_DIR_IN_CREATE,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,HIGH_NOT_PRECEDENCE,NO_ENGINE_SUBSTITUTION,REAL_AS_FLOAT';
     2  -- NO_AUTO_CREATE_USER set failed in mysql8.0
     3  
     4  use sql_mode;
     5  
     6  -- test sql_mode PIPES_AS_CONCAT
     7  set @@session.sql_mode=concat(@@session.sql_mode, ',PIPES_AS_CONCAT');
     8  insert into t_2(name) values('pipes'||'as'||'concat');
     9  
    10  -- test sql_mode ANSI_QUOTES
    11  insert into t_2(name) values("a");
    12  
    13  -- test sql_mode IGNORE_SPACE
    14  set @@session.sql_mode=concat(@@session.sql_mode, ',IGNORE_SPACE');
    15  insert into t_2(name) values(concat ('ignore', 'space'));
    16  
    17  -- test sql_mode NO_AUTO_VALUE_ON_ZERO
    18  set @@session.sql_mode=concat(@@session.sql_mode, ',NO_AUTO_VALUE_ON_ZERO');
    19  insert into t_2(id, name) values (20, 'a');
    20  replace into t_2(id, name) values (0, 'c');
    21  
    22  -- test sql_mode NO_BACKSLASH_ESCAPES
    23  set @@session.sql_mode=concat(@@session.sql_mode, ',NO_BACKSLASH_ESCAPES');
    24  insert into t_2(name) values ('\\a');