diff options
| author | unknown <bar@bar.mysql.r18.ru> | 2002-12-20 13:00:06 +0400 |
|---|---|---|
| committer | unknown <bar@bar.mysql.r18.ru> | 2002-12-20 13:00:06 +0400 |
| commit | 9d580589966927569d6b759a3c550d64caa77ddc (patch) | |
| tree | a93bc4bc3e2bb3d14d857ee284a7e6f8b226f4f2 /mysql-test | |
| parent | 774e9927b6f05bdec0277513242663d198929a85 (diff) | |
| download | mariadb-git-9d580589966927569d6b759a3c550d64caa77ddc.tar.gz | |
COUNT(DISTINCT) charset related test
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/t/ctype_many.test | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/mysql-test/t/ctype_many.test b/mysql-test/t/ctype_many.test index 7854bc38d6f..b02684b2fb8 100644 --- a/mysql-test/t/ctype_many.test +++ b/mysql-test/t/ctype_many.test @@ -137,9 +137,12 @@ SELECT CONVERT(koi8_ru_f USING utf8),MIN(comment),COUNT(*) FROM t1 GROUP BY 1; ALTER TABLE t1 ADD utf8_f CHAR(32) CHARACTER SET utf8 NOT NULL; UPDATE t1 SET utf8_f=CONVERT(koi8_ru_f USING utf8); - SELECT * FROM t1; +ALTER TABLE t1 ADD bin_f CHAR(32) BYTE NOT NULL; +UPDATE t1 SET bin_f=koi8_ru_f; +SELECT COUNT(DISTINCT bin_f),COUNT(DISTINCT koi8_ru_f),COUNT(DISTINCT utf8_f) FROM t1; + SELECT koi8_ru_f,MIN(comment) FROM t1 GROUP BY 1; SELECT utf8_f,MIN(comment) FROM t1 GROUP BY 1; SELECT DISTINCT koi8_ru_f FROM t1; |