diff options
author | Marko Mäkelä <marko.makela@mariadb.com> | 2023-02-16 11:41:18 +0200 |
---|---|---|
committer | Marko Mäkelä <marko.makela@mariadb.com> | 2023-02-16 11:41:18 +0200 |
commit | 1fd00998390a7487e42f5e29472e99354159c8bc (patch) | |
tree | 0d8d186d702341695c1ad12236b60b3d0a896354 /mysql-test/include | |
parent | fa5426ee469a8def705b6653cad4b9d21b4b2741 (diff) | |
parent | 345356b868d840554a8572876efc027d3ccd9842 (diff) | |
download | mariadb-git-1fd00998390a7487e42f5e29472e99354159c8bc.tar.gz |
Merge 10.10 into 10.11
Diffstat (limited to 'mysql-test/include')
-rw-r--r-- | mysql-test/include/ctype_casefolding.inc | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/include/ctype_casefolding.inc b/mysql-test/include/ctype_casefolding.inc new file mode 100644 index 00000000000..4ee402c95ad --- /dev/null +++ b/mysql-test/include/ctype_casefolding.inc @@ -0,0 +1,18 @@ +CREATE OR REPLACE TABLE case_folding AS SELECT 0 AS code, SPACE(32) AS c LIMIT 0; +SHOW CREATE TABLE case_folding; +# Uncode code points that have a variable length case mapping in utf8 +# (e.g. LOWER('2-byte-character') -> '3-byte-character' +INSERT INTO case_folding (code) VALUES +(0x23A), +(0x23E), +(0x23F), +(0x240), +(0x250), +(0x251), +(0x252), +(0x26B), +(0x271), +(0x27D); +UPDATE case_folding SET c=CHAR(code USING ucs2); +SELECT HEX(code), HEX(LOWER(c)), HEX(UPPER(c)), c FROM case_folding; +DROP TABLE case_folding; |