1. 14 Aug, 2006 1 commit
    • unknown's avatar
      Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots. · 2606cb93
      unknown authored
      All but ss677 are against the mysql-5.1 tree only.
      
      Fixes the following bugs:
      - Bug #19834: Using cursors when running in READ-COMMITTED can cause InnoDB to crash
      - Bug #20213: DBT2 testing cause mysqld to core using Innodb
      - Bug #20493: on partition tables, select and show command casue server crash
      - Bug #21113: Duplicate printout in SHOW INNODB STATUS
      - Bug #21313: rsql_..._recover_innodb_tmp_table is redundant and broken
      - Bug #21467: Manual URL wrong in InnoDB "page corrupted" error report
      
      
      mysql-test/r/innodb.result:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
        
        innodb.result: Adjust Innodb_rows_inserted and Innodb_rows_updated
        to reflect the deleted statements in r420, which somehow reappeared
        in the MySQL tree.
      mysql-test/t/innodb.test:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
      sql/ha_innodb.cc:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
        
        ha_innobase::start_stmt(): patch from Heikki:
        Do not call read_view_close_for_mysql().  (Bug #19834)
        
        Fix Bug#20213 and its duplicates: stress test crashes of InnoDB-5.1
        
        Fix Bug #20493 : we must prepare prebuilt->trx to point to the trx of this thd before using it
        
        Add update_thd() to several places in ha_innodb.cc to make sure prebuilt->trx points to the right trx object; in other functions add assertions that prebuilt->trx is for this thd; when 5.1 stabilizes, we can change these assertions to ut_ad() debug version assertions
        
        Remove redundant check_trx_exists() and ut_a() from r701,
        as suggested by Marko
        
        Correct all URLs pointing to the MySQL manual. (Bug #21467)
      storage/innobase/btr/btr0btr.c:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
        
        Correct all URLs pointing to the MySQL manual. (Bug #21467)
      storage/innobase/buf/buf0buf.c:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
        
        Correct all URLs pointing to the MySQL manual. (Bug #21467)
      storage/innobase/dict/dict0dict.c:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
        
        Correct all URLs pointing to the MySQL manual. (Bug #21467)
      storage/innobase/fil/fil0fil.c:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
        
        Make the tablespace cache hash size 100 or 1000 times bigger. Fixes bug
        #21112.
        
        After ut_print_timestamp(), always display "  InnoDB:" (note two spaces).
        
        Correct all URLs pointing to the MySQL manual. (Bug #21467)
      storage/innobase/fsp/fsp0fsp.c:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
        
        Correct all URLs pointing to the MySQL manual. (Bug #21467)
      storage/innobase/ibuf/ibuf0ibuf.c:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
        
        ibuf_print(): Don't print redundant information. Fixes bug #21113.
        
        Remove non-varying variable ibuf->meter and related constant IBUF_THRESHOLD.
      storage/innobase/include/btr0cur.ic:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
        
        btr_cur_get_page(): Remove buggy assertion.
      storage/innobase/include/buf0buf.ic:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
        
        Correct all URLs pointing to the MySQL manual. (Bug #21467)
      storage/innobase/include/ibuf0ibuf.ic:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
        
        Remove non-varying variable ibuf->meter and related constant IBUF_THRESHOLD.
      storage/innobase/log/log0log.c:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
        
        Correct all URLs pointing to the MySQL manual. (Bug #21467)
      storage/innobase/log/log0recv.c:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
        
        Correct all URLs pointing to the MySQL manual. (Bug #21467)
      storage/innobase/os/os0file.c:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
        
        Correct all URLs pointing to the MySQL manual. (Bug #21467)
      storage/innobase/row/row0mysql.c:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
        
        Remove the special treatment of tables
        rsql_IDENTIFIER_recover_innodb_tmp_table, which is redundant and
        was broken with the introduction of the "safe" file name encoding of
        identifiers.  (Bug #21313)
        
        ChangeSet@1.2181.173.1  2006-08-02 17:57:06+02:00  ingo@local
        Bug#18775 - Temporary table from alter table visible to other threads
        Continued implementation of WL#1324 (table name to filename encoding)
        Changed back the encoded temp file prefix to #sql.
        
        After ut_print_timestamp(), always display "  InnoDB:" (note two spaces).
        
        Correct all URLs pointing to the MySQL manual. (Bug #21467)
      storage/innobase/row/row0sel.c:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
        
        Correct all URLs pointing to the MySQL manual. (Bug #21467)
      storage/innobase/row/row0vers.c:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
        
        row_vers_build_for_semi_consistent_read(): rec_trx_id was uninitialized
        in a comparison.  Initialize it.
      storage/innobase/srv/srv0start.c:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
        
        Correct all URLs pointing to the MySQL manual. (Bug #21467)
      storage/innobase/ut/ut0dbg.c:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
        
        ut_dbg_assertion_failed(): Print space between timestamp and start of error
        message.
        
        After ut_print_timestamp(), always display "  InnoDB:" (note two spaces).
        
        Correct all URLs pointing to the MySQL manual. (Bug #21467)
      storage/innobase/Makefile.am:
        Applied innodb-5.1-ss677, -ss680, -ss713, and -ss720 snapshots.
        All but ss677 are against the mysql-5.1 tree only.
      2606cb93
  2. 10 Aug, 2006 10 commits
    • unknown's avatar
      Merge pgalbraith@bk-internal.mysql.com:/home/bk/mysql-5.1-runtime · 2f48a591
      unknown authored
      into  govinda.patg.net:/home/patg/mysql-build/mysql-5.1-engines-merge
      
      
      sql/mysql_priv.h:
        Auto merged
      sql/sql_base.cc:
        Auto merged
      sql/sql_yacc.yy:
        Auto merged
      2f48a591
    • unknown's avatar
      Merge pgalbraith@bk-internal.mysql.com:/home/bk/mysql-5.1 · fab1b2f5
      unknown authored
      into  govinda.patg.net:/home/patg/mysql-build/mysql-5.1-engines-merge
      
      
      sql/ha_myisam.cc:
        Auto merged
      sql/ha_myisammrg.cc:
        Auto merged
      sql/ha_ndbcluster.cc:
        Auto merged
      sql/mysql_priv.h:
        Auto merged
      sql/sql_acl.cc:
        Auto merged
      sql/sql_base.cc:
        Auto merged
      sql/sql_delete.cc:
        Auto merged
      sql/sql_insert.cc:
        Auto merged
      sql/sql_partition.cc:
        Auto merged
      sql/sql_show.cc:
        Auto merged
      sql/sql_table.cc:
        Auto merged
      sql/sql_trigger.cc:
        Auto merged
      sql/sql_view.cc:
        Auto merged
      sql/sql_yacc.yy:
        Auto merged
      sql/table.cc:
        Auto merged
      storage/innobase/row/row0mysql.c:
        Auto merged
      fab1b2f5
    • unknown's avatar
      Merge moonlight.intranet:/home/tomash/src/mysql_ab/mysql-5.1-merge · eef51cd8
      unknown authored
      into  moonlight.intranet:/home/tomash/src/mysql_ab/mysql-5.1-runtine-merge
      
      
      mysql-test/r/sp.result:
        Auto merged
      mysql-test/t/sp.test:
        Auto merged
      sql/sql_base.cc:
        Auto merged
      eef51cd8
    • unknown's avatar
      Merge moonlight.intranet:/home/tomash/src/mysql_ab/tmp_merge · 3459da7d
      unknown authored
      into  moonlight.intranet:/home/tomash/src/mysql_ab/mysql-5.1-merge
      
      
      client/mysql.cc:
        Auto merged
      mysql-test/Makefile.am:
        Auto merged
      mysql-test/r/date_formats.result:
        Auto merged
      mysql-test/r/func_str.result:
        Auto merged
      mysql-test/r/sp.result:
        Auto merged
      mysql-test/t/date_formats.test:
        Auto merged
      mysql-test/t/func_str.test:
        Auto merged
      mysql-test/t/ps_1general.test:
        Auto merged
      mysql-test/t/sp.test:
        Auto merged
      mysql-test/t/udf.test:
        Auto merged
      mysys/my_open.c:
        Auto merged
      BitKeeper/deleted/.del-make_win_src_distribution.sh~f80d8fca44e4e5f1:
        Auto merged
      sql/field.cc:
        Auto merged
      sql/field.h:
        Auto merged
      sql/item_strfunc.cc:
        Auto merged
      sql/mysql_priv.h:
        Auto merged
      sql/sql_class.cc:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      sql/time.cc:
        Auto merged
      client/mysqltest.c:
        Manual merge.
      mysql-test/r/ps_1general.result:
        Manual merge.
      3459da7d
    • unknown's avatar
      Merge moonlight.intranet:/home/tomash/src/mysql_ab/tmp_merge · 6fb4287a
      unknown authored
      into  moonlight.intranet:/home/tomash/src/mysql_ab/mysql-5.1-merge
      
      
      sql/ha_innodb.cc:
        Null-merge.
      storage/innobase/fil/fil0fil.c:
        Null-merge.
      storage/innobase/ibuf/ibuf0ibuf.c:
        Null-merge.
      6fb4287a
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.1-runtime · 13475abf
      unknown authored
      into  janus.mylan:/usr/home/serg/Abk/m51
      
      
      configure.in:
        Auto merged
      sql/sql_base.cc:
        Auto merged
      13475abf
    • unknown's avatar
      revert part of the code · 5b7f05de
      unknown authored
      how did it get in?!? (it's only in local csets so no other tree is affected)
      
      
      sql/sp.cc:
        revert this patch.
        how did it get in?!? (it's only in local csets so no other tree is affected)
      5b7f05de
    • unknown's avatar
      after merge update · 2834469c
      unknown authored
      
      mysql-test/r/mysqldump.result:
        update result
      mysql-test/t/mysqldump.test:
        update test
      2834469c
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.1 · 6646048f
      unknown authored
      into janus.mylan:/usr/home/serg/Abk/m51
      
      
      configure.in:
        Auto merged
      6646048f
    • unknown's avatar
      Merge moonlight.intranet:/home/tomash/src/mysql_ab/mysql-5.1 · 2a90e7f1
      unknown authored
      into  moonlight.intranet:/home/tomash/src/mysql_ab/mysql-5.1-merge
      
      
      sql/sql_base.cc:
        Auto merged
      2a90e7f1
  3. 09 Aug, 2006 6 commits
    • unknown's avatar
      sql_base.cc, table.cc: · b6920c54
      unknown authored
        After merge fix
      
      
      sql/table.cc:
        After merge fix
      sql/sql_base.cc:
        After merge fix
      b6920c54
    • unknown's avatar
      Merge ahristov@bk-internal.mysql.com:/home/bk/mysql-5.1-runtime · b60873b1
      unknown authored
      into  lmy004.:/work/mysql-5.1-runtime
      
      
      sql/sp.cc:
        Auto merged
      sql/sql_yacc.yy:
        Auto merged
      mysql-test/r/sp.result:
        manual merge
      mysql-test/t/sp.test:
        manual merge
      b60873b1
    • unknown's avatar
      Fix for bug#20701 BINARY keyword should be forbidden in stored routines · 0231ca09
      unknown authored
          
      create function func() returns char(10) binary ...
      is no more possible. This will be reenabled when 
      bug 2676 "DECLARE can't have COLLATE clause in stored procedure"
      is fixed.
      
      Fix after 2nd review
      
      
      mysql-test/r/sp-error.result:
        update result
      mysql-test/r/sp.result:
        update result
      mysql-test/t/sp-error.test:
        add a test case for bug#20701 BINARY keyword should be forbidden in stored procedures
      mysql-test/t/sp.test:
        Fix test case which uses binary for the return value of a function.
        It's no more possible after fix for bug#20701 
        BINARY keyword should be forbidden in SP
        
        Fix few glitches where ; is used instead of | . The delimiter is |
      sql/sql_yacc.yy:
        Fix for bug#20701 BINARY keyword should be forbidden in stored routines
        
        create function func() returns char(10) binary ...
        is no more possible. This will be reenabled when 
        bug 2676 "DECLARE can't have COLLATE clause in stored procedure"
        is fixed
      0231ca09
    • unknown's avatar
      Merge moonlight.intranet:/home/tomash/src/mysql_ab/mysql-5.1-merge · 29701579
      unknown authored
      into  moonlight.intranet:/home/tomash/src/mysql_ab/mysql-5.1-rt-merge
      
      
      sql/handler.cc:
        Auto merged
      sql/mysqld.cc:
        Auto merged
      sql/sql_base.cc:
        Auto merged
      sql/share/errmsg.txt:
        Auto merged
      29701579
    • unknown's avatar
      Post-merge fix. · 5f34962a
      unknown authored
      
      sql/sql_parse.cc:
        Post-merge fix.  No need to check DB name twice.
      5f34962a
    • unknown's avatar
      Merge moonlight.intranet:/home/tomash/src/mysql_ab/tmp_merge · 22b92457
      unknown authored
      into  moonlight.intranet:/home/tomash/src/mysql_ab/mysql-5.1-merge
      
      
      BitKeeper/deleted/.del-mysys.vcproj~40a49d09c4184822:
        Auto merged
      configure.in:
        Auto merged
      mysql-test/mysql-test-run.pl:
        Auto merged
      mysql-test/r/func_time.result:
        Auto merged
      mysql-test/r/warnings.result:
        Auto merged
      mysql-test/t/func_time.test:
        Auto merged
      mysql-test/t/mysqlbinlog.test:
        Auto merged
      mysql-test/t/udf.test:
        Auto merged
      mysql-test/t/warnings.test:
        Auto merged
      BitKeeper/deleted/.del-mysqld.vcproj~6aa7b3f9c3e28fcb:
        Auto merged
      sql/field.cc:
        Auto merged
      sql/handler.cc:
        Auto merged
      sql/mysql_priv.h:
        Auto merged
      sql/mysqld.cc:
        Auto merged
      sql/set_var.cc:
        Auto merged
      sql/sp.cc:
        Auto merged
      sql/sql_class.cc:
        Auto merged
      support-files/mysql.spec.sh:
        Auto merged
      mysql-test/r/sp.result:
        Manual merge.  Place 5.0 test before 5.1 test.
      mysql-test/t/sp.test:
        Manual merge.  Place 5.0 test before 5.1 test.
      mysys/my_bitmap.c:
        Manual merge.
      scripts/make_binary_distribution.sh:
        Manual merge.
      sql/Makefile.am:
        Manual merge.
      sql/slave.cc:
        Manual merge.
      sql/sql_class.h:
        Manual merge.
      sql/sql_parse.cc:
        Manual merge.
      sql/sql_select.cc:
        Manual merge.
      tests/mysql_client_test.c:
        Manual merge.
      22b92457
  4. 08 Aug, 2006 5 commits
    • unknown's avatar
      Merge sunlight.local:/local_work/leak_fix_orig · 68d26515
      unknown authored
      into  sunlight.local:/local_work/leak_fix-5.1-mysql
      
      
      sql/sql_lex.h:
        Auto merged
      sql/sql_view.cc:
        Auto merged
      sql/sql_view.h:
        Auto merged
      sql/unireg.h:
        Auto merged
      sql/sql_base.cc:
        Manual merge
      sql/table.cc:
        Manual merge
      68d26515
    • unknown's avatar
      BUG #21524 "'ps' test fails in --ps-protocol test AMD64 bit" · b6897efb
      unknown authored
      (this is not a fix to the bug, but simply to disable the test in 
      order to push a 5.0 to 5.1 merge)
      
      This merge contains:
      
      Push by holyfoot@production.mysql.com on Tue Jul 25 13:41:40 2006:
      
      bk clone -l -r'holyfoot/hf@mysql.com/deer.(none)|ChangeSet|20060725085017|41021' mysql-5.0 tmp_merge
      
      
      mysql-test/t/disabled.def:
        BUG #21524 "'ps' test fails in --ps-protocol test AMD64 bit"
        
        (this is not a fix to the bug, but simply to disable the test in 
        order to push a 5.0 to 5.1 merge)
      b6897efb
    • unknown's avatar
      sql_base.cc, unireg.h, sql_lex.h, table.cc, sql_view.h, sql_view.cc: · 1e9ebd01
      unknown authored
        Correct memory leak fix
      
      
      sql/unireg.h:
        Correct memory leak fix
      sql/table.cc:
        Correct memory leak fix
      sql/sql_view.h:
        Correct memory leak fix
      sql/sql_view.cc:
        Correct memory leak fix
      sql/sql_lex.h:
        Correct memory leak fix
      sql/sql_base.cc:
        Correct memory leak fix
      1e9ebd01
    • unknown's avatar
      Merge govinda.patg.net:/home/patg/mysql-build/mysql-5.0-holyfoot · f1af1a5d
      unknown authored
      into  govinda.patg.net:/home/patg/mysql-build/mysql-5.1-5.0-merge2
      
      Push by holyfoot@production.mysql.com on Tue Jul 25 13:41:40 2006:
      
      bk clone -l -r'holyfoot/hf@mysql.com/deer.(none)|ChangeSet|20060725085017|41021' mysql-5.0 tmp_merge
      
      
      BitKeeper/deleted/.del-libmysqld.dsp~78dc6a589e5a4149:
        Auto merged
      configure.in:
        Auto merged
      libmysqld/lib_sql.cc:
        Auto merged
      mysql-test/r/date_formats.result:
        Auto merged
      mysql-test/r/merge.result:
        Auto merged
      mysql-test/t/date_formats.test:
        Auto merged
      mysql-test/t/merge.test:
        Auto merged
      sql/field.h:
        Auto merged
      sql/ha_myisammrg.cc:
        Auto merged
      BitKeeper/deleted/.del-libmysqld.vcproj~a75d5b9a5967dea0:
        Auto merged
      BitKeeper/deleted/.del-libmysqld_ia64.dsp~578ab58d5f281d2a:
        Auto merged
      BitKeeper/deleted/.del-mysqld.dsp~ffdbf2d234e23e56:
        Auto merged
      BitKeeper/deleted/.del-mysqld.vcproj~6aa7b3f9c3e28fcb:
        Auto merged
      BitKeeper/deleted/.del-mysqld_ia64.dsp~7f8cf84d81ee04e2:
        Auto merged
      BitKeeper/deleted/.del-mysqldemb.dsp~1baf8c0e59ee9f7e:
        Auto merged
      BitKeeper/deleted/.del-mysqldemb.vcproj~54c64d55ccc51a7c:
        Auto merged
      BitKeeper/deleted/.del-mysqldemb_ia64.dsp~c7f7d75d542393cd:
        Auto merged
      BitKeeper/deleted/.del-mysqldmax.dsp~5d213fe1c204142e:
        Auto merged
      BitKeeper/deleted/.del-mysqldmax_ia64.dsp~25006b7cc0725ad1:
        Auto merged
      sql/item_strfunc.cc:
        Auto merged
      sql/item_timefunc.cc:
        Auto merged
      sql/sql_class.cc:
        Auto merged
      support-files/mysql.spec.sh:
        Auto merged
      include/my_base.h:
        Hand merge of conflicts (5.0-5.1 merge), second try 
        
        Push by holyfoot@production.mysql.com on Tue Jul 25 13:41:40 2006:
        
        bk clone -l -r'holyfoot/hf@mysql.com/deer.(none)|ChangeSet|20060725085017|41021' mysql-5.0 tmp_merge
      mysql-test/r/federated.result:
        Hand merge of conflicts (5.0-5.1 merge), second try 
        
        Push by holyfoot@production.mysql.com on Tue Jul 25 13:41:40 2006:
        
        bk clone -l -r'holyfoot/hf@mysql.com/deer.(none)|ChangeSet|20060725085017|41021' mysql-5.0 tmp_merge
      mysql-test/t/federated.test:
        Hand merge of conflicts (5.0-5.1 merge), second try 
        
        Push by holyfoot@production.mysql.com on Tue Jul 25 13:41:40 2006:
        
        bk clone -l -r'holyfoot/hf@mysql.com/deer.(none)|ChangeSet|20060725085017|41021' mysql-5.0 tmp_merge
      sql/field.cc:
        Hand merge of conflicts (5.0-5.1 merge), second try 
        
        Push by holyfoot@production.mysql.com on Tue Jul 25 13:41:40 2006:
        
        bk clone -l -r'holyfoot/hf@mysql.com/deer.(none)|ChangeSet|20060725085017|41021' mysql-5.0 tmp_merge
      sql/ha_federated.cc:
        Hand merge of conflicts (5.0-5.1 merge), second try 
        
        Push by holyfoot@production.mysql.com on Tue Jul 25 13:41:40 2006:
        
        bk clone -l -r'holyfoot/hf@mysql.com/deer.(none)|ChangeSet|20060725085017|41021' mysql-5.0 tmp_merge
      sql/handler.cc:
        Hand merge of conflicts (5.0-5.1 merge), second try 
        
        Push by holyfoot@production.mysql.com on Tue Jul 25 13:41:40 2006:
        
        bk clone -l -r'holyfoot/hf@mysql.com/deer.(none)|ChangeSet|20060725085017|41021' mysql-5.0 tmp_merge
      tests/mysql_client_test.c:
        Hand merge of conflicts (5.0-5.1 merge), second try 
        
        Push by holyfoot@production.mysql.com on Tue Jul 25 13:41:40 2006:
        
        bk clone -l -r'holyfoot/hf@mysql.com/deer.(none)|ChangeSet|20060725085017|41021' mysql-5.0 tmp_merge
      f1af1a5d
    • unknown's avatar
      Fix windows pushbuild failure: the bug occured because · 9de602d2
      unknown authored
      we didn't check for NULL value of the
      lex_create_info->db_type pointer.
      The pointer is NULL in the case, when the engine name is
      unknown to the server. This happens with NDB on Windows.
      
      
      sql/sql_table.cc:
        don't check pointer in the case, it is NULL
      9de602d2
  5. 04 Aug, 2006 2 commits
    • unknown's avatar
      Fix for bug#21416 SP: Recursion level higher than zero needed for non-recursive call · e60678ae
      unknown authored
      The following procedure was not possible if max_sp_recursion_depth is 0
      create procedure show_proc() show create procedure show_proc;
      
      Actually there is no recursive call but the limit is checked.
      
      Solved by temporarily increasing the thread's limit just before the fetch from cache
      and decreasing after that.
      
      
      mysql-test/r/sp.result:
        update result
      mysql-test/t/sp.test:
        Test for bug #21416 SP: Recursion level higher than zero needed for non-recursive call
      sql/sp.cc:
        Increase the max_sp_recursion_depth temporarily for SHOW CREATE PROCEDURE call.
        This call is in fact not recursive but is counted as such. Outcome, it will work
        always but if max_sp_recursion_depth is reached we are going to cache one more
        sp_head instance.
      e60678ae
    • unknown's avatar
      Merge pchardin@bk-internal.mysql.com:/home/bk/mysql-5.1-runtime · 79b03c66
      unknown authored
      into  mysql.com:/home/cps/mysql/devel/5.1-curs-bug
      
      
      sql/ha_myisam.cc:
        Auto merged
      sql/handler.h:
        Auto merged
      sql/sql_table.cc:
        Auto merged
      mysql-test/r/log_tables.result:
        SCCS merged
      mysql-test/t/log_tables.test:
        SCCS merged
      79b03c66
  6. 03 Aug, 2006 16 commits
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.1-new-maint · 5e2babfe
      unknown authored
      into  maint1.mysql.com:/data/localhome/tsmith/bk/mrg51-c
      
      
      5e2babfe
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.1-new-maint · f87df4cc
      unknown authored
      into  neptunus.(none):/home/msvensson/mysql/mysql-5.1-new-maint
      
      
      f87df4cc
    • unknown's avatar
      Merge rama.(none):/home/jimw/my/mysql-5.1-17122 · 551f9ded
      unknown authored
      into  rama.(none):/home/jimw/my/mysql-5.1-clean
      
      
      551f9ded
    • unknown's avatar
      Manual merge resolve, part 6 of 6+ · a4f66037
      unknown authored
      a4f66037
    • unknown's avatar
      Use "--source" command instead of "source", makes mysql-test-run.pl dtecte... · 5f61f026
      unknown authored
      Use "--source" command instead of "source", makes mysql-test-run.pl dtecte this as test case that need binlog format row.
      
      
      
      5f61f026
    • unknown's avatar
      Merge maint1.mysql.com:/data/localhome/tsmith/bk/mrg51-a · 177c0623
      unknown authored
      into  maint1.mysql.com:/data/localhome/tsmith/bk/mrg51-c
      
      
      177c0623
    • unknown's avatar
      Fix Bug #18559 "log tables cannot change engine, and · 157c42de
      unknown authored
                      gets deadlocked when dropping w/ log on"
      
      Log tables rely on concurrent insert machinery to add data.
      This means that log tables are always opened and locked by
      special (artificial) logger threads. Because of this, the thread
      which tries to drop a log table starts to wait for the table
      to be unlocked. Which will happen only if the log table is disabled.
      Alike situation happens if one tries to alter a log table.
      However in addition to the problem above, alter table calls
      check_if_locking_is_allowed() routine for the engine. The
      routine does not allow alter for the log tables. So, alter
      doesn't start waiting forever for logs to be disabled, but 
      returns with an error.
      Another problem is that not all engines could be used for
      the log tables. That's because they need concurrent insert.
      
      In this patch we:
      (1) Explicitly disallow to drop/alter a log table if it
          is currently used by the logger.
      (2) Update MyISAM to support log tables
      (3) Allow to drop log tables/alter log tables if log is
          disabled
      At the same time we (4) Disallow to alter log tables to
      unsupported engine (after this patch CSV and MyISAM are 
      alowed)
      Recommit with review fixes.
      
      
      mysql-test/r/log_tables.result:
        Update result file.
        Note: there are warnings in result file. This is because of CSV
        bug (Bug #21328). They should go away after it is fixed.
      mysql-test/t/log_tables.test:
        Add a test for the bug
      sql/ha_myisam.cc:
        Add log table handling to myisam: as log tables
        use concurrent insert, they are typically
        locked with TL_CONCURRERENT_INSERT lock. So,
        disallow other threads to attempt locking of
        the log tables in incompatible modes. Because
        otherwise the threads will wait for the tables
        to be unlocked forever.
      sql/handler.cc:
        Add a function to check if a table we're going to lock
        is a log table and if the lock mode we want allowed
      sql/handler.h:
        Add a new function to check compatibility of the locking
      sql/log.cc:
        we shouldn't close the log table if and only
        if this particular table is already closed
      sql/log.h:
        add new functions to check if a log is enabled
      sql/share/errmsg.txt:
        add new error messages
      sql/sql_table.cc:
        DROP and ALTER TABLE should not work on log
        tables if the log tables are enabled
      storage/csv/ha_tina.cc:
        move function to check if the locking for the log
        tables allowed to handler class, so that we can
        reuse it in other engines.
      storage/myisam/mi_extra.c:
        add new ::extra() flag processing to myisam
      storage/myisam/mi_open.c:
        init log table flag
      storage/myisam/mi_write.c:
        update status after each write if it's a log table
      storage/myisam/myisamdef.h:
        Add new log table flag to myisam share.
        We need it to distinguish between usual
        and log tables, as for the log tables we
        should provide concurrent insert in a
        different way than for usual tables: we
        want new rows to be immediately visible
        to other threads.
      157c42de
    • unknown's avatar
      5.0 -> 5.1 manual merge, part 5 of 5 (or more?) · 9f0f8458
      unknown authored
      9f0f8458
    • unknown's avatar
      Replace FEDERATED_EQ with STRING_WITH_LEN("=") · 358400a8
      unknown authored
      
      sql/ha_federated.cc:
        After merge fix
      358400a8
    • unknown's avatar
      Merge neptunus.(none):/home/msvensson/mysql/my51-m-bug20942 · b58c7551
      unknown authored
      into  neptunus.(none):/home/msvensson/mysql/mysql-5.1-new-maint
      
      
      sql/ha_federated.cc:
        Manual merge
      b58c7551
    • unknown's avatar
      Fix Bug #20139 Infinite loop after "FLUSH" and "LOCK tabX, general_log" · e1ec4de4
      unknown authored
      Due to incorrect handling of FLUSH TABLES, log tables were marked for flush,
      but not reopened. Later we started to wait for the log table to be closed
      (disabled) after the flush. And as nobody disabled logs in concurrent treads,
      the command lasted forever.
      After internal consultations it was decided to skip logs during FLUSH TABLES.
      The reasoning is that logging is done in the "log device", whatever it is
      which is always active and controlled by FLUSH LOGS. So, to flush logs
      one should use FLUSH LOGS, and not FLUSH TABLES.
      
      
      mysql-test/r/log_tables.result:
        update result file
      mysql-test/t/log_tables.test:
        add a test for the bug
      sql/sql_base.cc:
        Skip log tables during FLUSH TABLES
      e1ec4de4
    • unknown's avatar
      5.0 -> 5.1 manual merge, part 4 of 4 (or more?) · 71076932
      unknown authored
      71076932
    • unknown's avatar
      Merge maint1.mysql.com:/data/localhome/tsmith/bk/mrg50-c · 15e27e48
      unknown authored
      into  maint1.mysql.com:/data/localhome/tsmith/bk/mrg51-c
      
      
      mysql-test/t/warnings.test:
        5.0 -> 5.1 manual merge, part 3 of 3 (or more?)
      sql/handler.cc:
        5.0 -> 5.1 manual merge, part 3 of 3 (or more?)
      sql/mysql_priv.h:
        5.0 -> 5.1 manual merge, part 3 of 3 (or more?)
      sql/mysqld.cc:
        5.0 -> 5.1 manual merge, part 3 of 3 (or more?)
      sql/set_var.cc:
        5.0 -> 5.1 manual merge, part 3 of 3 (or more?)
      mysql-test/r/warnings.result:
        5.0 -> 5.1 manual merge, part 3 of 3 (or more?)
      15e27e48
    • unknown's avatar
      Merge maint1.mysql.com:/data/localhome/tsmith/bk/mrg50-b · eafb7605
      unknown authored
      into  maint1.mysql.com:/data/localhome/tsmith/bk/mrg51-b
      
      
      mysql-test/r/insert_select.result:
        SCCS merged
      sql/sql_insert.cc:
        SCCS merged
      eafb7605
    • unknown's avatar
      5.0 -> 5.1 manual merge, part 1 of 3 (or more?) · 0901cb0b
      unknown authored
      0901cb0b
    • unknown's avatar
      Bug#18775 - Temporary table from alter table visible to other threads · ce4b9c82
      unknown authored
      New test cases. Names with umlauts don't compare well on Windows.
      
      
      mysql-test/r/alter_table.result:
        Bug#18775 - Temporary table from alter table visible to other threads
        New test results
      mysql-test/r/backup.result:
        Bug#18775 - Temporary table from alter table visible to other threads
        New test results
      mysql-test/t/alter_table.test:
        Bug#18775 - Temporary table from alter table visible to other threads
        New test case. Names with umlauts don't compare well on Windows.
      mysql-test/t/backup.test:
        Bug#18775 - Temporary table from alter table visible to other threads
        New test case. Names with umlauts don't compare well on Windows.
      ce4b9c82