summaryrefslogtreecommitdiff
path: root/mysql-test/r/order_by.result
diff options
context:
space:
mode:
authorunknown <joreland@mysql.com>2005-01-27 10:31:45 +0100
committerunknown <joreland@mysql.com>2005-01-27 10:31:45 +0100
commit6603f7a88525b764f0efc3fcf9870f2e17217e7e (patch)
tree3e6cc3097cba033ba8a5e9772c8b9cd093f87b47 /mysql-test/r/order_by.result
parent9e4df02f3ab10ca0e9d11dc943c6479e211d88d0 (diff)
parentd2e2de1b595306276263cf1506e16fe7d0ba9d28 (diff)
downloadmariadb-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
Diffstat (limited to 'mysql-test/r/order_by.result')
-rw-r--r--mysql-test/r/order_by.result17
1 files changed, 17 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;