Debian Codegraph @

mysql-test/suite/test_services/r/test_table_access_utf8.result

raw
1 SET NAMES "utf8mb4";
2 INSTALL COMPONENT 'file://component_test_table_access';
3 SELECT HEX('∀p∊ℙ');
4 HEX('∀p∊ℙ')
5 E2888070E2888AE28499
6 SELECT HEX('∃s∊ℚ');
7 HEX('∃s∊ℚ')
8 E2888373E2888AE2849A
9 SELECT HEX('∃s∊𝕊');
10 HEX('∃s∊?')
11 E2888373E2888AF09D958A
12 SELECT HEX('s(p)≎⊤');
13 HEX('s(p)≎⊤')
14 73287029E2898EE28AA4
15 CREATE SCHEMA `∀p∊ℙ`;
16 show databases;
17 Database
18 information_schema
19 mtr
20 mysql
21 performance_schema
22 sys
23 test
24 ∀p∊ℙ
25 CREATE TABLE `∀p∊ℙ`.`∃s∊ℚ`(`s(p)≎⊤` VARCHAR(255) CHARACTER SET `utf8mb4`);
26 CREATE TABLE `∀p∊ℙ`.`∃s∊𝕊`(`s(p)≎⊤` VARCHAR(255) CHARACTER SET `utf8mb4`);
27 Warnings:
28 Warning 1300 Cannot convert string '\xE2\x88\x83s\xE2\x88...' from utf8mb4 to utf8mb3
29 use `∀p∊ℙ`;
30 show tables;
31 Tables_in_∀p∊ℙ
32 ∃s∊?
33 ∃s∊ℚ
34 show create table `∃s∊ℚ`;
35 Table Create Table
36 ∃s∊ℚ CREATE TABLE `∃s∊ℚ` (
37 `s(p)≎⊤` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL
38 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
39 show create table `∃s∊𝕊`;
40 Table Create Table
41 ∃s∊? CREATE TABLE `∃s∊?` (
42 `s(p)≎⊤` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL
43 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
44 Warnings:
45 Warning 1300 Cannot convert string '\xE2\x88\x83s\xE2\x88...' from utf8mb4 to utf8mb3
46 SELECT * FROM `∀p∊ℙ`.`∃s∊ℚ`;
47 s(p)≎⊤
48 SELECT * FROM `∀p∊ℙ`.`∃s∊𝕊`;
49 s(p)≎⊤
50 Warnings:
51 Warning 1300 Cannot convert string '\xE2\x88\x83s\xE2\x88...' from utf8mb4 to utf8mb3
52 SELECT test_table_access_driver("MATH-INSERT-UTF8MB3");
53 test_table_access_driver("MATH-INSERT-UTF8MB3")
54 OK
55 SELECT * FROM `∀p∊ℙ`.`∃s∊ℚ`;
56 s(p)≎⊤
57 ∀p∊ℙ ∃s∊ℚ s(p)≎⊤
58 TRUNCATE TABLE `∀p∊ℙ`.`∃s∊ℚ`;
59 SELECT * FROM `∀p∊ℙ`.`∃s∊ℚ`;
60 s(p)≎⊤
61 SELECT test_table_access_driver("MATH-INSERT-UTF8MB4");
62 test_table_access_driver("MATH-INSERT-UTF8MB4")
63 OK
64 SELECT * FROM `∀p∊ℙ`.`∃s∊𝕊`;
65 s(p)≎⊤
66 ∀p∊ℙ ∃s∊𝕊 s(p)≎⊤
67 Warnings:
68 Warning 1300 Cannot convert string '\xE2\x88\x83s\xE2\x88...' from utf8mb4 to utf8mb3
69 TRUNCATE TABLE `∀p∊ℙ`.`∃s∊𝕊`;
70 Warnings:
71 Warning 1300 Cannot convert string '\xE2\x88\x83s\xE2\x88...' from utf8mb4 to utf8mb3
72 SELECT * FROM `∀p∊ℙ`.`∃s∊𝕊`;
73 s(p)≎⊤
74 Warnings:
75 Warning 1300 Cannot convert string '\xE2\x88\x83s\xE2\x88...' from utf8mb4 to utf8mb3
76 ##################
77 # SERVER RESTART #
78 ##################
79 # restart
80 SELECT * FROM `∀p∊ℙ`.`∃s∊ℚ`;
81 s(p)≎⊤
82 ∀p∊ℙ ∃s∊ℚ s(p)≎⊤
83 SELECT * FROM `∀p∊ℙ`.`∃s∊𝕊`;
84 s(p)≎⊤
85 ∀p∊ℙ ∃s∊𝕊 s(p)≎⊤
86 Warnings:
87 Warning 1300 Cannot convert string '\xE2\x88\x83s\xE2\x88...' from utf8mb4 to utf8mb3
88 DROP TABLE `∀p∊ℙ`.`∃s∊ℚ`;
89 DROP TABLE `∀p∊ℙ`.`∃s∊𝕊`;
90 Warnings:
91 Warning 1300 Cannot convert string '\xE2\x88\x83s\xE2\x88...' from utf8mb4 to utf8mb3
92 DROP SCHEMA `∀p∊ℙ`;
93 UNINSTALL COMPONENT 'file://component_test_table_access';