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; |