Debian Codegraph @

mysql-test/suite/compat/oracle/t/keywords.test

raw
1 SET sql_mode=ORACLE;
2
3 --echo #
4 --echo # MDEV-17363 Compressed columns cannot be restored from dump
5 --echo # In sql_mode=ORACLE, COMPRESSED is still valid both as an SP label
6 --echo # and an SP variable name.
7 --echo #
8
9 DELIMITER $$;
10 BEGIN
11 IF TRUE THEN
12 GOTO compressed;
13 END IF;
14 SELECT 'This should not be reached' AS warn;
15 <<compressed>>
16 BEGIN
17 SELECT 1 AS a;
18 END;
19 END
20 $$
21 DELIMITER ;$$
22
23 DELIMITER $$;
24 DECLARE compressed INT DEFAULT 1;
25 BEGIN
26 SELECT compressed;
27 END
28 $$
29 DELIMITER ;$$