1. 12 Jul, 2005 1 commit
    • unknown's avatar
      Fix bug #11399 Column alias was lost during view preraration. · 2ae3cdcf
      unknown authored
      New item created in find_field_in_table() to fix view's item, was created 
      without taking into account original item's alias. This patch checks if alias 
      is set to the original item and if so sets it to newly created item.
      
      
      sql/sql_base.cc:
        Fix bug#11399 Alias wasn't set on view column
      mysql-test/t/view.test:
        Test case for bug#11399 Use an alias in a select statement on a view
      mysql-test/r/view.result:
        Test case for bug#11399 Use an alias in a select statement on a view
      2ae3cdcf
  2. 04 Jul, 2005 1 commit
    • unknown's avatar
      After merge fixes · 428830c5
      unknown authored
      Better fix for ON DUPLICATE KEY UPDATE
      
      
      mysql-test/r/group_by.result:
        After merge fixes
      mysql-test/r/select.result:
        Reorder test to match 4.1 tests (will make future merges easier)
      mysql-test/t/group_by.test:
        Added --disable_ps_protocol to avoid extra warning
      mysql-test/t/select.test:
        Reorder test to match 4.1 tests (will make future merges easier)
      sql/mysql_priv.h:
        Better fix for ON DUPLICATE KEY UPDATE
      sql/sql_base.cc:
        After merge fixes
      sql/sql_insert.cc:
        Better fix for ON DUPLICATE KEY UPDATE
        (old solution gave problem with item->cached_table)
      sql/sql_prepare.cc:
        Better fix for ON DUPLICATE KEY UPDATE
      428830c5
  3. 03 Jul, 2005 1 commit
    • unknown's avatar
      Merge with 4.1 · eeee5fb1
      unknown authored
      
      Makefile.am:
        Auto merged
      myisam/mi_create.c:
        Auto merged
      myisam/mi_open.c:
        Auto merged
      mysql-test/r/ctype_utf8.result:
        Auto merged
      mysys/thr_alarm.c:
        Auto merged
      VC++Files/sql/mysqld.dsp:
        Keep old
      client/mysqldump.c:
        Manual merge
      client/mysqltest.c:
        Automatic merge
      configure.in:
        Manual merge
      mysql-test/r/ctype_ucs.result:
        Auto merge
      mysql-test/r/func_str.result:
        Auto merge
      mysql-test/r/group_by.result:
        Auto merge
      mysql-test/r/insert_select.result:
        Auto merge
      mysql-test/r/insert_update.result:
        Auto merge
      mysql-test/r/lowercase_table2.result:
        Auto merge
      mysql-test/r/select.result:
        Manual merge
      mysql-test/r/variables.result:
        Auto merge
      mysql-test/t/ctype_ucs.test:
        Auto merge
      mysql-test/t/func_str.test:
        Auto merge
      mysql-test/t/group_by.test:
        Auto merge
      mysql-test/t/insert_select.test:
        Auto merge
      mysql-test/t/insert_update.test:
        Auto merge
      mysql-test/t/ndb_alter_table.test:
        Auto merge
      mysql-test/t/select.test:
        Auto merge
      mysql-test/t/variables.test:
        Auto merge
      mysys/my_access.c:
        Auto merge
      scripts/make_win_src_distribution.sh:
        Auto merge
      sql/field.cc:
        Manual merge
      sql/ha_ndbcluster.cc:
        Auto merge
      sql/handler.cc:
        Auto merge
      sql/item.cc:
        Auto merge
      sql/item.h:
        Manual merge
      sql/item_cmpfunc.h:
        Auto merge
      sql/item_strfunc.cc:
        Auto merge
      sql/item_strfunc.h:
        Auto merge
      sql/mysql_priv.h:
        manual merge
      sql/mysqld.cc:
        manual merge
      sql/opt_range.cc:
        manual merge
      sql/set_var.cc:
        Auto merge
      sql/sql_base.cc:
        manual merge
        Restore processing of ON DUPLICATE KEY UPDATE
      sql/sql_insert.cc:
        manual merge
        Restore processing of ON DUPLICATE KEY UPDATE
        Simplify mysql_prepare_insert by using local variable for select_lex and save old values just before they are changed
      sql/sql_parse.cc:
        Restore processing of ON DUPLICATE KEY UPDATE
      sql/sql_prepare.cc:
        New ON DUPLICATE KEY UPDATE handling
      sql/sql_select.cc:
        manual merge
      sql/sql_table.cc:
        auto merge
      sql/sql_yacc.yy:
        auto merge
      strings/ctype-ucs2.c:
        auto merge
      strings/ctype-utf8.c:
        auto merge
      eeee5fb1
  4. 02 Jul, 2005 6 commits
  5. 01 Jul, 2005 31 commits
    • unknown's avatar
      Merge kboortz@bk-internal.mysql.com:/home/bk/mysql-4.1 · 18266bed
      unknown authored
      into mysql.com:/Users/kent/mysql/bk/mysql-4.1
      
      
      18266bed
    • unknown's avatar
      row0sel.c: · c75eae35
      unknown authored
        Optimize speed: no need to keep track of set new rec locks in a consistent read
      
      
      innobase/row/row0sel.c:
        Optimize speed: no need to keep track of set new rec locks in a consistent read
      c75eae35
    • unknown's avatar
      Merge heikki@bk-internal.mysql.com:/home/bk/mysql-5.0 · de21d09d
      unknown authored
      into hundin.mysql.fi:/home/heikki/mysql-5.0
      
      
      de21d09d
    • unknown's avatar
      trx0trx.h, trx0trx.ic, row0mysql.c: · c2323bae
      unknown authored
        Fix another bug in the fix of Bug #3300
      
      
      innobase/row/row0mysql.c:
        Fix another bug in the fix of Bug #3300
      innobase/include/trx0trx.ic:
        Fix another bug in the fix of Bug #3300
      innobase/include/trx0trx.h:
        Fix another bug in the fix of Bug #3300
      c2323bae
    • unknown's avatar
      trx0trx.ic, trx0trx.h: · 5bcbe404
      unknown authored
        Fix bug in the Bug #3300 bug fix
      
      
      innobase/include/trx0trx.h:
        Fix bug in the Bug #3300 bug fix
      innobase/include/trx0trx.ic:
        Fix bug in the Bug #3300 bug fix
      5bcbe404
    • unknown's avatar
      Many files: · 8561600a
      unknown authored
        Fix Bug #3300 : if innodb_locks_unsafe_for_binlog is set, release locks on rows that we do not UPDATE or DELETE
      
      
      sql/ha_innodb.cc:
        Fix Bug #3300 : if innodb_locks_unsafe_for_binlog is set, release locks on rows that we do not UPDATE or DELETE
      innobase/row/row0mysql.c:
        Fix Bug #3300 : if innodb_locks_unsafe_for_binlog is set, release locks on rows that we do not UPDATE or DELETE
      innobase/row/row0sel.c:
        Fix Bug #3300 : if innodb_locks_unsafe_for_binlog is set, release locks on rows that we do not UPDATE or DELETE
      innobase/include/trx0trx.ic:
        Fix Bug #3300 : if innodb_locks_unsafe_for_binlog is set, release locks on rows that we do not UPDATE or DELETE
      innobase/include/row0mysql.h:
        Fix Bug #3300 : if innodb_locks_unsafe_for_binlog is set, release locks on rows that we do not UPDATE or DELETE
      innobase/include/trx0trx.h:
        Fix Bug #3300 : if innodb_locks_unsafe_for_binlog is set, release locks on rows that we do not UPDATE or DELETE
      innobase/lock/lock0lock.c:
        Fix Bug #3300 : if innodb_locks_unsafe_for_binlog is set, release locks on rows that we do not UPDATE or DELETE
      innobase/trx/trx0trx.c:
        Fix Bug #3300 : if innodb_locks_unsafe_for_binlog is set, release locks on rows that we do not UPDATE or DELETE
      8561600a
    • unknown's avatar
      Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.1 · f831ab65
      unknown authored
      into sanja.is.com.ua:/home/bell/mysql/bk/work-bug5-4.1
      
      
      f831ab65
    • unknown's avatar
    • unknown's avatar
      Merge svojtovich@bk-internal.mysql.com:/home/bk/mysql-5.0 · 8d6c0896
      unknown authored
      into mysql.com:/home/svoj/devel/mysql/yassl1-mysql-5.0
      
      
      8d6c0896
    • unknown's avatar
      Merge mysql.com:/usr/local/bk/mysql-5.0 · ac480a37
      unknown authored
      into  mysql.com:/home/pem/work/mysql-5.0
      
      
      ac480a37
    • unknown's avatar
      Fix a crash I introduced by the last push. · d0df504b
      unknown authored
      d0df504b
    • unknown's avatar
      WL#2286 - Compile MySQL w/YASSL support · 672dffca
      unknown authored
      Merge with latest yaSSL. It includes fix for bigendian/littleendian
      problem (fixes func_encrypt test failure). Our trees are in sync now.
      
      
      extra/yassl/include/yassl_types.hpp:
        Merge with latest yaSSL.
      extra/yassl/src/Makefile.am:
        Merge with latest yaSSL.
      extra/yassl/src/buffer.cpp:
        Merge with latest yaSSL.
      extra/yassl/src/cert_wrapper.cpp:
        Merge with latest yaSSL.
      extra/yassl/src/lock.cpp:
        Merge with latest yaSSL.
      extra/yassl/src/log.cpp:
        Merge with latest yaSSL.
      extra/yassl/src/socket_wrapper.cpp:
        Merge with latest yaSSL.
      extra/yassl/src/template_instnt.cpp:
        Merge with latest yaSSL.
      extra/yassl/src/timer.cpp:
        Merge with latest yaSSL.
      extra/yassl/src/yassl_error.cpp:
        Merge with latest yaSSL.
      extra/yassl/src/yassl_int.cpp:
        Merge with latest yaSSL.
      extra/yassl/taocrypt/include/types.hpp:
        Merge with latest yaSSL.
      extra/yassl/taocrypt/src/Makefile.am:
        Merge with latest yaSSL.
      extra/yassl/taocrypt/src/aestables.cpp:
        Merge with latest yaSSL.
      extra/yassl/taocrypt/src/algebra.cpp:
        Merge with latest yaSSL.
      extra/yassl/taocrypt/src/arc4.cpp:
        Merge with latest yaSSL.
      extra/yassl/taocrypt/src/coding.cpp:
        Merge with latest yaSSL.
      extra/yassl/taocrypt/src/file.cpp:
        Merge with latest yaSSL.
      extra/yassl/taocrypt/src/integer.cpp:
        Merge with latest yaSSL.
      extra/yassl/taocrypt/src/misc.cpp:
        Merge with latest yaSSL.
      extra/yassl/taocrypt/src/random.cpp:
        Merge with latest yaSSL.
      extra/yassl/taocrypt/src/template_instnt.cpp:
        Merge with latest yaSSL.
      672dffca
    • unknown's avatar
      Merge mysql.com:/usr/local/bk/mysql-5.0 · 07d1323f
      unknown authored
      into  mysql.com:/home/pem/work/mysql-5.0
      
      
      07d1323f
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · b4751a93
      unknown authored
      into neptunus.(none):/home/msvensson/mysql/mysql-5.0
      
      
      b4751a93
    • unknown's avatar
      Merge mysql.com:/usr/local/bk/mysql-5.0 · 407d245b
      unknown authored
      into  mysql.com:/home/pem/work/mysql-5.0
      
      
      407d245b
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · d81f0574
      unknown authored
      into  mysql.com:/opt/local/work/mysql-5.0-11172-new
      
      
      sql/sql_select.cc:
        Auto merged
      d81f0574
    • unknown's avatar
      Fix a valgrind warning. · b32d2ac2
      unknown authored
      
      sql/sql_prepare.cc:
        A small fix for the previous patch: we should first free the
        prepared statement items, and then free the runtime memory root,
        as some memory used for cleanup is allocated in that mem root.
      sql/sql_select.cc:
        - ever free the cursor mem root in close() (it's too early).
      b32d2ac2
    • unknown's avatar
      Merge ibabaev@bk-internal.mysql.com:/home/bk/mysql-5.0 · 120a2da1
      unknown authored
      into rurik.mysql.com:/home/igor/mysql-5.0
      
      
      sql/sql_select.cc:
        Auto merged
      120a2da1
    • unknown's avatar
      Merge neptunus.(none):/home/msvensson/mysql/mysql-4.1-1.2310.2.2 · a58edfc5
      unknown authored
      into neptunus.(none):/home/msvensson/mysql/mysql-5.0
      
      
      client/mysqltest.c:
        Auto merged
      a58edfc5
    • unknown's avatar
      Merge neptunus.(none):/home/msvensson/mysql/mysql-4.1-1.2310.2.2 · 012f6be8
      unknown authored
      into neptunus.(none):/home/msvensson/mysql/mysql-4.1
      
      
      client/mysqltest.c:
        Auto merged
      012f6be8
    • unknown's avatar
      Win port fixes · d305f6d3
      unknown authored
      
      client/mysqltest.c:
        Check for HAVE_SYS_WAIT_H
        Define WEXITSTATUS if not defined
      d305f6d3
    • unknown's avatar
      Disabled the GOTO feature. (It's non-standard and undocumented.) · 1ff4a0eb
      unknown authored
      We want to have the defacto standard syntax for labels ("L:" instead of "label L;"),
      and fix some known bugs, before we enable this again.
      The code is left intact (#ifdef'ed SP_GOTO) and the test cases are kept in
      sp-goto.test, for the future...
      
      
      mysql-test/r/sp-error.result:
        Moved all goto tests to sp-goto.test.
      mysql-test/r/sp.result:
        Moved all goto tests to sp-goto.test.
      mysql-test/t/disabled.def:
        Disabled GOTO/LABEL (until the label syntax and some bugs can be fixed).
        We keep the tests in sp-goto.test for the future, but disable for now.
      mysql-test/t/sp-error.test:
        Moved all goto tests to sp-goto.test.
      mysql-test/t/sp.test:
        Moved all goto tests to sp-goto.test.
      sql/lex.h:
        Disabled GOTO/LABEL (until the label syntax and some bugs can be fixed).
      sql/sql_yacc.yy:
        Disabled GOTO/LABEL (until the label syntax and some bugs can be fixed).
      1ff4a0eb
    • unknown's avatar
      tests/mysql_client_test.c · eb4cb6eb
      unknown authored
          Add a test case for Bug#11656 "Server crash with mysql_stmt_fetch 
          (cursors)", the bug itself is no longer present.
      
      
      tests/mysql_client_test.c:
        Add a test case for Bug#11656 "Server crash with mysql_stmt_fetch 
        (cursors)", the bug itself is no longer present.
      eb4cb6eb
    • unknown's avatar
      - fix -ansi -pedantic error · 6c8d3975
      unknown authored
      6c8d3975
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · dc22424b
      unknown authored
      into  mysql.com:/opt/local/work/mysql-5.0-11172-new
      
      
      sql/sql_class.cc:
        Auto merged
      sql/sql_prepare.cc:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      dc22424b
    • unknown's avatar
      A fix and a test case for Bug#11172 "mysql_stmt_attr_set · d36c14f7
      unknown authored
      CURSOR_TYPE_READ_ONLY date/datetime filter server crash".
      The fix adds support for Item_change_list in cursors (proper rollback
      of the modified item tree). 
      
      
      sql/sql_class.cc:
        No need to call fatal_error() twice.
      sql/sql_prepare.cc:
        - implement proper cleanup of the prepared statement in mysql_stmt_reset
          if there is a cursor.
        - take into account thd->change_list when fetching data through a
          cursor.
      sql/sql_select.cc:
        - take into account thd->change_list when fetching data from a cursor:
          grab it when we open a cursor, and rollback the changes to the parsed
          tree when we close it.
      sql/sql_select.h:
        - Cursor::change_list added
      tests/mysql_client_test.c:
        - a test case for Bug#11172 "mysql_stmt_attr_set CURSOR_TYPE_READ_ONLY date/datetime
         filter server crash"
      d36c14f7
    • unknown's avatar
      Merge rurik.mysql.com:/home/igor/mysql-5.0 · 7dad490f
      unknown authored
      into rurik.mysql.com:/home/igor/dev/mysql-5.0-0
      
      
      mysql-test/r/view.result:
        Auto merged
      sql/item.h:
        Auto merged
      sql/sql_select.cc:
        Auto merged
      7dad490f
    • unknown's avatar
      Merge abarkov@bk-internal.mysql.com:/home/bk/mysql-5.0 · 8ec6c354
      unknown authored
      into mysql.com:/usr/home/bar/mysql-5.0
      
      
      8ec6c354
    • unknown's avatar
      view.result: · 66b4354a
      unknown authored
        Fixed the results of a test for group_concat.
        After the fix foor bug #11639 the results became
        correct.
      olap.result, olap.test:
        Added a test case for bug #11639.
      sql_select.cc:
        Fixed bug #11639: a wrong result set when using a view
        instead of the underlying table in a rollup query 
        executed through filesort.
        The old code did not take into account that we always
        use an Item_ref object when referring to a view column.
      item.h:
        Fixed bug #11639.
        Now if two Item_ref items ref1 and ref2 refer to the same field
        then ref1->eq(ref2) returns 1.
      
      
      sql/item.h:
        Fixed bug #11639.
        Now if two Item_ref items ref1 and ref2 refer to the same field
        then ref1->eq(ref2) returns 1.
      sql/sql_select.cc:
        Fixed bug #11639: a wrong result set when using a view
        instead of the underlying table in a rollup query 
        executed through filesort.
        The old code did not take into account that we always
        use an Item_ref object when referring to a view column.
      mysql-test/t/olap.test:
        Added a test case for bug #11639.
      mysql-test/r/olap.result:
        Added a test case for bug #11639.
      mysql-test/r/view.result:
        Fixed the results of a test for group_concat.
        After the fix foor bug #11639 the results became
        correct.
      66b4354a
    • unknown's avatar
      fix bugs found by gcc 3.4 compiler · 497b8865
      unknown authored
      
      sql/sp_head.h:
        removed unused parameter
      sql/sql_lex.cc:
        make correct operation order
      sql/sql_yacc.yy:
        removed unused parameter
      497b8865
    • unknown's avatar
      sql_table.cc: · 0e6a93ec
      unknown authored
        Bug#11657 Creation of secondary index fails:
      
        If TINYBLOB key part length is 255, it is equal
        to field length. For BLOB, unlike for CHAR/VARCHAR,
        we should keep a non-zero key part length, otherwise
        "BLOB/TEXT column used in key specification without a key length"
        error is produced afterwards.
      
      type_blob.result, type_blob.test:
        fixing tests accordinly
      
      
      sql/sql_table.cc:
        Bug#11657 Creation of secondary index fails
        For TINYBLOB key part length can be equal to field length.
        We should still keep a non-zero key part length,
      mysql-test/t/type_blob.test:
        fixing tests accordinly
      mysql-test/r/type_blob.result:
        fixing tests accordinly
      0e6a93ec