diff options
| author | unknown <bar@bar.mysql.r18.ru> | 2003-08-05 11:03:05 +0500 |
|---|---|---|
| committer | unknown <bar@bar.mysql.r18.ru> | 2003-08-05 11:03:05 +0500 |
| commit | fc8b138544c6edb34a1bc26b8cc8b69630bb81b5 (patch) | |
| tree | 4cc952660aa92af2c01890655eecf3562e2bd7b5 /mysql-test/r | |
| parent | 691b7584fb3bc42b70fe470ba5fa812d28190141 (diff) | |
| download | mariadb-git-fc8b138544c6edb34a1bc26b8cc8b69630bb81b5.tar.gz | |
Fix:
CREATE TABLE t1 (s1 CHAR(5) CHARACTER SET latin1 COLLATE latin1_german2_ci);
INSERT INTO t1 VALUES ('Ü');
INSERT INTO t1 VALUES ('ue');
SELECT DISTINCT s1 FROM t1;
The above returned two rows in error.
Now it returns one row, in latin1_german2_ci: Ü == ue
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/ctype_latin1_de.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/ctype_latin1_de.result b/mysql-test/r/ctype_latin1_de.result index e0cb7008899..418bd65e0dc 100644 --- a/mysql-test/r/ctype_latin1_de.result +++ b/mysql-test/r/ctype_latin1_de.result @@ -264,3 +264,18 @@ select * from t1 where word like CAST(0xDF as CHAR); word word2 ß ß drop table t1; +CREATE TABLE t1 ( +s1 CHAR(5) CHARACTER SET latin1 COLLATE latin1_german2_ci +); +INSERT INTO t1 VALUES ('Ü'); +INSERT INTO t1 VALUES ('ue'); +SELECT DISTINCT s1 FROM t1; +s1 +Ü +SELECT s1,COUNT(*) FROM t1 GROUP BY s1; +s1 COUNT(*) +Ü 2 +SELECT COUNT(DISTINCT s1) FROM t1; +COUNT(DISTINCT s1) +1 +DROP TABLE t1; |