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

Library import 241120-1113

1 files changed, 36 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/compute_range/pg_startswith.sql b/yql/essentials/tests/sql/suites/compute_range/pg_startswith.sql
new file mode 100644
index 0000000000..0ed99c65c0
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/compute_range/pg_startswith.sql
@@ -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"))
+);