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

Hi Sergei,

On Sat, 26 Jun 2004, Sergei Golubchik wrote:
> On Jun 26, Boyd Lynn Gerber wrote:
> > 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 ]
> 
> Fixed today

Thanks for looking in to these. I just did a new bk pull and one test
is still failing.  The pull was 16:00 MDT time.  I do not know if all the
post of changes have made it to public bk yet.  I know you are trying to
get a new version of MySQL-4.1 out.  And I hope to not have any problems
on UnixWare by the time it is released.


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 18:45:33 2004
--- r/func_group.reject Sun Jun 27 00:52:59 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  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
--- 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
***************
*** 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;
--- 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;
-------------------------------------------------------
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


Thanks,




--
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]