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 a14e5b8c28dc31fa5c00c9b217fd2b83f1002c93 Author: amashenkov <[email protected]> AuthorDate: Mon May 13 18:52:20 2024 +0300 wip. --- .../test_unicode_escapes_in_literals.test_ignored | 62 ++++++++++++++++++++++ 1 file changed, 62 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..e39c87117f --- /dev/null +++ b/modules/sql-engine/src/integrationTest/sql/types/string/test_unicode_escapes_in_literals.test_ignored @@ -0,0 +1,62 @@ +# 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-21942 + +# 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'), (3, 'd\\x61t\\x0061'), (4, 'd\\u0061t\\U00000061') + +# retrieve unicode strings again +query IT +SELECT * FROM t ORDER BY id +---- +1 data +2 d\\0061t\+000061 +3 data +4 data + +query IT +SELECT * FROM t WHERE s = U&'d\\0061t\\+000061' ORDER BY id +---- +1 data +2 d\0061t\+000061 +3 data +4 data + +query IT +SELECT * FROM t WHERE s = 'd\\x61t\\x0061' ORDER BY id +---- +1 data +2 d\0061t\+000061 +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 +d\ 00 +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
