unique key and utf8

am 30.06.2004 20:37:21 von Linus Upson

VGhlIGZvbGxvd2luZyB3YXMgdGVzdGVkIHdpdGggTXlTUUwgNC4xLjEgcnVu bmluZyBvbiBSZWRI
YXQgRVMgMy4gVGhpcyBtZXNzYWdlIHdhcyBzZW50IGluIFVURi04Lg0KDQpU aGUgdW5pcXVlIGtl
eSBpbmRleCBwcmVmaXggbGVuZ3RoIGlzIG1pc2xlYWRpbmcgd2hlbiB5b3Ug dXNlIHRoZSB1dGY4
IGNoYXJhY3RlciBzZXQuIElmIHlvdSBzcGVjaWZ5IGEgcHJlZml4IG9mIE4g Y2hhcmFjdGVycyB0
aGUgdW5pcXVlbmVzcyBjb25zdHJhaW50IGFwcGVhcnMgdG8gYmUgZW5mb3Jj ZWQgZm9yIHRoZSBm
aXJzdCAzKk4gYnl0ZXMgb2YgY29sdW1uLCBub3QgdGhlIGZpcnN0IE4gY2hh cmFjdGVycy4gSSBh
c3N1bWUgdGhlIGNvbnN0YW50IDMgY29tZXMgZnJvbSB0aGUgZmFjdCB0aGF0 IG15c3FsIHVzZXMg
YSBtYXhpbXVtIG9mIDMgYnl0ZXMgdG8gZW5jb2RlIGEgdXRmOCBjaGFyYWN0 ZXIuDQoNClRoZSBm
b2xsb3dpbmcgZXhhbXBsZSBkZW1vbnN0cmF0ZXMgdGhlIHByb2JsZW06DQoN CkNSRUFURSBUQUJM
RSBgdGAgKA0KICBgY2AgdmFyY2hhcigyMCkgTk9UIE5VTEwgZGVmYXVsdCAn JywNCiAgVU5JUVVF
IEtFWSBgY2AgKGBjYCgxKSkNCikgVFlQRT1NeUlTQU0gREVGQVVMVCBDSEFS U0VUPXV0ZjgNCg0K
aW5zZXJ0IGludG8gYHRgIHZhbHVlcyAoJzEyMzQ1Jyk7DQppbnNlcnQgaW50 byBgdGAgdmFsdWVz
ICgnMS0tLS0nKTsNCmluc2VydCBpbnRvIGB0YCB2YWx1ZXMgKCcxMi0tLScp Ow0KaW5zZXJ0IGlu
dG8gYHRgIHZhbHVlcyAoJzEyMy0tJyk7DQojIEVSUk9SIDEwNjIgKDIzMDAw KTogRHVwbGljYXRl
IGVudHJ5ICcxMjMnIGZvciBrZXkgMQ0KDQppbnNlcnQgaW50byBgdGAgdmFs dWVzICgnZsO8Jyk7
DQppbnNlcnQgaW50byBgdGAgdmFsdWVzICgnZsO8YmFyJyk7DQojIEVSUk9S IDEwNjIgKDIzMDAw
KTogRHVwbGljYXRlIGVudHJ5ICdmw7wnIGZvciBrZXkgMQ0KDQpFdmVuIHRo b3VnaCB0aGUgdW5p
cXVlIHByZWZpeCBpcyBzcGVjaWZpZWQgYXMgMSBjaGFyYWN0ZXIsIHRoZSBm aXJzdCBzZXQgb2Yg
aW5zZXJ0IHN0YXRlbWVudHMgc2hvdyB0aGF0IG15c3FsIHdvbid0IGRldGVj dCBhIGR1cGxpY2F0
ZSBlbnRyeSB1bnRpbCB5b3UgdHJ5IHRvIGluc2VydCAzIEFTQ0lJIGNoYXJh Y3RlcnMuIFRoZSBz
ZWNvbmQgc2V0IG9mIGluc2VydCBzdGF0ZW1lbnRzIHNob3cgdGhhdCBteXNx bCB3aWxsIGhpdCB0
aGUgdW5pcXVlbmVzcyBjb25zdHJhaW50IGF0IDIgY2hhcmFjdGVycyBpZiBv bmUgb2YgdGhlbSBp
cyBlbmNvZGVkIHdpdGggdHdvIHV0ZjggYnl0ZXMuIEl0IGlzIGFsc28gcG9z c2libGUgZm9yIHRo
ZSBpbmRleCBjb3ZlciBvbmx5IHBhcnQgb2YgYSBtdWx0aWJ5dGUgZW5jb2Rl ZCBjaGFyYWN0ZXIu
DQoNCkkgZGlzY292ZXJlZCB0aGlzIHByb2JsZW0gYmVjYXVzZSBteXNxbCBz aWxlbnRseSBzaG9y
dGVuZWQgdGhlIHVuaXF1ZSBpbmRleCBwcmVmaXggb24gb25lIG9mIG15IHV0 ZjggdmFyY2hhciBj
b2x1bW5zLiBXaGVuIEkgZXhlY3V0ZSB0aGUgZm9sbG93aW5nIHN0YXRlbWVu dDoNCg0KQ1JFQVRF
IFRBQkxFIGB0YCAoDQogIGBjYCB2YXJjaGFyKDE1MCkgTk9UIE5VTEwgZGVm YXVsdCAnJywNCiAg
VU5JUVVFIEtFWSBgY2AgKGBjYCgxNTApKQ0KKSBUWVBFPU15SVNBTSBERUZB VUxUIENIQVJTRVQ9
dXRmOA0KDQp0aGVyZSBhcmUgbm8gZXJyb3JzIG9yIHdhcm5pbmdzLCBidXQg dGhlIHJlc3VsdCBp
czoNCg0KbXlzcWw+IHNob3cgY3JlYXRlIHRhYmxlIHQgXEcNCioqKioqKioq KioqKioqKioqKioq
KioqKioqKiAxLiByb3cgKioqKioqKioqKioqKioqKioqKioqKioqKioqDQog ICAgICAgVGFibGU6
IHQNCkNyZWF0ZSBUYWJsZTogQ1JFQVRFIFRBQkxFIGB0YCAoDQogIGBjYCB2 YXJjaGFyKDE1MCkg
Tk9UIE5VTEwgZGVmYXVsdCAnJywNCiAgVU5JUVVFIEtFWSBgY2AgKGBjYCg2 NCkpDQopIFRZUEU9
TXlJU0FNIERFRkFVTFQgQ0hBUlNFVD11dGY4DQoxIHJvdyBpbiBzZXQgKDAu MDAgc2VjKQ0KDQpU
aGUgMTUwIGNoYXJhY3RlciBwcmVmaXggc2hvdWxkIHN0aWxsIGZpdCB3aXRo aW4gdGhlIDUwMCBi
eXRlIGluZGV4IGxpbWl0IG9mIDQuMS4xIHNpbmNlIDMgKiAxNTAgPSA0NTAs IGJ1dCBmb3Igc29t
ZSByZWFzb24gdGhlIHByZWZpeCBoYXMgYmVlbiByZWR1Y2VkIHRvIDY0Lg0K DQpUaGVyZSBhcmUg
dGhyZWUgcG9zc2libGUgYnVnIHJlcG9ydHM6DQoNCjEuIFNpbmNlIG15c3Fs IHNpbGVudGx5IGNv
bnZlcnRzIHRoZSBpbmRleCBwcmVmaXggZnJvbSBjaGFyYWN0ZXJzIHRvIGJ5 dGVzLCBpdCBpcyBp
bXBvc3NpYmxlIHRvIGhhdmUgYSB1bmlxdWVuZXNzIGNvbnN0cmFpbnQgd2l0 aCBhIHByZWRpY3Rh
YmxlIG51bWJlciBvZiBjaGFyYWN0ZXJzIHVubGVzcyB0aGUgZW50aXJlIGNv bHVtbiBpcyBpbmRl
eGVkIG9yIGEgZml4ZWQgd2lkdGggY2hhcmFjdGVyIGVuY29kaW5nIGlzIHVz ZWQuDQoNCjIuIFRo
ZSBkb2N1bWVudGF0aW9uIGlzbid0IGNsZWFyIGFib3V0IHdoYXQgdGhlIHVu aXF1ZSBpbmRleCBw
cmVmaXggaW1wbGllcyBmb3IgbXVsdGlieXRlIGNoYXJhY3RlciBzZXRzLg0K DQozLiBUaGVyZSBz
aG91bGQgYSB3YXJuaW5nIHdoZW4gbXlzcWwgc2hvcnRlbnMgYSB1bmlxdWUg Y29uc3RyYWludC4g
QW4gZXZlbiBiZXR0ZXIgZml4IHdvdWxkIGhhdmUgbXlzcWwgaW5kZXggdGhl IGVudGlyZSBjb2x1
bW4uDQoNClRoYW5rcywNCkxpbnVzDQo=

