1. 25 Jun, 2007 1 commit
    • unknown's avatar
      Bug #29154: LOCK TABLES is not atomic when >1 InnoDB tables are locked · 6a1657ae
      unknown authored
        LOCK TABLES takes a list of tables to lock. It may lock several 
        tables successfully and then encounter a tables that it can't lock, 
        e.g. because it's locked. In such case it needs to undo the locks on
        the already locked tables. And it does that. But it has also notified
        the relevant table storage engine handlers that they should lock.
        The only reliable way to ensure that the table handlers will give up
        their locks is to end the transaction. This is what UNLOCK TABLE 
        does : it ends the transaction if there were locked tables by LOCK 
        tables.
        It is possible to end the transaction when the lock fails in 
        LOCK TABLES because LOCK TABLES ends the transaction at its start 
        already. 
        Fixed by ending (again) the transaction when LOCK TABLES fails to
        lock a table.
      
      
      mysql-test/r/innodb_mysql.result:
        Bug #29154: test case
      mysql-test/t/innodb_mysql.test:
        Bug #29154: test case
      sql/sql_parse.cc:
        Bug #29154: end the trasaction at a failing 
        LOCK TABLES so the handler can free its locks.
      6a1657ae
  2. 21 Jun, 2007 1 commit
  3. 20 Jun, 2007 8 commits
    • unknown's avatar
      Fixed bug #28293. · 86b04e8b
      unknown authored
      Occasionally mysqlbinlog --hexdump failed with error:
        ERROR 1064 (42000) at line ...: You have an error in your
        SQL syntax; check the manual that corresponds to your MySQL
        server version for the right syntax to use near
        'Query thread_id=... exec_time=... error_code=...
      
      When the length of hexadecimal dump of binlog header was
      divisible by 16, commentary sign '#' after header was lost.
      The Log_event::print_header function has been modified to always
      finish hexadecimal binlog header with "\n# ".
      
      
      sql/log_event.cc:
        Fixed bug #28293.
        The Log_event::print_header function has been modified to always
        finish hexadecimal binlog header with "\n# ".
      mysql-test/r/mysqlbinlog.result:
        Updated test case for bug #28293.
      mysql-test/t/mysqlbinlog.test:
        Updated test case for bug #28293.
      86b04e8b
    • unknown's avatar
      port of the fix for bug 19116 4.1-opt -> 5.0-opt · 0186f295
      unknown authored
      0186f295
    • unknown's avatar
      Merge magare.gmz:/home/kgeorge/mysql/work/B29116-4.1-opt · 2d9ca378
      unknown authored
      into  magare.gmz:/home/kgeorge/mysql/work/B29116-5.0-opt
      
      
      mysql-test/t/rpl_change_master.test:
        Auto merged
      2d9ca378
    • unknown's avatar
      Merge gleb.loc:/home/uchum/work/bk/5.0-opt-28898 · 77f3c55c
      unknown authored
      into  gleb.loc:/home/uchum/work/bk/5.0-opt
      
      77f3c55c
    • unknown's avatar
      metadata.test, metadata.result: · 39e7beeb
      unknown authored
        Updated test case for bug #28898. Additional cleanup.
      
      
      mysql-test/t/metadata.test:
        Updated test case for bug #28898. Additional cleanup.
      mysql-test/r/metadata.result:
        Updated test case for bug #28898. Additional cleanup.
      39e7beeb
    • unknown's avatar
      Bug #28839 Errors in strict mode silently stop SQL thread if --slave-skip-errors exists. · e3eb0750
      unknown authored
      slave_sql thread calls thd->clear_error() to force error to be ignored,
      though this method didn't clear thd->killed state, what causes
      slave_sql thread to stop.
      
      clear thd->killed state if we ignore an error
      
      
      mysql-test/r/rpl_skip_error.result:
        Bug #28839 Errors in strict mode silently stop SQL thread if --slave-skip-errors exists.
        
        test result
      mysql-test/t/rpl_skip_error.test:
        Bug #28839 Errors in strict mode silently stop SQL thread if --slave-skip-errors exists.
        
        test case
      sql/log_event.cc:
        Bug #28839 Errors in strict mode silently stop SQL thread if --slave-skip-errors exists.
        
        clear thd->killed state if we ignore the error
      e3eb0750
    • unknown's avatar
      Merge gleb.loc:/home/uchum/work/bk/5.0-opt-28898 · 0049168c
      unknown authored
      into  gleb.loc:/home/uchum/work/bk/5.0-opt
      
      
      sql/sql_select.cc:
        Auto merged
      0049168c
    • unknown's avatar
      Fixed bug #28898. · e5c99105
      unknown authored
      For a join query with GROUP BY and/or ORDER BY and a view reference
      in the FROM list the metadata erroneously showed empty table aliases
      and database names for the view columns.
      
      
      
      sql/item.h:
        Fixed bug #28898.
        Body of Item_ref::get_tmp_table_item method has been moved
        to item.cc file.
      mysql-test/t/metadata.test:
        Updated test case for bug #28898.
      sql/item.cc:
        Fixed bug #28898.
        The Item_ref::get_tmp_table_item method has been modified
        to copy pointers to the table alias and database name to the new
        Item_field object created for a field stored in the temporary
        table.
      mysql-test/r/metadata.result:
        Updated test case for bug #28898.
      sql/sql_select.cc:
        Fixed bug #28898.
        The change_to_use_tmp_fields function has been modified to
        to copy pointers to the table alias and database name from
        the Item_ref objects to the new Item_field objects created
        for fields stored in the temporary table.
      e5c99105
  4. 19 Jun, 2007 3 commits
  5. 18 Jun, 2007 3 commits
  6. 17 Jun, 2007 10 commits
  7. 16 Jun, 2007 6 commits
    • unknown's avatar
      bigint.test: · 2cdd8975
      unknown authored
        Updated test case for bug #28625.
      
      
      mysql-test/t/bigint.test:
        Updated test case for bug #28625.
      2cdd8975
    • unknown's avatar
      Merge chilla.local:/home/mydev/mysql-5.0-amain · fefa6844
      unknown authored
      into  chilla.local:/home/mydev/mysql-5.0-axmrg
      
      
      configure.in:
        Auto merged
      sql/mysqld.cc:
        Auto merged
      fefa6844
    • unknown's avatar
      Merge gleb.loc:/home/uchum/work/bk/5.0-opt · d10e905c
      unknown authored
      into  gleb.loc:/home/uchum/work/bk/5.0-opt-28625
      
      
      sql/item_func.cc:
        Auto merged
      d10e905c
    • unknown's avatar
      Fixed bug #28625: · c20c7cac
      unknown authored
      DECIMAL column was used instead of BIGINT for the minimal possible
      BIGINT (-9223372036854775808).
      
      The Item_func_neg::fix_length_and_dec has been adjusted to
      to inherit the type of the argument in the case when it's an 
      Item_int object whose value is equal to LONGLONG_MIN.
      
      
      sql/item_func.cc:
        Fixed bug #28625.
        The Item_func_neg::fix_length_and_dec has been adjusted to
        to inherit the type of the argument in the case when it's an 
        Item_int object whose value is equal to LONGLONG_MIN.
      mysql-test/t/bigint.test:
        Added test result for bug #28625.
      mysql-test/r/bigint.result:
        Added test case for bug #28625.
      c20c7cac
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.0-maint · aadf7cd5
      unknown authored
      into  pippilotta.erinye.com:/shared/home/df/mysql/build/mysql-5.0-build
      
      
      mysql-test/mysql-test-run.pl:
        Auto merged
      mysql-test/t/mysqldump.test:
        Auto merged
      aadf7cd5
    • unknown's avatar
      Merge pippilotta.erinye.com:/shared/home/df/mysql/build/mysql-5.0-build-work · 166ea111
      unknown authored
      into  pippilotta.erinye.com:/shared/home/df/mysql/build/mysql-5.0-build
      
      
      client/CMakeLists.txt:
        merge fix
      166ea111
  8. 15 Jun, 2007 8 commits