1. 30 Jun, 2004 3 commits
    • bell@sanja.is.com.ua's avatar
      24a8dc23
    • igor@rurik.mysql.com's avatar
      Merge rurik.mysql.com:/home/igor/mysql-5.0 · a0c83c0f
      igor@rurik.mysql.com authored
      into rurik.mysql.com:/home/igor/dev/mysql-5.0-1
      a0c83c0f
    • 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. 28 Jun, 2004 1 commit
  3. 25 Jun, 2004 4 commits
  4. 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
  5. 16 Jun, 2004 5 commits
  6. 15 Jun, 2004 2 commits
  7. 14 Jun, 2004 4 commits
  8. 11 Jun, 2004 2 commits
  9. 10 Jun, 2004 1 commit
  10. 09 Jun, 2004 4 commits
  11. 08 Jun, 2004 2 commits
  12. 07 Jun, 2004 2 commits
  13. 03 Jun, 2004 1 commit
  14. 01 Jun, 2004 1 commit
  15. 29 May, 2004 2 commits
  16. 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
  17. 26 May, 2004 2 commits