Debian Codegraph @

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

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