Debian Codegraph @

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

raw
1 --source include/have_binlog_format_row.inc
2
3 SET sql_mode=ORACLE;
4
5 --disable_ps2_protocol
6 CREATE SEQUENCE s1;
7 SHOW CREATE SEQUENCE s1;
8 SELECT s1.currval;
9 SELECT s1.nextval;
10 SELECT s1.nextval;
11 SELECT s1.nextval;
12 EXPLAIN EXTENDED SELECT s1.nextval;
13 SELECT nextval(s1);
14 EXPLAIN EXTENDED SELECT s1.currval;
15 SELECT lastval(s1);
16 DROP SEQUENCE s1;
17 --enable_ps2_protocol
18
19 CREATE SEQUENCE s1;
20 CREATE VIEW v1 AS SELECT s1.nextval AS a;
21 SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME='v1';
22 --disable_ps2_protocol
23 SELECT * FROM v1;
24 --enable_ps2_protocol
25 SHOW CREATE VIEW v1;
26 DROP VIEW v1;
27 DROP SEQUENCE s1;
28
29
30 CREATE SEQUENCE s1;
31 CREATE VIEW v1 AS SELECT s1.currval AS a;
32 SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME='v1';
33 SELECT * FROM v1;
34 SHOW CREATE VIEW v1;
35 DROP VIEW v1;
36 DROP SEQUENCE s1;
37
38 --echo #
39 --echo # MDEV-12533 sql_mode=ORACLE: Add support for database qualified sequence names in NEXTVAL and CURRVAL
40 --echo #
41 --disable_ps2_protocol
42 CREATE SEQUENCE s1;
43 SELECT test.s1.nextval;
44 SELECT test.s1.currval;
45 SELECT .s1.nextval;
46 SELECT .s1.currval;
47 DROP SEQUENCE s1;
48 --enable_ps2_protocol