Debian Codegraph @

mysql-test/suite/x/t/connection_sql_mode.test

raw
1 ## Preamble
2 --source include/xplugin_preamble.inc
3 --source include/xplugin_create_user.inc
4
5
6 ## Test starts here
7
8 --echo 1. Check connection for SQL_MODE = DEFAULT
9 --exec $MYSQLXTEST -ux_root --password='' --sql="select 1 as value" 2>&1
10
11
12 --echo 2. Check connection for SQL_MODE = DEFAULT + PAD_CHAR_TO_FULL_LENGTH
13 SELECT CONCAT_WS(',', @@global.SQL_MODE, 'PAD_CHAR_TO_FULL_LENGTH') INTO @MODES;
14 SET @@GLOBAL.SQL_MODE=@MODES;
15
16 --exec $MYSQLXTEST -ux_root --password='' --sql="select 2 as value" 2>&1
17
18
19 --echo 3. Check connection for SQL_MODE set modes taken from bug log
20 SET @@GLOBAL.SQL_MODE='ANSI_QUOTES,NO_AUTO_VALUE_ON_ZERO,NO_BACKSLASH_ESCAPES,NO_DIR_IN_CREATE,NO_ZERO_DATE,PAD_CHAR_TO_FULL_LENGTH';
21
22 --exec $MYSQLXTEST -ux_root --password='' --sql="select 3 as value" 2>&1
23
24
25 --echo 4. Check connection for SQL_MODE back to DEFAULT
26 SET @@GLOBAL.SQL_MODE=DEFAULT;
27
28 --exec $MYSQLXTEST -ux_root --password='' --sql="select 4 as value" 2>&1
29
30
31 ## Cleanup
32 --source ../include/xplugin_cleanup.inc