diff options
author | unknown <monty@mysql.com> | 2004-12-02 14:47:14 +0200 |
---|---|---|
committer | unknown <monty@mysql.com> | 2004-12-02 14:47:14 +0200 |
commit | 35f9ecc1ceaf1ecdc989ec31f057603f5d51ed84 (patch) | |
tree | bdf1d0bf0dbc1d45ea86f192333d02aaa83df074 /mysql-test | |
parent | 646deed9f7b46e1ff27b4b37b85675c88deb3596 (diff) | |
parent | 93cf297fcb932aaaf1c006d7066ec453c9a907cb (diff) | |
download | mariadb-git-35f9ecc1ceaf1ecdc989ec31f057603f5d51ed84.tar.gz |
merged on pull
mysql-test/r/rpl_start_stop_slave.result:
Auto merged
sql/field.cc:
Auto merged
sql/item_cmpfunc.cc:
Auto merged
sql/mysql_priv.h:
Auto merged
sql/sql_table.cc:
Auto merged
mysql-test/r/type_enum.result:
merged test cases
mysql-test/t/type_enum.test:
merged test cases
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/type_enum.result | 12 | ||||
-rw-r--r-- | mysql-test/t/ps.test | 1 | ||||
-rw-r--r-- | mysql-test/t/type_enum.test | 13 |
3 files changed, 25 insertions, 1 deletions
diff --git a/mysql-test/r/type_enum.result b/mysql-test/r/type_enum.result index 15f16e4d02d..2ccf32367fb 100644 --- a/mysql-test/r/type_enum.result +++ b/mysql-test/r/type_enum.result @@ -1725,3 +1725,15 @@ a ö ü drop table t1; +create table t1 (a enum ('Y','N') CHARACTER SET utf8 COLLATE utf8_bin); +insert into t1 values ('Y'); +alter table t1 add b set ('Y','N') CHARACTER SET utf8 COLLATE utf8_bin; +alter table t1 add c enum ('Y','N') CHARACTER SET utf8 COLLATE utf8_bin; +select * from t1; +Catalog Database Table Table_alias Column Column_alias Name Type Length Max length Is_null Flags Decimals Charsetnr +def test t1 t1 a a 254 3 1 Y 384 0 8 +def test t1 t1 b b 254 9 0 Y 2176 0 8 +def test t1 t1 c c 254 3 0 Y 384 0 8 +a b c +Y NULL NULL +drop table t1; diff --git a/mysql-test/t/ps.test b/mysql-test/t/ps.test index 7fe88ad0ddc..51d1fd065cf 100644 --- a/mysql-test/t/ps.test +++ b/mysql-test/t/ps.test @@ -471,4 +471,3 @@ execute stmt using @var, @var, @var; set @var=null; select @var is null, @var is not null, @var; execute stmt using @var, @var, @var; - diff --git a/mysql-test/t/type_enum.test b/mysql-test/t/type_enum.test index 2c4bbdf8355..3a5b12b91e4 100644 --- a/mysql-test/t/type_enum.test +++ b/mysql-test/t/type_enum.test @@ -100,3 +100,16 @@ set names latin1; show create table t1; select a from t1 order by a; drop table t1; + +# +# Test bug where enum fields where extended for each ALTER TABLE +# + +create table t1 (a enum ('Y','N') CHARACTER SET utf8 COLLATE utf8_bin); +insert into t1 values ('Y'); +alter table t1 add b set ('Y','N') CHARACTER SET utf8 COLLATE utf8_bin; +alter table t1 add c enum ('Y','N') CHARACTER SET utf8 COLLATE utf8_bin; +--enable_metadata +select * from t1; +--disable metadata +drop table t1; |