diff options
| author | unknown <joreland@mysql.com> | 2005-01-27 10:31:45 +0100 |
|---|---|---|
| committer | unknown <joreland@mysql.com> | 2005-01-27 10:31:45 +0100 |
| commit | 6603f7a88525b764f0efc3fcf9870f2e17217e7e (patch) | |
| tree | 3e6cc3097cba033ba8a5e9772c8b9cd093f87b47 | |
| parent | 9e4df02f3ab10ca0e9d11dc943c6479e211d88d0 (diff) | |
| parent | d2e2de1b595306276263cf1506e16fe7d0ba9d28 (diff) | |
| download | mariadb-git-6603f7a88525b764f0efc3fcf9870f2e17217e7e.tar.gz | |
Merge mysql.com:/home/jonas/src/mysql-4.1
into mysql.com:/home/jonas/src/mysql-5.0
mysql-test/r/order_by.result:
Auto merged
mysql-test/t/order_by.test:
Auto merged
| -rw-r--r-- | mysql-test/r/order_by.result | 17 | ||||
| -rw-r--r-- | mysql-test/t/order_by.test | 10 |
2 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/r/order_by.result b/mysql-test/r/order_by.result index 5674fbb9177..3474da93d75 100644 --- a/mysql-test/r/order_by.result +++ b/mysql-test/r/order_by.result @@ -778,3 +778,20 @@ sid wnid 39560 01019090000 37994 01019090000 drop table t1; +CREATE TABLE t1 (a int); +INSERT INTO t1 VALUES (2), (1), (1), (2), (1); +SELECT a FROM t1 ORDER BY a; +a +1 +1 +1 +2 +2 +(SELECT a FROM t1) ORDER BY a; +a +1 +1 +1 +2 +2 +DROP TABLE t1; diff --git a/mysql-test/t/order_by.test b/mysql-test/t/order_by.test index 02e49f9750d..9608b7900ee 100644 --- a/mysql-test/t/order_by.test +++ b/mysql-test/t/order_by.test @@ -539,3 +539,13 @@ explain select * from t1 where wnid like '0101%' order by wnid; select * from t1 where wnid like '0101%' order by wnid; drop table t1; + +# +# Bug #7672 - a wrong result for a select query in braces followed by order by +# + +CREATE TABLE t1 (a int); +INSERT INTO t1 VALUES (2), (1), (1), (2), (1); +SELECT a FROM t1 ORDER BY a; +(SELECT a FROM t1) ORDER BY a; +DROP TABLE t1; |