1. 04 Jul, 2006 1 commit
    • unknown's avatar
      A fix and a test case for Bug#17843 "Certain stored procedures fail to · c12cc90d
      unknown authored
      run at startup"
      
      The server returned an error when trying to execute init-file with a 
      stored procedure that could return multiple result sets to the client. 
      A stored procedure can return multiple result sets if it contains 
      PREPARE, SELECT, SHOW and similar statements.
         
      The fix is to set client_capabilites|=CLIENT_MULTI_RESULTS in
      sql_parse.cc:handle_bootstrap(). There is no "client" really, so 
      nothing is ever sent. This makes init-file feature behave consistently: 
      the prepared statements that can be called directly in the init-file 
      can be used in a stored procedure too.
      
      Re-committed the patch originally submitted by Per-Erik after review.
      
      
      mysql-test/Makefile.am:
        Fix re-make without make clean.
      mysql-test/r/init_connect.result:
        Updated results (a test case for Bug#17843)
      mysql-test/r/init_file.result:
        Updated results (a test case for Bug#17843)
      mysql-test/std_data/init_file.dat:
        Add test coverage for new features added in 5.0. Note, that what can 
        be done in init_file is very limited as it does not support any other
        delimiter except ';' -- only "one liners" and no multiple statement 
        procedures. Also, this is executed with a dummy user "boot@", which 
        calls for the use of DEFINER clause.
      mysql-test/t/init_connect.test:
        Add test coverage for new features added in 5.0.
      mysql-test/t/init_file.test:
        Add test coverage for new features added in 5.0 --
        stored routines, views, triggers. The actual tests are in 
        std_data/init_file.dat, here we just check the results and clean up.
      sql/sql_class.cc:
        Initialize Security_context::priv_host to an empty string:
        when executing an init-file, sql_parse.cc:get_default_definer()
        will use this for the value of the definer if it's not set in the query.
      sql/sql_parse.cc:
        Set CLIENT_MULTI_RESULTS in handle_bootstrap(), to make prepared
        statements work in stored procedures called from init-file.
      c12cc90d
  2. 03 Jul, 2006 2 commits
  3. 01 Jul, 2006 3 commits
  4. 30 Jun, 2006 25 commits
    • unknown's avatar
      Merge mysql.com:/home/psergey/mysql-4.1-bug16168-push · c1fa66c3
      unknown authored
      into  mysql.com:/home/psergey/mysql-5.0-bug16168-merge
      
      
      mysql-test/t/range.test:
        Auto merged
      mysql-test/r/range.result:
        SCCS merged
      sql/opt_range.cc:
        SCCS merged
      c1fa66c3
    • unknown's avatar
      Remove an unused variable. · 697e8d71
      unknown authored
      697e8d71
    • unknown's avatar
      Remove a couple of unused/barely used names. · 0c7bc6e9
      unknown authored
      
      sql/sql_lex.cc:
        Remove an unused thread key.
      sql/sql_lex.h:
        Remove an unused thread key, current_lex.
      sql/sql_parse.cc:
        Remove an unused thread key, current_lex macro.
      0c7bc6e9
    • unknown's avatar
      After merge fixes · 0bbc6fbe
      unknown authored
      
      BitKeeper/etc/ignore:
        added scripts/mysql_upgrade_shell
      include/my_handler.h:
        my_handler.h should not include my_global.h
      mysql-test/r/key.result:
        Update results after merge
      0bbc6fbe
    • unknown's avatar
      Merge mysql.com:/home/my/mysql-4.1 · 9606675b
      unknown authored
      into  mysql.com:/home/my/mysql-5.0
      
      
      libmysql/libmysql.c:
        Auto merged
      mysql-test/mysql-test-run.sh:
        Auto merged
      mysql-test/t/key.test:
        Auto merged
      sql/table.cc:
        Auto merged
      mysql-test/r/key.result:
        Manual merge
      mysql-test/t/mysqldump.test:
        Manual merge
        (Now we have same code as in 4.1 and 5.1)
      sql/ha_ndbcluster.cc:
        Manual merge
        Change %ll -> llstr()
      tests/mysql_client_test.c:
        manual merge
      9606675b
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-4.1 · e0171231
      unknown authored
      into  mysql.com:/home/my/mysql-4.1
      
      
      e0171231
    • unknown's avatar
      Merge tulin@bk-internal.mysql.com:/home/bk/mysql-4.1 · a6d2cafd
      unknown authored
      into  poseidon.ndb.mysql.com:/home/tomas/mysql-4.1-main
      
      
      a6d2cafd
    • unknown's avatar
      Reverted wrong bug fix (Bug#11228) · 66a59b10
      unknown authored
      
      mysql-test/r/key.result:
        Fixed result after removing wrong bug fix
      mysql-test/t/key.test:
        Added SHOW CREATE TABLE, which is the proper way to check for table definitions
      sql/table.cc:
        Reverted wrong bug fix.
        The intention with the original code was to show that MySQL treats the first
        given unique key as a primary key. Clients can use the marked primary key as a
        real primary key to validate row changes in case of conflicting updates.  The
        ODBC driver (and other drivers) may also use this fact to optimize/check
        updates and handle conflicts.  The marked key also shows what some engines, like InnoDB or NDB,
        will use as it's internal primary key.
        
        For checking if someone has declared a true PRIMARY KEY, one should use 'SHOW CREATE TABLE'
      66a59b10
    • unknown's avatar
      Merge poseidon.ndb.mysql.com:/home/tomas/mysql-4.1 · e410532a
      unknown authored
      into  poseidon.ndb.mysql.com:/home/tomas/mysql-4.1-main
      
      
      sql/ha_ndbcluster.cc:
        Auto merged
      e410532a
    • unknown's avatar
      adopted ndb handler code for tables without primary key and with unique index · 437afbfd
      unknown authored
      - added missing retrieval of hidden primary key
      
      
      437afbfd
    • unknown's avatar
      Bug#17226: Variable set in cursor on first iteration is assigned · fc085d77
      unknown authored
                 second iterations value
      
      During assignment to the BLOB variable in routine body the value
      wasn't copied.
      
      
      mysql-test/r/sp-vars.result:
        Add result for bug#17226.
      mysql-test/t/sp-vars.test:
        Add test case for bug#17226.
      sql/field_conv.cc:
        Honor copy_blobs flag.
      fc085d77
    • unknown's avatar
      Merge mysqldev@production:my/mysql-5.0-release · b138b55d
      unknown authored
      into  mysql.com:/usr/local/mysql/tmp-5.0
      
      
      include/my_global.h:
        Auto merged
      sql/item_sum.cc:
        Auto merged
      b138b55d
    • unknown's avatar
      Fix Windows build problem following previous push. · 949ad5b4
      unknown authored
      
      strings/strtod.c:
        Fix Windows build problem, EOVERFLOW is defined in my_base.h on Windows.
      949ad5b4
    • unknown's avatar
      Merge mysql.com:/home/tomash/src/mysql_ab/mysql-4.1 · 618bd69d
      unknown authored
      into  mysql.com:/home/tomash/src/mysql_ab/mysql-4.1-bug20152
      
      
      618bd69d
    • unknown's avatar
      bug #20152: mysql_stmt_execute() overwrites parameter buffers · 86155590
      unknown authored
      When using a parameter bind MYSQL_TYPE_DATE in a prepared statement,
      the time part of the MYSQL_TIME buffer was written to zero in
      mysql_stmt_execute(). The param_store_date() function in libmysql.c
      worked directly on the provided buffer.
      Changed to use a copy of the buffer.
      
      
      libmysql/libmysql.c:
        fix for bug #20152
      tests/mysql_client_test.c:
        added test for bug#20152
      86155590
    • unknown's avatar
      Merge mysqldev@production.mysql.com:my/mysql-5.0-release · 4a6a237f
      unknown authored
      into  mysql.com:/usr/local/mysql/mysql-5.0-release
      
      
      4a6a237f
    • unknown's avatar
      BUG#20769: Dangling pointer in ctype_recoding test case. · d9cb536a
      unknown authored
      In some functions dealing with strings and character sets, the wrong
      pointers were saved for restoration in THD::rollback_item_tree_changes().
      This could potentially cause random corruption or crashes.
      
      Fixed by passing the original Item ** locations, not local stack copies.
      
      Also remove unnecessary use of default arguments.
      
      
      sql/item.cc:
        Function agg_item_charsets() now handles non-consequtive Item *'s.
      sql/item.h:
        Remove use of default argument.
      sql/item_cmpfunc.cc:
        Remove use of default argument.
      sql/item_func.cc:
        Remove use of default argument.
      sql/item_func.h:
        Function agg_item_charsets() now handles non-consequtive Item *'s.
      sql/item_strfunc.cc:
        Pass original Item **'s to agg_arg_charsets(), not local copies, to ensure
        proper restoration in THD::rollback_item_tree_changes().
      sql/item_sum.cc:
        Remove use of default argument.
      d9cb536a
    • unknown's avatar
      BUG#16168: Wrong results from range optimizer, "Use_count: Wrong count for key ..." warnings: · 633cbfb5
      unknown authored
       - Added comments.
       - Make SEL_ARG::clone() set SEL_ARG::elements in the created copy.
      
      
      mysql-test/r/range.result:
        BUG#16168: Testcase
      mysql-test/t/range.test:
        BUG#16168: Testcase
      633cbfb5
    • unknown's avatar
      Merge mysql.com:/home/emurphy/src/bk-clean/mysql-4.1 · 29423c2d
      unknown authored
      into  mysql.com:/home/emurphy/src/bk-clean/mysql-5.0
      
      
      configure.in:
        Auto merged
      29423c2d
    • unknown's avatar
      Fixing windows build. · a14c9ddf
      unknown authored
      
      strings/strtod.c:
        Reverting previous change to include files (angle brackets instead of
        quotes) that broke windows build
      a14c9ddf
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · de1499ea
      unknown authored
      into  mysql.com:/home/my/mysql-5.0
      
      
      mysql-test/r/func_sapdb.result:
        Auto merged
      mysql-test/r/func_time.result:
        Auto merged
      mysql-test/r/symlink.result:
        Auto merged
      mysql-test/t/func_sapdb.test:
        Auto merged
      mysql-test/t/func_time.test:
        Auto merged
      sql/item_timefunc.cc:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      de1499ea
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-4.1 · 0343a80b
      unknown authored
      into  mysql.com:/home/my/mysql-4.1
      
      
      0343a80b
    • unknown's avatar
      Merge monty@192.168.0.9:/home/my/mysql-4.1 · c8a5b35d
      unknown authored
      into  mysql.com:/home/my/mysql-4.1
      
      
      c8a5b35d
    • unknown's avatar
      Don't read ~/.my.cnf in mysqldump.test · c5ed64a4
      unknown authored
      
      heap/hp_test1.c:
        Changed type from last commit
      mysql-test/mysql-test-run.sh:
        Fixed problem with running with --gdb and two masters
        Don't disable ndb becasue we run gdb
      mysql-test/t/mysqldump.test:
        Don't read ~/.my.cnf
      sql/ha_ndbcluster.cc:
        Portability fix
      c5ed64a4
    • unknown's avatar
      mysql.spec.sh: · b76a6873
      unknown authored
        Disable old RPM strip
      my_global.h:
        Fixed wrong cast, which caused problems with gcc 4.0 and
        floats in prepared statements (Bug #19694)
      mysqlmanager.vcproj:
        Place output files in common release/debug directory
      
      
      server-tools/instance-manager/mysqlmanager.vcproj:
        Place output files in common release/debug directory
      include/my_global.h:
        Fixed wrong cast, which caused problems with gcc 4.0 and
        floats in prepared statements (Bug #19694)
      support-files/mysql.spec.sh:
        Disable old RPM strip
      b76a6873
  5. 29 Jun, 2006 9 commits
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-4.1 · 6946f03e
      unknown authored
      into  mysql.com:/home/my/mysql-4.1
      
      
      6946f03e
    • unknown's avatar
      Merge mysql.com:/home/my/mysql-4.1 · 2226065b
      unknown authored
      into  mysql.com:/home/my/mysql-5.0
      
      
      include/my_global.h:
        Auto merged
      mysql-test/r/func_sapdb.result:
        Auto merged
      mysql-test/r/symlink.result:
        Auto merged
      mysql-test/t/func_sapdb.test:
        Auto merged
      mysys/my_handler.c:
        Auto merged
      sql/item_timefunc.cc:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      strings/strtod.c:
        Auto merged
      mysql-test/r/func_time.result:
        Manual merge
      mysql-test/t/func_time.test:
        Manual merge
      2226065b
    • unknown's avatar
      Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-4.1 · 2a100c1c
      unknown authored
      into sunlight.local:/local_work/autopush/merge-4.1
      
      
      2a100c1c
    • unknown's avatar
      Fixed include file usage · 77deeb7e
      unknown authored
      hp_test2 now works again
      Fixed wrong cast, which caused problems with gcc 4.0 and floats in prepared statements (Bug #19694)
      
      
      heap/hp_test1.c:
        Portability fix
      heap/hp_test2.c:
        Added max_table_size (fixes that hp_test2 works again)
      include/my_global.h:
        Fixed wrong cast, which caused problems with gcc 4.0 (Bug #19694)
      mysys/my_handler.c:
        Added missing include file
      strings/strtod.c:
        Fixed include files
      77deeb7e
    • unknown's avatar
      Merge · 3cf92fb7
      unknown authored
      
      mysql-test/r/func_sapdb.result:
        Auto merged
      mysql-test/r/symlink.result:
        Auto merged
      mysql-test/t/func_sapdb.test:
        Auto merged
      sql/item_timefunc.cc:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      mysql-test/r/func_time.result:
        SCCS merged
      mysql-test/t/func_time.test:
        SCCS merged
      3cf92fb7
    • unknown's avatar
      Merge moonbone.local:/home/evgen/bk-trees/mysql-5.0-opt · 6ea7aafc
      unknown authored
      into moonbone.local:/work/merge-5.0
      
      
      sql/sql_select.cc:
        Auto merged
      strings/ctype-mb.c:
        Auto merged
      6ea7aafc
    • unknown's avatar
      Merge poseidon.ndb.mysql.com:/home/tomas/mysql-5.0-main · 7bc46be1
      unknown authored
      into  poseidon.ndb.mysql.com:/home/tomas/5.0-merge
      
      
      sql/ha_ndbcluster.cc:
        Auto merged
      7bc46be1
    • unknown's avatar
      Merge tulin@bk-internal.mysql.com:/home/bk/mysql-5.0 · 96a14ba2
      unknown authored
      into  poseidon.ndb.mysql.com:/home/tomas/5.0-merge
      
      
      96a14ba2
    • unknown's avatar
      Merge mysql.com:/mnt/storeage/mysql-4.1 · 194c6348
      unknown authored
      into  mysql.com:/mnt/storeage/mysql-4.1_bug19298
      
      
      194c6348