• unknown's avatar
    sql_select.cc: · 74e523d2
    unknown authored
      Fixed bug #12144.
      Added an optimization that avoids key access with null keys for the 'ref'
      method when used in outer joins. The regilar optimization with adding
      IS NOT NULL expressions is not applied for outer join on expressions as
      the predicates of these expressions are not pushed down in 4.1.
    null_key.result, null_key.test:
      Added a test case for bug #12144.
    
    
    mysql-test/t/null_key.test:
      Added a test case for bug #12144.
    mysql-test/r/null_key.result:
      Added a test case for bug #12144.
    sql/sql_select.cc:
      Fixed bug #12144.
      Added an optimization that avoids key access with null keys for the 'ref'
      method when used in outer joins. The regilar optimization with adding
      IS NOT NULL expressions is not applied for outer join on expressions as
      the predicates of these expressions are not pushed down in 4.1.
    74e523d2
null_key.test 7.95 KB