← Back to branch summary

~drizzle-trunk/drizzle/development

1 by brian
clean slate 
1
 
--disable_warnings

2
 
drop table if exists `Ｔ１`;

3
 
drop table if exists `Ｔ２`;

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
 
--enable_warnings

15
 









16



#










17



# Test RIGHT() function with Japanese character in utf8 encoding










18



#










19












20



SET NAMES utf8;










21



SET character_set_database = utf8;










22












23



CREATE TABLE `Ｔ１` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = innodb;










24



CREATE TABLE `Ｔ２` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = innodb;










25



CREATE TABLE `Ｔ３` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = innodb;










26



CREATE TABLE `Ｔ４` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = myisam;










27



CREATE TABLE `Ｔ５` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = myisam;










28



CREATE TABLE `Ｔ６` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = myisam;










29



CREATE TABLE `Ｔ７` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = heap;










30



CREATE TABLE `Ｔ８` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = heap;










31



CREATE TABLE `Ｔ９` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = heap;










32



CREATE TABLE `Ｔ１０` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = bdb;










33



CREATE TABLE `Ｔ１１` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = bdb;










34



CREATE TABLE `Ｔ１２` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = bdb;










35












36



INSERT INTO `Ｔ１` VALUES ('ｱｲｳｴｵ'),('ｱｲｳｴ'),('ｱｲｳ'),('ｱｲ'),('ｱ'),('');










37



INSERT INTO `Ｔ２` VALUES ('あいうえお'),('あいうえ'),('あいう'),('あい'),('あ'),('');










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












49



#InnoDB










50



SELECT `Ｃ１`, RIGHT(`Ｃ１`,0) FROM `Ｔ１`;










51



SELECT `Ｃ１`, RIGHT(`Ｃ１`,1) FROM `Ｔ１`;










52



SELECT `Ｃ１`, RIGHT(`Ｃ１`,2) FROM `Ｔ１`;










53



SELECT `Ｃ１`, RIGHT(`Ｃ１`,3) FROM `Ｔ１`;










54



SELECT `Ｃ１`, RIGHT(`Ｃ１`,4) FROM `Ｔ１`;










55



SELECT `Ｃ１`, RIGHT(`Ｃ１`,5) FROM `Ｔ１`;










56



SELECT `Ｃ１`, RIGHT(`Ｃ１`,0) FROM `Ｔ２`;










57



SELECT `Ｃ１`, RIGHT(`Ｃ１`,1) FROM `Ｔ２`;










58



SELECT `Ｃ１`, RIGHT(`Ｃ１`,2) FROM `Ｔ２`;










59



SELECT `Ｃ１`, RIGHT(`Ｃ１`,3) FROM `Ｔ２`;










60



SELECT `Ｃ１`, RIGHT(`Ｃ１`,4) FROM `Ｔ２`;










61



SELECT `Ｃ１`, RIGHT(`Ｃ１`,5) FROM `Ｔ２`;










62



SELECT `Ｃ１`, RIGHT(`Ｃ１`,0) FROM `Ｔ３`;










63



SELECT `Ｃ１`, RIGHT(`Ｃ１`,1) FROM `Ｔ３`;










64



SELECT `Ｃ１`, RIGHT(`Ｃ１`,2) FROM `Ｔ３`;










65



SELECT `Ｃ１`, RIGHT(`Ｃ１`,3) FROM `Ｔ３`;










66



SELECT `Ｃ１`, RIGHT(`Ｃ１`,4) FROM `Ｔ３`;










67



SELECT `Ｃ１`, RIGHT(`Ｃ１`,5) FROM `Ｔ３`;










68












69



#MyISAM










70



SELECT `Ｃ１`, RIGHT(`Ｃ１`,0) FROM `Ｔ４`;










71



SELECT `Ｃ１`, RIGHT(`Ｃ１`,1) FROM `Ｔ４`;










72



SELECT `Ｃ１`, RIGHT(`Ｃ１`,2) FROM `Ｔ４`;










73



SELECT `Ｃ１`, RIGHT(`Ｃ１`,3) FROM `Ｔ４`;










74



SELECT `Ｃ１`, RIGHT(`Ｃ１`,4) FROM `Ｔ４`;










75



SELECT `Ｃ１`, RIGHT(`Ｃ１`,5) FROM `Ｔ４`;










76



SELECT `Ｃ１`, RIGHT(`Ｃ１`,0) FROM `Ｔ５`;










77



SELECT `Ｃ１`, RIGHT(`Ｃ１`,1) FROM `Ｔ５`;










78



SELECT `Ｃ１`, RIGHT(`Ｃ１`,2) FROM `Ｔ５`;










79



SELECT `Ｃ１`, RIGHT(`Ｃ１`,3) FROM `Ｔ５`;










80



SELECT `Ｃ１`, RIGHT(`Ｃ１`,4) FROM `Ｔ５`;










81



SELECT `Ｃ１`, RIGHT(`Ｃ１`,5) FROM `Ｔ５`;










