Debian Codegraph @

mysql-test/suite/compat/oracle/r/sequence.result

raw
1 SET sql_mode=ORACLE;
2 CREATE SEQUENCE s1;
3 SHOW CREATE SEQUENCE s1;
4 Table Create Table
5 s1 CREATE SEQUENCE "s1" start with 1 minvalue 1 maxvalue 9223372036854775806 increment by 1 cache 1000 nocycle
6 SELECT s1.currval;
7 s1.currval
8 NULL
9 SELECT s1.nextval;
10 s1.nextval
11 1
12 SELECT s1.nextval;
13 s1.nextval
14 2
15 SELECT s1.nextval;
16 s1.nextval
17 3
18 EXPLAIN EXTENDED SELECT s1.nextval;
19 id select_type table type possible_keys key key_len ref rows filtered Extra
20 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used
21 Warnings:
22 Note 1003 select nextval("test"."s1") AS "s1.nextval"
23 SELECT nextval(s1);
24 nextval(s1)
25 4
26 EXPLAIN EXTENDED SELECT s1.currval;
27 id select_type table type possible_keys key key_len ref rows filtered Extra
28 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used
29 Warnings:
30 Note 1003 select lastval("test"."s1") AS "s1.currval"
31 SELECT lastval(s1);
32 lastval(s1)
33 4
34 DROP SEQUENCE s1;
35 CREATE SEQUENCE s1;
36 CREATE VIEW v1 AS SELECT s1.nextval AS a;
37 SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME='v1';
38 VIEW_DEFINITION
39 select nextval(`test`.`s1`) AS `a`
40 SELECT * FROM v1;
41 a
42 1
43 SHOW CREATE VIEW v1;
44 View Create View character_set_client collation_connection
45 v1 CREATE VIEW "v1" AS select nextval("test"."s1") AS "a" latin1 latin1_swedish_ci
46 DROP VIEW v1;
47 DROP SEQUENCE s1;
48 CREATE SEQUENCE s1;
49 CREATE VIEW v1 AS SELECT s1.currval AS a;
50 SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME='v1';
51 VIEW_DEFINITION
52 select lastval(`test`.`s1`) AS `a`
53 SELECT * FROM v1;
54 a
55 NULL
56 SHOW CREATE VIEW v1;
57 View Create View character_set_client collation_connection
58 v1 CREATE VIEW "v1" AS select lastval("test"."s1") AS "a" latin1 latin1_swedish_ci
59 DROP VIEW v1;
60 DROP SEQUENCE s1;
61 #
62 # MDEV-12533 sql_mode=ORACLE: Add support for database qualified sequence names in NEXTVAL and CURRVAL
63 #
64 CREATE SEQUENCE s1;
65 SELECT test.s1.nextval;
66 test.s1.nextval
67 1
68 SELECT test.s1.currval;
69 test.s1.currval
70 1
71 SELECT .s1.nextval;
72 .s1.nextval
73 2
74 SELECT .s1.currval;
75 .s1.currval
76 2
77 DROP SEQUENCE s1;