Intermediate changes

commit_hash:e6cca97ec9c9627f1ba82a11abf454518fc90972

1 files changed, 36 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/compute_range/pg_startswith.yql b/yql/essentials/tests/sql/suites/compute_range/pg_startswith.yql
new file mode 100644
index 00000000000..0ed99c65c08
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/compute_range/pg_startswith.yql
@@ -0,0 +1,36 @@
+/* syntax version 1 */
+/* postgres can not */
+/* dq can not */
+/* dqfile can not */
+/* yt can not */
+pragma warning("disable", "4510");
+pragma warning("disable", "1108");
+
+-- like 'aaaa'
+select YQL::RangeComputeFor(
+	    Struct<a:PgInt4,b:PgText>,
+	    ($row) -> (StartsWith(FromPg($row.b), 'aaaa') ?? false),
+	    AsTuple(AsAtom("b"))
+);
+
+-- not like 'aaaa'
+select YQL::RangeComputeFor(
+	    Struct<a:PgInt4,b:PgText>,
+	    ($row) -> (not (StartsWith(FromPg($row.b), 'aaaa') ?? true)),
+	    AsTuple(AsAtom("b"))
+);
+
+
+-- like <invalid utf8>
+select YQL::RangeComputeFor(
+	    Struct<a:PgInt4,b:PgText>,
+	    ($row) -> (StartsWith(FromPg($row.b), 'a\xf5') ?? false),
+	    AsTuple(AsAtom("b"))
+);
+
+-- not like <invalid utf8>
+select YQL::RangeComputeFor(
+	    Struct<a:PgInt4,b:PgText>,
+	    ($row) -> (not (StartsWith(FromPg($row.b), 'a\xf5') ?? true)),
+	    AsTuple(AsAtom("b"))
+);