diff options
| author | unknown <svoj@june.mysql.com> | 2007-04-18 16:35:22 +0500 |
|---|---|---|
| committer | unknown <svoj@june.mysql.com> | 2007-04-18 16:35:22 +0500 |
| commit | 78035fb5d5cd237fa545493b644e70118d73bfff (patch) | |
| tree | 85b7e68bc1525abfdcc7fa3744e12b6f140d2e5c /mysql-test/t/merge.test | |
| parent | 1ff64d6e1111247536ecc004505ca376df8a58b6 (diff) | |
| parent | de15763cfbf230c7fa1333b84a707abc25cde2d6 (diff) | |
| download | mariadb-git-78035fb5d5cd237fa545493b644e70118d73bfff.tar.gz | |
Merge mysql.com:/home/svoj/devel/mysql/BUG24342/mysql-5.0-engines
into mysql.com:/home/svoj/devel/mysql/BUG24342/mysql-5.1-engines
mysql-test/r/merge.result:
Auto merged
mysql-test/t/merge.test:
Auto merged
storage/myisam/mi_rkey.c:
Auto merged
storage/myisam/myisamdef.h:
Auto merged
storage/myisammrg/myrg_rkey.c:
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 e150b6b3a9a..69e0b19ebf0 100644 --- a/mysql-test/t/merge.test +++ b/mysql-test/t/merge.test @@ -451,6 +451,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 # |