(ignite-3) branch ignite-21942 created (now 2730c3245f)

[am...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

amashenkov pushed a change to branch ignite-21942
in repository https://gitbox.apache.org/repos/asf/ignite-3.git


      at 2730c3245f wip.

This branch includes the following new commits:

     new 2730c3245f wip.

The 1 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails.  The revisions
listed as "add" were already present in the repository and have only
been added to this reference.

(ignite-3) 01/01: wip.

[am...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

amashenkov pushed a commit to branch ignite-21942
in repository https://gitbox.apache.org/repos/asf/ignite-3.git

commit 2730c3245f02ca90c60e9f886f7a14ef4c005b98
Author: amashenkov <an...@gmail.com>
AuthorDate: Mon May 13 18:52:20 2024 +0300

    wip.
---
 .../test_unicode_escapes_in_literals.test_ignored  | 47 ++++++++++++++++++++++
 1 file changed, 47 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..b80ea868f7
--- /dev/null
+++ b/modules/sql-engine/src/integrationTest/sql/types/string/test_unicode_escapes_in_literals.test_ignored
@@ -0,0 +1,47 @@
+# name: test/sql/types/string/test_unicode_escapes_on_literals.test
+# description: SQL feature F393 (Unicode escapes in literals)
+# group: [string]
+# Ignore: https://issues.apache.org/jira/browse/IGNITE-21962
+
+# 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\+000061'), (2, N'd\0061t\+000061')
+INSERT INTO t VALUES (3, 'd\x61t\x0061'), (4, 'd\u0061t\U00000061')
+
+# retrieve unicode strings again
+query IT
+SELECT * FROM t ORDER BY id
+----
+1 data
+2 data
+3 data
+4 data
+
+# substring on t
+query TT
+SELECT substring(s, 1, 2), substring(s, 3, 2) FROM t ORDER BY id
+----
+da ta
+da ta
+da ta
+da ta
+
+# length on t
+query I
+SELECT length(s) FROM t ORDER BY id
+----
+4
+4
+4
+4
+
+query I
+SELECT octet_length(s) FROM t ORDER BY id
+----
+4
+4
+4
+4