Debian Codegraph @

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

raw
1 SET sql_mode=ORACLE;
2
3 --echo #
4 --echo # MDEV-15975 PL/SQL parser does not understand historical queries
5 --echo #
6
7 CREATE TABLE t1 (a INT) WITH SYSTEM VERSIONING;
8 INSERT INTO t1 VALUES (10);
9 DELETE FROM t1;
10 INSERT INTO t1 VALUES (20);
11 SELECT * FROM t1 FOR SYSTEM_TIME ALL;
12 SELECT * FROM t1 FOR SYSTEM_TIME AS OF (NOW()+INTERVAL 10 YEAR);
13 DROP TABLE t1;
14
15 --echo #
16 --echo # MDEV-17959 Assertion `opt_bootstrap || mysql_parse_status || thd->lex->select_stack_top == 0' failed in parse_sql upon DELETE HISTORY under ORACLE mode
17 --echo #
18
19 SET SQL_MODE= ORACLE;
20 CREATE TABLE t1 (a INT);
21 --error ER_VERS_NOT_VERSIONED
22 DELETE HISTORY FROM t1;
23 DROP TABLE t1;