1. 07 Apr, 2007 1 commit
  2. 04 Apr, 2007 1 commit
  3. 03 Apr, 2007 1 commit
    • unknown's avatar
      Fixed bug #27532: wrong results with ORDER/GROUP BY queries containing · 0ee34b1c
      unknown authored
      IN/BETWEEN predicates in sorting expressions.
      Wrong results may occur when the select list contains an expression
      with IN/BETWEEN predicate that differs from a sorting expression by
      an additional NOT only.
       
      Added the method Item_func_opt_neg::eq to compare correctly expressions
      containing [NOT] IN/BETWEEN.
      The eq method inherited from the Item_func returns TRUE when comparing
      'a IN (1,2)' with 'a NOT IN (1,2)' that is not, of course, correct.  
      
      
      mysql-test/r/order_by.result:
        Added a test case for bug #27532.
      mysql-test/t/order_by.test:
        Added a test case for bug #27532.
      sql/item_cmpfunc.cc:
        Fixed bug #27532.
        Added the method Item_func_opt_neg::eq to compare correctly expressions
        containing [NOT] IN/BETWEEN.
        The eq method inherited from the Item_func returns TRUE when comparing
        'a IN (1,2)' with 'a NOT IN (1,2)' that is not, of course, correct.
      sql/item_cmpfunc.h:
        Added the method Item_func_opt_neg::eq to compare correctly expressions
        containing [NOT] IN/BETWEEN.
        The eq method inherited from the Item_func returns TRUE when comparing
        'a IN (1,2)' with 'a NOT IN (1,2)' that is not, of course, correct.
      0ee34b1c
  4. 02 Apr, 2007 2 commits
  5. 31 Mar, 2007 1 commit
  6. 30 Mar, 2007 2 commits
    • unknown's avatar
      BUG#26624: high mem usage (crash) in range optimizer · 080c0c7a
      unknown authored
      Pushbuild fixes: 
       - Make MAX_SEL_ARGS smaller (even 16K records_in_range() calls is 
         more than it makes sense to do in typical cases)
       - Don't call sel_arg->test_use_count() if we've already allocated 
         more than MAX_SEL_ARGs elements. The test will succeed but will take
         too much time for the test suite (and not provide much value).
      
      
      mysql-test/r/range.result:
        BUG#26624: high mem usage (crash) in range optimizer
        Pushbuild fixes: make the test go faster
      mysql-test/t/range.test:
        BUG#26624: high mem usage (crash) in range optimizer
        Pushbuild fixes: make the test go faster
      080c0c7a
    • unknown's avatar
      Merge kboortz@bk-internal.mysql.com:/home/bk/mysql-4.1 · ade8bbf4
      unknown authored
      into  mysql.com:/home/kent/bk/tmp/mysql-4.1-build
      
      
      ade8bbf4
  7. 29 Mar, 2007 4 commits
  8. 28 Mar, 2007 10 commits
    • unknown's avatar
      Bug #26642: create index corrupts table definition in .frm · 0b72b7f0
      unknown authored
      Thanks to Martin Friebe for finding and submitting a fix for this bug!
      
      A table with maximum number of key segments and maximum length key name
      would have a corrupted .frm file, due to an incorrect calculation of the
      complete key length.  Now the key length is computed correctly (I hope) :-)
      
      MyISAM would reject a table with the maximum number of keys and the maximum
      number of key segments in all keys.  It would allow one less than this total
      maximum.  Now MyISAM accepts a table defined with the maximum.  (This is a
      very minor issue.)
      
      
      myisam/mi_open.c:
        change >= to > in a comparison (i.e., error only if key_parts_in_table
        really is greater than MAX_KEY * MAX_KEY_SEG)
      mysql-test/r/create.result:
        Add test results for bug #26642 (create index corrupts table definition in .frm)
      mysql-test/t/create.test:
        Add test case for bug #26642 (create index corrupts table definition in .frm)
      sql/table.cc:
        In create_frm(), fix formula for key_length; it was too small by (keys * 2) bytes
      0b72b7f0
    • unknown's avatar
      Merge mysql.com:/home/psergey/mysql-4.1-bug26625 · edd5a859
      unknown authored
      into  mysql.com:/home/psergey/mysql-4.1-bug26624-r2
      
      
      edd5a859
    • unknown's avatar
      BUG#26624: high mem usage (crash) in range optimizer · 9639eb3d
      unknown authored
      - Added PARAM::alloced_sel_args where we count the # of SEL_ARGs
        created by SEL_ARG tree cloning operations.
      - Made the range analyzer to shortcut and not do any more cloning 
        if we've already created MAX_SEL_ARGS SEL_ARG objects in cloning.
      - Added comments about space complexity of SEL_ARG-graph 
        representation.
      
      
      mysql-test/r/range.result:
        BUG#26624: Testcase
      mysql-test/t/range.test:
        BUG#26624: Testcase
      9639eb3d
    • unknown's avatar
      Delete: sql/mysqld.cc.rej · 60189d35
      unknown authored
      60189d35
    • unknown's avatar
      BUG#26625: crash in range optimizer (out of mem) · 425304f5
      unknown authored
      - Define Sql_alloc::operator new() as thow() so that C++ compiler
        handles NULL return values
      (there is no testcase as there is no portable way to set limit on the 
      amount of memory that a process can allocate)
      
      
      sql/sql_list.h:
        BUG#26625: crash in range optimizer (out of mem) 
        - Define Sql_alloc::operator new() as thow() so that C++ compiler
          handles NULL return values
      425304f5
    • unknown's avatar
      Merge chilla.local:/home/mydev/mysql-4.1--main · f6eca60a
      unknown authored
      into  chilla.local:/home/mydev/mysql-4.1-axmrg
      
      
      f6eca60a
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-4.1 · cd07f122
      unknown authored
      into  chilla.local:/home/mydev/mysql-4.1-axmrg
      
      
      cd07f122
    • unknown's avatar
      Merge chilla.local:/home/mydev/mysql-4.1--team · 17a4df42
      unknown authored
      into  chilla.local:/home/mydev/mysql-4.1-axmrg
      
      
      sql/ha_myisam.cc:
        Auto merged
      17a4df42
    • unknown's avatar
      Merge chilla.local:/home/mydev/mysql-4.1-bug26231 · 30bf8b69
      unknown authored
      into  chilla.local:/home/mydev/mysql-4.1-axmrg
      
      
      30bf8b69
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-4.1-engines · fd3b7235
      unknown authored
      into  chilla.local:/home/mydev/mysql-4.1-bug24985
      
      
      mysql-test/r/heap_btree.result:
        Bug#24985 - UTF8 ENUM primary key on MEMORY using BTREE
                    causes incorrect duplicate entries
        Manual merge
      mysql-test/t/heap_btree.test:
        Bug#24985 - UTF8 ENUM primary key on MEMORY using BTREE
                    causes incorrect duplicate entries
        Manual merge
      fd3b7235
  9. 27 Mar, 2007 2 commits
    • unknown's avatar
      mysql.spec.sh, Makefile.am: · 0d5a969a
      unknown authored
        Don't use explicit calls to mysql-test-run in spec
      
      
      Makefile.am:
        Don't use explicit calls to mysql-test-run in spec
      support-files/mysql.spec.sh:
        Don't use explicit calls to mysql-test-run in spec
      0d5a969a
    • unknown's avatar
      Bug#24985 - UTF8 ENUM primary key on MEMORY using BTREE · 1fd0ba89
      unknown authored
                  causes incorrect duplicate entries
      
      Keys for BTREE indexes on ENUM and SET columns of MEMORY tables
      with character set UTF8 were computed incorrectly. Many
      different column values got the same key value.
      
      Apart of possible performance problems, it made unique indexes
      of this type unusable because it rejected many different
      values as duplicates.
      
      The problem was that multibyte character detection was tried
      on the internal numeric column value. Many values were not
      identified as characters. Their key value became blank filled.
      
      Thanks to Alexander Barkov and Ramil Kalimullin for the patch,
      which sets the character set of ENUM and SET key segments to
      the pseudo binary character set.
      
      
      mysql-test/r/heap_btree.result:
        Bug#24985 - UTF8 ENUM primary key on MEMORY using BTREE
                    causes incorrect duplicate entries
        Added test result.
      mysql-test/t/heap_btree.test:
        Bug#24985 - UTF8 ENUM primary key on MEMORY using BTREE
                    causes incorrect duplicate entries
        Added test.
      sql/ha_heap.cc:
        Bug#24985 - UTF8 ENUM primary key on MEMORY using BTREE
                    causes incorrect duplicate entries
        Set key segment charset to my_charset_bin for ENUM and SET
        columns.
      1fd0ba89
  10. 26 Mar, 2007 2 commits
    • unknown's avatar
      Bug #27164: not reseting the data pointer · 3335f68d
      unknown authored
       to 0 causes wrong (large) length to be read
       from the row in _mi_calc_blob_length() when 
       storing NULL values in (e.g) POINT columns.
       This large length is then used to allocate
       a block of memory that (on some OSes) causes
       trouble.
       Fixed by calling the base class's 
       Field_blob::reset() from Field_geom::reset()
       that is called when storing a NULL value into
       the column.
      
      
      mysql-test/r/gis.result:
        Bug #27164: test case
      mysql-test/t/gis.test:
        Bug #27164: test case
      sql/field.h:
        Bug #27164: not reseting the data pointer
         to 0 causes wrong (large) length to be read
         from the row in _mi_calc_blob_length() when 
         storing NULL values in (e.g) POINT columns.
         This large length is then used to allocate
         a block of memory that (on some OSes) causes
         trouble.
      3335f68d
    • unknown's avatar
      Merge rkalimullin@bk-internal.mysql.com:/home/bk/mysql-4.1-maint · e77cdbe2
      unknown authored
      into  mysql.com:/home/ram/work/b25301/b25301.4.1
      
      
      sql-common/my_time.c:
        Auto merged
      e77cdbe2
  11. 25 Mar, 2007 2 commits
  12. 24 Mar, 2007 1 commit
  13. 23 Mar, 2007 6 commits
  14. 22 Mar, 2007 5 commits
    • unknown's avatar
      Merge bk@192.168.21.1:mysql-4.1 · 55f991c2
      unknown authored
      into  mysql.com:/home/hf/work/mrg/mysql-4.1-opt
      
      
      55f991c2
    • unknown's avatar
      .del-fill_func_tables.sh: · 4b4700f3
      unknown authored
        Delete: scripts/fill_func_tables.sh
      .del-fill_help_tables.sh:
        Delete: scripts/fill_help_tables.sh
      .del-internals.texi:
        Delete: Docs/internals.texi
      
      
      BitKeeper/deleted/.del-internals.texi:
        Delete: Docs/internals.texi
      BitKeeper/deleted/.del-fill_func_tables.sh:
        Delete: scripts/fill_func_tables.sh
      BitKeeper/deleted/.del-fill_help_tables.sh:
        Delete: scripts/fill_help_tables.sh
      4b4700f3
    • unknown's avatar
      Merge mysql.com:/home/kent/bk/tmp/mysql-4.0 · d3125d0a
      unknown authored
      into  mysql.com:/home/kent/bk/tmp/mysql-4.1-build
      
      
      BitKeeper/deleted/.del-net_doc.txt:
        Auto merged
      d3125d0a
    • unknown's avatar
      Deleted directories · 84536ba9
      unknown authored
        Docs/Books/
        Docs/MySQL-logos/
      Deleted files
        Docs/Tutorial-MySQL-final.txt
        Docs/bk.txt
        Docs/Support/.cvsignore
        Docs/Support/colspec-fix.pl
        Docs/Support/docbook-fixup.pl
        Docs/Support/docbook-prefix.pl
        Docs/Support/docbook-split
        Docs/Support/make-docbook
        Docs/Support/make-makefile
        Docs/Support/test-make-manual
        Docs/Support/test-make-manual-de
        Docs/Support/trivial-makeinfo-4.0c.patch
        Docs/Support/xwf
      Deleted file now in internals main text
        Docs/my_sys.txt
      Deleted file now in internals svn tree
        Docs/net_doc.txt
      Removed obsolete entries
        Docs/.cvsignore
      Added note that info is obsolete
        Docs/linuxthreads.txt
      
      
      BitKeeper/deleted/.del-colspec-fix.pl:
        Delete: Docs/Support/colspec-fix.pl
      BitKeeper/deleted/.del-docbook-fixup.pl:
        Delete: Docs/Support/docbook-fixup.pl
      BitKeeper/deleted/.del-docbook-prefix.pl:
        Delete: Docs/Support/docbook-prefix.pl
      BitKeeper/deleted/.del-docbook-split:
        Delete: Docs/Support/docbook-split
      BitKeeper/deleted/.del-make-docbook:
        Delete: Docs/Support/make-docbook
      BitKeeper/deleted/.del-make-makefile:
        Delete: Docs/Support/make-makefile
      BitKeeper/deleted/.del-test-make-manual-de:
        Delete: Docs/Support/test-make-manual-de
      BitKeeper/deleted/.del-test-make-manual:
        Delete: Docs/Support/test-make-manual
      BitKeeper/deleted/.del-trivial-makeinfo-4.0c.patch:
        Delete: Docs/Support/trivial-makeinfo-4.0c.patch
      BitKeeper/deleted/.del-xwf:
        Delete: Docs/Support/xwf
      BitKeeper/deleted/.del-algor.eps~1a57aff065918206:
        Delete: Docs/Books/algor.eps
      BitKeeper/deleted/.del-algor.gif:
        Delete: Docs/Books/algor.gif
      BitKeeper/deleted/.del-algor.txt:
        Delete: Docs/Books/algor.txt
      BitKeeper/deleted/.del-dbi.eps~7b1032f98de7736d:
        Delete: Docs/Books/dbi.eps
      BitKeeper/deleted/.del-dbi.gif:
        Delete: Docs/Books/dbi.gif
      BitKeeper/deleted/.del-dbi.txt:
        Delete: Docs/Books/dbi.txt
      BitKeeper/deleted/.del-dubois.eps~f24e09a7fa420436:
        Delete: Docs/Books/dubois.eps
      BitKeeper/deleted/.del-dubois.gif:
        Delete: Docs/Books/dubois.gif
      BitKeeper/deleted/.del-dubois.txt:
        Delete: Docs/Books/dubois.txt
      BitKeeper/deleted/.del-ecomm.eps~17833026ebd7656:
        Delete: Docs/Books/ecomm.eps
      BitKeeper/deleted/.del-ecomm.gif:
        Delete: Docs/Books/ecomm.gif
      BitKeeper/deleted/.del-ecomm.txt:
        Delete: Docs/Books/ecomm.txt
      BitKeeper/deleted/.del-in_21.eps~8150d06653dab178:
        Delete: Docs/Books/in_21.eps
      BitKeeper/deleted/.del-in_21.gif:
        Delete: Docs/Books/in_21.gif
      BitKeeper/deleted/.del-in_21.txt:
        Delete: Docs/Books/in_21.txt
      BitKeeper/deleted/.del-manual.eps~1c2ebcea50b4840c:
        Delete: Docs/Books/manual.eps
      BitKeeper/deleted/.del-manual.gif:
        Delete: Docs/Books/manual.gif
      BitKeeper/deleted/.del-manual.txt:
        Delete: Docs/Books/manual.txt
      BitKeeper/deleted/.del-msql.eps~f3801b9d166ae4fc:
        Delete: Docs/Books/msql.eps
      BitKeeper/deleted/.del-msql.gif:
        Delete: Docs/Books/msql.gif
      BitKeeper/deleted/.del-msql.txt:
        Delete: Docs/Books/msql.txt
      BitKeeper/deleted/.del-prof.eps~1f54d9a56eb2b908:
        Delete: Docs/Books/prof.eps
      BitKeeper/deleted/.del-prof.gif:
        Delete: Docs/Books/prof.gif
      BitKeeper/deleted/.del-prof.txt:
        Delete: Docs/Books/prof.txt
      BitKeeper/deleted/.del-pthreads.eps~2ca8ff2d1181b2c0:
        Delete: Docs/Books/pthreads.eps
      BitKeeper/deleted/.del-pthreads.gif:
        Delete: Docs/Books/pthreads.gif
      BitKeeper/deleted/.del-pthreads.txt:
        Delete: Docs/Books/pthreads.txt
      BitKeeper/deleted/.del-realmen.eps~cc022325d3cb045:
        Delete: Docs/Books/realmen.eps
      BitKeeper/deleted/.del-realmen.gif:
        Delete: Docs/Books/realmen.gif
      BitKeeper/deleted/.del-realmen.txt:
        Delete: Docs/Books/realmen.txt
      BitKeeper/deleted/.del-sql-99.eps~f85c06de7a016c7d:
        Delete: Docs/Books/sql-99.eps
      BitKeeper/deleted/.del-sql-99.gif:
        Delete: Docs/Books/sql-99.gif
      BitKeeper/deleted/.del-sql-99.txt:
        Delete: Docs/Books/sql-99.txt
      BitKeeper/deleted/.del-mysql-01.gif:
        Delete: Docs/MySQL-logos/mysql-01.gif
      BitKeeper/deleted/.del-mysql-02.gif:
        Delete: Docs/MySQL-logos/mysql-02.gif
      BitKeeper/deleted/.del-mysql-03.gif:
        Delete: Docs/MySQL-logos/mysql-03.gif
      BitKeeper/deleted/.del-mysql-04.gif:
        Delete: Docs/MySQL-logos/mysql-04.gif
      BitKeeper/deleted/.del-mysql-05.gif:
        Delete: Docs/MySQL-logos/mysql-05.gif
      BitKeeper/deleted/.del-mysql-06.gif:
        Delete: Docs/MySQL-logos/mysql-06.gif
      BitKeeper/deleted/.del-mysql-07.gif:
        Delete: Docs/MySQL-logos/mysql-07.gif
      BitKeeper/deleted/.del-mysql-08.gif:
        Delete: Docs/MySQL-logos/mysql-08.gif
      BitKeeper/deleted/.del-mysql-09.gif:
        Delete: Docs/MySQL-logos/mysql-09.gif
      BitKeeper/deleted/.del-mysql-10.gif:
        Delete: Docs/MySQL-logos/mysql-10.gif
      BitKeeper/deleted/.del-mysql-11.gif:
        Delete: Docs/MySQL-logos/mysql-11.gif
      BitKeeper/deleted/.del-mysql-12.gif:
        Delete: Docs/MySQL-logos/mysql-12.gif
      BitKeeper/deleted/.del-mysql-13.gif:
        Delete: Docs/MySQL-logos/mysql-13.gif
      BitKeeper/deleted/.del-mysql-14.gif:
        Delete: Docs/MySQL-logos/mysql-14.gif
      BitKeeper/deleted/.del-mysql-15.gif:
        Delete: Docs/MySQL-logos/mysql-15.gif
      BitKeeper/deleted/.del-mysql-16.gif:
        Delete: Docs/MySQL-logos/mysql-16.gif
      BitKeeper/deleted/.del-mysql-17.gif:
        Delete: Docs/MySQL-logos/mysql-17.gif
      BitKeeper/deleted/.del-mysql-compatible.jpg:
        Delete: Docs/MySQL-logos/mysql-compatible.jpg
      BitKeeper/deleted/.del-mysql_anim-01.gif:
        Delete: Docs/MySQL-logos/mysql_anim-01.gif
      BitKeeper/deleted/.del-mysql_anim-02.gif:
        Delete: Docs/MySQL-logos/mysql_anim-02.gif
      BitKeeper/deleted/.del-mysql_anim-03.gif:
        Delete: Docs/MySQL-logos/mysql_anim-03.gif
      BitKeeper/deleted/.del-mysql_anim-04.gif:
        Delete: Docs/MySQL-logos/mysql_anim-04.gif
      BitKeeper/deleted/.del-mysql_anim-05.gif:
        Delete: Docs/MySQL-logos/mysql_anim-05.gif
      BitKeeper/deleted/.del-mysql_anim-06.gif:
        Delete: Docs/MySQL-logos/mysql_anim-06.gif
      BitKeeper/deleted/.del-Tutorial-MySQL-final.txt:
        Delete: Docs/Tutorial-MySQL-final.txt
      BitKeeper/deleted/.del-net_doc.txt:
        Delete: Docs/net_doc.txt
      BitKeeper/deleted/.del-my_sys.txt:
        Delete: Docs/my_sys.txt
      BitKeeper/deleted/.del-bk.txt:
        Delete: Docs/bk.txt
      BitKeeper/deleted/.del-.cvsignore:
        Delete: Docs/Support/.cvsignore
      Docs/.cvsignore:
        Removed obsolete entries
      Docs/linuxthreads.txt:
        Added note info is obsolete
      84536ba9
    • unknown's avatar
      bug #16546 (DATETIME + 0 not always coerced in the same way) · 50b5064c
      unknown authored
        fix for cast( AS DATETIME) + 0 operation.
        I just implemented Item_datetime_typecast::val() method
        as it is usually done in other classes.
        Should be fixed more radically in 5.0
      
      
      mysql-test/r/type_datetime.result:
        result added
      mysql-test/t/type_datetime.test:
        testcase
      sql/item_timefunc.h:
        added double conversion to Item_datetime_typecast
      50b5064c