1. 15 Jun, 2006 1 commit
  2. 07 Jun, 2006 1 commit
    • unknown's avatar
      BUG#12982 - LOAD DATA fails without any error for big files with big · dc934844
      unknown authored
                  read buffer
      Setting read buffer to values greater than SSIZE_MAX results in
      unexpected behavior.
      
      According to read(2) manual:
      If count is greater than SSIZE_MAX, the result is unspecified.
      
      Set upper limit for read_buffer_size and read_rnd_buffer_size to
      SSIZE_MAX.
      
      
      include/my_global.h:
        Define SSIZE_MAX if not defined.
      sql/mysqld.cc:
        Set upper limit for read_buffer_size and read_rnd_buffer_size to
        SSIZE_MAX.
      dc934844
  3. 31 May, 2006 3 commits
    • unknown's avatar
      Merge mysql.com:/home/mydev/mysql-5.0 · cc6a2505
      unknown authored
      into  mysql.com:/home/mydev/mysql-5.0-bug19604
      
      cc6a2505
    • unknown's avatar
      Bug#19604 - CHECK TABLE with concurrent INSERT can reset auto_increment · 556defaf
      unknown authored
      CHECK TABLE did temporarily clear the auto_increment value.
      It runs with a read lock, allowing other readers and
      conurrent INSERTs. The latter could grab the wrong value
      in this moment.
      
      CHECK TABLE does no longer modify the auto_increment value.
      Not even for a short moment.
      
      
      myisam/mi_check.c:
        Bug#19604 - CHECK TABLE with concurrent INSERT can reset auto_increment
        In chk_key() and update_auto_increment_key() in the repair_only
        case, do not touch info->s->state.auto_increment. Especially
        chk_key() can be called from CHECK TABLE with a read lock.
        Concurrent inserts could grab a temporarily changed value.
        Added minor style fixes.
      myisam/mi_key.c:
        Bug#19604 - CHECK TABLE with concurrent INSERT can reset auto_increment
        Changed update_auto_increment() to retrieve_auto_increment()
        to reflect that it does not change the auto_increment by
        itself any more. This must now be done externally if needed.
      myisam/mi_update.c:
        Bug#19604 - CHECK TABLE with concurrent INSERT can reset auto_increment
        Added explicit update of info->s->state.auto_increment
        after the change from update_auto_increment() to
        retrieve_auto_increment().
      myisam/mi_write.c:
        Bug#19604 - CHECK TABLE with concurrent INSERT can reset auto_increment
        Added explicit update of info->s->state.auto_increment
        after the change from update_auto_increment() to
        retrieve_auto_increment().
      myisam/myisamdef.h:
        Bug#19604 - CHECK TABLE with concurrent INSERT can reset auto_increment
        Changed update_auto_increment() to retrieve_auto_increment()
        to reflect that it does not change the auto_increment by
        itself any more. This must now be done externally if needed.
      556defaf
    • unknown's avatar
      Bug#19648 · 4d079a5c
      unknown authored
        "Merge table does not work with bit types"
         MERGE should have HA_CAN_BIT_FIELD feature bit set or else table row is
         formatted incorrectly.
      
      
      mysql-test/r/merge.result:
        Bug#19648
          Test for fix
      mysql-test/t/merge.test:
        Bug#19648
          Test for fix
      sql/ha_myisammrg.h:
        Bug#19648
          Must have HA_CAN_BIT_FIELD for BIT type support
      4d079a5c
  4. 29 May, 2006 1 commit
    • unknown's avatar
      Bug#19815 - CREATE/RENAME/DROP DATABASE can deadlock on a global read lock · e1fb901b
      unknown authored
      The order of acquiring LOCK_mysql_create_db
      and wait_if_global_read_lock() was wrong. It could happen
      that a thread held LOCK_mysql_create_db while waiting for
      the global read lock to be released. The thread with the
      global read lock could try to administrate a database too.
      It would first try to lock LOCK_mysql_create_db and hang...
      
      The check if the current thread has the global read lock
      is done in wait_if_global_read_lock(), which could not be
      reached because of the hang in LOCK_mysql_create_db.
      
      Now I exchanged the order of acquiring LOCK_mysql_create_db
      and wait_if_global_read_lock(). This makes 
      wait_if_global_read_lock() fail with an error message for
      the thread with the global read lock. No deadlock happens.
      
      
      mysql-test/r/lock_multi.result:
        Bug#19815 - CREATE/RENAME/DROP DATABASE can deadlock on a global read lock
        The test result
      mysql-test/t/lock_multi.test:
        Bug#19815 - CREATE/RENAME/DROP DATABASE can deadlock on a global read lock
        The test case
      sql/sql_db.cc:
        Bug#19815 - CREATE/RENAME/DROP DATABASE can deadlock on a global read lock
        Exchanged the order of acquiring LOCK_mysql_create_db
        and wait_if_global_read_lock().
      e1fb901b
  5. 18 May, 2006 1 commit
  6. 10 May, 2006 1 commit
    • unknown's avatar
      BUG#18233 - Memory tables INDEX USING HASH (a,b) returns 1 row on · 43a9d2cc
      unknown authored
                  SELECT WHERE a= AND b=
      
      Selecting data from memory table with varchar column and hash index over it
      returns only first row matched.
      
      Problem was that key length calculation for varchar columns didn't include
      number of bytes to store length.
      
      Fixed key length for varchar fields to include number of bytes to store length.
      
      
      heap/hp_create.c:
        Fixed key length for varchar fields to include number of bytes to store length.
      mysql-test/r/heap.result:
        Testcase for BUG#18233.
      mysql-test/t/heap.test:
        Testcase for BUG#18233.
      43a9d2cc
  7. 09 May, 2006 8 commits
  8. 08 May, 2006 5 commits
    • unknown's avatar
      No commit message · f0d9ac5e
      unknown authored
      No commit message
      f0d9ac5e
    • unknown's avatar
      Merge mysql.com:/Users/kent/mysql/bk/mysql-5.0-release · 86443c81
      unknown authored
      into mysql.com:/Users/kent/mysql/bk/mysql-5.0-new
      
      
      configure.in:
        Auto merged
      86443c81
    • unknown's avatar
      Remove valgrind and compiler warnings · 808df3bd
      unknown authored
      Add function 'vio_end' that will cleanup resources allocated by vio and the components it uses.
      
      
      include/violite.h:
        Import patch warnings.patch
      libmysql/libmysql.c:
        Import patch warnings.patch
      sql/mysqld.cc:
        Import patch warnings.patch
      vio/test-ssl.c:
        Import patch warnings.patch
      vio/test-sslclient.c:
        Import patch warnings.patch
      vio/test-sslserver.c:
        Import patch warnings.patch
      vio/vio.c:
        Import patch warnings.patch
      vio/viosslfactories.c:
        Import patch warnings.patch
      808df3bd
    • unknown's avatar
      Merge neptunus.(none):/home/msvensson/mysql/my50-maint-bug18474 · ed8963d6
      unknown authored
      into  neptunus.(none):/home/msvensson/mysql/mysql-5.0-maint
      
      ed8963d6
    • unknown's avatar
      Merge 192.168.0.20:mysql/my50-maint-yassl · 14f90b29
      unknown authored
      into  neptunus.(none):/home/msvensson/mysql/mysql-5.0-maint
      
      
      extra/yassl/src/ssl.cpp:
        Auto merged
      extra/yassl/taocrypt/src/make.bat:
        Auto merged
      extra/yassl/testsuite/test.hpp:
        Auto merged
      14f90b29
  9. 07 May, 2006 10 commits
    • unknown's avatar
      Merge ibabaev@bk-internal.mysql.com:/home/bk/mysql-5.0 · 0eccfdd2
      unknown authored
      into  rurik.mysql.com:/home/igor/mysql-5.0
      
      
      mysql-test/r/rpl_user_variables.result:
        Auto merged
      sql/item_func.cc:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      mysql-test/t/rpl_user_variables.test:
        Manual merge
      0eccfdd2
    • unknown's avatar
      Post-merge fixes. · 8b9596ac
      unknown authored
      8b9596ac
    • unknown's avatar
      Merge rurik.mysql.com:/home/igor/dev/mysql-4.1-0 · 02110c8f
      unknown authored
      into  rurik.mysql.com:/home/igor/dev/mysql-5.0-0
      
      
      mysql-test/r/having.result:
        Auto merged
      mysql-test/t/having.test:
        Auto merged
      sql/item_func.cc:
        Auto merged
      sql/sql_lex.h:
        Auto merged
      mysql-test/r/rpl_user_variables.result:
        Manual merge
      mysql-test/t/rpl_user_variables.test:
        Manual merge
      sql/sql_lex.cc:
        Manual merge
      sql/sql_prepare.cc:
        Manual merge
      sql/sql_select.cc:
        Manual merge
      02110c8f
    • unknown's avatar
      Merge ibabaev@bk-internal.mysql.com:/home/bk/mysql-4.1 · 9c4d5e70
      unknown authored
      into  rurik.mysql.com:/home/igor/mysql-4.1
      
      9c4d5e70
    • unknown's avatar
      Merge aelkin@bk-internal.mysql.com:/home/bk/mysql-5.0 · b245f68e
      unknown authored
      into  mysql.com:/usr_rh9/home/elkin.rh9/MySQL/Merge/5.0-bug19136
      
      
      sql/sql_select.cc:
        Auto merged
      b245f68e
    • unknown's avatar
      Bug#19136: Crashing log-bin and uninitialized user variables in a derived table · a423451f
      unknown authored
      recalculating results
      
      
      mysql-test/r/rpl_user_variables.result:
        fixing results
      a423451f
    • unknown's avatar
    • unknown's avatar
      Merge mysql.com:/usr_rh9/home/elkin.rh9/4.1 · ddb829c0
      unknown authored
      into  mysql.com:/usr_rh9/home/elkin.rh9/MySQL/Merge/5.0-bug19136
      
      
      sql/item_func.cc:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      mysql-test/r/rpl_user_variables.result:
        manual merge use local
      mysql-test/t/rpl_user_variables.test:
        manual merge use version 5.0's "show binlog events from 98"
      ddb829c0
    • unknown's avatar
      Merge mysql.com:/usr_rh9/home/elkin.rh9/MySQL/BARE/4.1 · 9bc4cc75
      unknown authored
      into  mysql.com:/usr_rh9/home/elkin.rh9/MySQL/FIXES/4.1-bug19136_unass_user_var
      
      
      sql/item_func.cc:
        Auto merged
      9bc4cc75
    • unknown's avatar
      Fixed bug #14927. · 39c73589
      unknown authored
      A query with a group by and having clauses could return a wrong
      result set if the having condition contained a constant conjunct 
      evaluated to FALSE.
      It happened because the pushdown condition for table with
      grouping columns lost its constant conjuncts.
      Pushdown conditions are always built by the function make_cond_for_table
      that ignores constant conjuncts. This is apparently not correct when
      constant false conjuncts are present.
      
      
      
      mysql-test/r/having.result:
        Added a test case for bug #14927.
      mysql-test/t/having.test:
        Added a test case for bug #14927.
      sql/sql_lex.cc:
        Fixed bug #14927.
        Initialized fields for having conditions in  st_select_lex::init_query().
      sql/sql_lex.h:
        Fixed bug #14927.
        Added a field to restore having condititions for execution in SP and PS.
      sql/sql_prepare.cc:
        Fixed bug #14927.
        Added code to restore havinf conditions for execution in SP and PS.
      sql/sql_select.cc:
        Fixed bug #14927.
        Performed evaluation of constant expressions in having clauses.
        If the having condition contains a constant conjunct that is always false
        an empty result set is returned after the optimization phase.
        In this case the corresponding EXPLAIN command now returns 
        "Impossible HAVING" in the last column.
      39c73589
  10. 06 May, 2006 9 commits