Debian Codegraph @

mysql-test/suite/galera/t/galera_unicode_identifiers.test

raw
1 #
2 # Test non-ascii table, column and index names
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 --let $wsrep_sync_wait_orig = (SELECT @@wsrep_sync_wait)
9 SET GLOBAL wsrep_sync_wait = 15;
10
11 --connection node_2
12 SET NAMES utf8mb4;
13 SET GLOBAL wsrep_sync_wait = 15;
14
15 --connection node_1
16 SET NAMES utf8mb4;
17
18 --let $innodb_num_tables_orig = `SELECT COUNT(*) FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES`
19
20 # Spaces in identifiers
21
22 CREATE DATABASE `database with space`;
23 USE `database with space`;
24 CREATE TABLE `table with space` (
25 `column with space` INTEGER AUTO_INCREMENT PRIMARY KEY,
26 `second column with space` INTEGER,
27 UNIQUE `index name with space` (`second column with space`)
28 ) engine=innodb;
29 INSERT INTO `table with space` VALUES (1, 1);
30
31 # Unicode identifiers
32
33 CREATE DATABASE `база`;
34 USE `база`;
35 CREATE TABLE `таблица` (
36 `първа_колона` INTEGER PRIMARY KEY,
37 `втора_колона` INTEGER,
38 UNIQUE `индекс` (`втора_колона`)
39 ) engine=innodb;
40
41 INSERT INTO `таблица` VALUES (1, 1);
42
43 # Without a PK
44
45 CREATE DATABASE `втора база`;
46 USE `втора база`;
47 CREATE TABLE `втора таблица` (
48 `първа колона` INTEGER,
49 `втора колона` INTEGER,
50 KEY `първи индекс` (`първа колона`)
51 ) engine=innodb;
52
53 INSERT INTO `втора таблица` VALUES (1, 1);
54
55 --connection node_2
56 # Wait until 3 above tables with databases are created also to this node
57 --let $wait_condition = SELECT COUNT(*) = $innodb_num_tables_orig + 3 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES;
58 --source include/wait_condition.inc
59
60 USE `database with space`;
61 SELECT `second column with space` FROM `table with space`;
62
63 USE `база`;
64 SELECT * FROM `таблица`;
65
66 USE `втора база`;
67 SELECT `втора колона` FROM `втора таблица`;
68
69 --eval SET GLOBAL wsrep_sync_wait = $wsrep_sync_wait_orig
70
71 --connection node_1
72 DROP TABLE `database with space`.`table with space`;
73 DROP TABLE `база`.`таблица`;
74 DROP TABLE `втора база`.`втора таблица`;
75
76 DROP DATABASE `database with space`;
77 DROP DATABASE `база`;
78 DROP DATABASE `втора база`;
79 --eval SET GLOBAL wsrep_sync_wait = $wsrep_sync_wait_orig