summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <monty@mysql.com>2004-12-02 14:47:14 +0200
committerunknown <monty@mysql.com>2004-12-02 14:47:14 +0200
commit35f9ecc1ceaf1ecdc989ec31f057603f5d51ed84 (patch)
treebdf1d0bf0dbc1d45ea86f192333d02aaa83df074 /mysql-test
parent646deed9f7b46e1ff27b4b37b85675c88deb3596 (diff)
parent93cf297fcb932aaaf1c006d7066ec453c9a907cb (diff)
downloadmariadb-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.result12
-rw-r--r--mysql-test/t/ps.test1
-rw-r--r--mysql-test/t/type_enum.test13
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;