ports/144619: Some MySQLs' tests failed
Terranus
terranus at land.ru
Wed Mar 10 13:10:09 UTC 2010
>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 at 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:
More information about the freebsd-ports-bugs
mailing list