diff options
author | Oleksandr Byelkin <sanja@mariadb.com> | 2017-05-05 16:43:25 +0200 |
---|---|---|
committer | Oleksandr Byelkin <sanja@mariadb.com> | 2017-05-05 16:43:25 +0200 |
commit | cf31db184e6bc16a5fef1b1b45aca73253944250 (patch) | |
tree | 5d4fb56bb0f86c3b258c871cfb840e68b1aead7c | |
parent | a3e0a952f71418e942c8232132f24b3ee3df6070 (diff) | |
download | mariadb-git-cf31db184e6bc16a5fef1b1b45aca73253944250.tar.gz |
Fix test to be windows file system tollerant.
-rw-r--r-- | mysql-test/r/query_cache_innodb.result | 28 | ||||
-rw-r--r-- | mysql-test/t/query_cache_innodb.test | 24 |
2 files changed, 26 insertions, 26 deletions
diff --git a/mysql-test/r/query_cache_innodb.result b/mysql-test/r/query_cache_innodb.result index 2f439948108..643a065612f 100644 --- a/mysql-test/r/query_cache_innodb.result +++ b/mysql-test/r/query_cache_innodb.result @@ -30,32 +30,32 @@ select * from t2; t2id id drop table t2; drop table t1; -create database `testdatabase$Ї`; -use `testdatabase$Ї`; -create table `t1$Ї` ( id int unsigned auto_increment, primary key(id) ) engine=innodb; -create table `t2$Ї` ( t2id int unsigned, id int unsigned, primary key(t2id, id), foreign key (`id`) references `t1$Ї`(`id`) on delete cascade ) engine=innodb; -insert into `t1$Ї` values (1); -insert into `t2$Ї`values (1,1); -select * from `t2$Ї`; +create database `testdatabase$ї`; +use `testdatabase$ї`; +create table `t1$ї` ( id int unsigned auto_increment, primary key(id) ) engine=innodb; +create table `t2$ї` ( t2id int unsigned, id int unsigned, primary key(t2id, id), foreign key (`id`) references `t1$ї`(`id`) on delete cascade ) engine=innodb; +insert into `t1$ї` values (1); +insert into `t2$ї`values (1,1); +select * from `t2$ї`; t2id id 1 1 show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 1 -delete from `t1$Ї`; +delete from `t1$ї`; show status like "Qcache_queries_in_cache"; Variable_name Value Qcache_queries_in_cache 0 -select * from `t2$Ї`; +select * from `t2$ї`; t2id id -optimize table `t2$Ї`; +optimize table `t2$ї`; Table Op Msg_type Msg_text -testdatabase$Ї.t2$Ї optimize note Table does not support optimize, doing recreate + analyze instead -testdatabase$Ї.t2$Ї optimize status OK -select * from `t2$Ї`; +testdatabase$ї.t2$ї optimize note Table does not support optimize, doing recreate + analyze instead +testdatabase$ї.t2$ї optimize status OK +select * from `t2$ї`; t2id id use test; -drop database `testdatabase$Ї`; +drop database `testdatabase$ї`; SET NAMES default; create database `#mysql50#-`; use `#mysql50#-`; diff --git a/mysql-test/t/query_cache_innodb.test b/mysql-test/t/query_cache_innodb.test index fe49836c29d..ba62ec36c16 100644 --- a/mysql-test/t/query_cache_innodb.test +++ b/mysql-test/t/query_cache_innodb.test @@ -30,26 +30,26 @@ select * from t2; drop table t2; drop table t1; -create database `testdatabase$Ї`; -use `testdatabase$Ї`; -create table `t1$Ї` ( id int unsigned auto_increment, primary key(id) ) engine=innodb; +create database `testdatabase$ї`; +use `testdatabase$ї`; +create table `t1$ї` ( id int unsigned auto_increment, primary key(id) ) engine=innodb; -create table `t2$Ї` ( t2id int unsigned, id int unsigned, primary key(t2id, id), foreign key (`id`) references `t1$Ї`(`id`) on delete cascade ) engine=innodb; +create table `t2$ї` ( t2id int unsigned, id int unsigned, primary key(t2id, id), foreign key (`id`) references `t1$ї`(`id`) on delete cascade ) engine=innodb; -insert into `t1$Ї` values (1); -insert into `t2$Ї`values (1,1); -select * from `t2$Ї`; +insert into `t1$ї` values (1); +insert into `t2$ї`values (1,1); +select * from `t2$ї`; show status like "Qcache_queries_in_cache"; -delete from `t1$Ї`; +delete from `t1$ї`; show status like "Qcache_queries_in_cache"; -select * from `t2$Ї`; +select * from `t2$ї`; -optimize table `t2$Ї`; -select * from `t2$Ї`; +optimize table `t2$ї`; +select * from `t2$ї`; use test; -drop database `testdatabase$Ї`; +drop database `testdatabase$ї`; SET NAMES default; create database `#mysql50#-`; |