summaryrefslogtreecommitdiff
path: root/mysql-test/t/csv_alter_table.test
diff options
context:
space:
mode:
authorMichael Widenius <monty@askmonty.org>2012-04-04 00:16:38 +0300
committerMichael Widenius <monty@askmonty.org>2012-04-04 00:16:38 +0300
commitb04c4801b0529aebb39c8d9be95c123d2f3b7d46 (patch)
tree0a4f72935b5ac6816996172ae412b62327b4caf4 /mysql-test/t/csv_alter_table.test
parent34ed8f33795b639d21817003236ce0f6c069481d (diff)
downloadmariadb-git-b04c4801b0529aebb39c8d9be95c123d2f3b7d46.tar.gz
Created suites for heap, archive and csv.
Moved test from main suite to the new suites. Move tests from maria/t and maria/r to maria mysql-test/mysql-test-run.pl: Added support for the new suites
Diffstat (limited to 'mysql-test/t/csv_alter_table.test')
-rw-r--r--mysql-test/t/csv_alter_table.test56
1 files changed, 0 insertions, 56 deletions
diff --git a/mysql-test/t/csv_alter_table.test b/mysql-test/t/csv_alter_table.test
deleted file mode 100644
index 0093a1d10a7..00000000000
--- a/mysql-test/t/csv_alter_table.test
+++ /dev/null
@@ -1,56 +0,0 @@
-#-----------------------------------------------------------------------------
-# csv_alter_table.test - .test file for MySQL regression suite
-# Purpose: To test the behavior of the CSV engine
-# Bug#31473 resulted in strict enforcement of non-nullable
-# columns in CSV engine.
-# Tests code for Bug#33696 - CSV engine allows NULLable
-# Columns via ALTER TABLE statements
-#
-# Author pcrews
-# Last modified: 2008-01-06
-#-----------------------------------------------------------------------------
-
---source include/have_csv.inc
-
-#############################################################################
-# Testcase csv_alter_table.1: Positive test for ALTER table
-#
-#############################################################################
--- echo # ===== csv_alter_table.1 =====
--- disable_warnings
-DROP TABLE IF EXISTS t1;
--- enable_warnings
-
-CREATE TABLE t1 (a int NOT NULL) ENGINE = CSV;
-ALTER TABLE t1 ADD COLUMN b CHAR(5) NOT NULL;
-DESC t1;
-ALTER TABLE t1 DROP COLUMN b;
-DESC t1;
-ALTER TABLE t1 MODIFY a BIGINT NOT NULL;
-DESC t1;
-ALTER TABLE t1 CHANGE a a INT NOT NULL;
-DESC t1;
-
-DROP TABLE t1;
-
-#############################################################################
-# Testcase csv_alter_table.2: Negative test for ALTER table
-# These queries should not succeed / should throw errors
-#############################################################################
--- echo # ===== csv_alter_table.2 =====
--- disable_warnings
-DROP TABLE IF EXISTS t1;
--- enable_warnings
-
-CREATE TABLE t1 (a int NOT NULL) ENGINE = CSV;
---error ER_CHECK_NOT_IMPLEMENTED
-ALTER TABLE t1 ADD COLUMN b CHAR(5);
-DESC t1;
---error ER_CHECK_NOT_IMPLEMENTED
-ALTER TABLE t1 MODIFY a BIGINT;
-DESC t1;
---error ER_CHECK_NOT_IMPLEMENTED
-ALTER TABLE t1 CHANGE a a INT;
-DESC t1;
-
-DROP TABLE t1;