mysql-output.txt

mysql-output.txt (text/plain), 5.75 KB, created by Markus Rothe (RETIRED) on 2005-11-17 08:03:05 UTC

 * >>> Test phase [test]: dev-db/mysql-4.0.25-r2
cd mysql-test ; ./mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
running  ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=. --datadir=./var/master-data --skip-innodb --skip-bdb --skip-warnings --language=../sql/share/english/
051117 18:45:44 ../sql/mysqld: Shutdown Complete

Installing Slave Databases
running  ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables     --basedir=. --datadir=./var/slave-data --skip-innodb --skip-bdb --skip-warnings --language=../sql/share/english/
051117 18:45:45 ../sql/mysqld: Shutdown Complete

Manager disabled, skipping manager start.
Loading Standard Test Databases
Starting Tests

 TEST                           RESULT
------------------------------------------
alias                          [ pass ]
alter_table                    [ pass ]
analyse                        [ pass ]
analyze                        [ pass ]
ansi                           [ pass ]
auto_increment                 [ pass ]
backup                         [ pass ]
bdb-alter-table-1              [ pass ]
bdb-alter-table-2              [ pass ]
bdb-crash                      [ pass ]
bdb-deadlock                   [ pass ]
bdb                            [ fail ]

Errors are (from /var/tmp/portage/mysql-4.0.25-r2/work/mysql/mysql-test/var/log/mysqltest-time) :
/var/tmp/portage/mysql-4.0.25-r2/work/mysql/client/.libs/mysqltest: At line 869: Result length mismatch
(the last line(s) may be the ones that caused the die() in mysqltest)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/bdb.result        2005-06-29 20:32:01.000000000 +0300
--- r/bdb.reject        2005-11-17 18:46:36.000000000 +0300
***************
*** 140,152 ****
  1015  102     2
  explain select level from t1 where level=1;
  table type    possible_keys   key     key_len ref     rows    Extra
! t1    ref     level   level   1       const   1       Using where; Using index
  explain select level,id from t1 where level=1;
  table type    possible_keys   key     key_len ref     rows    Extra
! t1    ref     level   level   1       const   1       Using where; Using index
  explain select level,id,parent_id from t1 where level=1;
  table type    possible_keys   key     key_len ref     rows    Extra
! t1    ref     level   level   1       const   1       Using where
  select level,id from t1 where level=1;
  level id
  1     1002
--- 140,152 ----
  1015  102     2
  explain select level from t1 where level=1;
  table type    possible_keys   key     key_len ref     rows    Extra
! t1    ref     level   level   1       const   4294967296      Using where; Using index
  explain select level,id from t1 where level=1;
  table type    possible_keys   key     key_len ref     rows    Extra
! t1    ref     level   level   1       const   4294967296      Using where; Using index
  explain select level,id,parent_id from t1 where level=1;
  table type    possible_keys   key     key_len ref     rows    Extra
! t1    ref     level   level   1       const   4294967296      Using where
  select level,id from t1 where level=1;
  level id
  1     1002
***************
*** 625,631 ****
  1016  102     2
  explain select level from t1 where level=1;
  table type    possible_keys   key     key_len ref     rows    Extra
! t1    ref     level   level   1       const   1       Using where; Using index
  select level,id from t1 where level=1;
  level id
  1     1004
--- 625,631 ----
  1016  102     2
  explain select level from t1 where level=1;
  table type    possible_keys   key     key_len ref     rows    Extra
! t1    ref     level   level   1       const   4294967296      Using where; Using index
  select level,id from t1 where level=1;
  level id
  1     1004
***************
*** 1169,1182 ****
  insert into t1 values ('a',1),('A',2);
  explain select a from t1;
  table type    possible_keys   key     key_len ref     rows    Extra
! t1    ALL     NULL    NULL    NULL    NULL    2
  select a from t1;
  a
  a
  A
  explain select b from t1;
  table type    possible_keys   key     key_len ref     rows    Extra
! t1    index   NULL    b       4       NULL    2       Using index
  select b from t1;
  b
  1
--- 1169,1182 ----
  insert into t1 values ('a',1),('A',2);
  explain select a from t1;
  table type    possible_keys   key     key_len ref     rows    Extra
! t1    ALL     NULL    NULL    NULL    NULL    8589934592
  select a from t1;
  a
  a
  A
  explain select b from t1;
  table type    possible_keys   key     key_len ref     rows    Extra
! t1    index   NULL    b       4       NULL    8589934592      Using index
  select b from t1;
  b
  1
***************
*** 1184,1190 ****
  alter table t1 modify a char(10) binary;
  explain select a from t1;
  table type    possible_keys   key     key_len ref     rows    Extra
! t1    index   NULL    a       11      NULL    2       Using index
  select a from t1;
  a
  A
--- 1184,1190 ----
  alter table t1 modify a char(10) binary;
  explain select a from t1;
  table type    possible_keys   key     key_len ref     rows    Extra
! t1    index   NULL    a       11      NULL    0       Using index
  select a from t1;
  a
  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.

Test bdb failed!

Aborting: bdb failed. To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon

Master shutdown finished
Slave shutdown finished
make: *** [test] Error 1

!!! ERROR: dev-db/mysql-4.0.25-r2 failed.
!!! Function src_test, Line 266, Exitcode 1
!!! make test failed
!!! If you need support, post the topmost build error, NOT this status message.