diff options
| author | unknown <ram@gw.mysql.r18.ru> | 2004-03-17 18:57:51 +0400 |
|---|---|---|
| committer | unknown <ram@gw.mysql.r18.ru> | 2004-03-17 18:57:51 +0400 |
| commit | ebb94b592c7d941d292544860759ce2d2ff08043 (patch) | |
| tree | c9779b81dd607a145d192081ac388bb9c159713c /mysql-test/t/subselect.test | |
| parent | afc4ce3de6deb90ff6f8b373fbe804bfa1a16809 (diff) | |
| parent | c6d993a1ff113b0c0243c3e0296092a2d3be66c6 (diff) | |
| download | mariadb-git-ebb94b592c7d941d292544860759ce2d2ff08043.tar.gz | |
merge
sql/item.h:
Auto merged
sql/item_func.cc:
Auto merged
sql/sql_select.cc:
Auto merged
mysql-test/r/subselect.result:
resolving conflicts
mysql-test/t/subselect.test:
resolving conflicts
Diffstat (limited to 'mysql-test/t/subselect.test')
| -rw-r--r-- | mysql-test/t/subselect.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 6d766f8f8f8..8da67f84c86 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -1067,6 +1067,14 @@ SET SQL_SELECT_LIMIT=default; drop table t1; # +# Bug #3118: subselect + order by +# + +CREATE TABLE t1 (a int, b int, INDEX (a)); +INSERT INTO t1 VALUES (1, 1), (1, 2), (1, 3); +SELECT * FROM t1 WHERE a = (SELECT MAX(a) FROM t1 WHERE a = 1) ORDER BY b; +DROP TABLE t1; + # Item_cond fix field # create table t1(val varchar(10)); |