Edit File: tc_drop_table.test
--disable_warnings DROP TABLE IF EXISTS t1,t2,t3; --enable_warnings CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); DROP TABLE t1 ; DROP TABLE t2,t3 ; CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); DROP TABLE IF EXISTS t1 ; DROP TABLE IF EXISTS t2,t3 ; CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); DROP TABLE t1 RESTRICT ; DROP TABLE t2,t3 RESTRICT ; CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); DROP TABLE IF EXISTS t1 RESTRICT ; DROP TABLE IF EXISTS t2,t3 RESTRICT ; CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); DROP TABLE t1 CASCADE ; DROP TABLE t2,t3 CASCADE ; CREATE TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); DROP TABLE IF EXISTS t1 CASCADE ; DROP TABLE IF EXISTS t2,t3 CASCADE ; CREATE TEMPORARY TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TEMPORARY TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TEMPORARY TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); DROP TEMPORARY TABLE t1 ; DROP TEMPORARY TABLE t2,t3 ; CREATE TEMPORARY TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TEMPORARY TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TEMPORARY TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); DROP TEMPORARY TABLE IF EXISTS t1 ; DROP TEMPORARY TABLE IF EXISTS t2,t3 ; CREATE TEMPORARY TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TEMPORARY TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TEMPORARY TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); DROP TEMPORARY TABLE t1 RESTRICT ; DROP TEMPORARY TABLE t2,t3 RESTRICT ; CREATE TEMPORARY TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TEMPORARY TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TEMPORARY TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); DROP TEMPORARY TABLE IF EXISTS t1 RESTRICT ; DROP TEMPORARY TABLE IF EXISTS t2,t3 RESTRICT ; CREATE TEMPORARY TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TEMPORARY TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TEMPORARY TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); DROP TEMPORARY TABLE t1 CASCADE ; DROP TEMPORARY TABLE t2,t3 CASCADE ; CREATE TEMPORARY TABLE t1(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TEMPORARY TABLE t2(c1 INTEGER NOT NULL PRIMARY KEY); CREATE TEMPORARY TABLE t3(c1 INTEGER NOT NULL PRIMARY KEY); DROP TEMPORARY TABLE IF EXISTS t1 CASCADE ; DROP TEMPORARY TABLE IF EXISTS t2,t3 CASCADE ;
Back to File Manager