Re: unique key and utf8

am 30.06.2004 23:08:57 von Sergei Golubchik

Hi!

On Jun 30, Linus Upson wrote:
> The following was tested with MySQL 4.1.1 running on RedHat ES 3. This
> message was sent in UTF-8.
>
> The unique key index prefix length is misleading when you use the utf8
> character set. If you specify a prefix of N characters the uniqueness
> constraint appears to be enforced for the first 3*N bytes of column,
> not the first N characters.

Oops.
I agree, it's confusing.
We'll fix it.

> I discovered this problem because mysql silently shortened the unique
> index prefix on one of my utf8 varchar columns. When I execute the
> following statement:
>
> CREATE TABLE `t` (
> `c` varchar(150) NOT NULL default '',
> UNIQUE KEY `c` (`c`(150))
> ) TYPE=MyISAM DEFAULT CHARSET=utf8
>
> there are no errors or warnings, but the result is:
>
> mysql> show create table t \G
> *************************** 1. row ***************************
> Table: t
> Create Table: CREATE TABLE `t` (
> `c` varchar(150) NOT NULL default '',
> UNIQUE KEY `c` (`c`(64))
> ) TYPE=MyISAM DEFAULT CHARSET=utf8
> 1 row in set (0.00 sec)
>
> The 150 character prefix should still fit within the 500 byte index
> limit of 4.1.1 since 3 * 150 = 450, but for some reason the prefix has
> been reduced to 64.

I wasn't able to repeat in in MySQL 4.1.3 - index was created as
expected. MySQL *never* silently truncates a UNIQUE index (if it does,
it's a bug).

Regards,
Sergei

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

RE: unique key and utf8

am 04.07.2004 03:47:51 von Linus Upson

------=_NextPart_000_005A_01C4612E.3EA076F0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Many of the mysql test cases fail when I configure 4.1.3 with
'--with-charset=3Dutf8'. The symptoms are similar to the index =
truncation
problem I reported with 4.1.1.

Here is how mysql was configured:

C compiler: gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-34)
C++ compiler: g++ (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-34)
Environment:
System: Linux seek 2.4.21-15.0.2.ELsmp #1 SMP Wed Jun 16 22:52:07 EDT =
2004
i686 i686 i386 GNU/Linux
Architecture: i686

../configure --prefix=3D/home/linus/mysql/utf8 --with-tcp-port=3D8506
--with-unix-socket-path=3D/home/linus/mysql/utf8/tmp/mysql.s ock
--with-charset=3Dutf8

The full test results from the following command are attached.

$ ./mysql-test-run --force > test-utf8.txt

I also tried to configure mysql using the same configure command but =
without
the '--with-charset=3Dutf8' option. More of the tests ran, but it =
eventually
failed with:

....
ctype_mb [ pass ]
ctype_recoding [ pass ]
ctype_sjis [ skipped ]
ERROR: /home/linus/mysql/utf8/mysql-test/var/run/master.pid was not =
created
in 30 seconds; Aborting

I've attached the complete test output as test-default-charset.txt.

Thanks,
Linus

-----Original Message-----
From: Sergei Golubchik [mailto:serg@mysql.com]=20
Sent: Wednesday, June 30, 2004 2:09 PM
To: Linus Upson
Cc: bugs@lists.mysql.com; bar@mysql.com
Subject: Re: unique key and utf8

Hi!

On Jun 30, Linus Upson wrote:
> The following was tested with MySQL 4.1.1 running on RedHat ES 3. This =

> message was sent in UTF-8.
>=20
> The unique key index prefix length is misleading when you use the utf8 =

> character set. If you specify a prefix of N characters the uniqueness=20
> constraint appears to be enforced for the first 3*N bytes of column,=20
> not the first N characters.

Oops.
I agree, it's confusing.
We'll fix it.
=20
> I discovered this problem because mysql silently shortened the unique=20
> index prefix on one of my utf8 varchar columns. When I execute the=20
> following statement:
>=20
> CREATE TABLE `t` (
> `c` varchar(150) NOT NULL default '',
> UNIQUE KEY `c` (`c`(150))
> ) TYPE=3DMyISAM DEFAULT CHARSET=3Dutf8
>=20
> there are no errors or warnings, but the result is:
>=20
> mysql> show create table t \G
> *************************** 1. row ***************************
> Table: t
> Create Table: CREATE TABLE `t` (
> `c` varchar(150) NOT NULL default '',
> UNIQUE KEY `c` (`c`(64))
> ) TYPE=3DMyISAM DEFAULT CHARSET=3Dutf8
> 1 row in set (0.00 sec)
>=20
> The 150 character prefix should still fit within the 500 byte index=20
> limit of 4.1.1 since 3 * 150 =3D 450, but for some reason the prefix =
has=20
> been reduced to 64.

I wasn't able to repeat in in MySQL 4.1.3 - index was created as =
expected.
MySQL *never* silently truncates a UNIQUE index (if it does, it's a =
bug).
=20
Regards,
Sergei

--=20
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/
/_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com

