diff options
author | Nirbhay Choubey <nirbhay@mariadb.com> | 2014-09-30 18:06:15 -0400 |
---|---|---|
committer | Nirbhay Choubey <nirbhay@mariadb.com> | 2014-09-30 18:06:15 -0400 |
commit | 9a57de86beda0032a6dd9f804822e2651eb869bf (patch) | |
tree | 7c1b645c0f4e4392c3c47da46f4c5d08b0c28a86 /mysql-test/suite/galera/r/galera_unicode_identifiers.result | |
parent | c916085e271cd049537b1e07b36cd060c44750bd (diff) | |
download | mariadb-git-9a57de86beda0032a6dd9f804822e2651eb869bf.tar.gz |
bzr merge -r4123..4144 codership/5.6
Diffstat (limited to 'mysql-test/suite/galera/r/galera_unicode_identifiers.result')
-rw-r--r-- | mysql-test/suite/galera/r/galera_unicode_identifiers.result | 46 |
1 files changed, 46 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_unicode_identifiers.result b/mysql-test/suite/galera/r/galera_unicode_identifiers.result new file mode 100644 index 00000000000..cb348f8509f --- /dev/null +++ b/mysql-test/suite/galera/r/galera_unicode_identifiers.result @@ -0,0 +1,46 @@ +SET GLOBAL wsrep_sync_wait = 7; +SET GLOBAL wsrep_sync_wait = 7; +CREATE DATABASE `database with space`; +USE `database with space`; +CREATE TABLE `table with space` ( +`column with space` INTEGER AUTO_INCREMENT PRIMARY KEY, +`second column with space` INTEGER, +UNIQUE `index name with space` (`second column with space`) +) ENGINE=INNODB; +INSERT INTO `table with space` VALUES (DEFAULT, 1); +CREATE DATABASE `база`; +USE `база`; +CREATE TABLE `таблица` ( +`първа_колона` INTEGER PRIMARY KEY, +`втора_колона` INTEGER, +UNIQUE `индекс` (`втора_колона`) +) ENGINE=INNODB; +INSERT INTO `таблица` VALUES (1, 1); +CREATE DATABASE `втора база`; +USE `втора база`; +CREATE TABLE `втора таблица` ( +`първа колона` INTEGER, +`втора колона` INTEGER, +KEY `първи индекс` (`първа колона`) +) ENGINE=INNODB; +INSERT INTO `втора таблица` VALUES (1, 1); +USE `database with space`; +SELECT * FROM `table with space`; +column with space second column with space +1 1 +USE `база`; +SELECT * FROM `таблица`; +първа_колона втора_колона +1 1 +USE `втора база`; +SELECT * FROM `втора таблица`; +първа колона втора колона +1 1 +SET GLOBAL wsrep_sync_wait = (SELECT @@wsrep_sync_wait); +DROP TABLE `database with space`.`table with space`; +DROP TABLE `база`.`таблица`; +DROP TABLE `втора база`.`втора таблица`; +DROP DATABASE `database with space`; +DROP DATABASE `база`; +DROP DATABASE `втора база`; +SET GLOBAL wsrep_sync_wait = (SELECT @@wsrep_sync_wait); |