diff options
| author | Michael Widenius <monty@askmonty.org> | 2009-06-07 13:05:19 +0300 |
|---|---|---|
| committer | Michael Widenius <monty@askmonty.org> | 2009-06-07 13:05:19 +0300 |
| commit | 1f81aa5f5aa48001b4b986c0d45ea094c78f896d (patch) | |
| tree | 1a60ec234ebc5d5ca71def3def5e99041ece28ec /mysql-test/t/alter_table.test | |
| parent | 774ceff0c0856499671da626616d2ebc06bdd12d (diff) | |
| download | mariadb-git-1f81aa5f5aa48001b4b986c0d45ea094c78f896d.tar.gz | |
Added tests to cover more server code
Author: Stewart Smith
mysql-test/r/alter_table.result:
Testing of ALTER TABLE .. DROP DEFAULT
mysql-test/r/limit.result:
Testing of LIMIT ... OFFSET
mysql-test/t/alter_table.test:
Testing of ALTER TABLE .. DROP DEFAULT
mysql-test/t/limit.test:
Testing of LIMIT ... OFFSET
Diffstat (limited to 'mysql-test/t/alter_table.test')
| -rw-r--r-- | mysql-test/t/alter_table.test | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test index 2498d566f66..5233d64f44a 100644 --- a/mysql-test/t/alter_table.test +++ b/mysql-test/t/alter_table.test @@ -1000,4 +1000,22 @@ ALTER TABLE t1 MODIFY b ENUM('a', 'z', 'b', 'c') NOT NULL; SELECT * FROM t1; DROP TABLE t1; +# +# Test for ALTER column DROP DEFAULT +# + +SET @save_sql_mode=@@sql_mode; +SET sql_mode=strict_all_tables; + +CREATE TABLE t1 (a int NOT NULL default 42); +INSERT INTO t1 values (); +SELECT * FROM t1; +ALTER TABLE t1 ALTER COLUMN a DROP DEFAULT; +--error 1364 +INSERT INTO t1 values (); +INSERT INTO t1 (a) VALUES (11); +SELECT * FROM t1 ORDER BY a; +DROP TABLE t1; +SET @@sql_mode=@save_sql_mode; + --echo End of 5.1 tests |