diff options
Diffstat (limited to 'mysql-test/suite/jp/t/jp_union_ujis.test')
-rw-r--r-- | mysql-test/suite/jp/t/jp_union_ujis.test | 36 |
1 files changed, 5 insertions, 31 deletions
diff --git a/mysql-test/suite/jp/t/jp_union_ujis.test b/mysql-test/suite/jp/t/jp_union_ujis.test index e36d18c85c0..73c9c6607ad 100644 --- a/mysql-test/suite/jp/t/jp_union_ujis.test +++ b/mysql-test/suite/jp/t/jp_union_ujis.test @@ -1,4 +1,5 @@ --source include/have_ujis.inc +--source include/have_innodb.inc --disable_warnings drop table if exists `」ヤ」ア`; @@ -10,9 +11,6 @@ drop table if exists `」ヤ」カ`; drop table if exists `」ヤ」キ`; drop table if exists `」ヤ」ク`; drop table if exists `」ヤ」ケ`; -drop table if exists `」ヤ」ア」ー`; -drop table if exists `」ヤ」ア」ア`; -drop table if exists `」ヤ」ア」イ`; --enable_warnings # @@ -70,34 +68,10 @@ DROP TABLE `」ヤ」ア` ; DROP TABLE `」ヤ」イ` ; DROP TABLE `」ヤ」ウ` ; -#HEAP -CREATE TABLE `」ヤ」ア` (`」テ」ア` char(1), INDEX(`」テ」ア`)) DEFAULT CHARSET = ujis engine = HEAP; -CREATE TABLE `」ヤ」イ` (`」テ」ア` char(1), INDEX(`」テ」ア`)) DEFAULT CHARSET = ujis engine = HEAP; -CREATE TABLE `」ヤ」ウ` (`」テ」ア` char(1), INDEX(`」テ」ア`)) DEFAULT CHARSET = ujis engine = HEAP; -INSERT INTO `」ヤ」ア` VALUES('竺'),('竺'),('、「'),('、「'),('常ワ'),('常ワ'); -INSERT INTO `」ヤ」イ` VALUES('軸'),('軸'),('、、'),('、、'),('常ン'),('常ン'); -INSERT INTO `」ヤ」ウ` VALUES('宍'),('宍'),('、ヲ'),('、ヲ'),('常゙'),('常゙'); -SELECT * FROM `」ヤ」ア` UNION DISTINCT SELECT * FROM `」ヤ」イ` ORDER BY `」テ」ア`; -SELECT * FROM `」ヤ」ア` UNION ALL SELECT * FROM `」ヤ」イ` ORDER BY `」テ」ア`; -(SELECT * FROM `」ヤ」ア`) UNION (SELECT * FROM `」ヤ」イ`) UNION (SELECT '、ヲ') ORDER BY `」テ」ア`; -(SELECT '、ヲ' AS `」テ」ア`) UNION (SELECT * FROM `」ヤ」ア`) UNION (SELECT * FROM `」ヤ」イ`) ORDER BY `」テ」ア`; -SELECT `」テ」ア`, COUNT(*) FROM `」ヤ」ア` GROUP BY `」テ」ア` UNION -SELECT `」テ」ア`, COUNT(*) FROM `」ヤ」イ` GROUP BY `」テ」ア` ORDER BY `」テ」ア`; -SELECT * FROM `」ヤ」ア` UNION DISTINCT -SELECT * FROM `」ヤ」イ` UNION ALL -SELECT * FROM `」ヤ」ウ` ORDER BY `」テ」ア`; -SELECT * FROM `」ヤ」ア` UNION ALL -SELECT * FROM `」ヤ」イ` UNION DISTINCT -SELECT * FROM `」ヤ」ウ` ORDER BY `」テ」ア`; -SELECT * FROM `」ヤ」ア` UNION SELECT REPEAT(`」テ」ア`,5) FROM `」ヤ」イ` ORDER BY `」テ」ア`; -DROP TABLE `」ヤ」ア` ; -DROP TABLE `」ヤ」イ` ; -DROP TABLE `」ヤ」ウ` ; - -#BDB -CREATE TABLE `」ヤ」ア` (`」テ」ア` char(1), INDEX(`」テ」ア`)) DEFAULT CHARSET = ujis engine = BDB; -CREATE TABLE `」ヤ」イ` (`」テ」ア` char(1), INDEX(`」テ」ア`)) DEFAULT CHARSET = ujis engine = BDB; -CREATE TABLE `」ヤ」ウ` (`」テ」ア` char(1), INDEX(`」テ」ア`)) DEFAULT CHARSET = ujis engine = BDB; +#MEMORY +CREATE TABLE `」ヤ」ア` (`」テ」ア` char(1), INDEX(`」テ」ア`)) DEFAULT CHARSET = ujis engine = MEMORY; +CREATE TABLE `」ヤ」イ` (`」テ」ア` char(1), INDEX(`」テ」ア`)) DEFAULT CHARSET = ujis engine = MEMORY; +CREATE TABLE `」ヤ」ウ` (`」テ」ア` char(1), INDEX(`」テ」ア`)) DEFAULT CHARSET = ujis engine = MEMORY; INSERT INTO `」ヤ」ア` VALUES('竺'),('竺'),('、「'),('、「'),('常ワ'),('常ワ'); INSERT INTO `」ヤ」イ` VALUES('軸'),('軸'),('、、'),('、、'),('常ン'),('常ン'); INSERT INTO `」ヤ」ウ` VALUES('宍'),('宍'),('、ヲ'),('、ヲ'),('常゙'),('常゙'); |