From 3bb7d3eebf5678d67933d7ae7cf1b9da8c70dbff Mon Sep 17 00:00:00 2001 From: Alexander Barkov Date: Mon, 9 Nov 2009 14:53:49 +0400 Subject: Backporting test for Bug#158 ENUM and SET types does not accept valid cp1251 character --- mysql-test/r/ctype_cp1251.result | 11 +++++++++++ mysql-test/t/ctype_cp1251.test | 10 ++++++++++ 2 files changed, 21 insertions(+) diff --git a/mysql-test/r/ctype_cp1251.result b/mysql-test/r/ctype_cp1251.result index 47797af3cbe..bf0bc07c50e 100644 --- a/mysql-test/r/ctype_cp1251.result +++ b/mysql-test/r/ctype_cp1251.result @@ -70,3 +70,14 @@ we_ivo NULL we_martin NULL we_toshko NULL drop table t1; +CREATE TABLE t1 ( +e1 enum('ябълка'), +e2 enum('мляко') +) ENGINE=MYISAM character set cp1251; +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `e1` enum('ябълка') DEFAULT NULL, + `e2` enum('мляко') DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=cp1251 +DROP TABLE t1; diff --git a/mysql-test/t/ctype_cp1251.test b/mysql-test/t/ctype_cp1251.test index 463a9cea4bc..b6a1cfc3f98 100644 --- a/mysql-test/t/ctype_cp1251.test +++ b/mysql-test/t/ctype_cp1251.test @@ -47,4 +47,14 @@ insert into t1 (a) values ('air'), select * from t1 where a like 'we_%'; drop table t1; +# +# Bug#158 ENUM and SET types does not accept valid cp1251 character +# +CREATE TABLE t1 ( + e1 enum('ябълка'), + e2 enum('мляко') +) ENGINE=MYISAM character set cp1251; +SHOW CREATE TABLE t1; +DROP TABLE t1; + # End of 4.1 tests -- cgit v1.2.1