1. 06 Sep, 2005 2 commits
    • unknown's avatar
      InnoDB: Reject foreign keys in temporary tables. Closes bug #12084. · 01c8f66b
      unknown authored
      
      innobase/dict/dict0dict.c:
        Add reject_fks parameter to dict_create_foreign_constraints_low and
        dict_create_foreign_constraints.
      innobase/include/dict0dict.h:
        Add reject_fks parameter to dict_create_foreign_constraints.
      innobase/include/row0mysql.h:
        Add reject_fks parameter to row_table_add_foreign_constraints.
      innobase/row/row0mysql.c:
        Add reject_fks parameter to row_table_add_foreign_constraints.
      sql/ha_innodb.cc:
        In create, pass correct reject_fks argument to
        row_table_add_foreign_constraints depending on whether we're creating a
        temporary table or not. Also move duplicated cleanup code to a single
        place.
      01c8f66b
    • unknown's avatar
      Merge · 62981cc8
      unknown authored
      
      mysql-test/r/func_gconcat.result:
        Auto merged
      mysql-test/t/func_gconcat.test:
        Auto merged
      ndb/src/kernel/blocks/ndbcntr/NdbcntrMain.cpp:
        Auto merged
      ndb/src/kernel/error/ErrorReporter.cpp:
        Auto merged
      ndb/src/kernel/main.cpp:
        Auto merged
      ndb/src/kernel/vm/Emulator.cpp:
        Auto merged
      ndb/src/kernel/vm/Emulator.hpp:
        Auto merged
      ndb/src/mgmsrv/ConfigInfo.cpp:
        Auto merged
      ndb/src/mgmsrv/MgmtSrvr.cpp:
        Auto merged
      ndb/src/mgmsrv/Services.cpp:
        Auto merged
      ndb/tools/ndb_config.cpp:
        Auto merged
      ndb/tools/restore/consumer_restore.cpp:
        Auto merged
      ndb/include/util/ndb_opts.h:
        merge
      ndb/tools/Makefile.am:
        merge
      ndb/tools/restore/restore_main.cpp:
        merge
      62981cc8
  2. 05 Sep, 2005 12 commits
  3. 04 Sep, 2005 4 commits
    • unknown's avatar
      row0mysql.c, ha_innodb.cc: · 8fc02b3b
      unknown authored
        Fix bug #12308 : do not roll back the whhole transaction in a lock wait timeout error, just roll back the latest SQL statement; note that the locks set in the latest SQL statements remain, as InnoDB does not know what locks were set in which SQL statement
      
      
      sql/ha_innodb.cc:
        Fix bug #12308 : do not roll back the whhole transaction in a lock wait timeout error, just roll back the latest SQL statement; note that the locks set in the latest SQL statements remain, as InnoDB does not know what locks were set in which SQL statement
      innobase/row/row0mysql.c:
        Fix bug #12308 : do not roll back the whhole transaction in a lock wait timeout error, just roll back the latest SQL statement; note that the locks set in the latest SQL statements remain, as InnoDB does not know what locks were set in which SQL statement
      8fc02b3b
    • unknown's avatar
      This patch disables the query cache for the federated engine. · 238b8cd5
      unknown authored
      
      sql/ha_federated.h:
        Fix cache issues
      238b8cd5
    • unknown's avatar
      ha_innodb.cc: · e9c098e3
      unknown authored
        Better comments about auto-inc and SHOW TABLE STATUS
      
      
      sql/ha_innodb.cc:
        Better comments about auto-inc and SHOW TABLE STATUS
      e9c098e3
    • unknown's avatar
      ha_innodb.cc: · 1e787a37
      unknown authored
        Fix bug #12973 : set the table handle field auto_increment_value if ::info() is called with the flag HA_STATUS_AUTO
      
      
      sql/ha_innodb.cc:
        Fix bug #12973 : set the table handle field auto_increment_value if ::info() is called with the flag HA_STATUS_AUTO
      1e787a37
  4. 03 Sep, 2005 7 commits
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.0 · e38fe316
      unknown authored
      into  mysql.com:/home/jimw/my/mysql-5.0-clean
      
      e38fe316
    • unknown's avatar
      Merge mysql.com:/home/jimw/my/mysql-5.0-11787 · 777e8b3d
      unknown authored
      into  mysql.com:/home/jimw/my/mysql-5.0-clean
      
      
      include/mysql.h:
        Auto merged
      sql-common/client.c:
        Auto merged
      client/mysqltest.c:
        Resolve conflict
      777e8b3d
    • unknown's avatar
      univ.i, page0page.ic: · acbf048c
      unknown authored
        Add a sanity check to page_rec_is_comp; a new univ.i macro UNIV_RELEASE_NOT_YET_STABLE controls such sanity checks that we will remove after the release is stable enough
      
      
      innobase/include/page0page.ic:
        Add a sanity check to page_rec_is_comp; a new univ.i macro UNIV_RELEASE_NOT_YET_STABLE controls such sanity checks that we will remove after the release is stable enough
      innobase/include/univ.i:
        Add a sanity check to page_rec_is_comp; a new univ.i macro UNIV_RELEASE_NOT_YET_STABLE controls such sanity checks that we will remove after the release is stable enough
      acbf048c
    • unknown's avatar
      row0sel.c: · 1bef1b3f
      unknown authored
        Fix a wrong debug assert in the previous patch
      
      
      innobase/row/row0sel.c:
        Fix a wrong debug assert in the previous patch
      1bef1b3f
    • unknown's avatar
      row0sel.c: · 582182f8
      unknown authored
        Add more comments to row_search_for_mysql() and remove the ugly double use of the variable rec in that function
      
      
      innobase/row/row0sel.c:
        Add more comments to row_search_for_mysql() and remove the ugly double use of the variable rec in that function
      582182f8
    • unknown's avatar
      Merge heikki@bk-internal.mysql.com:/home/bk/mysql-5.0 · 652ff87e
      unknown authored
      into  hundin.mysql.fi:/home/heikki/mysql-5.0
      
      652ff87e
    • unknown's avatar
      Merge joreland@bk-internal.mysql.com:/home/bk/mysql-4.1 · be77cdbe
      unknown authored
      into  eel.(none):/home/jonas/src/mysql-4.1-push
      
      be77cdbe
  5. 02 Sep, 2005 15 commits
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 1dfe47fa
      unknown authored
      into  mysql.com:/home/kostja/mysql/mysql-5.0-dsql3
      
      
      sql/mysql_priv.h:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      sql/share/errmsg.txt:
        manual merge
      1dfe47fa
    • unknown's avatar
      Implement WL#2661 "Prepared Statements: Dynamic SQL in Stored Procedures". · 9fbcfd67
      unknown authored
      The idea of the patch is to separate statement processing logic,
      such as parsing, validation of the parsed tree, execution and cleanup, 
      from global query processing logic, such as logging, resetting
      priorities of a thread, resetting stored procedure cache, resetting
      thread count of errors and warnings.
      This makes PREPARE and EXECUTE behave similarly to the rest of SQL
      statements and allows their use in stored procedures.
      This patch contains a change in behaviour:
      until recently for each SQL prepared statement command, 2 queries
      were written to the general log, e.g.
      [Query]   prepare stmt from @stmt_text;
      [Prepare] select * from t1 <-- contents of @stmt_text
      The chagne was necessary to prevent [Prepare] commands from being written
      to the general log when executing a stored procedure with Dynamic SQL.
      We should consider whether the old behavior is preferrable and probably
      restore it.
      This patch refixes Bug#7115, Bug#10975 (partially), Bug#10605 (various bugs
      in Dynamic SQL reported before it was disabled).
      
      
      mysql-test/r/not_embedded_server.result:
        Since we don't want to log Dynamic SQL in stored procedures,
        now the general log gets only one log entry per SQL statement.
      mysql-test/r/sp-error.result:
        - remove obsolete tests
        - a better error message for the case when a stored procedure that
        returns a result set is called from a function
      mysql-test/r/trigger.result:
        - a better error message for the case when a stored procedure that
        returns a result set is called from a trigger
      mysql-test/t/sp-error.test:
        - a better error message for the case when a stored procedure that
          returns a result set is called from a function.
        - move the comment to its place (end of file).
      mysql-test/t/trigger.test:
        - a better error message for the case when a stored procedure that
        returns a result set is called from a trigger
      sql/item_func.cc:
        - we need to pass sql_command explicitly to get_var_with_binlog, because
        when creating a query for SQL prepared statement thd->lex->sql_command
        points at SQLCOM_EXECUTE, which is not listed in the list of update
        queries.
      sql/log_event.h:
        - remove an extra copy of the previous sentence
      sql/mysql_priv.h:
        - fix declarations of sql_prepare.cc API
      sql/share/errmsg.txt:
        - a new error message, when one attempts to execute a prepared statement
        which is currently being executed (this can happen only in Dynamic SQL
        at the moment).
      sql/sp_head.cc:
        - extend sp_multi_results_command to return different flags for a
        command (and rename it)
        - add support for SQLCOM_PREPARE,SQLCOM_EXECUTE, SQLCOM_DEALLOCATE
          to sp_get_flags_for_command
        - replace multiple boolean sp_head members with uint m_flags
        - a fix for a crash when user variables are used in a stored procedure
          and binlog is on. A temporary fix for Bug#12637 "SP crashes the server 
         if it has update query with user var & binlog is enabled", which actually
         stands for stored functions: now instead of a crash we break
         replication if a user variable is used in a stored function which 
         is executed in prelocked mode.
      sql/sp_head.h:
        - replace multiple boolean flags of sp_head with uint m_flags;
        - add flag CONTAINS_DYNAMIC_SQL
        - use this flag to error if a stored procedure with Dynamic SQL is
          called from a function or trigger.
      sql/sql_class.cc:
        - Statement_map::insert should not delete a statement if it exists,
          now it's done externally to be able to handle the case when the
          statement being deleted is in use.
        - remove extra code (free_list is already reset in free_items)
      sql/sql_lex.cc:
        - add lex->stmt_prepare_mode; we can't rely on thd->command any more,
          because we don't reset it any more (Dynamic SQL requirement is that
          PS are as little intrusive as possible).
      sql/sql_lex.h:
        - declare bool LEX::stmt_prepare_mode
      sql/sql_parse.cc:
        - move prepared statement code to sql_prepare.cc
        - change declarations (refactored code)
        - better error message when one attempts to use Dynamic SQL or a 
          stored procedure that returns a result set in a function or trigger.
      sql/sql_prepare.cc:
        - major refactoring to ensure PREPARE/EXECUTE commands do not reset global THD
          state and allow their use in stored procedures.
        - add Prepared_statement::flags and use it to ensure no recursive execution
          of a prepared statement is possible
        - better comments
      sql/sql_yacc.yy:
        - enable PREPARE/EXECUTE/DEALLOCATE in stored procedures
        - produce an error message on attempt to use PREPARE/EXECUTE/DEALLOCATE
          in a stored function or trigger
      mysql-test/r/sp-dynamic.result:
        - sp-dynamic.test results
      mysql-test/t/sp-dynamic.test:
        - a new test for PREPARE/EXECUTE/DEALLOCATE in stored procedures.
      9fbcfd67
    • unknown's avatar
      row0sel.c: · 79cf2a65
      unknown authored
        Fix bug #12947 : a consistent read could return inconsistent results; this bug was introduced in 5.0.5
      
      
      innobase/row/row0sel.c:
        Fix bug #12947 : a consistent read could return inconsistent results; this bug was introduced in 5.0.5
      79cf2a65
    • unknown's avatar
      Merge mysql.com:/home/jimw/my/mysql-4.1-clean · 0616ea91
      unknown authored
      into  mysql.com:/home/jimw/my/mysql-5.0-clean
      
      
      mysql-test/t/variables.test:
        Auto merged
      sql/set_var.cc:
        Auto merged
      mysql-test/r/variables.result:
        Resolve conflict
      scripts/mysqld_multi.sh:
        Resolve conflict
      0616ea91
    • unknown's avatar
      Merge mysql.com:/home/jimw/my/mysql-4.1-11280 · 76da91b5
      unknown authored
      into  mysql.com:/home/jimw/my/mysql-4.1-clean
      
      76da91b5
    • unknown's avatar
      Compile error fix. · 114b4e9d
      unknown authored
      
      client/mysqltest.c:
        Have variable declarations before "DBUG_ENTER",
        the opposite order will fail to compile on some platforms.
      114b4e9d
    • unknown's avatar
      Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-5.0 · eef7dff3
      unknown authored
      into  sanja.is.com.ua:/home/bell/mysql/bk/work-bug3-5.0
      
      
      sql/item.cc:
        Auto merged
      sql/mysql_priv.h:
        Auto merged
      sql/sql_base.cc:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      sql/sql_view.cc:
        Auto merged
      sql/table.cc:
        Auto merged
      eef7dff3
    • unknown's avatar
      Rename: · 8857d641
      unknown authored
      - current_arena to stmt_arena: the thread may have more than one
      'current' arenas: one for runtime data, and one for the parsed 
      tree of a statement. Only one of them is active at any moment.
      - set_item_arena -> set_query_arena, because Item_arena was renamed to 
      Query_arena a while ago
      - set_n_backup_item_arena -> set_n_backup_active_arena;
      the active arena is the arena thd->mem_root and thd->free_list
      are currently pointing at.
      - restore_backup_item_arena -> restore_active_arena (with the same
      rationale)
      - change_arena_if_needed -> activate_stmt_arena_if_needed; this
      method sets thd->stmt_arena active if it's not done yet.
      
      
      sql/item.cc:
        Rename.
      sql/item_cmpfunc.cc:
        Rename.
      sql/item_func.cc:
        Rename.
      sql/item_subselect.cc:
        Rename.
      sql/item_subselect.h:
        Remove an unused forward declaration.
      sql/item_sum.h:
        Remove an unused forward declaration.
      sql/mysql_priv.h:
        Remove an unused forward declaration.
      sql/sp.cc:
        Rename.
      sql/sp_head.cc:
        Rename.
      sql/sql_base.cc:
        Rename.
      sql/sql_class.cc:
        Rename.
      sql/sql_class.h:
        Rename.
      sql/sql_lex.cc:
        Rename.
      sql/sql_parse.cc:
        Rename.
      sql/sql_prepare.cc:
        Rename.
      sql/sql_select.cc:
        Rename.
      sql/sql_show.cc:
        Rename.
      sql/sql_union.cc:
        Rename.
      sql/sql_view.cc:
        Rename.
      sql/table.cc:
        Rename.
      8857d641
    • unknown's avatar
      Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-5.0 · 8027ca8f
      unknown authored
      into  sanja.is.com.ua:/home/bell/mysql/bk/work-bug3-5.0
      
      
      sql/sql_parse.cc:
        Auto merged
      8027ca8f
    • unknown's avatar
      Merge joreland@bk-internal.mysql.com:/home/bk/mysql-5.0 · ba5d5bbf
      unknown authored
      into  eel.(none):/home/jonas/src/mysql-5.0-push
      
      ba5d5bbf
    • unknown's avatar
      Merge joreland@bk-internal.mysql.com:/home/bk/mysql-5.0 · 0923d5bd
      unknown authored
      into  eel.(none):/home/jonas/src/mysql-5.0-push
      
      0923d5bd
    • unknown's avatar
      Removed redundant case in Makefile.am · 331f75d1
      unknown authored
      
      
      Makefile.am:
        Removed redundant case
      331f75d1
    • unknown's avatar
      Merge eel.(none):/home/jonas/src/mysql-5.0 · 2c353660
      unknown authored
      into  eel.(none):/home/jonas/src/mysql-5.0-push
      
      2c353660
    • unknown's avatar
      Merge eel.(none):/home/jonas/src/mysql-4.1 · 75cabf80
      unknown authored
      into  eel.(none):/home/jonas/src/mysql-4.1-push
      
      75cabf80
    • unknown's avatar
      Merge eel.(none):/home/jonas/src/mysql-4.1 · e5733f2a
      unknown authored
      into  eel.(none):/home/jonas/src/mysql-5.0
      
      
      ndb/include/kernel/signaldata/SignalData.hpp:
        Auto merged
      ndb/src/common/debugger/signaldata/SignalDataPrint.cpp:
        Auto merged
      ndb/src/kernel/blocks/dbdih/DbdihMain.cpp:
        Auto merged
      ndb/src/kernel/blocks/dbtc/DbtcMain.cpp:
        Auto merged
      ndb/src/common/debugger/EventLogger.cpp:
        merge
      e5733f2a