Re: Lastes mysql-4.1 bk as of 06/25/04 problems on UnixWare 7.1.
am 26.06.2004 22:28:00 von Boyd Lynn Gerber
Hi All,
On Sat, 26 Jun 2004, Boyd Lynn Gerber wrote:
> I get the following error from make test. All other bdb tests pass.
> bdb [ fail ]
>
> Errors are (from
> /home/blg/uw713/mysql-4.1.3/mysql-test/var/log/mysqltest-tim e)
> :
> /home/blg/uw713/mysql-4.1.3/client/.libs/mysqltest: At line
> 716: query 'select T1.KINMU_DATE from t1 T1 ,t2 T2 where T1.SYAIN_NO =
> '12345' and T1.KINMU_DATE = '200106' and T2.SYAIN_NO = T1.SYAIN_NO'
> failed: 1015: Can't lock file (errno: -30982)
> (the last lines may be the most important ones)
These tests also fail...
flush_table [ fail ]
Errors are (from
/home/blg/uw713/mysql-4.1.3-beta/mysql-test/var/log/mysqltes t-time)
:
/home/blg/uw713/mysql-4.1.3-beta/client/.libs/mysqltest: At line
53: query 'handler test.t2 read first limit 9' succeeded - should have
failed with errno 1109...
/home/blg/uw713/mysql-4.1.3-beta/client/.libs/mysqltest: At line
54: query 'handler test_test.t1 read first limit 9' failed: 1109: Unknown
table 't1' in HANDLER
(the last lines may be the most important ones)
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
Resuming Tests
func_group [ fail ]
Errors are (from
/home/blg/uw713/mysql-4.1.3-beta/mysql-test/var/log/mysqltes t-time)
:
/home/blg/uw713/mysql-4.1.3-beta/client/.libs/mysqltest: At line
421: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/func_group.result Sat Jun 26 16:20:58 2004
--- r/func_group.reject Sat Jun 26 21:52:57 2004
***************
*** 576,582 ****
explain
select min(a1) from t1 where a1 != 'KKK';
id select_type table type possible_keys key key_len
ref rows Extra
! 1 SIMPLE t1 range PRIMARY PRIMARY 3 NULL 14
Using where; Using index
explain
select max(a3) from t1 where a2 < 2 and a3 < 'SEA';
id select_type table type possible_keys key key_len
ref rows Extra
--- 576,582 ----
explain
select min(a1) from t1 where a1 != 'KKK';
id select_type table type possible_keys key key_len
ref rows Extra
! 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL
Impossible WHERE noticed after reading const tables
explain
select max(a3) from t1 where a2 < 2 and a3 < 'SEA';
id select_type table type possible_keys key key_len
ref rows Extra
***************
*** 621,627 ****
explain
select concat(min(t1.a1),min(t2.a4)) from t1, t2 where t2.a4 <> 'AME';
id select_type table type possible_keys key key_len
ref rows Extra
! 1 SIMPLE t2 range k2 k2 4 NULL 6
Using where; Using index
1 SIMPLE t1 index NULL PRIMARY 3 NULL 14
Using index
drop table t1, t2;
create table t1 (USR_ID integer not null, MAX_REQ integer not null,
constraint PK_SEA_USER primary key (USR_ID)) engine=InnoDB;
--- 621,627 ----
explain
select concat(min(t1.a1),min(t2.a4)) from t1, t2 where t2.a4 <> 'AME';
id select_type table type possible_keys key key_len
ref rows Extra
! 1 SIMPLE t2 ref k2 k2 4 const 6
Using where; Using index
1 SIMPLE t1 index NULL PRIMARY 3 NULL 14
Using index
drop table t1, t2;
create table t1 (USR_ID integer not null, MAX_REQ integer not null,
constraint PK_SEA_USER primary key (USR_ID)) engine=InnoDB;
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
Resuming Tests
grant_cache [ fail ]
Errors are (from
/home/blg/uw713/mysql-4.1.3-beta/mysql-test/var/log/mysqltes t-time)
:
/home/blg/uw713/mysql-4.1.3-beta/client/.libs/mysqltest: At line
136: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/grant_cache.result Sat Jun 26 16:20:58 2004
--- r/grant_cache.reject Sat Jun 26 21:53:18 2004
***************
*** 112,119 ****
Variable_name Value
Qcache_not_cached 1
show grants for current_user();
! Grants for @localhost
! GRANT USAGE ON *.* TO ''@'localhost'
select "user2";
user2
user2
--- 112,119 ----
Variable_name Value
Qcache_not_cached 1
show grants for current_user();
! Grants for root@localhost
! GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION
select "user2";
user2
user2
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
Resuming Tests
innodb_cache [ fail ]
Errors are (from
/home/blg/uw713/mysql-4.1.3-beta/mysql-test/var/log/mysqltes t-time)
:
/home/blg/uw713/mysql-4.1.3-beta/client/.libs/mysqltest: At line
83: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/innodb_cache.result Sat Jun 26 16:20:58 2004
--- r/innodb_cache.reject Sat Jun 26 21:54:38 2004
***************
*** 110,117 ****
--- 110,123 ----
drop table t1;
set GLOBAL query_cache_size=1355776;
CREATE TABLE t1 ( id int(10) NOT NULL auto_increment, a varchar(25)
default NULL, PRIMARY KEY (id), UNIQUE KEY a (a)) TYPE=innodb;
+ Warnings:
+ Warning 1287 'TYPE=storage_engine' is deprecated; use
'ENGINE=storage_engine' instead
CREATE TABLE t2 ( id int(10) NOT NULL auto_increment, b varchar(25)
default NULL, PRIMARY KEY (id), UNIQUE KEY b (b)) TYPE=innodb;
+ Warnings:
+ Warning 1287 'TYPE=storage_engine' is deprecated; use
'ENGINE=storage_engine' instead
CREATE TABLE t3 ( id int(10) NOT NULL auto_increment, t1_id int(10) NOT
NULL default '0', t2_id int(10) NOT NULL default '0', state int(11)
default NULL, PRIMARY KEY (id), UNIQUE KEY t1_id (t1_id,t2_id), KEY t2_id
(t2_id,t1_id), CONSTRAINT `t3_ibfk_1` FOREIGN KEY (`t1_id`) REFERENCES
`t1` (`id`), CONSTRAINT `t3_ibfk_2` FOREIGN KEY (`t2_id`) REFERENCES `t2`
(`id`)) TYPE=innodb;
+ Warnings:
+ Warning 1287 'TYPE=storage_engine' is deprecated; use
'ENGINE=storage_engine' instead
INSERT INTO t1 VALUES (1,'me');
INSERT INTO t2 VALUES (1,'you');
INSERT INTO t3 VALUES (2,1,1,2);
***************
*** 121,127 ****
begin;
insert into t3 VALUES ( NULL, 1, 1, 2 );
insert into t3 VALUES ( NULL, 1, 1, 2 );
! Duplicate entry '1-1' for key 2
commit;
select t1.* from t1, t2, t3 where t3.state & 1 = 0 and t3.t1_id = t1.id
and t3.t2_id = t2.id and t1.id = 1 order by t1.a asc;
id a
--- 127,133 ----
begin;
insert into t3 VALUES ( NULL, 1, 1, 2 );
insert into t3 VALUES ( NULL, 1, 1, 2 );
! ERROR 23000: Duplicate entry '1-1' for key 2
commit;
select t1.* from t1, t2, t3 where t3.state & 1 = 0 and t3.t1_id = t1.id
and t3.t2_id = t2.id and t1.id = 1 order by t1.a asc;
id a
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
Resuming Tests
negation_elimination [ fail ]
Errors are (from
/home/blg/uw713/mysql-4.1.3-beta/mysql-test/var/log/mysqltes t-time)
:
/home/blg/uw713/mysql-4.1.3-beta/client/.libs/mysqltest: At line
69: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/negation_elimination.result Sat Jun 26 16:20:58 2004
--- r/negation_elimination.reject Sat Jun 26 21:58:44 2004
***************
*** 55,82 ****
10
explain select * from t1 where not(a = 10);
id select_type table type possible_keys key key_len
ref rows Extra
! 1 SIMPLE t1 range a a 5 NULL 19
Using where; Using index
select * from t1 where not(a = 10);
a
- 0
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
explain select * from t1 where not(a != 10);
id select_type table type possible_keys key key_len
ref rows Extra
1 SIMPLE t1 ref a a 5 const 1
Using where; Using index
--- 55,63 ----
10
explain select * from t1 where not(a = 10);
id select_type table type possible_keys key key_len
ref rows Extra
! 1 SIMPLE t1 ref a a 5 const 19
Using where; Using index
select * from t1 where not(a = 10);
a
explain select * from t1 where not(a != 10);
id select_type table type possible_keys key key_len
ref rows Extra
1 SIMPLE t1 ref a a 5 const 1
Using where; Using index
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
Resuming Tests
range [ fail ]
Errors are (from
/home/blg/uw713/mysql-4.1.3-beta/mysql-test/var/log/mysqltes t-time)
:
/home/blg/uw713/mysql-4.1.3-beta/client/.libs/mysqltest: At line
386: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/range.result Sat Jun 26 16:20:58 2004
--- r/range.reject Sat Jun 26 21:59:42 2004
***************
*** 244,250 ****
1 SIMPLE t2 range x x 5 NULL 2
Using where
explain select count(*) from t1 where x in (1);
id select_type table type possible_keys key key_len
ref rows Extra
! 1 SIMPLE t1 ref x x 5 NULL 1
Using where; Using index
explain select count(*) from t1 where x in (1,2);
id select_type table type possible_keys key key_len
ref rows Extra
1 SIMPLE t1 range x x 5 NULL 2
Using where; Using index
--- 244,250 ----
1 SIMPLE t2 range x x 5 NULL 2
Using where
explain select count(*) from t1 where x in (1);
id select_type table type possible_keys key key_len
ref rows Extra
! 1 SIMPLE t1 ref x x 5 const 1
Using where; Using index
explain select count(*) from t1 where x in (1,2);
id select_type table type possible_keys key key_len
ref rows Extra
1 SIMPLE t1 range x x 5 NULL 2
Using where; Using index
***************
*** 416,422 ****
1 SIMPLE t2 ref uid_index uid_index 4
test.t1.uid 38
explain select * from t1, t2 where t1.uid=t2.uid AND t1.uid != 0;
id select_type table type possible_keys key key_len
ref rows Extra
! 1 SIMPLE t1 range uid_index uid_index 4
NULL 129 Using where
1 SIMPLE t2 ref uid_index uid_index 4
test.t1.uid 38
select * from t1, t2 where t1.uid=t2.uid AND t1.uid > 0;
id name uid id name uid
--- 416,422 ----
1 SIMPLE t2 ref uid_index uid_index 4
test.t1.uid 38
explain select * from t1, t2 where t1.uid=t2.uid AND t1.uid != 0;
id select_type table type possible_keys key key_len
ref rows Extra
! 1 SIMPLE t1 ref uid_index uid_index 4
const 129 Using where
1 SIMPLE t2 ref uid_index uid_index 4
test.t1.uid 38
select * from t1, t2 where t1.uid=t2.uid AND t1.uid > 0;
id name uid id name uid
***************
*** 448,477 ****
1026 Z 26 1026 Z 26
select * from t1, t2 where t1.uid=t2.uid AND t1.uid != 0;
id name uid id name uid
- 1001 A 1 1001 A 1
- 1002 B 2 1002 B 2
- 1003 C 3 1003 C 3
- 1004 D 4 1004 D 4
- 1005 E 5 1005 E 5
- 1006 F 6 1006 F 6
- 1007 G 7 1007 G 7
- 1008 H 8 1008 H 8
- 1009 I 9 1009 I 9
- 1010 J 10 1010 J 10
- 1011 K 11 1011 K 11
- 1012 L 12 1012 L 12
- 1013 M 13 1013 M 13
- 1014 N 14 1014 N 14
- 1015 O 15 1015 O 15
- 1016 P 16 1016 P 16
- 1017 Q 17 1017 Q 17
- 1018 R 18 1018 R 18
- 1019 S 19 1019 S 19
- 1020 T 20 1020 T 20
- 1021 U 21 1021 U 21
- 1022 V 22 1022 V 22
- 1023 W 23 1023 W 23
- 1024 X 24 1024 X 24
- 1025 Y 25 1025 Y 25
- 1026 Z 26 1026 Z 26
drop table t1,t2;
--- 448,451 ----
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
Resuming Tests
rpl000009 [ fail ]
Errors are (from
/home/blg/uw713/mysql-4.1.3-beta/mysql-test/var/log/mysqltes t-time)
:
/home/blg/uw713/mysql-4.1.3-beta/client/.libs/mysqltest: At line
173: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/rpl000009.result Sat Jun 26 16:20:58 2004
--- r/rpl000009.reject Sat Jun 26 22:00:31 2004
***************
*** 36,41 ****
--- 36,42 ----
mysqltest
mysqltest2
test
+ test_test
create table mysqltest2.t1(n int, s char(20));
create table mysqltest2.t2(n int, s text);
insert into mysqltest2.t1 values (1, 'one'), (2, 'two'), (3, 'three');
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
Resuming Tests
show_check [ fail ]
Errors are (from
/home/blg/uw713/mysql-4.1.3-beta/mysql-test/var/log/mysqltes t-time)
:
/home/blg/uw713/mysql-4.1.3-beta/client/.libs/mysqltest: At line
306: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/show_check.result Sat Jun 26 16:20:58 2004
--- r/show_check.reject Sat Jun 26 22:07:43 2004
***************
*** 48,56 ****
--- 48,58 ----
Database
mysql
test
+ test_test
show databases like "test%";
Database (test%)
test
+ test_test
create table t1 (f1 int not null, f2 int not null, f3 int not null, f4
int not null, primary key(f1,f2,f3,f4));
insert into t1 values
(1,1,1,0),(1,1,2,0),(1,1,3,0),(1,2,1,0),(1,2,2,0),(1,2,3,0), (1,3,1,0),(1,3,2,0),(1,3,3,0),(1,1,1,1),(1,1,2,1),(1,1,3,1), (1,2,1,1),(1,2,2,1),(1,2,3,1),(1,3,1,1),(1,3,2,1),(1,3,3,1);
analyze table t1;
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
Resuming Tests
subselect [ fail ]
Errors are (from
/home/blg/uw713/mysql-4.1.3-beta/mysql-test/var/log/mysqltes t-time)
:
/home/blg/uw713/mysql-4.1.3-beta/client/.libs/mysqltest: At line
1215: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/subselect.result Sat Jun 26 16:20:58 2004
--- r/subselect.reject Sat Jun 26 22:08:13 2004
***************
*** 1331,1342 ****
Note 1003 select test.t2.a AS `a` from test.t2 where
(test.t2.a,(((test.t2.a) in t1
on a)))
select * from t2 where t2.a in (select a from t1 where t1.b <> 30);
a
- 2
- 4
explain extended select * from t2 where t2.a in (select a from t1 where
t1.b <> 30);
id select_type table type possible_keys key key_len
ref rows Extra
1 PRIMARY t2 index NULL a 5 NULL 4
Using where; Using index
! 2 DEPENDENT SUBQUERY t1 index_subquery a a 5
func 1001 Using index; Using where
Warnings:
Note 1003 select test.t2.a AS `a` from test.t2 where
(test.t2.a,(((test.t2.a) in t1
on a where (test.t1.b <> 30))))
select * from t2 where t2.a in (select t1.a from t1,t3 where t1.b=t3.a);
--- 1331,1340 ----
Note 1003 select test.t2.a AS `a` from test.t2 where
(test.t2.a,(((test.t2.a) in t1
on a)))
select * from t2 where t2.a in (select a from t1 where t1.b <> 30);
a
explain extended select * from t2 where t2.a in (select a from t1 where
t1.b <> 30);
id select_type table type possible_keys key key_len
ref rows Extra
1 PRIMARY t2 index NULL a 5 NULL 4
Using where; Using index
! 2 DEPENDENT SUBQUERY t1 index_subquery a a 10
func,const 1000 Using index; Using where
Warnings:
Note 1003 select test.t2.a AS `a` from test.t2 where
(test.t2.a,(((test.t2.a) in t1
on a where (test.t1.b <> 30))))
select * from t2 where t2.a in (select t1.a from t1,t3 where t1.b=t3.a);
***************
*** 1353,1369 ****
insert into t1 values (3,31);
select * from t2 where t2.a in (select a from t1 where t1.b <> 30);
a
- 2
- 3
- 4
select * from t2 where t2.a in (select a from t1 where t1.b <> 30 and
t1.b <> 31);
a
- 2
- 4
explain extended select * from t2 where t2.a in (select a from t1 where
t1.b <> 30);
id select_type table type possible_keys key key_len
ref rows Extra
1 PRIMARY t2 index NULL a 5 NULL 4
Using where; Using index
! 2 DEPENDENT SUBQUERY t1 index_subquery a a 5
func 1001 Using index; Using where
Warnings:
Note 1003 select test.t2.a AS `a` from test.t2 where
(test.t2.a,(((test.t2.a) in t1
on a where (test.t1.b <> 30))))
drop table t1, t2, t3;
--- 1351,1362 ----
insert into t1 values (3,31);
select * from t2 where t2.a in (select a from t1 where t1.b <> 30);
a
select * from t2 where t2.a in (select a from t1 where t1.b <> 30 and
t1.b <> 31);
a
explain extended select * from t2 where t2.a in (select a from t1 where
t1.b <> 30);
id select_type table type possible_keys key key_len
ref rows Extra
1 PRIMARY t2 index NULL a 5 NULL 4
Using where; Using index
! 2 DEPENDENT SUBQUERY t1 index_subquery a a 10
func,const 1000 Using index; Using where
Warnings:
Note 1003 select test.t2.a AS `a` from test.t2 where
(test.t2.a,(((test.t2.a) in t1
on a where (test.t1.b <> 30))))
drop table t1, t2, t3;
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
Resuming Tests
o
--
Boyd Gerber
ZENEZ 1042 East Fort Union #135, Midvale Utah 84047
--
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