| 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; |