1. 19 Nov, 2005 4 commits
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 32e6e6aa
      unknown authored
      into  mysql.com:/home/dlenev/src/mysql-5.0-bg13825
      
      
      32e6e6aa
    • unknown's avatar
      A fix for Bug#14845 "mysql_stmt_fetch returns MYSQL_NO_DATA when · 4ca413e9
      unknown authored
      COUNT(*) is 0" (the test case has been pushed already)
      
      
      sql/sql_cursor.cc:
        Fix a return of an unitialized variable: return_zero_rows
        checks the return value of send_fields and in case it's 1
        doesn't call send_data. This caused creation of an empty result 
        set for the case when there is a cursor against a select with a 
        group function and no matching rows.
      4ca413e9
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · e2de3a8f
      unknown authored
      into  mysql.com:/home/dlenev/src/mysql-5.0-bg13825
      
      
      sql/ha_innodb.cc:
        Auto merged
      sql/handler.cc:
        Auto merged
      sql/sql_class.cc:
        Auto merged
      sql/sql_class.h:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      e2de3a8f
    • unknown's avatar
      Fix for bug #13825 "Triggers: crash if release savepoint" and for general · 11d4d7e6
      unknown authored
      handling of savepoints in stored routines.
      
      Fixed ha_rollback_to_savepoint()/ha_savepoint()/ha_release_savepoint()
      functions to properly handle savepoints inside of stored functions and
      triggers.
      Also now when we invoke stored function or trigger we create new savepoint
      level. We destroy it at the end of function/trigger execution and return back
      to old savepoint level.
      
      
      mysql-test/r/sp_trans.result:
        Added test for bug #13825 "Triggers: crash if release savepoint" and for
        general handling of savepoints in stored routines.
      mysql-test/t/sp_trans.test:
        Added test for bug #13825 "Triggers: crash if release savepoint" and for
        general handling of savepoints in stored routines.
      sql/ha_innodb.cc:
        innobase_savepoint():
          Replaced check which always failed due to similar check in caller
          with assertion.
      sql/handler.cc:
        ha_rollback_to_savepoint()/ha_savepoint()/ha_release_savepoint():
          Changed functions to properly support handling of savepoints
          inside of stored functions and triggers.
      sql/sql_class.cc:
        THD::reset_sub_statement_state()/restore_sub_statement_state():
          When we invoke stored function or trigger we should create new savepoint
          level. We should destroy it at the end of function/trigger execution and
          return back to old savepoint level. To support this behavior we should
          save and reset list of current savepoints on entering function and restore
          old list when we leave it.
      sql/sql_class.h:
        Sub_statement_state:
          When we invoke stored function or trigger we should create new savepoint
          level. We should destroy it at the end of function/trigger execution and
          return back to old savepoint level. To support this behavior added "savepoint"
          member which is used to save/restore list of current savepoints on
          entering/leaving function.
      sql/sql_parse.cc:
        mysql_execute_command():
          Changed processing of SQLCOM_SAVEPOINT so now it is not ignored when
          we are in autocommit mode and savepoint is set inside of stored
          function or trigger.
      11d4d7e6
  2. 18 Nov, 2005 8 commits
  3. 17 Nov, 2005 15 commits
    • unknown's avatar
      Manually merged · d29438f2
      unknown authored
      
      sql/sql_view.cc:
        Auto merged
      d29438f2
    • unknown's avatar
      Merge mysql.com:/home/jimw/my/mysql-4.1-clean · 016fe413
      unknown authored
      into  mysql.com:/home/jimw/my/mysql-5.0-clean
      
      
      client/mysql.cc:
        Auto merged
      configure.in:
        Auto merged
      mysql-test/t/mix_innodb_myisam_binlog.test:
        Auto merged
      mysql-test/r/mix_innodb_myisam_binlog.result:
        Resolve conflict
      sql/item_func.cc:
        Resolve conflict
      sql/sql_show.cc:
        Resolve conflicts
      016fe413
    • unknown's avatar
      Merge mysql.com:/home/jimw/my/mysql-4.1-14801 · 421dadf7
      unknown authored
      into  mysql.com:/home/jimw/my/mysql-4.1-clean
      
      
      421dadf7
    • unknown's avatar
      Merge mysql.com:/home/jimw/my/mysql-4.1-12640 · 58196d39
      unknown authored
      into  mysql.com:/home/jimw/my/mysql-4.1-clean
      
      
      configure.in:
        Auto merged
      58196d39
    • unknown's avatar
      Merge mysql.com:/home/jimw/my/mysql-4.1-11796 · ab816dca
      unknown authored
      into  mysql.com:/home/jimw/my/mysql-4.1-clean
      
      
      ab816dca
    • unknown's avatar
      Post-review fixes (Bug#13524). · 57ad6b20
      unknown authored
      
      sql/sql_prepare.cc:
        Post-review fixes (Bug#13524): make sure 
        mysql_reset_thd_for_next_command is called first for
        all PS commands.
      57ad6b20
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 5afe878c
      unknown authored
      into  mysql.com:/opt/local/work/mysql-5.0-13524
      
      
      5afe878c
    • unknown's avatar
      set_var.cc, mysqld.cc, ha_innodb.h: · 30df60fa
      unknown authored
        BUG#12701: SHOW VARIABLES does not show correct size of buffer pool.
      ha_innodb.cc:
        BUG#12701: SHOW VARIABLES does not show correct size of buffer pool
      
      
      sql/ha_innodb.cc:
        BUG#12701: SHOW VARIABLES does not show correct size of buffer pool
      sql/ha_innodb.h:
        BUG#12701: SHOW VARIABLES does not show correct size of buffer pool.
      sql/mysqld.cc:
        BUG#12701: SHOW VARIABLES does not show correct size of buffer pool.
      sql/set_var.cc:
        BUG#12701: SHOW VARIABLES does not show correct size of buffer pool.
      30df60fa
    • unknown's avatar
      A fix and a test case for Bug#13524 "lock timeout gives · 5b8a9654
      unknown authored
      incorrect warning on open cursor"
      
      
      sql/sql_prepare.cc:
        A fix for Bug#13524 "lock timeout gives incorrect 
        warning on open cursor": reset the connection for next
        command before performing a cursor fetch (add an omitted line).
      tests/mysql_client_test.c:
        A test case for Bug#13524 "lock timeout gives incorrect 
        warning on open cursor"
      5b8a9654
    • unknown's avatar
      Merge istruewing@bk-internal.mysql.com:/home/bk/mysql-4.1 · 3fd5759a
      unknown authored
      into production.mysql.com:/usersnfs/istruewing/autopush/mysql-4.1
      
      
      3fd5759a
    • unknown's avatar
      Merge spachev@bk-internal.mysql.com:/home/bk/mysql-4.1 · d88df3a3
      unknown authored
      into  asksasha.com:/reiser-data/mysql-dev/mysql-4.1-bug7947
      
      
      d88df3a3
    • unknown's avatar
      4d93df79
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 47044ea6
      unknown authored
      into  mysql.com:/home/dlenev/src/mysql-5.0-bg13399-2
      
      
      47044ea6
    • unknown's avatar
      Fix for bug #13399 Crash when executing PS/SP which should activate trigger · d518f702
      unknown authored
      which is now dropped" and bug #12329 "Bogus error msg when executing PS with
      stored procedure after SP was re-created".
      
      
      mysql-test/r/sp-error.result:
        Added test for bug #12329 "Bogus error msg when executing PS with stored
        procedure after SP was re-created".
      mysql-test/r/trigger.result:
        Added test for bug #13399 Crash when executing PS/SP which should activate
        trigger which is now dropped".
      mysql-test/t/sp-error.test:
        Added test for bug #12329 "Bogus error msg when executing PS with stored
        procedure after SP was re-created".
      mysql-test/t/trigger.test:
        Added test for bug #13399 Crash when executing PS/SP which should activate
        trigger which is now dropped".
      sql/sp_head.cc:
        sp_head::add_used_tables_to_table_list():
          We have to copy database/table names and alias to PS/SP memory since current
          instance of sp_head object can pass away before next execution of PS/SP for
          which tables are added to prelocking list.
          This will be fixed by introducing of proper invalidation mechanism once new
          TDC is ready.
      d518f702
    • unknown's avatar
      A fix and a test case for Bug#14077 "Failure to replicate a stored · b6707610
      unknown authored
      function with a cursor". Enable execution of SELECT queries in SP on slave.
      
      
      mysql-test/r/rpl_sp.result:
        Test results were fixed (Bug#14077).
      mysql-test/t/rpl_sp.test:
        Add a test case for Bug#14077 "Failure to replicate a stored 
        function with a cursor".
      sql/sql_parse.cc:
        Do not rewrite SELECTs with DOs on slave: if this SELECT was for a stored
        routine cursor, slave must be able to execute the SELECT in order to
        open a cursor.
        At the moment the bug is present only in stored functions and stored
        procedures called from stored functions, because, due to
        stored procedure unfolding for replication, top level stored procedures
        are never executed on slave.
      b6707610
  4. 16 Nov, 2005 13 commits
    • unknown's avatar
      Merge pnousiainen@bk-internal.mysql.com:/home/bk/mysql-5.0 · 4d899772
      unknown authored
      into  mysql.com:/export/space/pekka/ndb/version/my50
      
      
      4d899772
    • unknown's avatar
      Merge mysql.com:/home/mydev/mysql-4.1 · 771478f2
      unknown authored
      into  mysql.com:/home/mydev/mysql-4.1-4100
      
      
      771478f2
    • unknown's avatar
      Merge istruewing@bk-internal.mysql.com:/home/bk/mysql-5.0 · 48e91809
      unknown authored
      into production.mysql.com:/usersnfs/istruewing/autopush/mysql-5.0
      
      
      48e91809
    • unknown's avatar
      Merge istruewing@bk-internal.mysql.com:/home/bk/mysql-5.0 · 5951caea
      unknown authored
      into production.mysql.com:/usersnfs/istruewing/autopush/mysql-5.0
      
      
      5951caea
    • unknown's avatar
      Bug#14616 - Freshly imported table returns error 124 when using LIMIT · cd1abd99
      unknown authored
      After merge fix.
      
      
      cd1abd99
    • unknown's avatar
      bug#14433 - archive uses wrong ref_length · dcf5d348
      unknown authored
      
      mysql-test/t/func_group.test:
        re-enable the test
      dcf5d348
    • unknown's avatar
      Merge pnousiainen@bk-internal.mysql.com:/home/bk/mysql-5.0 · a2f4bd83
      unknown authored
      into  mysql.com:/export/space/pekka/ndb/version/my50
      
      
      a2f4bd83
    • unknown's avatar
      Merge pnousiainen@bk-internal.mysql.com:/home/bk/mysql-4.1 · 2432bc8f
      unknown authored
      into  mysql.com:/export/space/pekka/ndb/version/my41-r1.2456.1.1
      
      
      2432bc8f
    • unknown's avatar
      ndb - bug#14007 5.0 *** does not automerge into 5.1 *** · 74dcfd25
      unknown authored
      
      mysql-test/r/ndb_charset.result:
        bug#14007 5.0
      mysql-test/t/ndb_charset.test:
        bug#14007 5.0
      ndb/src/kernel/blocks/dbtup/DbtupRoutines.cpp:
        bug#14007 5.0
      ndb/src/kernel/vm/SimulatedBlock.cpp:
        bug#14007 5.0
      ndb/src/kernel/vm/SimulatedBlock.hpp:
        bug#14007 5.0
      74dcfd25
    • unknown's avatar
      Issuing error about presence of commit/rollback statements in stored functions... · 8a661e77
      unknown authored
      Issuing error about presence of commit/rollback statements in stored functions and triggers added to SP parsing procedure (BUG#13627)
      
      The crash mentioned in original bug report is already prevented by one
      of previous patches (fix for bug #13343 "CREATE|etc TRIGGER|VIEW|USER
      don't commit the transaction (inconsistency)"), this patch only improve
      error returning.
      
      
      mysql-test/r/sp-error.result:
        Test that statements which implicitly commit transaction
      mysql-test/t/sp-error.test:
        Test that statements which implicitly commit transaction
      sql/sp_head.cc:
        We set the new flag about commit/rollback statements presence
      sql/sp_head.h:
        The new flag about commit/rollback presence added
        A comment fixed
      sql/sql_yacc.yy:
        Removed commit/rollback-statement-present errors spread by this file, only one check left which check flags of a SP
      8a661e77
    • unknown's avatar
      DbtupRoutines.cpp: · 821cd17c
      unknown authored
        Auto merged
      
      
      ndb/src/kernel/blocks/dbtup/DbtupRoutines.cpp:
        Auto merged
      821cd17c
    • unknown's avatar
      ndb - bug#14007 4.1 [re-commit for LenZ merge] · 563e5c8d
      unknown authored
      
      mysql-test/r/ndb_charset.result:
        bug#14007 test [re-commit]
      mysql-test/t/ndb_charset.test:
        bug#14007 test [re-commit]
      ndb/include/kernel/AttributeDescriptor.hpp:
        bug#14007 4.1 need getSizeInBytes [re-commit]
      ndb/src/kernel/blocks/dbtup/DbtupRoutines.cpp:
        bug#14007 4.1 *** do not AUTOmerge to 5.0 *** [re-commit]
      563e5c8d
    • unknown's avatar
      Merge mysql.com:/home/mydev/mysql-4.1-4100 · 6506fb32
      unknown authored
      into  mysql.com:/home/mydev/mysql-5.0-5000
      
      
      mysql-test/r/handler.result:
        Auto merged
      mysql-test/r/myisam.result:
        Auto merged
      mysql-test/t/handler.test:
        Auto merged
      mysql-test/t/myisam.test:
        Auto merged
      sql/sql_class.cc:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      sql/mysql_priv.h:
        Bug#14397 - OPTIMIZE TABLE with an open HANDLER causes a crash
        Manual merge.
      sql/sql_base.cc:
        Bug#14397 - OPTIMIZE TABLE with an open HANDLER causes a crash
        Manual merge.
      sql/sql_handler.cc:
        Bug#14397 - OPTIMIZE TABLE with an open HANDLER causes a crash
        Manual merge.
      sql/sql_table.cc:
        Bug#14397 - OPTIMIZE TABLE with an open HANDLER causes a crash
        Manual merge.
      6506fb32