Create 'main' test directory and move 't' and 'r' there

1 files changed, 0 insertions, 588 deletions

diff --git a/mysql-test/t/wl4435_generated.inc b/mysql-test/t/wl4435_generated.inc
deleted file mode 100644
index 5ea05a89402..00000000000
--- a/mysql-test/t/wl4435_generated.inc
+++ /dev/null
@@ -1,588 +0,0 @@
-
-###########################################################################
-
---echo
---echo TINYINT
---echo
-
-CREATE PROCEDURE p1(OUT v TINYINT)
-  SET v = 127;
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = 127;
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo SMALLINT
---echo
-
-CREATE PROCEDURE p1(OUT v SMALLINT)
-  SET v = 32767;
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = 32767;
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo MEDIUMINT
---echo
-
-CREATE PROCEDURE p1(OUT v MEDIUMINT)
-  SET v = 8388607;
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = 8388607;
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo INT
---echo
-
-CREATE PROCEDURE p1(OUT v INT)
-  SET v = 2147483647;
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = 2147483647;
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo BIGINT
---echo
-
-CREATE PROCEDURE p1(OUT v BIGINT)
-  SET v = 9223372036854775807;
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = 9223372036854775807;
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo BIT(11)
---echo
-
-CREATE PROCEDURE p1(OUT v BIT(11))
-  SET v = b'10100100101';
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = b'10100100101';
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo TIMESTAMP
---echo
-
-CREATE PROCEDURE p1(OUT v TIMESTAMP)
-  SET v = '2007-11-18 15:01:02';
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = '2007-11-18 15:01:02';
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo DATETIME
---echo
-
-CREATE PROCEDURE p1(OUT v DATETIME)
-  SET v = '1234-11-12 12:34:59';
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = '1234-11-12 12:34:59';
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo TIME
---echo
-
-CREATE PROCEDURE p1(OUT v TIME)
-  SET v = '123:45:01';
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = '123:45:01';
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo DATE
---echo
-
-CREATE PROCEDURE p1(OUT v DATE)
-  SET v = '1234-11-12';
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = '1234-11-12';
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo YEAR
---echo
-
-CREATE PROCEDURE p1(OUT v YEAR)
-  SET v = 2010;
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = 2010;
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo FLOAT(7, 4)
---echo
-
-CREATE PROCEDURE p1(OUT v FLOAT(7, 4))
-  SET v = 123.4567;
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a - 123.4567 < 0.00001;
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo DOUBLE(8, 5)
---echo
-
-CREATE PROCEDURE p1(OUT v DOUBLE(8, 5))
-  SET v = 123.45678;
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a - 123.45678 < 0.000001;
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo DECIMAL(9, 6)
---echo
-
-CREATE PROCEDURE p1(OUT v DECIMAL(9, 6))
-  SET v = 123.456789;
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = 123.456789;
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo CHAR(32)
---echo
-
-CREATE PROCEDURE p1(OUT v CHAR(32))
-  SET v = REPEAT('a', 16);
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = REPEAT('a', 16);
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo VARCHAR(32)
---echo
-
-CREATE PROCEDURE p1(OUT v VARCHAR(32))
-  SET v = REPEAT('b', 16);
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = REPEAT('b', 16);
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo TINYTEXT
---echo
-
-CREATE PROCEDURE p1(OUT v TINYTEXT)
-  SET v = REPEAT('c', 16);
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = REPEAT('c', 16);
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo TEXT
---echo
-
-CREATE PROCEDURE p1(OUT v TEXT)
-  SET v = REPEAT('d', 16);
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = REPEAT('d', 16);
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo MEDIUMTEXT
---echo
-
-CREATE PROCEDURE p1(OUT v MEDIUMTEXT)
-  SET v = REPEAT('e', 16);
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = REPEAT('e', 16);
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo LONGTEXT
---echo
-
-CREATE PROCEDURE p1(OUT v LONGTEXT)
-  SET v = REPEAT('f', 16);
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = REPEAT('f', 16);
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo BINARY(32)
---echo
-
-CREATE PROCEDURE p1(OUT v BINARY(32))
-  SET v = REPEAT('g', 32);
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = REPEAT('g', 32);
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo VARBINARY(32)
---echo
-
-CREATE PROCEDURE p1(OUT v VARBINARY(32))
-  SET v = REPEAT('h', 16);
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = REPEAT('h', 16);
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo TINYBLOB
---echo
-
-CREATE PROCEDURE p1(OUT v TINYBLOB)
-  SET v = REPEAT('i', 16);
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = REPEAT('i', 16);
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo BLOB
---echo
-
-CREATE PROCEDURE p1(OUT v BLOB)
-  SET v = REPEAT('j', 16);
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = REPEAT('j', 16);
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo MEDIUMBLOB
---echo
-
-CREATE PROCEDURE p1(OUT v MEDIUMBLOB)
-  SET v = REPEAT('k', 16);
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = REPEAT('k', 16);
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo LONGBLOB
---echo
-
-CREATE PROCEDURE p1(OUT v LONGBLOB)
-  SET v = REPEAT('l', 16);
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = REPEAT('l', 16);
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo SET('aaa', 'bbb')
---echo
-
-CREATE PROCEDURE p1(OUT v SET('aaa', 'bbb'))
-  SET v = 'aaa';
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = 'aaa';
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;
-
-###########################################################################
-
---echo
---echo ENUM('aaa', 'bbb')
---echo
-
-CREATE PROCEDURE p1(OUT v ENUM('aaa', 'bbb'))
-  SET v = 'aaa';
-
-PREPARE stmt1 FROM 'CALL p1(?)';
-EXECUTE stmt1 USING @a;
-
-CREATE TEMPORARY TABLE tmp1 AS SELECT @a AS c1;
-
-SHOW CREATE TABLE tmp1;
-
-SELECT @a, @a = 'aaa';
-
-DROP TEMPORARY TABLE tmp1;
-DROP PROCEDURE p1;