Bug #7266 Test failure: 'greedy_optimizer'
Description:
Test 'greedy_optimizer' fails for me in current 5.0,
both with and without the option '--ps-protocol'.
This is a non-debug build: 'compile-pentium-max'.
Failure report:
-------------------------------------------------------
*** r/greedy_optimizer.result 2004-11-05 12:13:03.000000000 +0300
--- r/greedy_optimizer.reject 2004-12-14 12:22:04.000000000 +0300
***************
*** 122,132 ****
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 3
1 SIMPLE t2 ALL NULL NULL NULL NULL 6 Using where
! 1 SIMPLE t3 eq_ref PRIMARY PRIMARY 4 test.t2.c22 1
! 1 SIMPLE t4 ALL NULL NULL NULL NULL 12 Using where
! 1 SIMPLE t5 eq_ref PRIMARY PRIMARY 4 test.t4.c42 1
! 1 SIMPLE t6 ALL NULL NULL NULL NULL 18 Using where
1 SIMPLE t7 eq_ref PRIMARY PRIMARY 4 test.t6.c62 1 Using index
show status like 'Last_query_cost';
Variable_name Value
Last_query_cost 821.838037
--- 122,132 ----
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ALL NULL NULL NULL NULL 3
1 SIMPLE t2 ALL NULL NULL NULL NULL 6 Using where
! 1 SIMPLE t6 ALL NULL NULL NULL NULL 18
1 SIMPLE t7 eq_ref PRIMARY PRIMARY 4 test.t6.c62 1 Using index
+ 1 SIMPLE t4 ALL NULL NULL NULL NULL 12
+ 1 SIMPLE t3 eq_ref PRIMARY PRIMARY 4 test.t2.c22 1 Using where
+ 1 SIMPLE t5 eq_ref PRIMARY PRIMARY 4 test.t4.c42 1 Using where
show status like 'Last_query_cost';
Variable_name Value
Last_query_cost 821.838037
***************
*** 134,192 ****
...
Similar re-orderings and adding/dropping 'Using where' continue throughout that range of line numbers.
...
-------------------------------------------------------
Latest changeset on my PC:
ChangeSet@1.1738, 2004-12-14 13:41:32+03:00, gluh@gluh.mysql.r18.ru
Fix for bug #7223: information_schema: error in "views"
The error is older, as I got it already yesterday but did not yet report.
How to repeat:
Run the test suite.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.