1. 31 Jan, 2006 10 commits
  2. 30 Jan, 2006 13 commits
    • unknown's avatar
      Merge pgalbraith@bk-internal.mysql.com:/home/bk/mysql-5.0 · 7ed62789
      unknown authored
      into  govinda.patg.net:/home/patg/mysql-build/mysql-5.0
      
      7ed62789
    • unknown's avatar
      Merge mysql.com:/home/alexi/innodb/mysql-4.1-ss20 · d076e73f
      unknown authored
      into  mysql.com:/home/alexi/innodb/mysql-5.0-ss20
      
      
      innobase/btr/btr0sea.c:
        Null merged
      innobase/fil/fil0fil.c:
        Null merged
      d076e73f
    • unknown's avatar
      Fixed BUG#15653, BUG#16582. · 1675beef
      unknown authored
        Applied innodb-4.1-ss20 snapshot.
      
      
      innobase/btr/btr0sea.c:
        Applied innodb-4.1-ss20 snapshot.
          Account for a race condition when dropping the adaptive
          hash index for a B-tree page (Bug #16582).
          btr_search_drop_page_hash_index(): Retry the operation if a hash
          index with different parameters was built meanwhile. Add
          diagnostics for the case that hash node pointers to the page
          remain. This fix is from Heikki.
          btr_search_info_update_hash(), btr_search_info_update_slow():
          Document the parameter "info" as in/out.
      innobase/fil/fil0fil.c:
        Applied innodb-4.1-ss20 snapshot.
          Keep track on unflushed modifications to file spaces. When
          there are tens of thousnads of file spaces, flushing all files
          in fil_flush_file_spaces() would be very slow (Bug #16582).
          fil_flush_file_spaces(): Only flush unflushed file spaces.
          fil_space_t, fil_system_t: Add a list of unflushed spaces.
      innobase/include/btr0sea.ic:
        Applied innodb-4.1-ss20 snapshot.
          btr_search_info_update_hash(), btr_search_info_update_slow():
          Document the parameter "info" as in/out.
      1675beef
    • unknown's avatar
      Merge pgalbraith@bk-internal.mysql.com:/home/bk/mysql-5.0 · e93007b0
      unknown authored
      into  govinda.patg.net:/home/patg/mysql-build/mysql-5.0
      
      e93007b0
    • unknown's avatar
      Merge mysql.com:/extern/mysql/bk/mysql-5.0 · d6201a76
      unknown authored
      into  mysql.com:/extern/mysql/work/bug15737/mysql-5.0
      
      d6201a76
    • unknown's avatar
      Merge mysql.com:/extern/mysql/bk/mysql-5.0 · 00c1c6b6
      unknown authored
      into  mysql.com:/extern/mysql/work/bug15737/mysql-5.0
      
      00c1c6b6
    • unknown's avatar
      Post-review fix for BUG#15737 (corrected typo in sp-code.test comment) · fa60778b
      unknown authored
      
      mysql-test/t/sp-code.test:
        Corrected typo in comment.
      fa60778b
    • unknown's avatar
      Merge svlasenko@bk-internal.mysql.com:/home/bk/mysql-5.0 · 36329aa8
      unknown authored
      into  selena.:H:/MYSQL/src/#15634-mysql-5.0
      
      
      sql/field.cc:
        Auto merged
      36329aa8
    • unknown's avatar
      Merge aivanov@bk-internal.mysql.com:/home/bk/mysql-5.0 · d637558f
      unknown authored
      into  mysql.com:/home/alexi/innodb/mysql-5.0-ss17
      
      d637558f
    • unknown's avatar
      Merge mysql.com:/home/alexi/innodb/mysql-4.1-ss17 · 97c6d044
      unknown authored
      into  mysql.com:/home/alexi/innodb/mysql-5.0-ss17
      
      
      innobase/dict/dict0dict.c:
        Null merged
      mysql-test/r/innodb.result:
        Null merged
      mysql-test/t/innodb.test:
        Null merged
      97c6d044
    • unknown's avatar
      Fixed BUG#16387. · a323b6b7
      unknown authored
        Applied innodb-4.1-ss17 snapshot.
        Do not mistake TABLENAME_ibfk_0 for auto-generated id.
      
      
      innobase/dict/dict0dict.c:
        Applied innodb-4.1-ss17 snapshot.
          dict_table_get_highest_foreign_id(): Ignore foreign
          constraint identifiers starting with the pattern
          TABLENAME_ibfk_0 (BUG#16387).
      mysql-test/r/innodb.result:
        Applied innodb-4.1-ss17 snapshot.
          Fixed results for added test case.
      mysql-test/t/innodb.test:
        Applied innodb-4.1-ss17 snapshot.
          Added test case.
      a323b6b7
    • unknown's avatar
      Merge neptunus.(none):/home/msvensson/mysql/bug15719/my50-bug15719 · 5e03878c
      unknown authored
      into  neptunus.(none):/home/msvensson/mysql/mysql-5.0
      
      
      sql-common/client.c:
        Auto merged
      tests/mysql_client_test.c:
        Merge
      5e03878c
    • unknown's avatar
      Merge neptunus.(none):/home/msvensson/mysql/mysql-5.0 · f27d9696
      unknown authored
      into  neptunus.(none):/home/msvensson/mysql/mysqltest_var/my50-mysqltest_var-integration
      
      f27d9696
  3. 29 Jan, 2006 1 commit
    • unknown's avatar
      information_schema_db.result, information_schema.result: · 5c142d36
      unknown authored
        Fix test result.
      table.h, sql_show.cc:
        Put I_S tables in lexical order.
      
      
      sql/sql_show.cc:
        Put I_S tables in lexical order.
      sql/table.h:
        Put I_S tables in lexical order.
      mysql-test/r/information_schema.result:
        Fix test result.
      mysql-test/r/information_schema_db.result:
        Fix test result.
      5c142d36
  4. 28 Jan, 2006 2 commits
    • unknown's avatar
      Fix for bug #16829 "Firing trigger with RETURN crashes the server" · 40033029
      unknown authored
      We should disallow usage of RETURN statement in triggers and emit
      error at parsing time (instead of crashing when trigger is fired).
      
      
      mysql-test/r/trigger.result:
        Added test for bug #16829 "Firing trigger with RETURN crashes the server".
      mysql-test/t/trigger.test:
        Added test for bug #16829 "Firing trigger with RETURN crashes the server".
      sql/sql_yacc.yy:
        We should disallow usage of RETURN statement in triggers and emit
        error at parsing time (instead of crashing when trigger is fired).
      40033029
    • unknown's avatar
      Fixed bug #16260. · ab55c1ea
      unknown authored
      The problem has manifested itself in the cases when we have a nested outer join
      for which it can be inferred that one of the inner tables is a single row table.
      
      
      mysql-test/r/join_nested.result:
        Added a test case for bug #16260.
      mysql-test/t/join_nested.test:
        Added a test case for bug #16260.
      sql/sql_select.cc:
        Fixed bug #16260.
        The problem has manifested itself in the cases when we have a nested outer join
        for which it can be inferred that one of the inner tables is a single row table.
        A table is never considered as a const table if it is used in a nested join 
        that serves as an inner operand of an outer join.
      ab55c1ea
  5. 27 Jan, 2006 4 commits
    • unknown's avatar
      BUG# 14768 · cea30533
      unknown authored
      Added fixes to make last_insert_id() to work.
      
      
      mysql-test/r/federated.result:
        BUG #14768
        
        New test results for last_insert_id()
      mysql-test/t/federated.test:
        BUG #14768
        
        Tests for last_insert_id()
      sql/ha_federated.cc:
        BUG# 14768
        
        * Added code to set last_insert_id()
        * Added code to free share->scheme
      sql/ha_federated.h:
        BUG #14768
        
        New method for setting last_insert_id()
      cea30533
    • unknown's avatar
      Merge neptunus.(none):/home/msvensson/mysql/mysql-5.0 · fcded8ae
      unknown authored
      into  neptunus.(none):/home/msvensson/mysql/mysqltest_var/my50-mysqltest_var-integration
      
      fcded8ae
    • unknown's avatar
      Merge... · b160f184
      unknown authored
      Merge neptunus.(none):/home/msvensson/mysql/mysqltestrun_check_testcases/my50-mysqltestrun_check_testcases
      into  neptunus.(none):/home/msvensson/mysql/mysqltest_var/my50-mysqltest_var-integration
      
      
      mysql-test/mysql-test-run.pl:
        Auto merged
      mysql-test/r/query_cache.result:
        Auto merged
      mysql-test/r/rpl000001.result:
        Auto merged
      mysql-test/r/rpl_loaddata.result:
        Auto merged
      mysql-test/r/rpl_loaddata_rule_m.result:
        Auto merged
      mysql-test/r/rpl_loaddata_rule_s.result:
        Auto merged
      mysql-test/r/rpl_misc_functions.result:
        Auto merged
      mysql-test/r/rpl_replicate_do.result:
        Auto merged
      mysql-test/r/sp-security.result:
        Auto merged
      mysql-test/r/variables.result:
        Auto merged
      mysql-test/r/view_grant.result:
        Auto merged
      mysql-test/t/query_cache.test:
        Auto merged
      mysql-test/t/rpl000001.test:
        Auto merged
      mysql-test/t/rpl_loaddata.test:
        Auto merged
      mysql-test/t/rpl_loaddata_rule_m.test:
        Auto merged
      mysql-test/t/rpl_loaddata_rule_s.test:
        Auto merged
      mysql-test/t/rpl_misc_functions.test:
        Auto merged
      mysql-test/t/rpl_replicate_do.test:
        Auto merged
      mysql-test/t/sp-security.test:
        Auto merged
      mysql-test/t/trigger-compat.test:
        Auto merged
      mysql-test/r/trigger-compat.result:
        Merge
      b160f184
    • unknown's avatar
      Use MYSQLTEST_VARDIR · e5b4e2ed
      unknown authored
      
      mysql-test/t/information_schema.test:
        Use MYSQLTEST_VARDIR instead of MYSQL_TEST_DIR/var
      e5b4e2ed
  6. 26 Jan, 2006 5 commits
    • unknown's avatar
      Add new option "check-testcases" to mysql-test-run.pl · f64c2772
      unknown authored
      Cleanup the sideeffects from most of the  testcases with sideeffects.
      
      
      mysql-test/mysql-test-run.pl:
        Add option "check-testcases" to mysql-test-run.pl
        Will execute "include/check-testcase.test" once before each tescase and record the output into "var/tmp/check-testcase.result"
        After the teastcase it will run again and this time compare the output with previously recorded file.
      mysql-test/r/analyze.result:
        Drop table t1 at end of test
      mysql-test/r/create_select_tmp.result:
        Drop table t1 at end of test
      mysql-test/r/ctype_cp932.result:
        Drop table t1 at end of test
      mysql-test/r/ctype_recoding.result:
        Drop table t1 at end of test
      mysql-test/r/grant2.result:
        Drop user mysqltest_2 and mysqltest_A@'%'
      mysql-test/r/join_outer.result:
        Drop view v1 to cleanup
      mysql-test/r/ps_1general.result:
        Drop table t1 at end of test
      mysql-test/r/query_cache.result:
        Drop function "f1"
      mysql-test/r/read_only.result:
        Reset the "read_only" flag
      mysql-test/r/rpl000001.result:
        Remove user "blafasel2"
      mysql-test/r/rpl000017.result:
        Remove user "replicate"
      mysql-test/r/rpl_failed_optimize.result:
        Drop table t1 to cleanup
      mysql-test/r/rpl_flush_tables.result:
        Drop tables t3, t4, t5
      mysql-test/r/rpl_ignore_revoke.result:
        Delete user "user_foo"
      mysql-test/r/rpl_insert_id.result:
        Drop table t1 to cleanup
      mysql-test/r/rpl_loaddata.result:
        Drop tyable t1 to cleanup
      mysql-test/r/rpl_loaddata_rule_m.result:
        Drop tyable t1 to cleanup
      mysql-test/r/rpl_loaddata_rule_s.result:
        Drop tyable t1 to cleanup
      mysql-test/r/rpl_misc_functions.result:
        Drop tyable t1 to cleanup
      mysql-test/r/rpl_multi_update3.result:
        Drop tyable t1 and t2 to cleanup
      mysql-test/r/rpl_replicate_do.result:
        Drop tyable t1 to cleanup
      mysql-test/r/rpl_skip_error.result:
        Drop tyable t1 to cleanup
      mysql-test/r/rpl_slave_status.result:
        Drop tyable t1 to cleanup
      mysql-test/r/sp-prelocking.result:
        Drop view v1 and tables t1, t2, t3 and t4 to cleanup
      mysql-test/r/sp-security.result:
        Delete users to cleanup
        Delete remaining traces in tables_priv and procs_priv
      mysql-test/r/subselect_innodb.result:
        Drop procedure p1 to cleanup
      mysql-test/r/trigger-compat.result:
        Drop trigger wl2818_trg1 and wl2818_trg2.
        Drop table t1, t2
        Drop database mysqltest_db1
        And the users "mysqltest_dfn@localhost" and "mysqltest_inv@localhost"
      mysql-test/r/type_bit.result:
        Drop tables t1 and t2 to cleanup
      mysql-test/r/variables.result:
        Set GLOBAL max_join_size to 10 as it originally was in variables-master.opt
      mysql-test/r/view_grant.result:
        Dop user "test@localhost" to cleanup
      mysql-test/t/analyze.test:
        Drop table t1 to cleanup
      mysql-test/t/create_select_tmp.test:
        Drop table t1 to cleanup
      mysql-test/t/ctype_cp932.test:
        Drop table t1 to cleanup
      mysql-test/t/ctype_recoding.test:
        Drop table t1 to cleanup
      mysql-test/t/fulltext_var.test:
        Restore the original ft_boolean_syntax
      mysql-test/t/grant2.test:
        Drop users "mysqltest_2" and "mysqltest_A@'%'" to cleanup
      mysql-test/t/innodb_cache.test:
        Reset query_cache_size to original value
      mysql-test/t/join_outer.test:
        Drop view v1 to cleanup
      mysql-test/t/ps_1general.test:
        Drop table t1 to cleanup
      mysql-test/t/query_cache.test:
        Drop function "f1" to cleanup
      mysql-test/t/read_only.test:
        Reset the readonly flag
      mysql-test/t/rpl000001.test:
        Delete user "blafasel2" to cleanup
      mysql-test/t/rpl000017.test:
        Delete user "replicate" to cleanup
      mysql-test/t/rpl_failed_optimize.test:
        Drop table t1 to cleanup
      mysql-test/t/rpl_flush_tables.test:
        Droip table t3, t4 and t5 to cleanup
      mysql-test/t/rpl_ignore_revoke.test:
        Delet user "user_foo" to cleanup
      mysql-test/t/rpl_insert_id.test:
        drop table t1 to cleanup
      mysql-test/t/rpl_loaddata.test:
        Drop table t1 to cleanup
      mysql-test/t/rpl_loaddata_rule_m.test:
        Drop table t1 to cleanup
      mysql-test/t/rpl_loaddata_rule_s.test:
        Drop table t1 to cleanup
      mysql-test/t/rpl_misc_functions.test:
        Drop table t1 to cleanup
      mysql-test/t/rpl_multi_update3.test:
        Drop table t1 and t2 to cleanup
      mysql-test/t/rpl_replicate_do.test:
        Drop table t1 to cleanup
      mysql-test/t/rpl_skip_error.test:
        Drop table t1 to cleanup
      mysql-test/t/rpl_slave_status.test:
        Drop table t1 to cleanup
      mysql-test/t/sp-prelocking.test:
        Drop table t1, t2 t3 and t4 to cleanup
        Drop view v1
      mysql-test/t/sp-security.test:
        Delete  test users from mysql.user, mysql.db, mysql.procs_priv and mysql.tables_priv
        Drop table t1 to cleanup
      mysql-test/t/subselect_innodb.test:
        Drop procedure p1 to cleanup
      mysql-test/t/trigger-compat.test:
        Drop trigger wl2818_trg1 and wl2818_trg2 to cleanup
        Drop table t1, t2
        Drop users
        drop database mysqltest_db1
      mysql-test/t/type_bit.test:
        drop table t1 and t2 to cleanup
      mysql-test/t/variables-master.opt:
        Increase max_join_size to 100.
      mysql-test/t/variables.test:
        Set max_join_size to 10, which was the original value in variables-master.opt
      mysql-test/t/view_grant.test:
        Drop the user "test@localhost"
      mysql-test/include/check-testcase.test:
        New BitKeeper file ``mysql-test/include/check-testcase.test''
      f64c2772
    • unknown's avatar
      Merge neptunus.(none):/home/msvensson/mysql/mysql-5.0 · c56193aa
      unknown authored
      into  neptunus.(none):/home/msvensson/mysql/mysqltest_var/my50-mysqltest_var-integration
      
      
      mysql-test/t/trigger-grant.test:
        Merge
      c56193aa
    • unknown's avatar
      Merge neptunus.(none):/home/msvensson/mysql/mysqltest_var/my50-mysqltest_var · 85dc29d7
      unknown authored
      into  neptunus.(none):/home/msvensson/mysql/mysqltest_var/my50-mysqltest_var-integration
      
      
      mysql-test/t/mysqltest.test:
        Auto merged
      85dc29d7
    • unknown's avatar
      Merge · 32ff59f9
      unknown authored
      32ff59f9
    • unknown's avatar
      Bug #15719 MYSQL_OPT_RECONNECT option is modified by mysql_real_connect · 13db3ba9
      unknown authored
       - Move init of "reconnect" variable to mysql_init 
       - Add test case to mysql_client_test.
      
      
      sql-common/client.c:
        Move initialisation of reconnect variable to mysql_init instead of doing it in mysql_real_connect.
      tests/mysql_client_test.c:
        Add test to check that reconnect is not modified by a call to mysql_real_connect
      13db3ba9
  7. 25 Jan, 2006 5 commits
    • unknown's avatar
      Merge svlasenko@bk-internal.mysql.com:/home/bk/mysql-5.0 · bee074d1
      unknown authored
      into  selena.:H:/MYSQL/src/#11892-mysql-5.0
      
      bee074d1
    • unknown's avatar
      Merge mysql.com:/users/lthalmann/bkroot/mysql-5.0 · b0e49a21
      unknown authored
      into  mysql.com:/users/lthalmann/bk/mysql-5.0-bug16487
      
      b0e49a21
    • unknown's avatar
      BUG#16487: New test for ignored table and multi-update · e6a443b7
      unknown authored
      
      mysql-test/r/rpl_ignore_table.result:
        New result file
      mysql-test/t/rpl_ignore_table-slave.opt:
        New option file
      mysql-test/t/rpl_ignore_table.test:
        New test for ignored table and multi-update
      e6a443b7
    • unknown's avatar
      Fixed BUG#15737: Stored procedure optimizer bug with LEAVE · f89389e3
      unknown authored
        Second version.
        The problem was that the optimizer didn't work correctly with forwards jumps
        to "no-op" hpop and cpop instructions.
        Don't generate "no-op" instructions (hpop 0 and cpop 0), it isn't actually
        necessary.
      
      
      mysql-test/r/sp-code.result:
        Updated results for new test case (BUG#15737)
      mysql-test/t/sp-code.test:
        New test case (BUG#15737)
      sql/sp_head.cc:
        Removed backpatch methods from sp_instr_hpop/cpop, since they're not needed any more.
        Added more documentation to sp_head::optimize()
      sql/sp_head.h:
        Removed backpatch and opt_mark methods from sp_instr_hpop/cpop, since they're not needed
        any more.
        Added comments to optimizer methods in sp_instr.
      sql/sql_yacc.yy:
        Don't generate "no-op" hpop and cpop instructions for LEAVE, it's not necessary.
        Just generate them when needed.
      f89389e3
    • unknown's avatar
      Merge baker@bk-internal.mysql.com:/home/bk/mysql-5.0 · 39e2b087
      unknown authored
      into  zim.tangent.org:/home/brian/mysql/mysql-5.0
      
      39e2b087