1. 13 Mar, 2008 4 commits
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.1-runtime · bad61329
      unknown authored
      into  mysql.com:/Users/davi/mysql/mysql-5.1-runtime
      
      bad61329
    • unknown's avatar
      Bug#34891 sp_notembedded.test fails sporadically · 77a0a8ac
      unknown authored
      The problem is that since MyISAM's concurrent_insert is on by
      default some concurrent SELECT statements might not see changes
      made by INSERT statements in other connections, even if the
      INSERT statement has returned.
      
      The solution is to disable concurrent_insert so that INSERT
      statements returns after the data is actually visible to other
      statements.
      
      
      mysql-test/r/flush_read_lock_kill.result:
        Restore old value of @@global.concurrent_insert
      mysql-test/r/kill.result:
        Restore old value of @@global.concurrent_insert
      mysql-test/r/sp_notembedded.result:
        Update test case result
      mysql-test/t/flush_read_lock_kill.test:
        Restore old value of @@global.concurrent_insert so it
        doesn't affect other tests.
      mysql-test/t/kill.test:
        Restore old value of @@global.concurrent_insert so it
        doesn't affect other tests.
      mysql-test/t/sp_notembedded.test:
        Disable and restore concurrent_insert value at the end of the
        test case. The test case for Bug 29936 requires that the inserted
        rows need to be visible before a SELECT statement is queued in
        another connection.
        
        Remove sleep at the start of the test, it's not necessary to log
        the result of the processlist command, showing the warnings has
        the same end result.
      77a0a8ac
    • unknown's avatar
      Merge quad.:/mnt/raid/alik/MySQL/devel/5.1-rt · 84f7d81c
      unknown authored
      into  quad.:/mnt/raid/alik/MySQL/devel/bug-35074/5.1-rt-bug35074
      
      84f7d81c
    • unknown's avatar
      Fix for Bug#35074: max_used_connections is not correct. · c8aedb02
      unknown authored
      The problem was that number of threads was used to calculate
      max_used_connections.
      
      The fix is to use number of active connections.
      
      
      mysql-test/r/connect.result:
        Update result file.
      mysql-test/t/connect.test:
        - Add a test case for Bug#35074: max_used_connections is not correct;
        - Make a test case for Bug#33507 more stable.
      sql/mysqld.cc:
        Use number of connections insetad of threads
        to calculate max_used_connections.
      c8aedb02
  2. 12 Mar, 2008 6 commits
    • unknown's avatar
      Fix manual merge. · 978b6ca1
      unknown authored
      978b6ca1
    • unknown's avatar
      Fix for Bug#33507: Event scheduler creates more threads · f8d0ffeb
      unknown authored
      than max_connections -- which results in user lockout.
      
      The problem was that the variable thread_count that contains
      the number of active threads was interpreted as a number of
      active connections.
      
      The fix is to introduce a new counter for active connections.
      
      
      mysql-test/r/connect.result:
        A test case for Bug#33507: Event scheduler creates more threads
        than max_connections -- which results in user lockout.
      mysql-test/t/connect.test:
        A test case for Bug#33507: Event scheduler creates more threads
        than max_connections -- which results in user lockout.
      sql/mysql_priv.h:
        1. Polishing: login_connection() and end_connection() need not
           to be public.
        
        2. Introduce connection_count -- a variable to contain the number
           of active connections. It is protected by LOCK_connection_count.
      sql/mysqld.cc:
        Use connection_count to count active connections.
      sql/sql_connect.cc:
        1. Use connection_count to count active connections.
        2. Make login_connection(), end_connection() private for the module
        as they had to be.
      f8d0ffeb
    • unknown's avatar
      Fix manual merge. · 17e198e8
      unknown authored
      17e198e8
    • unknown's avatar
      Merge quad.:/mnt/raid/alik/MySQL/devel/5.0-rt · e4f69a4c
      unknown authored
      into  quad.:/mnt/raid/alik/MySQL/devel/5.1-rt-merged
      
      
      sql/sql_delete.cc:
        Manually merged.
      e4f69a4c
    • unknown's avatar
      A fix for Bug#34643: TRUNCATE crash if trigger and foreign key. · 0dc8565e
      unknown authored
        
      In cases when TRUNCATE was executed by invoking mysql_delete() rather
      than by table recreation (for example, when TRUNCATE was issued on
      InnoDB table with is referenced by foreign key) triggers were invoked.
      In debug builds this also led to crash because of an assertion, which
      assumes that some preliminary actions take place before trigger 
      invocation, which doesn't happen in case of TRUNCATE.
      
      The fix is not to execute triggers in mysql_delete() when this
      function is used by TRUNCATE.
      
      
      mysql-test/r/trigger-trans.result:
        Update result file.
      mysql-test/t/trigger-trans.test:
        A test case for Bug#34643: TRUNCATE crash if trigger and foreign key.
      sql/sql_delete.cc:
        Do not process triggers in TRUNCATE.
      0dc8565e
    • unknown's avatar
      Merge quad.:/mnt/raid/alik/MySQL/devel/5.0-rt · 418f328e
      unknown authored
      into  quad.:/mnt/raid/alik/MySQL/devel/5.1-rt
      
      
      tests/mysql_client_test.c:
        Manually merged.
      418f328e
  3. 10 Mar, 2008 1 commit
  4. 06 Mar, 2008 2 commits
    • unknown's avatar
      Bug#35103 mysql_client_test::test_bug29948 causes sporadic failures · 6834e608
      unknown authored
      Disable test case for bug 29948, which is causing sporadically
      failures in other tests inside mysql_client_test.
      
      
      tests/mysql_client_test.c:
        Disable test case.
      6834e608
    • unknown's avatar
      Bug#25132 disabled query cache: Qcache_free_blocks = 1 · 972e4006
      unknown authored
      The initial value of free memory blocks in 0. When the query cache is enabled 
      a new memory block gets allocated and is assigned number 1. The free memory
      block is later split each time query cache memory is allocated for new blocks.
      This means that the free memory block counter won't be reduced to zero when
      the number of allocated blocks are zero, but rather one. To avoid confusion
      this patch changes this behavior so that the free memory block counter is
      reset to zero when the query cache is disabled.
      Note that when the query cache is enabled and resized the free memory block
      counter was still calculated correctly.
      
      
      mysql-test/r/query_cache.result:
        test case
      mysql-test/t/query_cache.test:
        test case
      sql/sql_cache.cc:
        Restore the memory block count to 0 for consistency.
      972e4006
  5. 05 Mar, 2008 1 commit
  6. 04 Mar, 2008 5 commits
  7. 03 Mar, 2008 1 commit
  8. 29 Feb, 2008 2 commits
  9. 28 Feb, 2008 6 commits
    • unknown's avatar
      Merge buzz.(none):/home/davi/mysql-5.0-runtime · 066df249
      unknown authored
      into  buzz.(none):/home/davi/mysql-5.1-runtime
      
      
      mysql-test/r/ps.result:
        Auto merged
      mysql-test/t/limit.test:
        Auto merged
      mysql-test/t/ps.test:
        Auto merged
      sql/item.h:
        Auto merged
      sql/item_func.cc:
        Auto merged
      sql/sql_class.h:
        Auto merged
      sql/item.cc:
        Auto merged
      mysql-test/suite/rpl/r/rpl_user_variables.result:
        Manual merge
      mysql-test/suite/rpl/t/rpl_user_variables.test:
        Manual merge
      sql/sql_yacc.yy:
        Manual merge
      066df249
    • unknown's avatar
      Post-merge fix for Bug 33851. The initialization order of members · bc489574
      unknown authored
      must match the order which they were declared in the class definition. 
      
      
      sql/item.cc:
        Fix initialization order, parameter was the last one declared.
      bc489574
    • unknown's avatar
      Bug#34655 Compile error · ba02c492
      unknown authored
      Rename client_last_error to last_error and client_last_errno to last_errno
      to not break connectors which use the internal net structure for error handling.
      
      
      include/mysql_com.h:
        Rename client_last_error to last_error, client_last_errno to last_errno.
      include/mysql_h.ic:
        Rename client_last_error to last_error, client_last_errno to last_errno.
      libmysql/libmysql.c:
        Rename client_last_error to last_error, client_last_errno to last_errno.
      libmysql/manager.c:
        Rename client_last_error to last_error, client_last_errno to last_errno.
      libmysqld/lib_sql.cc:
        Rename client_last_error to last_error, client_last_errno to last_errno.
      libmysqld/libmysqld.c:
        Rename client_last_error to last_error, client_last_errno to last_errno.
      server-tools/instance-manager/mysql_connection.cc:
        Rename client_last_error to last_error, client_last_errno to last_errno.
      sql/log_event.cc:
        Rename client_last_error to last_error, client_last_errno to last_errno.
      sql-common/client.c:
        Rename client_last_error to last_error, client_last_errno to last_errno.
      sql/log_event_old.cc:
        Rename client_last_error to last_error, client_last_errno to last_errno.
      sql/net_serv.cc:
        Rename client_last_error to last_error, client_last_errno to last_errno.
      sql/repl_failsafe.cc:
        Rename client_last_error to last_error, client_last_errno to last_errno.
      ba02c492
    • unknown's avatar
      Bug#33851 Passing UNSIGNED param to EXECUTE returns ERROR 1210 · 8d4c99e3
      unknown authored
      The problem is that passing anything other than a integer to a limit
      clause in a prepared statement would fail. This limitation was introduced
      to avoid replication problems (e.g: replicating the statement with a
      string argument would cause a parse failure in the slave).
      
      The solution is to convert arguments to the limit clause to a integer
      value and use this converted value when persisting the query to the log.
      
      
      mysql-test/r/limit.result:
        Update test case result.
      mysql-test/r/ps.result:
        Add test case result for Bug#33851
      mysql-test/r/rpl_user_variables.result:
        Test case result for replication of prepared statement with
        limit clause.
      mysql-test/t/limit.test:
        Test parameters to limit clause.
      mysql-test/t/ps.test:
        Add test case for Bug#33851
      mysql-test/t/rpl_user_variables.test:
        Test replication of a parameter which value is converted.
      sql/item.cc:
        Convert value to integer if it's a parameter to a limit clause.
      sql/item.h:
        Flag signal that item is a parameter to a limit clause.
      sql/item_func.cc:
        Const member functions, object is not mutated.
      sql/sql_class.h:
        Const member functions, object is not mutated.
      sql/sql_yacc.yy:
        Flag that item is a parameter to a limit clause.
      8d4c99e3
    • unknown's avatar
      Disable test case due to Bug#34891: sp_notembedded.test fails · 5446adf5
      unknown authored
      sporadically.
      
      
      mysql-test/r/sp_notembedded.result:
        Disable test case.
      mysql-test/t/sp_notembedded.test:
        Disable test case.
      5446adf5
    • unknown's avatar
      Fix for Bug#34852: SHOW OPEN TABLES output is not repeatable · 5e484082
      unknown authored
      (show_check.test fails sporadically).
      
      Fix test case for Bug#12183 to make it stable.
      
      
      mysql-test/r/show_check.result:
        Fix result file.
      mysql-test/t/show_check.test:
        Make test case for Bug#12183 stable.
      5e484082
  10. 27 Feb, 2008 7 commits
  11. 26 Feb, 2008 5 commits
    • unknown's avatar
      Merge quad.:/mnt/raid/alik/MySQL/devel/5.0-rt · d4180856
      unknown authored
      into  quad.:/mnt/raid/alik/MySQL/devel/5.1-rt
      
      
      mysql-test/r/view.result:
        Auto merged
      d4180856
    • unknown's avatar
      Merge quad.:/mnt/raid/alik/MySQL/devel/5.1 · 6f67007c
      unknown authored
      into  quad.:/mnt/raid/alik/MySQL/devel/5.1-rt-merged
      
      
      client/mysqltest.c:
        Auto merged
      mysql-test/r/view.result:
        Auto merged
      sql/ha_ndbcluster.cc:
        Auto merged
      sql/ha_ndbcluster_binlog.cc:
        Auto merged
      sql/handler.cc:
        Auto merged
      sql/log_event.cc:
        Auto merged
      sql/mysql_priv.h:
        Auto merged
      sql/mysqld.cc:
        Auto merged
      sql/set_var.cc:
        Auto merged
      sql/sql_class.cc:
        Auto merged
      sql/sql_connect.cc:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      tests/mysql_client_test.c:
        Auto merged
      mysql-test/suite/rpl_ndb/t/disabled.def:
        Manually merged.
      mysql-test/t/disabled.def:
        Manually merged.
      6f67007c
    • unknown's avatar
      Merge quad.:/mnt/raid/alik/MySQL/devel/5.0 · b67149f5
      unknown authored
      into  quad.:/mnt/raid/alik/MySQL/devel/5.0-rt-merged
      
      
      mysql-test/r/view.result:
        Auto merged
      b67149f5
    • unknown's avatar
      Merge mysql.com:/Users/davi/mysql/bugs/34424-5.1 · bb7585d3
      unknown authored
      into  mysql.com:/Users/davi/mysql/mysql-5.1-runtime
      
      bb7585d3
    • unknown's avatar
      Fix the remaining memory leaks (mysql_client_test). · 7946aafb
      unknown authored
      
      tests/mysql_client_test.c:
        Fix the remaining memory leaks.
      7946aafb