1. 28 Nov, 2007 1 commit
    • unknown's avatar
      BUG#32772: partition crash 1: enum column · b5c0cf45
      unknown authored
      The bug was that for ordered index scans, ha_partition::index_init() did
      not put index columns into table->read_set if the underlying storage 
      engine did not have HA_PARTIAL_COLUMN_READ flag. 
      This was causing assertion failure when handle_ordered_index_scan() tried
      to sort the records according to index order.
      
      Fixed by making ha_partition::index_init() put index columns into table->read_set
      for all ordered scans. 
      
      
      mysql-test/r/partition.result:
        BUG#32772: partition crash 1: enum column
        - Testcase
      mysql-test/t/partition.test:
        BUG#32772: partition crash 1: enum column
        - Testcase
      sql/ha_partition.cc:
        BUG#32772: partition crash 1: enum column
        - Make ha_partition::index_init() include index columns in the read_set
          whenever an ordered scan is initialized, no matter if
          HA_PARTIAL_COLUMN_READ is set or not.
      b5c0cf45
  2. 27 Nov, 2007 2 commits
    • unknown's avatar
      Merge magare.gmz:/home/kgeorge/mysql/work/B30355-5.0-opt · 9d503cea
      unknown authored
      into  magare.gmz:/home/kgeorge/mysql/work/B30355-5.1-opt
      
      
      include/mysql_com.h:
        Auto merged
      mysql-test/r/udf.result:
        Auto merged
      mysql-test/t/udf.test:
        Auto merged
      sql/item_func.cc:
        Auto merged
      sql/item_func.h:
        Auto merged
      sql/udf_example.c:
        Auto merged
      9d503cea
    • unknown's avatar
      Bug #30355: Incorrect ordering of UDF results · 63b65169
      unknown authored
      There's currently no way of knowing the determinicity of an UDF.
      And the optimizer and the sequence() UDFs were making wrong
      assumptions about what the is_const member means.
      Plus there was no implementation of update_system_tables()
      causing the optimizer to overwrite the information returned by
      the <udf>_init function.
      
      Fixed by equating the assumptions about the semantics of 
      is_const and providing a implementation of update_used_tables().
      Added a TODO item for the UDF API change needed to make a better 
      implementation.
      
      
      include/mysql_com.h:
        Bug #30355: comment added
      mysql-test/r/udf.result:
        Bug #30355: test case
      mysql-test/t/udf.test:
        Bug #30355: test case
      sql/item_func.cc:
        Bug #30355: keep const_item_cache and used_tables_cache in sync
      sql/item_func.h:
        Bug #30355: 
         - a better implementation of update_used_tables()
         - keep const_item_cache and used_tables_cache in sync
      sql/udf_example.c:
        Bug #30355: Wrong value for const_item fixed.
      63b65169
  3. 26 Nov, 2007 10 commits
    • unknown's avatar
      Many files: · 3058e025
      unknown authored
        Test case for the bug#31048 is moved to the subselect_notembedded tests as the embedded server isn't affected by this bug.
      
      
      mysql-test/r/subselect.result:
        Test case for the bug#31048 is moved to the subselect_notembedded tests as the embedded server isn't affected by this bug.
      mysql-test/r/subselect_notembedded.result:
        Test case for the bug#31048 is moved to the subselect_notembedded tests as the embedded server isn't affected by this bug.
      mysql-test/t/subselect.test:
        Test case for the bug#31048 is moved to the subselect_notembedded tests as the embedded server isn't affected by this bug.
      mysql-test/t/subselect_notembedded.test:
        Test case for the bug#31048 is moved to the subselect_notembedded tests as the embedded server isn't affected by this bug.
      3058e025
    • unknown's avatar
      Merge polly.(none):/home/kaa/src/opt/bug28837/my51-bug29131 · 8ae8b2e5
      unknown authored
      into  polly.(none):/home/kaa/src/opt/mysql-5.1-opt
      
      
      storage/myisam/ha_myisam.cc:
        Auto merged
      mysql-test/r/merge.result:
        Manual merge.
      mysql-test/r/myisam.result:
        Manual merge.
      mysql-test/t/merge.test:
        Manual merge.
      mysql-test/t/myisam.test:
        Manual merge.
      8ae8b2e5
    • unknown's avatar
      Merge polly.(none):/home/kaa/src/opt/bug28837/my50-bug29131 · ed480259
      unknown authored
      into  polly.(none):/home/kaa/src/opt/bug28837/my51-bug29131
      
      
      mysql-test/r/merge.result:
        Auto merged
      mysql-test/t/merge.test:
        Auto merged
      mysql-test/r/myisam.result:
        Manual merge.
      mysql-test/t/myisam.test:
        Manual merge.
      storage/myisam/ha_myisam.cc:
        Manual merge.
      storage/myisammrg/ha_myisammrg.cc:
        Manual merge.
      ed480259
    • unknown's avatar
      Fix for bug #28837: MyISAM storage engine error (134) doing delete with · 67bf39f2
      unknown authored
      self-join
      
      When doing DELETE with self-join on a MyISAM or MERGE table, it could
      happen that a record being retrieved in join_read_next_same() has
      already been deleted by previous iterations. That caused the engine's
      index_next_same() method to fail with HA_ERR_RECORD_DELETED error and
      the whole DELETE query to be aborted with an error.
      
      Fixed by suppressing the HA_ERR_RECORD_DELETED error in
      hy_myisam::index_next_same() and ha_myisammrg::index_next_same(). Since
      HA_ERR_RECORD_DELETED can only be returned by MyISAM, there is no point
      in filtering this error in the SQL layer.
      
      
      mysql-test/r/merge.result:
        Added a test case for bug #28837.
      mysql-test/r/myisam.result:
        Added a test case for bug #28837.
      mysql-test/t/merge.test:
        Added a test case for bug #28837.
      mysql-test/t/myisam.test:
        Added a test case for bug #28837.
      sql/ha_myisam.cc:
        Skip HA_ERR_RECORD_DELETED silently when calling mi_rnext_same().
      sql/ha_myisammrg.cc:
        Skip HA_ERR_RECORD_DELETED silently when calling mi_rnext_same().
      67bf39f2
    • unknown's avatar
      merge of 5.0-opt to 5.1-opt · 185b9efe
      unknown authored
      185b9efe
    • unknown's avatar
      Merge gkodinov@bk-internal.mysql.com:/home/bk/mysql-5.1-opt · 6b4a0f25
      unknown authored
      into  magare.gmz:/home/kgeorge/mysql/autopush/B32036-5.1-opt
      
      
      6b4a0f25
    • unknown's avatar
      Merge magare.gmz:/home/kgeorge/mysql/work/B32036-5.0-opt · b7a2960f
      unknown authored
      into  magare.gmz:/home/kgeorge/mysql/work/B32036-5.1-opt
      
      
      mysql-test/r/subselect.result:
        merged fix for bug 32036 to 5.1-opt
      mysql-test/t/subselect.test:
        merged fix for bug 32036 to 5.1-opt
      sql/sql_yacc.yy:
        merged fix for bug 32036 to 5.1-opt
      b7a2960f
    • unknown's avatar
      Bug #32036: EXISTS within a WHERE clause with a UNION · f3f9855d
      unknown authored
        crashes MySQL 5.122
      There was a difference in how UNIONs are handled
      on top level and when in sub-query.
      Because the rules for sub-queries were syntactically
      allowing cases that are not currently supported by
      the server we had crashes (this bug) or wrong results
      (bug 32051).
      Fixed by making the syntax rules for UNIONs match the 
      ones at top level.
      
      These rules however do not support nesting UNIONs, e.g.
      (SELECT a FROM t1 UNION ALL SELECT b FROM t2) 
       UNION
      (SELECT c FROM t3 UNION ALL SELECT d FROM t4)
      Supports for statements with nested UNIONs will be
      added in a future version.
      
      
      mysql-test/r/subselect.result:
        Bug #32036: test case
      mysql-test/t/subselect.test:
        Bug #32036: test case
      sql/sql_yacc.yy:
        Bug #32036: Make the syntax rules for UNIONs in subqueries the same
        as for top level UNIONs.
      f3f9855d
    • unknown's avatar
      Merge magare.gmz:/home/kgeorge/mysql/work/B32268-5.0-opt · 9eb12eb9
      unknown authored
      into  magare.gmz:/home/kgeorge/mysql/work/B32268-5.1-opt
      
      
      mysql-test/r/group_min_max.result:
        Auto merged
      mysql-test/t/group_min_max.test:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      9eb12eb9
    • unknown's avatar
      Bug#30152 MySQLD crash duing alter table causes DROP DATABASE to FAIL due to temp file(addon) · aab5779b
      unknown authored
      result fix
      
      
      mysql-test/r/drop.result:
        result fix
      aab5779b
  4. 24 Nov, 2007 8 commits
  5. 23 Nov, 2007 13 commits
    • unknown's avatar
      Merge polly.(none):/home/kaa/src/opt/bug29976/my51-bug28550 · 5668c1b3
      unknown authored
      into  polly.(none):/home/kaa/src/opt/mysql-5.1-opt
      
      
      sql/slave.cc:
        Auto merged
      5668c1b3
    • unknown's avatar
      Merge sgluhov@bk-internal.mysql.com:/home/bk/mysql-5.1-opt · 86823d74
      unknown authored
      into  mysql.com:/home/gluh/MySQL/Merge/5.1-opt
      
      
      86823d74
    • unknown's avatar
      Bug#30152 MySQLD crash duing alter table causes DROP DATABASE to FAIL due to temp file · 9a34c80e
      unknown authored
      disable decoding of table name if the table is internal temporary table
      
      
      mysql-test/r/drop.result:
        test result
      mysql-test/t/drop.test:
        test case
      sql/sql_db.cc:
        check is the name is internal tmp table name
      sql/sql_table.cc:
        disable decoding of table name if the table is internal temporary table
      sql/table.h:
        added flag which is true when table name is the name of internal temporary table
      9a34c80e
    • unknown's avatar
      Merge gkodinov@bk-internal.mysql.com:/home/bk/mysql-5.0-opt · 10c1aa79
      unknown authored
      into  magare.gmz:/home/kgeorge/mysql/autopush/B32400-5.0-opt
      
      
      tests/mysql_client_test.c:
        Auto merged
      mysql-test/r/subselect.result:
        SCCS merged
      mysql-test/t/subselect.test:
        SCCS merged
      10c1aa79
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.1-opt · 8401d595
      unknown authored
      into  magare.gmz:/home/kgeorge/mysql/work/B32400-5.1-opt
      
      
      8401d595
    • unknown's avatar
      Merge magare.gmz:/home/kgeorge/mysql/work/B32400-5.0-opt · 042a58e0
      unknown authored
      into  magare.gmz:/home/kgeorge/mysql/work/B32400-5.1-opt
      
      
      BitKeeper/deleted/.del-ps_6bdb.result:
        Auto merged
      mysql-test/r/ps_2myisam.result:
        Auto merged
      mysql-test/r/ps_3innodb.result:
        Auto merged
      mysql-test/r/ps_4heap.result:
        Auto merged
      mysql-test/r/ps_5merge.result:
        Auto merged
      mysql-test/suite/ndb/r/ps_7ndb.result:
        Auto merged
      sql/item.cc:
        Auto merged
      tests/mysql_client_test.c:
        Auto merged
      mysql-test/t/subselect.test:
        merge of bug 32400 to 5.1-opt
      042a58e0
    • unknown's avatar
      Merge sgluhov@bk-internal.mysql.com:/home/bk/mysql-5.1-opt · 13f637fb
      unknown authored
      into  mysql.com:/home/gluh/MySQL/Merge/5.1-opt
      
      
      13f637fb
    • unknown's avatar
      Bug#32178 server crash when select from i_s and concurrent partition management · 6b3fed49
      unknown authored
      The crash happens because we change share->partition_info where 'share' is global struct
      (it affects other threads which use the same 'share').
      It causes discrepancy between 'share' and handler data. 
      The fix:
      Move share->partition_info update into WFRM_INSTALL_SHADOW part which is protected by OPEN_lock.
      
      
      sql/sql_partition.cc:
        fast_end_partition: added close_thread_tables() for the case when error occures
        fast_alter_partition_table: added close_thread_tables() for the case when error occures
      sql/sql_table.cc:
        The crash happens because we change share->partition_info where 'share' is global struct.
        It causes discrepancy between 'share' and handler data.
        The fix:
        Move share->partition_info update into WFRM_INSTALL_SHADOW part which is protected by OPEN_lock.
      6b3fed49
    • unknown's avatar
      Merge ssh://bk-internal.mysql.com//home/bk/mysql-5.1-opt · d1a41459
      unknown authored
      into  polly.(none):/home/kaa/src/opt/mysql-5.1-opt
      
      
      d1a41459
    • unknown's avatar
      Merge polly.(none):/home/kaa/src/opt/bug32080/my51-bug26215 · 7ba06230
      unknown authored
      into  polly.(none):/home/kaa/src/opt/mysql-5.1-opt
      
      
      mysql-test/lib/mtr_report.pl:
        Auto merged
      7ba06230
    • unknown's avatar
      merge 5.0-opt -> 5.1-opt · 339e8f5d
      unknown authored
      339e8f5d
    • unknown's avatar
      Merge magare.gmz:/home/kgeorge/mysql/work/mysql-5.0-opt · c00bfc3b
      unknown authored
      into  magare.gmz:/home/kgeorge/mysql/work/merge-5.1-opt
      
      
      mysql-test/r/gis.result:
        Auto merged
      mysql-test/r/type_bit.result:
        Auto merged
      mysql-test/r/type_blob.result:
        Auto merged
      mysql-test/t/gis.test:
        Auto merged
      mysql-test/t/type_bit.test:
        Auto merged
      mysql-test/t/type_blob.test:
        Auto merged
      sql/item.h:
        Auto merged
      sql/item_subselect.cc:
        Auto merged
      sql/opt_range.cc:
        Auto merged
      sql/sql_class.cc:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      sql/sql_string.cc:
        Auto merged
      tests/mysql_client_test.c:
        Auto merged
      mysql-test/r/subselect.result:
        null merge. resolve latete.
      mysql-test/t/subselect.test:
        merge 5.0-opt -> 5.1-opt
      sql/key.cc:
        merge 5.0-opt -> 5.1-opt
      sql/sql_class.h:
        merge 5.0-opt -> 5.1-opt
      sql/sql_insert.cc:
        merge 5.0-opt -> 5.1-opt
      sql/sql_table.cc:
        merge 5.0-opt -> 5.1-opt
      c00bfc3b
    • unknown's avatar
      Fix for bug #32080: Excessive warnings on Solaris: setrlimit could not · e7501cd9
      unknown authored
      change the size of core files.
      
      Suppress the 'setrlimit could not change the size of the core files'
      warning in mysql-test-run. We do not want core files on some of the
      PushBuild hosts, and PushBuild itself does not set --core-files, so
      that warning is expected.
      
      
      mysql-test/lib/mtr_report.pl:
        Suppress the 'setrlimit could not change the size of the core files'
        warning in mysql-test-run. We do not want core files on some of the
        PushBuild machines, and PushBuild itself does not set --core-files, so
        that warning is expected.
      e7501cd9
  6. 22 Nov, 2007 6 commits