65 lines
2.9 KiB
Plaintext
65 lines
2.9 KiB
Plaintext
--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 ;
|
|
|