1. 27 Dec, 2004 1 commit
    • unknown's avatar
      row0ins.c: · a7b984d2
      unknown authored
        Fix bug: if we dropped a table where an INSERT was waiting for a lock to check a FOREIGN KEY constraint, then an assertion would fail in lock_reset_all_on_table(), since that operation assumes no waiting locks on the table or its records
      row0mysql.c:
        Fix bug: InnoDB failed to drop a table in the background drop queue if the table was referenced by a foreign key constraint
      
      
      innobase/row/row0mysql.c:
        Fix bug: InnoDB failed to drop a table in the background drop queue if the table was referenced by a foreign key constraint
      innobase/row/row0ins.c:
        Fix bug: if we dropped a table where an INSERT was waiting for a lock to check a FOREIGN KEY constraint, then an assertion would fail in lock_reset_all_on_table(), since that operation assumes no waiting locks on the table or its records
      a7b984d2
  2. 24 Dec, 2004 1 commit
  3. 23 Dec, 2004 3 commits
    • unknown's avatar
      Merge sinisa@bk-internal.mysql.com:/home/bk/mysql-4.0 · 8feedada
      unknown authored
      into sinisa.nasamreza.org:/mnt/work/mysql-4.0
      
      
      8feedada
    • unknown's avatar
      Fix for a bug #7495 · 8ccfad76
      unknown authored
      
      mysql-test/r/func_str.result:
        result for test case for a bug in QUOTE() (Bug #7495)
      mysql-test/t/func_str.test:
        test case for a bug in QUOTE() (Bug #7495)
      sql/item_strfunc.cc:
        a better fix for a QUOTE() bug (Bug #7495)
      8ccfad76
    • unknown's avatar
      Make GRANTs, which change SSL attributes and/or user limits, · 4a5ca0bc
      unknown authored
      to behave well on 5.0 tables (well now you can't use tables from 4.1
      and 5.0 with 4.0 because former use utf8, but still it is nice to have
      similar code in acl_init() and replace_user_table()).
      This also will make such GRANTs working in 5.0 (they are broken now).
      
      
      mysql-test/r/grant.result:
        Added test for GRANT which manipulates user limits.
      mysql-test/t/grant.test:
        Added test for GRANT which manipulates user limits.
      4a5ca0bc
  4. 22 Dec, 2004 2 commits
    • unknown's avatar
      A fix for the bug #7495 · 74cc635a
      unknown authored
      
      mysql-test/r/func_str.result:
        A result for test case for the bug #7495 involving either LTRIM() 
        or TRIM() within QUOTE() function.
      mysql-test/t/func_str.test:
        A test case for the bug #7495 involving either LTRIM() or TRIM() 
        within QUOTE() function.
      sql/item_strfunc.cc:
        Changes for LTRIM() and TRIM() functions that aleviate the bug  
        entirely.
      74cc635a
    • unknown's avatar
      ha_innodb.cc: · e6dfed9f
      unknown authored
        If AUTOCOMMIT=1, do not acquire an InnoDB table lock in LOCK TABLES; this makes porting of old MyISAM applications to InnoDB easier, since in that mode InnoDB table locks caused deadlocks very easily
      
      
      sql/ha_innodb.cc:
        If AUTOCOMMIT=1, do not acquire an InnoDB table lock in LOCK TABLES; this makes porting of old MyISAM applications to InnoDB easier, since in that mode InnoDB table locks caused deadlocks very easily
      e6dfed9f
  5. 21 Dec, 2004 2 commits
    • unknown's avatar
      os0file.c: · fed35d92
      unknown authored
        Put back accidentally removed undef and remove a debug def
      
      
      innobase/os/os0file.c:
        Put back accidentally removed undef and remove a debug def
      fed35d92
    • unknown's avatar
      os0file.c: · b0d26c26
      unknown authored
        Fix InnoDB bug: on HP-UX, with a 32-bit binary, InnoDB was only able to read or write <= 2 GB files; the reason was that InnoDB treated the return value of lseek() as a 32-bit integer; lseek was used on HP-UX-11 as a replacement for pread() and pwrite() because HAVE_BROKEN_PREAD was defined on that platform
      
      
      innobase/os/os0file.c:
        Fix InnoDB bug: on HP-UX, with a 32-bit binary, InnoDB was only able to read or write <= 2 GB files; the reason was that InnoDB treated the return value of lseek() as a 32-bit integer; lseek was used on HP-UX-11 as a replacement for pread() and pwrite() because HAVE_BROKEN_PREAD was defined on that platform
      b0d26c26
  6. 20 Dec, 2004 1 commit
    • unknown's avatar
      configure.in: · 9cee9f69
      unknown authored
        Increment from 4.0.23 to 4.0.24
      
      
      configure.in:
        Increment from 4.0.23 to 4.0.24
      9cee9f69
  7. 18 Dec, 2004 5 commits
  8. 16 Dec, 2004 4 commits
  9. 13 Dec, 2004 1 commit
    • unknown's avatar
      dict0load.c: · f40f838f
      unknown authored
        dict_load_table(): detect the new table format of MySQL 5.0.3
      
      
      innobase/dict/dict0load.c:
        dict_load_table(): detect the new table format of MySQL 5.0.3
      f40f838f
  10. 11 Dec, 2004 3 commits
    • unknown's avatar
      Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-4.0 · b18e8c92
      unknown authored
      into mysql.com:/dbdata/psergey/mysql-4.0-bug6976
      
      
      b18e8c92
    • unknown's avatar
      Fix for BUG#6976: · b5c119e7
      unknown authored
      In Item_ref::Item_ref set maybe_null (and other fields fix_fields sets) to be the 
      same as in (*ref), because Item_ref::fix_fields() will not be called.  Previously 
      maybe_null was 0 always and this produced a bogus state where 
      maybe_null==0 && is_null() == true 
      which broke evaluation for some upper-level Items, like AND and OR.
      
      
      mysql-test/r/group_by.result:
        Test for BUG#6976
      mysql-test/t/group_by.test:
        Test for BUG#6976
      sql/item.cc:
        Comment added
      sql/item.h:
        Fix for BUG#6976:
          in Item_ref::Item_ref(Item**...) fix all fields because fix_fields() will not be called.
      b5c119e7
    • unknown's avatar
      Fix for BUG#5837 - attempt 3. · 8e4251dd
      unknown authored
        Call mark_as_null_row in join_read_const and join_read_system.
      
      
      mysql-test/r/multi_update.result:
        Testcase for BUG#5837
      mysql-test/t/multi_update.test:
        Testcase for BUG#5837
      sql/table.h:
        Added comments
      8e4251dd
  11. 10 Dec, 2004 2 commits
    • unknown's avatar
      Merge marko@bk-internal.mysql.com:/home/bk/mysql-4.0 · 96a927b5
      unknown authored
      into hundin.mysql.fi:/home/marko/k/mysql-4.0
      
      
      96a927b5
    • unknown's avatar
      dict0dict.h, dict0dict.c, ha_innodb.cc: · c486461e
      unknown authored
        Fix for the 0xA0 character problem in the InnoDB FOREIGN KEY parser: if my_isspace() treats 0xA0 as space, then let InnoDB do the same; this might break some multi-byte charset id's, though for big5, ujis, sjis this seems not to change the current behavior (I checked the tables in /share/charsets); this fix must NOT be merged to 4.1 because in 4.1 everything is in UTF-8
      
      
      sql/ha_innodb.cc:
        Fix for the 0xA0 character problem in the InnoDB FOREIGN KEY parser: if my_isspace() treats 0xA0 as space, then let InnoDB do the same; this might break some multi-byte charset id's, though for big5, ujis, sjis this seems not to change the current behavior (I checked the tables in /share/charsets); this fix must NOT be merged to 4.1 because in 4.1 everything is in UTF-8
      innobase/dict/dict0dict.c:
        Fix for the 0xA0 character problem in the InnoDB FOREIGN KEY parser: if my_isspace() treats 0xA0 as space, then let InnoDB do the same; this might break some multi-byte charset id's, though for big5, ujis, sjis this seems not to change the current behavior (I checked the tables in /share/charsets); this fix must NOT be merged to 4.1 because in 4.1 everything is in UTF-8
      innobase/include/dict0dict.h:
        Fix for the 0xA0 character problem in the InnoDB FOREIGN KEY parser: if my_isspace() treats 0xA0 as space, then let InnoDB do the same; this might break some multi-byte charset id's, though for big5, ujis, sjis this seems not to change the current behavior (I checked the tables in /share/charsets); this fix must NOT be merged to 4.1 because in 4.1 everything is in UTF-8
      c486461e
  12. 09 Dec, 2004 1 commit
    • unknown's avatar
      srv0srv.c: · f4f4e636
      unknown authored
        srv_printf_innodb_monitor(): Removed extraneous rewind() call.
        The caller of this function calls rewind() if necessary.
        In this way, we avoid rewind()ing stderr in
        srv_lock_timeout_and_monitor_thread().
      
      
      innobase/srv/srv0srv.c:
        srv_printf_innodb_monitor(): Removed extraneous rewind() call.
        The caller of this function calls rewind() if necessary.
        In this way, we avoid rewind()ing stderr in
        srv_lock_timeout_and_monitor_thread().
      f4f4e636
  13. 07 Dec, 2004 2 commits
  14. 02 Dec, 2004 2 commits
    • unknown's avatar
      Prevent adding 'CREATE TABLE .. SELECT' query to the binary log when the · 9286d1c1
      unknown authored
      insertion of new records partially failed. It would get logged because of the
      logic to log a partially-failed 'INSERT ... SELECT' (which can't be rolled back
      in non-transactional tables), but 'CREATE TABLE ... SELECT' is always rolled
      back on failure, even for non-transactional tables. (Bug #6682)
      (Original fix reimplemented after review by Serg and Guilhem.)
      
      
      mysql-test/t/insert_select.test:
        Add test case for Bug #6682
      mysql-test/r/insert_select.result:
        Add results for test case for Bug #6682
      sql/sql_table.cc:
        moved tmp_disable_binlog() and reenable_binlog macros to sql/sql_class.h
      sql/sql_insert.cc:
        disable binlog during call to super's ::send_error in select_create class
      sql/sql_class.h:
        add select_create::send_error()
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      9286d1c1
    • unknown's avatar
      A fix (bug #6878: Crash with engine=memory). · a845e882
      unknown authored
      
      heap/hp_open.c:
        A fix (bug #6878: Crash with engine=memory).
        Record length should be >= sizeof(byte*).
      a845e882
  15. 30 Nov, 2004 1 commit
    • unknown's avatar
      two-line fix for BUG#6732 "FLUSH TABLES WITH READ LOCK + COMMIT makes next... · 352ad815
      unknown authored
      two-line fix for BUG#6732 "FLUSH TABLES WITH READ LOCK + COMMIT makes next FLUSH...LOCK hang forever"
      (originally reported as "second run of innobackup hangs forever and can even hang server").
      Plus testcase for the bugfix and comments about global read locks.
      
      
      mysql-test/r/flush_block_commit.result:
        result update
      mysql-test/t/flush_block_commit.test:
        testing bugfix (originally: second run of innobackup hangs)
      sql/lock.cc:
        When we are in start_waiting_global_read_lock(), if we ourselves have
        the global read lock, there is nothing to start. This makes a pair with how 
        wait_if_global_read_lock() behaves when we ourselves have the global read lock.
        Previously, start_waiting_global_read_lock() decremented protect... whereas wait_if_global_read_lock()
        hadn't incremented it => very wrong => hangs.
        Descriptive comments on how global read lock works.
      352ad815
  16. 26 Nov, 2004 2 commits
    • unknown's avatar
      srv0srv.c: · 59abcd44
      unknown authored
        srv_lock_timeout_and_monitor_thread(): write to srv_monitor_file
        only if --innodb_status_file=1
      
      
      innobase/srv/srv0srv.c:
        srv_lock_timeout_and_monitor_thread(): write to srv_monitor_file
        only if --innodb_status_file=1
      59abcd44
    • unknown's avatar
      Fixes while reviewing code · 60af9206
      unknown authored
      (Cleanups and better bug fixes)
      
      
      mysql-test/r/select.result:
        Fixed test after wrong merge
      mysql-test/t/select.test:
        Fixed test after wrong merge
      scripts/mysql_fix_privilege_tables.sh:
        Don't read defaults files
      sql/item_cmpfunc.cc:
        Fix wrong value for not_null_tables_cache
      sql/item_cmpfunc.h:
        Remove wrong patch (flags are set in fix_length_and_dec())
      sql/item_func.h:
        Fix wrong value for not_null_tables_cache
      sql/slave.cc:
        Fixed indentation
      60af9206
  17. 25 Nov, 2004 4 commits
    • unknown's avatar
      Merge mysql.com:/home/timka/mysql/src/4.0-virgin · fecd27a1
      unknown authored
      into mysql.com:/home/timka/mysql/src/4.0-master
      
      
      BitKeeper/etc/logging_ok:
        auto-union
      fecd27a1
    • unknown's avatar
      Merge for BUG#3759 which was missing from the main tree for some reason. · 0dcb55f4
      unknown authored
      
      BitKeeper/etc/logging_ok:
        auto-union
      sql/item_cmpfunc.h:
        Auto merged
      mysql-test/r/select.result:
        Merge for BUG#3759
      mysql-test/t/select.test:
        Merge for BUG#3759
      0dcb55f4
    • unknown's avatar
      Merge mysql.com:/space/bkroot/mysql-4.0 · 467c4814
      unknown authored
      into mysql.com:/space/bk/b6148-mysql-4.0
      
      
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      467c4814
    • unknown's avatar
      Fix for Bug#6148. Only rewind read position in binary log when the · 6f2cf12a
      unknown authored
      slave SQL thread is started.
      
      
      sql/slave.cc:
        Adding threads to init as parameter to init_master_info.
        Only rewind read position when starting SQL thread.
      sql/slave.h:
        Adding threads to init as parameter to init_master_info.
        Only rewind read position when starting SQL thread.
      sql/sql_repl.cc:
        Adding threads to init as parameter to init_master_info.
        Only rewind read position when starting SQL thread.
      sql/repl_failsafe.cc:
        Adding threads to init as parameter to init_master_info.
        Only rewind read position when starting SQL thread.
      6f2cf12a
  18. 24 Nov, 2004 1 commit
  19. 23 Nov, 2004 1 commit
    • unknown's avatar
      Change "Do-compile" to make automatic build log analysis easier and · a9aff01e
      unknown authored
      to run the standard tests with "--force" (default, can be switched off).
      
      
      Build-tools/Do-compile:
        1) For an automated log analysis, we need a clear marker in the build log
           whether compile + link succeeded: Write it after successful "make".
        2) Ensure the standard tests are run with "--force" in the default case,
           but allow the old behaviour by an option "--one-error".
        3) Correct a typing error in the usage message.
      a9aff01e
  20. 22 Nov, 2004 1 commit