Debian Codegraph @

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

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