ygerzhedovich commented on code in PR #3660: URL: https://github.com/apache/ignite-3/pull/3660#discussion_r1580898660
########## modules/sql-engine/src/integrationTest/sql/types/char/test_char_character_set.test: ########## @@ -0,0 +1,60 @@ +# name: test/sql/types/char/test_char_character_set.test +# description: E021-01 Character string types. CHARACTER SET tests +# group: [char] + +# Incorrect name of charset +statement error +CREATE TABLE t_incorrect(C1 CHAR CHARACTER SET UTF_8); + +statement ok +CREATE TABLE t_default (c1 CHAR, c2 CHARACTER, c3 CHAR(3), c4 CHARACTER(3)); + +statement ok +CREATE TABLE t_utf8 (c1 CHAR CHARACTER SET UTF8, c2 CHARACTER CHARACTER SET UTF8, c3 CHAR(3) CHARACTER SET UTF8, c4 CHARACTER(3) CHARACTER SET UTF8); + +statement ok +CREATE TABLE t_latin1 (c1 CHAR CHARACTER SET LATIN1, c2 CHARACTER CHARACTER SET LATIN1, c3 CHAR(3) CHARACTER SET LATIN1, c4 CHARACTER(3) CHARACTER SET LATIN1); + +statement ok +INSERT INTO t_default VALUES('1', '2', '🍞', 'Ю44'); + +statement ok +INSERT INTO t_utf8 VALUES('1', '2', '🍞', 'Ю44'); + +# Must fail due to use symbol doesn't belong to charset of column +skipif ignite3 +# https://issues.apache.org/jira/browse/IGNITE-22100 +statement error +INSERT INTO t_latin1 VALUES('1', '2', '🍞', 'Ю44'); Review Comment: Do you have an example in real life when it will be useful? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: notifications-unsubscr...@ignite.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org