Spracherkennung für: .test vermutete Sprache: SQL {SQL[228] VDM[84] Lisp[80]} [Methode: maximale Elemente, drei Dimensionen]
--source include/have_sjis.inc
--source include/have_innodb.inc
--character_set sjis
--disable_warnings
drop table if exists `sP`;
drop table if exists `sQ`;
drop table if exists `sR`;
drop table if exists `sS`;
drop table if exists `sT`;
drop table if exists `sU`;
drop table if exists `sV`;
drop table if exists `sW`;
drop table if exists `sX`;
--enable_warnings
#
# Test INSERT() function with Japanese characters in sjis encoding
#
SET NAMES sjis;
SET character_set_database = sjis;
CREATE TABLE `sP` (`bP` char(5)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `sQ` (`bP` char(5)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `sR` (`bP` char(5)) DEFAULT CHARSET = sjis engine = innodb;
CREATE TABLE `sS` (`bP` char(5)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `sT` (`bP` char(5)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `sU` (`bP` char(5)) DEFAULT CHARSET = sjis engine = myisam;
CREATE TABLE `sV` (`bP` char(5)) DEFAULT CHARSET = sjis engine = MEMORY;
CREATE TABLE `sW` (`bP` char(5)) DEFAULT CHARSET = sjis engine = MEMORY;
CREATE TABLE `sX` (`bP` char(5)) DEFAULT CHARSET = sjis engine = MEMORY;
INSERT INTO `sP` VALUES ('±²³´µ');
INSERT INTO `sQ` VALUES (' ¢¤¦¨');
INSERT INTO `sR` VALUES ('\\\\\');
INSERT INTO `sS` VALUES ('±²³´µ');
INSERT INTO `sT` VALUES (' ¢¤¦¨');
INSERT INTO `sU` VALUES ('\\\\\');
INSERT INTO `sV` VALUES ('±²³´µ');
INSERT INTO `sW` VALUES (' ¢¤¦¨');
INSERT INTO `sX` VALUES ('\\\\\');
#InnoDB
SELECT INSERT(`bP`,1,1,'¶') FROM `sP`;
SELECT INSERT(`bP`,1,2,'¶·') FROM `sP`;
SELECT INSERT(`bP`,1,3,'¶·¸') FROM `sP`;
SELECT INSERT(`bP`,1,4,'¶·¸¹') FROM `sP`;
SELECT INSERT(`bP`,1,5,'¶·¸¹º') FROM `sP`;
SELECT INSERT(`bP`,2,1,'·') FROM `sP`;
SELECT INSERT(`bP`,2,2,'·¸') FROM `sP`;
SELECT INSERT(`bP`,2,3,'·¸¹') FROM `sP`;
SELECT INSERT(`bP`,2,4,'·¸¹º') FROM `sP`;
SELECT INSERT(`bP`,3,1,'¸') FROM `sP`;
SELECT INSERT(`bP`,3,2,'¸¹') FROM `sP`;
SELECT INSERT(`bP`,3,3,'¸¹º') FROM `sP`;
SELECT INSERT(`bP`,4,1,'¹') FROM `sP`;
SELECT INSERT(`bP`,4,2,'¹º') FROM `sP`;
SELECT INSERT(`bP`,5,1,'º') FROM `sP`;
SELECT INSERT(`bP`,1,1,' ') FROM `sP`;
SELECT INSERT(`bP`,1,2,' ') FROM `sP`;
SELECT INSERT(`bP`,1,3,' ') FROM `sP`;
SELECT INSERT(`bP`,1,4,' ') FROM `sP`;
SELECT INSERT(`bP`,1,5,' ') FROM `sP`;
SELECT INSERT(`bP`,2,1,' ') FROM `sP`;
SELECT INSERT(`bP`,2,2,' ') FROM `sP`;
SELECT INSERT(`bP`,2,3,' ') FROM `sP`;
SELECT INSERT(`bP`,2,4,' ') FROM `sP`;
SELECT INSERT(`bP`,3,1,' ') FROM `sP`;
SELECT INSERT(`bP`,3,2,' ') FROM `sP`;
SELECT INSERT(`bP`,3,3,' ') FROM `sP`;
SELECT INSERT(`bP`,4,1,' ') FROM `sP`;
SELECT INSERT(`bP`,4,2,' ') FROM `sP`;
SELECT INSERT(`bP`,5,1,' ') FROM `sP`;
SELECT INSERT(`bP`,1,1,'©') FROM `sQ`;
SELECT INSERT(`bP`,1,2,'©«') FROM `sQ`;
SELECT INSERT(`bP`,1,3,'©«') FROM `sQ`;
SELECT INSERT(`bP`,1,4,'©«¯') FROM `sQ`;
SELECT INSERT(`bP`,1,5,'©«¯±') FROM `sQ`;
SELECT INSERT(`bP`,2,1,'«') FROM `sQ`;
SELECT INSERT(`bP`,2,2,'«') FROM `sQ`;
SELECT INSERT(`bP`,2,3,'«¯') FROM `sQ`;
SELECT INSERT(`bP`,2,4,'«¯±') FROM `sQ`;
SELECT INSERT(`bP`,3,1,'') FROM `sQ`;
SELECT INSERT(`bP`,3,2,'¯') FROM `sQ`;
SELECT INSERT(`bP`,3,3,'¯±') FROM `sQ`;
SELECT INSERT(`bP`,4,1,'¯') FROM `sQ`;
SELECT INSERT(`bP`,4,2,'¯±') FROM `sQ`;
SELECT INSERT(`bP`,5,1,'±') FROM `sQ`;
SELECT INSERT(`bP`,1,1,'@') FROM `sQ`;
SELECT INSERT(`bP`,1,2,'@@') FROM `sQ`;
SELECT INSERT(`bP`,1,3,'@@@') FROM `sQ`;
SELECT INSERT(`bP`,1,4,'@@@@') FROM `sQ`;
SELECT INSERT(`bP`,1,5,'@@@@@') FROM `sQ`;
SELECT INSERT(`bP`,2,1,'@') FROM `sQ`;
SELECT INSERT(`bP`,2,2,'@@') FROM `sQ`;
SELECT INSERT(`bP`,2,3,'@@@') FROM `sQ`;
SELECT INSERT(`bP`,2,4,'@@@@') FROM `sQ`;
SELECT INSERT(`bP`,3,1,'@') FROM `sQ`;
SELECT INSERT(`bP`,3,2,'@@') FROM `sQ`;
SELECT INSERT(`bP`,3,3,'@@@') FROM `sQ`;
SELECT INSERT(`bP`,4,1,'@') FROM `sQ`;
SELECT INSERT(`bP`,4,2,'@@') FROM `sQ`;
SELECT INSERT(`bP`,5,1,'@') FROM `sQ`;
SELECT INSERT(`bP`,1,1,'\') FROM `sR`;
SELECT INSERT(`bP`,1,2,'\\' ) FROM `sR`;
SELECT INSERT(`bP`,1,3,'\\\' ) FROM `sR`;
SELECT INSERT(`bP`,1,4,'\\\\' ) FROM `sR`;
SELECT INSERT(`bP`,1,5,'\\\\\' ) FROM `sR`;
SELECT INSERT(`bP`,2,1,'\') FROM `sR`;
SELECT INSERT(`bP`,2,2,'\\' ) FROM `sR`;
SELECT INSERT(`bP`,2,3,'\\\' ) FROM `sR`;
SELECT INSERT(`bP`,2,4,'\\\\' ) FROM `sR`;
SELECT INSERT(`bP`,3,1,'\') FROM `sR`;
SELECT INSERT(`bP`,3,2,'\\' ) FROM `sR`;
SELECT INSERT(`bP`,3,3,'\\\' ) FROM `sR`;
SELECT INSERT(`bP`,4,1,'\') FROM `sR`;
SELECT INSERT(`bP`,4,2,'\\' ) FROM `sR`;
SELECT INSERT(`bP`,5,1,'\') FROM `sR`;
#MyISAM
SELECT INSERT(`bP`,1,1,'¶') FROM `sS`;
SELECT INSERT(`bP`,1,2,'¶·') FROM `sS`;
SELECT INSERT(`bP`,1,3,'¶·¸') FROM `sS`;
SELECT INSERT(`bP`,1,4,'¶·¸¹') FROM `sS`;
SELECT INSERT(`bP`,1,5,'¶·¸¹º') FROM `sS`;
SELECT INSERT(`bP`,2,1,'·') FROM `sS`;
SELECT INSERT(`bP`,2,2,'·¸') FROM `sS`;
SELECT INSERT(`bP`,2,3,'·¸¹') FROM `sS`;
SELECT INSERT(`bP`,2,4,'·¸¹º') FROM `sS`;
SELECT INSERT(`bP`,3,1,'¸') FROM `sS`;
SELECT INSERT(`bP`,3,2,'¸¹') FROM `sS`;
SELECT INSERT(`bP`,3,3,'¸¹º') FROM `sS`;
SELECT INSERT(`bP`,4,1,'¹') FROM `sS`;
SELECT INSERT(`bP`,4,2,'¹º') FROM `sS`;
SELECT INSERT(`bP`,5,1,'º') FROM `sS`;
SELECT INSERT(`bP`,1,1,' ') FROM `sS`;
SELECT INSERT(`bP`,1,2,' ') FROM `sS`;
SELECT INSERT(`bP`,1,3,' ') FROM `sS`;
SELECT INSERT(`bP`,1,4,' ') FROM `sS`;
SELECT INSERT(`bP`,1,5,' ') FROM `sS`;
SELECT INSERT(`bP`,2,1,' ') FROM `sS`;
SELECT INSERT(`bP`,2,2,' ') FROM `sS`;
SELECT INSERT(`bP`,2,3,' ') FROM `sS`;
SELECT INSERT(`bP`,2,4,' ') FROM `sS`;
SELECT INSERT(`bP`,3,1,' ') FROM `sS`;
SELECT INSERT(`bP`,3,2,' ') FROM `sS`;
SELECT INSERT(`bP`,3,3,' ') FROM `sS`;
SELECT INSERT(`bP`,4,1,' ') FROM `sS`;
SELECT INSERT(`bP`,4,2,' ') FROM `sS`;
SELECT INSERT(`bP`,5,1,' ') FROM `sS`;
SELECT INSERT(`bP`,1,1,'©') FROM `sT`;
SELECT INSERT(`bP`,1,2,'©«') FROM `sT`;
SELECT INSERT(`bP`,1,3,'©«') FROM `sT`;
SELECT INSERT(`bP`,1,4,'©«¯') FROM `sT`;
SELECT INSERT(`bP`,1,5,'©«¯±') FROM `sT`;
SELECT INSERT(`bP`,2,1,'«') FROM `sT`;
SELECT INSERT(`bP`,2,2,'«') FROM `sT`;
SELECT INSERT(`bP`,2,3,'«¯') FROM `sT`;
SELECT INSERT(`bP`,2,4,'«¯±') FROM `sT`;
SELECT INSERT(`bP`,3,1,'') FROM `sT`;
SELECT INSERT(`bP`,3,2,'¯') FROM `sT`;
SELECT INSERT(`bP`,3,3,'¯±') FROM `sT`;
SELECT INSERT(`bP`,4,1,'¯') FROM `sT`;
SELECT INSERT(`bP`,4,2,'¯±') FROM `sT`;
SELECT INSERT(`bP`,5,1,'±') FROM `sT`;
SELECT INSERT(`bP`,1,1,'@') FROM `sT`;
SELECT INSERT(`bP`,1,2,'@@') FROM `sT`;
SELECT INSERT(`bP`,1,3,'@@@') FROM `sT`;
SELECT INSERT(`bP`,1,4,'@@@@') FROM `sT`;
SELECT INSERT(`bP`,1,5,'@@@@@') FROM `sT`;
SELECT INSERT(`bP`,2,1,'@') FROM `sT`;
SELECT INSERT(`bP`,2,2,'@@') FROM `sT`;
SELECT INSERT(`bP`,2,3,'@@@') FROM `sT`;
SELECT INSERT(`bP`,2,4,'@@@@') FROM `sT`;
SELECT INSERT(`bP`,3,1,'@') FROM `sT`;
SELECT INSERT(`bP`,3,2,'@@') FROM `sT`;
SELECT INSERT(`bP`,3,3,'@@@') FROM `sT`;
SELECT INSERT(`bP`,4,1,'@') FROM `sT`;
SELECT INSERT(`bP`,4,2,'@@') FROM `sT`;
SELECT INSERT(`bP`,5,1,'@') FROM `sT`;
SELECT INSERT(`bP`,1,1,'\') FROM `sU`;
SELECT INSERT(`bP`,1,2,'\\' ) FROM `sU`;
SELECT INSERT(`bP`,1,3,'\\\' ) FROM `sU`;
SELECT INSERT(`bP`,1,4,'\\\\' ) FROM `sU`;
SELECT INSERT(`bP`,1,5,'\\\\\' ) FROM `sU`;
SELECT INSERT(`bP`,2,1,'\') FROM `sU`;
SELECT INSERT(`bP`,2,2,'\\') FROM `sU`;
SELECT INSERT(`bP`,2,3,'\\\' ) FROM `sU`;
SELECT INSERT(`bP`,2,4,'\\\\' ) FROM `sU`;
SELECT INSERT(`bP`,3,1,'\') FROM `sU`;
SELECT INSERT(`bP`,3,2,'\\' ) FROM `sU`;
SELECT INSERT(`bP`,3,3,'\\\' ) FROM `sU`;
SELECT INSERT(`bP`,4,1,'\') FROM `sU`;
SELECT INSERT(`bP`,4,2,'\\' ) FROM `sU`;
SELECT INSERT(`bP`,5,1,'\') FROM `sU`;
#MEMORY
SELECT INSERT(`bP`,1,1,'¶') FROM `sV`;
SELECT INSERT(`bP`,1,2,'¶·') FROM `sV`;
SELECT INSERT(`bP`,1,3,'¶·¸') FROM `sV`;
SELECT INSERT(`bP`,1,4,'¶·¸¹') FROM `sV`;
SELECT INSERT(`bP`,1,5,'¶·¸¹º') FROM `sV`;
SELECT INSERT(`bP`,2,1,'·') FROM `sV`;
SELECT INSERT(`bP`,2,2,'·¸') FROM `sV`;
SELECT INSERT(`bP`,2,3,'·¸¹') FROM `sV`;
SELECT INSERT(`bP`,2,4,'·¸¹º') FROM `sV`;
SELECT INSERT(`bP`,3,1,'¸') FROM `sV`;
SELECT INSERT(`bP`,3,2,'¸¹') FROM `sV`;
SELECT INSERT(`bP`,3,3,'¸¹º') FROM `sV`;
SELECT INSERT(`bP`,4,1,'¹') FROM `sV`;
SELECT INSERT(`bP`,4,2,'¹º') FROM `sV`;
SELECT INSERT(`bP`,5,1,'º') FROM `sV`;
SELECT INSERT(`bP`,1,1,' ') FROM `sV`;
SELECT INSERT(`bP`,1,2,' ') FROM `sV`;
SELECT INSERT(`bP`,1,3,' ') FROM `sV`;
SELECT INSERT(`bP`,1,4,' ') FROM `sV`;
SELECT INSERT(`bP`,1,5,' ') FROM `sV`;
SELECT INSERT(`bP`,2,1,' ') FROM `sV`;
SELECT INSERT(`bP`,2,2,' ') FROM `sV`;
SELECT INSERT(`bP`,2,3,' ') FROM `sV`;
SELECT INSERT(`bP`,2,4,' ') FROM `sV`;
SELECT INSERT(`bP`,3,1,' ') FROM `sV`;
SELECT INSERT(`bP`,3,2,' ') FROM `sV`;
SELECT INSERT(`bP`,3,3,' ') FROM `sV`;
SELECT INSERT(`bP`,4,1,' ') FROM `sV`;
SELECT INSERT(`bP`,4,2,' ') FROM `sV`;
SELECT INSERT(`bP`,5,1,' ') FROM `sV`;
SELECT INSERT(`bP`,1,1,'©') FROM `sW`;
SELECT INSERT(`bP`,1,2,'©«') FROM `sW`;
SELECT INSERT(`bP`,1,3,'©«') FROM `sW`;
SELECT INSERT(`bP`,1,4,'©«¯') FROM `sW`;
SELECT INSERT(`bP`,1,5,'©«¯±') FROM `sW`;
SELECT INSERT(`bP`,2,1,'«') FROM `sW`;
SELECT INSERT(`bP`,2,2,'«') FROM `sW`;
SELECT INSERT(`bP`,2,3,'«¯') FROM `sW`;
SELECT INSERT(`bP`,2,4,'«¯±') FROM `sW`;
SELECT INSERT(`bP`,3,1,'') FROM `sW`;
SELECT INSERT(`bP`,3,2,'¯') FROM `sW`;
SELECT INSERT(`bP`,3,3,'¯±') FROM `sW`;
SELECT INSERT(`bP`,4,1,'¯') FROM `sW`;
SELECT INSERT(`bP`,4,2,'¯±') FROM `sW`;
SELECT INSERT(`bP`,5,1,'±') FROM `sW`;
SELECT INSERT(`bP`,1,1,'@') FROM `sW`;
SELECT INSERT(`bP`,1,2,'@@') FROM `sW`;
SELECT INSERT(`bP`,1,3,'@@@') FROM `sW`;
SELECT INSERT(`bP`,1,4,'@@@@') FROM `sW`;
SELECT INSERT(`bP`,1,5,'@@@@@') FROM `sW`;
SELECT INSERT(`bP`,2,1,'@') FROM `sW`;
SELECT INSERT(`bP`,2,2,'@@') FROM `sW`;
SELECT INSERT(`bP`,2,3,'@@@') FROM `sW`;
SELECT INSERT(`bP`,2,4,'@@@@') FROM `sW`;
SELECT INSERT(`bP`,3,1,'@') FROM `sW`;
SELECT INSERT(`bP`,3,2,'@@') FROM `sW`;
SELECT INSERT(`bP`,3,3,'@@@') FROM `sW`;
SELECT INSERT(`bP`,4,1,'@') FROM `sW`;
SELECT INSERT(`bP`,4,2,'@@') FROM `sW`;
SELECT INSERT(`bP`,5,1,'@') FROM `sW`;
SELECT INSERT(`bP`,1,1,'\') FROM `sX`;
SELECT INSERT(`bP`,1,2,'\\' ) FROM `sX`;
SELECT INSERT(`bP`,1,3,'\\\' ) FROM `sX`;
SELECT INSERT(`bP`,1,4,'\\\\' ) FROM `sX`;
SELECT INSERT(`bP`,1,5,'\\\\\' ) FROM `sX`;
SELECT INSERT(`bP`,2,1,'\') FROM `sX`;
SELECT INSERT(`bP`,2,2,'\\' ) FROM `sX`;
SELECT INSERT(`bP`,2,3,'\\\' ) FROM `sX`;
SELECT INSERT(`bP`,2,4,'\\\\' ) FROM `sX`;
SELECT INSERT(`bP`,3,1,'\') FROM `sX`;
SELECT INSERT(`bP`,3,2,'\\' ) FROM `sX`;
SELECT INSERT(`bP`,3,3,'\\\' ) FROM `sX`;
SELECT INSERT(`bP`,4,1,'\') FROM `sX`;
SELECT INSERT(`bP`,4,2,'\\' ) FROM `sX`;
SELECT INSERT(`bP`,5,1,'\') FROM `sX`;
DROP TABLE `sP`;
DROP TABLE `sQ`;
DROP TABLE `sR`;
DROP TABLE `sS`;
DROP TABLE `sT`;
DROP TABLE `sU`;
DROP TABLE `sV`;
DROP TABLE `sW`;
DROP TABLE `sX`;