diff options
| author | svoj@june.mysql.com <> | 2007-04-18 16:35:22 +0500 |
|---|---|---|
| committer | svoj@june.mysql.com <> | 2007-04-18 16:35:22 +0500 |
| commit | 05a8c545df0461468c83e7fbe5b3fa609faa666a (patch) | |
| tree | 85b7e68bc1525abfdcc7fa3744e12b6f140d2e5c /mysql-test/t/merge.test | |
| parent | ef2c0228da3c420ce6a4dfe9d48268de375a1bdd (diff) | |
| parent | 2d64de7d7e03c42faaac7802ee4fcf9c12f6f1c2 (diff) | |
| download | mariadb-git-05a8c545df0461468c83e7fbe5b3fa609faa666a.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
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 # |