82



SELECT `Ｃ１`, RIGHT(`Ｃ１`,0) FROM `Ｔ６`;










83



SELECT `Ｃ１`, RIGHT(`Ｃ１`,1) FROM `Ｔ６`;










84



SELECT `Ｃ１`, RIGHT(`Ｃ１`,2) FROM `Ｔ６`;










85



SELECT `Ｃ１`, RIGHT(`Ｃ１`,3) FROM `Ｔ６`;










86



SELECT `Ｃ１`, RIGHT(`Ｃ１`,4) FROM `Ｔ６`;










87



SELECT `Ｃ１`, RIGHT(`Ｃ１`,5) FROM `Ｔ６`;










88












89



#HEAP










90



SELECT `Ｃ１`, RIGHT(`Ｃ１`,0) FROM `Ｔ７`;










91



SELECT `Ｃ１`, RIGHT(`Ｃ１`,1) FROM `Ｔ７`;










92



SELECT `Ｃ１`, RIGHT(`Ｃ１`,2) FROM `Ｔ７`;










93



SELECT `Ｃ１`, RIGHT(`Ｃ１`,3) FROM `Ｔ７`;










94



SELECT `Ｃ１`, RIGHT(`Ｃ１`,4) FROM `Ｔ７`;










95



SELECT `Ｃ１`, RIGHT(`Ｃ１`,5) FROM `Ｔ７`;










96



SELECT `Ｃ１`, RIGHT(`Ｃ１`,0) FROM `Ｔ８`;










97



SELECT `Ｃ１`, RIGHT(`Ｃ１`,1) FROM `Ｔ８`;










98



SELECT `Ｃ１`, RIGHT(`Ｃ１`,2) FROM `Ｔ８`;










99



SELECT `Ｃ１`, RIGHT(`Ｃ１`,3) FROM `Ｔ８`;










100



SELECT `Ｃ１`, RIGHT(`Ｃ１`,4) FROM `Ｔ８`;










101



SELECT `Ｃ１`, RIGHT(`Ｃ１`,5) FROM `Ｔ８`;










102



SELECT `Ｃ１`, RIGHT(`Ｃ１`,0) FROM `Ｔ９`;










103



SELECT `Ｃ１`, RIGHT(`Ｃ１`,1) FROM `Ｔ９`;










104



SELECT `Ｃ１`, RIGHT(`Ｃ１`,2) FROM `Ｔ９`;










105



SELECT `Ｃ１`, RIGHT(`Ｃ１`,3) FROM `Ｔ９`;










106



SELECT `Ｃ１`, RIGHT(`Ｃ１`,4) FROM `Ｔ９`;










107



SELECT `Ｃ１`, RIGHT(`Ｃ１`,5) FROM `Ｔ９`;










108












109



#BDB










110



SELECT `Ｃ１`, RIGHT(`Ｃ１`,0) FROM `Ｔ１０`;










111



SELECT `Ｃ１`, RIGHT(`Ｃ１`,1) FROM `Ｔ１０`;










112



SELECT `Ｃ１`, RIGHT(`Ｃ１`,2) FROM `Ｔ１０`;










113



SELECT `Ｃ１`, RIGHT(`Ｃ１`,3) FROM `Ｔ１０`;










114



SELECT `Ｃ１`, RIGHT(`Ｃ１`,4) FROM `Ｔ１０`;










115



SELECT `Ｃ１`, RIGHT(`Ｃ１`,5) FROM `Ｔ１０`;










116



SELECT `Ｃ１`, RIGHT(`Ｃ１`,0) FROM `Ｔ１１`;










117



SELECT `Ｃ１`, RIGHT(`Ｃ１`,1) FROM `Ｔ１１`;










118



SELECT `Ｃ１`, RIGHT(`Ｃ１`,2) FROM `Ｔ１１`;










119



SELECT `Ｃ１`, RIGHT(`Ｃ１`,3) FROM `Ｔ１１`;










120



SELECT `Ｃ１`, RIGHT(`Ｃ１`,4) FROM `Ｔ１１`;










121



SELECT `Ｃ１`, RIGHT(`Ｃ１`,5) FROM `Ｔ１１`;










122



SELECT `Ｃ１`, RIGHT(`Ｃ１`,0) FROM `Ｔ１２`;










123



SELECT `Ｃ１`, RIGHT(`Ｃ１`,1) FROM `Ｔ１２`;










124



SELECT `Ｃ１`, RIGHT(`Ｃ１`,2) FROM `Ｔ１２`;










125



SELECT `Ｃ１`, RIGHT(`Ｃ１`,3) FROM `Ｔ１２`;










126



SELECT `Ｃ１`, RIGHT(`Ｃ１`,4) FROM `Ｔ１２`;










127



SELECT `Ｃ１`, RIGHT(`Ｃ１`,5) FROM `Ｔ１２`;










128












129



DROP TABLE `Ｔ１`;










130



DROP TABLE `Ｔ２`;










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 `Ｔ１２`;