diff options
| author | Alexey Kopytov <Alexey.Kopytov@Sun.com> | 2010-06-02 14:01:26 +0400 |
|---|---|---|
| committer | Alexey Kopytov <Alexey.Kopytov@Sun.com> | 2010-06-02 14:01:26 +0400 |
| commit | e90af219d207e99911330e80a057d2c15becde5d (patch) | |
| tree | c68d67987c26b2d664b5cdab6edf6a8a37f06c58 /mysql-test/t/explain.test | |
| parent | fb4c786e2fd846044cda9fd3dc783e9bca624e40 (diff) | |
| parent | 40d4c07cd0b03eff55b0eef1c05fbee975bacc0b (diff) | |
| download | mariadb-git-e90af219d207e99911330e80a057d2c15becde5d.tar.gz | |
Manual merge from mysql-5.1-bugteam to mysql-trunk-merge.
conflicts:
conflict configure.in
Diffstat (limited to 'mysql-test/t/explain.test')
| -rw-r--r-- | mysql-test/t/explain.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/explain.test b/mysql-test/t/explain.test index 72406110de1..60108b3b038 100644 --- a/mysql-test/t/explain.test +++ b/mysql-test/t/explain.test @@ -223,4 +223,19 @@ EXPLAIN SELECT 1 FROM t1 WHERE a = (SELECT 1 FROM t1 t JOIN t2 WHERE b <= 1 AND DROP TABLE t1, t2; +--echo # +--echo # Bug #48573: difference of index selection between rpm binary and +--echo # .tar.gz, windows vs linux.. +--echo # + +CREATE TABLE t1(c1 INT, c2 INT, c4 INT, c5 INT, KEY(c2, c5), KEY(c2, c4, c5)); +INSERT INTO t1 VALUES(4, 1, 1, 1); +INSERT INTO t1 VALUES(3, 1, 1, 1); +INSERT INTO t1 VALUES(2, 1, 1, 1); +INSERT INTO t1 VALUES(1, 1, 1, 1); + +EXPLAIN SELECT c1 FROM t1 WHERE c2 = 1 AND c4 = 1 AND c5 = 1; + +DROP TABLE t1; + --echo End of 5.1 tests. |