diff options
| author | jimw@mysql.com <> | 2005-11-30 12:17:01 -0800 |
|---|---|---|
| committer | jimw@mysql.com <> | 2005-11-30 12:17:01 -0800 |
| commit | 0597c510c89b9b4aedac95d12bbccd1871ffd2d2 (patch) | |
| tree | 0842357ad78347a6ab54d08343e906c55f7b72b0 /mysql-test/r/alter_table.result | |
| parent | 5ad6b9b4f315da89a114b5d8398b8b98507b608e (diff) | |
| parent | 70c30c8d9323d10b5b60ea7819668c5d42a9118c (diff) | |
| download | mariadb-git-0597c510c89b9b4aedac95d12bbccd1871ffd2d2.tar.gz | |
Merge mysql.com:/home/jimw/my/mysql-5.0-clean
into mysql.com:/home/jimw/my/mysql-5.1-clean
Diffstat (limited to 'mysql-test/r/alter_table.result')
| -rw-r--r-- | mysql-test/r/alter_table.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result index e3e9dab78bd..85d3bd0b2ad 100644 --- a/mysql-test/r/alter_table.result +++ b/mysql-test/r/alter_table.result @@ -555,6 +555,11 @@ alter table test.t1 rename t1; ERROR 3D000: No database selected alter table test.t1 rename test.t1; use test; +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; create table t1 (v varchar(32)); insert into t1 values ('def'),('abc'),('hij'),('3r4f'); |