Debian Codegraph @

mysql-test/suite/test_services/t/test_table_access_utf8.test

raw
1 # Test the table_access_service
2
3 SET NAMES "utf8mb4";
4
5 INSTALL COMPONENT 'file://component_test_table_access';
6
7 # MATH
8
9 # Schema name
10 # \u2200 = for each
11 # \u220A = element
12 # \u2119 = P
13
14 # Table name
15 # \u2203 = there exists
16 # \u220A = element
17 # \u211A = Q (UTF8MB3)
18 # \u1D54A = S (UTF8MB4)
19
20 # Column name
21 # \u224E = equivalent
22 # \u22a4 = Truth
23
24 SELECT HEX('∀p∊ℙ');
25 SELECT HEX('∃s∊ℚ');
26 SELECT HEX('∃s∊𝕊');
27 SELECT HEX('s(p)≎⊤');
28
29 CREATE SCHEMA `∀p∊ℙ`;
30
31 show databases;
32
33 CREATE TABLE `∀p∊ℙ`.`∃s∊ℚ`(`s(p)≎⊤` VARCHAR(255) CHARACTER SET `utf8mb4`);
34
35 CREATE TABLE `∀p∊ℙ`.`∃s∊𝕊`(`s(p)≎⊤` VARCHAR(255) CHARACTER SET `utf8mb4`);
36
37 use `∀p∊ℙ`;
38
39 show tables;
40
41 show create table `∃s∊ℚ`;
42
43 show create table `∃s∊𝕊`;
44
45 SELECT * FROM `∀p∊ℙ`.`∃s∊ℚ`;
46
47 SELECT * FROM `∀p∊ℙ`.`∃s∊𝕊`;
48
49 SELECT test_table_access_driver("MATH-INSERT-UTF8MB3");
50
51 SELECT * FROM `∀p∊ℙ`.`∃s∊ℚ`;
52 TRUNCATE TABLE `∀p∊ℙ`.`∃s∊ℚ`;
53
54 SELECT * FROM `∀p∊ℙ`.`∃s∊ℚ`;
55
56 SELECT test_table_access_driver("MATH-INSERT-UTF8MB4");
57
58 SELECT * FROM `∀p∊ℙ`.`∃s∊𝕊`;
59 TRUNCATE TABLE `∀p∊ℙ`.`∃s∊𝕊`;
60
61 SELECT * FROM `∀p∊ℙ`.`∃s∊𝕊`;
62
63 --echo ##################
64 --echo # SERVER RESTART #
65 --echo ##################
66
67 --source include/restart_mysqld.inc
68
69 SELECT * FROM `∀p∊ℙ`.`∃s∊ℚ`;
70
71 SELECT * FROM `∀p∊ℙ`.`∃s∊𝕊`;
72
73 DROP TABLE `∀p∊ℙ`.`∃s∊ℚ`;
74 DROP TABLE `∀p∊ℙ`.`∃s∊𝕊`;
75 DROP SCHEMA `∀p∊ℙ`;
76
77 UNINSTALL COMPONENT 'file://component_test_table_access';
78