1. 12 Jul, 2005 1 commit
    • unknown's avatar
      Fix bug #11399 Column alias was lost during view preraration. · 24a77123
      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
      24a77123
  2. 04 Jul, 2005 1 commit
    • unknown's avatar
      After merge fixes · 90949a31
      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
      90949a31
  3. 03 Jul, 2005 1 commit
    • unknown's avatar
      Merge with 4.1 · 1e0d23f2
      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
      1e0d23f2
  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 · a4a0c8e9
      unknown authored
      into mysql.com:/Users/kent/mysql/bk/mysql-4.1
      
      a4a0c8e9
    • unknown's avatar
      row0sel.c: · 583ef1e0
      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
      583ef1e0
    • unknown's avatar
      Merge heikki@bk-internal.mysql.com:/home/bk/mysql-5.0 · 72b7a834
      unknown authored
      into hundin.mysql.fi:/home/heikki/mysql-5.0
      
      72b7a834
    • unknown's avatar
      trx0trx.h, trx0trx.ic, row0mysql.c: · 5f7c17aa
      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
      5f7c17aa
    • unknown's avatar
      trx0trx.ic, trx0trx.h: · 122bf0b8
      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
      122bf0b8
    • unknown's avatar
      Many files: · 3f767b74
      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
      3f767b74
    • unknown's avatar
      Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.1 · 3155e1d8
      unknown authored
      into sanja.is.com.ua:/home/bell/mysql/bk/work-bug5-4.1
      
      3155e1d8
    • unknown's avatar
    • unknown's avatar
      Merge svojtovich@bk-internal.mysql.com:/home/bk/mysql-5.0 · 913c284b
      unknown authored
      into mysql.com:/home/svoj/devel/mysql/yassl1-mysql-5.0
      
      913c284b
    • unknown's avatar
      Merge mysql.com:/usr/local/bk/mysql-5.0 · ffe8b4a5
      unknown authored
      into  mysql.com:/home/pem/work/mysql-5.0
      
      ffe8b4a5
    • unknown's avatar
      Fix a crash I introduced by the last push. · 2a098108
      unknown authored
      2a098108
    • unknown's avatar
      WL#2286 - Compile MySQL w/YASSL support · 34d2361f
      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.
      34d2361f
    • unknown's avatar
      Merge mysql.com:/usr/local/bk/mysql-5.0 · 9faa680a
      unknown authored
      into  mysql.com:/home/pem/work/mysql-5.0
      
      9faa680a
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 4754f06a
      unknown authored
      into neptunus.(none):/home/msvensson/mysql/mysql-5.0
      
      4754f06a
    • unknown's avatar
      Merge mysql.com:/usr/local/bk/mysql-5.0 · 2206585a
      unknown authored
      into  mysql.com:/home/pem/work/mysql-5.0
      
      2206585a
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 6dd943ad
      unknown authored
      into  mysql.com:/opt/local/work/mysql-5.0-11172-new
      
      
      sql/sql_select.cc:
        Auto merged
      6dd943ad
    • unknown's avatar
      Fix a valgrind warning. · bebdaf7c
      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).
      bebdaf7c
    • unknown's avatar
      Merge ibabaev@bk-internal.mysql.com:/home/bk/mysql-5.0 · 9daab53b
      unknown authored
      into rurik.mysql.com:/home/igor/mysql-5.0
      
      
      sql/sql_select.cc:
        Auto merged
      9daab53b
    • unknown's avatar
      Merge neptunus.(none):/home/msvensson/mysql/mysql-4.1-1.2310.2.2 · 66edef91
      unknown authored
      into neptunus.(none):/home/msvensson/mysql/mysql-5.0
      
      
      client/mysqltest.c:
        Auto merged
      66edef91
    • unknown's avatar
      Merge neptunus.(none):/home/msvensson/mysql/mysql-4.1-1.2310.2.2 · 98eb2e04
      unknown authored
      into neptunus.(none):/home/msvensson/mysql/mysql-4.1
      
      
      client/mysqltest.c:
        Auto merged
      98eb2e04
    • unknown's avatar
      Win port fixes · dc2a35de
      unknown authored
      
      client/mysqltest.c:
        Check for HAVE_SYS_WAIT_H
        Define WEXITSTATUS if not defined
      dc2a35de
    • unknown's avatar
      Disabled the GOTO feature. (It's non-standard and undocumented.) · 614a6fbb
      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).
      614a6fbb
    • unknown's avatar
      tests/mysql_client_test.c · d7368614
      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.
      d7368614
    • unknown's avatar
      - fix -ansi -pedantic error · f5690e4b
      unknown authored
      f5690e4b
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · 90f60a26
      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
      90f60a26
    • unknown's avatar
      A fix and a test case for Bug#11172 "mysql_stmt_attr_set · 12cf1bec
      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"
      12cf1bec
    • unknown's avatar
      Merge rurik.mysql.com:/home/igor/mysql-5.0 · acc5294e
      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
      acc5294e
    • unknown's avatar
      Merge abarkov@bk-internal.mysql.com:/home/bk/mysql-5.0 · 81c12ae8
      unknown authored
      into mysql.com:/usr/home/bar/mysql-5.0
      
      81c12ae8
    • unknown's avatar
      view.result: · 6422def9
      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.
      6422def9
    • unknown's avatar
      fix bugs found by gcc 3.4 compiler · a17ee9fa
      unknown authored
      
      sql/sp_head.h:
        removed unused parameter
      sql/sql_lex.cc:
        make correct operation order
      sql/sql_yacc.yy:
        removed unused parameter
      a17ee9fa
    • unknown's avatar
      sql_table.cc: · 644e2497
      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
      644e2497