summaryrefslogtreecommitdiff
path: root/mysql-test/t/derived.test
diff options
context:
space:
mode:
authorunknown <Sinisa@sinisa.nasamreza.org>2003-03-10 17:07:39 +0200
committerunknown <Sinisa@sinisa.nasamreza.org>2003-03-10 17:07:39 +0200
commit462a72b80246c09304f140675f6dd80cb3a20826 (patch)
tree258ecd8f90af30d0aa5acf0f2264106c66ef24e0 /mysql-test/t/derived.test
parent249788280aa26cb1566652330744bb678caff854 (diff)
downloadmariadb-git-462a72b80246c09304f140675f6dd80cb3a20826.tar.gz
Adding tests for the fixed ORDER BY 0 bug
Diffstat (limited to 'mysql-test/t/derived.test')
-rw-r--r--mysql-test/t/derived.test2
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/derived.test b/mysql-test/t/derived.test
index 1dbdd6e0ae8..8b8d9e4d1a2 100644
--- a/mysql-test/t/derived.test
+++ b/mysql-test/t/derived.test
@@ -62,3 +62,5 @@ SELECT * FROM (SELECT 1 UNION SELECT a) b;
SELECT 1 as a FROM (SELECT a UNION SELECT 1) b;
--error 1054
SELECT 1 as a FROM (SELECT 1 UNION SELECT a) b;
+--error 1054
+select 1 from (select 2) a order by 0;