Debian Codegraph @

mysql-test/suite/sysschema/r/fn_list_add.result

raw
1 SELECT sys.list_add(NULL, 'foo');
2 sys.list_add(NULL, 'foo')
3 foo
4 SELECT sys.list_add('', 'foo');
5 sys.list_add('', 'foo')
6 foo
7 SELECT sys.list_add('bar', 'foo');
8 sys.list_add('bar', 'foo')
9 bar,foo
10 SELECT sys.list_add('bar, ', 'foo');
11 sys.list_add('bar, ', 'foo')
12 bar,foo
13 SELECT sys.list_add('foo', NULL);
14 ERROR 02200: Function sys.list_add: in_add_value input variable should not be NULL
15 SET @sqlmode := @@sql_mode;
16 SELECT @@sql_mode;
17 @@sql_mode
18 ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
19 SET SESSION sql_mode = sys.list_add(@@sql_mode, 'ANSI_QUOTES');
20 SELECT @@sql_mode;
21 @@sql_mode
22 ANSI_QUOTES,ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
23 SET SESSION sql_mode = @sqlmode;
24 SET @sqlmode := NULL;
25 SET @input := REPEAT('a', 4194304);
26 SELECT sys.list_add(@input, 'foo');
27 ERROR 22001: Data too long for column 'in_list' at row 1
28 SET @input := NULL;