Debian Codegraph @

mysql-test/suite/sysschema/t/fn_list_drop.test

raw
1 -- source include/not_embedded.inc
2 # Tests for sys schema
3 # Verify the sys.sql_mode_drop() function perfoms as expected
4
5 # Remove from front of list
6 SELECT sys.list_drop('1,2,3,4,5', '1');
7
8 # Remove from middle of list
9 SELECT sys.list_drop('1,2,3,4,5', '3');
10
11 # Remove from end of list
12 SELECT sys.list_drop('1,2,3,4,5', '5');
13
14 # Make sure spaces are appropriately dealt with
15 SELECT sys.list_drop('1, 2, 3, 4, 5', '1');
16 SELECT sys.list_drop('1, 2, 3, 4, 5', '3');
17 SELECT sys.list_drop('1, 2, 3, 4, 5', '5');
18
19 # Should return an error with a NULL value to drop
20 --error 1138
21 SELECT sys.list_drop('1,2,3,4,5', NULL);
22
23 # Test the sql mode update use case
24 # save old mode to restore
25 SET @sqlmode := @@sql_mode;
26
27 SELECT @@sql_mode;
28
29 SET SESSION sql_mode = sys.list_drop(@@sql_mode, 'STRICT_TRANS_TABLES');
30
31 SELECT @@sql_mode;
32
33 # restore old mode
34 SET SESSION sql_mode = @sqlmode;
35 SET @sqlmode := NULL;