diff options
| author | unknown <kaa@polly.local> | 2007-05-31 14:58:22 +0400 |
|---|---|---|
| committer | unknown <kaa@polly.local> | 2007-05-31 14:58:22 +0400 |
| commit | d92bc733f8554dfe815cc0ceec5bbe1600453507 (patch) | |
| tree | cbaa5936229d6f86c780c22524967302461b6162 /mysql-test/r/heap_hash.result | |
| parent | e5353e2f48a75e20df595b7e14e00ee1b74f44c0 (diff) | |
| parent | f18a10c6c1ced93a83ead017aa10398fa17c9a63 (diff) | |
| download | mariadb-git-d92bc733f8554dfe815cc0ceec5bbe1600453507.tar.gz | |
Merge polly.local:/home/kaa/src/maint/bug27643/my50-bug27643
into polly.local:/home/kaa/src/maint/bug27643/my51-bug27643
mysql-test/r/ctype_ucs2_def.result:
Auto merged
mysql-test/r/heap_hash.result:
Auto merged
mysql-test/t/ctype_ucs2_def.test:
Auto merged
mysql-test/t/heap_hash.test:
Auto merged
sql/sql_select.cc:
Auto merged
strings/ctype-bin.c:
Auto merged
strings/ctype-mb.c:
Auto merged
strings/ctype-ucs2.c:
Auto merged
Diffstat (limited to 'mysql-test/r/heap_hash.result')
| -rw-r--r-- | mysql-test/r/heap_hash.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/heap_hash.result b/mysql-test/r/heap_hash.result index 41f00fd2ad8..c7a620002c4 100644 --- a/mysql-test/r/heap_hash.result +++ b/mysql-test/r/heap_hash.result @@ -366,3 +366,19 @@ explain select a from t1 where a in (1,3); id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 range a a 5 NULL 4 Using where drop table t1; +End of 4.1 tests +CREATE TABLE t1(col1 VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, +col2 VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, +UNIQUE KEY key1 USING HASH (col1, col2)) ENGINE=MEMORY; +INSERT INTO t1 VALUES('A', 'A'); +INSERT INTO t1 VALUES('A ', 'A '); +ERROR 23000: Duplicate entry 'A -A ' for key 1 +DROP TABLE t1; +CREATE TABLE t1(col1 VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, +col2 VARCHAR(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, +UNIQUE KEY key1 USING HASH (col1, col2)) ENGINE=MEMORY; +INSERT INTO t1 VALUES('A', 'A'); +INSERT INTO t1 VALUES('A ', 'A '); +ERROR 23000: Duplicate entry 'A -A ' for key 1 +DROP TABLE t1; +End of 5.0 tests |