This is an automated email from the ASF dual-hosted git repository.
amashenkov pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/ignite-3.git
The following commit(s) were added to refs/heads/main by this push:
new dc741be3b6 IGNITE-21942 Cover SQL F393(Unicode escapes in literals)
feature by tests (#3746)
dc741be3b6 is described below
commit dc741be3b6bd9136d00a38a4999c0644e567f570
Author: Andrew V. Mashenkov <amashen...@users.noreply.github.com>
AuthorDate: Wed May 15 23:09:13 2024 +0300
IGNITE-21942 Cover SQL F393(Unicode escapes in literals) feature by tests
(#3746)
---
.../test_unicode_escapes_in_literals.test_ignored | 51 ++++++++++++++++++++++
1 file changed, 51 insertions(+)
diff --git
a/modules/sql-engine/src/integrationTest/sql/types/string/test_unicode_escapes_in_literals.test_ignored
b/modules/sql-engine/src/integrationTest/sql/types/string/test_unicode_escapes_in_literals.test_ignored
new file mode 100644
index 0000000000..86c2af763f
--- /dev/null
+++
b/modules/sql-engine/src/integrationTest/sql/types/string/test_unicode_escapes_in_literals.test_ignored
@@ -0,0 +1,51 @@
+# name: test/sql/types/string/test_unicode_escapes_in_literals.test
+# description: SQL feature F393 (Unicode escapes in literals)
+# group: [string]
+# Ignore: https://issues.apache.org/jira/browse/IGNITE-22221
+
+# insert unicode strings into the database
+statement ok
+CREATE TABLE t(id INTEGER, s VARCHAR);
+
+statement ok
+INSERT INTO t VALUES (1, U&'d\0061t\0061'), (2, U&'d\+000061t\+000061')
+
+# retrieve unicode strings again
+query IT
+SELECT * FROM t ORDER BY id
+----
+1 data
+2 data
+
+query IT
+SELECT * FROM t WHERE s = U&'d\0061t\0061' ORDER BY id
+----
+1 data
+2 data
+
+query IT
+SELECT * FROM t WHERE s = U&'d\+000061t\+000061' ORDER BY id
+----
+1 data
+2 data
+
+
+# substring on t
+query TT
+SELECT substring(s, 1, 2), substring(s, 3, 2) FROM t ORDER BY id
+----
+da ta
+da ta
+
+# length on t
+query I
+SELECT length(s) FROM t ORDER BY id
+----
+4
+4
+
+query I
+SELECT octet_length(s) FROM t ORDER BY id
+----
+4
+4
