An error occurred fetching the project authors.
  1. 29 Sep, 2004 1 commit
    • unknown's avatar
      post review changes: · e05e1860
      unknown authored
      CHECK OPTION moved to one function
      view name added to error messages
      
      
      mysql-test/r/view.result:
        error messages changed
      sql/share/czech/errmsg.txt:
        view name added
      sql/share/danish/errmsg.txt:
        view name added
      sql/share/dutch/errmsg.txt:
        view name added
      sql/share/english/errmsg.txt:
        view name added
      sql/share/estonian/errmsg.txt:
        view name added
      sql/share/french/errmsg.txt:
        view name added
      sql/share/german/errmsg.txt:
        view name added
      sql/share/greek/errmsg.txt:
        view name added
      sql/share/hungarian/errmsg.txt:
        view name added
      sql/share/italian/errmsg.txt:
        view name added
      sql/share/japanese/errmsg.txt:
        view name added
      sql/share/korean/errmsg.txt:
        view name added
      sql/share/norwegian-ny/errmsg.txt:
        view name added
      sql/share/norwegian/errmsg.txt:
        view name added
      sql/share/polish/errmsg.txt:
        view name added
      sql/share/portuguese/errmsg.txt:
        view name added
      sql/share/romanian/errmsg.txt:
        view name added
      sql/share/russian/errmsg.txt:
        view name added
      sql/share/serbian/errmsg.txt:
        view name added
      sql/share/slovak/errmsg.txt:
        view name added
      sql/share/spanish/errmsg.txt:
        view name added
      sql/share/swedish/errmsg.txt:
        view name added
      sql/share/ukrainian/errmsg.txt:
        view name added
      sql/sql_class.h:
        view reference saved
      sql/sql_insert.cc:
        CHECK OPTION moved to one function
      sql/sql_update.cc:
        CHECK OPTION moved to one function
      sql/sql_view.cc:
        view name added to error message
      sql/table.cc:
        CHECK OPTION moved to one function
      sql/table.h:
        CHECK OPTION moved to one function
      e05e1860
  2. 07 Sep, 2004 1 commit
    • unknown's avatar
      WL#1218 "Triggers". Some very preliminary version of patch. · 52ac4935
      unknown authored
      Mostly needed for Monty for him getting notion what needed for triggers 
      from new .FRM format. 
      
      Things to be done:
      - Right placement of trigger's invocations
      - Right handling of errors in triggers (including transaction rollback)
      - Support for priviliges
      - Right handling of DROP/RENAME table (hope that it will be handled automatically
        with merging of .TRG into .FRM file)
      - Saving/restoring some information critical for trigger creation and replication
        with their definitions (e.g. sql_mode, creator, ...)
      - Replication
      
      Already has some known bugs so probably not for general review.
      
      
      include/mysqld_error.h:
        Added trigger related error codes.
      sql/Makefile.am:
        Added sql_trigger.* files to list of sources from which mysqld is built.
      sql/item.cc:
        Added Item_trigger_field class representing field of new/old version of row which is 
        inserted/updated/deleted and for which trigger is invoked.
      sql/item.h:
        Added enums for describing trigger properties. (Here because of dependencies).
        Added Item_trigger_field class representing field of new/old version of row which is 
        inserted/updated/deleted and for which trigger is invoked.
      sql/item_func.cc:
        Added Item_func_set_user_var::print_as_stmt() for printing of assignment to ser variable
        from stored procedures.
        Added comment clarifying why we don't need set no_send_ok when calling stored functions.
      sql/item_func.h:
        Added Item_func_set_user_var::print_as_stmt() for printing of assignment to ser variable
        from stored procedures.
      sql/lex.h:
        Symbols used in statements defining triggers were added.
      sql/mysql_priv.h:
        Exported some functions needed for triggers implementation.
      sql/parse_file.cc:
        Cleaned up FILE_OPTIONS_STRLIST handling (needed for triggers).
      sql/parse_file.h:
        Cleaned up FILE_OPTIONS_STRLIST handling (needed for triggers).
      sql/share/czech/errmsg.txt:
        Added trigger related error messages.
      sql/share/danish/errmsg.txt:
        Added trigger related error messages.
      sql/share/dutch/errmsg.txt:
        Added trigger related error messages.
      sql/share/english/errmsg.txt:
        Added trigger related error messages.
      sql/share/estonian/errmsg.txt:
        Added trigger related error messages.
      sql/share/french/errmsg.txt:
        Added trigger related error messages.
      sql/share/german/errmsg.txt:
        Added trigger related error messages.
      sql/share/greek/errmsg.txt:
        Added trigger related error messages.
      sql/share/hungarian/errmsg.txt:
        Added trigger related error messages.
      sql/share/italian/errmsg.txt:
        Added trigger related error messages.
      sql/share/japanese/errmsg.txt:
        Added trigger related error messages.
      sql/share/korean/errmsg.txt:
        Added trigger related error messages.
      sql/share/norwegian-ny/errmsg.txt:
        Added trigger related error messages.
      sql/share/norwegian/errmsg.txt:
        Added trigger related error messages.
      sql/share/polish/errmsg.txt:
        Added trigger related error messages.
      sql/share/portuguese/errmsg.txt:
        Added trigger related error messages.
      sql/share/romanian/errmsg.txt:
        Added trigger related error messages.
      sql/share/russian/errmsg.txt:
        Added trigger related error messages.
      sql/share/serbian/errmsg.txt:
        Added trigger related error messages.
      sql/share/slovak/errmsg.txt:
        Added trigger related error messages.
      sql/share/spanish/errmsg.txt:
        Added trigger related error messages.
      sql/share/swedish/errmsg.txt:
        Added trigger related error messages.
      sql/share/ukrainian/errmsg.txt:
        Added trigger related error messages.
      sql/sp_head.cc:
        sp_head::init_strings(): added support for triggers 
          (we don't have most of strings for them)
        sp_head::execute_function(): triggers don't require RETURN
        sp_head::reset_lex(): added propagation of trigger properties to LEX used for 
         parsing of statements composing trigger body.
        Added two more SP instructions:
        - sp_instr_set_user_var for setting user variables in stored functions and triggers
          (we can't use sp_instr_stmt and "SET @A:=..." statement since it will close open 
          tables and thus break execution of calling statement.
        - sp_instr_set_trigger_field for assignment to fields of row being updated/inserted in
          triggers
      sql/sp_head.h:
        Added new type of sp_head object - TYPE_ENUM_TRIGGER
        Added two more SP instructions:
        - sp_instr_set_user_var for setting user variables in stored functions and triggers
          (we can't use sp_instr_stmt and "SET @A:=..." statement since it will close open 
          tables and thus break execution of calling statement.
        - sp_instr_set_trigger_field for assignment to fields of row being updated/inserted in
          triggers
      sql/sql_base.cc:
        Now freeing memory occupied by trigger related structures when closing tables.
        open_unireg_entry(): added loading of triggers for table.
        find_field_in_real_table() is now public since it required by Item_trigger_field in item.cc
      sql/sql_delete.cc:
        Added triggers invocation for DELETE (should be fixed for sure :))
      sql/sql_insert.cc:
        Added triggers invocation for INSERT (should be fixed for sure :))
      sql/sql_lex.cc:
        Added trg_new_row_fake_var variable pointer to which is used for distinguishing between
        assignment to NEW row field (when parsing trigger definition) and structured variable.
        Added initialization of LEX->trg_table to lex_start(). (When triggers are parsed during
        opening of table it points to table object.)
      sql/sql_lex.h:
        Added trigger related commands.
        Added st_trg_chistics structure describing properties of trigger being created
        (as struct and as LEX member).
        Added trg_new_row_fake_var variable pointer to which is used for
        distinguishing between assignment to NEW row field (when parsing trigger definition)
        and structured variable.
        Added LEX::trg_table which points to table being opened when we are parsing trigger
        definition while opening table.
      sql/sql_parse.cc:
        Added support for CREATE/DROP TRIGGER commands.
      sql/sql_table.cc:
        Cleanup. close_cached_table() always returns 0 and its result is not analyzed in most
        places so chenged its return type to void.
      sql/sql_update.cc:
        Added triggers invocation for UPDATE (should be fixed for sure :))
      sql/sql_yacc.yy:
        Added support for CREATE/DROP TRIGGER statements.
        Added support for OLD/NEW row identifiers in trigger.
        Made assignment to user variables not to break execution of stored function or trigger.
      sql/table.h:
        Added TABLE::triggers member representing triggers for this table.
      52ac4935
  3. 03 Sep, 2004 1 commit
    • unknown's avatar
      CHECK OPTIONs added (WL#1983) · 704fb6da
      unknown authored
      include/mysqld_error.h:
        new error messages
      mysql-test/r/view.result:
        test of CHECK OPTION in a views
      mysql-test/t/view.test:
        test of CHECK OPTION in a views
      sql/share/czech/errmsg.txt:
        new error messages
      sql/share/danish/errmsg.txt:
        new error messages
      sql/share/dutch/errmsg.txt:
        new error messages
      sql/share/english/errmsg.txt:
        new error messages
      sql/share/estonian/errmsg.txt:
        new error messages
      sql/share/french/errmsg.txt:
        new error messages
      sql/share/german/errmsg.txt:
        new error messages
      sql/share/greek/errmsg.txt:
        new error messages
      sql/share/hungarian/errmsg.txt:
        new error messages
      sql/share/italian/errmsg.txt:
        new error messages
      sql/share/japanese/errmsg.txt:
        new error messages
      sql/share/korean/errmsg.txt:
        new error messages
      sql/share/norwegian-ny/errmsg.txt:
        new error messages
      sql/share/norwegian/errmsg.txt:
        new error messages
      sql/share/polish/errmsg.txt:
        new error messages
      sql/share/portuguese/errmsg.txt:
        new error messages
      sql/share/romanian/errmsg.txt:
        new error messages
      sql/share/russian/errmsg.txt:
        new error messages
      sql/share/serbian/errmsg.txt:
        new error messages
      sql/share/slovak/errmsg.txt:
        new error messages
      sql/share/spanish/errmsg.txt:
        new error messages
      sql/share/swedish/errmsg.txt:
        new error messages
      sql/share/ukrainian/errmsg.txt:
        new error messages
      sql/sql_insert.cc:
        CHECK OPTIONs added
      sql/sql_lex.h:
        CHECK OPTIONs added
      sql/sql_update.cc:
        CHECK OPTIONs added
      sql/sql_view.cc:
        new parameter added
        returnrd values fixed
      sql/sql_yacc.yy:
        CHECK OPTIONs added
      sql/table.cc:
        CHECK OPTIONs added
      sql/table.h:
        CHECK OPTIONs added
      704fb6da
  4. 02 Sep, 2004 2 commits
    • unknown's avatar
      errmsg.txt: · b871ea38
      unknown authored
        Add GPL comment
      
      
      sql/share/czech/errmsg.txt:
        Add GPL comment
      sql/share/danish/errmsg.txt:
        Add GPL comment
      sql/share/dutch/errmsg.txt:
        Add GPL comment
      sql/share/english/errmsg.txt:
        Add GPL comment
      sql/share/estonian/errmsg.txt:
        Add GPL comment
      sql/share/french/errmsg.txt:
        Add GPL comment
      sql/share/german/errmsg.txt:
        Add GPL comment
      sql/share/greek/errmsg.txt:
        Add GPL comment
      sql/share/hungarian/errmsg.txt:
        Add GPL comment
      sql/share/italian/errmsg.txt:
        Add GPL comment
      sql/share/japanese/errmsg.txt:
        Add GPL comment
      sql/share/korean/errmsg.txt:
        Add GPL comment
      sql/share/norwegian-ny/errmsg.txt:
        Add GPL comment
      sql/share/norwegian/errmsg.txt:
        Add GPL comment
      sql/share/polish/errmsg.txt:
        Add GPL comment
      sql/share/portuguese/errmsg.txt:
        Add GPL comment
      sql/share/romanian/errmsg.txt:
        Add GPL comment
      sql/share/russian/errmsg.txt:
        Add GPL comment
      sql/share/slovak/errmsg.txt:
        Add GPL comment
      sql/share/spanish/errmsg.txt:
        Add GPL comment
      sql/share/swedish/errmsg.txt:
        Add GPL comment
      sql/share/ukrainian/errmsg.txt:
        Add GPL comment
      b871ea38
    • unknown's avatar
      checked INTO clause during view creation (BUG#5332) · 5feaa7b6
      unknown authored
      include/mysqld_error.h:
        bug name and number of bugs fixed
      mysql-test/r/view.result:
        VIEW over SELECT with prohibited clauses
      mysql-test/t/view.test:
        VIEW over SELECT with prohibited clauses
      sql/share/czech/errmsg.txt:
        error message made more general
      sql/share/danish/errmsg.txt:
        error message made more general
      sql/share/dutch/errmsg.txt:
        error message made more general
      sql/share/english/errmsg.txt:
        error message made more general
      sql/share/estonian/errmsg.txt:
        error message made more general
      sql/share/french/errmsg.txt:
        error message made more general
      sql/share/german/errmsg.txt:
        error message made more general
      sql/share/greek/errmsg.txt:
        error message made more general
      sql/share/hungarian/errmsg.txt:
        error message made more general
      sql/share/italian/errmsg.txt:
        error message made more general
      sql/share/japanese/errmsg.txt:
        error message made more general
      sql/share/korean/errmsg.txt:
        error message made more general
      sql/share/norwegian-ny/errmsg.txt:
        error message made more general
      sql/share/norwegian/errmsg.txt:
        error message made more general
      sql/share/polish/errmsg.txt:
        error message made more general
      sql/share/portuguese/errmsg.txt:
        error message made more general
      sql/share/romanian/errmsg.txt:
        error message made more general
      sql/share/russian/errmsg.txt:
        error message made more general
      sql/share/serbian/errmsg.txt:
        error message made more general
      sql/share/slovak/errmsg.txt:
        error message made more general
      sql/share/spanish/errmsg.txt:
        error message made more general
      sql/share/swedish/errmsg.txt:
        error message made more general
      sql/share/ukrainian/errmsg.txt:
        error message made more general
      sql/sql_view.cc:
        checked INTO clause during view creation
      5feaa7b6
  5. 31 Aug, 2004 1 commit
  6. 27 Aug, 2004 1 commit
  7. 26 Aug, 2004 1 commit
    • unknown's avatar
      Major rehacking and cleanup of sp_pcontext. · 071651ef
      unknown authored
      This finishes (almost) WL#2002: Implement stored procedure GOTO.
      Only the syntax issue for free labels remains ("label L;" vs "L:").
      
      
      include/mysqld_error.h:
        New error code for GOTO in SP handler.
      mysql-test/r/sp-error.result:
        New error test cases for GOTO.
      mysql-test/r/sp.result:
        New test cases for GOTO.
        Also removed some things that made it impossible to run the test in
        an external (debugged) mysqld.
      mysql-test/t/sp-error.test:
        New error test cases for GOTO.
      mysql-test/t/sp.test:
        New test cases for GOTO.
        Also removed some things that made it impossible to run the test in
        an external (debugged) mysqld.
      sql/share/czech/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/danish/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/dutch/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/english/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/estonian/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/french/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/german/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/greek/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/hungarian/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/italian/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/japanese/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/korean/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/norwegian-ny/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/norwegian/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/polish/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/portuguese/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/romanian/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/russian/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/serbian/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/slovak/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/spanish/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/swedish/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/share/ukrainian/errmsg.txt:
        New error message for GOTO in SP handler.
      sql/sp_head.cc:
        Code cleanup (renaming of pcontext methods), support goto, and fixed bug
        in jump shortcutting in the optimizer (detect infinite loops).
      sql/sp_head.h:
        Code cleanup (renaming of pcontext methods), support goto, and fixed bug
        in jump shortcutting in the optimizer (detect infinite loops).
      sql/sp_pcontext.cc:
        Major rehack and cleanup:
        - We now push and pop a chain of contexts during parsing (instead of having
          a single one).
        - Makes error detection for GOTO easier and enables some optmizations and
          debugger support.
        - Makes it a little trickier to keep track on variable and cursor indexes instead.
        - Renamed things to get a more consistent naming scheme too.
      sql/sp_pcontext.h:
        Major rehack and cleanup:
        - We now push and pop a chain of contexts during parsing (instead of having
          a single one).
        - Makes error detection for GOTO easier and enables some optmizations and
          debugger support.
        - Makes it a little trickier to keep track on variable and cursor indexes instead.
        - Renamed things to get a more consistent naming scheme too.
      sql/sql_yacc.yy:
        Changes to reflect the rework and renamings in sp_pcontext, and fixed
        some GOTO error checking.
      071651ef
  8. 23 Aug, 2004 1 commit
    • unknown's avatar
      Fixed uninitialized variable · 7d4ad390
      unknown authored
      Fixed error messages
      
      
      sql/share/czech/errmsg.txt:
        Fixed error message to us long
      sql/share/danish/errmsg.txt:
        Fixed error message to us long
      sql/share/dutch/errmsg.txt:
        Fixed error message to us long
      sql/share/english/errmsg.txt:
        Fixed error message to us long
      sql/share/estonian/errmsg.txt:
        Fixed error message to us long
      sql/share/french/errmsg.txt:
        Fixed error message to us long
      sql/share/german/errmsg.txt:
        Fixed error message to us long
      sql/share/greek/errmsg.txt:
        Fixed error message to us long
      sql/share/hungarian/errmsg.txt:
        Fixed error message to us long
      sql/share/italian/errmsg.txt:
        Fixed error message to us long
      sql/share/japanese/errmsg.txt:
        Fixed error message to us long
      sql/share/korean/errmsg.txt:
        Fixed error message to us long
      sql/share/norwegian-ny/errmsg.txt:
        Fixed error message to us long
      sql/share/norwegian/errmsg.txt:
        Fixed error message to us long
      sql/share/polish/errmsg.txt:
        Fixed error message to us long
      sql/share/portuguese/errmsg.txt:
        Fixed error message to us long
      sql/share/romanian/errmsg.txt:
        Fixed error message to us long
      sql/share/russian/errmsg.txt:
        Fixed error message to us long
      sql/share/serbian/errmsg.txt:
        Fixed error message to us long
      sql/share/slovak/errmsg.txt:
        Fixed error message to us long
      sql/share/spanish/errmsg.txt:
        Fixed error message to us long
      sql/share/swedish/errmsg.txt:
        Fixed error message to us long
      sql/share/ukrainian/errmsg.txt:
        Fixed error message to us long
      sql/sql_table.cc:
        Fixed uninitialized variable
      7d4ad390
  9. 10 Aug, 2004 1 commit
    • unknown's avatar
      errmsg.txt: · de78ba87
      unknown authored
        fix error message
      
      
      sql/share/czech/errmsg.txt:
        fix error message
      sql/share/danish/errmsg.txt:
        fix error message
      sql/share/dutch/errmsg.txt:
        fix error message
      sql/share/english/errmsg.txt:
        fix error message
      sql/share/estonian/errmsg.txt:
        fix error message
      sql/share/french/errmsg.txt:
        fix error message
      sql/share/german/errmsg.txt:
        fix error message
      sql/share/greek/errmsg.txt:
        fix error message
      sql/share/hungarian/errmsg.txt:
        fix error message
      sql/share/italian/errmsg.txt:
        fix error message
      sql/share/japanese/errmsg.txt:
        fix error message
      sql/share/korean/errmsg.txt:
        fix error message
      sql/share/norwegian-ny/errmsg.txt:
        fix error message
      sql/share/norwegian/errmsg.txt:
        fix error message
      sql/share/polish/errmsg.txt:
        fix error message
      sql/share/portuguese/errmsg.txt:
        fix error message
      sql/share/romanian/errmsg.txt:
        fix error message
      sql/share/serbian/errmsg.txt:
        fix error message
      sql/share/slovak/errmsg.txt:
        fix error message
      sql/share/spanish/errmsg.txt:
        fix error message
      sql/share/swedish/errmsg.txt:
        fix error message
      de78ba87
  10. 04 Aug, 2004 1 commit
    • unknown's avatar
      Print MYSQL_COMPILATION_COMMENT after ER_READY on server startup · 03daa16a
      unknown authored
      sql/share/czech/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      sql/share/danish/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      sql/share/dutch/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      sql/share/english/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      sql/share/estonian/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      sql/share/french/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      sql/share/german/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      sql/share/greek/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      sql/share/hungarian/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      sql/share/japanese/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      sql/share/korean/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      sql/share/norwegian-ny/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      sql/share/norwegian/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      sql/share/polish/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      sql/share/portuguese/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      sql/share/romanian/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      sql/share/russian/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      sql/share/slovak/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      sql/share/spanish/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      sql/share/swedish/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      sql/share/ukrainian/errmsg.txt:
        Remove trailing \n from ER_READY (it is now printed in mysqld.cc)
      03daa16a
  11. 29 Jul, 2004 1 commit
    • unknown's avatar
      Fixed BUG#434: Stored procedure which drops itself causes crash. · 4467bcf2
      unknown authored
      Simply disallow it, just as we disallow creation of routines from within
      other SPs.
      
      
      include/mysqld_error.h:
        New error code for when attempting to drop a stored routine from within
        another stored routine.
      mysql-test/r/sp-error.result:
        New test case for BUG#4344.
      mysql-test/t/sp-error.test:
        New test case for BUG#4344.
      sql/share/czech/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/danish/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/dutch/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/english/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/estonian/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/french/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/german/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/greek/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/hungarian/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/italian/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/japanese/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/korean/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/norwegian-ny/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/norwegian/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/polish/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/portuguese/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/romanian/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/russian/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/serbian/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/slovak/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/spanish/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/swedish/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/share/ukrainian/errmsg.txt:
        New error message for when attempting to drop a stored routine from within
        another stored routine.
      sql/sql_yacc.yy:
        Don't allow drop function/procedure from within another function/procedure.
      4467bcf2
  12. 21 Jul, 2004 2 commits
    • unknown's avatar
      Final patch for WL#1600(warn if max_allowed_packet used) · 8df1bf6b
      unknown authored
      mysql-test/r/func_str.result:
        test fixed
      mysql-test/r/packet.result:
        test fixed
      sql/item_geofunc.cc:
        error message fixed
      sql/item_strfunc.cc:
        error message fixed
      sql/share/czech/errmsg.txt:
        error message fixed
      sql/share/danish/errmsg.txt:
        error message fixed
      sql/share/dutch/errmsg.txt:
        error message fixed
      sql/share/english/errmsg.txt:
        error message fixed
      sql/share/estonian/errmsg.txt:
        error message fixed
      sql/share/french/errmsg.txt:
        error message fixed
      sql/share/german/errmsg.txt:
        error message fixed
      sql/share/greek/errmsg.txt:
        error message fixed
      sql/share/hungarian/errmsg.txt:
        error message fixed
      sql/share/italian/errmsg.txt:
        error message fixed
      sql/share/japanese/errmsg.txt:
        error message fixed
      sql/share/korean/errmsg.txt:
        error message fixed
      sql/share/norwegian-ny/errmsg.txt:
        error message fixed
      sql/share/norwegian/errmsg.txt:
        error message fixed
      sql/share/polish/errmsg.txt:
        error message fixed
      sql/share/portuguese/errmsg.txt:
        error message fixed
      sql/share/romanian/errmsg.txt:
        error message fixed
      sql/share/russian/errmsg.txt:
        error message fixed
      sql/share/serbian/errmsg.txt:
        error message fixed
      sql/share/slovak/errmsg.txt:
        error message fixed
      sql/share/spanish/errmsg.txt:
        error message fixed
      sql/share/swedish/errmsg.txt:
        error message fixed
      sql/share/ukrainian/errmsg.txt:
        error message fixed
      8df1bf6b
    • unknown's avatar
      error message interception (Bug#4598) · b01e2f6d
      unknown authored
      error handling of view initialization fixed (Bug#4599)
      
      
      include/mysqld_error.h:
        new error message
      mysql-test/r/view.result:
        changing of underlaying table test
      mysql-test/t/view.test:
        changing of underlaying table test
      sql/share/czech/errmsg.txt:
        new error message
      sql/share/danish/errmsg.txt:
        new error message
      sql/share/dutch/errmsg.txt:
        new error message
      sql/share/english/errmsg.txt:
        new error message
      sql/share/estonian/errmsg.txt:
        new error message
      sql/share/french/errmsg.txt:
        new error message
      sql/share/german/errmsg.txt:
        new error message
      sql/share/greek/errmsg.txt:
        new error message
      sql/share/hungarian/errmsg.txt:
        new error message
      sql/share/italian/errmsg.txt:
        new error message
      sql/share/japanese/errmsg.txt:
        new error message
      sql/share/korean/errmsg.txt:
        new error message
      sql/share/norwegian-ny/errmsg.txt:
        new error message
      sql/share/norwegian/errmsg.txt:
        new error message
      sql/share/polish/errmsg.txt:
        new error message
      sql/share/portuguese/errmsg.txt:
        new error message
      sql/share/romanian/errmsg.txt:
        new error message
      sql/share/russian/errmsg.txt:
        new error message
      sql/share/serbian/errmsg.txt:
        new error message
      sql/share/slovak/errmsg.txt:
        new error message
      sql/share/spanish/errmsg.txt:
        new error message
      sql/share/swedish/errmsg.txt:
        new error message
      sql/share/ukrainian/errmsg.txt:
        new error message
      sql/sql_base.cc:
        error message interception
        error handling fixed
      sql/sql_view.cc:
        comment fixed
        error message interception
      sql/table.cc:
        error message interception
      sql/table.h:
        error message interception
      b01e2f6d
  13. 15 Jul, 2004 1 commit
    • unknown's avatar
      VIEW · 8790b1e6
      unknown authored
      two TABLE_LIST copy eliminated
      
      
      include/mysqld_error.h:
        errors of view
      libmysqld/Makefile.am:
        new view file
      mysql-test/r/connect.result:
        SHOW TABLE show type of table
      mysql-test/r/ctype_recoding.result:
        SHOW TABLE show type of table
      mysql-test/r/drop.result:
        SHOW TABLE show type of table
      mysql-test/r/grant.result:
        new two privileges (CRETEA|SHOW VIEW)
      mysql-test/r/lowercase_table.result:
        SHOW TABLE show type of table
      mysql-test/r/ps_1general.result:
        SHOW TABLE show type of table
      mysql-test/r/rename.result:
        SHOW TABLE show type of table
      mysql-test/r/rpl000009.result:
        SHOW TABLE show type of table
      mysql-test/r/rpl_error_ignored_table.result:
        SHOW TABLE show type of table
      mysql-test/r/select.result:
        SHOW TABLE show type of table
      mysql-test/r/system_mysql_db.result:
        SHOW TABLE show type of table
        new two privileges (CRETEA|SHOW VIEW)
      mysql-test/t/system_mysql_db_fix.test:
        removing all system tables
      scripts/mysql_fix_privilege_tables.sql:
        new two privileges (CRETEA|SHOW VIEW)
      sql/Makefile.am:
        new VIEW related file
      sql/ha_myisammrg.cc:
        two TABLE_LIST copy eliminated
      sql/item.cc:
        VIEW
      sql/item.h:
        VIEW
      sql/item_subselect.cc:
        VIEW
      sql/item_subselect.h:
        VIEW
      sql/lex.h:
        VIEW
      sql/lock.cc:
        VIEW
      sql/mysql_priv.h:
        VIEW
      sql/mysqld.cc:
        VIEW
        new parameter - sql_updatable_view_key
      sql/opt_sum.cc:
        two TABLE_LIST copy eliminated
      sql/set_var.cc:
        new parameter - sql_updatable_view_key
      sql/share/czech/errmsg.txt:
        errors messages of views
      sql/share/danish/errmsg.txt:
        errors messages of views
      sql/share/dutch/errmsg.txt:
        errors messages of views
      sql/share/english/errmsg.txt:
        errors messages of views
      sql/share/estonian/errmsg.txt:
        errors messages of views
      sql/share/french/errmsg.txt:
        errors messages of views
      sql/share/german/errmsg.txt:
        errors messages of views
      sql/share/greek/errmsg.txt:
        errors messages of views
      sql/share/hungarian/errmsg.txt:
        errors messages of views
      sql/share/italian/errmsg.txt:
        errors messages of views
      sql/share/japanese/errmsg.txt:
        errors messages of views
      sql/share/korean/errmsg.txt:
        errors messages of views
      sql/share/norwegian-ny/errmsg.txt:
        errors messages of views
      sql/share/norwegian/errmsg.txt:
        errors messages of views
      sql/share/polish/errmsg.txt:
        errors messages of views
      sql/share/portuguese/errmsg.txt:
        errors messages of views
      sql/share/romanian/errmsg.txt:
        errors messages of views
      sql/share/russian/errmsg.txt:
        errors messages of views
      sql/share/serbian/errmsg.txt:
        errors messages of views
      sql/share/slovak/errmsg.txt:
        errors messages of views
      sql/share/spanish/errmsg.txt:
        errors messages of views
      sql/share/swedish/errmsg.txt:
        errors messages of views
      sql/share/ukrainian/errmsg.txt:
        errors messages of views
      sql/slave.cc:
        two TABLE_LIST copy eliminated
      sql/sp.cc:
        VIEW
      sql/sql_acl.cc:
        VIEW
      sql/sql_acl.h:
        VIEW
      sql/sql_base.cc:
        VIEW
      sql/sql_cache.cc:
        two TABLE_LIST copy eliminated
      sql/sql_class.h:
        VIEW
      sql/sql_db.cc:
        two TABLE_LIST copy eliminated
      sql/sql_delete.cc:
        VIEW
      sql/sql_derived.cc:
        VIEW
      sql/sql_handler.cc:
        two TABLE_LIST copy eliminated
      sql/sql_help.cc:
        two TABLE_LIST copy eliminated
      sql/sql_insert.cc:
        VIEW
      sql/sql_lex.cc:
        VIEW
      sql/sql_lex.h:
        VIEW
      sql/sql_load.cc:
        VIEW
      sql/sql_olap.cc:
        VIEW
      sql/sql_parse.cc:
        two TABLE_LIST copy eliminated
        VIEW
      sql/sql_prepare.cc:
        VIEW
      sql/sql_rename.cc:
        two TABLE_LIST copy eliminated
      sql/sql_select.cc:
        VIEW
      sql/sql_show.cc:
        VIEW
      sql/sql_table.cc:
        VIEW
      sql/sql_union.cc:
        VIEW
      sql/sql_update.cc:
        VIEW
      sql/sql_yacc.yy:
        VIEW
      sql/table.cc:
        VIEW
      sql/table.h:
        VIEW
      sql/tztime.cc:
        two TABLE_LIST copy eliminated
      sql/unireg.h:
        VIEW
      tests/client_test.c:
        VIEW
      8790b1e6
  14. 07 Jul, 2004 1 commit
  15. 29 Jun, 2004 1 commit
    • unknown's avatar
      WL#1600 (Warn if result is truncatet due to max_allowed_packet) · 58bdba57
      unknown authored
      include/mysqld_error.h:
        Warning added
      mysql-test/r/func_str.result:
        test result fixed
      mysql-test/r/packet.result:
        test resut fixed
      sql/item_geofunc.cc:
        warning issued
      sql/item_strfunc.cc:
        warning issued
      sql/share/czech/errmsg.txt:
        Warning added
      sql/share/danish/errmsg.txt:
        Warning added
      sql/share/dutch/errmsg.txt:
        Warning added
      sql/share/english/errmsg.txt:
        Warning added
      sql/share/estonian/errmsg.txt:
        Warning added
      sql/share/french/errmsg.txt:
        Warning added
      sql/share/german/errmsg.txt:
        Warning added
      sql/share/greek/errmsg.txt:
        Warning added
      sql/share/hungarian/errmsg.txt:
        Warning added
      sql/share/italian/errmsg.txt:
        Warning added
      sql/share/japanese/errmsg.txt:
        Warning added
      sql/share/korean/errmsg.txt:
        Warning added
      sql/share/norwegian-ny/errmsg.txt:
        Warning added
      sql/share/norwegian/errmsg.txt:
        Warning added
      sql/share/polish/errmsg.txt:
        Warning added
      sql/share/portuguese/errmsg.txt:
        Warning added
      sql/share/romanian/errmsg.txt:
        Warning added
      sql/share/russian/errmsg.txt:
        Warning added
      sql/share/serbian/errmsg.txt:
        Warning added
      sql/share/slovak/errmsg.txt:
        Warning added
      sql/share/spanish/errmsg.txt:
        Warning added
      sql/share/swedish/errmsg.txt:
        Warning added
      sql/share/ukrainian/errmsg.txt:
        Warning added
      58bdba57
  16. 18 Jun, 2004 1 commit
    • unknown's avatar
      WL#1264 "Per-thread time zone support infrastructure". · 6aaccbcb
      unknown authored
      Added basic per-thread time zone functionality (based on public
      domain elsie-code). Now user can select current time zone
      (from the list of time zones described in system tables).
      All NOW-like functions honor this time zone, values of TIMESTAMP
      type are interpreted as values in this time zone, so now
      our TIMESTAMP type behaves similar to Oracle's TIMESTAMP WITH
      LOCAL TIME ZONE (or proper PostgresSQL type).
        
      WL#1266 "CONVERT_TZ() - basic time with time zone conversion 
      function".
        
      Fixed problems described in Bug #2336 (Different number of warnings 
      when inserting bad datetime as string or as number). This required
      reworking of datetime realted warning hadling (they now generated 
      at Field object level not in conversion functions).
        
      Optimization: Now Field class descendants use table->in_use member
      instead of current_thd macro.
      
      
      include/my_global.h:
        Added macro for reading of 32-bit ints stored in network order from
        unaligned memory location.
      include/mysqld_error.h:
        Added error-code for invalid timestamp warning and error-code
        for wrong or unknown time zone specification.
      libmysqld/Makefile.am:
        Added main per-thread time zone support file to libmysqld
      libmysqld/lib_sql.cc:
        Added initialization of time zones infrastructure to embedded server.
      mysql-test/r/connect.result:
        Updated test result since now mysql database contains more
        system tables.
      mysql-test/r/date_formats.result:
        Now when truncation occurs during conversion to datetime value we are producing Warnings 
        instead of Notes. Also we are giving more clear warnings about this in some cases.
      mysql-test/r/func_sapdb.result:
        New warnings about truncation occured during conversion to datetime value added due
        their better handling.
      mysql-test/r/func_time.result:
        New warnings about truncation occured during conversion to datetime value added due
        their better handling.
      mysql-test/r/select.result:
        New warnings about truncation occured during conversion to datetime value added due
        their better handling. Also tweaked test a bit to made it less ambigious for reader.
      mysql-test/r/system_mysql_db.result:
        Updated test result because new system tables holding time zone descriptions were 
        added.
      mysql-test/r/timezone.result:
        Updated timezone.test to use new system variable which shows system time zone.
        Added test of warning which is produced if someone tries to store non-existing (due 
        falling into spring time-gap) datetime value into TIMESTAMP field.
      mysql-test/r/type_datetime.result:
        Separated and extended test of values and warnings produced for bad values stored in 
        DATETTIME fields.
      mysql-test/r/type_time.result:
        Now we are producing more consistent warning when we are truncating datetime value while
        storing it in TIME field.
      mysql-test/r/type_timestamp.result:
        Separated and extended test of values and warnings produced for bad
        values stored in TIMESTAMP fields.
      mysql-test/t/select.test:
        Updated test to make it less ambigous for reader.
      mysql-test/t/timezone.test:
        Updated timezone.test to use new system variable which shows system time zone.
        Added test of warning which is produced if someone tries to store non-existing (due 
        falling into spring time-gap) datetime value into TIMESTAMP field.
      mysql-test/t/type_datetime.test:
        Separated and extended test of values and warnings produced for bad
        values stored in DATETTIME fields.
      mysql-test/t/type_timestamp.test:
        Separated and extended test of values and warnings produced for bad
        values stored in TIMESTAMP fields.
      scripts/mysql_create_system_tables.sh:
        Added creation of tables with time zone descriptions.
        Also added descriptions of time zones used in tests.
      scripts/mysql_fix_privilege_tables.sql:
        Added mysql.time_zone* tables family.
      sql/Makefile.am:
        Added files implementing time zone support to server, also added
        rules for building of mysql_tzinfo_to_sql converter and test_time
        test.
      sql/field.cc:
        Now we are using per-thread time zone for TIMESTAMP <-> whatever conversion.
        Fixed generation of warnings for datetime types (DATETIME/TIMESTAMP/DATE/...) and
        any other Field to datetime conversion (now we are generating warnings no in lower
        level functions like in str_to_TIME() but in Field methods. This allows generate
        better and more consistent warnings and to reuse code of str_to_TIME() outside of
        server).
        
        Added 3rd parameter to set_warning() method to be able to not increment cut fields
        but still produce a warning. Also added set_datetime_warning() family of auxiliary 
        methods which allow easier generate datetime related warnings.
        Also replaced occurences of current_thd with table->in_use member, added
        asserts for catching all places there we need to set table->in_use
        accordingly. Renamed fix_datetime() function to number_to_TIME() and
        moved it to sql/time.cc there it fits better.
      sql/field.h:
        Added comment about places where we can use table->in_use member
        instead of current_thd.
        Added 3rd parameter to Field::set_warning() method and set_datetime_warning()
        family of methods.
      sql/field_conv.cc:
        Field::set_warning() method with 2 arguments was replaced with more 
        generic set_warning() method with 3 arguments.
      sql/ha_berkeley.cc:
        Now we set table->in_use for temporary tables so we have to use
        table->tmp_table for checking if table is temporary.
      sql/item.cc:
        Replaced calls to str_to_time() and str_to_TIME() funcs with their warning
        generating analogs.
      sql/item_create.cc:
        Added creation of CONVERT_TZ function as FUNC_ARG3.
      sql/item_create.h:
        Added creation of CONVERT_TZ function as FUNC_ARG3.
      sql/item_timefunc.cc:
        Added support of per-thread time zone to NOW-like and FROM_UNIXTIME,
        UNIX_TIMESTAMP functions. 
        Added support for CONVERT_TZ function.
        Removed call to str_to_timestamp function which caused non-optimal
        behavior in certain cases. Replaced calls to str_to_time() function 
        with its warning generating analog.
      sql/item_timefunc.h:
        Added support of per-thread time zone to NOW-like and
        FROM_UNIXTIME, UNIX_TIMESTAMP functions.
        Added support of CONVERT_TZ function.
      sql/lex.h:
        Added support of CONVERT_TZ function.
      sql/log.cc:
        Added support for replication of statements depending on time zone.
      sql/mysql_priv.h:
        Now including headers with per-thread time zone support functions
        and classes. Added portable replacement of time_t - my_time_t type. 
        Added time zone as one of query distinguishing parameters for
        query cache. 
        Fixed declarations of str_to_TIME, str_to_time and 
        my_system_gmt_sec (former my_gmt_sec) since now they have one more
        out parameter which informs about wrong datetime value or data 
        truncation during conversion.
        Added warning generating version of str_to_TIME() and str_to_time()
        functions.
        Thrown away str_to_datetime/timestamp functions since they are not
        needed any longer. Added number_to_TIME function.
      sql/mysqld.cc:
        Added per-thread time zone support initialization.
        Added new startup parameter --default-time-zone.
      sql/set_var.cc:
        Added support for per-thread time_zone variable.
        Renamed old timezone variable to system_time_zone.
      sql/set_var.h:
        Added support for per-thread time_zone variable.
      sql/share/czech/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/danish/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/dutch/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/english/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/estonian/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/french/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/german/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/greek/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/hungarian/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/italian/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/japanese/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/korean/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/norwegian-ny/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/norwegian/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/polish/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/portuguese/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/romanian/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/russian/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/serbian/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/slovak/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/spanish/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/swedish/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/share/ukrainian/errmsg.txt:
        Added error message for barking when incorrect time zone name or
        specifiaction is provided and for warning about invalid TIMESTAMP
        values (e.g. falling into the spring time-gap).
      sql/slave.cc:
        In order to support replication of statements using time zones in 4.1 we should 
        ensure that both master and slave have same default time zone.
      sql/sql_base.cc:
        Now we are setting TABLE::in_use member for all tables (which assume
        calls to Field::store or val_ methods).
      sql/sql_cache.cc:
        Added time zone as one more query distinguishing parameter
        for query cache.
      sql/sql_class.cc:
        Added THD::time_zone_used variable indicating that this query
        uses per thread time zone.
      sql/sql_class.h:
        Added per-thread time zone variable. Added THD::time_zone_used
        variable indicating that this query uses per thread time zone
        so if this is updating query the time zone should be logged to 
        binlog.
      sql/sql_insert.cc:
        We should set TABLE::in_use member pointing to thread which is called
        INSERT DELAYED and not to worker thread.
      sql/sql_load.cc:
        Field::set_warning() now has one more argument now.
      sql/sql_parse.cc:
        Resetting THD::time_zone_used variable in the end of query
        processing.
      sql/sql_select.cc:
        Now we are setting TABLE::in_use member for all tables (which assume
        calls to Field::store or val_ methods).
      sql/sql_show.cc:
        Now using per thread time zone for extended show tables.
      sql/time.cc:
        Added support for per-thread time zones for TIMESTAMP type and
        reworked generation of warnings for TIMESTAMP and DATETIME types.
        (Introduced new TIME_to_timestamp() function. Removed hours 
        normalisation from former my_gmt_sec() since it was not working 
        and not used anywhere now, but breaks parameter constness, added
        to this function generation of warning if we are falling in spring 
        time-gap. Removed str_to_timestamp and str_to_datetime functions 
        which are no longer used. Moved fix_datetime function from
        sql/field.cc to this file as number_to_TIME() function. Added
        out parameter for str_to_TIME and str_to_time functions which
        indicates if value was truncated during conversion, removed direct 
        generation of warnings from this functions.)
      sql/unireg.cc:
        Now we are setting TABLE::in_use member for all tables (which assume
          calls to Field::store or val_ methods).
      BitKeeper/etc/ignore:
        Added sql/test_time sql/mysql_tzinfo_to_sql libmysqld/tztime.cc to the ignore list
      6aaccbcb
  17. 16 Jun, 2004 5 commits
  18. 15 Jun, 2004 1 commit
  19. 13 May, 2004 1 commit
    • unknown's avatar
      WL #1729 Handler: error text for NDB errors · d4399619
      unknown authored
      - New solution after discussions with Sergei, no handler specific code or error messages should be in sql layer.
      next_result, only check for error if check is -1
      Improved index_read 
      
      
      include/mysqld_error.h:
        New error codes ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG, update number to 298.
        Removed prevoius ER_NDB_ERROR, handler specific error should not be here.
      sql/ha_ndbcluster.cc:
        Removed print_error from ha_ndbcluster, added code to handler::print_error to ask  handler::get_error_message for message for an error.
        Fix bug in next_result, only check for error if -1 is returned.
        Make index_read easier, special case where pk_read or unique_index_read is detected and as default do ordered_index_scan
      sql/ha_ndbcluster.h:
        Remplace print_error with get_error_message
      sql/handler.cc:
        Add new function get_error_message usedc to ask handler for a message for an error.
        Call get_error_message from print_error if error code is not known.
      sql/handler.h:
        Add new function get_error_message
      sql/share/czech/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/danish/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/dutch/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/english/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/estonian/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/french/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/german/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/greek/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/hungarian/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/italian/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/korean/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/norwegian-ny/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/norwegian/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/polish/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/portuguese/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/romanian/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/russian/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/serbian/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/slovak/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/spanish/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/swedish/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      sql/share/ukrainian/errmsg.txt:
        Error message for ER_GET_ERRMSG and ER_GET_TEMPORARY_ERRMSG
      d4399619
  20. 11 May, 2004 2 commits
    • unknown's avatar
      file parser for new .frm · e66b7405
      unknown authored
      include/my_sys.h:
        names for get_date format flags
      include/mysqld_error.h:
        error of parser
      libmysqld/Makefile.am:
        parser file added
      mysys/mf_getdate.c:
        function comment for get_date()
        2 new flags added
        names for get_date format flags
      sql/Makefile.am:
        parser file added
      sql/mysql_priv.h:
        parser file added
      sql/share/czech/errmsg.txt:
        file parser errors
      sql/share/danish/errmsg.txt:
        file parser errors
      sql/share/dutch/errmsg.txt:
        file parser errors
      sql/share/english/errmsg.txt:
        file parser errors
      sql/share/estonian/errmsg.txt:
        file parser errors
      sql/share/french/errmsg.txt:
        file parser errors
      sql/share/german/errmsg.txt:
        file parser errors
      sql/share/greek/errmsg.txt:
        file parser errors
      sql/share/hungarian/errmsg.txt:
        file parser errors
      sql/share/italian/errmsg.txt:
        file parser errors
      sql/share/japanese/errmsg.txt:
        file parser errors
      sql/share/korean/errmsg.txt:
        file parser errors
      sql/share/norwegian-ny/errmsg.txt:
        file parser errors
      sql/share/norwegian/errmsg.txt:
        file parser errors
      sql/share/polish/errmsg.txt:
        file parser errors
      sql/share/portuguese/errmsg.txt:
        file parser errors
      sql/share/romanian/errmsg.txt:
        file parser errors
      sql/share/russian/errmsg.txt:
        file parser errors
      sql/share/serbian/errmsg.txt:
        file parser errors
      sql/share/slovak/errmsg.txt:
        file parser errors
      sql/share/spanish/errmsg.txt:
        file parser errors
      sql/share/swedish/errmsg.txt:
        file parser errors
      sql/share/ukrainian/errmsg.txt:
        file parser errors
      BitKeeper/etc/ignore:
        Added libmysqld/parse_file.cc to the ignore list
      e66b7405
    • unknown's avatar
      WL# 1729 Handler: error text for NDB errors · f84be2fd
      unknown authored
      - Close an open scan if index_read is called without closing the previous one.
      - Removed some errors that occured during previous merge
      
      
      include/mysqld_error.h:
        Added two new error messages for NDB
      sql/ha_ndbcluster.cc:
        Added more error code mappings, from NDB code to MySQL 
        Added function to print out the error message when an NDB error occurs.
        Added two new error codes, which will represent either a permanent or temporary NDB error.
        Modev get_ndb_lock_type from class to local function
        Removed some merge errors
        New function close_scan, to close an open scan.
      sql/ha_ndbcluster.h:
        Added print_error function, overrides handler::print_error
        Added close_scan
        Moved get_ndb_lock_type from class to local function
      sql/share/czech/errmsg.txt:
        Added two new error messages for NDB
      sql/share/danish/errmsg.txt:
        Added two new error messages for NDB
      sql/share/dutch/errmsg.txt:
        Added two new error messages for NDB
      sql/share/english/errmsg.txt:
        Added two new error messages for NDB
      sql/share/estonian/errmsg.txt:
        Added two new error messages for NDB
      sql/share/french/errmsg.txt:
        Added two new error messages for NDB
      sql/share/german/errmsg.txt:
        Added two new error messages for NDB
      sql/share/greek/errmsg.txt:
        Added two new error messages for NDB
      sql/share/hungarian/errmsg.txt:
        Added two new error messages for NDB
      sql/share/italian/errmsg.txt:
        Added two new error messages for NDB
      sql/share/japanese/errmsg.txt:
        Added two new error messages for NDB
      sql/share/korean/errmsg.txt:
        Added two new error messages for NDB
      sql/share/norwegian-ny/errmsg.txt:
        Added two new error messages for NDB
      sql/share/norwegian/errmsg.txt:
        Added two new error messages for NDB
      sql/share/polish/errmsg.txt:
        Added two new error messages for NDB
      sql/share/portuguese/errmsg.txt:
        Added two new error messages for NDB
      sql/share/romanian/errmsg.txt:
        Added two new error messages for NDB
      sql/share/russian/errmsg.txt:
        Added two new error messages for NDB
      sql/share/serbian/errmsg.txt:
        Added two new error messages for NDB
      sql/share/slovak/errmsg.txt:
        Added two new error messages for NDB
      sql/share/spanish/errmsg.txt:
        Added two new error messages for NDB
      sql/share/swedish/errmsg.txt:
        Added two new error messages for NDB
      sql/share/ukrainian/errmsg.txt:
        Added two new error messages for NDB
      f84be2fd
  21. 28 Apr, 2004 1 commit
    • unknown's avatar
      Post-merge fixes, some quite complex. client/mysqlbinlog.cc and sql/log_event.cc · 2eecc377
      unknown authored
      merged manually by guilhem.
      
      
      client/mysqlbinlog.cc:
        Post-merge fixes; manually merged by guilhem.
      include/mysqld_error.h:
        Post-merge fixes.
      mysql-test/r/drop_temp_table.result:
        Post-merge fixes.
      mysql-test/r/insert.result:
        Post-merge fixes.
      mysql-test/r/mysqlbinlog.result:
        Post-merge fixes.
      mysql-test/r/query_cache.result:
        Post-merge fixes.
      mysql-test/r/rpl_error_ignored_table.result:
        Post-merge fixes.
      mysql-test/r/rpl_relayrotate.result:
        Post-merge fixes.
      mysql-test/r/rpl_trunc_binlog.result:
        Post-merge fixes.
      mysql-test/r/sp-error.result:
        Post-merge fixes.
      mysql-test/r/sp.result:
        Post-merge fixes.
      mysql-test/r/system_mysql_db.result:
        Post-merge fixes.
      mysql-test/r/variables.result:
        Post-merge fixes.
      mysql-test/t/rpl_error_ignored_table.test:
        Post-merge fixes.
      mysql-test/t/sp-error.test:
        Post-merge fixes.
      sql/ha_innodb.cc:
        Post-merge fixes.
      sql/log_event.cc:
        Post-merge fixes; manually merged by guilhem.
      sql/set_var.cc:
        Post-merge fixes.
      sql/share/danish/errmsg.txt:
        Post-merge fixes.
      sql/share/dutch/errmsg.txt:
        Post-merge fixes.
      sql/share/english/errmsg.txt:
        Post-merge fixes.
      sql/share/estonian/errmsg.txt:
        Post-merge fixes.
      sql/sp.cc:
        Post-merge fixes.
      sql/sql_insert.cc:
        Post-merge fixes.
      sql/sql_table.cc:
        Post-merge fixes.
      2eecc377
  22. 07 Apr, 2004 1 commit
    • unknown's avatar
      new error for unsupported command in PS · c9d856c8
      unknown authored
      fixed IN subselect with basic constant left expression
      SQLCOM_CREATE_TABLE, SQLCOM_UPDATE_MULTI, SQLCOM_REPLACE_SELECT, SQLCOM_INSERT_SELECT, QLCOM_DELETE_MULTI fixed to be compatible with PS (BUG#3398, BUG#3406)
      fixed multiupdate privelege check (BUG#3408)
      fixed multiupdate tables check (BUG#3411)
      unchecked commands now is rejected by PS protocol to avoid serever crash
      fixed cleunup procedure to be compatible sith DO/SET (BUG#3393)
      
      
      include/mysqld_error.h:
        new error for unsupported command in PS
      mysql-test/r/multi_update.result:
        test sutes (BUG#3408, BUG#3411)
      mysql-test/t/multi_update.test:
        test sutes (BUG#3408, BUG#3411)
      sql/item_cmpfunc.cc:
        fixed IN subselect with basic constant left expression
      sql/mysql_priv.h:
        some function frop sql_parse.h become public
      sql/set_var.cc:
        check for SET command via PS
      sql/set_var.h:
        check for SET command via PS
      sql/share/czech/errmsg.txt:
        new error for unsupported command in PS
      sql/share/danish/errmsg.txt:
        new error for unsupported command in PS
      sql/share/dutch/errmsg.txt:
        new error for unsupported command in PS
      sql/share/english/errmsg.txt:
        new error for unsupported command in PS
      sql/share/estonian/errmsg.txt:
        new error for unsupported command in PS
      sql/share/french/errmsg.txt:
        new error for unsupported command in PS
      sql/share/german/errmsg.txt:
        new error for unsupported command in PS
      sql/share/greek/errmsg.txt:
        new error for unsupported command in PS
      sql/share/hungarian/errmsg.txt:
        new error for unsupported command in PS
      sql/share/italian/errmsg.txt:
        new error for unsupported command in PS
      sql/share/japanese/errmsg.txt:
        new error for unsupported command in PS
      sql/share/korean/errmsg.txt:
        new error for unsupported command in PS
      sql/share/norwegian-ny/errmsg.txt:
        new error for unsupported command in PS
      sql/share/norwegian/errmsg.txt:
        new error for unsupported command in PS
      sql/share/polish/errmsg.txt:
        new error for unsupported command in PS
      sql/share/portuguese/errmsg.txt:
        new error for unsupported command in PS
      sql/share/romanian/errmsg.txt:
        new error for unsupported command in PS
      sql/share/russian/errmsg.txt:
        new error for unsupported command in PS
      sql/share/serbian/errmsg.txt:
        new error for unsupported command in PS
      sql/share/slovak/errmsg.txt:
        new error for unsupported command in PS
      sql/share/spanish/errmsg.txt:
        new error for unsupported command in PS
      sql/share/swedish/errmsg.txt:
        new error for unsupported command in PS
      sql/share/ukrainian/errmsg.txt:
        new error for unsupported command in PS
      sql/sql_lex.cc:
        first table unlincking procedures for CREATE command
      sql/sql_lex.h:
        first table unlincking procedures for CREATE command
      sql/sql_parse.cc:
        used function to exclude first table from list
        SQLCOM_CREATE_TABLE, SQLCOM_UPDATE_MULTI, SQLCOM_REPLACE_SELECT, SQLCOM_INSERT_SELECT, QLCOM_DELETE_MULTI fixed to be compatible with PS (BUG#3398, BUG#3406)
        fixed multiupdate privelege check (BUG#3408)
        fixed multiupdate tables check (BUG#3411)
      sql/sql_prepare.cc:
        fixed a lot of commands to be compatible with PS
        unchecked commands now is rejected to avoid serever crash
      sql/sql_select.cc:
        allow empty result for PS preparing
      sql/sql_union.cc:
        fixed cleunup procedure to be compatible sith DO/SET (BUG#3393)
      sql/sql_update.cc:
        fixed update to use correct tables lists (BUG#3408)
      sql/table.h:
        flag to support multi update tables check (BUG#3408)
      tests/client_test.c:
        removed unsupported tables
        fixed show table test
        added new tests
      c9d856c8
  23. 02 Apr, 2004 1 commit
    • unknown's avatar
      WL#1266 "Separate auto-set logic from TIMESTAMP type." · 32b28f92
      unknown authored
      Final version of patch.
      
      Adds support for specifying of DEFAULT NOW() and/or ON UPDATE NOW()
      clauses for TIMESTAMP field definition.
      Current implementation allows only one such field per table and
      uses several unireg types for storing info about this properties of
      field. It should be replaced with better implementation when new
      .frm format is introduced.
      
      
      include/mysqld_error.h:
        Added error codes for case when we have more than one column with NOW()
        in DEFAULT or ON UPDATE clauses and for case when we are using ON UPDATE
        clause with wrong type.
      mysql-test/r/create.result:
        Added tests for using of DEFAULT NOW() and ON UPDATE NOW() with
        non-TIMESTAMP fields.
      mysql-test/r/show_check.result:
        Updated test results to reflect new default look of TIMESTAMP fields
        in SHOW CREATE TABLE.
      mysql-test/r/system_mysql_db.result:
        Updated test results to reflect new default look of TIMESTAMP fields
        in SHOW CREATE TABLE.
      mysql-test/r/type_ranges.result:
        Updated test results to reflect new default look of TIMESTAMP fields
        in SHOW COLUMNS.
      mysql-test/r/type_timestamp.result:
        Added tests for various DEFAULT and ON UPDATE clauses for TIMESTAMP
        fields definitions.
      mysql-test/t/create.test:
        Added tests for using of DEFAULT NOW() and ON UPDATE NOW() with
        non-TIMESTAMP fields.
      mysql-test/t/type_timestamp.test:
        Added tests for various DEFAULT and ON UPDATE clauses for TIMESTAMP
        fields definitions.
      sql/field.cc:
        Added support for various combinations of DEFAULT and ON UPDATE clauses
        for TIMESTAMP field. 
        
        Setting TABLE::timestamp* members for TIMESTAMP fields with auto-set 
        option taking into account their unireg type (which corresponds to 
        various DEFAULT/ON UPDATE values combinations). Replaced 
        TABLE::time_stamp with TABLE::timestamp_default_now/on_update_now
        couple moved their setup to separate method set_timestamp_offsets(),
        which now is called from  open_table instead of Field_timestamp cons.
      sql/field.h:
        Added more unireg types for handling of DEFAULT NOW() and ON UPDATE
        NOW() for TIMESTAMP fields.
        Fixed value corresponding to DEFAULT item for TIMESTAMP field.
      sql/ha_berkeley.cc:
        Now TIMESTAMP column with auto-set property could be updated during
        INSERT or/and UPDATE independently.
      sql/ha_heap.cc:
        Now TIMESTAMP column with auto-set property could be updated during
        INSERT or/and UPDATE independently.
      sql/ha_innodb.cc:
        Now TIMESTAMP column with auto-set property could be updated during
        INSERT or/and UPDATE independently.
      sql/ha_isam.cc:
        Now TIMESTAMP column with auto-set property could be updated during
        INSERT or/and UPDATE independently.
      sql/ha_isammrg.cc:
        Now TIMESTAMP column with auto-set property could be updated during
        INSERT or/and UPDATE independently.
      sql/ha_myisam.cc:
        Now TIMESTAMP column with auto-set property could be updated during
        INSERT or/and UPDATE independently.
      sql/ha_myisammrg.cc:
        Now TIMESTAMP column with auto-set property could be updated during
        INSERT or/and UPDATE independently.
      sql/item_func.h:
        We need to distinguish NOW() from other function for using in 
        DEFAULT and in ON UPDATE clauses.
      sql/item_timefunc.h:
        We need to distinguish NOW() from other function for using in 
        DEFAULT and in ON UPDATE clauses.
      sql/mysql_priv.h:
        Added parameter for ON UPDATE value to add_field_to_list() function.
      sql/share/czech/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/danish/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/dutch/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/english/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/estonian/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/french/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/german/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/greek/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/hungarian/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/italian/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/japanese/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/korean/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/norwegian-ny/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/norwegian/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/polish/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/portuguese/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/romanian/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/russian/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/serbian/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/slovak/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/spanish/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/swedish/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/share/ukrainian/errmsg.txt:
        Added error messages for case when we have more than one column with
        NOW() (CURRENT_TIMESTAMP is just more standard alias) in DEFAULT or 
        ON UPDATE clauses and for case when we are using ON UPDATE clause with
        wrong type.
      sql/sql_base.cc:
        Added setup of TABLE::timestamp_default_now/on_update_now pair
        for each statement to open_table().
      sql/sql_insert.cc:
        Using TABLE::timestamp_default_now/on_update_now pair instead of
        old TABLE::time_stamp. Added check for case then REPLACE could not
        be converted to UPDATE because of different DEFAULT/ON UPDATE values
        for TIMESTAMP field.
      sql/sql_lex.h:
        Added member for value used in ON UPDATE clause to st_lex.
      sql/sql_load.cc:
        Using TABLE::timestamp_default_now/on_update_now pair instead of
        old TABLE::time_stamp. We don't need to restore these members
        since they are set up for each statement in open_table().
      sql/sql_parse.cc:
        Added handling of DEFAULT NOW() and ON UPDATE NOW() clauses for
        TIMESTAMP fields to add_field_to_list() function.
      sql/sql_show.cc:
        Added support for DEFAULT CURRENT_TIMESTAMP (aka NOW() ) and 
        ON UPDATE CURRENT_TIMESTAMP to SHOW CREATE TABLE and SHOW COLUMNS.
      sql/sql_table.cc:
        mysql_create_table() function - added check for number of TIMESTAMP 
          fields with auto-set values and replacing of old style TIMESTAMPs
          with their newer analogs.
        mysql_alter_table(): Using TABLE::timestamp_default_now/on_update_now 
          pair instead of old TABLE::time_stamp. We don't need to restore these
          members since they are set up for each statement in open_table().
      sql/sql_update.cc:
        Left only setting of TABLE::timestamp_default_now/on_update_now
        to 0 since they should be already set up in open_table().
      sql/sql_yacc.yy:
        Added support for DEFAULT NOW() and ON UPDATE NOW() in field
        definitions.
      sql/table.h:
        Replaced TABLE::time_stamp withTABLE::timestamp_default_now/timestamp_on_update_now
        pair which allows to distinguish TIMESTAMP's with various DEFAULT/ON UPDATE
        clauses and optimize checks if TIMESTAMP field should be set to NOW()
        in handlers.
      sql/unireg.cc:
        Now we are marking only TIMESTAMP fields with NOW() as default or
        as on update value as special field for unireg.
      32b28f92
  24. 29 Mar, 2004 2 commits
    • unknown's avatar
      Fixed BUG#3287: Stored Procedure Case Statement Not SQL:2003 Compliant. · 5c7f368b
      unknown authored
      include/mysqld_error.h:
        New error code for missing ELSE in SP CASE statement.
      include/sql_state.h:
        New error code for missing ELSE in SP CASE statement.
      mysql-test/r/sp-error.result:
        Test case for missing ELSE in SP CASE statement.
      mysql-test/t/sp-error.test:
        Test case for missing ELSE in SP CASE statement.
      sql/share/czech/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/danish/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/dutch/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/english/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/estonian/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/french/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/german/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/greek/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/hungarian/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/italian/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/japanese/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/korean/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/norwegian-ny/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/norwegian/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/polish/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/portuguese/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/romanian/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/russian/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/serbian/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/slovak/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/spanish/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/swedish/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/share/ukrainian/errmsg.txt:
        New error message for missing ELSE in SP CASE statement.
      sql/sql_yacc.yy:
        Generate run-time error instruction when no ELSE in SP CASE statement.
      5c7f368b
    • unknown's avatar
      Enforce standard declaration order in SPs. · 7456a3e9
      unknown authored
      Added new test cases for this, and adjusted old tests accordingly,
      and new error codes and messages.
      Fixed bugs in some tests (bug2673 and use test).
      Added debug printing of instructions in SPs.
      
      
      include/mysqld_error.h:
        New error codes for non-standard declaration order in SPs.
      include/sql_state.h:
        New error codes for non-standard declaration order in SPs.
      mysql-test/r/sp-error.result:
        Enforce standard declaration order.
        Fixed syntax error in use-test.
        New test cases for wrong order.
      mysql-test/r/sp.result:
        Enforce strict declaration order.
        Fixed platform dependent bug2673 test.
      mysql-test/t/sp-error.test:
        Enforce standard declaration order.
        Fixed syntax error in use-test.
        New test cases for wrong order.
      mysql-test/t/sp.test:
        Enforce strict declaration order.
        Fixed platform dependent bug2673 test.
      sql/share/czech/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/danish/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/dutch/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/english/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/estonian/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/french/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/german/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/greek/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/hungarian/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/italian/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/japanese/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/korean/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/norwegian-ny/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/norwegian/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/polish/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/portuguese/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/romanian/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/russian/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/serbian/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/slovak/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/spanish/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/swedish/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/share/ukrainian/errmsg.txt:
        New error messages for strict (standard) declaration order in SPs.
      sql/sp_head.cc:
        Debug printing of instructions in procedures.
        New error instruction for future use.
      sql/sp_head.h:
        Debug printing of instructions in procedures.
        New error instruction for future use.
      sql/sql_string.cc:
        New methods needed by debug printing of instruction in SPs.
      sql/sql_string.h:
        New methods needed by debug printing of instruction in SPs.
      sql/sql_yacc.yy:
        Check for standard order of declarations in SPs.
      7456a3e9
  25. 15 Mar, 2004 1 commit
    • unknown's avatar
      Task #835: additional changes fot str_to_date · afedd9f8
      unknown authored
      include/mysqld_error.h:
        Task #835: additional changes fot str_to_date
        New error message
      mysql-test/r/date_formats.result:
        Task #835: additional changes fot str_to_date
        tests
      mysql-test/r/func_sapdb.result:
        Task #835: additional changes fot str_to_date
        tests
      mysql-test/r/func_time.result:
        Task #835: additional changes fot str_to_date
        tests
      mysql-test/r/type_time.result:
        Task #835: additional changes fot str_to_date
        tests
      mysql-test/t/date_formats.test:
        Task #835: additional changes fot str_to_date
        tests
      mysql-test/t/func_sapdb.test:
        Task #835: additional changes fot str_to_date
        tests
      mysql-test/t/func_time.test:
        Task #835: additional changes fot str_to_date
        tests
      sql/share/czech/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/danish/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/dutch/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/english/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/estonian/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/french/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/german/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/greek/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/hungarian/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/italian/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/japanese/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/korean/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/norwegian-ny/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/norwegian/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/polish/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/portuguese/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/romanian/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/russian/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/serbian/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/slovak/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/spanish/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/swedish/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      sql/share/ukrainian/errmsg.txt:
        Task #835: additional changes fot str_to_date
        New error message
      afedd9f8
  26. 13 Mar, 2004 1 commit
    • unknown's avatar
      fixed bug #1427 "enum allows duplicate values in the list" · 5a67c11c
      unknown authored
      include/mysqld_error.h:
        added ER_DUPLICATED_VALUE_IN_TYPE
      mysql-test/r/create.result:
        added test for bug #1427 "enum allows duplicate values in the list"
      mysql-test/t/create.test:
        added test for bug #1427 "enum allows duplicate values in the list"
      sql/share/czech/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/danish/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/dutch/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/english/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/estonian/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/french/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/german/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/greek/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/hungarian/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/italian/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/japanese/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/korean/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/norwegian-ny/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/norwegian/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/polish/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/portuguese/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/romanian/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/russian/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/serbian/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/slovak/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/spanish/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/swedish/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/share/ukrainian/errmsg.txt:
        added message for ER_DUPLICATED_VALUE_IN_TYPE
      sql/sql_table.cc:
        added function check_duplicates_in_interval and 
        calling it from mysql_create_table for enum and set
      5a67c11c
  27. 11 Mar, 2004 1 commit
    • unknown's avatar
      WL#1366: Use the schema (db) associated with an SP. · eb4aa092
      unknown authored
      Phase 2: Make SPs belong to a DB, and use qualified names.
        As a side effect, using USE in an SP is no longer allowed.
        (It just doesn't work otherwise.)
      
      
      include/mysqld_error.h:
        New error code (USE is no longer allowed in a stored procedure).
      include/sql_state.h:
        New error state (USE is no longer allowed in a stored procedure).
      mysql-test/r/sp-error.result:
        Updated result for test of USE in SP (not allowed now).
      mysql-test/r/sp-security.result:
        Updated test results for new db column and qualified procedured names.
      mysql-test/r/sp.result:
        Updated results for USE in SP (as it's no longer allowed), and
        for new db column in status result.
      mysql-test/t/sp-error.test:
        Moved test of USE in SP from sp.test (as it's no longer allowed).
      mysql-test/t/sp-security.test:
        Ajusted tests for new db column and qualified procedured names.
      mysql-test/t/sp.test:
        Moved test of USE in SP to sp-error.test (as it's no longer allowed).
        Adjusted tests for new db column in status result.
      sql/mysql_priv.h:
        mysql_change_db() now has optional arguments for use by SP with qualified names.
      sql/share/czech/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/danish/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/dutch/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/english/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/estonian/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/french/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/german/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/greek/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/hungarian/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/italian/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/japanese/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/korean/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/norwegian-ny/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/norwegian/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/polish/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/portuguese/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/romanian/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/russian/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/serbian/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/slovak/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/spanish/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/swedish/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/share/ukrainian/errmsg.txt:
        New error message: USE is not allowed in a stored procedure.
      sql/sp.cc:
        SPs are now "belong" to a DB and may have qualified names.
        New functions for changing DB ("use") when parsing and invoking SPs.
      sql/sp.h:
        New functions for changing DB ("use") when parsing and invoking SPs.
      sql/sp_cache.cc:
        Use the qualified name in the SP cache.
      sql/sp_head.cc:
        New function for allocating a qualified SP name (used in sql_yacc.yy).
        Change DB when executing an SP (if needed).
        Moved thd_mem_root swap functions from sp_head.h.
      sql/sp_head.h:
        New function for allocating a qualified SP name (used in sql_yacc.yy).
        Moved thd_mem_root swap functions to sp_head.cc.
      sql/sql_db.cc:
        mysql_change_db() now has optional arguments for use by SP with qualified names
        (for use when reading an SP from database and executing it); also allow "unusing"
        a database, i.e. setting thd->thd to "".
      sql/sql_yacc.yy:
        Initialize qualfied SP names correctly.
        USE is no longer allowed in an SP.
      eb4aa092
  28. 07 Mar, 2004 1 commit
  29. 02 Mar, 2004 1 commit
  30. 29 Feb, 2004 1 commit
  31. 28 Feb, 2004 1 commit
    • unknown's avatar
      small after-merge fixes (error messages). · 45f39ff1
      unknown authored
      include/mysqld_error.h:
        more generic error code
      mysql-test/r/func_compress.result:
        update after message change
      mysql-test/r/loaddata.result:
        update after message change
      mysql-test/r/warnings.result:
        update after message change
      sql/share/czech/errmsg.txt:
        message change
      sql/share/danish/errmsg.txt:
        message change
      sql/share/dutch/errmsg.txt:
        message change
      sql/share/english/errmsg.txt:
        message change
      sql/share/estonian/errmsg.txt:
        message change
      sql/share/french/errmsg.txt:
        message change
      sql/share/german/errmsg.txt:
        message change
      sql/share/greek/errmsg.txt:
        message change
      sql/share/hungarian/errmsg.txt:
        message change
      sql/share/italian/errmsg.txt:
        message change
      sql/share/japanese/errmsg.txt:
        message change
      sql/share/korean/errmsg.txt:
        message change
      sql/share/norwegian-ny/errmsg.txt:
        message change
      sql/share/norwegian/errmsg.txt:
        message change
      sql/share/polish/errmsg.txt:
        message change
      sql/share/portuguese/errmsg.txt:
        message change
      sql/share/romanian/errmsg.txt:
        message change
      sql/share/russian/errmsg.txt:
        message change
      sql/share/slovak/errmsg.txt:
        message change
      sql/share/spanish/errmsg.txt:
        message change
      sql/share/swedish/errmsg.txt:
        message change
      sql/share/ukrainian/errmsg.txt:
        message change
      45f39ff1
  32. 22 Feb, 2004 1 commit