diff options
Diffstat (limited to 'mysql-test/suite/jp/t/jp_create_tbl_ujis.test')
-rw-r--r-- | mysql-test/suite/jp/t/jp_create_tbl_ujis.test | 115 |
1 files changed, 22 insertions, 93 deletions
diff --git a/mysql-test/suite/jp/t/jp_create_tbl_ujis.test b/mysql-test/suite/jp/t/jp_create_tbl_ujis.test index ac70facdce9..c82d11868bd 100644 --- a/mysql-test/suite/jp/t/jp_create_tbl_ujis.test +++ b/mysql-test/suite/jp/t/jp_create_tbl_ujis.test @@ -1,4 +1,5 @@ --source include/have_ujis.inc +--source include/have_innodb.inc --disable_warnings DROP TABLE IF EXISTS `アアア`; @@ -169,101 +170,29 @@ DROP TABLE `龞龞龞`; DROP TABLE `龡龡龡`; DROP TABLE `龢龢龢`; -CREATE TABLE `アアア`(`カカカ` char(1)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TABLE `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TABLE `あああ`(`かかか` char(1)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TABLE `いいい`(`ききき` char(1)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TABLE `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TABLE `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = ujis engine=HEAP; +CREATE TABLE `アアア`(`カカカ` char(1)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TABLE `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TABLE `あああ`(`かかか` char(1)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TABLE `いいい`(`ききき` char(1)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TABLE `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TABLE `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = ujis engine=MEMORY; # Tables should not be created because table names exist -CREATE TABLE IF NOT EXISTS `アアア`(`カカカ` char(1)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TABLE IF NOT EXISTS `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TABLE IF NOT EXISTS `あああ`(`かかか` char(1)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TABLE IF NOT EXISTS `いいい`(`ききき` char(1)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TABLE IF NOT EXISTS `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TABLE IF NOT EXISTS `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = ujis engine=HEAP; +CREATE TABLE IF NOT EXISTS `アアア`(`カカカ` char(1)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TABLE IF NOT EXISTS `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TABLE IF NOT EXISTS `あああ`(`かかか` char(1)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TABLE IF NOT EXISTS `いいい`(`ききき` char(1)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TABLE IF NOT EXISTS `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TABLE IF NOT EXISTS `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = ujis engine=MEMORY; # Tables should be created -CREATE TABLE IF NOT EXISTS `ウウウ`(`ククク` char(1)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TABLE IF NOT EXISTS `ううう`(`くくく` char(1)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TABLE IF NOT EXISTS `龞龞龞`(`丅丅丅`char(1)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TEMPORARY TABLE `エエエ`(`ケケケ` char(1)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TEMPORARY TABLE `オオオ`(`コココ` char(1)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TEMPORARY TABLE `えええ`(`けけけ` char(1)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TEMPORARY TABLE `おおお`(`こここ` char(1)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TEMPORARY TABLE `龡龡龡`(`丌丌丌` char(1)) DEFAULT CHARSET = ujis engine=HEAP; -CREATE TEMPORARY TABLE `龢龢龢`(`丒丒丒` char(1)) DEFAULT CHARSET = ujis engine=HEAP; - -DESC `アアア`; -DESC `イイイ`; -DESC `ウウウ`; -DESC `エエエ`; -DESC `オオオ`; -DESC `あああ`; -DESC `いいい`; -DESC `ううう`; -DESC `えええ`; -DESC `おおお`; -DESC `龖龖龖`; -DESC `龗龗龗`; -DESC `龞龞龞`; -DESC `龡龡龡`; -DESC `龢龢龢`; - -SHOW CREATE TABLE `アアア`; -SHOW CREATE TABLE `イイイ`; -SHOW CREATE TABLE `ウウウ`; -SHOW CREATE TABLE `エエエ`; -SHOW CREATE TABLE `オオオ`; -SHOW CREATE TABLE `あああ`; -SHOW CREATE TABLE `いいい`; -SHOW CREATE TABLE `ううう`; -SHOW CREATE TABLE `えええ`; -SHOW CREATE TABLE `おおお`; -SHOW CREATE TABLE `龖龖龖`; -SHOW CREATE TABLE `龗龗龗`; -SHOW CREATE TABLE `龞龞龞`; -SHOW CREATE TABLE `龡龡龡`; -SHOW CREATE TABLE `龢龢龢`; - -DROP TABLE `アアア`; -DROP TABLE `イイイ`; -DROP TABLE `ウウウ`; -DROP TABLE `エエエ`; -DROP TABLE `オオオ`; -DROP TABLE `あああ`; -DROP TABLE `いいい`; -DROP TABLE `ううう`; -DROP TABLE `えええ`; -DROP TABLE `おおお`; -DROP TABLE `龖龖龖`; -DROP TABLE `龗龗龗`; -DROP TABLE `龞龞龞`; -DROP TABLE `龡龡龡`; -DROP TABLE `龢龢龢`; - -CREATE TABLE `アアア`(`カカカ` char(1)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TABLE `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TABLE `あああ`(`かかか` char(1)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TABLE `いいい`(`ききき` char(1)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TABLE `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TABLE `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = ujis engine=BDB; -# Tables should not be created because table names exist -CREATE TABLE IF NOT EXISTS `アアア`(`カカカ` char(1)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TABLE IF NOT EXISTS `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TABLE IF NOT EXISTS `あああ`(`かかか` char(1)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TABLE IF NOT EXISTS `いいい`(`ききき` char(1)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TABLE IF NOT EXISTS `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TABLE IF NOT EXISTS `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = ujis engine=BDB; -# Tables should be created -CREATE TABLE IF NOT EXISTS `ウウウ`(`ククク` char(1)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TABLE IF NOT EXISTS `ううう`(`くくく` char(1)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TABLE IF NOT EXISTS `龞龞龞`(`丅丅丅`char(1)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TEMPORARY TABLE `エエエ`(`ケケケ` char(1)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TEMPORARY TABLE `オオオ`(`コココ` char(1)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TEMPORARY TABLE `えええ`(`けけけ` char(1)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TEMPORARY TABLE `おおお`(`こここ` char(1)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TEMPORARY TABLE `龡龡龡`(`丌丌丌` char(1)) DEFAULT CHARSET = ujis engine=BDB; -CREATE TEMPORARY TABLE `龢龢龢`(`丒丒丒` char(1)) DEFAULT CHARSET = ujis engine=BDB; +CREATE TABLE IF NOT EXISTS `ウウウ`(`ククク` char(1)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TABLE IF NOT EXISTS `ううう`(`くくく` char(1)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TABLE IF NOT EXISTS `龞龞龞`(`丅丅丅`char(1)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TEMPORARY TABLE `エエエ`(`ケケケ` char(1)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TEMPORARY TABLE `オオオ`(`コココ` char(1)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TEMPORARY TABLE `えええ`(`けけけ` char(1)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TEMPORARY TABLE `おおお`(`こここ` char(1)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TEMPORARY TABLE `龡龡龡`(`丌丌丌` char(1)) DEFAULT CHARSET = ujis engine=MEMORY; +CREATE TEMPORARY TABLE `龢龢龢`(`丒丒丒` char(1)) DEFAULT CHARSET = ujis engine=MEMORY; DESC `アアア`; DESC `イイイ`; |