mariadb/mysql-test/suite/engines/funcs/r/tc_drop_table.result
Omer BarNir c92b9b7315 Test suites for engine testing, moved from test-extra so will be available
for general use.


mysql-test/Makefile.am:
  Adding directories of additional test suites
mysql-test/mysql-stress-test.pl:
  Adding check for additional errors checking during test run
2010-03-17 23:42:07 -07:00

61 lines
2.8 KiB
Text

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 ;