Re: Lastes mysql-4.1 bk as of 06/25/04 problems on UnixWare 7.1.

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-time) 
> :
> /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/mysqltest-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/mysqltest-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/mysqltest-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/mysqltest-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/mysqltest-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/mysqltest-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/mysqltest-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/mysqltest-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/mysqltest-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 
<in_optimizer>(test.t2.a,<exists>(<index_lookup>(<cache>(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 
<in_optimizer>(test.t2.a,<exists>(<index_lookup>(<cache>(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 
<in_optimizer>(test.t2.a,<exists>(<index_lookup>(<cache>(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 
<in_optimizer>(test.t2.a,<exists>(<index_lookup>(<cache>(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 
<in_optimizer>(test.t2.a,<exists>(<index_lookup>(<cache>(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 
<in_optimizer>(test.t2.a,<exists>(<index_lookup>(<cache>(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 <[email protected]>
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/[email protected]