Debian Codegraph @

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

raw
1 SET sql_mode=ORACLE;
2
3 --echo #
4 --echo # MDEV-10588 sql_mode=ORACLE: TRUNCATE TABLE t1 [ {DROP|REUSE} STORAGE ]
5 --echo #
6
7 CREATE TABLE t1 (a INT);
8 TRUNCATE TABLE t1 REUSE STORAGE;
9 TRUNCATE TABLE t1 DROP STORAGE;
10 DROP TABLE t1;
11
12 # REUSE is actually a reserved word in Oracle.
13 # But we don't reserve it for MDEV-10588
14
15 CREATE TABLE reuse (reuse INT);
16 DROP TABLE reuse;