• unknown's avatar
    Bug #22781: SQL_BIG_RESULT fails to influence sort plan · 45cad70f
    unknown authored
     Currently SQL_BIG_RESULT is checked only at compile time.
     However, additional optimizations may take place after
     this check that change the sort method from 'filesort'
     to sorting via index. As a result the actual plan
     executed is not the one specified by the SQL_BIG_RESULT
     hint. Similarly, there is no such test when executing
     EXPLAIN, resulting in incorrect output.
     The patch corrects the problem by testing for
     SQL_BIG_RESULT both during the explain and execution
     phases.
    
    
    mysql-test/r/bdb.result:
      Bug #22781: SQL_BIG_RESULT fails to influence sort plan
       - updated sql_big_result testcase
    mysql-test/r/group_by.result:
      Bug #22781: SQL_BIG_RESULT fails to influence sort plan
       - test case with MyISAM
    mysql-test/r/innodb.result:
      Bug #22781: SQL_BIG_RESULT fails to influence sort plan
       - updated sql_big_result testcase
    mysql-test/r/innodb_mysql.result:
      Bug #22781: SQL_BIG_RESULT fails to influence sort plan
       - test case with InnoDB
    mysql-test/r/myisam.result:
      Bug #22781: SQL_BIG_RESULT fails to influence sort plan
       - updated sql_big_result testcase
    mysql-test/t/group_by.test:
      Bug #22781: SQL_BIG_RESULT fails to influence sort plan
       - test case with MyISAM
    mysql-test/t/innodb_mysql.test:
      Bug #22781: SQL_BIG_RESULT fails to influence sort plan
       - test case with InnoDB
    sql/sql_select.cc:
      Bug #22781: SQL_BIG_RESULT fails to influence sort plan
       - When SQL_BIG_RESULT is specified, disable the optimization performed
      at execution/explain time that decides to use an index instead
      of filesort.
    45cad70f
group_by.result 31.4 KB