diff options
| author | unknown <holyfoot@deer.(none)> | 2005-11-24 20:24:45 +0400 |
|---|---|---|
| committer | unknown <holyfoot@deer.(none)> | 2005-11-24 20:24:45 +0400 |
| commit | ae2dc30930108eff19259b59182fbaf867af677b (patch) | |
| tree | 064fae6c98f2a266d84e024fb4fa0303e4251c6a /mysql-test/r/alter_table.result | |
| parent | 97bfd41fe1382ff33a9fc458c0bd092342b217e5 (diff) | |
| download | mariadb-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/r/alter_table.result')
| -rw-r--r-- | mysql-test/r/alter_table.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result index 9b60a187d0b..f224a10c9bd 100644 --- a/mysql-test/r/alter_table.result +++ b/mysql-test/r/alter_table.result @@ -556,3 +556,9 @@ ERROR 3D000: No database selected alter table test.t1 rename test.t1; use test; drop table t1; +create table t1 (mycol int(10) not null); +alter table t1 alter column mycol set default 0; +desc t1; +Field Type Null Key Default Extra +mycol int(10) NO 0 +drop table t1; |