This is an automated email from the ASF dual-hosted git repository.
zstan pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/ignite-3.git
The following commit(s) were added to refs/heads/main by this push:
new 865c02bf0b IGNITE-21945 Sql. Cover SQL F855(Nested <order by clause>
in <query expression>) (#3708)
865c02bf0b is described below
commit 865c02bf0b19aa47579a0536732a6938bfebc4ec
Author: Evgeniy Stanilovskiy <[email protected]>
AuthorDate: Wed May 8 10:42:54 2024 +0300
IGNITE-21945 Sql. Cover SQL F855(Nested <order by clause> in <query
expression>) (#3708)
---
.../sql/order/test_nested_order_by.test | 43 ++++++++++++++++++++++
1 file changed, 43 insertions(+)
diff --git
a/modules/sql-engine/src/integrationTest/sql/order/test_nested_order_by.test
b/modules/sql-engine/src/integrationTest/sql/order/test_nested_order_by.test
new file mode 100644
index 0000000000..48b45c3cb8
--- /dev/null
+++ b/modules/sql-engine/src/integrationTest/sql/order/test_nested_order_by.test
@@ -0,0 +1,43 @@
+# name: test/sql/order/test_nested_order_by.test
+# description: F855 (Nested <order by clause> in <query expression>)
+# group: [order]
+
+statement ok
+CREATE TABLE t(c char, i int);
+
+statement ok
+INSERT INTO t SELECT x, 0 - x FROM table(system_range(0, 3));
+
+statement ok
+INSERT INTO t VALUES(NULL, NULL);
+
+query II rowsort
+SELECT * FROM (SELECT * FROM t ORDER BY i NULLS LAST) AS temp ORDER BY c;
+----
+0 0
+1 -1
+2 -2
+3 -3
+NULL NULL
+
+query II rowsort
+SELECT * FROM (SELECT * FROM t ORDER BY i NULLS FIRST) AS temp ORDER BY c;
+----
+NULL NULL
+0 0
+1 -1
+2 -2
+3 -3
+
+query II rowsort
+SELECT * FROM (SELECT * FROM t ORDER BY i NULLS FIRST LIMIT 2 OFFSET 1) AS
temp ORDER BY c;
+----
+2 -2
+3 -3
+
+query II rowsort
+SELECT * FROM (SELECT * FROM (VALUES ROW(1, 100), ROW(2, 200)) as temp(x, y)
ORDER BY x) ORDER BY y;
+----
+1 100
+2 200
+
