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 <gerberb@stripped>
ZENEZ 1042 East Fort Union #135, Midvale Utah 84047
