1. 06 Sep, 2005 3 commits
    • unknown's avatar
      Add testcase for bug #12084. · d17b361e
      unknown authored
      d17b361e
    • unknown's avatar
      InnoDB: Reject foreign keys in temporary tables. Closes bug #12084. · 2d1c26cc
      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.
      2d1c26cc
    • unknown's avatar
      Merge · 7b2aacb7
      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
      7b2aacb7
  2. 05 Sep, 2005 12 commits
  3. 04 Sep, 2005 4 commits
    • unknown's avatar
      row0mysql.c, ha_innodb.cc: · c02509b1
      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
      c02509b1
    • unknown's avatar
      This patch disables the query cache for the federated engine. · 7425899f
      unknown authored
      
      sql/ha_federated.h:
        Fix cache issues
      7425899f
    • unknown's avatar
      ha_innodb.cc: · d6b70bf4
      unknown authored
        Better comments about auto-inc and SHOW TABLE STATUS
      
      
      sql/ha_innodb.cc:
        Better comments about auto-inc and SHOW TABLE STATUS
      d6b70bf4
    • unknown's avatar
      ha_innodb.cc: · 53379f98
      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
      53379f98
  4. 03 Sep, 2005 7 commits
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.0 · 7f38d440
      unknown authored
      into  mysql.com:/home/jimw/my/mysql-5.0-clean
      
      
      7f38d440
    • unknown's avatar
      Merge mysql.com:/home/jimw/my/mysql-5.0-11787 · 3eb26b77
      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
      3eb26b77
    • unknown's avatar
      univ.i, page0page.ic: · 8b2b0e24
      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
      8b2b0e24
    • unknown's avatar
      row0sel.c: · 80ea9db8
      unknown authored
        Fix a wrong debug assert in the previous patch
      
      
      innobase/row/row0sel.c:
        Fix a wrong debug assert in the previous patch
      80ea9db8
    • unknown's avatar
      row0sel.c: · cf4a47c0
      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
      cf4a47c0
    • unknown's avatar
      Merge heikki@bk-internal.mysql.com:/home/bk/mysql-5.0 · 67a74369
      unknown authored
      into  hundin.mysql.fi:/home/heikki/mysql-5.0
      
      
      67a74369
    • unknown's avatar
      Merge joreland@bk-internal.mysql.com:/home/bk/mysql-4.1 · fd3164e3
      unknown authored
      into  eel.(none):/home/jonas/src/mysql-4.1-push
      
      
      fd3164e3
  5. 02 Sep, 2005 14 commits
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 17994730
      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
      17994730
    • unknown's avatar
      Implement WL#2661 "Prepared Statements: Dynamic SQL in Stored Procedures". · c910050a
      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.
      c910050a
    • unknown's avatar
      row0sel.c: · 387c2589
      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
      387c2589
    • unknown's avatar
      Merge mysql.com:/home/jimw/my/mysql-4.1-clean · 79ae20bc
      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
      79ae20bc
    • unknown's avatar
      Merge mysql.com:/home/jimw/my/mysql-4.1-11280 · cbb1da77
      unknown authored
      into  mysql.com:/home/jimw/my/mysql-4.1-clean
      
      
      cbb1da77
    • unknown's avatar
      Compile error fix. · 5d99ed0e
      unknown authored
      
      client/mysqltest.c:
        Have variable declarations before "DBUG_ENTER",
        the opposite order will fail to compile on some platforms.
      5d99ed0e
    • unknown's avatar
      Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-5.0 · 196862df
      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
      196862df
    • unknown's avatar
      Rename: · dc922213
      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.
      dc922213
    • unknown's avatar
      Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-5.0 · 29a37a30
      unknown authored
      into  sanja.is.com.ua:/home/bell/mysql/bk/work-bug3-5.0
      
      
      sql/sql_parse.cc:
        Auto merged
      29a37a30
    • unknown's avatar
      Merge joreland@bk-internal.mysql.com:/home/bk/mysql-5.0 · aeb7fe83
      unknown authored
      into  eel.(none):/home/jonas/src/mysql-5.0-push
      
      
      aeb7fe83
    • unknown's avatar
      Merge joreland@bk-internal.mysql.com:/home/bk/mysql-5.0 · 81f89241
      unknown authored
      into  eel.(none):/home/jonas/src/mysql-5.0-push
      
      
      81f89241
    • unknown's avatar
      Removed redundant case in Makefile.am · 8f0530d0
      unknown authored
      
      
      Makefile.am:
        Removed redundant case
      8f0530d0
    • unknown's avatar
      Merge eel.(none):/home/jonas/src/mysql-5.0 · 6f85ba17
      unknown authored
      into  eel.(none):/home/jonas/src/mysql-5.0-push
      
      
      6f85ba17
    • unknown's avatar
      Merge eel.(none):/home/jonas/src/mysql-4.1 · 5fafed14
      unknown authored
      into  eel.(none):/home/jonas/src/mysql-4.1-push
      
      
      5fafed14