From cf31db184e6bc16a5fef1b1b45aca73253944250 Mon Sep 17 00:00:00 2001 From: Oleksandr Byelkin Date: Fri, 5 May 2017 16:43:25 +0200 Subject: Fix test to be windows file system tollerant. --- mysql-test/r/query_cache_innodb.result | 28 ++++++++++++++-------------- 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#-`; -- cgit v1.2.1