polardbxengine/mysql-test/suite/engines/funcs/r/tc_drop_table.result

62 lines
2.8 KiB
Plaintext

DROP TABLE IF EXISTS t1,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 ;
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 ;