diff options
| author | Igor Babaev <igor@askmonty.org> | 2013-11-13 14:43:09 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2013-11-13 14:43:09 -0800 |
| commit | ae40c7207760ea6c829a6bdbbabc1e19941f1240 (patch) | |
| tree | b16e5d9d06b4ccbd74d686715dcbe082f694f5ea /mysql-test/r | |
| parent | 441192bfb0e620b49cb58eaef96132151531fc54 (diff) | |
| download | mariadb-git-ae40c7207760ea6c829a6bdbbabc1e19941f1240.tar.gz | |
Fixed bug mdev-5091.
The function SELECT_LEX::update_used_tables should process all
ORDER BY lists in any subselect of a union.
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/union.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/union.result b/mysql-test/r/union.result index 13941d3f84d..05dab9e2874 100644 --- a/mysql-test/r/union.result +++ b/mysql-test/r/union.result @@ -1724,3 +1724,18 @@ foo 1 deallocate prepare stmt1; End of 5.1 tests +# +# mdev-5091: Asseirtion failure for UNION with ORDER BY +# in one of selects +# +CREATE TABLE t1 (i int, c char(1)) ENGINE=MyISAM; +INSERT INTO t1 VALUES (6,'b'); +CREATE VIEW v1 AS SELECT * FROM t1; +( SELECT i FROM v1 GROUP BY i ORDER BY CONCAT( c, c ) LIMIT 1 ) +UNION +( SELECT i FROM t1 ); +i +6 +DROP VIEW v1; +DROP TABLE t1; +End of 5.3 tests |