EVOLUTION-MANAGER

Edit File: sequence.test

--source include/have_binlog_format_row.inc SET sql_mode=ORACLE; CREATE SEQUENCE s1; SHOW CREATE SEQUENCE s1; SELECT s1.currval; SELECT s1.nextval; SELECT s1.nextval; SELECT s1.nextval; EXPLAIN EXTENDED SELECT s1.nextval; SELECT nextval(s1); EXPLAIN EXTENDED SELECT s1.currval; SELECT lastval(s1); DROP SEQUENCE s1; CREATE SEQUENCE s1; CREATE VIEW v1 AS SELECT s1.nextval AS a; SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME='v1'; SELECT * FROM v1; SHOW CREATE VIEW v1; DROP VIEW v1; DROP SEQUENCE s1; CREATE SEQUENCE s1; CREATE VIEW v1 AS SELECT s1.currval AS a; SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME='v1'; SELECT * FROM v1; SHOW CREATE VIEW v1; DROP VIEW v1; DROP SEQUENCE s1; --echo # --echo # MDEV-12533 sql_mode=ORACLE: Add support for database qualified sequence names in NEXTVAL and CURRVAL --echo # CREATE SEQUENCE s1; SELECT test.s1.nextval; SELECT test.s1.currval; SELECT .s1.nextval; SELECT .s1.currval; DROP SEQUENCE s1;