Date: Wed, 10 Mar 2010 13:06:16 GMT From: Terranus <terranus@land.ru> To: freebsd-gnats-submit@FreeBSD.org Subject: ports/144619: Some MySQLs' tests failed Message-ID: <201003101306.o2AD6GaK021629@www.freebsd.org> Resent-Message-ID: <201003101310.o2ADA8uA028096@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>Number: 144619 >Category: ports >Synopsis: Some MySQLs' tests failed >Confidential: no >Severity: non-critical >Priority: medium >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: change-request >Submitter-Id: current-users >Arrival-Date: Wed Mar 10 13:10:08 UTC 2010 >Closed-Date: >Last-Modified: >Originator: Terranus >Release: 8.0-RELEASE >Organization: >Environment: FreeBSD mydom.home 8.0-RELEASE FreeBSD 8.0-RELEASE #0: Sat Nov 21 15:48:17 UTC 2009 root@almeida.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC i386 >Description: Some tests failed: ctype_utf8 myisam mysql_client_test type_blob >How-To-Repeat: After compiling port mysql-server-5.0.90 and cd to /usr/ports/databases/mysql50-server/work/mysql-5.0.90 run 'make test' command But before any test can be executed need todo some things (relative to /usr/ports/databases/mysql50-server/work/mysql-5.0.90): 1. cd client && make 2. cd scripts && make mysql_fix_privilege_tables 3. cd server-tools && make 4. cd tests && make mysql_client_test >Fix: 1. 'mysql_client_test' test works fine after compiling 'mysql_client_test' program: cd usr/ports/databases/mysql50-server/work/mysql-5.0.90/tests && make mysql_client_test 2. other three test fails cause imho wrong limit values applied. I've changed this tests' scripts and result files: ########## CUT HERE ################## --- /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/t/ctype_utf8.test.bak 2010-01-15 13:13:38.000000000 +0300 +++ /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/t/ctype_utf8.test 2010-03-10 15:23:44.000000000 +0300 @@ -164,7 +164,7 @@ # UTF8 breaks primary keys for cols > 333 characters # --error 1071 -create table t1 (a text character set utf8, primary key(a(360))); +create table t1 (a text character set utf8, primary key(a(3600))); # --- /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/r/ctype_utf8.result.bak 2010-01-15 13:13:39.000000000 +0300 +++ /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/r/ctype_utf8.result 2010-03-10 15:24:57.000000000 +0300 @@ -240,8 +240,8 @@ hex(s1) 41 drop table t1; -create table t1 (a text character set utf8, primary key(a(360))); -ERROR 42000: Specified key was too long; max key length is 1000 bytes +create table t1 (a text character set utf8, primary key(a(3600))); +ERROR 42000: Specified key was too long; max key length is 3072 bytes CREATE TABLE t1 ( a varchar(10) ) CHARACTER SET utf8; INSERT INTO t1 VALUES ( 'test' ); SELECT a.a, b.a FROM t1 a, t1 b WHERE a.a = b.a; --- /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/t/myisam.test.bak 2010-01-15 13:13:38.000000000 +0300 +++ /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/t/myisam.test 2010-03-09 16:37:12.000000000 +0300 @@ -337,8 +337,8 @@ # --error 1071 -CREATE TABLE t1 (a varchar(255), b varchar(255), c varchar(255), d varchar(255), e varchar(255), KEY t1 (a, b, c, d, e)); -CREATE TABLE t1 (a varchar(255), b varchar(255), c varchar(255), d varchar(255), e varchar(255)); +CREATE TABLE t1 (a varchar(511), b varchar(511), c varchar(1023), d varchar(1023), e varchar(255), KEY t1 (a, b, c, d, e)); +CREATE TABLE t1 (a varchar(511), b varchar(511), c varchar(1023), d varchar(1023), e varchar(255)); --error 1071 ALTER TABLE t1 ADD INDEX t1 (a, b, c, d, e); DROP TABLE t1; --- /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/r/myisam.result.bak 2010-01-15 13:13:39.000000000 +0300 +++ /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/r/myisam.result 2010-03-09 16:39:12.000000000 +0300 @@ -322,11 +322,11 @@ Table Op Msg_type Msg_text test.t1 check status OK drop table t1; -CREATE TABLE t1 (a varchar(255), b varchar(255), c varchar(255), d varchar(255), e varchar(255), KEY t1 (a, b, c, d, e)); -ERROR 42000: Specified key was too long; max key length is 1000 bytes -CREATE TABLE t1 (a varchar(255), b varchar(255), c varchar(255), d varchar(255), e varchar(255)); +CREATE TABLE t1 (a varchar(511), b varchar(511), c varchar(1023), d varchar(1023), e varchar(255), KEY t1 (a, b, c, d, e)); +ERROR 42000: Specified key was too long; max key length is 3072 bytes +CREATE TABLE t1 (a varchar(511), b varchar(511), c varchar(1023), d varchar(1023), e varchar(255)); ALTER TABLE t1 ADD INDEX t1 (a, b, c, d, e); -ERROR 42000: Specified key was too long; max key length is 1000 bytes +ERROR 42000: Specified key was too long; max key length is 3072 bytes DROP TABLE t1; CREATE TABLE t1 (a int not null, b int, c int, key(b), key(c), key(a,b), key(c,a)); INSERT into t1 values (0, null, 0), (0, null, 1), (0, null, 2), (0, null,3), (1,1,4); @@ -1668,7 +1668,7 @@ drop table t1; create table t1 (v varchar(65530), key(v)); Warnings: -Warning 1071 Specified key was too long; max key length is 1000 bytes +Warning 1071 Specified key was too long; max key length is 3072 bytes drop table if exists t1; create table t1 (v varchar(65536)); Warnings: --- /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/t/type_blob.test.bak 2010-01-15 13:13:38.000000000 +0300 +++ /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/t/type_blob.test 2010-03-10 10:18:12.000000000 +0300 @@ -132,8 +132,8 @@ drop table t1; -- error 1071 -create table t1 (a text, unique (a(2100))); # should give an error -create table t1 (a text, key (a(2100))); # key is auto-truncated +create table t1 (a text, unique (a(3100))); # should give an error +create table t1 (a text, key (a(3100))); # key is auto-truncated show create table t1; drop table t1; --- /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/r/type_blob.result.bak 2010-01-15 13:13:40.000000000 +0300 +++ /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/r/type_blob.result 2010-03-10 10:18:50.000000000 +0300 @@ -356,16 +356,16 @@ a 1 hello 1 drop table t1; -create table t1 (a text, unique (a(2100))); -ERROR 42000: Specified key was too long; max key length is 1000 bytes -create table t1 (a text, key (a(2100))); +create table t1 (a text, unique (a(3100))); +ERROR 42000: Specified key was too long; max key length is 3072 bytes +create table t1 (a text, key (a(3100))); Warnings: -Warning 1071 Specified key was too long; max key length is 1000 bytes +Warning 1071 Specified key was too long; max key length is 3072 bytes show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` text, - KEY `a` (`a`(1000)) + KEY `a` (`a`(3072)) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 drop table t1; CREATE TABLE t1 ( ########## CUT HERE ################## Patch attached with submission follows: --- /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/r/ctype_utf8.result.bak 2010-01-15 13:13:39.000000000 +0300 +++ /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/r/ctype_utf8.result 2010-03-10 15:24:57.000000000 +0300 @@ -240,8 +240,8 @@ hex(s1) 41 drop table t1; -create table t1 (a text character set utf8, primary key(a(360))); -ERROR 42000: Specified key was too long; max key length is 1000 bytes +create table t1 (a text character set utf8, primary key(a(3600))); +ERROR 42000: Specified key was too long; max key length is 3072 bytes CREATE TABLE t1 ( a varchar(10) ) CHARACTER SET utf8; INSERT INTO t1 VALUES ( 'test' ); SELECT a.a, b.a FROM t1 a, t1 b WHERE a.a = b.a; --- /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/t/ctype_utf8.test.bak 2010-01-15 13:13:38.000000000 +0300 +++ /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/t/ctype_utf8.test 2010-03-10 15:23:44.000000000 +0300 @@ -164,7 +164,7 @@ # UTF8 breaks primary keys for cols > 333 characters # --error 1071 -create table t1 (a text character set utf8, primary key(a(360))); +create table t1 (a text character set utf8, primary key(a(3600))); # --- /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/r/myisam.result.bak 2010-01-15 13:13:39.000000000 +0300 +++ /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/r/myisam.result 2010-03-09 16:39:12.000000000 +0300 @@ -322,11 +322,11 @@ Table Op Msg_type Msg_text test.t1 check status OK drop table t1; -CREATE TABLE t1 (a varchar(255), b varchar(255), c varchar(255), d varchar(255), e varchar(255), KEY t1 (a, b, c, d, e)); -ERROR 42000: Specified key was too long; max key length is 1000 bytes -CREATE TABLE t1 (a varchar(255), b varchar(255), c varchar(255), d varchar(255), e varchar(255)); +CREATE TABLE t1 (a varchar(511), b varchar(511), c varchar(1023), d varchar(1023), e varchar(255), KEY t1 (a, b, c, d, e)); +ERROR 42000: Specified key was too long; max key length is 3072 bytes +CREATE TABLE t1 (a varchar(511), b varchar(511), c varchar(1023), d varchar(1023), e varchar(255)); ALTER TABLE t1 ADD INDEX t1 (a, b, c, d, e); -ERROR 42000: Specified key was too long; max key length is 1000 bytes +ERROR 42000: Specified key was too long; max key length is 3072 bytes DROP TABLE t1; CREATE TABLE t1 (a int not null, b int, c int, key(b), key(c), key(a,b), key(c,a)); INSERT into t1 values (0, null, 0), (0, null, 1), (0, null, 2), (0, null,3), (1,1,4); @@ -1668,7 +1668,7 @@ drop table t1; create table t1 (v varchar(65530), key(v)); Warnings: -Warning 1071 Specified key was too long; max key length is 1000 bytes +Warning 1071 Specified key was too long; max key length is 3072 bytes drop table if exists t1; create table t1 (v varchar(65536)); Warnings: --- /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/t/myisam.test.bak 2010-01-15 13:13:38.000000000 +0300 +++ /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/t/myisam.test 2010-03-09 16:37:12.000000000 +0300 @@ -337,8 +337,8 @@ # --error 1071 -CREATE TABLE t1 (a varchar(255), b varchar(255), c varchar(255), d varchar(255), e varchar(255), KEY t1 (a, b, c, d, e)); -CREATE TABLE t1 (a varchar(255), b varchar(255), c varchar(255), d varchar(255), e varchar(255)); +CREATE TABLE t1 (a varchar(511), b varchar(511), c varchar(1023), d varchar(1023), e varchar(255), KEY t1 (a, b, c, d, e)); +CREATE TABLE t1 (a varchar(511), b varchar(511), c varchar(1023), d varchar(1023), e varchar(255)); --error 1071 ALTER TABLE t1 ADD INDEX t1 (a, b, c, d, e); DROP TABLE t1; --- /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/r/type_blob.result.bak 2010-01-15 13:13:40.000000000 +0300 +++ /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/r/type_blob.result 2010-03-10 10:18:50.000000000 +0300 @@ -356,16 +356,16 @@ a 1 hello 1 drop table t1; -create table t1 (a text, unique (a(2100))); -ERROR 42000: Specified key was too long; max key length is 1000 bytes -create table t1 (a text, key (a(2100))); +create table t1 (a text, unique (a(3100))); +ERROR 42000: Specified key was too long; max key length is 3072 bytes +create table t1 (a text, key (a(3100))); Warnings: -Warning 1071 Specified key was too long; max key length is 1000 bytes +Warning 1071 Specified key was too long; max key length is 3072 bytes show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` text, - KEY `a` (`a`(1000)) + KEY `a` (`a`(3072)) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 drop table t1; CREATE TABLE t1 ( --- /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/t/type_blob.test.bak 2010-01-15 13:13:38.000000000 +0300 +++ /usr/ports/databases/mysql50-server/work/mysql-5.0.90/mysql-test/t/type_blob.test 2010-03-10 10:18:12.000000000 +0300 @@ -132,8 +132,8 @@ drop table t1; -- error 1071 -create table t1 (a text, unique (a(2100))); # should give an error -create table t1 (a text, key (a(2100))); # key is auto-truncated +create table t1 (a text, unique (a(3100))); # should give an error +create table t1 (a text, key (a(3100))); # key is auto-truncated show create table t1; drop table t1; >Release-Note: >Audit-Trail: >Unformatted:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201003101306.o2AD6GaK021629>