diff options
| author | unknown <serg@serg.mylan> | 2004-08-13 18:29:25 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2004-08-13 18:29:25 +0200 |
| commit | b6f6d5b2fd920c5f8c8e611c9b58b43077b21f8d (patch) | |
| tree | 9f1d56d26b0dc04c637b834bdb89d3d7be9af018 /mysql-test/t/key.test | |
| parent | 4a0f586bc735abb1b9d0129210ab349cfb629d40 (diff) | |
| download | mariadb-git-b6f6d5b2fd920c5f8c8e611c9b58b43077b21f8d.tar.gz | |
apply UNIQUE constrain correctly for multi-byte charsets
only MyISAM is fixed
include/m_ctype.h:
my_charpos() macro
myisam/mi_key.c:
apply UNIQUE constrain correctly for multi-byte charsets
mysql-test/r/binary.result:
new test
mysql-test/r/key.result:
apply UNIQUE constrain correctly for multi-byte charsets
mysql-test/t/binary.test:
new test
mysql-test/t/func_gconcat.test:
make test to pass w/o InnoDB
mysql-test/t/key.test:
apply UNIQUE constrain correctly for multi-byte charsets
Diffstat (limited to 'mysql-test/t/key.test')
| -rw-r--r-- | mysql-test/t/key.test | 26 |
1 files changed, 25 insertions, 1 deletions
diff --git a/mysql-test/t/key.test b/mysql-test/t/key.test index 8d399abfec9..ce10f07cf07 100644 --- a/mysql-test/t/key.test +++ b/mysql-test/t/key.test @@ -97,7 +97,7 @@ CREATE TABLE t1 ( PRIMARY KEY (name,author,category) ); INSERT INTO t1 VALUES -('patnom','patauteur',0,'p.favre@cryo-networks.fr',NULL,NULL,'#p2sndnq6ae5g1u6t','essai\nsalut','scol://195.242.78.119:patauteur.patnom',NULL,NULL,NULL,950036174,-882087474,NULL,3,0,3,'1','Pub/patnom/futur_divers.scs',NULL,'pat','CC1'); +('patnom','patauteur',0,'p.favre@cryo-networks.fr',NULL,NULL,'#p2sndnq6ae5g1u6t','essai salut','scol://195.242.78.119:patauteur.patnom',NULL,NULL,NULL,950036174,-882087474,NULL,3,0,3,'1','Pub/patnom/futur_divers.scs',NULL,'pat','CC1'); INSERT INTO t1 VALUES ('LeNomDeMonSite','Marc',0,'m.barilley@cryo-networks.fr',NULL,NULL,NULL,NULL,'scol://195.242.78.119:Marc.LeNomDeMonSite',NULL,NULL,NULL,950560434,-881563214,NULL,3,0,3,'1','Pub/LeNomDeMonSite/domus_hibere.scs',NULL,'Marq','CC1'); select * from t1 where name='patnom' and author='patauteur' and category=0; @@ -228,3 +228,27 @@ EXPLAIN SELECT numeropost FROM t1 WHERE numreponse='1'; FLUSH TABLES; SELECT numeropost FROM t1 WHERE numreponse='1'; drop table t1; + +# +# UNIQUE prefix keys and multi-byte charsets +# + +create table t1 (c varchar(30) character set utf8, t text character set utf8, unique (c(2)), unique (t(3))) engine=myisam; +show create table t1; +insert t1 values ('cccc', 'tttt'), + (0xD0B1212223D0B1D0B1D0B1D0B1D0B1, 0xD0B1D0B1212223D0B1D0B1D0B1D0B1), + (0xD0B1222123D0B1D0B1D0B1D0B1D0B1, 0xD0B1D0B1222123D0B1D0B1D0B1D0B1); +--error 1062 +insert t1 (c) values ('cc22'); +--error 1062 +insert t1 (t) values ('ttt22'); +--error 1062 +insert t1 (c) values (0xD0B1212322D0B1D0B1D0B1D0B1D0B1); +--error 1062 +insert t1 (t) values (0xD0B1D0B1212322D0B1D0B1D0B1D0B1); +select c from t1 where c='cccc'; +select t from t1 where t='tttt'; +select c from t1 where c=0xD0B1212223D0B1D0B1D0B1D0B1D0B1; +select t from t1 where t=0xD0B1D0B1212223D0B1D0B1D0B1D0B1; +drop table t1; + |