diff options
| author | Martin Hansson <martin.hansson@sun.com> | 2010-09-13 14:46:55 +0200 |
|---|---|---|
| committer | Martin Hansson <martin.hansson@sun.com> | 2010-09-13 14:46:55 +0200 |
| commit | dae7b019190b46cfaadf7b4c8d47fe05f6cfb457 (patch) | |
| tree | 8d28ea9bf655589ae7db9761c7f4f643017871ce /mysql-test/t/order_by.test | |
| parent | 657ba74a0443576e55d27936ec68e2bea3fdf254 (diff) | |
| parent | 3beeb5d045241afb9d3733fba8dd4ec6e5b9dd86 (diff) | |
| download | mariadb-git-dae7b019190b46cfaadf7b4c8d47fe05f6cfb457.tar.gz | |
Merge of fix for Bug#50394.
Diffstat (limited to 'mysql-test/t/order_by.test')
| -rw-r--r-- | mysql-test/t/order_by.test | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/t/order_by.test b/mysql-test/t/order_by.test index 2ea169d950d..7869a01a84d 100644 --- a/mysql-test/t/order_by.test +++ b/mysql-test/t/order_by.test @@ -1467,6 +1467,31 @@ SELECT * FROM t1 FORCE INDEX FOR JOIN (a), t2 WHERE t1.a < 2 ORDER BY t1.a; DROP TABLE t1, t2; +--echo # +--echo # Bug #50394: Regression in EXPLAIN with index scan, LIMIT, GROUP BY and +--echo # ORDER BY computed col +--echo # +CREATE TABLE t1 ( a INT NOT NULL, b INT NOT NULL, KEY( a, b ) ); + +INSERT INTO t1 VALUES (1, 1), (2, 2), (3, 3), (4, 4), (5, 5); +INSERT INTO t1 SELECT a + 5, b + 5 FROM t1; + +CREATE TABLE t2( a INT PRIMARY KEY, b INT ); + +INSERT INTO t2 VALUES (1, 1), (2, 2), (3, 3), (4, 4), (5, 5); +INSERT INTO t2 SELECT a + 5, b + 5 FROM t2; + +EXPLAIN +SELECT count(*) AS c, t1.a +FROM t1 JOIN t2 ON t1.b = t2.a +WHERE t2.b = 1 +GROUP BY t1.a +ORDER by c +LIMIT 2; + +DROP TABLE t1, t2; + + --echo End of 5.1 tests |