An error occurred fetching the project authors.
  1. 16 Dec, 2003 1 commit
    • unknown's avatar
      Forgot to wrap things in #ifndef NO_EMBEDDED_ACCESS_CHECKS for the embedded server. · 241bb226
      unknown authored
      Added missing cleanup in sp-security.test.
      
      
      mysql-test/r/sp-security.result:
        Added clean-up.
      mysql-test/t/sp-security.test:
        Added clean-up.
      sql/item_func.cc:
        Forgot to wrap things in #ifndef NO_EMBEDDED_ACCESS_CHECKS for the embedded server.
      sql/sp_head.cc:
        Forgot to wrap things in #ifndef NO_EMBEDDED_ACCESS_CHECKS for the embedded server.
      sql/sp_head.h:
        Forgot to wrap things in #ifndef NO_EMBEDDED_ACCESS_CHECKS for the embedded server.
      sql/sql_parse.cc:
        Forgot to wrap things in #ifndef NO_EMBEDDED_ACCESS_CHECKS for the embedded server.
      241bb226
  2. 15 Dec, 2003 1 commit
    • unknown's avatar
      Fixed various memory leaks. · 1d77c041
      unknown authored
      sql/sp.cc:
        Fixed memory leaks. Deletion of sps now in sp_cache.
      sql/sp_cache.cc:
        Fixed memory leaks. Use implicit delete of objects to make sure
        they're always freed.
      sql/sp_cache.h:
        Fixed memory leaks. Use implicit delete of objects to make sure
        they're always freed.
      sql/sp_head.cc:
        Fixed memory leaks. Make sure we use the right mem_root during parsing.
      sql/sp_head.h:
        Fixed memory leaks. Make sure we use the right mem_root during parsing.
      sql/sql_parse.cc:
        Fixed memory leaks. Don't forget to free the temporary object created at definition.
      sql/sql_yacc.yy:
        Fixed memory leaks. Make sure we use the right mem_root during parsing.
      1d77c041
  3. 13 Dec, 2003 1 commit
    • unknown's avatar
      WL#1365: Implement definer's rights execution of stored procedures. · a6f85eea
      unknown authored
      (Also put the hostpart back in the definer column.)
      
      
      mysql-test/r/sp-error.result:
        Moved error test from sp.test
      mysql-test/r/sp.result:
        Moved error test to sp-error.test.
        Put hostpart back into definer column in mysql.proc.
      mysql-test/t/sp-error.test:
        Moved error test from sp.test
      mysql-test/t/sp.test:
        Moved error test to sp-error.test.
        Put hostpart back into definer column in mysql.proc.
      sql/item_func.cc:
        (Maybe) switch security context before invoking a stored function.
      sql/sp.cc:
        Renamed creator into definer, for more consistent terminology, and put the
        hostpart back.
      sql/sp_head.cc:
        Some fixes in the way things are allocated, and moved set_info() definition
        here from sp_head.h. creator is now called definer, and is split into a
        user and host part.
        Added functions for (possible) change and restore of privileges, for sql security
        definer calls.
      sql/sp_head.h:
        Moved set_info() definition here from sp_head.h.
        creator is now called definer, and is split into a user and host part.
        Added functions for (possible) change and restore of privileges, for sql security
        definer calls.
      sql/sql_acl.cc:
        New function acl_getroot_no_password() for getting the privileges used when
        calling an SP with sql security definer.
      sql/sql_acl.h:
        New function acl_getroot_no_password() for getting the privileges used when
        calling an SP with sql security definer.
      sql/sql_parse.cc:
        (Maybe) switch security context before invoking a stored procedure.
      sql/sql_yacc.yy:
        Fixed typo.
      a6f85eea
  4. 12 Dec, 2003 1 commit
    • unknown's avatar
      In order to make ALTER PROCEDURE|FUNCTION work correctly, and in general to · cabd28c6
      unknown authored
      make characteristics (and SHOW) work right, we had to separate the old
      definition blob in the mysql.proc table into separate fields for parameters,
      return type, and body, and handle the characteristics (like SQL SECURITY)
      separately... and then reassemble the CREATE string for parsing, of course.
      This is rather ugly, mostly the parser bit. (Hopefully that will be better
      with the new parser.)
      
      
      Docs/sp-imp-spec.txt:
        Separated the definitions string of the procedure into different columns
        in the mysql.proc schema.
      mysql-test/r/sp.result:
        New characteristics tests.
      mysql-test/t/sp.test:
        New characteristics tests.
      scripts/mysql_create_system_tables.sh:
        Separated the definitions string of the procedure into different columns
        in the mysql.proc schema.
      scripts/mysql_fix_privilege_tables.sql:
        Separated the definitions string of the procedure into different columns
        in the mysql.proc schema.
      sql/sp.cc:
        Separated the definitions string of the procedure into different columns.
        Rewrote much of the code related this (have a assemble the definition
        string from its different parts now) and the way characteristics are now
        handled, in order to make ALTER actually work.
      sql/sp.h:
        Changed prototypes.
      sql/sp_head.cc:
        Rewrote much of the code related to the new mysql.proc schema with separate
        definition fields (have to assemble the definition string from its different
        parts now) and the way characteristics are now handled, in order to make ALTER
        actually work.
      sql/sp_head.h:
        Separated the different parts of the definition strings: name, parameters,
        return type (for functions) and body.
      sql/sql_yacc.yy:
        Separated the different parts of the definition strings: name, parameters,
        return type (for functions) and body.
        This is ugly and messy; hopefully there's a more elegant way to do this
        when the new parser is installed.
      cabd28c6
  5. 10 Dec, 2003 1 commit
    • unknown's avatar
      WL#1363: Update the mysql.proc table and add new fields. · 3702a1db
      unknown authored
      Also made the parsing and handling of SP characteristics
      more general and extendable, and added a few ch:istics.
      
      
      Docs/sp-imp-spec.txt:
        Updated spec with new schema.
      Docs/sp-implemented.txt:
        Added info about ALTER and SHOW.
      mysql-test/r/sp.result:
        Minor change in SHOW FUNCTION|PROCEDURE STATUS output.
      scripts/mysql_create_system_tables.sh:
        New mysql.proc schema.
      scripts/mysql_fix_privilege_tables.sql:
        New mysql.proc schema.
      sql/lex.h:
        New lex words for SP characteristics.
      sql/sp.cc:
        New mysql.proc schema.
        Also made the characteristics handling slightly more extendable.
      sql/sp.h:
        Made the characteristics handling slightly more extendable.
      sql/sp_head.cc:
        Made the characteristics handling slightly more extendable.
      sql/sp_head.h:
        Made the characteristics handling slightly more extendable.
      sql/sql_lex.h:
        Made the characteristics handling slightly more extendable.
      sql/sql_parse.cc:
        Made the characteristics handling slightly more extendable.
      sql/sql_yacc.yy:
        Made the characteristics handling slightly more extendable
        and made the parsing of characteristics more general, and
        added a few new dito. (LANGUAGE SQL, and [NOT] DETERMINISTIC
        for starters).
      3702a1db
  6. 04 Dec, 2003 2 commits
    • unknown's avatar
      Fixed another compiler error on HP-UX. · 722d19c3
      unknown authored
      722d19c3
    • unknown's avatar
      Fixed BUG#336: Subselects with tables does not work as values for local SP variables · 3aaa8ab9
      unknown authored
       and BUG#1654: Stored Procedure Crash if contains subquery and set function
      
      Disallowed subselects in RETURN (for FUNCTIONs) and SET of local variables.
      The latter should work, but turned out to be difficult to fix, so we just
      disallow it for the time being.
      
      
      include/mysqld_error.h:
        New error message for unsupported subselect as SP set values (for the time being).
      include/sql_state.h:
        New error message for unsupported subselect as SP set values (for the time being).
      mysql-test/r/sp-error.result:
        Test cases for BUG#336 and BUG#1654. (Unsupported use of subselect)
      mysql-test/t/sp-error.test:
        Test cases for BUG#336 and BUG#1654. (Unsupported use of subselect)
      sql/item.cc:
        Made Item_splocal::type() work at compile time, for error checking.
      sql/item.h:
        Made Item_splocal::type() work at compile time, for error checking.
      sql/share/czech/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/danish/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/dutch/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/english/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/estonian/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/french/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/german/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/greek/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/hungarian/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/italian/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/japanese/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/korean/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/norwegian-ny/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/norwegian/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/polish/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/portuguese/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/romanian/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/russian/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/serbian/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/slovak/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/spanish/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/swedish/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/share/ukrainian/errmsg.txt:
        New error message for unsupported subselect as SP set values (for the time being).
      sql/sp_head.cc:
        Fixed (bogus) compile error on HP-UX alpha.
      sql/sql_yacc.yy:
        Disallowed subselects in RETURN (for FUNCTIONs) and SET of local variables.
        The latter should work, but turned out to be difficult to fix, so we just
        disallow it for the time being.
      3aaa8ab9
  7. 21 Nov, 2003 1 commit
  8. 20 Nov, 2003 1 commit
  9. 19 Nov, 2003 2 commits
    • unknown's avatar
      Post-merge fixes. · afe2186e
      unknown authored
      afe2186e
    • unknown's avatar
      Fixed BUG#1862 (flush table in SPs didn't work). · bd226350
      unknown authored
      Fixed various bugs: setting local variables to NULL, SELECT INTO var now actually
      might work, SELECT INTO with not row now gives a "no data" warning (instead of
      the "empty query" error), etc.
      Updated test cases accordingly.
      
      
      mysql-test/r/sp-error.result:
        Corrected security syntax for alter/create procedure.
      mysql-test/r/sp.result:
        Corrected security syntax for alter/create procedure.
        New tests for setting local variables to null,
        bug fixes for SELECT INTO var, FLUSH TABLES calls (BUG#1862),
        and corrected "no data" warning for SELECT INTO with no rows.
      mysql-test/t/sp-error.test:
        Corrected security syntax for alter/create procedure.
      mysql-test/t/sp.test:
        Corrected security syntax for alter/create procedure.
        New tests for setting local variables to null,
        bug fixes for SELECT INTO var, FLUSH TABLES calls (BUG#1862),
        and corrected "no data" warning for SELECT INTO with no rows.
      sql/lex.h:
        Added SQL_SYM (and added a few _SYM suffixes for new symbols).
      sql/sp_head.cc:
        Fixed bug in the item_list copying for "with_wild" cases (list nodes ended
        up in the wrong memroot).
        Catch errors and warnings even if return values is 0 from sub-statements.
        Restore table_list which is zapped by SQLCOM_CREATE_TABLE and INSERT_SELECT.
        Set old table pointers to NULL after sub-statement call (since all tables are
        closed).
      sql/sql_class.cc:
        Corrected error message when no rows return by a SELECT INTO var; should
        be a "no data" warning.
      sql/sql_lex.h:
        Have to store the original table_list first pointer for some
        sub-statements in SPs.
      sql/sql_yacc.yy:
        Corrected SECURITY INVOKER/DEFINER syntax ("SQL" missing), added some _SYM
        suffixes, and fixed valgrind complaints for SP COMMENTs.
        (Also removed some now irrelevant comments.)
      bd226350
  10. 17 Nov, 2003 2 commits
    • unknown's avatar
      WL#1241: SHOW PROCEDURE/FUNCTION · 6c1a2b7f
      unknown authored
      WL#1263: Support for the attributes COMMENT and SUID
               in CREATE/ALTER PROCEDURE/FUNCTION
      
      
      include/mysqld_error.h:
        Error code for 'alter procedure'
      mysql-test/r/sp-error.result:
        Test for WL#1241&WL#1263
      mysql-test/r/sp.result:
        Test for WL#1241&WL#1263
      mysql-test/t/sp-error.test:
        Test for WL#1241&WL#1263
      mysql-test/t/sp.test:
        Test for WL#1241&WL#1263
      sql/share/czech/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/danish/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/dutch/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/english/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/estonian/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/french/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/german/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/greek/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/hungarian/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/italian/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/japanese/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/korean/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/norwegian-ny/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/norwegian/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/polish/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/portuguese/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/romanian/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/russian/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/serbian/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/slovak/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/spanish/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/swedish/errmsg.txt:
        Error massage for 'alter procedure'
      sql/share/ukrainian/errmsg.txt:
        Error massage for 'alter procedure'
      6c1a2b7f
    • unknown's avatar
      Bugfix, handling null values. · 74e77582
      unknown authored
      74e77582
  11. 28 Oct, 2003 1 commit
  12. 20 Oct, 2003 1 commit
    • unknown's avatar
      Bugfix; added another method to Item_splocal, updated tests, and added previous · 2b1dc5f3
      unknown authored
      fix to functions as well.
      
      
      mysql-test/r/sp.result:
        Modified test to trap yet another bug (now fixed).
      mysql-test/t/sp.test:
        Modified test to trap yet another bug (now fixed).
      sql/item.h:
        Another bugfix; need to override yet another method in Item_splocal.
      sql/sp_head.cc:
        Completed previous initialization bug; now for FUNCTIONs. too.
      2b1dc5f3
  13. 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
  14. 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
  15. 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
  16. 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
  17. 03 Oct, 2003 2 commits
    • unknown's avatar
      Check that a FUNCTION contains RETURN and that we actually get a return value. · 4379cbcf
      unknown authored
      include/mysqld_error.h:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      mysql-test/r/sp-error.result:
        New error tests for missing RETURNs in FUNCTIONs.
      mysql-test/t/sp-error.test:
        New error tests for missing RETURNs in FUNCTIONs.
      sql/share/czech/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/danish/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/dutch/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/english/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/estonian/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/french/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/german/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/greek/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/hungarian/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/italian/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/japanese/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/korean/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/norwegian-ny/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/norwegian/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/polish/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/portuguese/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/romanian/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/russian/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/serbian/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/slovak/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/spanish/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/swedish/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/share/ukrainian/errmsg.txt:
        New error codes/messages for missing RETURNs in FUNCTIONs.
      sql/sp_head.h:
        Check that a FUNCTION contains RETURN.
      sql/sql_parse.cc:
        Check that a FUNCTION contains RETURN.
      sql/sql_yacc.yy:
        Check that a FUNCTION contains RETURN.
      4379cbcf
    • 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
  18. 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
  19. 27 Aug, 2003 1 commit
  20. 26 Aug, 2003 1 commit
  21. 03 Jul, 2003 1 commit
  22. 01 Jul, 2003 1 commit
    • unknown's avatar
      Bugfixes for the sp_head memroot stuff. · 31a58c40
      unknown authored
      sql/sp.cc:
        Bugfixes for the sp_head memroot stuff. (Do things in the correct order
        at error clean-up.)
      sql/sp_head.cc:
        Bugfixes for the sp_head memroot stuff. Make sure everything goes to the
        right memroot. Need separate post-reset-memroot init in sp_head.
      sql/sp_head.h:
        Need separate post-reset-memroot init method.
      sql/sql_yacc.yy:
        Bugfixes for the sp_head memroot stuff. Make sure everything goes to the
        right memroot. Must do things in the correct order for this.
      31a58c40
  23. 29 Jun, 2003 1 commit
    • unknown's avatar
      sp_head now has its own mem_root (WL#961). · 663ac86f
      unknown authored
      Also fixed some difficult memory leaks that became apparent
      in this task.
      
      
      sql/sp.cc:
        sp_head now has its own mem_root.
      sql/sp_head.cc:
        sp_head now has its own mem_root.
        Also fixed some difficult memory leaks.
      sql/sp_head.h:
        sp_head now has its own mem_root.
      sql/sql_lex.h:
        Fixed some memory leaks in sp_head. Need to keep track on used lex:es.
      sql/sql_parse.cc:
        sp_head now has its own mem_root.
        Fixed SP memory leaks.
      sql/sql_prepare.cc:
        Fixed SP memory leaks.
      sql/sql_yacc.yy:
        sp_head now has its own mem_root.
      663ac86f
  24. 12 Jun, 2003 1 commit
  25. 02 Jun, 2003 1 commit
  26. 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
  27. 06 May, 2003 1 commit
  28. 05 May, 2003 1 commit
  29. 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
  30. 23 Apr, 2003 3 commits
    • unknown's avatar
      subselect in procedure argument list (Bug #302) · 37c94017
      unknown authored
      BitKeeper/etc/ignore:
        Added libmysqld/sp_pcontext.cc libmysqld/sp.cc libmysqld/sp_head.cc to the ignore list
      mysql-test/r/subselect.result:
        test of subselect in procedure argument list
      mysql-test/t/subselect.test:
        test of subselect in procedure argument list
      sql/sp_head.cc:
        subselect in procedure argument list
      sql/sql_parse.cc:
        subselect in procedure argument list
      37c94017
    • unknown's avatar
      Fixes bug #302: call u((select 1)) now works. · 44052160
      unknown authored
      More complex cases, like call u((select x from table limit 1)) does not.
      
      
      44052160
    • unknown's avatar
      Made multiple queries (SELECT without INTO) work in SPs. · f525047d
      unknown authored
      This included bug fixes in the 4.1 protocol (actually send and receive the
      server_status flags).
      
      
      libmysql/libmysql.c:
        Pick up the server_status (with the 4.1 protocol) as well.
      mysql-test/r/sp-error.result:
        Test for "bad selects" in non-CLIENT_MULTI_QUERIES clients (as mysqltest for the
        momen; this test will have to go away eventually).
      mysql-test/t/sp-error.test:
        Test for "bad selects" in non-CLIENT_MULTI_QUERIES clients (as mysqltest for the
        momen; this test will have to go away eventually).
      sql/protocol.cc:
        Actually send the server_status flags in send_eof() (4.1 protocol), not just zero.
      sql/sp_head.cc:
        Made multiple queries (SELECT without INTO) work in SPs.
      sql/sp_head.h:
        Made multiple queries (SELECT without INTO) work in SPs.
      sql/sql_parse.cc:
        Made multiple queries (SELECT without INTO) work in SPs.
      sql/sql_yacc.yy:
        Made multiple queries (SELECT without INTO) work in SPs.
      f525047d
  31. 17 Apr, 2003 1 commit
    • unknown's avatar
      Check the number of args to SPs. · 4ed94fcd
      unknown authored
      Fixes bug #280.
      
      
      include/mysqld_error.h:
        Check the number of args to SPs.
      mysql-test/r/sp-error.result:
        Check the number of args to SPs.
      mysql-test/t/sp-error.test:
        Check the number of args to SPs.
      sql/share/czech/errmsg.txt:
        Check the number of args to SPs.
      sql/share/danish/errmsg.txt:
        Check the number of args to SPs.
      sql/share/dutch/errmsg.txt:
        Check the number of args to SPs.
      sql/share/english/errmsg.txt:
        Check the number of args to SPs.
      sql/share/estonian/errmsg.txt:
        Check the number of args to SPs.
      sql/share/french/errmsg.txt:
        Check the number of args to SPs.
      sql/share/german/errmsg.txt:
        Check the number of args to SPs.
      sql/share/greek/errmsg.txt:
        Check the number of args to SPs.
      sql/share/hungarian/errmsg.txt:
        Check the number of args to SPs.
      sql/share/italian/errmsg.txt:
        Check the number of args to SPs.
      sql/share/japanese/errmsg.txt:
        Check the number of args to SPs.
      sql/share/korean/errmsg.txt:
        Check the number of args to SPs.
      sql/share/norwegian-ny/errmsg.txt:
        Check the number of args to SPs.
      sql/share/norwegian/errmsg.txt:
        Check the number of args to SPs.
      sql/share/polish/errmsg.txt:
        Check the number of args to SPs.
      sql/share/portuguese/errmsg.txt:
        Check the number of args to SPs.
      sql/share/romanian/errmsg.txt:
        Check the number of args to SPs.
      sql/share/russian/errmsg.txt:
        Check the number of args to SPs.
      sql/share/serbian/errmsg.txt:
        Check the number of args to SPs.
      sql/share/slovak/errmsg.txt:
        Check the number of args to SPs.
      sql/share/spanish/errmsg.txt:
        Check the number of args to SPs.
      sql/share/swedish/errmsg.txt:
        Check the number of args to SPs.
      sql/share/ukrainian/errmsg.txt:
        Check the number of args to SPs.
      sql/sp_head.cc:
        Check the number of args to SPs.
      4ed94fcd
  32. 03 Apr, 2003 2 commits
  33. 02 Apr, 2003 1 commit