From: Ole John Aske Date: December 2 2010 8:51am Subject: bzr commit into mysql-5.1-telco-7.0-spj-scan-vs-scan branch (ole.john.aske:3384) List-Archive: http://lists.mysql.com/commits/125768 Message-Id: <20101202085122.12337222@fimafeng09.norway.sun.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============0669407642028459330==" --===============0669407642028459330== MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline #At file:///net/fimafeng09/export/home/tmp/oleja/mysql/mysql-5.1-telco-7.0-spj-scan-scan/ based on revid:ole.john.aske@stripped 3384 Ole John Aske 2010-12-02 Updated result file after merge. Required as ndb_join_pushdown is default 'true' in the SPJ branch which cause a different explain output. modified: mysql-test/suite/ndb/r/ndb_condition_pushdown.result === modified file 'mysql-test/suite/ndb/r/ndb_condition_pushdown.result' --- a/mysql-test/suite/ndb/r/ndb_condition_pushdown.result 2010-12-01 22:00:42 +0000 +++ b/mysql-test/suite/ndb/r/ndb_condition_pushdown.result 2010-12-02 08:51:17 +0000 @@ -2236,6 +2236,7 @@ id select_type table type possible_keys 1 SIMPLE tx ALL NULL NULL NULL NULL 0 0.00 Using where with pushed condition: (`test`.`tx`.`c` = 1) 1 SIMPLE t2 ALL NULL NULL NULL NULL 0 0.00 Using where with pushed condition: (`test`.`t2`.`c` = 1); Using join buffer Warnings: +Note 1644 Can't push table 't2' as child, 'type' must be a 'ref' access Note 1003 select `test`.`tx`.`a` AS `a`,`test`.`tx`.`b` AS `b`,`test`.`tx`.`c` AS `c`,`test`.`tx`.`d` AS `d`,`test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`tx` join `test`.`tx` `t2` where ((`test`.`tx`.`c` = 1) and (`test`.`t2`.`c` = 1)) explain extended select straight_join * @@ -2244,10 +2245,10 @@ join tx as t2 on t2.a = tx.a and t2.b = join tx as t3 on t3.a = tx.c and t3.b = tx.d join tx as t4 on t4.a = t3.b and t4.b = t2.c; id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE tx ALL PRIMARY NULL NULL NULL 0 0.00 -1 SIMPLE t2 eq_ref PRIMARY PRIMARY 8 test.tx.a,test.tx.b 1 100.00 -1 SIMPLE t3 eq_ref PRIMARY PRIMARY 8 test.tx.c,test.tx.d 1 100.00 -1 SIMPLE t4 eq_ref PRIMARY PRIMARY 8 test.tx.d,test.t2.c 1 100.00 +1 SIMPLE tx ALL PRIMARY NULL NULL NULL 0 0.00 Parent of 4 pushed join@1 +1 SIMPLE t2 eq_ref PRIMARY PRIMARY 8 test.tx.a,test.tx.b 1 100.00 Child of pushed join@1 +1 SIMPLE t3 eq_ref PRIMARY PRIMARY 8 test.tx.c,test.tx.d 1 100.00 Child of pushed join@1 +1 SIMPLE t4 eq_ref PRIMARY PRIMARY 8 test.tx.d,test.t2.c 1 100.00 Child of pushed join@1 Warnings: Note 1003 select straight_join `test`.`tx`.`a` AS `a`,`test`.`tx`.`b` AS `b`,`test`.`tx`.`c` AS `c`,`test`.`tx`.`d` AS `d`,`test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d`,`test`.`t3`.`a` AS `a`,`test`.`t3`.`b` AS `b`,`test`.`t3`.`c` AS `c`,`test`.`t3`.`d` AS `d`,`test`.`t4`.`a` AS `a`,`test`.`t4`.`b` AS `b`,`test`.`t4`.`c` AS `c`,`test`.`t4`.`d` AS `d` from `test`.`tx` join `test`.`tx` `t2` join `test`.`tx` `t3` join `test`.`tx` `t4` where ((`test`.`t2`.`b` = `test`.`tx`.`b`) and (`test`.`t2`.`a` = `test`.`tx`.`a`) and (`test`.`t3`.`a` = `test`.`tx`.`c`) and (`test`.`t4`.`b` = `test`.`t2`.`c`) and (`test`.`t3`.`b` = `test`.`tx`.`d`) and (`test`.`t4`.`a` = `test`.`tx`.`d`)) explain extended @@ -2260,12 +2261,15 @@ id select_type table type possible_keys 1 SIMPLE t2 ref PRIMARY PRIMARY 4 const 10 100.00 Using where; Using filesort 1 SIMPLE tx eq_ref PRIMARY PRIMARY 8 test.t2.c,test.t2.d 1 100.00 Warnings: +Note 1644 Table 't2' is not pushable: GROUP BY cannot be done using index on grouped columns. +Note 1644 Table 'tx' is not pushable: GROUP BY cannot be done using index on grouped columns. Note 1003 select `test`.`t2`.`c` AS `c`,count(distinct `test`.`t2`.`a`) AS `count(distinct t2.a)` from `test`.`tx` join `test`.`tx` `t2` where ((`test`.`tx`.`b` = `test`.`t2`.`d`) and (`test`.`tx`.`a` = `test`.`t2`.`c`) and (`test`.`t2`.`a` = 4)) group by `test`.`t2`.`c` explain extended select * from tx join tx as t2 on tx.c=1 where t2.c=1; id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tx ALL NULL NULL NULL NULL 0 0.00 Using where with pushed condition: (`test`.`tx`.`c` = 1) 1 SIMPLE t2 ALL NULL NULL NULL NULL 0 0.00 Using where with pushed condition: (`test`.`t2`.`c` = 1); Using join buffer Warnings: +Note 1644 Can't push table 't2' as child, 'type' must be a 'ref' access Note 1003 select `test`.`tx`.`a` AS `a`,`test`.`tx`.`b` AS `b`,`test`.`tx`.`c` AS `c`,`test`.`tx`.`d` AS `d`,`test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c`,`test`.`t2`.`d` AS `d` from `test`.`tx` join `test`.`tx` `t2` where ((`test`.`tx`.`c` = 1) and (`test`.`t2`.`c` = 1)) explain extended select t2.c, count(distinct t2.a) @@ -2277,6 +2281,8 @@ id select_type table type possible_keys 1 SIMPLE t2 ref PRIMARY PRIMARY 4 const 10 100.00 Using where; Using filesort 1 SIMPLE tx eq_ref PRIMARY PRIMARY 8 test.t2.c,test.t2.d 1 100.00 Warnings: +Note 1644 Table 't2' is not pushable: GROUP BY cannot be done using index on grouped columns. +Note 1644 Table 'tx' is not pushable: GROUP BY cannot be done using index on grouped columns. Note 1003 select `test`.`t2`.`c` AS `c`,count(distinct `test`.`t2`.`a`) AS `count(distinct t2.a)` from `test`.`tx` join `test`.`tx` `t2` where ((`test`.`tx`.`b` = `test`.`t2`.`d`) and (`test`.`tx`.`a` = `test`.`t2`.`c`) and (`test`.`t2`.`a` = 4)) group by `test`.`t2`.`c` drop table tx; set engine_condition_pushdown = @old_ecpd; --===============0669407642028459330== MIME-Version: 1.0 Content-Type: text/bzr-bundle; charset="us-ascii"; name="bzr/ole.john.aske@stripped" Content-Transfer-Encoding: 7bit Content-Disposition: inline # Bazaar merge directive format 2 (Bazaar 0.90) # revision_id: ole.john.aske@stripped\ # p0jvx59vy3irxyvo # target_branch: file:///net/fimafeng09/export/home/tmp/oleja/mysql\ # /mysql-5.1-telco-7.0-spj-scan-scan/ # testament_sha1: 0778a2694aae711376d8f02ea8c35bf74bbe4628 # timestamp: 2010-12-02 09:51:21 +0100 # source_branch: bzr+ssh://oaske@stripped/bzrroot/server\ # /mysql-5.1-telco-7.0-spj/ # base_revision_id: ole.john.aske@stripped\ # 22mf7mvxdl7q2t9i # # Begin bundle IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWbqHr7UAAjFfgEAwUOf/93q3 3iC////wUAVM68008dby010evdhtCSSmBPU1B6j1PKaaYmIHqPU8kAAD1AJKamRU/00Tanop6ptD U0bU0aGTEYATIZAlNTSZNRMTQ0ekyaMjQAAANAAJJI1T8piCNqNPKaaZqNAGgGhptQACSQg0GkYg TZE0xApp+qPUPUAD1NNGs07F12udRCtX5SSKUgBuxYIwhCmp3IuFNl0fMmRzYNDfFdJskLHbc0ih YDSzQrzSm+KM5T2u8sD5RlLe5ksSQ3v6BXGV9RHL6aKgsNUIVb+NOXLXaHCD7CDUGYsvi7bA9cw8 GxRCA1v7eCFoOoCQLHFc6Jqm4AnOVQ2DbROJeETug+ClPzDn1eloJilwyGmIc6EhhHHSqu+s+BEQ +Hx0eJGRj1F8UZY9dm8NVMwdGdsikNe06QxockQcLY6yF/2VBOKtglzgpoPCVQoFSwKQQwMwoJOJ b2N4sgPT1sO+hTrmD3C0JmJNLlQoiPJjIy9KYifB8wi4YNNLsO+8ZfkYVTSFpFiX5PI+0cPA5vM8 SnulANQN+BcDCKiQxrDIaZWzEiQIsV60QZp12O99BxObwg69j5g46F8PIa+OzXtGK1qTh0qcFnR0 FPqFLXWPGqWOsUDQKBIrKjhAtONz3m0pjuiPFcqqrTiEeT7z2bYpnQRpjPQZ71um0syFVSxnEqUU kn3QbgiLL3bUnmHET4I1mGCak2uKg36w2J88nYzfVa5PLcRS3NGowlo3S6Fl5eo7L9shhXIzNYXC kEc6BfN0ouhcxQyISJoM8iEItnKbsaDkpVemqUHpFWtKaSdhhmDpgjqB7w8kvMOmqAMH8Xh5JEVI UQ+lYW3hOBFL+gqSsgDMH9r4CqtLwDqsN2D2Q8Hey9+uJTKOtoA/tVZXncy0Daonl4ShiO65Imf0 kO1CFnbRivJ4hkYc0yHqhI5Tda6THDZaWWmMwogyOyzC/TSIdys9QGoI09xQik9uXsT2YGWQ0SLm SM3hJIn6pveIgnOGzx05fkuvUE5lT4E9WutGWZjk8IFTLM/EJuZMDFv66zoLYL9Gnka3uBrQ33H8 wSRhqZShi4x26+UQ89t6Rj01M6e0IbTX44Be8JqTPg4cXbjU4UaXcEcbU3uHyB7plarIH1O3qs1E 9BBEkzxShngoSV4MXkS+2cPKd64TrCv6dHdja4882eGD0VzBnNvEMYhnAtyZwf2hPN0FfSgU3srY NfQm6QhzmRUoxCBjqtkjyCAPwD/t2uEAirchUo3g+5cKPPfA9TseiRUG3Uegs7WsBTB2HHhxBwXO kDK5uaOYvucVpGSQ6ANnuuC2ygS+XAk/mvAq18LTcG+u6E5EzEE3pTLQM7lB1FmIuRBMlSocJGiG +ATpTs5E7w6hOFkg39yVLJlp4d4Ym90GqD03wDaD9GQ5uGIBYFyTKQcdx5/tI4gmuFlmB5iriF2c 0G8KqpPwsytlMBmCewjp2X3JhZQYL+IcVzKhzcHcnUvUgDzM4L5k1ArPlL1eTFFSy0Pv8wnnmtE5 aC0ezBEJobijGTD3FjwCkHftUkWFSy7ePi1mRouUhgLgk4d9UtJeFMG2Dwe+MwvecNrjeEaMyjcN WJ+2fT02fSxmZtFYzUVdLytWhJXupWyhJ5RDihqsY+9uOOFRpCYNVrEqBsGh2UW5UDCsFAO8TXIl cAZJxoESBhQOFtPIE+MUMNRH/i7kinChIXUPX2o= --===============0669407642028459330==--