← Back to branch summary

~drizzle-trunk/drizzle/development

1 by brian
clean slate 
1
 
--source include/have_ujis.inc

2
 









3



--disable_warnings










4



drop table if exists `£Ô£±`;










5



drop table if exists `£Ô£²`;










6



drop table if exists `£Ô£³`;










7



drop table if exists `£Ô£Ž`;










8



drop table if exists `£Ô£µ`;










9



drop table if exists `£Ô£¶`;










10



drop table if exists `£Ô£·`;










11



drop table if exists `£Ô£ž`;










12



drop table if exists `£Ô£¹`;










13



drop table if exists `£Ô£±£°`;










14



drop table if exists `£Ô£±£±`;










15



drop table if exists `£Ô£±£²`;










16



--enable_warnings










17












18



#










19



# Test LEFT() function with Japanese character in ujis encoding










20



#










21












22



SET NAMES ujis;










23



SET character_set_database = ujis;










24












25



CREATE TABLE `£Ô£±` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = innodb;










26



CREATE TABLE `£Ô£²` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = innodb;










27



CREATE TABLE `£Ô£³` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = innodb;










28



CREATE TABLE `£Ô£Ž` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = myisam;










29



CREATE TABLE `£Ô£µ` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = myisam;










30



CREATE TABLE `£Ô£¶` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = myisam;










31



CREATE TABLE `£Ô£·` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = heap;










32



CREATE TABLE `£Ô£ž` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = heap;










33



CREATE TABLE `£Ô£¹` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = heap;










34



CREATE TABLE `£Ô£±£°` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = bdb;










35



CREATE TABLE `£Ô£±£±` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = bdb;










36



CREATE TABLE `£Ô£±£²` (`£Ã£±` char(5), INDEX(`£Ã£±`)) DEFAULT CHARSET = ujis engine = bdb;










37












38



INSERT INTO `£Ô£±` VALUES ('Ž±Ž²Ž³ŽŽŽµ'),('Ž±Ž²Ž³ŽŽ'),('Ž±Ž²Ž³'),('Ž±Ž²'),('Ž±'),('');










39



INSERT INTO `£Ô£²` VALUES ('€¢€€€Š€š€ª'),('€¢€€€Š€š'),('€¢€€€Š'),('€¢€€'),('€¢'),('');










40



INSERT INTO `£Ô£³` VALUES ('í܏íݏíޏíߏíà'),('í܏íݏíޏíß'),('í܏íݏíÞ'),('í܏íÝ'),('íÜ'),('');










41



INSERT INTO `£Ô£Ž` VALUES ('Ž±Ž²Ž³ŽŽŽµ'),('Ž±Ž²Ž³ŽŽ'),('Ž±Ž²Ž³'),('Ž±Ž²'),('Ž±'),('');










42



INSERT INTO `£Ô£µ` VALUES ('€¢€€€Š€š€ª'),('€¢€€€Š€š'),('€¢€€€Š'),('€¢€€'),('€¢'),('');










43



INSERT INTO `£Ô£¶` VALUES ('í܏íݏíޏíߏíà'),('í܏íݏíޏíß'),('í܏íݏíÞ'),('í܏íÝ'),('íÜ'),('');










44



INSERT INTO `£Ô£·` VALUES ('Ž±Ž²Ž³ŽŽŽµ'),('Ž±Ž²Ž³ŽŽ'),('Ž±Ž²Ž³'),('Ž±Ž²'),('Ž±'),('');










45



INSERT INTO `£Ô£ž` VALUES ('€¢€€€Š€š€ª'),('€¢€€€Š€š'),('€¢€€€Š'),('€¢€€'),('€¢'),('');










46



INSERT INTO `£Ô£¹` VALUES ('í܏íݏíޏíߏíà'),('í܏íݏíޏíß'),('í܏íݏíÞ'),('í܏íÝ'),('íÜ'),('');










47



INSERT INTO `£Ô£±£°` VALUES ('Ž±Ž²Ž³ŽŽŽµ'),('Ž±Ž²Ž³ŽŽ'),('Ž±Ž²Ž³'),('Ž±Ž²'),('Ž±'),('');










48



INSERT INTO `£Ô£±£±` VALUES ('€¢€€€Š€š€ª'),('€¢€€€Š€š'),('€¢€€€Š'),('€¢€€'),('€¢'),('');










49



INSERT INTO `£Ô£±£²` VALUES ('í܏íݏíޏíߏíà'),('í܏íݏíޏíß'),('í܏íݏíÞ'),('í܏íÝ'),('íÜ'),('');










50












51



#InnoDB










52



SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£±`;










53



SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£±`;










54



SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£±`;










55



SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£±`;










56



SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£±`;










57



SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£±`;










58



SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£²`;










59



SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£²`;










60



SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£²`;










61



SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£²`;










62



SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£²`;










63



SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£²`;










64



SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£³`;










65



SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£³`;










66



SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£³`;










67



SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£³`;










68



SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£³`;










69



SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£³`;










70












71



#MyISAM










72



SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£Ž`;










73



SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£Ž`;










74



SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£Ž`;










75



SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£Ž`;










76



SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£Ž`;










77



SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£Ž`;










78



SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£µ`;










79



SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£µ`;










80



SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£µ`;










81



SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£µ`;










82



SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£µ`;










83



SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£µ`;










84



SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£¶`;










85



SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£¶`;










86



SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£¶`;










87



SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£¶`;










88



SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£¶`;










89



SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£¶`;










90












91



#HEAP










92



SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£·`;










93



SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£·`;










94



SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£·`;










95



SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£·`;










96



SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£·`;










97



SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£·`;










98



SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£ž`;










99



SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£ž`;










100



SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£ž`;










101



SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£ž`;










102



SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£ž`;










103



SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£ž`;










104



SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£¹`;










105



SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£¹`;










106



SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£¹`;










107



SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£¹`;










108



SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£¹`;










109



SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£¹`;










110












111



#BDB










112



SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£±£°`;










113



SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£±£°`;










114



SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£±£°`;










115



SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£±£°`;










116



SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£±£°`;










117



SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£±£°`;










118



SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£±£±`;










119



SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£±£±`;










120



SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£±£±`;










121



SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£±£±`;










122



SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£±£±`;










123



SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£±£±`;










124



SELECT `£Ã£±`, LEFT(`£Ã£±`,0) FROM `£Ô£±£²`;










125



SELECT `£Ã£±`, LEFT(`£Ã£±`,1) FROM `£Ô£±£²`;










126



SELECT `£Ã£±`, LEFT(`£Ã£±`,2) FROM `£Ô£±£²`;










127



SELECT `£Ã£±`, LEFT(`£Ã£±`,3) FROM `£Ô£±£²`;










128



SELECT `£Ã£±`, LEFT(`£Ã£±`,4) FROM `£Ô£±£²`;










129



SELECT `£Ã£±`, LEFT(`£Ã£±`,5) FROM `£Ô£±£²`;










130












131



DROP TABLE `£Ô£±`;










132



DROP TABLE `£Ô£²`;










133



DROP TABLE `£Ô£³`;










134



DROP TABLE `£Ô£Ž`;










135



DROP TABLE `£Ô£µ`;










136



DROP TABLE `£Ô£¶`;










137



DROP TABLE `£Ô£·`;










138



DROP TABLE `£Ô£ž`;










139



DROP TABLE `£Ô£¹`;










140



DROP TABLE `£Ô£±£°`;










141



DROP TABLE `£Ô£±£±`;










142



DROP TABLE `£Ô£±£²`;