1. 12 Apr, 2005 1 commit
    • unknown's avatar
      BUG#8924 'Explain' shows different strategy · 5b5a1239
      unknown authored
       - If number of records in table is 4, the calculated cost for using "index" and "range" become so close so that any rounding errors becomes visible.
       - Added one more record to the tables for heap test and expoect "range" to be selected
       - Decrease number of records in t1 for range and expect "index" to be choosen.
      
      
      mysql-test/r/heap.result:
        Add one more record to table t1 and expect explain to use "range"
      mysql-test/r/heap_btree.result:
        Add one more record to table t1 and expect explain to use "range"
      mysql-test/r/heap_hash.result:
        Add one more record to table t1 and expect explain to use "range"
      mysql-test/r/range.result:
        Update results
      mysql-test/t/heap.test:
        Add one more record to table t1 and expect explain to use "range"
      mysql-test/t/heap_btree.test:
        Add one more record to table t1 and expect explain to use "range"
      mysql-test/t/heap_hash.test:
        Add one more record to table t1 in order for optimizer to select use of "range" deterministic
      mysql-test/t/range.test:
        Remove one record from table t1 to avoid that cost for "index" and "range" are so close that rounding error become visible.
      5b5a1239
  2. 07 Apr, 2005 23 commits
  3. 06 Apr, 2005 16 commits
    • unknown's avatar
      Merge mysql.com:/home/jimw/my/mysql-4.1-clean · 1ef9b972
      unknown authored
      into mysql.com:/home/jimw/my/mysql-5.0-clean
      
      
      client/mysqlcheck.c:
        Auto merged
      1ef9b972
    • unknown's avatar
      Fix for bug #9566 "explicit LOCK TABLE and store procedures result in · 188b8af6
      unknown authored
      illegal state".
      
      We should not assume that mysql.proc table does not exist if we are
      unable to open it under LOCK TABLES or in prelocked mode (and
      remember this fact by setting mysql_proc_table_exists to zero).
      
      
      mysql-test/r/sp.result:
        Added test for bug #9566 "explicit LOCK TABLE and store procedures result in illegal
        state"
      mysql-test/t/sp.test:
        Added test for bug #9566 "explicit LOCK TABLE and store procedures result in illegal
        state"
      sql/sp.cc:
        db_find_routine_aux():
          We should not assume that mysql.proc table does not exist if we are
          unable to open it under LOCK TABLES or in prelocked mode since this
          condition may be transient.
      188b8af6
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.0 · 0ec06cab
      unknown authored
      into serg.mylan:/usr/home/serg/Abk/mysql-5.0
      
      
      0ec06cab
    • unknown's avatar
      after merge fix · 1fcebd55
      unknown authored
      
      mysql-test/r/user_var.result:
        after merge fixes - old (erroneous) results restored.
        Should be corrected when the fix is applied
      mysql-test/t/user_var.test:
        after merge fixes - old (erroneous) results restored.
        Should be corrected when the fix is applied
      1fcebd55
    • unknown's avatar
      manually merged · 3960c84f
      unknown authored
      Gluh's SESSION/GLOBAL for @variables fix in sql_yacc.yy and
      Bar's well_formed_len() changes in ndb code
      did not make it and should be re-applied manually
      
      
      BitKeeper/etc/logging_ok:
        auto-union
      include/m_ctype.h:
        Auto merged
      innobase/btr/btr0pcur.c:
        Auto merged
      innobase/include/btr0pcur.h:
        Auto merged
      innobase/include/os0file.h:
        Auto merged
      innobase/os/os0file.c:
        Auto merged
      innobase/row/row0sel.c:
        Auto merged
      innobase/srv/srv0start.c:
        Auto merged
      mysql-test/r/user_var.result:
        Auto merged
      mysql-test/t/user_var.test:
        Auto merged
      ndb/include/ndbapi/NdbTransaction.hpp:
        Auto merged
      ndb/src/ndbapi/NdbTransaction.cpp:
        Auto merged
      ndb/tools/desc.cpp:
        Auto merged
      strings/ctype-big5.c:
        Auto merged
      strings/ctype-mb.c:
        Auto merged
      strings/ctype-simple.c:
        Auto merged
      strings/ctype-sjis.c:
        Auto merged
      strings/ctype-ucs2.c:
        Auto merged
      strings/ctype-ujis.c:
        Auto merged
      BitKeeper/deleted/.del-NdbResultSet.cpp~84d192cf3f42600d:
        ul
      ndb/include/ndbapi/NdbScanOperation.hpp:
        ul
      ndb/src/ndbapi/NdbIndexOperation.cpp:
        ul
      ndb/src/ndbapi/NdbOperationDefine.cpp:
        ul
      ndb/src/ndbapi/NdbOperationSearch.cpp:
        ul
      ndb/src/ndbapi/NdbScanOperation.cpp:
        ul
      sql/field.cc:
        manually merged, because bk messed it up
      sql/sql_yacc.yy:
        merged
      3960c84f
    • unknown's avatar
      Merge jamppa@bk-internal.mysql.com:/home/bk/mysql-5.0 · d30aa11c
      unknown authored
      into a193-229-222-105.elisa-laajakaista.fi:/home/my/bk/mysql-5.0-new
      
      
      d30aa11c
    • unknown's avatar
      Added missing file to Makefile.am · 86655591
      unknown authored
      86655591
    • unknown's avatar
      merged · 6f23625d
      unknown authored
      6f23625d
    • unknown's avatar
      Minor fix in cursors execution. · df64ac0b
      unknown authored
      
      sql/sql_select.cc:
        Fix a discrepancy spotted after the setup_end_select_func patch has been 
        pushed: last join sweep assumes that join->tmp_table is zero.
      df64ac0b
    • unknown's avatar
      Merge mysql.com:/home/jimw/my/mysql-4.0-clean · 0d17aea7
      unknown authored
      into mysql.com:/home/jimw/my/mysql-4.1-clean
      
      
      client/mysqlcheck.c:
        Auto merged
      mysys/my_rename.c:
        Auto merged
      0d17aea7
    • unknown's avatar
      Merge mysql.com:/home/jimw/my/mysql-4.0-9492 · c6bb2293
      unknown authored
      into mysql.com:/home/jimw/my/mysql-4.0-clean
      
      
      c6bb2293
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · f6853d04
      unknown authored
      into mysql.com:/media/sda1/mysql/mysql-5.0-9520
      
      
      f6853d04
    • unknown's avatar
      Refactor parts of do_select() (JOIN execution). · 61c8b3a8
      unknown authored
      
      sql/sql_select.cc:
        Bits of refactoring of do_select as one step forward to merge cursor and
        non-cursor execution.
        Moving send_fields (metadata handling) out of do_select to one level up
        and moving end_select setting to a separate function.
        This function is used in the Cursor::open() too.
      61c8b3a8
    • unknown's avatar
      Merge kboortz@bk-internal.mysql.com:/home/bk/mysql-5.0 · 231f705c
      unknown authored
      into mysql.com:/Users/kent/mysql/bk/mysql-5.0-compile
      
      
      231f705c
    • unknown's avatar
      Fixed errors found during review · 7503894a
      unknown authored
      
      mysql-test/r/drop.result:
        Made error message smaller to not get into trouble with clients with smaller error buffers
        The proper way to fix this is to generate a separate warning for each not found table if there was more than one table in the DROP
        but
      mysql-test/r/kill.result:
        Portablity fix
      mysql-test/t/kill.test:
        Portablity fix
      mysys/my_sync.c:
        Fixed possible compiler warning
      sql/records.cc:
        Fixed possible compiler warning
      sql/share/errmsg.txt:
        Made error message smaller to not get into trouble with clients with smaller error buffers
      sql/sql_class.cc:
        Don't put code in comments
      sql/sql_show.cc:
        Cleanup
      7503894a
    • unknown's avatar
      Merge · 1655e97f
      unknown authored
      
      mysql-test/mysql-test-run.pl:
        Auto merged
      mysql-test/r/rpl_rewrite_db.result:
        Auto merged
      1655e97f