------=_NextPart_000_005A_01C4612E.3EA076F0
Content-Type: text/plain;
name="test-utf8.txt"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="test-utf8.txt"

Installing Test Databases=0A=
Removing Stale Files=0A=
Installing Master Databases=0A=
running ../libexec/mysqld --no-defaults --bootstrap --skip-grant-tables =
--basedir=3D.. --datadir=3Dmysql-test/var/master-data --skip-innodb =
--skip-ndbcluster --skip-bdb =0A=
Installing Slave Databases=0A=
running ../libexec/mysqld --no-defaults --bootstrap --skip-grant-tables =
--basedir=3D.. --datadir=3Dmysql-test/var/slave-data --skip-innodb =
--skip-ndbcluster --skip-bdb =0A=
Manager disabled, skipping manager start.=0A=
Loading Standard Test Databases=0A=
Starting Tests=0A=
=0A=
TEST RESULT=0A=
------------------------------------------=0A=
alias [ fail ]=0A=
=0A=
Errors are (from =
/home/linus/mysql/utf8/mysql-test/var/log/mysqltest-time) :=0A=
/home/linus/mysql/utf8/bin/mysqltest: At line 65: query 'SELECT =
ELT(FIELD(kundentyp,'PP','PPA','PG','PGA','FK','FKA','FP','F PA','K','KA',=
'V','VA',''), 'Privat (Private Nutzung)','Privat (Private Nutzung) Sitz =
im Ausland','Privat (geschaeftliche Nutzung)','Privat (geschaeftliche =
Nutzung) Sitz im Ausland','Firma (Kapitalgesellschaft)','Firma =
(Kapitalgesellschaft) Sitz im Ausland','Firma =
(Personengesellschaft)','Firma (Personengesellschaft) Sitz im =
Ausland','oeff. rechtl. Koerperschaft','oeff. rechtl. Koerperschaft Sitz =
im Ausland','Eingetragener Verein','Eingetragener Verein Sitz im =
Ausland','Typ unbekannt') AS Kundentyp ,kategorie FROM t1 WHERE hdl_nr < =
2000000 AND kategorie IN ('Prepaid','Mobilfunk') AND st_klasse =3D =
'Workflow' GROUP BY kundentyp ORDER BY kategorie' failed: 1271: Illegal =
mix of collations for operation 'field'=0A=
(the last lines may be the most important ones)=0A=
=0A=
Ending Tests=0A=
Shutting-down MySQL daemon=0A=
=0A=
Master shutdown finished=0A=
Slave shutdown finished=0A=
Resuming Tests=0A=
=0A=
alter_table [ pass ]=0A=
analyse [ fail ]=0A=
=0A=
Errors are (from =
/home/linus/mysql/utf8/mysql-test/var/log/mysqltest-time) :=0A=
/home/linus/mysql/utf8/bin/mysqltest: At line 41: Result length mismatch=0A=
(the last lines may be the most important ones)=0A=
Below are the diffs between actual and expected results:=0A=
-------------------------------------------------------=0A=
*** r/analyse.result 2004-07-04 03:33:44.000000000 +0300=0A=
--- r/analyse.reject 2004-07-04 04:22:57.000000000 +0300=0A=
***************=0A=
*** 19,31 ****=0A=
test.t1.bool N Y 1 1 0 0 1.0000 NULL ENUM('N','Y') NOT NULL=0A=
test.t1.d 2002-03-03 2002-03-05 10 10 0 0 10.0000 NULL =
ENUM('2002-03-03','2002-03-04','2002-03-05') NOT NULL=0A=
create table t2 select * from t1 procedure analyse();=0A=
select * from t2;=0A=
Field_name Min_value Max_value Min_length Max_length Empties_or_zeros =
Nulls Avg_value_or_avg_length Std Optimal_fieldtype=0A=
! test.t1.i 1 7 1 1 0 0 4.0000 2.2361 ENUM('1','3','5','7') NOT NULL=0A=
! test.t1.j 2 8 1 1 0 0 5.0000 2.2361 ENUM('2','4','6','8') NOT NULL=0A=
test.t1.empty_string 0 0 4 0 0.0000 NULL CHAR(0) NOT NULL=0A=
test.t1.bool N Y 1 1 0 0 1.0000 NULL ENUM('N','Y') NOT NULL=0A=
! test.t1.d 2002-03-03 2002-03-05 10 10 0 0 10.0000 NULL =
ENUM('2002-03-03','2002-03-04','2002-03-05') NOT NULL=0A=
drop table t1,t2;=0A=
EXPLAIN SELECT 1 FROM (SELECT 1) a PROCEDURE ANALYSE();=0A=
id select_type table type possible_keys key key_len ref rows Extra=0A=
--- 19,35 ----=0A=
test.t1.bool N Y 1 1 0 0 1.0000 NULL ENUM('N','Y') NOT NULL=0A=
test.t1.d 2002-03-03 2002-03-05 10 10 0 0 10.0000 NULL =
ENUM('2002-03-03','2002-03-04','2002-03-05') NOT NULL=0A=
create table t2 select * from t1 procedure analyse();=0A=
+ Warnings:=0A=
+ Warning 1265 Data truncated for column 'Optimal_fieldtype' at row 4=0A=
+ Warning 1265 Data truncated for column 'Optimal_fieldtype' at row 4=0A=
+ Warning 1265 Data truncated for column 'Optimal_fieldtype' at row 4=0A=
select * from t2;=0A=
Field_name Min_value Max_value Min_length Max_length Empties_or_zeros =
Nulls Avg_value_or_avg_length Std Optimal_fieldtype=0A=
! test.t1.i 1 7 1 1 0 0 4.0000 2.2361 ENUM('1','3','5','7')=0A=
! test.t1.j 2 8 1 1 0 0 5.0000 2.2361 ENUM('2','4','6','8')=0A=
test.t1.empty_string 0 0 4 0 0.0000 NULL CHAR(0) NOT NULL=0A=
test.t1.bool N Y 1 1 0 0 1.0000 NULL ENUM('N','Y') NOT NULL=0A=
! test.t1.d 2002-03-03 2002-03-05 10 10 0 0 10.0000 NULL =
ENUM('2002-03-03','200=0A=
drop table t1,t2;=0A=
EXPLAIN SELECT 1 FROM (SELECT 1) a PROCEDURE ANALYSE();=0A=
id select_type table type possible_keys key key_len ref rows Extra=0A=
***************=0A=
*** 36,51 ****=0A=
show create table t2;=0A=
Table Create Table=0A=
t2 CREATE TABLE `t2` (=0A=
! `Field_name` char(255) NOT NULL default '',=0A=
! `Min_value` char(255) default NULL,=0A=
! `Max_value` char(255) default NULL,=0A=
`Min_length` bigint(11) NOT NULL default '0',=0A=
`Max_length` bigint(11) NOT NULL default '0',=0A=
`Empties_or_zeros` bigint(11) NOT NULL default '0',=0A=
`Nulls` bigint(11) NOT NULL default '0',=0A=
! `Avg_value_or_avg_length` char(255) NOT NULL default '',=0A=
! `Std` char(255) default NULL,=0A=
! `Optimal_fieldtype` char(64) NOT NULL default ''=0A=
) ENGINE=3DMyISAM DEFAULT CHARSET=3Dlatin1=0A=
select * from t1 where 0=3D1 procedure analyse();=0A=
Field_name Min_value Max_value Min_length Max_length Empties_or_zeros =
Nulls Avg_value_or_avg_length Std Optimal_fieldtype=0A=
--- 40,55 ----=0A=
show create table t2;=0A=
Table Create Table=0A=
t2 CREATE TABLE `t2` (=0A=
! `Field_name` char(85) character set utf8 NOT NULL default '',=0A=
! `Min_value` char(85) character set utf8 default NULL,=0A=
! `Max_value` char(85) character set utf8 default NULL,=0A=
`Min_length` bigint(11) NOT NULL default '0',=0A=
`Max_length` bigint(11) NOT NULL default '0',=0A=
`Empties_or_zeros` bigint(11) NOT NULL default '0',=0A=
`Nulls` bigint(11) NOT NULL default '0',=0A=
! `Avg_value_or_avg_length` char(85) character set utf8 NOT NULL =
default '',=0A=
! `Std` char(85) character set utf8 default NULL,=0A=
! `Optimal_fieldtype` char(22) character set utf8 NOT NULL default ''=0A=
) ENGINE=3DMyISAM DEFAULT CHARSET=3Dlatin1=0A=
select * from t1 where 0=3D1 procedure analyse();=0A=
Field_name Min_value Max_value Min_length Max_length Empties_or_zeros =
Nulls Avg_value_or_avg_length Std Optimal_fieldtype=0A=
***************=0A=
*** 55,70 ****=0A=
show create table t2;=0A=
Table Create Table=0A=
t2 CREATE TABLE `t2` (=0A=
! `Field_name` char(255) NOT NULL default '',=0A=
! `Min_value` char(255) default NULL,=0A=
! `Max_value` char(255) default NULL,=0A=
`Min_length` bigint(11) NOT NULL default '0',=0A=
`Max_length` bigint(11) NOT NULL default '0',=0A=
`Empties_or_zeros` bigint(11) NOT NULL default '0',=0A=
`Nulls` bigint(11) NOT NULL default '0',=0A=
! `Avg_value_or_avg_length` char(255) NOT NULL default '',=0A=
! `Std` char(255) default NULL,=0A=
! `Optimal_fieldtype` char(64) NOT NULL default ''=0A=
) ENGINE=3DMyISAM DEFAULT CHARSET=3Dlatin1=0A=
select * from t2;=0A=
Field_name Min_value Max_value Min_length Max_length Empties_or_zeros =
Nulls Avg_value_or_avg_length Std Optimal_fieldtype=0A=
--- 59,74 ----=0A=
show create table t2;=0A=
Table Create Table=0A=
t2 CREATE TABLE `t2` (=0A=
! `Field_name` char(85) character set utf8 NOT NULL default '',=0A=
! `Min_value` char(85) character set utf8 default NULL,=0A=
! `Max_value` char(85) character set utf8 default NULL,=0A=
`Min_length` bigint(11) NOT NULL default '0',=0A=
`Max_length` bigint(11) NOT NULL default '0',=0A=
`Empties_or_zeros` bigint(11) NOT NULL default '0',=0A=
`Nulls` bigint(11) NOT NULL default '0',=0A=
! `Avg_value_or_avg_length` char(85) character set utf8 NOT NULL =
default '',=0A=
! `Std` char(85) character set utf8 default NULL,=0A=
! `Optimal_fieldtype` char(22) character set utf8 NOT NULL default ''=0A=
) ENGINE=3DMyISAM DEFAULT CHARSET=3Dlatin1=0A=
select * from t2;=0A=
Field_name Min_value Max_value Min_length Max_length Empties_or_zeros =
Nulls Avg_value_or_avg_length Std Optimal_fieldtype=0A=
***************=0A=
*** 78,93 ****=0A=
show create table t2;=0A=
Table Create Table=0A=
t2 CREATE TABLE `t2` (=0A=
! `Field_name` char(255) NOT NULL default '',=0A=
! `Min_value` char(255) default NULL,=0A=
! `Max_value` char(255) default NULL,=0A=
`Min_length` bigint(11) NOT NULL default '0',=0A=
`Max_length` bigint(11) NOT NULL default '0',=0A=
`Empties_or_zeros` bigint(11) NOT NULL default '0',=0A=
`Nulls` bigint(11) NOT NULL default '0',=0A=
! `Avg_value_or_avg_length` char(255) NOT NULL default '',=0A=
! `Std` char(255) default NULL,=0A=
! `Optimal_fieldtype` char(64) NOT NULL default ''=0A=
) ENGINE=3DMyISAM DEFAULT CHARSET=3Dlatin1=0A=
select * from t2;=0A=
Field_name Min_value Max_value Min_length Max_length Empties_or_zeros =
Nulls Avg_value_or_avg_length Std Optimal_fieldtype=0A=
--- 82,97 ----=0A=
show create table t2;=0A=
Table Create Table=0A=
t2 CREATE TABLE `t2` (=0A=
! `Field_name` char(85) character set utf8 NOT NULL default '',=0A=
! `Min_value` char(85) character set utf8 default NULL,=0A=
! `Max_value` char(85) character set utf8 default NULL,=0A=
`Min_length` bigint(11) NOT NULL default '0',=0A=
`Max_length` bigint(11) NOT NULL default '0',=0A=
`Empties_or_zeros` bigint(11) NOT NULL default '0',=0A=
`Nulls` bigint(11) NOT NULL default '0',=0A=
! `Avg_value_or_avg_length` char(85) character set utf8 NOT NULL =
default '',=0A=
! `Std` char(85) character set utf8 default NULL,=0A=
! `Optimal_fieldtype` char(22) character set utf8 NOT NULL default ''=0A=
) ENGINE=3DMyISAM DEFAULT CHARSET=3Dlatin1=0A=
select * from t2;=0A=
Field_name Min_value Max_value Min_length Max_length Empties_or_zeros =
Nulls Avg_value_or_avg_length Std Optimal_fieldtype=0A=
-------------------------------------------------------=0A=
Please follow the instructions outlined at=0A=
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html=0A =
to find the reason to this problem and how to report this.=0A=
=0A=
Ending Tests=0A=
Shutting-down MySQL daemon=0A=
=0A=
Master shutdown finished=0A=
Slave shutdown finished=0A=
Resuming Tests=0A=
=0A=
ansi [ pass ]=0A=
archive [ skipped ]=0A=
auto_increment [ pass ]=0A=
backup [ pass ]=0A=
bdb-alter-table-1 [ skipped ]=0A=
bdb-alter-table-2 [ skipped ]=0A=
bdb-crash [ skipped ]=0A=
bdb-deadlock [ skipped ]=0A=
bdb [ skipped ]=0A=
bdb_cache [ skipped ]=0A=
bench_count_distinct [ pass ]=0A=
bigint [ pass ]=0A=
binary [ fail ]=0A=
=0A=
Errors are (from =
/home/linus/mysql/utf8/mysql-test/var/log/mysqltest-time) :=0A=
/home/linus/mysql/utf8/bin/mysqltest: At line 11: query 'insert into t1 =
values ("ä")' failed: 1062: Duplicate entry '' for key 1=0A=
(the last lines may be the most important ones)=0A=
=0A=
Ending Tests=0A=
Shutting-down MySQL daemon=0A=
=0A=
Master shutdown finished=0A=
Slave shutdown finished=0A=
Resuming Tests=0A=
=0A=
bool [ pass ]=0A=
bulk_replace [ pass ]=0A=
case [ fail ]=0A=
=0A=
Errors are (from =
/home/linus/mysql/utf8/mysql-test/var/log/mysqltest-time) :=0A=
/home/linus/mysql/utf8/bin/mysqltest: At line 44: query 'select max(case =
col when 1 then val else null end) as color from t1 group by row' =
failed: 1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and =
(utf8_general_ci,COERCIBLE) for operation 'case'=0A=
(the last lines may be the most important ones)=0A=
=0A=
Ending Tests=0A=
Shutting-down MySQL daemon=0A=
=0A=
Master shutdown finished=0A=
Slave shutdown finished=0A=
Resuming Tests=0A=
=0A=
cast [ fail ]=0A=
=0A=
Errors are (from =
/home/linus/mysql/utf8/mysql-test/var/log/mysqltest-time) :=0A=
/home/linus/mysql/utf8/bin/mysqltest: At line 31: query 'create table t1 =
select cast(_koi8r'ÔÅÓÔ' as char character set cp1251) as t' =
failed: 1050: Table 't1' already exists=0A=
(the last lines may be the most important ones)=0A=
=0A=
Ending Tests=0A=
Shutting-down MySQL daemon=0A=
=0A=
Master shutdown finished=0A=
Slave shutdown finished=0A=
Resuming Tests=0A=
=0A=
check [ pass ]=0A=
comments [ pass ]=0A=
compare [ fail ]=0A=
=0A=
Errors are (from =
/home/linus/mysql/utf8/mysql-test/var/log/mysqltest-time) :=0A=
/home/linus/mysql/utf8/bin/mysqltest: At line 31: query 'SELECT =
hex(a),STRCMP(a,'a'), STRCMP(a,'a ') FROM t1' failed: 1267: Illegal mix =
of collations (latin1_swedish_ci,IMPLICIT) and =
(utf8_general_ci,COERCIBLE) for operation 'strcmp'=0A=
(the last lines may be the most important ones)=0A=
=0A=
Ending Tests=0A=
Shutting-down MySQL daemon=0A=
=0A=
Master shutdown finished=0A=
Slave shutdown finished=0A=
Resuming Tests=0A=
=0A=
connect [ fail ]=0A=
=0A=
Errors are (from =
/home/linus/mysql/utf8/mysql-test/var/log/mysqltest-time) :=0A=
/home/linus/mysql/utf8/bin/mysqltest: At line 73: Result length mismatch=0A=
(the last lines may be the most important ones)=0A=
Below are the diffs between actual and expected results:=0A=
-------------------------------------------------------=0A=
*** r/connect.result 2004-07-04 03:33:44.000000000 +0300=0A=
--- r/connect.reject 2004-07-04 04:24:01.000000000 +0300=0A=
***************=0A=
*** 17,22 ****=0A=
--- 17,24 ----=0A=
user=0A=
show tables;=0A=
Tables_in_test=0A=
+ t1=0A=
+ t2=0A=
grant ALL on *.* to test@localhost identified by "gambling";=0A=
grant ALL on *.* to test@127.0.0.1 identified by "gambling";=0A=
show tables;=0A=
***************=0A=
*** 38,43 ****=0A=
--- 40,47 ----=0A=
user=0A=
show tables;=0A=
Tables_in_test=0A=
+ t1=0A=
+ t2=0A=
update mysql.user set password=3Dold_password("gambling2") where =
user=3D"test";=0A=
flush privileges;=0A=
set password=3Dold_password('gambling3');=0A=
***************=0A=
*** 60,64 ****=0A=
--- 64,70 ----=0A=
user=0A=
show tables;=0A=
Tables_in_test=0A=
+ t1=0A=
+ t2=0A=
delete from mysql.user where user=3D"test";=0A=
flush privileges;=0A=
-------------------------------------------------------=0A=
Please follow the instructions outlined at=0A=
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html=0A =
to find the reason to this problem and how to report this.=0A=
=0A=
Ending Tests=0A=
Shutting-down MySQL daemon=0A=
=0A=
Master shutdown finished=0A=
Slave shutdown finished=0A=
Resuming Tests=0A=
=0A=
constraints [ pass ]=0A=
count_distinct [ fail ]=0A=
=0A=
Errors are (from =
/home/linus/mysql/utf8/mysql-test/var/log/mysqltest-time) :=0A=
/home/linus/mysql/utf8/bin/mysqltest: At line 37: query 'select =
t2.isbn,city,t1.libname,count(distinct t1.libname) as a from t3 left =
join t1 on t3.libname=3Dt1.libname left join t2 on t3.isbn=3Dt2.isbn =
group by city having count(distinct concat(t1.libname,'a')) > 1' failed: =
1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and =
(utf8_general_ci,COERCIBLE) for operation 'concat'=0A=
(the last lines may be the most important ones)=0A=
=0A=
Ending Tests=0A=
Shutting-down MySQL daemon=0A=
=0A=
Master shutdown finished=0A=
Slave shutdown finished=0A=
Resuming Tests=0A=
=0A=
count_distinct2 [ pass ]=0A=
count_distinct3 [ pass ]=0A=
create [ fail ]=0A=
=0A=
Errors are (from =
/home/linus/mysql/utf8/mysql-test/var/log/mysqltest-time) :=0A=
/home/linus/mysql/utf8/bin/mysqltest: At line 97: query 'explain select =
* from t2 where b=3D"world"' failed: 1267: Illegal mix of collations =
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for =
operation '=3D'=0A=
(the last lines may be the most important ones)=0A=
=0A=
Ending Tests=0A=
Shutting-down MySQL daemon=0A=
=0A=
Master shutdown finished=0A=
Slave shutdown finished=0A=
Resuming Tests=0A=
=0A=
ctype_big5 [ skipped ]=0A=
ctype_collate [ fail ]=0A=
=0A=
Errors are (from =
/home/linus/mysql/utf8/mysql-test/var/log/mysqltest-time) :=0A=
/home/linus/mysql/utf8/bin/mysqltest: At line 197: Result length mismatch=0A=
(the last lines may be the most important ones)=0A=
Below are the diffs between actual and expected results:=0A=
-------------------------------------------------------=0A=
*** r/ctype_collate.result 2004-07-04 03:33:44.000000000 +0300=0A=
--- r/ctype_collate.reject 2004-07-04 04:26:35.000000000 +0300=0A=
***************=0A=
*** 58,72 ****=0A=
ue=0A=
Y=0A=
y=0A=
! ü =
! Ü =
Z=0A=
z=0A=
! å =
! Å =
! Ä =
! ä =
! ß =
SELECT latin1_f FROM t1 ORDER BY latin1_f COLLATE latin1_swedish_ci;=0A=
latin1_f=0A=
A=0A=
--- 58,72 ----=0A=
ue=0A=
Y=0A=
y=0A=
! Ã¼=0A=
! Ã=0A=
Z=0A=
z=0A=
! Ã¥=0A=
! Ã=0A=
! Ã=0A=
! Ã¤=0A=
! Ã=0A=
SELECT latin1_f FROM t1 ORDER BY latin1_f COLLATE latin1_swedish_ci;=0A=
latin1_f=0A=
A=0A=
***************=0A=
*** 87,126 ****=0A=
ue=0A=
Y=0A=
y=0A=
! ü =
! Ü =
Z=0A=
z=0A=
! å =
! Å =
! Ä =
! ä =
! ß =
SELECT latin1_f FROM t1 ORDER BY latin1_f COLLATE latin1_german2_ci;=0A=
latin1_f=0A=
A=0A=
a=0A=
! Å =
! å =
AD=0A=
ad=0A=
! Ä =
ae=0A=
AE=0A=
! ä =
af=0A=
AF=0A=
b=0A=
B=0A=
! ß =
ss=0A=
SS=0A=
U=0A=
u=0A=
ue=0A=
UE=0A=
! ü =
! Ü =
Y=0A=
y=0A=
Z=0A=
--- 87,126 ----=0A=
ue=0A=
Y=0A=
y=0A=
! Ã¼=0A=
! Ã=0A=
Z=0A=
z=0A=
! Ã¥=0A=
! Ã=0A=
! Ã=0A=
! Ã¤=0A=
! Ã=0A=
SELECT latin1_f FROM t1 ORDER BY latin1_f COLLATE latin1_german2_ci;=0A=
latin1_f=0A=
A=0A=
a=0A=
! Ã=0A=
! Ã¥=0A=
AD=0A=
ad=0A=
! Ã=0A=
ae=0A=
AE=0A=
! Ã¤=0A=
af=0A=
AF=0A=
b=0A=
B=0A=
! Ã=0A=
ss=0A=
SS=0A=
U=0A=
u=0A=
ue=0A=
UE=0A=
! Ã¼=0A=
! Ã=0A=
Y=0A=
y=0A=
Z=0A=
***************=0A=
*** 135,155 ****=0A=
ae=0A=
af=0A=
AF=0A=
! Ä =
! ä =
! Å =
! å =
b=0A=
B=0A=
ss=0A=
SS=0A=
! ß =
U=0A=
u=0A=
UE=0A=
ue=0A=
! ü =
! Ü =
Y=0A=
y=0A=
Z=0A=
--- 135,155 ----=0A=
ae=0A=
af=0A=
AF=0A=
! Ã=0A=
! Ã¤=0A=
! Ã=0A=
! Ã¥=0A=
b=0A=
B=0A=
ss=0A=
SS=0A=
! Ã=0A=
U=0A=
u=0A=
UE=0A=
ue=0A=
! Ã¼=0A=
! Ã=0A=
Y=0A=
y=0A=
Z=0A=
***************=0A=
*** 176,188 ****=0A=
ue=0A=
y=0A=
z=0A=
! Ä =
! Å =
! Ü =
! ß =
! ä =
! å =
! ü =
SELECT latin1_f FROM t1 ORDER BY latin1_f COLLATE koi8r_general_ci;=0A=
ERROR 42000: COLLATION 'koi8r_general_ci' is not valid for CHARACTER =
SET 'latin1'=0A=
SELECT latin1_f COLLATE latin1_swedish_ci AS latin1_f_as FROM t1 ORDER =
BY latin1_f_as;=0A=
--- 176,188 ----=0A=
ue=0A=
y=0A=
z=0A=
! Ã=0A=
! Ã=0A=
! Ã=0A=
! Ã=0A=
! Ã¤=0A=
! Ã¥=0A=
! Ã¼=0A=
SELECT latin1_f FROM t1 ORDER BY latin1_f COLLATE koi8r_general_ci;=0A=
ERROR 42000: COLLATION 'koi8r_general_ci' is not valid for CHARACTER =
SET 'latin1'=0A=
SELECT latin1_f COLLATE latin1_swedish_ci AS latin1_f_as FROM t1 ORDER =
BY latin1_f_as;=0A=
***************=0A=
*** 205,244 ****=0A=
ue=0A=
Y=0A=
y=0A=
! ü =
! Ü =
Z=0A=
z=0A=
! å =
! Å =
! Ä =
! ä =
! ß =
SELECT latin1_f COLLATE latin1_german2_ci AS latin1_f_as FROM t1 ORDER =
BY latin1_f_as;=0A=
latin1_f_as=0A=
A=0A=
a=0A=
! Å =
! å =
AD=0A=
ad=0A=
! Ä =
ae=0A=
AE=0A=
! ä =
af=0A=
AF=0A=
b=0A=
B=0A=
! ß =
ss=0A=
SS=0A=
U=0A=
u=0A=
ue=0A=
UE=0A=
! ü =
! Ü =
Y=0A=
y=0A=
Z=0A=
--- 205,244 ----=0A=
ue=0A=
Y=0A=
y=0A=
! Ã¼=0A=
! Ã=0A=
Z=0A=
z=0A=
! Ã¥=0A=
! Ã=0A=
! Ã=0A=
! Ã¤=0A=
! Ã=0A=
SELECT latin1_f COLLATE latin1_german2_ci AS latin1_f_as FROM t1 ORDER =
BY latin1_f_as;=0A=
latin1_f_as=0A=
A=0A=
a=0A=
! Ã=0A=
! Ã¥=0A=
AD=0A=
ad=0A=
! Ã=0A=
ae=0A=
AE=0A=
! Ã¤=0A=
af=0A=
AF=0A=
b=0A=
B=0A=
! Ã=0A=
ss=0A=
SS=0A=
U=0A=
u=0A=
ue=0A=
UE=0A=
! Ã¼=0A=
! Ã=0A=
Y=0A=
y=0A=
Z=0A=
***************=0A=
*** 253,273 ****=0A=
ae=0A=
af=0A=
AF=0A=
! Ä =
! ä =
! Å =
! å =
b=0A=
B=0A=
ss=0A=
SS=0A=
! ß =
U=0A=
u=0A=
UE=0A=
ue=0A=
! ü =
! Ü =
Y=0A=
y=0A=
Z=0A=
--- 253,273 ----=0A=
ae=0A=
af=0A=
AF=0A=
! Ã=0A=
! Ã¤=0A=
! Ã=0A=
! Ã¥=0A=
b=0A=
B=0A=
ss=0A=
SS=0A=
! Ã=0A=
U=0A=
u=0A=
UE=0A=
ue=0A=
! Ã¼=0A=
! Ã=0A=
Y=0A=
y=0A=
Z=0A=
***************=0A=
*** 294,306 ****=0A=
ue=0A=
y=0A=
z=0A=
! Ä =
! Å =
! Ü =
! ß =
! ä =
! å =
! ü =
SELECT latin1_f COLLATE koi8r_general_ci AS latin1_f_as FROM t1 ORDER =
BY latin1_f_as;=0A=
ERROR 42000: COLLATION 'koi8r_general_ci' is not valid for CHARACTER =
SET 'latin1'=0A=
SELECT latin1_f,count(*) FROM t1 GROUP BY latin1_f;=0A=
--- 294,306 ----=0A=
ue=0A=
y=0A=
z=0A=
! Ã=0A=
! Ã=0A=
! Ã=0A=
! Ã=0A=
! Ã¤=0A=
! Ã¥=0A=
! Ã¼=0A=
SELECT latin1_f COLLATE koi8r_general_ci AS latin1_f_as FROM t1 ORDER =
BY latin1_f_as;=0A=
ERROR 42000: COLLATION 'koi8r_general_ci' is not valid for CHARACTER =
SET 'latin1'=0A=
SELECT latin1_f,count(*) FROM t1 GROUP BY latin1_f;=0A=
***************=0A=
*** 313,323 ****=0A=
SS 2=0A=
U 2=0A=
UE 2=0A=
! Ü 4=0A=
Z 2=0A=
! =C5 2=0A=
! Ä 2=0A=
! ß 1=0A=
SELECT latin1_f,count(*) FROM t1 GROUP BY latin1_f COLLATE =
latin1_swedish_ci;=0A=
latin1_f count(*)=0A=
A 2=0A=
--- 313,323 ----=0A=
SS 2=0A=
U 2=0A=
UE 2=0A=
! Ã 4=0A=
Z 2=0A=
! Ã 2=0A=
! Ã 2=0A=
! Ã 1=0A=
SELECT latin1_f,count(*) FROM t1 GROUP BY latin1_f COLLATE =
latin1_swedish_ci;=0A=
latin1_f count(*)=0A=
A 2=0A=
***************=0A=
*** 328,338 ****=0A=
SS 2=0A=
U 2=0A=
UE 2=0A=
! Ü 4=0A=
Z 2=0A=
! =C5 2=0A=
! Ä 2=0A=
! ß 1=0A=
SELECT latin1_f,count(*) FROM t1 GROUP BY latin1_f COLLATE =
latin1_german2_ci;=0A=
latin1_f count(*)=0A=
A 4=0A=
--- 328,338 ----=0A=
SS 2=0A=
U 2=0A=
UE 2=0A=
! Ã 4=0A=
Z 2=0A=
! Ã 2=0A=
! Ã 2=0A=
! Ã 1=0A=
SELECT latin1_f,count(*) FROM t1 GROUP BY latin1_f COLLATE =
latin1_german2_ci;=0A=
latin1_f count(*)=0A=
A 4=0A=
***************=0A=
*** 351,364 ****=0A=
AD 2=0A=
AE 2=0A=
AF 2=0A=
! Ä 2=0A=
! =C5 2=0A=
B 2=0A=
SS 2=0A=
! ß 1=0A=
U 2=0A=
UE 2=0A=
! Ü 2=0A=
Y 2=0A=
Z 2=0A=
SELECT latin1_f,count(*) FROM t1 GROUP BY latin1_f COLLATE latin1_bin;=0A=
--- 351,364 ----=0A=
AD 2=0A=
AE 2=0A=
AF 2=0A=
! Ã 2=0A=
! Ã 2=0A=
B 2=0A=
SS 2=0A=
! Ã 1=0A=
U 2=0A=
UE 2=0A=
! Ã 2=0A=
Y 2=0A=
Z 2=0A=
SELECT latin1_f,count(*) FROM t1 GROUP BY latin1_f COLLATE latin1_bin;=0A=
***************=0A=
*** 383,395 ****=0A=
ue 1=0A=
y 1=0A=
z 1=0A=
! Ä 1=0A=
! =C5 1=0A=
! Ü 1=0A=
! ß 1=0A=
! ä 1=0A=
! =E5 1=0A=
! ü 1=0A=
SELECT latin1_f,count(*) FROM t1 GROUP BY latin1_f COLLATE =
koi8r_general_ci;=0A=
ERROR 42000: COLLATION 'koi8r_general_ci' is not valid for CHARACTER =
SET 'latin1'=0A=
SELECT DISTINCT latin1_f FROM t1;=0A=
--- 383,395 ----=0A=
ue 1=0A=
y 1=0A=
z 1=0A=
! Ã 1=0A=
! Ã 1=0A=
! Ã 1=0A=
! Ã 1=0A=
! Ã¤ 1=0A=
! Ã¥ 1=0A=
! Ã¼ 1=0A=
SELECT latin1_f,count(*) FROM t1 GROUP BY latin1_f COLLATE =
koi8r_general_ci;=0A=
ERROR 42000: COLLATION 'koi8r_general_ci' is not valid for CHARACTER =
SET 'latin1'=0A=
SELECT DISTINCT latin1_f FROM t1;=0A=
***************=0A=
*** 398,411 ****=0A=
AD=0A=
AE=0A=
AF=0A=
! Ä =
! Å =
B=0A=
U=0A=
UE=0A=
! Ü =
SS=0A=
! ß =
Z=0A=
SELECT DISTINCT latin1_f COLLATE latin1_swedish_ci FROM t1;=0A=
latin1_f COLLATE latin1_swedish_ci=0A=
--- 398,411 ----=0A=
AD=0A=
AE=0A=
AF=0A=
! Ã=0A=
! Ã=0A=
B=0A=
U=0A=
UE=0A=
! Ã=0A=
SS=0A=
! Ã=0A=
Z=0A=
SELECT DISTINCT latin1_f COLLATE latin1_swedish_ci FROM t1;=0A=
latin1_f COLLATE latin1_swedish_ci=0A=
***************=0A=
*** 413,426 ****=0A=
AD=0A=
AE=0A=
AF=0A=
! Ä =
! Å =
B=0A=
U=0A=
UE=0A=
! Ü =
SS=0A=
! ß =
Z=0A=
SELECT DISTINCT latin1_f COLLATE latin1_german2_ci FROM t1;=0A=
latin1_f COLLATE latin1_german2_ci=0A=
--- 413,426 ----=0A=
AD=0A=
AE=0A=
AF=0A=
! Ã=0A=
! Ã=0A=
B=0A=
U=0A=
UE=0A=
! Ã=0A=
SS=0A=
! Ã=0A=
Z=0A=
SELECT DISTINCT latin1_f COLLATE latin1_german2_ci FROM t1;=0A=
latin1_f COLLATE latin1_german2_ci=0A=
***************=0A=
*** 440,453 ****=0A=
AD=0A=
AE=0A=
AF=0A=
! Ä =
! Å =
B=0A=
U=0A=
UE=0A=
! Ü =
SS=0A=
! ß =
Y=0A=
Z=0A=
SELECT DISTINCT latin1_f COLLATE latin1_bin FROM t1;=0A=
--- 440,453 ----=0A=
AD=0A=
AE=0A=
AF=0A=
! Ã=0A=
! Ã=0A=
B=0A=
U=0A=
UE=0A=
! Ã=0A=
SS=0A=
! Ã=0A=
Y=0A=
Z=0A=
SELECT DISTINCT latin1_f COLLATE latin1_bin FROM t1;=0A=
***************=0A=
*** 460,480 ****=0A=
ae=0A=
AF=0A=
af=0A=
! Ä =
! ä =
! Å =
! å =
B=0A=
b=0A=
U=0A=
u=0A=
UE=0A=
ue=0A=
! Ü =
! ü =
SS=0A=
ss=0A=
! ß =
Y=0A=
y=0A=
Z=0A=
--- 460,480 ----=0A=
ae=0A=
AF=0A=
af=0A=
! Ã=0A=
! Ã¤=0A=
! Ã=0A=
! Ã¥=0A=
B=0A=
b=0A=
U=0A=
u=0A=
UE=0A=
ue=0A=
! Ã=0A=
! Ã¼=0A=
SS=0A=
ss=0A=
! Ã=0A=
Y=0A=
y=0A=
Z=0A=
-------------------------------------------------------=0A=
Please follow the instructions outlined at=0A=
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html=0A =
to find the reason to this problem and how to report this.=0A=
=0A=
Ending Tests=0A=
Shutting-down MySQL daemon=0A=
=0A=
Master shutdown finished=0A=
Slave shutdown finished=0A=
Resuming Tests=0A=
=0A=
ctype_cp1251 [ pass ]=0A=
ctype_create [ pass ]=0A=
ctype_latin1 [ pass ]=0A=
ctype_latin1_de [ pass ]=0A=
ctype_many [ skipped ]=0A=
ctype_mb [ pass ]=0A=
ctype_recoding [ pass ]=0A=
ctype_sjis [ skipped ]=0A=
ERROR: /home/linus/mysql/utf8/mysql-test/var/run/master.pid was not =
created in 30 seconds; Aborting=0A=

------=_NextPart_000_005A_01C4612E.3EA076F0
Content-Type: text/plain;
name="test-default-charset.txt"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="test-default-charset.txt"

Installing Test Databases=0A=
Removing Stale Files=0A=
Installing Master Databases=0A=
running ../libexec/mysqld --no-defaults --bootstrap --skip-grant-tables =
--basedir=3D.. --datadir=3Dmysql-test/var/master-data --skip-innodb =
--skip-ndbcluster --skip-bdb =0A=
Installing Slave Databases=0A=
running ../libexec/mysqld --no-defaults --bootstrap --skip-grant-tables =
--basedir=3D.. --datadir=3Dmysql-test/var/slave-data --skip-innodb =
--skip-ndbcluster --skip-bdb =0A=
Manager disabled, skipping manager start.=0A=
Loading Standard Test Databases=0A=
Starting Tests=0A=
=0A=
TEST RESULT=0A=
------------------------------------------=0A=
alias [ pass ]=0A=
alter_table [ pass ]=0A=
analyse [ pass ]=0A=
ansi [ pass ]=0A=
archive [ skipped ]=0A=
auto_increment [ pass ]=0A=
backup [ pass ]=0A=
bdb-alter-table-1 [ skipped ]=0A=
bdb-alter-table-2 [ skipped ]=0A=
bdb-crash [ skipped ]=0A=
bdb-deadlock [ skipped ]=0A=
bdb [ skipped ]=0A=
bdb_cache [ skipped ]=0A=
bench_count_distinct [ pass ]=0A=
bigint [ pass ]=0A=
binary [ pass ]=0A=
bool [ pass ]=0A=
bulk_replace [ pass ]=0A=
case [ pass ]=0A=
cast [ pass ]=0A=
check [ pass ]=0A=
comments [ pass ]=0A=
compare [ pass ]=0A=
connect [ pass ]=0A=
constraints [ pass ]=0A=
count_distinct [ pass ]=0A=
count_distinct2 [ pass ]=0A=
count_distinct3 [ pass ]=0A=
create [ pass ]=0A=
ctype_big5 [ skipped ]=0A=
ctype_collate [ pass ]=0A=
ctype_cp1251 [ pass ]=0A=
ctype_create [ pass ]=0A=
ctype_latin1 [ pass ]=0A=
ctype_latin1_de [ pass ]=0A=
ctype_many [ skipped ]=0A=
ctype_mb [ pass ]=0A=
ctype_recoding [ pass ]=0A=
ctype_sjis [ skipped ]=0A=
ERROR: /home/linus/mysql/base/mysql-test/var/run/master.pid was not =
created in 30 seconds; Aborting=0A=

------=_NextPart_000_005A_01C4612E.3EA076F0
Content-Type: text/plain; charset=us-ascii

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org
------=_NextPart_000_005A_01C4612E.3EA076F0--

Re: unique key and utf8

am 12.07.2004 16:06:47 von Sinisa Milivojevic

Linus Upson wrote:

>Many of the mysql test cases fail when I configure 4.1.3 with
>'--with-charset=utf8'. The symptoms are similar to the index truncation
>problem I reported with 4.1.1.
>
>Here is how mysql was configured:
>
>C compiler: gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-34)
>C++ compiler: g++ (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-34)
>Environment:
>System: Linux seek 2.4.21-15.0.2.ELsmp #1 SMP Wed Jun 16 22:52:07 EDT 2004
>i686 i686 i386 GNU/Linux
>Architecture: i686
>
>./configure --prefix=/home/linus/mysql/utf8 --with-tcp-port=8506
>--with-unix-socket-path=/home/linus/mysql/utf8/tmp/mysql.so ck
>--with-charset=utf8
>
>The full test results from the following command are attached.
>
>$ ./mysql-test-run --force > test-utf8.txt
>
>I also tried to configure mysql using the same configure command but without
>the '--with-charset=utf8' option. More of the tests ran, but it eventually
>failed with:
>
>...
>ctype_mb [ pass ]
>ctype_recoding [ pass ]
>ctype_sjis [ skipped ]
>ERROR: /home/linus/mysql/utf8/mysql-test/var/run/master.pid was not created
>in 30 seconds; Aborting
>
>I've attached the complete test output as test-default-charset.txt.
>
>Thanks,
>Linus
>
>
>
>
>

HI!

I just tried the above on my machine with gcc 3.3.3 , kernel 2.4.26 SMP,
with the exact configure options and all tests passed for me.

--

Sincerely,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Full time Developer and Support Coordinator
<___/ www.mysql.com Larnaca, Cyprus

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org