Debian Codegraph @

mysql-test/suite/galera/r/galera_unicode_identifiers.result

raw
1 connection node_2;
2 connection node_1;
3 SET GLOBAL wsrep_sync_wait = 15;
4 connection node_2;
5 SET NAMES utf8mb4;
6 SET GLOBAL wsrep_sync_wait = 15;
7 connection node_1;
8 SET NAMES utf8mb4;
9 CREATE DATABASE `database with space`;
10 USE `database with space`;
11 CREATE TABLE `table with space` (
12 `column with space` INTEGER AUTO_INCREMENT PRIMARY KEY,
13 `second column with space` INTEGER,
14 UNIQUE `index name with space` (`second column with space`)
15 ) engine=innodb;
16 INSERT INTO `table with space` VALUES (1, 1);
17 CREATE DATABASE `база`;
18 USE `база`;
19 CREATE TABLE `таблица` (
20 `първа_колона` INTEGER PRIMARY KEY,
21 `втора_колона` INTEGER,
22 UNIQUE `индекс` (`втора_колона`)
23 ) engine=innodb;
24 INSERT INTO `таблица` VALUES (1, 1);
25 CREATE DATABASE `втора база`;
26 USE `втора база`;
27 CREATE TABLE `втора таблица` (
28 `първа колона` INTEGER,
29 `втора колона` INTEGER,
30 KEY `първи индекс` (`първа колона`)
31 ) engine=innodb;
32 INSERT INTO `втора таблица` VALUES (1, 1);
33 connection node_2;
34 USE `database with space`;
35 SELECT `second column with space` FROM `table with space`;
36 second column with space
37 1
38 USE `база`;
39 SELECT * FROM `таблица`;
40 първа_колона втора_колона
41 1 1
42 USE `втора база`;
43 SELECT `втора колона` FROM `втора таблица`;
44 втора колона
45 1
46 SET GLOBAL wsrep_sync_wait = (SELECT @@wsrep_sync_wait);
47 connection node_1;
48 DROP TABLE `database with space`.`table with space`;
49 DROP TABLE `база`.`таблица`;
50 DROP TABLE `втора база`.`втора таблица`;
51 DROP DATABASE `database with space`;
52 DROP DATABASE `база`;
53 DROP DATABASE `втора база`;
54 SET GLOBAL wsrep_sync_wait = (SELECT @@wsrep_sync_wait);