mirror of
https://github.com/MariaDB/server.git
synced 2025-02-04 21:02:17 +01:00
16 lines
366 B
Text
16 lines
366 B
Text
SET sql_mode=ORACLE;
|
|
|
|
--echo #
|
|
--echo # MDEV-10588 sql_mode=ORACLE: TRUNCATE TABLE t1 [ {DROP|REUSE} STORAGE ]
|
|
--echo #
|
|
|
|
CREATE TABLE t1 (a INT);
|
|
TRUNCATE TABLE t1 REUSE STORAGE;
|
|
TRUNCATE TABLE t1 DROP STORAGE;
|
|
DROP TABLE t1;
|
|
|
|
# REUSE is actually a reserved word in Oracle.
|
|
# But we don't reserve it for MDEV-10588
|
|
|
|
CREATE TABLE reuse (reuse INT);
|
|
DROP TABLE reuse;
|