An error occurred fetching the project authors.
  1. 17 Oct, 2003 1 commit
    • unknown's avatar
      Bugfix. Local variables are now initialized to null. · 82e5115a
      unknown authored
      mysql-test/r/sp.result:
        New test case for bugfix (when a variable is not set due to an exception).
      mysql-test/t/sp.test:
        New test case for bugfix (when a variable is not set due to an exception).
      sql/item.h:
        Local variables are initialized to null.
      sql/sp_head.cc:
        Local variables are initialized to null.
      82e5115a
  2. 16 Oct, 2003 1 commit
    • unknown's avatar
      Handle user variables (@-vars) as OUT and INOUT parameters in SPs. · 12a0546d
      unknown authored
      mysql-test/r/sp.result:
        Test cases for user variables (@-vars) as OUT and INOUT parameters.
      mysql-test/t/sp.test:
        Test cases for user variables (@-vars) as OUT and INOUT parameters.
      sql/item_func.h:
        We need to be able to detect Item_func_get_user_vars when used as arguments to SPs.
      sql/sp_head.cc:
        Handle user variables (@-vars) as OUT and INOUT parameters.
        But we still just ignore it, if it's anything else.
      12a0546d
  3. 15 Oct, 2003 1 commit
    • unknown's avatar
      Fix for BUG#1547: "SELECT ... WHERE field = var" sometimes give the wrong result in SPs · 9aa680a0
      unknown authored
      Two missing methods added to Item_splocal + test case.
      
      
      mysql-test/r/sp.result:
        Test case for BUG#1547
      mysql-test/t/sp.test:
        Test case for BUG#1547
      sql/item.h:
        Fix for BUG#1547: "SELECT ... WHERE field = var" sometimes give the wrong result in SPs
        
        Added missing methods to Item_splocal to get the correct compare function
        and make the optimizer do the right thing.
      9aa680a0
  4. 14 Oct, 2003 1 commit
    • unknown's avatar
      Fix for BUG#1495: Evaluate items before setting a local variable with SELECT INTO. · 776784b8
      unknown authored
      Also copy and restore order_list and group_list for selects in SPs.
      
      
      mysql-test/r/sp.result:
        Test for BUG#1495, and an additional cursor test.
      mysql-test/t/sp.test:
        Test for BUG#1495, and an additional cursor test.
      sql/sp_head.cc:
        Fix BUG#1495: renamed eval_func_item() into sp_eval_func_item() and made it
        non-static.
        Also need to copy and restore order_list and group_list pointers before and
        after execution of a substatement. (Which means these must always be properly
        initialized for all queries.)
      sql/sp_rcontext.cc:
        Fix BUG#1495: Evaluate and set a local variable (for SELECT INTO).
      sql/sp_rcontext.h:
        Fix BUG#1495: Evaluate and set a local variable (for SELECT INTO).
      sql/sql_class.cc:
        Fix BUG#1495: Evaluate and set a local variable (for SELECT INTO).
      sql/sql_class.h:
        Fix BUG#1495: Evaluate and set a local variable (for SELECT INTO); need type for this.
      sql/sql_parse.cc:
        order_list and group_list must be initialized in select_lex for all queries,
        to make SP sub statement execution work.
      sql/sql_yacc.yy:
        Type needed for setting local variables.
      sql/table.h:
        Need a copy of the Item* pointer when executing sub-statements in SPs. (Since
        it's modified and must be restored afterwards.)
      776784b8
  5. 10 Oct, 2003 1 commit
    • unknown's avatar
      WL#962: Added simple, read-only, non-scrolling, asensitive cursors in SPs, using the · 04c6b9b8
      unknown authored
      (updated) Protocol_cursor class.
      Also did some bug fixes.
      
      
      Docs/sp-imp-spec.txt:
        Added CURSOR docs (and fixed typos)
      Docs/sp-implemented.txt:
        Updated for CURSORs
      include/mysqld_error.h:
        New error codes/messages for CURSORs
      libmysqld/Makefile.am:
        SP cursors now needs this.
      mysql-test/r/sp-error.result:
        New tests for cursors.
      mysql-test/r/sp.result:
        New tests for cursors.
      mysql-test/t/sp-error.test:
        New tests for cursors.
      mysql-test/t/sp.test:
        New tests for cursors.
      sql/protocol.cc:
        We now always have Protocol_cursor (SPs use it)
      sql/protocol.h:
        Fixed bugs in Protocol_cursor (for SPs)
      sql/protocol_cursor.cc:
        Fixed bugs in Protocol_cursor (for SPs)
      sql/share/czech/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/danish/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/dutch/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/english/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/estonian/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/french/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/german/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/greek/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/hungarian/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/italian/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/japanese/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/korean/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/norwegian-ny/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/norwegian/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/polish/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/portuguese/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/romanian/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/russian/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/serbian/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/slovak/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/spanish/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/swedish/errmsg.txt:
        New error codes/messages for CURSORs
      sql/share/ukrainian/errmsg.txt:
        New error codes/messages for CURSORs
      sql/sp_head.cc:
        Added cursor support.
        Also fixed problems with item_lists, where pointers and ref_pointer_arrays.
      sql/sp_head.h:
        Added cursor support
      sql/sp_pcontext.cc:
        Added cursor support
      sql/sp_pcontext.h:
        Added cursor support
      sql/sp_rcontext.cc:
        Added cursor support, in particular the new sp_cursor class.
      sql/sp_rcontext.h:
        Added cursor support, in particular the new sp_cursor class.
      sql/sql_lex.h:
        We sometimes need to copy item_lists in LEX when executing substatements in SPs
      sql/sql_yacc.yy:
        Added minimal cursor support (not the full syntax yet).
      04c6b9b8
  6. 03 Oct, 2003 1 commit
    • unknown's avatar
      Fixed BUG#822: Copying and clearing some things in thd/lex when · 869b49ef
      unknown authored
      executing sub-statements (selects) prevents crashes intermittent
      crashes.
      Also fixed bug in sql_yacc.yy (generated a hpop instruction when
      not needed).
      
      
      mysql-test/r/sp.result:
        Test-case for BUG#822.
      mysql-test/t/sp.test:
        Test-case for BUG#822.
      sql/sp_head.cc:
        Fixed BUG#822; needed to copy and clear some stuff when calling sub-statements.
      sql/sql_yacc.yy:
        Only generate hpop instruction when we actually have handlers.
      869b49ef
  7. 16 Sep, 2003 1 commit
    • unknown's avatar
      Implemented SP CONDITIONs and HANDLERs, with the extension of handling · 4deedf62
      unknown authored
      MySQL error codes as well.
      (No UNDO HANDLERs yet, and no SIGNAL or RESIGNAL.)
      WL#850
      
      
      Docs/sp-imp-spec.txt:
        Spec of CONDITIONs and HANDLERs (and updated some old stuff too).
      Docs/sp-implemented.txt:
        Updated info about caching, CONDITIONs and HANDLERs.
      include/mysqld_error.h:
        New error for undeclared CONDITION.
      libmysqld/Makefile.am:
        New file: sp_rcontext.cc.
      mysql-test/r/sp-error.result:
        New tests for CONDITIONs and HANDLERs.
      mysql-test/r/sp.result:
        New tests for CONDITIONs and HANDLERs.
      mysql-test/t/sp-error.test:
        New tests for CONDITIONs and HANDLERs.
      mysql-test/t/sp.test:
        New tests for CONDITIONs and HANDLERs.
      sql/Makefile.am:
        New file: sp_rcontext.cc.
      sql/lex.h:
        New symbols for CONDITIONs, HANDLERs and CURSORs.
      sql/mysqld.cc:
        Catch error if we have a handler for it.
      sql/protocol.cc:
        Catch error if we have a handler for it.
      sql/share/czech/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/danish/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/dutch/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/english/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/estonian/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/french/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/german/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/greek/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/hungarian/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/italian/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/japanese/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/korean/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/norwegian-ny/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/norwegian/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/polish/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/portuguese/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/romanian/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/russian/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/serbian/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/slovak/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/spanish/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/swedish/errmsg.txt:
        New error for undeclared CONDITION.
      sql/share/ukrainian/errmsg.txt:
        New error for undeclared CONDITION.
      sql/sp_head.cc:
        New HANDLER code.
      sql/sp_head.h:
        New HANDLER code.
      sql/sp_pcontext.cc:
        New CONDITION and HANDLER code.
      sql/sp_pcontext.h:
        New CONDITION and HANDLER code.
      sql/sp_rcontext.h:
        New CONDITION and HANDLER code.
      sql/sql_yacc.yy:
        New CONDITION and HANDLER code.
      4deedf62
  8. 23 May, 2003 1 commit
    • unknown's avatar
      Adopt SP stuff to the new lex pointer. · 8ea9613e
      unknown authored
      mysql-test/r/sp.result:
        New test (of more call levels).
      mysql-test/t/sp.test:
        New test (of more call levels).
      sql/mysql_priv.h:
        SPs wants to init lex only.
      sql/sp.cc:
        Restore lex pointer (and fixed memory leak).
      sql/sp_head.cc:
        lex is now a pointer, so reset things the right way.
      sql/sp_head.h:
        lex is now a pointer.
      sql/sql_lex.h:
        SPs wants to init lex only.
      sql/sql_parse.cc:
        SPs wants to init lex only.
      sql/sql_prepare.cc:
        Restore lex pointer.
      8ea9613e
  9. 27 Apr, 2003 1 commit
    • unknown's avatar
      Post-fix of bug #302 fix. · 64cad16f
      unknown authored
      Fixed bug #320.
      Some new tests and cosmetic changes.
      Another strcasecmp() replaced.
      
      
      mysql-test/r/sp.result:
        Moved SP tests from subselect and added some more.
      mysql-test/r/subselect.result:
        Moved SP tests to sp.test.
      mysql-test/t/sp.test:
        Moved SP tests from subselect and added some more.
      mysql-test/t/subselect.test:
        Moved SP tests to sp.test.
      sql/sp.cc:
        Don't close derived tables.
      sql/sp_head.cc:
        Minor layout and comment fix.
      sql/sp_head.h:
        Minor comment fix.
      sql/sql_derived.cc:
        Don't set org_table_list->derived to 1 when debugging, as this breaks certain
        subselect args to SPs.
      sql/sql_parse.cc:
        Post-fix of bugfix (free memory on error), and added comment.
      sql/sql_yacc.yy:
        Another strcasecmp() replaced.
      64cad16f
  10. 04 Apr, 2003 1 commit
    • unknown's avatar
      Post merge fixes. · cfd69393
      unknown authored
      mysql-test/r/sp.result:
        Enabled the cs test as it works now.
      mysql-test/t/sp.test:
        Enabled the cs test as it works now.
      cfd69393
  11. 02 Apr, 2003 1 commit
  12. 30 Mar, 2003 1 commit
  13. 26 Mar, 2003 1 commit
  14. 20 Mar, 2003 1 commit
  15. 19 Mar, 2003 1 commit
    • unknown's avatar
      Post-merge fixes. · addf8ea0
      unknown authored
      mysql-test/r/sp.result:
        Post-merge fixes.
        (And disabled the ip test, since some change in 4.1 broke it.)
      mysql-test/t/sp.test:
        Post-merge fixes.
        (And disabled the ip test, since some change in 4.1 broke it.)
      addf8ea0
  16. 06 Mar, 2003 1 commit
    • unknown's avatar
      Fixed reentrantness bugs in select (lex->result) and select_dumpvar, and added cool · 6b3c8986
      unknown authored
      prime number test example.
      
      
      mysql-test/r/sp.result:
        New prime number example. (Good for future benchmarkings too.)
      mysql-test/t/sp.test:
        New prime number example. (Good for future benchmarkings too.)
      sql/sql_class.cc:
        Reset row_count in select_dumpvar when preparing, to make it reentrant as a lex member.
      sql/sql_select.cc:
        Don't delete result if it's a lex member (since lex needs to be reentrant).
      6b3c8986
  17. 05 Mar, 2003 1 commit
    • unknown's avatar
      Improved error handling regarding SPs (with info like names etc in the output). · f74b36a2
      unknown authored
      Disabled queries in FUNCTIONs.
      
      
      include/mysqld_error.h:
        New error message for queries in FUNCTIONs.
      mysql-test/t/sp.test:
        Moved error tests to sp-error.test.
      sql/share/czech/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/danish/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/dutch/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/english/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/estonian/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/french/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/german/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/greek/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/hungarian/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/italian/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/japanese/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/korean/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/norwegian-ny/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/norwegian/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/polish/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/portuguese/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/romanian/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/russian/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/serbian/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/slovak/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/spanish/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/swedish/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/share/ukrainian/errmsg.txt:
        New error message for queries in FUNCTIONs.
        Improved most of the SP error messages with added info.
      sql/sp_head.cc:
        Added debug output to sp_instr_jump::execute(). (Moved from sp_head.h)
      sql/sp_head.h:
        Moved sp_instr_jump::execute() to sp_head.cc.
      sql/sql_lex.h:
        Added SQLCOM_CREATE_SPFUNCTION (for improved error handling).
      sql/sql_parse.cc:
        Improved error handling regarding SPs (adding info like names etc in output).
      sql/sql_yacc.yy:
        Improved error handling regarding SPs (adding info like names etc in output).
        Disabled queries in FUNCTIONS (since it can't work anyway).
      f74b36a2
  18. 03 Mar, 2003 1 commit
    • unknown's avatar
      New FUNCTION documentation, and a minor test case modification. · f519382d
      unknown authored
      Docs/sp-imp-spec.txt:
        Updated docs about stored FUNCTIONs.
      Docs/sp-implemented.txt:
        Updated docs about stored FUNCTIONs.
      mysql-test/r/sp.result:
        Changed the ifac test example into a combination of a procedure and a function.
      mysql-test/t/sp.test:
        Changed the ifac test example into a combination of a procedure and a function.
      f519382d
  19. 02 Mar, 2003 1 commit
    • unknown's avatar
      Made FUNCTIONs work in insert and select queries, as well as nested function invocations. · 8a9422bd
      unknown authored
      Had to add a cahing mechanism which is in parts an ugly kludge, but it will be
      reworked once the real SP caching is implemented.
      
      
      mysql-test/r/sp.result:
        New function tests.
      mysql-test/t/sp.test:
        New function tests.
      sql/sp.cc:
        Big rehack of mysql.proc table usage strategy and adding a function cache
        mechanism, since we need to read used functions from the db before doing anything else
        when executing a query. (This cache is temporary and will probably be replaced by
        the real thing later.)
      sql/sp.h:
        New (temporary) FUNCTION caching functions.
      sql/sp_head.cc:
        Fixed some bugs in the function and procedure execution.
        Disabled some data collections that's not used at the moment.
      sql/sp_head.h:
        Fixed some bugs in the function and procedure execution.
        Disabled some data collections that's not used at the moment.
      sql/sql_class.h:
        Added SP function cache list to thd.
      sql/sql_lex.cc:
        Added SP function name list to lex.
      sql/sql_lex.h:
        Added SP function name list to lex.
      sql/sql_parse.cc:
        Read used FUNCTIONs from db and cache them in thd before doing anything else
        in a query execution. (This is necessary since we can't open mysql.proc during
        query execution.)
      sql/sql_yacc.yy:
        Collect used function names in lex.
      8a9422bd
  20. 27 Feb, 2003 1 commit
    • unknown's avatar
      A small step forward. Fixed a few bugs and made string type functions work, · aecc6a21
      unknown authored
      but still strange interferences between multiple function invocations...
      
      
      mysql-test/r/sp.result:
        New FUNCTION tests.
      mysql-test/t/sp.test:
        New FUNCTION tests.
      sql/item_func.cc:
        Fixed field_type bug; now string functions work too.
        Removed unecessary function which was added in a state of confusion.
      sql/item_func.h:
        Fixed field_type bug; now string functions work too.
        Removed unecessary function which was added in a state of confusion.
      sql/sp_head.cc:
        Fixed string type bug, and set the right charset.
      aecc6a21
  21. 26 Feb, 2003 1 commit
    • unknown's avatar
      Made stored FUNCTION invokation work almost always. Still buggy and unstable, and · 76b037dc
      unknown authored
      various known problems, but good enough for a checkpoint commit.
      
      
      mysql-test/r/sp.result:
        New tests for invoking simple FUNCTIONs.
      mysql-test/t/sp.test:
        New tests for invoking simple FUNCTIONs.
      sql/item_func.cc:
        New Item_func_sp for stored FUNCTIONs.
      sql/item_func.h:
        New Item_func_sp for stored FUNCTIONs.
      sql/sp.cc:
        Close mysql.proc table earlier so recursive find_function calls work.
        Added temporary sp_function_exists() function for checking without parsing.
      sql/sp.h:
        Added temporary sp_function_exists() function for checking without parsing.
      sql/sp_head.cc:
        New code for executing a FUNCTION. (And reworked some of the old code in the process.)
      sql/sp_head.h:
        New code for executing a FUNCTION.
      sql/sp_rcontext.h:
        Added result slot for FUNCTIONs.
      sql/sql_lex.cc:
        Added check for stored FUNCTION, analogous to UDFs.
      sql/sql_parse.cc:
        sp_head::execute was renamed into execute_procedure.
      sql/sql_yacc.yy:
        Added parsing of stored FUNCTION invocation and code generation for RETURN statement.
      76b037dc
  22. 21 Feb, 2003 1 commit
    • unknown's avatar
      Most of the groundwork for sprint task 729 (implement FUNCTIONs). · 0521fb54
      unknown authored
      Expanded the mysql.proc table, reworked the find/create/drop functions
      completely, added new functions for FUNCTIONs (lotta functions here :),
      got rid of some unnecessary use of Item_strings while at it. Extended
      the parser correspondingly, and fiddled around a bit to make SP FUNCTIONs
      coexist with UDFs.
      Can now CREATE and DROP FUNCTIONs. Invoking yet to come...
      
      
      Docs/sp-implemented.txt:
        Updated with info about CASCADE/RESTICT and METHOD, and some answers to questions.
      include/mysqld_error.h:
        New error message for misuse of RETURN.
      mysql-test/install_test_db.sh:
        Added enum field to mysql.proc to distinguish between FUNCTION and PROCEDURE.
      mysql-test/r/sp.result:
        New test for creating and dropping FUNCTIONS.
      mysql-test/t/sp.test:
        New test for creating and dropping FUNCTIONS.
      scripts/mysql_install_db.sh:
        Added enum field to mysql.proc to distinguish between FUNCTION and PROCEDURE.
      sql/lex.h:
        De-UDFed some symbol names, as they are now used for SPs as well.
        Added RETURN_SYM.
      sql/share/czech/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/danish/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/dutch/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/english/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/estonian/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/french/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/german/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/greek/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/hungarian/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/italian/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/japanese/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/korean/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/norwegian-ny/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/norwegian/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/polish/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/portuguese/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/romanian/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/russian/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/serbian/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/slovak/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/spanish/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/swedish/errmsg.txt:
        New error message for misuse of RETURN.
      sql/share/ukrainian/errmsg.txt:
        New error message for misuse of RETURN.
      sql/sp.cc:
        Major rehack to accomodate FUNCTIONs, and to make it easier to add
        future in-memory cache of prepared SPs.
      sql/sp.h:
        Major rehack to accomodate FUNCTIONs, and to make it easier to add
        future in-memory cache of prepared SPs.
      sql/sp_head.cc:
        Now creates FUNCTIONs too. (And got rid of some unnecessary Item_string use.)
      sql/sp_head.h:
        Now creates FUNCTIONs too. (And got rid of some unnecessary Item_string use.)
      sql/sql_lex.h:
        New stored FUNCTION commands.
      sql/sql_parse.cc:
        Added FUNCTION support ("drop" merged with the old UDF code), and made some
        additional changes for better error handling (following the sp.cc rehacking).
      sql/sql_yacc.yy:
        Some former UDF specific symbols renamed.
        Added CREATE FUNCTION parsing.
        DROP FUNCTION had to be partly merged with the old UDF code, because of the similar
        syntax.
        RETURN statement added, but still a no-op.
      0521fb54
  23. 19 Feb, 2003 1 commit
    • unknown's avatar
      Fixed SELECT INTO OUTFILE/DUMPFILE and stored procedures, and extended and · 3c88ebdc
      unknown authored
      reorganized the sp.test file.
      
      
      mysql-test/r/sp.result:
        New results from the reorganized sp.test file.
      mysql-test/t/sp.test:
        Reorganized the tests, and added a few new ones. ("fac" and more "select into")
      sql/sql_class.cc:
        Unlock tables and set thd->lock=0 in select_export::send_eof() and
        select_dump::send_eof().
        This fixes a problem with an assert() in lock_tables(), and made
        SELECT ... INTO OUTFILE and ... INTO DUMPFILE work in stored procedures.
      3c88ebdc
  24. 02 Feb, 2003 1 commit
    • unknown's avatar
      Added another select into test. · f8b7968e
      unknown authored
      mysql-test/r/sp.result:
        Added another test for select into (mixed variable types), and made into_test
        independent of previous tests.
      mysql-test/t/sp.test:
        Added another test for select into (mixed variable types), and made into_test
        independent of previous tests.
      f8b7968e
  25. 23 Jan, 2003 2 commits
    • unknown's avatar
      Added check for selects without into in SPs, and updated error messages and tests · cbc75706
      unknown authored
      accordingly.
      
      
      include/mysqld_error.h:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/czech/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/danish/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/dutch/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/english/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/estonian/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/french/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/german/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/greek/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/hungarian/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/italian/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/japanese/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/korean/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/norwegian-ny/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/norwegian/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/polish/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/portuguese/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/romanian/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/russian/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/serbian/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/slovak/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/spanish/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/swedish/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      sql/share/ukrainian/errmsg.txt:
        Added bad select in SP error (and fixed leave/iterate label mismatch error).
      mysql-test/r/sp.result:
        New test for repeat(...) and select with and without into in SPs.
      mysql-test/t/sp.test:
        New test for repeat(...) and select with and without into in SPs.
      sql/sql_yacc.yy:
        Check if an SP substatement is a SELECT and if so, has an INTO. If not, it's an
        error.
      cbc75706
    • unknown's avatar
      solve the lex conflict between the existing repeat() function · 172dc5b3
      unknown authored
      and repeat SP-construction
      
      
      172dc5b3
  26. 20 Jan, 2003 1 commit
  27. 18 Jan, 2003 1 commit
  28. 17 Jan, 2003 1 commit
    • unknown's avatar
      Added the Stored Procedure tests. · 838303a7
      unknown authored
      Removed newly added, but now redundant, test file.
      
      
      
      BitKeeper/deleted/.del-mysql_proc.result~63faae2f407c3fc2:
        Delete: mysql-test/r/mysql_proc.result
      BitKeeper/deleted/.del-mysql_proc.test~8863f59cfc347469:
        Delete: mysql-test/t/mysql_proc.test
      838303a7