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 <[email protected]> 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
