Debian Codegraph @

mysql-test/suite/test_service_sql_api/t/test_sql_sqlmode.test

raw
1 SET @sql_mode_global = @@global.sql_mode;
2 SET @sql_mode_session = @@session.sql_mode;
3
4 CREATE TABLE t1(a varchar(20) not null, b varchar(20));
5 CREATE TABLE t2(a varchar(20) null, b varchar(20));
6
7 INSERT INTO t1 VALUES('t1a1','t1b1');
8 INSERT INTO t1 VALUES('t1a2','t1b2');
9 INSERT INTO t1 VALUES('t1a3','t1b3');
10 INSERT INTO t1 VALUES('t1a4','t1b4');
11
12 INSERT INTO t2 VALUES('t2a1','t2b1');
13 INSERT INTO t2 VALUES('t2a2','t2b2');
14 INSERT INTO t2 VALUES('t2a3','t2b3');
15 INSERT INTO t2 VALUES('t2a4','t2b4');
16
17 SET @@global.sql_mode = NO_UNSIGNED_SUBTRACTION;
18
19 SELECT @@global.sql_mode;
20 SELECT @@session.sql_mode;
21
22 --echo ##########################################
23 --echo # Run plugin
24 --echo ##########################################
25 --replace_result $TEST_SQL_SQLMODE TEST_SQL_SQLMODE
26 eval INSTALL PLUGIN test_sql_sqlmode SONAME '$TEST_SQL_SQLMODE';
27
28 --echo ##########################################
29 --echo # Stop plugin
30 --echo ##########################################
31 UNINSTALL PLUGIN test_sql_sqlmode;
32
33 --echo ##########################################
34 --echo # Plugin log
35 --echo ##########################################
36 let $MYSQLD_DATADIR= `select @@datadir`;
37 cat_file $MYSQLD_DATADIR/test_sql_sqlmode.log;
38 remove_file $MYSQLD_DATADIR/test_sql_sqlmode.log;
39
40 SELECT @@global.sql_mode;
41 SELECT @@session.sql_mode;
42
43 SET @@session.sql_mode = @@global.sql_mode;
44 SELECT @@session.sql_mode;
45
46 --echo # SQL_MODE : NO_UNSIGNED_SUBTRACTION(Checking whether subtraction result is signed)
47 SELECT CAST(0 AS UNSIGNED) - 1;
48
49 --echo ##########################################
50 --echo # Cleanup
51 --echo ##########################################
52
53 --echo # Dropping the created tables
54 DROP TABLE t1;
55 DROP TABLE t2;
56
57 SET @@global.sql_mode = @sql_mode_global;
58 SET @@session.sql_mode = @sql_mode_session;