1. 25 Jun, 2007 1 commit
    • unknown's avatar
      Bug #29154: LOCK TABLES is not atomic when >1 InnoDB tables are locked · 39459397
      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.
      39459397
  2. 21 Jun, 2007 1 commit
  3. 20 Jun, 2007 8 commits
    • unknown's avatar
      Fixed bug #28293. · b5eb3fcb
      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.
      b5eb3fcb
    • unknown's avatar
      port of the fix for bug 19116 4.1-opt -> 5.0-opt · d8512831
      unknown authored
      d8512831
    • unknown's avatar
      Merge magare.gmz:/home/kgeorge/mysql/work/B29116-4.1-opt · e0ab3523
      unknown authored
      into  magare.gmz:/home/kgeorge/mysql/work/B29116-5.0-opt
      
      
      mysql-test/t/rpl_change_master.test:
        Auto merged
      e0ab3523
    • unknown's avatar
      Merge gleb.loc:/home/uchum/work/bk/5.0-opt-28898 · 4310ceb0
      unknown authored
      into  gleb.loc:/home/uchum/work/bk/5.0-opt
      
      
      4310ceb0
    • unknown's avatar
      metadata.test, metadata.result: · 8e35de2a
      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.
      8e35de2a
    • unknown's avatar
      Bug #28839 Errors in strict mode silently stop SQL thread if --slave-skip-errors exists. · d5cc204e
      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
      d5cc204e
    • unknown's avatar
      Merge gleb.loc:/home/uchum/work/bk/5.0-opt-28898 · e2aa6ee1
      unknown authored
      into  gleb.loc:/home/uchum/work/bk/5.0-opt
      
      
      sql/sql_select.cc:
        Auto merged
      e2aa6ee1
    • unknown's avatar
      Fixed bug #28898. · e855bf33
      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.
      e855bf33
  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: · 67988a75
      unknown authored
        Updated test case for bug #28625.
      
      
      mysql-test/t/bigint.test:
        Updated test case for bug #28625.
      67988a75
    • unknown's avatar
      Merge chilla.local:/home/mydev/mysql-5.0-amain · 3e2e6ea9
      unknown authored
      into  chilla.local:/home/mydev/mysql-5.0-axmrg
      
      
      configure.in:
        Auto merged
      sql/mysqld.cc:
        Auto merged
      3e2e6ea9
    • unknown's avatar
      Merge gleb.loc:/home/uchum/work/bk/5.0-opt · b1dc106b
      unknown authored
      into  gleb.loc:/home/uchum/work/bk/5.0-opt-28625
      
      
      sql/item_func.cc:
        Auto merged
      b1dc106b
    • unknown's avatar
      Fixed bug #28625: · 1b9f594f
      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.
      1b9f594f
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.0-maint · 2552a16e
      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
      2552a16e
    • unknown's avatar
      Merge pippilotta.erinye.com:/shared/home/df/mysql/build/mysql-5.0-build-work · 910d8ea1
      unknown authored
      into  pippilotta.erinye.com:/shared/home/df/mysql/build/mysql-5.0-build
      
      
      client/CMakeLists.txt:
        merge fix
      910d8ea1
  8. 15 Jun, 2007 8 commits