YQL-19206 Move contrib/ydb/library/yql/tests/sql/suites -> yql/essentials/tests/sql/suites

commit_hash:d0ef1f92b09c94db7c2408f946d2a4c62b603f00

1 files changed, 80 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/compute_range/startswith.sql b/yql/essentials/tests/sql/suites/compute_range/startswith.sql
new file mode 100644
index 0000000000..b5c31298cb
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/compute_range/startswith.sql
@@ -0,0 +1,80 @@
+/* syntax version 1 */
+/* postgres can not */
+/* dq can not */
+/* dqfile can not */
+/* yt can not */
+pragma warning("disable", "4510");
+
+-- string/string
+select YQL::RangeComputeFor(
+  Struct<x:String>,
+  ($row) -> (StartsWith($row.x, 'foo')),
+  AsTuple(AsAtom("x"))
+);
+
+
+select YQL::RangeComputeFor(
+  Struct<x:String>,
+  ($row) -> (not StartsWith($row.x, 'foo')),
+  AsTuple(AsAtom("x"))
+);
+
+
+select YQL::RangeComputeFor(
+  Struct<x:String>,
+  ($row) -> (StartsWith($row.x, '\xff\xff')),
+  AsTuple(AsAtom("x"))
+);
+
+select YQL::RangeComputeFor(
+  Struct<x:String>,
+  ($row) -> (not StartsWith($row.x, '\xff\xff')),
+  AsTuple(AsAtom("x"))
+);
+
+-- optional string/string
+select YQL::RangeComputeFor(
+  Struct<x:String?>,
+  ($row) -> ((not StartsWith($row.x, 'foo')) ?? false),
+  AsTuple(AsAtom("x"))
+);
+
+-- optional string/optional string
+select YQL::RangeComputeFor(
+  Struct<x:String?>,
+  ($row) -> (StartsWith($row.x, if(1 > 2, 'void')) ?? false),
+  AsTuple(AsAtom("x"))
+);
+
+--utf8/string
+select YQL::RangeComputeFor(
+  Struct<x:Utf8>,
+  ($row) -> (StartsWith($row.x, 'тест')),
+  AsTuple(AsAtom("x"))
+);
+
+select YQL::RangeComputeFor(
+  Struct<x:Utf8>,
+  ($row) -> (StartsWith($row.x, 'тест\xf5')),
+  AsTuple(AsAtom("x"))
+);
+
+--optional utf8/utf8
+select YQL::RangeComputeFor(
+  Struct<x:Utf8?>,
+  ($row) -> ((not StartsWith($row.x, 'тест'u)) ?? false),
+  AsTuple(AsAtom("x"))
+);
+
+select YQL::RangeComputeFor(
+  Struct<x:Utf8?>,
+  ($row) -> (StartsWith($row.x, '\xf4\x8f\xbf\xbf'u) ?? false),
+  AsTuple(AsAtom("x"))
+);
+
+-- optional utf8/string
+select YQL::RangeComputeFor(
+  Struct<x:Utf8?>,
+  ($row) -> ((not StartsWith($row.x, 'тест\xf5')) ?? false),
+  AsTuple(AsAtom("x"))
+);