Adding upstream version 1:10.11.6.upstream/1%10.11.6

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

1 files changed, 494 insertions, 0 deletions

diff --git a/mysql-test/suite/jp/r/jp_alter_sjis.result b/mysql-test/suite/jp/r/jp_alter_sjis.result
new file mode 100644
index 00000000..5574f543
--- /dev/null
+++ b/mysql-test/suite/jp/r/jp_alter_sjis.result
@@ -0,0 +1,494 @@
+SET NAMES sjis;
+SET character_set_database = sjis;
+DROP TABLE IF EXISTS `ｱｱｱ`;
+DROP TABLE IF EXISTS `ｲｲｲ`;
+DROP TABLE IF EXISTS `あああ`;
+DROP TABLE IF EXISTS `いいい`;
+DROP TABLE IF EXISTS `ソソソ`;
+DROP TABLE IF EXISTS `十十十`;
+CREATE TABLE `ｱｱｱ`(`ｷｷｷ` char(5)) DEFAULT CHARSET = sjis engine=INNODB;
+CREATE TABLE `ｲｲｲ`(`ｹｹｹ` char(5)) DEFAULT CHARSET = sjis engine=INNODB;
+CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = sjis engine=INNODB;
+CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = sjis engine=INNODB;
+CREATE TABLE `ソソソ`(`表表表` char(5)) DEFAULT CHARSET = sjis engine=INNODB;
+CREATE TABLE `十十十`(`予予予` char(5)) DEFAULT CHARSET = sjis engine=INNODB;
+INSERT INTO `ｱｱｱ` VALUES ('ｱｱｱｱｱ'),('ｲｲｲｲｲ'),('ｳｳｳｳｳ');
+INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
+INSERT INTO `ソソソ` VALUES ('表表表表表'),('構構構構構'),('能能能能能');
+ALTER TABLE `ｱｱｱ` ADD `ｶｶｶ` char(1) FIRST;
+ALTER TABLE `ｱｱｱ` ADD `ｸｸｸ` char(1) AFTER `ｷｷｷ`;
+ALTER TABLE `ｱｱｱ` ADD `ｹｹｹ` char(1);
+ALTER TABLE `ｱｱｱ` ADD INDEX (`ｶｶｶ`);
+ALTER TABLE `ｱｱｱ` ADD PRIMARY KEY (`ｷｷｷ`);
+ALTER TABLE `ｱｱｱ` ADD UNIQUE (`ｸｸｸ`);
+ALTER TABLE `ｱｱｱ` CHANGE `ｶｶｶ` `ｶｶ` char(1);
+ALTER TABLE `ｱｱｱ` MODIFY `ｷｷｷ` char(6);
+SELECT * FROM `ｱｱｱ`;
+ｶｶ	ｷｷｷ	ｸｸｸ	ｹｹｹ
+NULL	ｱｱｱｱｱ	NULL	NULL
+NULL	ｲｲｲｲｲ	NULL	NULL
+NULL	ｳｳｳｳｳ	NULL	NULL
+DESC `ｱｱｱ`;
+Field	Type	Null	Key	Default	Extra
+ｶｶ	char(1)	YES	MUL	NULL	
+ｷｷｷ	char(6)	NO	PRI	NULL	
+ｸｸｸ	char(1)	YES	UNI	NULL	
+ｹｹｹ	char(1)	YES		NULL	
+SHOW CREATE TABLE `ｱｱｱ`;
+Table	Create Table
+ｱｱｱ	CREATE TABLE `ｱｱｱ` (
+  `ｶｶ` char(1) DEFAULT NULL,
+  `ｷｷｷ` char(6) NOT NULL,
+  `ｸｸｸ` char(1) DEFAULT NULL,
+  `ｹｹｹ` char(1) DEFAULT NULL,
+  PRIMARY KEY (`ｷｷｷ`),
+  UNIQUE KEY `ｸｸｸ` (`ｸｸｸ`),
+  KEY `ｶｶｶ` (`ｶｶ`)
+) ENGINE=InnoDB DEFAULT CHARSET=sjis COLLATE=sjis_japanese_ci
+ALTER TABLE `ｱｱｱ` DROP INDEX `ｶｶｶ`;
+ALTER TABLE `ｱｱｱ` DROP PRIMARY KEY;
+ALTER TABLE `ｱｱｱ` DROP INDEX `ｸｸｸ`;
+ALTER TABLE `ｱｱｱ` DROP `ｶｶ`;
+ALTER TABLE `ｱｱｱ` DROP `ｸｸｸ`;
+ALTER TABLE `ｱｱｱ` DROP `ｹｹｹ`;
+SELECT * FROM `ｱｱｱ`;
+ｷｷｷ
+ｱｱｱｱｱ
+ｲｲｲｲｲ
+ｳｳｳｳｳ
+DESC `ｱｱｱ`;
+Field	Type	Null	Key	Default	Extra
+ｷｷｷ	char(6)	NO		NULL	
+SHOW CREATE TABLE `ｱｱｱ`;
+Table	Create Table
+ｱｱｱ	CREATE TABLE `ｱｱｱ` (
+  `ｷｷｷ` char(6) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=sjis COLLATE=sjis_japanese_ci
+ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
+ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
+ALTER TABLE `あああ` ADD `けけけ` char(1);
+ALTER TABLE `あああ` ADD INDEX (`かかか`);
+ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
+ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
+ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
+ALTER TABLE `あああ` MODIFY `ききき` char(6);
+SELECT * FROM `あああ`;
+かか	ききき	くくく	けけけ
+NULL	あああああ	NULL	NULL
+NULL	いいいいい	NULL	NULL
+NULL	ううううう	NULL	NULL
+DESC `あああ`;
+Field	Type	Null	Key	Default	Extra
+かか	char(1)	YES	MUL	NULL	
+ききき	char(6)	NO	PRI	NULL	
+くくく	char(1)	YES	UNI	NULL	
+けけけ	char(1)	YES		NULL	
+SHOW CREATE TABLE `あああ`;
+Table	Create Table
+あああ	CREATE TABLE `あああ` (
+  `かか` char(1) DEFAULT NULL,
+  `ききき` char(6) NOT NULL,
+  `くくく` char(1) DEFAULT NULL,
+  `けけけ` char(1) DEFAULT NULL,
+  PRIMARY KEY (`ききき`),
+  UNIQUE KEY `くくく` (`くくく`),
+  KEY `かかか` (`かか`)
+) ENGINE=InnoDB DEFAULT CHARSET=sjis COLLATE=sjis_japanese_ci
+ALTER TABLE `あああ` DROP INDEX `かかか`;
+ALTER TABLE `あああ` DROP PRIMARY KEY;
+ALTER TABLE `あああ` DROP INDEX `くくく`;
+ALTER TABLE `あああ` DROP `かか`;
+ALTER TABLE `あああ` DROP `くくく`;
+ALTER TABLE `あああ` DROP `けけけ`;
+SELECT * FROM `あああ`;
+ききき
+あああああ
+いいいいい
+ううううう
+DESC `あああ`;
+Field	Type	Null	Key	Default	Extra
+ききき	char(6)	NO		NULL	
+SHOW CREATE TABLE `あああ`;
+Table	Create Table
+あああ	CREATE TABLE `あああ` (
+  `ききき` char(6) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=sjis COLLATE=sjis_japanese_ci
+ALTER TABLE `ソソソ` ADD `構構構` char(1) FIRST;
+ALTER TABLE `ソソソ` ADD `能能能` char(1) AFTER `表表表`;
+ALTER TABLE `ソソソ` ADD `予予予` char(1);
+ALTER TABLE `ソソソ` ADD INDEX (`構構構`);
+ALTER TABLE `ソソソ` ADD PRIMARY KEY (`表表表`);
+ALTER TABLE `ソソソ` ADD UNIQUE (`能能能`);
+ALTER TABLE `ソソソ` CHANGE `構構構` `構構` char(1);
+ALTER TABLE `ソソソ` MODIFY `表表表` char(6);
+SELECT * FROM `ソソソ`;
+構構	表表表	能能能	予予予
+NULL	構構構構構	NULL	NULL
+NULL	能能能能能	NULL	NULL
+NULL	表表表表表	NULL	NULL
+DESC `ソソソ`;
+Field	Type	Null	Key	Default	Extra
+構構	char(1)	YES	MUL	NULL	
+表表表	char(6)	NO	PRI	NULL	
+能能能	char(1)	YES	UNI	NULL	
+予予予	char(1)	YES		NULL	
+SHOW CREATE TABLE `ソソソ`;
+Table	Create Table
+ソソソ	CREATE TABLE `ソソソ` (
+  `構構` char(1) DEFAULT NULL,
+  `表表表` char(6) NOT NULL,
+  `能能能` char(1) DEFAULT NULL,
+  `予予予` char(1) DEFAULT NULL,
+  PRIMARY KEY (`表表表`),
+  UNIQUE KEY `能能能` (`能能能`),
+  KEY `構構構` (`構構`)
+) ENGINE=InnoDB DEFAULT CHARSET=sjis COLLATE=sjis_japanese_ci
+ALTER TABLE `ソソソ` DROP INDEX `構構構`;
+ALTER TABLE `ソソソ` DROP PRIMARY KEY;
+ALTER TABLE `ソソソ` DROP INDEX `能能能`;
+ALTER TABLE `ソソソ` DROP `構構`;
+ALTER TABLE `ソソソ` DROP `能能能`;
+ALTER TABLE `ソソソ` DROP `予予予`;
+SELECT * FROM `ソソソ`;
+表表表
+構構構構構
+能能能能能
+表表表表表
+DESC `ソソソ`;
+Field	Type	Null	Key	Default	Extra
+表表表	char(6)	NO		NULL	
+SHOW CREATE TABLE `ソソソ`;
+Table	Create Table
+ソソソ	CREATE TABLE `ソソソ` (
+  `表表表` char(6) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=sjis COLLATE=sjis_japanese_ci
+DROP TABLE `ｱｱｱ`;
+DROP TABLE `ｲｲｲ`;
+DROP TABLE `あああ`;
+DROP TABLE `いいい`;
+DROP TABLE `ソソソ`;
+DROP TABLE `十十十`;
+CREATE TABLE `ｱｱｱ`(`ｷｷｷ` char(5)) DEFAULT CHARSET = sjis engine=MYISAM;
+CREATE TABLE `ｲｲｲ`(`ｹｹｹ` char(5)) DEFAULT CHARSET = sjis engine=MYISAM;
+CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = sjis engine=MYISAM;
+CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = sjis engine=MYISAM;
+CREATE TABLE `ソソソ`(`表表表` char(5)) DEFAULT CHARSET = sjis engine=MYISAM;
+CREATE TABLE `十十十`(`予予予` char(5)) DEFAULT CHARSET = sjis engine=MYISAM;
+INSERT INTO `ｱｱｱ` VALUES ('ｱｱｱｱｱ'),('ｲｲｲｲｲ'),('ｳｳｳｳｳ');
+INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
+INSERT INTO `ソソソ` VALUES ('表表表表表'),('構構構構構'),('能能能能能');
+ALTER TABLE `ｱｱｱ` ADD `ｶｶｶ` char(1) FIRST;
+ALTER TABLE `ｱｱｱ` ADD `ｸｸｸ` char(1) AFTER `ｷｷｷ`;
+ALTER TABLE `ｱｱｱ` ADD `ｹｹｹ` char(1);
+ALTER TABLE `ｱｱｱ` ADD INDEX (`ｶｶｶ`);
+ALTER TABLE `ｱｱｱ` ADD PRIMARY KEY (`ｷｷｷ`);
+ALTER TABLE `ｱｱｱ` ADD UNIQUE (`ｸｸｸ`);
+ALTER TABLE `ｱｱｱ` CHANGE `ｶｶｶ` `ｶｶ` char(1);
+ALTER TABLE `ｱｱｱ` MODIFY `ｷｷｷ` char(6);
+SELECT * FROM `ｱｱｱ`;
+ｶｶ	ｷｷｷ	ｸｸｸ	ｹｹｹ
+NULL	ｱｱｱｱｱ	NULL	NULL
+NULL	ｲｲｲｲｲ	NULL	NULL
+NULL	ｳｳｳｳｳ	NULL	NULL
+DESC `ｱｱｱ`;
+Field	Type	Null	Key	Default	Extra
+ｶｶ	char(1)	YES	MUL	NULL	
+ｷｷｷ	char(6)	NO	PRI	NULL	
+ｸｸｸ	char(1)	YES	UNI	NULL	
+ｹｹｹ	char(1)	YES		NULL	
+SHOW CREATE TABLE `ｱｱｱ`;
+Table	Create Table
+ｱｱｱ	CREATE TABLE `ｱｱｱ` (
+  `ｶｶ` char(1) DEFAULT NULL,
+  `ｷｷｷ` char(6) NOT NULL,
+  `ｸｸｸ` char(1) DEFAULT NULL,
+  `ｹｹｹ` char(1) DEFAULT NULL,
+  PRIMARY KEY (`ｷｷｷ`),
+  UNIQUE KEY `ｸｸｸ` (`ｸｸｸ`),
+  KEY `ｶｶｶ` (`ｶｶ`)
+) ENGINE=MyISAM DEFAULT CHARSET=sjis COLLATE=sjis_japanese_ci
+ALTER TABLE `ｱｱｱ` DROP INDEX `ｶｶｶ`;
+ALTER TABLE `ｱｱｱ` DROP PRIMARY KEY;
+ALTER TABLE `ｱｱｱ` DROP INDEX `ｸｸｸ`;
+ALTER TABLE `ｱｱｱ` DROP `ｶｶ`;
+ALTER TABLE `ｱｱｱ` DROP `ｸｸｸ`;
+ALTER TABLE `ｱｱｱ` DROP `ｹｹｹ`;
+SELECT * FROM `ｱｱｱ`;
+ｷｷｷ
+ｱｱｱｱｱ
+ｲｲｲｲｲ
+ｳｳｳｳｳ
+DESC `ｱｱｱ`;
+Field	Type	Null	Key	Default	Extra
+ｷｷｷ	char(6)	NO		NULL	
+SHOW CREATE TABLE `ｱｱｱ`;
+Table	Create Table
+ｱｱｱ	CREATE TABLE `ｱｱｱ` (
+  `ｷｷｷ` char(6) NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=sjis COLLATE=sjis_japanese_ci
+ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
+ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
+ALTER TABLE `あああ` ADD `けけけ` char(1);
+ALTER TABLE `あああ` ADD INDEX (`かかか`);
+ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
+ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
+ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
+ALTER TABLE `あああ` MODIFY `ききき` char(6);
+SELECT * FROM `あああ`;
+かか	ききき	くくく	けけけ
+NULL	あああああ	NULL	NULL
+NULL	いいいいい	NULL	NULL
+NULL	ううううう	NULL	NULL
+DESC `あああ`;
+Field	Type	Null	Key	Default	Extra
+かか	char(1)	YES	MUL	NULL	
+ききき	char(6)	NO	PRI	NULL	
+くくく	char(1)	YES	UNI	NULL	
+けけけ	char(1)	YES		NULL	
+SHOW CREATE TABLE `あああ`;
+Table	Create Table
+あああ	CREATE TABLE `あああ` (
+  `かか` char(1) DEFAULT NULL,
+  `ききき` char(6) NOT NULL,
+  `くくく` char(1) DEFAULT NULL,
+  `けけけ` char(1) DEFAULT NULL,
+  PRIMARY KEY (`ききき`),
+  UNIQUE KEY `くくく` (`くくく`),
+  KEY `かかか` (`かか`)
+) ENGINE=MyISAM DEFAULT CHARSET=sjis COLLATE=sjis_japanese_ci
+ALTER TABLE `あああ` DROP INDEX `かかか`;
+ALTER TABLE `あああ` DROP PRIMARY KEY;
+ALTER TABLE `あああ` DROP INDEX `くくく`;
+ALTER TABLE `あああ` DROP `かか`;
+ALTER TABLE `あああ` DROP `くくく`;
+ALTER TABLE `あああ` DROP `けけけ`;
+SELECT * FROM `あああ`;
+ききき
+あああああ
+いいいいい
+ううううう
+DESC `あああ`;
+Field	Type	Null	Key	Default	Extra
+ききき	char(6)	NO		NULL	
+SHOW CREATE TABLE `あああ`;
+Table	Create Table
+あああ	CREATE TABLE `あああ` (
+  `ききき` char(6) NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=sjis COLLATE=sjis_japanese_ci
+ALTER TABLE `ソソソ` ADD `構構構` char(1) FIRST;
+ALTER TABLE `ソソソ` ADD `能能能` char(1) AFTER `表表表`;
+ALTER TABLE `ソソソ` ADD `予予予` char(1);
+ALTER TABLE `ソソソ` ADD INDEX (`構構構`);
+ALTER TABLE `ソソソ` ADD PRIMARY KEY (`表表表`);
+ALTER TABLE `ソソソ` ADD UNIQUE (`能能能`);
+ALTER TABLE `ソソソ` CHANGE `構構構` `構構` char(1);
+ALTER TABLE `ソソソ` MODIFY `表表表` char(6);
+SELECT * FROM `ソソソ`;
+構構	表表表	能能能	予予予
+NULL	表表表表表	NULL	NULL
+NULL	構構構構構	NULL	NULL
+NULL	能能能能能	NULL	NULL
+DESC `ソソソ`;
+Field	Type	Null	Key	Default	Extra
+構構	char(1)	YES	MUL	NULL	
+表表表	char(6)	NO	PRI	NULL	
+能能能	char(1)	YES	UNI	NULL	
+予予予	char(1)	YES		NULL	
+SHOW CREATE TABLE `ソソソ`;
+Table	Create Table
+ソソソ	CREATE TABLE `ソソソ` (
+  `構構` char(1) DEFAULT NULL,
+  `表表表` char(6) NOT NULL,
+  `能能能` char(1) DEFAULT NULL,
+  `予予予` char(1) DEFAULT NULL,
+  PRIMARY KEY (`表表表`),
+  UNIQUE KEY `能能能` (`能能能`),
+  KEY `構構構` (`構構`)
+) ENGINE=MyISAM DEFAULT CHARSET=sjis COLLATE=sjis_japanese_ci
+ALTER TABLE `ソソソ` DROP INDEX `構構構`;
+ALTER TABLE `ソソソ` DROP PRIMARY KEY;
+ALTER TABLE `ソソソ` DROP INDEX `能能能`;
+ALTER TABLE `ソソソ` DROP `構構`;
+ALTER TABLE `ソソソ` DROP `能能能`;
+ALTER TABLE `ソソソ` DROP `予予予`;
+SELECT * FROM `ソソソ`;
+表表表
+表表表表表
+構構構構構
+能能能能能
+DESC `ソソソ`;
+Field	Type	Null	Key	Default	Extra
+表表表	char(6)	NO		NULL	
+SHOW CREATE TABLE `ソソソ`;
+Table	Create Table
+ソソソ	CREATE TABLE `ソソソ` (
+  `表表表` char(6) NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=sjis COLLATE=sjis_japanese_ci
+DROP TABLE `ｱｱｱ`;
+DROP TABLE `ｲｲｲ`;
+DROP TABLE `あああ`;
+DROP TABLE `いいい`;
+DROP TABLE `ソソソ`;
+DROP TABLE `十十十`;
+CREATE TABLE `ｱｱｱ`(`ｷｷｷ` char(5)) DEFAULT CHARSET = sjis engine=MEMORY;
+CREATE TABLE `ｲｲｲ`(`ｹｹｹ` char(5)) DEFAULT CHARSET = sjis engine=MEMORY;
+CREATE TABLE `あああ`(`ききき` char(5)) DEFAULT CHARSET = sjis engine=MEMORY;
+CREATE TABLE `いいい`(`けけけ` char(5)) DEFAULT CHARSET = sjis engine=MEMORY;
+CREATE TABLE `ソソソ`(`表表表` char(5)) DEFAULT CHARSET = sjis engine=MEMORY;
+CREATE TABLE `十十十`(`予予予` char(5)) DEFAULT CHARSET = sjis engine=MEMORY;
+INSERT INTO `ｱｱｱ` VALUES ('ｱｱｱｱｱ'),('ｲｲｲｲｲ'),('ｳｳｳｳｳ');
+INSERT INTO `あああ` VALUES ('あああああ'),('いいいいい'),('ううううう');
+INSERT INTO `ソソソ` VALUES ('表表表表表'),('構構構構構'),('能能能能能');
+ALTER TABLE `ｱｱｱ` ADD `ｶｶｶ` char(1) FIRST;
+ALTER TABLE `ｱｱｱ` ADD `ｸｸｸ` char(1) AFTER `ｷｷｷ`;
+ALTER TABLE `ｱｱｱ` ADD `ｹｹｹ` char(1);
+ALTER TABLE `ｱｱｱ` ADD INDEX (`ｶｶｶ`);
+ALTER TABLE `ｱｱｱ` ADD PRIMARY KEY (`ｷｷｷ`);
+ALTER TABLE `ｱｱｱ` ADD UNIQUE (`ｸｸｸ`);
+ALTER TABLE `ｱｱｱ` CHANGE `ｶｶｶ` `ｶｶ` char(1);
+ALTER TABLE `ｱｱｱ` MODIFY `ｷｷｷ` char(6);
+SELECT * FROM `ｱｱｱ`;
+ｶｶ	ｷｷｷ	ｸｸｸ	ｹｹｹ
+NULL	ｱｱｱｱｱ	NULL	NULL
+NULL	ｲｲｲｲｲ	NULL	NULL
+NULL	ｳｳｳｳｳ	NULL	NULL
+DESC `ｱｱｱ`;
+Field	Type	Null	Key	Default	Extra
+ｶｶ	char(1)	YES	MUL	NULL	
+ｷｷｷ	char(6)	NO	PRI	NULL	
+ｸｸｸ	char(1)	YES	UNI	NULL	
+ｹｹｹ	char(1)	YES		NULL	
+SHOW CREATE TABLE `ｱｱｱ`;
+Table	Create Table
+ｱｱｱ	CREATE TABLE `ｱｱｱ` (
+  `ｶｶ` char(1) DEFAULT NULL,
+  `ｷｷｷ` char(6) NOT NULL,
+  `ｸｸｸ` char(1) DEFAULT NULL,
+  `ｹｹｹ` char(1) DEFAULT NULL,
+  PRIMARY KEY (`ｷｷｷ`),
+  UNIQUE KEY `ｸｸｸ` (`ｸｸｸ`),
+  KEY `ｶｶｶ` (`ｶｶ`)
+) ENGINE=MEMORY DEFAULT CHARSET=sjis COLLATE=sjis_japanese_ci
+ALTER TABLE `ｱｱｱ` DROP INDEX `ｶｶｶ`;
+ALTER TABLE `ｱｱｱ` DROP PRIMARY KEY;
+ALTER TABLE `ｱｱｱ` DROP INDEX `ｸｸｸ`;
+ALTER TABLE `ｱｱｱ` DROP `ｶｶ`;
+ALTER TABLE `ｱｱｱ` DROP `ｸｸｸ`;
+ALTER TABLE `ｱｱｱ` DROP `ｹｹｹ`;
+SELECT * FROM `ｱｱｱ`;
+ｷｷｷ
+ｱｱｱｱｱ
+ｲｲｲｲｲ
+ｳｳｳｳｳ
+DESC `ｱｱｱ`;
+Field	Type	Null	Key	Default	Extra
+ｷｷｷ	char(6)	NO		NULL	
+SHOW CREATE TABLE `ｱｱｱ`;
+Table	Create Table
+ｱｱｱ	CREATE TABLE `ｱｱｱ` (
+  `ｷｷｷ` char(6) NOT NULL
+) ENGINE=MEMORY DEFAULT CHARSET=sjis COLLATE=sjis_japanese_ci
+ALTER TABLE `あああ` ADD `かかか` char(1) FIRST;
+ALTER TABLE `あああ` ADD `くくく` char(1) AFTER `ききき`;
+ALTER TABLE `あああ` ADD `けけけ` char(1);
+ALTER TABLE `あああ` ADD INDEX (`かかか`);
+ALTER TABLE `あああ` ADD PRIMARY KEY (`ききき`);
+ALTER TABLE `あああ` ADD UNIQUE (`くくく`);
+ALTER TABLE `あああ` CHANGE `かかか` `かか` char(1);
+ALTER TABLE `あああ` MODIFY `ききき` char(6);
+SELECT * FROM `あああ`;
+かか	ききき	くくく	けけけ
+NULL	あああああ	NULL	NULL
+NULL	いいいいい	NULL	NULL
+NULL	ううううう	NULL	NULL
+DESC `あああ`;
+Field	Type	Null	Key	Default	Extra
+かか	char(1)	YES	MUL	NULL	
+ききき	char(6)	NO	PRI	NULL	
+くくく	char(1)	YES	UNI	NULL	
+けけけ	char(1)	YES		NULL	
+SHOW CREATE TABLE `あああ`;
+Table	Create Table
+あああ	CREATE TABLE `あああ` (
+  `かか` char(1) DEFAULT NULL,
+  `ききき` char(6) NOT NULL,
+  `くくく` char(1) DEFAULT NULL,
+  `けけけ` char(1) DEFAULT NULL,
+  PRIMARY KEY (`ききき`),
+  UNIQUE KEY `くくく` (`くくく`),
+  KEY `かかか` (`かか`)
+) ENGINE=MEMORY DEFAULT CHARSET=sjis COLLATE=sjis_japanese_ci
+ALTER TABLE `あああ` DROP INDEX `かかか`;
+ALTER TABLE `あああ` DROP PRIMARY KEY;
+ALTER TABLE `あああ` DROP INDEX `くくく`;
+ALTER TABLE `あああ` DROP `かか`;
+ALTER TABLE `あああ` DROP `くくく`;
+ALTER TABLE `あああ` DROP `けけけ`;
+SELECT * FROM `あああ`;
+ききき
+あああああ
+いいいいい
+ううううう
+DESC `あああ`;
+Field	Type	Null	Key	Default	Extra
+ききき	char(6)	NO		NULL	
+SHOW CREATE TABLE `あああ`;
+Table	Create Table
+あああ	CREATE TABLE `あああ` (
+  `ききき` char(6) NOT NULL
+) ENGINE=MEMORY DEFAULT CHARSET=sjis COLLATE=sjis_japanese_ci
+ALTER TABLE `ソソソ` ADD `構構構` char(1) FIRST;
+ALTER TABLE `ソソソ` ADD `能能能` char(1) AFTER `表表表`;
+ALTER TABLE `ソソソ` ADD `予予予` char(1);
+ALTER TABLE `ソソソ` ADD INDEX (`構構構`);
+ALTER TABLE `ソソソ` ADD PRIMARY KEY (`表表表`);
+ALTER TABLE `ソソソ` ADD UNIQUE (`能能能`);
+ALTER TABLE `ソソソ` CHANGE `構構構` `構構` char(1);
+ALTER TABLE `ソソソ` MODIFY `表表表` char(6);
+SELECT * FROM `ソソソ`;
+構構	表表表	能能能	予予予
+NULL	表表表表表	NULL	NULL
+NULL	構構構構構	NULL	NULL
+NULL	能能能能能	NULL	NULL
+DESC `ソソソ`;
+Field	Type	Null	Key	Default	Extra
+構構	char(1)	YES	MUL	NULL	
+表表表	char(6)	NO	PRI	NULL	
+能能能	char(1)	YES	UNI	NULL	
+予予予	char(1)	YES		NULL	
+SHOW CREATE TABLE `ソソソ`;
+Table	Create Table
+ソソソ	CREATE TABLE `ソソソ` (
+  `構構` char(1) DEFAULT NULL,
+  `表表表` char(6) NOT NULL,
+  `能能能` char(1) DEFAULT NULL,
+  `予予予` char(1) DEFAULT NULL,
+  PRIMARY KEY (`表表表`),
+  UNIQUE KEY `能能能` (`能能能`),
+  KEY `構構構` (`構構`)
+) ENGINE=MEMORY DEFAULT CHARSET=sjis COLLATE=sjis_japanese_ci
+ALTER TABLE `ソソソ` DROP INDEX `構構構`;
+ALTER TABLE `ソソソ` DROP PRIMARY KEY;
+ALTER TABLE `ソソソ` DROP INDEX `能能能`;
+ALTER TABLE `ソソソ` DROP `構構`;
+ALTER TABLE `ソソソ` DROP `能能能`;
+ALTER TABLE `ソソソ` DROP `予予予`;
+SELECT * FROM `ソソソ`;
+表表表
+表表表表表
+構構構構構
+能能能能能
+DESC `ソソソ`;
+Field	Type	Null	Key	Default	Extra
+表表表	char(6)	NO		NULL	
+SHOW CREATE TABLE `ソソソ`;
+Table	Create Table
+ソソソ	CREATE TABLE `ソソソ` (
+  `表表表` char(6) NOT NULL
+) ENGINE=MEMORY DEFAULT CHARSET=sjis COLLATE=sjis_japanese_ci
+DROP TABLE `ｱｱｱ`;
+DROP TABLE `ｲｲｲ`;
+DROP TABLE `あああ`;
+DROP TABLE `いいい`;
+DROP TABLE `ソソソ`;
+DROP TABLE `十十十`;