Debian Codegraph @

mysql-test/suite/x/r/connection_sql_mode.result

raw
1 1. Check connection for SQL_MODE = DEFAULT
2 RUN select 1 as value
3
4 value
5 1
6 0 rows affected
7 Mysqlx.Ok {
8 msg: "bye!"
9 }
10 ok
11 2. Check connection for SQL_MODE = DEFAULT + PAD_CHAR_TO_FULL_LENGTH
12 SELECT CONCAT_WS(',', @@global.SQL_MODE, 'PAD_CHAR_TO_FULL_LENGTH') INTO @MODES;
13 SET @@GLOBAL.SQL_MODE=@MODES;
14 Warnings:
15 Warning 3090 Changing sql mode 'PAD_CHAR_TO_FULL_LENGTH' is deprecated. It will be removed in a future release.
16 RUN select 2 as value
17
18 value
19 2
20 0 rows affected
21 Mysqlx.Ok {
22 msg: "bye!"
23 }
24 ok
25 3. Check connection for SQL_MODE set modes taken from bug log
26 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';
27 Warnings:
28 Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
29 Warning 3090 Changing sql mode 'PAD_CHAR_TO_FULL_LENGTH' is deprecated. It will be removed in a future release.
30 RUN select 3 as value
31
32 value
33 3
34 0 rows affected
35 Mysqlx.Ok {
36 msg: "bye!"
37 }
38 ok
39 4. Check connection for SQL_MODE back to DEFAULT
40 SET @@GLOBAL.SQL_MODE=DEFAULT;
41 RUN select 4 as value
42
43 value
44 4
45 0 rows affected
46 Mysqlx.Ok {
47 msg: "bye!"
48 }
49 ok