Merge pull request #11788 from ydb-platform/mergelibs-241120-1113

Library import 241120-1113

1 files changed, 35 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/compute_range/pg_compare.sql b/yql/essentials/tests/sql/suites/compute_range/pg_compare.sql
new file mode 100644
index 0000000000..4bb2a3f805
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/compute_range/pg_compare.sql
@@ -0,0 +1,35 @@
+/* syntax version 1 */
+/* postgres can not */
+/* dq can not */
+/* dqfile can not */
+/* yt can not */
+pragma warning("disable", "4510");
+pragma warning("disable", "1108");
+
+-- a > 2
+select YQL::RangeComputeFor(
+    Struct<a:PgInt4,b:PgText>,
+    ($row) -> (FromPg(PgOp(">", $row.a, 2p)) ?? false),
+    AsTuple(AsAtom("a"))
+);
+
+-- a >= 2
+select YQL::RangeComputeFor(
+    Struct<a:PgInt4,b:PgText>,
+    ($row) -> (($row.a >= 2p) ?? false),
+    AsTuple(AsAtom("a"))
+);
+
+-- b < 2
+select YQL::RangeComputeFor(
+    Struct<a:PgInt4,b:PgText>,
+    ($row) -> (('2'p > $row.b) ?? false),
+    AsTuple(AsAtom("b"))
+);
+
+-- b <= 2
+select YQL::RangeComputeFor(
+    Struct<a:PgInt4,b:PgText>,
+    ($row) -> (FromPg(PgOp(">=", '2'p, $row.b)) ?? false),
+    AsTuple(AsAtom("b"))
+);