summaryrefslogtreecommitdiff
path: root/mysql-test/t/alter_table.test
diff options
context:
space:
mode:
authorunknown <holyfoot@deer.(none)>2005-11-24 20:24:45 +0400
committerunknown <holyfoot@deer.(none)>2005-11-24 20:24:45 +0400
commitae2dc30930108eff19259b59182fbaf867af677b (patch)
tree064fae6c98f2a266d84e024fb4fa0303e4251c6a /mysql-test/t/alter_table.test
parent97bfd41fe1382ff33a9fc458c0bd092342b217e5 (diff)
downloadmariadb-git-ae2dc30930108eff19259b59182fbaf867af677b.tar.gz
Fix for bug #14693 (ALTER COLUMN SET DEFAULT has no effect)
mysql-test/r/alter_table.result: test result mysql-test/t/alter_table.test: test case sql/sql_table.cc: we should set the flag with the ALTER requirements
Diffstat (limited to 'mysql-test/t/alter_table.test')
-rw-r--r--mysql-test/t/alter_table.test9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test
index bae94656125..3878b55da11 100644
--- a/mysql-test/t/alter_table.test
+++ b/mysql-test/t/alter_table.test
@@ -401,3 +401,12 @@ use test;
drop table t1;
# End of 4.1 tests
+
+#
+# Bug #14693 (ALTER SET DEFAULT doesn't work)
+#
+
+create table t1 (mycol int(10) not null);
+alter table t1 alter column mycol set default 0;
+desc t1;
+drop table t1;