(ignite-3) branch main updated: IGNITE-21945 Sql. Cover SQL F855(Nested in ) (#3708)

[zs...@apache.org]

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 <st...@gmail.com>
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
+