summaryrefslogtreecommitdiff
path: root/mysql-test/include
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2023-02-10 13:03:01 +0200
committerMarko Mäkelä <marko.makela@mariadb.com>2023-02-10 13:03:01 +0200
commit6aec87544c675751141100d6efe3a2d943cb528f (patch)
tree8771c79790e0b58df172e48214a5077899a9b312 /mysql-test/include
parent70a515df434a57709eaf69f451c22739d7908ba4 (diff)
parentc41c79650aa2ef8eaf3f887b94db8cc7478eadd1 (diff)
downloadmariadb-git-6aec87544c675751141100d6efe3a2d943cb528f.tar.gz
Merge 10.5 into 10.6
Diffstat (limited to 'mysql-test/include')
-rw-r--r--mysql-test/include/ctype_casefolding.inc18
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;