diff options
Diffstat (limited to 'mysql-test/suite/jp/t/jp_create_tbl_utf8.test')
-rwxr-xr-x | mysql-test/suite/jp/t/jp_create_tbl_utf8.test | 312 |
1 files changed, 312 insertions, 0 deletions
diff --git a/mysql-test/suite/jp/t/jp_create_tbl_utf8.test b/mysql-test/suite/jp/t/jp_create_tbl_utf8.test new file mode 100755 index 00000000000..5c816eb169a --- /dev/null +++ b/mysql-test/suite/jp/t/jp_create_tbl_utf8.test @@ -0,0 +1,312 @@ +--disable_warnings +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 `いいい`; +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 `龡龡龡`; +DROP TABLE IF EXISTS `龢龢龢`; +--enable_warnings + +# +# Test creating table with Japanese characters in utf8 encoding +# + +SET NAMES utf8; +SET character_set_database = utf8; + +CREATE TABLE `アアア`(`カカカ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; +CREATE TABLE `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; +CREATE TABLE `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; +CREATE TABLE `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; +CREATE TABLE `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; +CREATE TABLE `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; +# Tables should not be created because table names exist +CREATE TABLE IF NOT EXISTS `アアア`(`カカカ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; +CREATE TABLE IF NOT EXISTS `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; +CREATE TABLE IF NOT EXISTS `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; +CREATE TABLE IF NOT EXISTS `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; +CREATE TABLE IF NOT EXISTS `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; +CREATE TABLE IF NOT EXISTS `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; +# Tables should be created +CREATE TABLE IF NOT EXISTS `ウウウ`(`ククク` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; +CREATE TABLE IF NOT EXISTS `ううう`(`くくく` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; +CREATE TABLE IF NOT EXISTS `龞龞龞`(`丅丅丅`char(1)) DEFAULT CHARSET = utf8 engine=INNODB; +CREATE TEMPORARY TABLE `エエエ`(`ケケケ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; +CREATE TEMPORARY TABLE `オオオ`(`コココ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; +CREATE TEMPORARY TABLE `えええ`(`けけけ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; +CREATE TEMPORARY TABLE `おおお`(`こここ` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; +CREATE TEMPORARY TABLE `龡龡龡`(`丌丌丌` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; +CREATE TEMPORARY TABLE `龢龢龢`(`丒丒丒` char(1)) DEFAULT CHARSET = utf8 engine=INNODB; + +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 = utf8 engine=MyISAM; +CREATE TABLE `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; +CREATE TABLE `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; +CREATE TABLE `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; +CREATE TABLE `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; +CREATE TABLE `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; +# Tables should not be created because table names exist +CREATE TABLE IF NOT EXISTS `アアア`(`カカカ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; +CREATE TABLE IF NOT EXISTS `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; +CREATE TABLE IF NOT EXISTS `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; +CREATE TABLE IF NOT EXISTS `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; +CREATE TABLE IF NOT EXISTS `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; +CREATE TABLE IF NOT EXISTS `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; +# Tables should be created +CREATE TABLE IF NOT EXISTS `ウウウ`(`ククク` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; +CREATE TABLE IF NOT EXISTS `ううう`(`くくく` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; +CREATE TABLE IF NOT EXISTS `龞龞龞`(`丅丅丅`char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; +CREATE TEMPORARY TABLE `エエエ`(`ケケケ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; +CREATE TEMPORARY TABLE `オオオ`(`コココ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; +CREATE TEMPORARY TABLE `えええ`(`けけけ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; +CREATE TEMPORARY TABLE `おおお`(`こここ` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; +CREATE TEMPORARY TABLE `龡龡龡`(`丌丌丌` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; +CREATE TEMPORARY TABLE `龢龢龢`(`丒丒丒` char(1)) DEFAULT CHARSET = utf8 engine=MyISAM; + +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 = utf8 engine=HEAP; +CREATE TABLE `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; +CREATE TABLE `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; +CREATE TABLE `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; +CREATE TABLE `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; +CREATE TABLE `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; +# Tables should not be created because table names exist +CREATE TABLE IF NOT EXISTS `アアア`(`カカカ` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; +CREATE TABLE IF NOT EXISTS `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; +CREATE TABLE IF NOT EXISTS `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; +CREATE TABLE IF NOT EXISTS `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; +CREATE TABLE IF NOT EXISTS `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; +CREATE TABLE IF NOT EXISTS `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; +# Tables should be created +CREATE TABLE IF NOT EXISTS `ウウウ`(`ククク` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; +CREATE TABLE IF NOT EXISTS `ううう`(`くくく` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; +CREATE TABLE IF NOT EXISTS `龞龞龞`(`丅丅丅`char(1)) DEFAULT CHARSET = utf8 engine=HEAP; +CREATE TEMPORARY TABLE `エエエ`(`ケケケ` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; +CREATE TEMPORARY TABLE `オオオ`(`コココ` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; +CREATE TEMPORARY TABLE `えええ`(`けけけ` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; +CREATE TEMPORARY TABLE `おおお`(`こここ` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; +CREATE TEMPORARY TABLE `龡龡龡`(`丌丌丌` char(1)) DEFAULT CHARSET = utf8 engine=HEAP; +CREATE TEMPORARY TABLE `龢龢龢`(`丒丒丒` char(1)) DEFAULT CHARSET = utf8 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 = utf8 engine=BDB; +CREATE TABLE `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=BDB; +CREATE TABLE `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=BDB; +CREATE TABLE `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=BDB; +CREATE TABLE `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=BDB; +CREATE TABLE `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=BDB; +# Tables should not be created because table names exist +CREATE TABLE IF NOT EXISTS `アアア`(`カカカ` char(1)) DEFAULT CHARSET = utf8 engine=BDB; +CREATE TABLE IF NOT EXISTS `イイイ`(`キキキ` char(1)) DEFAULT CHARSET = utf8 engine=BDB; +CREATE TABLE IF NOT EXISTS `あああ`(`かかか` char(1)) DEFAULT CHARSET = utf8 engine=BDB; +CREATE TABLE IF NOT EXISTS `いいい`(`ききき` char(1)) DEFAULT CHARSET = utf8 engine=BDB; +CREATE TABLE IF NOT EXISTS `龖龖龖`(`丂丂丂` char(1)) DEFAULT CHARSET = utf8 engine=BDB; +CREATE TABLE IF NOT EXISTS `龗龗龗`(`丄丄丄` char(1)) DEFAULT CHARSET = utf8 engine=BDB; +# Tables should be created +CREATE TABLE IF NOT EXISTS `ウウウ`(`ククク` char(1)) DEFAULT CHARSET = utf8 engine=BDB; +CREATE TABLE IF NOT EXISTS `ううう`(`くくく` char(1)) DEFAULT CHARSET = utf8 engine=BDB; +CREATE TABLE IF NOT EXISTS `龞龞龞`(`丅丅丅`char(1)) DEFAULT CHARSET = utf8 engine=BDB; +CREATE TEMPORARY TABLE `エエエ`(`ケケケ` char(1)) DEFAULT CHARSET = utf8 engine=BDB; +CREATE TEMPORARY TABLE `オオオ`(`コココ` char(1)) DEFAULT CHARSET = utf8 engine=BDB; +CREATE TEMPORARY TABLE `えええ`(`けけけ` char(1)) DEFAULT CHARSET = utf8 engine=BDB; +CREATE TEMPORARY TABLE `おおお`(`こここ` char(1)) DEFAULT CHARSET = utf8 engine=BDB; +CREATE TEMPORARY TABLE `龡龡龡`(`丌丌丌` char(1)) DEFAULT CHARSET = utf8 engine=BDB; +CREATE TEMPORARY TABLE `龢龢龢`(`丒丒丒` char(1)) DEFAULT CHARSET = utf8 engine=BDB; + +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 `龢龢龢`; |