An error occurred fetching the project authors.
  1. 01 Dec, 2007 1 commit
  2. 30 Nov, 2007 12 commits
    • unknown's avatar
      Merge mysql.com:/home/hf/work/mrg/my50-mrg · 51f5ac6b
      unknown authored
      into  mysql.com:/home/hf/work/mrg/my51-mrg
      
      
      sql/mysqld.cc:
        Auto merged
      sql/protocol.cc:
        Auto merged
      storage/federated/ha_federated.cc:
        Auto merged
      tests/mysql_client_test.c:
        Auto merged
      include/mysql_com.h:
        merging
      libmysqld/lib_sql.cc:
        merging
      mysql-test/r/federated.result:
        merging
      mysql-test/t/federated.test:
        merging
      storage/federated/ha_federated.h:
        mergin
      51f5ac6b
    • unknown's avatar
      Merge mysql.com:/home/hf/work/mrg/my41-mrg · 4100e3e4
      unknown authored
      into  mysql.com:/home/hf/work/mrg/my50-mrg
      
      
      include/mysql_com.h:
        Auto merged
      sql/mysqld.cc:
        Auto merged
      4100e3e4
    • unknown's avatar
      Merge mysql.com:/home/hf/work/32624/my50-32624 · 11c17294
      unknown authored
      into  mysql.com:/home/hf/work/mrg/my50-mrg
      
      
      11c17294
    • unknown's avatar
      Merge mysql.com:/home/hf/work/32374/my50-32374 · 104bba77
      unknown authored
      into  mysql.com:/home/hf/work/mrg/my50-mrg
      
      
      104bba77
    • unknown's avatar
      Merge mysql.com:/home/hf/work/31890/my51-31890 · 65b77b9d
      unknown authored
      into  mysql.com:/home/hf/work/mrg/my51-mrg
      
      
      mysql-test/r/partition.result:
        SCCS merged
      mysql-test/t/partition.test:
        merging
      65b77b9d
    • unknown's avatar
      Merge mysql.com:/home/hf/work/30430/my51-30430 · 69f539af
      unknown authored
      into  mysql.com:/home/hf/work/mrg/my51-mrg
      
      
      69f539af
    • unknown's avatar
      Bug #30430 crash:./mtr --embedded-server --ps-protocol cache_innodb func_misc... · 6959d204
      unknown authored
      PS-protocol data is stored in different format - the MYSQL_RECORDS->data
      contains the link to the record content, not to array of the links to
      the field's contents. So we have to handle it separately for
      embedded-server query cache.
      
      
      libmysqld/emb_qcache.cc:
        Bug #30430 crash:./mtr --embedded-server --ps-protocol cache_innodb func_misc...
        
        ps_protocol data now stored in it's particular way.
      libmysqld/emb_qcache.h:
        Bug #30430 crash:./mtr --embedded-server --ps-protocol cache_innodb func_misc...
        
        Querycache_stream::load_char/store_char  ->
          load_uchar/store_uchar
      mysql-test/r/func_misc.result:
        Bug #30430 crash:./mtr --embedded-server --ps-protocol cache_innodb func_misc...
        
        test result
      mysql-test/t/func_misc.test:
        Bug #30430 crash:./mtr --embedded-server --ps-protocol cache_innodb func_misc...
        
        the test uses t2 table, so let's make sure it doesn't exist befor the start
      6959d204
    • unknown's avatar
      Merge mysql.com:/home/hf/work/31900/my41-31900 · d87a75c1
      unknown authored
      into  mysql.com:/home/hf/work/mrg/my41-mrg
      
      
      d87a75c1
    • unknown's avatar
      Merge polly.(none):/home/kaa/src/opt/bug9481/my51-bug9481 · c6f076f6
      unknown authored
      into  polly.(none):/home/kaa/src/opt/mysql-5.1-opt
      
      
      sql/sql_class.h:
        Auto merged
      sql/sql_insert.cc:
        Auto merged
      tests/mysql_client_test.c:
        Auto merged
      c6f076f6
    • unknown's avatar
      Merge polly.(none):/home/kaa/src/opt/bug9481/my50-bug9481 · f904aab4
      unknown authored
      into  polly.(none):/home/kaa/src/opt/bug9481/my51-bug9481
      
      
      sql/sql_class.h:
        Null merge.
      sql/sql_insert.cc:
        Null merge.
      tests/mysql_client_test.c:
        Null merge.
      f904aab4
    • unknown's avatar
      Bug#32775 problems with SHOW EVENTS and Information_Schema · ff7e7fcb
      unknown authored
      removed unnecessary privilege checks for I_S schema
      
      
      mysql-test/r/information_schema.result:
        test result
      mysql-test/t/information_schema.test:
        test case
      sql/events.cc:
        There is no events in I_S so we don't need to execute check_access here.
      sql/sql_parse.cc:
        removed unnecessary check
      ff7e7fcb
    • unknown's avatar
      Bug #32374 crash with filesort when selecting from federated table and view. · cef31e05
      unknown authored
      filesort() uses file->estimate_rows_upper_bound() call to allocate
      internal buffers. If this function returns a value smaller than
      a number of row that will be returned later in find_all_keys(),
      that can cause server crash.
      Fixed by implementing ha_federated::estimate_rows_upper_bound() to
      return maximum possible number of rows.
      Present estimation for FEDERATED always returns 0 if the linked to the VIEW.
      
      
      mysql-test/r/federated.result:
        Bug #32374 crash with filesort when selecting from federated table and view.
        
        test result
      mysql-test/t/federated.test:
        Bug #32374 crash with filesort when selecting from federated table and view.
        
        test case
      sql/ha_federated.cc:
        Bug #32374 crash with filesort when selecting from federated table and view.
        
        ha_federated::estimate_rows_upper_bound() implemented
      sql/ha_federated.h:
        Bug #32374 crash with filesort when selecting from federated table and view.
        
        ha_federated::estimate_rows_upper_bound() interface
      cef31e05
  3. 29 Nov, 2007 2 commits
    • unknown's avatar
      Bug #29085 A small double precision number becomes zero. · 23e402bf
      unknown authored
      Denormalized DOUBLE-s can't be properly handled by old MIPS processors.
      So we need to enable specific mode for them so IRIX will do use
      software round to handle such numbers. 
      
      
      sql/mysqld.cc:
        Bug #29085 A small double precision number becomes zero.
        
        reset_floating_point_exeption() renamed as set_proper_floating_point_mode()
        #ifdef __sgi code added to enable denormalized DOUBLE-s on IRIX
      23e402bf
    • unknown's avatar
      Bug #32624 Error with multi queries in MySQL embedded server 5.1.22. · 1d062682
      unknown authored
      server status wasn't properly sent to the client after the error
      by the embedded server. Wasn't noticed before as one usually stopped
      retrieving results after he gets an error.
      
      
      libmysqld/lib_sql.cc:
        Bug #32624 Error with multi queries in MySQL embedded server 5.1.22.
        
        server status transferred to the client after errors
      sql/protocol.cc:
        Bug #32624 Error with multi queries in MySQL embedded server 5.1.22.
        
        set server status before net_send_error_packet() call as this
        function sends it to the client in the embedded server
      tests/mysql_client_test.c:
        Bug #32624 Error with multi queries in MySQL embedded server 5.1.22.
        
        testcase added
      1d062682
  4. 28 Nov, 2007 3 commits
    • unknown's avatar
      Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-5.1-opt · f4a7464f
      unknown authored
      into  mysql.com:/home/psergey/mysql-5.1-bug32772
      
      
      f4a7464f
    • unknown's avatar
      Bug#25629 CREATE TABLE LIKE does not work with INFORMATION_SCHEMA · b9d8e349
      unknown authored
      added new func mysql_create_like_schema_frm() which creates frm file based on I_S table
      
      
      mysql-test/r/create.result:
        test result
      mysql-test/t/create.test:
        test case
      sql/sql_table.cc:
        added new func mysql_create_like_schema_frm() which creates frm file based on I_S table
      b9d8e349
    • 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
  5. 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
  6. 26 Nov, 2007 12 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
      5.0 version of the fix for bug #9481: mysql_insert_id() returns 0 after · 1836b736
      unknown authored
      insert ... select.
      
      The 5.0 manual page for mysql_insert_id() does not mention anything
      about INSERT ... SELECT, though its current behavior is incosistent
      with what the manual says about the plain INSERT.
      
      Fixed by changing the AUTO_INCREMENT and mysql_insert_id() handling
      logic in INSERT ... SELECT to be consistent with the INSERT behavior,
      the manual, and the changes in 5.1 introduced by WL3146:
      
      
      - mysql_insert_id() now returns the first automatically generated
      AUTO_INCREMENT value that was successfully inserted by INSERT ... SELECT
      
      -  if an INSERT ... SELECT statement is executed, and no automatically
      generated value is successfully inserted, mysql_insert_id() now returns
      the ID of the last inserted row.
      
      
      sql/sql_class.h:
        Replaced last_insert_id with autoinc_value_of_last_inserted_row to be
        consistent with 5.1 code.
      sql/sql_insert.cc:
        Revised the AUTO_INCREMENT and mysql_insert_id() handling logic in
        INSERT ... SELECT to be consistent with INSERT behavior, the manual, and
        changes in 5.1 introduced by WL3146:
        
        - mysql_insert_id() now returns the first automatically generated
        AUTO_INCREMENT value that was successfully inserted;
        
        -  if an INSERT ... SELECT statement is executed, and no automatically
        generated value is successfully inserted, mysql_insert_id() now returns
        the ID of the last inserted row.
      tests/mysql_client_test.c:
        Backported the test cases related to INSERT ... SELECT and
        mysql_insert_id() from WL3146 patch to 5.0.
      1836b736
    • 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
      Bug #31900 Wrong confusing comment in mysql_com.h header file. · 7257ed0e
      unknown authored
      comment fixed as we truly need const_item to be 1 to mark
      constant function
      
      
      include/mysql_com.h:
        Bug #31900 Wrong confusing comment in mysql_com.h header file.
        
        comment fixed
      7257ed0e
    • 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
  7. 24 Nov, 2007 8 commits