ygerzhedovich commented on code in PR #3780:
URL: https://github.com/apache/ignite-3/pull/3780#discussion_r1608024670
##########
modules/sql-engine/src/integrationTest/sql/order/test_offset.test:
##########
@@ -0,0 +1,36 @@
+# name: test/sql/order/test_offset.test
+# description: offset clause tests
+# feature: SQL F861 (Top-level <result offset clause> in <query expression>)
+# group: [order]
+
+statement ok
+PRAGMA enable_verification
+
+statement ok
+CREATE TABLE test (b INTEGER);
+
+statement ok
+INSERT INTO test VALUES (22), (2), (7);
+
+query I
+SELECT b FROM test ORDER BY b DESC OFFSET 1;
Review Comment:
should we also check syntax?
<result offset clause> ::=
OFFSET <offset row count> { ROW | ROWS }
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscr...@ignite.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
