diff options
author | Michael Widenius <monty@askmonty.org> | 2012-04-04 00:16:38 +0300 |
---|---|---|
committer | Michael Widenius <monty@askmonty.org> | 2012-04-04 00:16:38 +0300 |
commit | b04c4801b0529aebb39c8d9be95c123d2f3b7d46 (patch) | |
tree | 0a4f72935b5ac6816996172ae412b62327b4caf4 /mysql-test/t/csv_alter_table.test | |
parent | 34ed8f33795b639d21817003236ce0f6c069481d (diff) | |
download | mariadb-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.test | 56 |
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; |