• unknown's avatar
    Bug #27531: the 4.1 fix. · 353b6f26
    unknown authored
    When checking for applicability of join cache
    we must disable its usage only if there is no
    temp table in use.
    When a temp table is used we can use join
    cache (and it will not make the result-set 
    unordered) to fill the temp table. The filesort() 
    operation is then applied to the data in the temp 
    table and hence is not affected by join cache
    usage.
    Fixed by narrowing the condition for disabling 
    join cache to exclude the case where temp table
    is used.
    
    
    mysql-test/r/join.result:
      Bug #27531: test case
    mysql-test/t/join.test:
      Bug #27531: test case
    sql/sql_select.cc:
      Bug #27531: 
      Disable join cache only if not using temp table
    353b6f26
sql_select.cc 301 KB