1. 23 Nov, 2007 1 commit
    • unknown's avatar
      WL#3949 Test should set binlog format dnamically · 59574a6e
      unknown authored
      - Reorganize collect a little to make it easier to apply optimizations
        and settings to collected test cases.
      - Add suite/rpl/combination file
      - Rename include/set_binlog_format_x.inc to .sql since thay are run by "mysql"
       
      
      
      mysql-test/include/set_binlog_format_mixed.sql:
        Rename: mysql-test/include/set_binlog_format_mixed.inc -> mysql-test/include/set_binlog_format_mixed.sql
      mysql-test/include/set_binlog_format_row.sql:
        Rename: mysql-test/include/set_binlog_format_row.inc -> mysql-test/include/set_binlog_format_row.sql
      mysql-test/include/set_binlog_format_statement.sql:
        Rename: mysql-test/include/set_binlog_format_statement.inc -> mysql-test/include/set_binlog_format_statement.sql
      mysql-test/lib/mtr_cases.pl:
        Reorganize code to
         - collect a suite
         - multiply the tests in the suite with any combinations the suite has
         - optimize the suite by skipping test not supported with current settings
        Use My::Config to read combinations file in my.cnf file format, this
        allowas a "short name" to be used for the combination instead of
        the full name wich is set to the extra arguments the combination applies
        Add function 'print_testcase' that can be used to print the testcases
        during different stages of the collect phase
      mysql-test/lib/mtr_report.pl:
        Print <testname> '<combination>' if combination is set
      mysql-test/mysql-test-run.pl:
        Add comments, fix indentation
        Rename .in to .sql files
        Only set binlog format dynamicall for master, slav is always restarted
      mysql-test/lib/My/Config.pm:
        New BitKeeper file ``mysql-test/lib/My/Config.pm''
      mysql-test/suite/rpl/combinations:
        New BitKeeper file ``mysql-test/suite/rpl/combinations''
      59574a6e
  2. 21 Nov, 2007 5 commits
  3. 20 Nov, 2007 3 commits
    • unknown's avatar
      WL#3949, fix for 2nd part · 2d1f41a1
      unknown authored
      
      mysql-test/mysql-test-run.pl:
        updated mtr
      mysql-test/include/set_binlog_format_mixed.inc:
        set mixed binlog format
      mysql-test/include/set_binlog_format_row.inc:
        set row binlog format
      mysql-test/include/set_binlog_format_statement.inc:
        set statement binlog format
      2d1f41a1
    • unknown's avatar
      BUG#31581: 5.1-telco-6.1 -> 5.1.22. Slave crashes during starting · ccfcd595
      unknown authored
      This patch has two purposes:
      (1) To refactor the code so that
         {Write|Update|Delete}_rows_log_event_old does not use code from
         {Write|Update|Delete}_rows_log_event. Before refactoring there
         was the following problem: whenever we modifed the code for new
         events, it affected the old events. This is bad, as it makes
         maintainance difficult. After refactoring, we can safely edit the
         new code without affecting old events. So, if we for instance
         modify the binary format of new events, we no longer need to worry
         about how the new code reads old events.
      (2) To fix BUG#31581.
      
      These two objectives are reached by the following changes:
       - Merged Rows_log_event into Old_rows_log_event and
         {Write|Update|Delete}_rows_log_event into
         {Write|Update|Delete}_rows_log_event_old.
       - Fixed the bug by replacing {WRITE|UPDATE|DELETE}_ROWS_EVENT by
         PRE_GA_{WRITE|UPDATE|DELETE}_ROWS_EVENT.
       - Added comments to log_event_old.h
      
      (This patch is identical to the previously committed patch which was
      a collapse of three changesets, except that it adds assert(0) to
      constructors for old types of row log events that should never be
      called.)
      
      
      sql/log_event_old.cc:
        Merged Rows_log_event into Old_rows_log_event and
        {Write|Update|Delete}_rows_log_event into
        {Write|Update|Delete}_rows_log_event_old. Also fixed the bug by
        replacing {WRITE|UPDATE|DELETE}_ROWS_EVENT by
        PRE_GA_{WRITE|UPDATE|DELETE}_ROWS_EVENT.
      sql/log_event_old.h:
        Merged Rows_log_event into Old_rows_log_event and
        {Write|Update|Delete}_rows_log_event into
        {Write|Update|Delete}_rows_log_event_old. Also added comment
        explaining what the file contains and what the classes do.
      ccfcd595
    • unknown's avatar
      WL#3949, second part. Added soft switching of the binlog format (w/o restart a server) · bfb18f9a
      unknown authored
      
      mysql-test/lib/mtr_cases.pl:
        updated the code for combination
      mysql-test/mysql-test-run.pl:
        added soft switching of binlog format
      mysql-test/lib/mtr_misc.pl:
        added new sub mtr_diff_opts
      mysql-test/suite/rpl/r/rpl_invoked_features.result:
        updated result
      mysql-test/suite/rpl/t/rpl_invoked_features.test:
        updated test
      mysql-test/suite/rpl/t/rpl_misc_functions.test:
        updated test
      mysql-test/suite/rpl/t/rpl_session_var.test:
        updated test
      bfb18f9a
  4. 14 Nov, 2007 3 commits
    • unknown's avatar
      Post-merge fixes. · 8f798dff
      unknown authored
      
      sql/sql_delete.cc:
        Correcting merge error.
      8f798dff
    • unknown's avatar
      Reverting changes to debug printouts to ha_ndbcluster.cc. · b04cd27c
      unknown authored
      
      sql/ha_ndbcluster.cc:
        Reverting previous changes done to DBUG_ENTER strings.
      b04cd27c
    • unknown's avatar
      Merge dl145h.mysql.com:/data0/mkindahl/mysql-5.1 · 19ef3ae8
      unknown authored
      into  dl145h.mysql.com:/data0/mkindahl/mysql-5.1-new-rpl
      
      
      mysql-test/extra/rpl_tests/rpl_extraMaster_Col.test:
        Auto merged
      mysql-test/mysql-test-run.pl:
        Auto merged
      mysql-test/suite/rpl/include/rpl_mixed_dml.inc:
        Auto merged
      mysql-test/suite/rpl/r/rpl_bug31076.result:
        Auto merged
      mysql-test/suite/rpl/t/rpl_bug31076.test:
        Auto merged
      mysql-test/suite/rpl/t/rpl_innodb_bug28430.test:
        Auto merged
      mysql-test/suite/rpl_ndb/t/disabled.def:
        Auto merged
      sql/field.cc:
        Auto merged
      sql/ha_ndbcluster.cc:
        Auto merged
      sql/handler.cc:
        Auto merged
      sql/log.cc:
        Auto merged
      sql/log_event.cc:
        Auto merged
      sql/log_event_old.cc:
        Auto merged
      sql/mysqld.cc:
        Auto merged
      sql/slave.cc:
        Auto merged
      sql/sp_head.cc:
        Auto merged
      sql/sql_class.cc:
        Auto merged
      sql/sql_class.h:
        Auto merged
      sql/sql_insert.cc:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      sql/sql_table.cc:
        Auto merged
      sql/sql_update.cc:
        Auto merged
      sql/sql_yacc.yy:
        Auto merged
      mysql-test/t/partition.test:
        Manual merge.
      BitKeeper/deleted/.del-rpl_row_extraColmaster_ndb.result~a2c64bae75b49d2:
        Manual merge.
      mysql-test/suite/rpl/r/rpl_extraColmaster_innodb.result:
        Manual merge.
      mysql-test/suite/rpl/r/rpl_extraColmaster_myisam.result:
        Manual merge.
      mysql-test/suite/rpl/t/disabled.def:
        Manual merge.
      sql/sql_delete.cc:
        Manual merge.
      19ef3ae8
  5. 12 Nov, 2007 2 commits
    • unknown's avatar
      Merge aelkin@bk-internal.mysql.com:/home/bk/mysql-5.1-rpl · 296931c1
      unknown authored
      into  koti.dsl.inet.fi:/home/elkin/MySQL/TEAM/FIXES/5.1/bug31170-rpl_innodb_bug28430_fails
      
      
      mysql-test/suite/rpl/r/rpl_innodb_bug28430.result:
        Auto merged
      mysql-test/suite/rpl/t/rpl_innodb_bug28430.test:
        manual merge
      296931c1
    • unknown's avatar
      BUG#31611 (Security risk with BINLOG statement): · c4f94b70
      unknown authored
      Adding missing drop of user created for test case.
      
      
      mysql-test/r/mysqlbinlog.result:
        Result file change.
      mysql-test/t/mysqlbinlog.test:
        Dropping user that was added earlier in the test.
      c4f94b70
  6. 09 Nov, 2007 3 commits
    • unknown's avatar
      BUG#31552 (Replication breaks when deleting rows from out-of-sync table without PK): · e7c56ceb
      unknown authored
      Pushing test case for bug only. Bug already fixed as a result of the patch for BUG#19958.
      
      
      mysql-test/extra/rpl_tests/rpl_row_basic.test:
        Adding test to see that no error is given on slave when deleting
        rows that don't exist on table without primary key.
      mysql-test/suite/rpl/r/rpl_row_basic_2myisam.result:
        Result change.
      mysql-test/suite/rpl/r/rpl_row_basic_3innodb.result:
        Result change.
      mysql-test/suite/rpl_ndb/r/rpl_row_basic_7ndb.result:
        Result change.
      e7c56ceb
    • unknown's avatar
      Fixing some tests to make the replication team tree green. · 1aa12b22
      unknown authored
      
      mysql-test/suite/rpl/r/rpl_found_rows.result:
        Result change.
      mysql-test/suite/rpl/t/rpl_found_rows.test:
        Adding ORDER BY to avoid order dependencies.
        Setting BINLOG_FORMAT=MIXED; for all master clients: one were missing.
        Dropping procedures that polluted later test results.
      1aa12b22
    • unknown's avatar
      Bug #31170 rpl_innodb_bug28430 fails: varying timing, ports, and log use · dc34f928
      unknown authored
      Non-deterministic parameters  of  SHOW SLAVE STATUS are masked out
      by means of using the standard include-macro.
      
      The masked-out parameters are not needed by the logics of the original
      tests. What is need to demonstre that replication is not stopped remains.
      
      
      
      mysql-test/suite/rpl/r/rpl_innodb_bug28430.result:
        results changed
      mysql-test/suite/rpl/t/rpl_innodb_bug28430.test:
        using the standard macro that takes care of masking out env specific values
      dc34f928
  7. 08 Nov, 2007 3 commits
  8. 07 Nov, 2007 4 commits
  9. 06 Nov, 2007 16 commits
    • unknown's avatar
      Merge koti.dsl.inet.fi:/home/elkin/MySQL/TEAM/FIXES/5.0/bug27571_asyn_killed_flags · cb9af6f8
      unknown authored
      into  koti.dsl.inet.fi:/home/elkin/MySQL/merge-5.1
      
      
      mysql-test/suite/binlog/r/binlog_killed.result:
        Auto merged
      mysql-test/suite/binlog/t/binlog_killed.test:
        Auto merged
      mysql-test/suite/rpl/t/rpl_dual_pos_advance.test:
        Auto merged
      mysql-test/suite/rpl/t/rpl_temporary.test:
        manual merge
      sql/log.cc:
        manual merge
      cb9af6f8
    • unknown's avatar
      Merge aelkin@bk-internal.mysql.com:/home/bk/mysql-5.0-rpl · 6957e84e
      unknown authored
      into  koti.dsl.inet.fi:/home/elkin/MySQL/TEAM/FIXES/5.0/bug27571_asyn_killed_flags
      
      
      6957e84e
    • unknown's avatar
      bug#27571 · 0c1a085c
      unknown authored
      refining non-deterministic tests.
      The new Bug@32148 is in the way. Adjuting the tests to be somehow useful.
       
      
      
      mysql-test/r/binlog_killed.result:
        results changed
      mysql-test/t/binlog_killed.test:
        refining the tests as killing is inherently non-deterministic;
        leaving todos.
      0c1a085c
    • unknown's avatar
      Merge malff@bk-internal.mysql.com:/home/bk/mysql-5.1-runtime · af48b26e
      unknown authored
      into  lambda.hsd1.co.comcast.net.:/home/malff/TREE/mysql-5.1-runtime
      
      
      af48b26e
    • unknown's avatar
      bug#27571 · febb4201
      unknown authored
      tests fixing: refreshing the results file.
      
      
      mysql-test/suite/binlog/r/binlog_killed.result:
        results changed
      febb4201
    • unknown's avatar
      BUG#12092 (FOUND_ROWS() not replicated): · 657dca93
      unknown authored
      In BUG#30244 added FOUND_ROWS() as an unsafe function, but that
      works only in mixed mode under 5.1. There is a workaround that
      can be used in statement-based mode either under 5.0 or 5.1
      where the result of FOUND_ROWS() is stored into a user vari-
      able and used that way instead. This will replicate correctly
      even under statement-based replication, since it will write
      a User_var entry to the binary log. For some other cases, the
      value has to be passed explicitly.
      
      This patch adds tests to demonstrate that the workarounds docu-
      mented for statement-based replication works as advertised, and
      does more extensive tests for cases that does not work under sta-
      tement-based replication actually work under mixed mode by switch-
      ing to row-based replication.
      
      
      mysql-test/include/reset_master_and_slave.inc:
        New BitKeeper file ``mysql-test/include/reset_master_and_slave.inc''
      mysql-test/suite/rpl/r/rpl_found_rows.result:
        New BitKeeper file ``mysql-test/suite/rpl/r/rpl_found_rows.result''
      mysql-test/suite/rpl/t/rpl_found_rows.test:
        New BitKeeper file ``mysql-test/suite/rpl/t/rpl_found_rows.test''
      657dca93
    • unknown's avatar
      Merge aelkin@bk-internal.mysql.com:/home/bk/mysql-5.0-rpl · 0216fb0d
      unknown authored
      into  koti.dsl.inet.fi:/home/elkin/MySQL/TEAM/FIXES/5.0/bug28597-log_name_upgrade
      
      
      0216fb0d
    • unknown's avatar
      results from 5.0 is not needed · 8d4fdc5c
      unknown authored
      
      BitKeeper/deleted/.del-binlog_killed_simulate.result:
        Delete: mysql-test/r/binlog_killed_simulate.result
      8d4fdc5c
    • unknown's avatar
      Merge koti.dsl.inet.fi:/home/elkin/MySQL/TEAM/BARE/5.0 · 74174d6f
      unknown authored
      into  koti.dsl.inet.fi:/home/elkin/MySQL/merge-5.1
      
      
      BitKeeper/deleted/.del-binlog_killed_bug27571-master.opt:
        Auto merged
      BitKeeper/deleted/.del-binlog_killed_bug27571.test:
        Auto merged
      74174d6f
    • unknown's avatar
      bug#27571 · d8c4501b
      unknown authored
      fixing tests
      
      
      mysql-test/r/binlog_killed_simulate.result:
        the new tests' result
      d8c4501b
    • unknown's avatar
      Merge gkodinov@bk-internal.mysql.com:/home/bk/mysql-5.1-runtime · c33d42eb
      unknown authored
      into  magare.gmz:/home/kgeorge/mysql/autopush/B31974-5.1-runtime
      
      
      c33d42eb
    • unknown's avatar
      Bug #31974: additional commit (test case updates) · 17698ca0
      unknown authored
       loose index scan enabled for subqueries
      
      
      mysql-test/r/group_min_max.result:
        Bug #31974: test case updates
         loose index scan enabled for subqueries
      mysql-test/r/index_merge_myisam.result:
        Bug #31974: test case updates
         loose index scan enabled for subqueries
      17698ca0
    • unknown's avatar
      bug#27571 · 86e07400
      unknown authored
      removing extra tests (on 5.1 that's been already done)
      
      
      BitKeeper/deleted/.del-binlog_killed_bug27571-master.opt:
        Delete: mysql-test/t/binlog_killed_bug27571-master.opt
      BitKeeper/deleted/.del-binlog_killed_bug27571.test:
        Delete: mysql-test/t/binlog_killed_bug27571.test
      86e07400
    • unknown's avatar
      Merge koti.dsl.inet.fi:/home/elkin/MySQL/TEAM/BARE/5.0 · 80533592
      unknown authored
      into  koti.dsl.inet.fi:/home/elkin/MySQL/merge-5.1
      
      
      mysql-test/suite/binlog/r/binlog_killed.result:
        manual merge ul
      mysql-test/suite/binlog/t/binlog_killed.test:
        manual merge with 5.0 specific tests; use local
      mysql-test/suite/binlog/t/binlog_killed_simulate.test:
         manual merge with 5.0 specific tests; use local
      mysql-test/t/ctype_ucs.test:
        Auto merged
      mysql-test/t/func_regexp.test:
        Auto merged
      mysql-test/r/ctype_ucs.result:
        automerge
      mysql-test/r/ctype_utf8.result:
        automerge
      mysql-test/r/func_regexp.result:
        automerge
      mysql-test/t/ctype_utf8.test:
        automerge
      sql/item_cmpfunc.cc:
        automerge
      sql/item_cmpfunc.h:
        automerge
      sql/sql_class.h:
        automerge
      sql/sql_insert.cc:
        automerge
      sql/sql_parse.cc:
        automerge
      sql/sql_update.cc:
        automerge
      80533592
    • unknown's avatar
      bug#27571 · 3cc49bbe
      unknown authored
      commit is specific for 5.0 to eliminated non-deterministic tests.
      Those tests run only in 5.1 env where there is a necessary devices such
      as processlist table of info_schema.
      
      
      mysql-test/r/binlog_killed.result:
        results changed
      mysql-test/t/binlog_killed.test:
        removing non-deterministic part of the test
      mysql-test/t/binlog_killed_simulate.test:
        adding the guard same as for 5.1 version
      3cc49bbe
    • unknown's avatar
      Merge aelkin@bk-internal.mysql.com:/home/bk/mysql-5.0-rpl · b4db3f3f
      unknown authored
      into  koti.dsl.inet.fi:/home/elkin/MySQL/TEAM/FIXES/5.0/bug27571_asyn_killed_flags
      
      
      sql/sql_insert.cc:
        Auto merged
      sql/sql_update.cc:
        Auto merged
      b4db3f3f