diff options
| author | unknown <ramil@mysql.com> | 2005-07-15 15:50:57 +0500 |
|---|---|---|
| committer | unknown <ramil@mysql.com> | 2005-07-15 15:50:57 +0500 |
| commit | f4cd03d03f81e2cfd986e8b96af6f3b46b87ec45 (patch) | |
| tree | 0742313cc8d9c5aec62e73e6f01b1e2726905bc1 /mysql-test/t/strict.test | |
| parent | 908ff34e0464cf25295fc461602856da8d80ac02 (diff) | |
| download | mariadb-git-f4cd03d03f81e2cfd986e8b96af6f3b46b87ec45.tar.gz | |
a fix (bug #9881: ALTER TABLE gives wrong error message with sql-mode TRADITIONAL).
sql/field.cc:
a fix (bug #9881: ALTER TABLE gives wrong error message with sql-mode TRADITIONAL).
Don't set def if NO_DEFAULT_VALUE_FLAG is set.
Diffstat (limited to 'mysql-test/t/strict.test')
| -rw-r--r-- | mysql-test/t/strict.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/strict.test b/mysql-test/t/strict.test index 302acc9bef2..6ac88e4d629 100644 --- a/mysql-test/t/strict.test +++ b/mysql-test/t/strict.test @@ -1093,3 +1093,13 @@ set @@sql_mode='traditional'; create table t1(a varchar(65537)); --error 1074 create table t1(a varbinary(65537)); + +# +# Bug #9881: problem with altering table +# + +set @@sql_mode='traditional'; +create table t1(a int, b date not null); +alter table t1 modify a bigint unsigned not null; +show create table t1; +drop table t1; |