1. 30 Nov, 2007 1 commit
  2. 26 Nov, 2007 1 commit
    • unknown's avatar
      5.0 version of the fix for bug #9481: mysql_insert_id() returns 0 after · fe9bccc3
      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.
      fe9bccc3
  3. 19 Nov, 2007 6 commits
  4. 18 Nov, 2007 1 commit
    • unknown's avatar
      Merge gleb.loc:/work/bk/PA/5.0-opt-32335 · 2ddf3a60
      unknown authored
      into  gleb.loc:/work/bk/5.1-opt
      
      
      mysql-test/r/select.result:
        Auto merged
      mysql-test/t/select.test:
        Auto merged
      sql/item_cmpfunc.cc:
        Merge with 5.0-opt.
      2ddf3a60
  5. 17 Nov, 2007 10 commits
    • unknown's avatar
      Merge gleb.loc:/work/bk/5.0-opt-32335 · 179246eb
      unknown authored
      into  gleb.loc:/work/bk/5.0-opt
      
      179246eb
    • unknown's avatar
      Fixed bug #32335. · 8aa822ee
      unknown authored
      Comparison of a BIGINT NOT NULL column with a constant arithmetic
      expression that evaluates to NULL caused error 1048: "Column '...'
      cannot be null".
      
      Made convert_constant_item() check if the constant expression is NULL
      before attempting to store it in a field. Attempts to store NULL in a
      NOT NULL field caused query errors.
      
      
      sql/item_cmpfunc.cc:
        Fixed bug #32335.
        1. Made convert_constant_item() check if the constant expression is NULL
           before attempting to store it in a field. Attempts to store NULL in
           a NOT NULL field caused query errors.
        
        2. Also minor bug has been fixed: the thd->count_cuted_fields value
           was not restored in case of successful conversion.
      mysql-test/t/select.test:
        Added test case for bug #32335.
      mysql-test/r/select.result:
        Added test case for bug #32335.
      8aa822ee
    • unknown's avatar
      Merge mysql.com:/home/hf/work/31158/my50-31158 · af2714c2
      unknown authored
      into  mysql.com:/home/hf/work/31158/my51-31158
      
      
      sql/field.cc:
        Auto merged
      af2714c2
    • unknown's avatar
      Merge mysql.com:/home/hf/work/31158/my41-31158 · da9d774f
      unknown authored
      into  mysql.com:/home/hf/work/31158/my50-31158
      
      da9d774f
    • unknown's avatar
      Merge bk@192.168.21.1:mysql-4.1-opt · 895e939c
      unknown authored
      into  mysql.com:/home/hf/work/31158/my41-31158
      
      895e939c
    • unknown's avatar
      Merge bk@192.168.21.1:mysql-5.0-opt · 991c3971
      unknown authored
      into  mysql.com:/home/hf/work/31158/my50-31158
      
      
      sql/field.cc:
        Auto merged
      991c3971
    • unknown's avatar
      Merge bk@192.168.21.1:mysql-5.1-opt · 8c2fe628
      unknown authored
      into  mysql.com:/home/hf/work/31158/my51-31158
      
      
      sql/field.cc:
        Auto merged
      8c2fe628
    • unknown's avatar
      Merge mysql.com:/home/hf/work/31158/my50-31158 · 5fac132b
      unknown authored
      into  mysql.com:/home/hf/work/31158/my51-31158
      
      
      mysql-test/t/gis.test:
        Auto merged
      sql/field.cc:
        Auto merged
      sql/field.h:
        Auto merged
      sql/item_geofunc.cc:
        Auto merged
      mysql-test/r/gis.result:
        merging
      5fac132b
    • unknown's avatar
      merging · be99cfef
      unknown authored
      be99cfef
    • unknown's avatar
      Merge mysql.com:/home/hf/work/31158/my41-31158 · 1dfe7db5
      unknown authored
      into  mysql.com:/home/hf/work/31158/my50-31158
      
      
      mysql-test/t/gis.test:
        Auto merged
      sql/field.h:
        Auto merged
      sql/item_geofunc.cc:
        Auto merged
      mysql-test/r/gis.result:
        merging
      sql/field.cc:
        merging
      1dfe7db5
  6. 16 Nov, 2007 9 commits
  7. 15 Nov, 2007 7 commits
  8. 14 Nov, 2007 5 commits
    • unknown's avatar
      updated result file · fb0e2183
      unknown authored
      fb0e2183
    • unknown's avatar
      Merge mysql.com:/home/gluh/MySQL/Merge/5.0-opt · c243eb6a
      unknown authored
      into  mysql.com:/home/gluh/MySQL/Merge/5.1-opt
      
      
      mysql-test/t/select.test:
        Auto merged
      c243eb6a
    • unknown's avatar
      after merge fix · 72d70ff8
      unknown authored
      72d70ff8
    • unknown's avatar
      Merge mysql.com:/home/gluh/MySQL/Merge/5.0-opt · a4bb840d
      unknown authored
      into  mysql.com:/home/gluh/MySQL/Merge/5.1-opt
      
      
      mysql-test/r/select.result:
        Auto merged
      mysql-test/t/select.test:
        Auto merged
      mysql-test/t/subselect.test:
        Auto merged
      mysql-test/t/variables.test:
        Auto merged
      sql/item_func.cc:
        Auto merged
      sql/item_timefunc.cc:
        Auto merged
      a4bb840d
    • unknown's avatar
      Merge mysql.com:/home/gluh/MySQL/Merge/5.1 · acb7a755
      unknown authored
      into  mysql.com:/home/gluh/MySQL/Merge/5.1-opt
      
      
      BitKeeper/etc/ignore:
        auto-union
      mysql-test/r/events_bugs.result:
        Auto merged
      mysql-test/r/partition.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/r/sp.result:
        Auto merged
      mysql-test/t/partition.test:
        Auto merged
      mysql-test/t/subselect.test:
        Auto merged
      mysql-test/t/variables.test:
        Auto merged
      sql/field.cc:
        Auto merged
      sql/ha_partition.cc:
        Auto merged
      sql/item.cc:
        Auto merged
      sql/item_func.cc:
        Auto merged
      sql/item_subselect.cc:
        Auto merged
      sql/item_timefunc.cc:
        Auto merged
      sql/mysql_priv.h:
        Auto merged
      sql/mysqld.cc:
        Auto merged
      sql/opt_range.cc:
        Auto merged
      sql/set_var.cc:
        Auto merged
      sql/sql_base.cc:
        Auto merged
      sql/sql_class.cc:
        Auto merged
      sql/sql_class.h:
        Auto merged
      sql/sql_partition.cc:
        Auto merged
      sql/sql_plugin.cc:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      sql/sql_udf.cc:
        Auto merged
      sql/sql_yacc.yy:
        Auto merged
      sql/share/errmsg.txt:
        Auto merged
      tests/mysql_client_test.c:
        Auto merged
      mysql-test/r/select.result:
        manual merge
      mysql-test/t/select.test:
        manual merge
      acb7a755