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

     1  set @@session.SQL_MODE='';
     2  use `sql_mode`;
     3  
     4  -- test sql_mode PIPES_AS_CONCAT
     5  insert into t_1(num) values('pipes'||'as'||'concat');
     6  
     7  -- test sql_mode ANSI_QUOTES
     8  insert into t_1(name) values("a");
     9  
    10  -- test sql_mode IGNORE_SPACE
    11  create table sum (id int not null, primary key(id));
    12  
    13  -- test sql_mode NO_AUTO_VALUE_ON_ZERO
    14  insert into t_1(id, name) values (30, 'a');
    15  insert into t_1(id, name) values (0, 'b');
    16  insert into t_1(id, name) values (0, 'c');
    17  
    18  -- test sql_mode NO_BACKSLASH_ESCAPES
    19  insert into t_1(name) values ('\\b');
    20  
    21  -- test sql_mode STRICT_TRANS_TABLES && STRICT_ALL_TABLES && NO_ZERO_IN_DATE && NO_ZERO_DATE && ALLOW_INVALID_DATES
    22  insert into t_1(dt) values('0000-06-00');
    23  insert into t_1(dt) values('0000-00-01');
    24  insert into t_1(dt) values('0000-06-01');
    25  insert into t_1(dt) values('0000-00-00');
    26  
    27  -- test sql_mode ERROR_FOR_DIVISION_BY_ZERO
    28  insert into t_1(num) values(4/0);
    29  
    30  -- test sql_mode NO_AUTO_CREATE_USER
    31  drop user if exists 'no_auto_create_user';
    32  grant select on *.* to 'no_auto_create_user';