An error occurred fetching the project authors.
  1. 30 Jun, 2004 1 commit
    • igor@rurik.mysql.com's avatar
      subselect2.result, select.result: · d70f886f
      igor@rurik.mysql.com authored
        Post-merge fixes for nested joins.
        The join_tab_cmp function in sql_select has been changed.
      join_nested.result:
        Post-merge fixes for nested joins. 
        The join_tab_cmp function in sql_select has been changed
      sql_select.cc:
        Post-merge fixes for nested joins.
        Avoided re-execution of eliminate_not_funcs and simplify_joins
        in optimize_cond.
        Changed the join_tab_cmp function to take into account
        the dependent relation.
      sql_lex.cc, sql_lex.h:
        Added the first_cond_optimization flag to st_select_lex to avoid
        re-execution of some optimizations in optimize_cond.
      sql_base.cc:
        Post-merge fixes for nested joins. 
        Fixed problems with a proper column list substituted for '*' in
        queries with natural joins.
      d70f886f
  2. 25 Jun, 2004 4 commits
  3. 22 Jun, 2004 1 commit
    • sergefp@mysql.com's avatar
      Range optimizer fix: · f874071a
      sergefp@mysql.com authored
      If cost(full_scan_on_shortest_covering_index) < cost(best_range_scan) <  cost(full_table_scan)
        use full_scan_on_shortest_covering_index
      (before this fix best_range_scan was used)
      f874071a
  4. 16 Jun, 2004 5 commits
  5. 15 Jun, 2004 2 commits
  6. 14 Jun, 2004 4 commits
  7. 11 Jun, 2004 2 commits
  8. 10 Jun, 2004 1 commit
  9. 09 Jun, 2004 4 commits
  10. 08 Jun, 2004 2 commits
  11. 07 Jun, 2004 2 commits
  12. 03 Jun, 2004 1 commit
  13. 01 Jun, 2004 1 commit
  14. 29 May, 2004 2 commits
  15. 28 May, 2004 3 commits
    • sergefp@mysql.com's avatar
      * New index_merge EXPLAIN output format · dff98a8e
      sergefp@mysql.com authored
       * Fixed a problem with wrong query results for partially covering keys in ROR-index_merge
       * ROR-intersection retrieval plan choice algorithm now uses less disk IO
         - and properly processes clustered PK range scans 
       * Fixed several minor range optimizer problems
       * Added more comments
       * Code cleanup
      dff98a8e
    • pem@mysql.comhem.se's avatar
    • pem@mysql.comhem.se's avatar
      Added test cases for the following bugs that have been fixed by recent changes: · a4729a90
      pem@mysql.comhem.se authored
       BUG#1863: CREATE TABLE in Stored Procedure sometimes crashes on repeated calls.
       BUG#2656: select with join in stored procedure: erroneous result on 2nd call.
       BUG#3426: IF x IS NULL in stored procedure fails on second call within connection.
       BUG#3448: Stored Procedures with inner joins possible bug.
       BUG#3734: Stored procedure returns wrong rows with fulltext parameter.
       BUG#3863: Stored procedure crash when incrementing variable in a loop.
      
      (And corrected the row count output to the client after CALL)
      a4729a90
  16. 26 May, 2004 4 commits
  17. 25 May, 2004 1 commit