| 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'; |