diff options
| author | unknown <svoj@mysql.com/june.mysql.com> | 2007-04-18 16:22:23 +0500 |
|---|---|---|
| committer | unknown <svoj@mysql.com/june.mysql.com> | 2007-04-18 16:22:23 +0500 |
| commit | de15763cfbf230c7fa1333b84a707abc25cde2d6 (patch) | |
| tree | daafee84641b790ed6fcfe3aee1e1ea1fbf2b453 /mysql-test/t/merge.test | |
| parent | b8250c712653e50acde5485b096429d55290f1ff (diff) | |
| parent | 150646b62df10d6e36e0e249ab5f58ff615505ce (diff) | |
| download | mariadb-git-de15763cfbf230c7fa1333b84a707abc25cde2d6.tar.gz | |
Merge mysql.com:/home/svoj/devel/mysql/BUG24342/mysql-4.1-engines
into mysql.com:/home/svoj/devel/mysql/BUG24342/mysql-5.0-engines
myisam/mi_rkey.c:
Auto merged
myisam/myisamdef.h:
Auto merged
myisammrg/myrg_rkey.c:
Auto merged
mysql-test/t/merge.test:
Auto merged
mysql-test/r/merge.result:
SCCS merged
Diffstat (limited to 'mysql-test/t/merge.test')
| -rw-r--r-- | mysql-test/t/merge.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/merge.test b/mysql-test/t/merge.test index 490010c0a42..b3944416adc 100644 --- a/mysql-test/t/merge.test +++ b/mysql-test/t/merge.test @@ -447,6 +447,19 @@ ALTER TABLE m1 ENGINE=MERGE UNION=(t1); SELECT * FROM m1; DROP TABLE t1, m1; +# +# BUG#24342 - Incorrect results with query over MERGE table +# +CREATE TABLE t1 (a VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_german2_ci, + b INT, INDEX(a,b)); +CREATE TABLE t2 LIKE t1; +CREATE TABLE t3 LIKE t1; +ALTER TABLE t3 ENGINE=MERGE UNION=(t1,t2); +INSERT INTO t1 VALUES ('ss',1); +INSERT INTO t2 VALUES ('ss',2),(0xDF,2); +SELECT COUNT(*) FROM t3 WHERE a=0xDF AND b=2; +DROP TABLE t1,t2,t3; + # End of 4.1 tests # |