1. 28 Mar, 2008 4 commits
  2. 27 Mar, 2008 22 commits
    • unknown's avatar
      Bug #35206: select query result different if the key is indexed or not · 82242b93
      unknown authored
      The code for executing indexed ORDER BY was not setting all the 
      internal fields correctly when selecting to execute ORDER BY over
      and index.
      Fixed by change the access method to one that will use the 
      quick indexed access if one is selected while selecting indexed
      ORDER BY.
      
      
      mysql-test/r/order_by.result:
        Bug #35206: test case
      mysql-test/t/order_by.test:
        Bug #35206: test case
      sql/sql_select.cc:
        Bug #35206: Change the access method when selecting a 
        quick indexed access.
      82242b93
    • unknown's avatar
      Bug#35272: @@global.key_buffer_size = 4294967295 let the server crash · df93bab5
      unknown authored
      reverting test that has been obsoleted by changes to the code
      
      
      mysql-test/r/key_cache.result:
        reverting test that has been obsoleted by changes to the code
      mysql-test/t/key_cache.test:
        reverting test that has been obsoleted by changes to the code
      df93bab5
    • unknown's avatar
      Patch clean up. · d71bd5fa
      unknown authored
      Fixed interference between tests: Users were added but not properly removed.
      This caused later tests to fail.
      
      
      mysql-test/r/grant.result:
        Fixed interference between tests: Users were added but not properly removed.
        This caused later tests to fail.
      mysql-test/t/grant.test:
        Fixed interference between tests: Users were added but not properly removed.
        This caused later tests to fail.
      d71bd5fa
    • unknown's avatar
      Merge trift2.:/MySQL/M50/push-5.0 · f1af4839
      unknown authored
      into  trift2.:/MySQL/M51/push-5.1
      
      f1af4839
    • unknown's avatar
      Merge jbruehe@bk-internal.mysql.com:/home/bk/mysql-5.1-build · a02f8c67
      unknown authored
      into  trift2.:/MySQL/M51/push-5.1
      
      a02f8c67
    • unknown's avatar
      Merge jbruehe@bk-internal.mysql.com:/home/bk/mysql-5.0-build · afc05e63
      unknown authored
      into  trift2.:/MySQL/M50/push-5.0
      
      afc05e63
    • unknown's avatar
      Merge trift2.:/MySQL/M51/ndb-decl-5.1 · 2e79d50b
      unknown authored
      into  trift2.:/MySQL/M51/push-5.1
      
      2e79d50b
    • unknown's avatar
      Merge mysql.com:/Users/davi/mysql/mysql-5.1-bug33201 · d455ee29
      unknown authored
      into  mysql.com:/Users/davi/mysql/mysql-5.0-bugteam
      
      
      sql/sql_acl.cc:
        Auto merged
      d455ee29
    • unknown's avatar
      Merge pippilotta.erinye.com:/shared/home/df/mysql/build/mysql-5.0-build · 948da163
      unknown authored
      into  pippilotta.erinye.com:/shared/home/df/mysql/build/mysql-5.1-build
      
      
      BitKeeper/deleted/.del-configure.js:
        Auto merged
      948da163
    • unknown's avatar
      BUG#25340 · b68bddae
      unknown authored
      b68bddae
    • unknown's avatar
      Merge trift2.:/MySQL/M50/push-5.0 · 3890079a
      unknown authored
      into  trift2.:/MySQL/M51/push-5.1
      
      
      configure.in:
        Auto merged
      3890079a
    • unknown's avatar
      Merge trift2.:/MySQL/M51/mysql-5.1 · 216abda6
      unknown authored
      into  trift2.:/MySQL/M51/push-5.1
      
      
      configure.in:
        Auto merged
      mysql-test/r/federated.result:
        Auto merged
      mysql-test/t/federated.test:
        Auto merged
      216abda6
    • unknown's avatar
      Merge trift2.:/MySQL/M50/mysql-5.0 · 774bd919
      unknown authored
      into  trift2.:/MySQL/M50/push-5.0
      
      
      configure.in:
        Auto merged
      774bd919
    • unknown's avatar
      Merge rhel5-ia64-a.mysql.com:/data0/tsmith/build/50 · 6af7b853
      unknown authored
      into  rhel5-ia64-a.mysql.com:/data0/tsmith/build/51
      
      6af7b853
    • unknown's avatar
      Merge tsmith@bk-internal.mysql.com:/home/bk/mysql-5.0 · 288394f5
      unknown authored
      into  rhel5-ia64-a.mysql.com:/data0/tsmith/build/50
      
      288394f5
    • unknown's avatar
      Merge rhel5-ia64-a.mysql.com:/data0/tsmith/51 · d08e8faf
      unknown authored
      into  rhel5-ia64-a.mysql.com:/data0/tsmith/build/51
      
      d08e8faf
    • unknown's avatar
      Merge tsmith@bk-internal.mysql.com:/home/bk/mysql-5.1 · 6b4a1d3c
      unknown authored
      into  rhel5-ia64-a.mysql.com:/data0/tsmith/build/51
      
      
      sql/mysqld.cc:
        Auto merged
      sql/sql_acl.cc:
        Auto merged
      sql/sql_class.cc:
        Auto merged
      mysql-test/r/drop.result:
        SCCS merged
      mysql-test/t/drop.test:
        SCCS merged
      6b4a1d3c
    • unknown's avatar
      Merge tnurnberg@bk-internal.mysql.com:/home/bk/mysql-5.1-bugteam · e2d617dc
      unknown authored
      into  mysql.com:/misc/mysql/34731/51-34731
      
      e2d617dc
    • unknown's avatar
      Merge tnurnberg@bk-internal.mysql.com:/home/bk/mysql-5.0-bugteam · 5d66282e
      unknown authored
      into  mysql.com:/misc/mysql/34731/50-34731
      
      5d66282e
    • unknown's avatar
      Merge mysql.com:/misc/mysql/34731/50-34731 · a6727685
      unknown authored
      into  mysql.com:/misc/mysql/34731/51-34731
      
      
      mysql-test/t/range.test:
        Auto merged
      sql/opt_range.cc:
        Auto merged
      mysql-test/r/range.result:
        manual merge
      a6727685
    • unknown's avatar
      Merge mysql.com:/misc/mysql/34731_/50-34731 · 35ef5948
      unknown authored
      into  mysql.com:/misc/mysql/34731/50-34731
      
      
      sql/opt_range.cc:
        Auto merged
      mysql-test/r/range.result:
        manual merge
      mysql-test/t/range.test:
        manual merge
      35ef5948
    • unknown's avatar
      Apply innodb-5.1-ss2360 snapshot · e4548830
      unknown authored
      Fixes:
      - Bug #34920: auto_increment resets to 1 on foreign key creation
        We need to use/inherit the passed in autoinc counter for ALTER TABLE
        statements too.
      
      
      mysql-test/r/innodb.result:
        Apply innodb-5.1-ss2360 snapshot
        
        Revision r2345:
        branches/5.1: Fix Bug# 34920. We need to use/inherit the passed in autoinc
        counter for ALTER TABLE statements too.
      mysql-test/t/innodb.test:
        Apply innodb-5.1-ss2360 snapshot
        
        Revision r2345:
        branches/5.1: Fix Bug# 34920. We need to use/inherit the passed in autoinc
        counter for ALTER TABLE statements too.
      storage/innobase/dict/dict0dict.c:
        Apply innodb-5.1-ss2360 snapshot
        
        Revision r2353:
        branches/5.1: Change the InnoDB autoinc type to ulint64. For this added a
        new typedef to univ.i (ib_ulonglong). Added checks for overflow and removed
        the assertion where it crashed previously, since the type has now changed
        to unsigned, it doesn't make sense to check for < 0. Added new tests, to
        check for overflow, for the different INT types supported for both
        signed and unsigned.
      storage/innobase/handler/ha_innodb.cc:
        Apply innodb-5.1-ss2360 snapshot
        
        Revision r2353:
        branches/5.1: Change the InnoDB autoinc type to ulint64. For this added a
        new typedef to univ.i (ib_ulonglong). Added checks for overflow and removed
        the assertion where it crashed previously, since the type has now changed
        to unsigned, it doesn't make sense to check for < 0. Added new tests, to
        check for overflow, for the different INT types supported for both
        signed and unsigned.
        
        
        Revision r2345:
        branches/5.1: Fix Bug# 34920. We need to use/inherit the passed in autoinc
        counter for ALTER TABLE statements too.
      storage/innobase/handler/ha_innodb.h:
        Apply innodb-5.1-ss2360 snapshot
        
        Revision r2353:
        branches/5.1: Change the InnoDB autoinc type to ulint64. For this added a
        new typedef to univ.i (ib_ulonglong). Added checks for overflow and removed
        the assertion where it crashed previously, since the type has now changed
        to unsigned, it doesn't make sense to check for < 0. Added new tests, to
        check for overflow, for the different INT types supported for both
        signed and unsigned.
      storage/innobase/include/dict0dict.h:
        Apply innodb-5.1-ss2360 snapshot
        
        Revision r2353:
        branches/5.1: Change the InnoDB autoinc type to ulint64. For this added a
        new typedef to univ.i (ib_ulonglong). Added checks for overflow and removed
        the assertion where it crashed previously, since the type has now changed
        to unsigned, it doesn't make sense to check for < 0. Added new tests, to
        check for overflow, for the different INT types supported for both
        signed and unsigned.
      storage/innobase/include/dict0mem.h:
        Apply innodb-5.1-ss2360 snapshot
        
        Revision r2353:
        branches/5.1: Change the InnoDB autoinc type to ulint64. For this added a
        new typedef to univ.i (ib_ulonglong). Added checks for overflow and removed
        the assertion where it crashed previously, since the type has now changed
        to unsigned, it doesn't make sense to check for < 0. Added new tests, to
        check for overflow, for the different INT types supported for both
        signed and unsigned.
      storage/innobase/include/row0sel.h:
        Apply innodb-5.1-ss2360 snapshot
        
        Revision r2353:
        branches/5.1: Change the InnoDB autoinc type to ulint64. For this added a
        new typedef to univ.i (ib_ulonglong). Added checks for overflow and removed
        the assertion where it crashed previously, since the type has now changed
        to unsigned, it doesn't make sense to check for < 0. Added new tests, to
        check for overflow, for the different INT types supported for both
        signed and unsigned.
      storage/innobase/include/univ.i:
        Apply innodb-5.1-ss2360 snapshot
        
        Revision r2353:
        branches/5.1: Change the InnoDB autoinc type to ulint64. For this added a
        new typedef to univ.i (ib_ulonglong). Added checks for overflow and removed
        the assertion where it crashed previously, since the type has now changed
        to unsigned, it doesn't make sense to check for < 0. Added new tests, to
        check for overflow, for the different INT types supported for both
        signed and unsigned.
      storage/innobase/row/row0sel.c:
        Apply innodb-5.1-ss2360 snapshot
        
        Revision r2353:
        branches/5.1: Change the InnoDB autoinc type to ulint64. For this added a
        new typedef to univ.i (ib_ulonglong). Added checks for overflow and removed
        the assertion where it crashed previously, since the type has now changed
        to unsigned, it doesn't make sense to check for < 0. Added new tests, to
        check for overflow, for the different INT types supported for both
        signed and unsigned.
      e4548830
  3. 26 Mar, 2008 14 commits
    • unknown's avatar
      Post-merge fix. · 9bd13302
      unknown authored
      Query cache does now work with concurrent_insert=0. See
      Bug 33756 - query cache with concurrent_insert=0 appears broken
      
      9bd13302
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0-build · 13c3814f
      unknown authored
      into  zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-5.0-build
      
      13c3814f
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.1-build · 41d23a04
      unknown authored
      into  zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-5.1-build
      
      41d23a04
    • unknown's avatar
      Merge kaamos.(none):/data/src/bugteam/bug34928/my51 · 93344569
      unknown authored
      into  kaamos.(none):/data/src/bugteam/mysql-5.1-bugteam
      
      93344569
    • unknown's avatar
      Merge zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-5.0-build · 9c86d7b2
      unknown authored
      into  zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-5.1-build
      
      
      support-files/mysql.server.sh:
        Auto merged
      9c86d7b2
    • unknown's avatar
      Fix for bug #34928: Confusion by having Primary Key and Index · 044dfd03
      unknown authored
      The bug is a regression introduced in 5.1 by the patch for bug28404.
      
      Under some circumstances test_if_skip_sort_order() could leave some
      data structures in an inconsistent state so that some parts of code
      could assume the selected execution strategy for GROUP BY/DISTINCT as
      a loose index scan (e.g. JOIN_TAB::is_using_loose_index_scan()), while
      the actual strategy chosen was an ordered index scan, which led to
      wrong data being returned.
      
      Fixed test_if_skip_sort_order() so that when changing the type for a
      join table, select->quick is reset not only for EXPLAIN, but for the 
      actual join execution as well, to not confuse code that depends on its
      value to determine the chosen GROUP BY/DISTINCT strategy.
      
      
      mysql-test/r/distinct.result:
        Added a test case for bug #34928.
      mysql-test/t/distinct.test:
        Added a test case for bug #34928.
      sql/sql_select.cc:
        When changing the table's join type to JT_NEXT in 
        test_if_skip_sort_order(), also reset select->quick because other
        code may depend on its value to determine the GROUP BY/DISTINCT
        execution strategy.
      044dfd03
    • unknown's avatar
      Merge stella.local:/home2/mydev/mysql-5.0-axmrg · 192fe25b
      unknown authored
      into  stella.local:/home2/mydev/mysql-5.1-axmrg
      
      192fe25b
    • unknown's avatar
      Merge stella.local:/home2/mydev/mysql-5.1-amain · 8b8c0762
      unknown authored
      into  stella.local:/home2/mydev/mysql-5.1-axmrg
      
      
      mysql-test/t/query_cache.test:
        Auto merged
      sql/mysql_priv.h:
        Auto merged
      sql/sql_delete.cc:
        Auto merged
      mysql-test/r/query_cache.result:
        SCCS merged
      8b8c0762
    • unknown's avatar
      Merge stella.local:/home2/mydev/mysql-5.0-amain · 20cf640c
      unknown authored
      into  stella.local:/home2/mydev/mysql-5.0-axmrg
      
      20cf640c
    • unknown's avatar
      Post-merge fix · 285de696
      unknown authored
      285de696
    • unknown's avatar
      Dummy change to force PushBuild. · 3cf73f27
      unknown authored
      3cf73f27
    • unknown's avatar
      Dummy change to force PushBuild. · 0b86a282
      unknown authored
      0b86a282
    • unknown's avatar
      Merge stella.local:/home2/mydev/mysql-5.1-ateam · 98daf3fe
      unknown authored
      into  stella.local:/home2/mydev/mysql-5.1-axmrg
      
      
      mysql-test/r/federated.result:
        Auto merged
      mysql-test/t/federated.test:
        Auto merged
      sql/sql_delete.cc:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      sql/sql_update.cc:
        Auto merged
      storage/federated/ha_federated.cc:
        Auto merged
      mysql-test/suite/binlog/r/binlog_unsafe.result:
        Manual merge
      mysql-test/suite/binlog/t/binlog_unsafe.test:
        Manual merge
      98daf3fe
    • unknown's avatar
      Merge stella.local:/home2/mydev/mysql-5.0-axmrg · a68cb126
      unknown authored
      into  stella.local:/home2/mydev/mysql-5.1-axmrg
      
      
      mysql-test/r/ctype_big5.result:
        Auto merged
      mysql-test/r/ctype_euckr.result:
        Auto merged
      mysql-test/r/ctype_gb2312.result:
        Auto merged
      mysql-test/r/ctype_gbk.result:
        Auto merged
      mysql-test/r/ctype_uca.result:
        Auto merged
      mysql-test/r/ctype_ucs.result:
        Auto merged
      mysql-test/suite/binlog/r/binlog_stm_ctype_cp932.result:
        Auto merged
      mysql-test/t/ctype_ucs.test:
        Auto merged
      sql/slave.cc:
        Auto merged
      mysql-test/r/federated.result:
        Manual merge from 5.0
      mysql-test/t/federated.test:
        Manual merge from 5.0
      storage/federated/ha_federated.cc:
        Manual merge from 5.0
      a68cb126