# Test distinction between SQL character count (codepoints) and Java charactter count.
---
- CreateTable: tu (id INT PRIMARY KEY NOT NULL, s1 VARCHAR(1), s2 VARCHAR(2))
---
- Statement: "INSERT INTO tu(id,s1) VALUES(1, '\U00010001')"
- warnings_count: 0
---
- Statement: "INSERT INTO tu(id,s2) VALUES(2, '\U00010001\U00010002')"
- warnings_count: 0
---
- Statement: "INSERT INTO tu(id,s1) VALUES(3, '\U00010001\U00010002')"
- warnings: [[22001, "WARN:  String data right-truncated: '\U00010001\U00010002' truncated to '\U00010001'"]]
---
- Statement: SELECT s2, CHAR_LENGTH(s2), OCTET_LENGTH(s2) FROM tu WHERE id = 2
- output: [["\U00010001\U00010002", 2, 8]]
---
- Statement: "SELECT SUBSTRING('\U00010001\U00010002\U00010003\U00010004', 2)"
- output: [["\U00010002\U00010003\U00010004"]]
---
- Statement: "SELECT SUBSTRING('\U00010001\U00010002\U00010003\U00010004', 2, 2)"
- output: [["\U00010002\U00010003"]]
---
- Statement: "SELECT SUBSTRING('\U00010001\U00010002\U00010003\U00010004', -2)"
- output: [["\U00010003\U00010004"]]
...
Add a YAML test for that.
Add a YAML test for that.
