An error occurred fetching the project authors.
  1. 02 Sep, 2004 1 commit
    • 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 07 Jul, 2004 1 commit
  8. 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
  9. 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
  10. 16 Jun, 2004 5 commits
  11. 15 Jun, 2004 1 commit
  12. 21 May, 2004 1 commit
    • unknown's avatar
      WL#1622 "SQL Syntax for Prepared Statements": Post-review fixes (1 of 2) · e7710af7
      unknown authored
      mysql-test/r/ps.result:
        Added tests for PREPARE stmt1 FROM @var syntax
      mysql-test/t/ps.test:
        Added tests for PREPARE stmt1 FROM @var syntax
      mysys/my_error.c:
        Added support for "%.*s" format
      sql/item.cc:
        Removed one redundant Item_param::set_value function
      sql/item.h:
        Removed one redundant Item_param::set_value function
      sql/mysqld.cc:
        Reformmated the code
      sql/share/czech/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/share/dutch/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/share/english/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/share/estonian/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/share/french/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/share/german/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/share/greek/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/share/hungarian/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/share/italian/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/share/japanese/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/share/korean/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/share/norwegian-ny/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/share/norwegian/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/share/polish/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/share/portuguese/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/share/romanian/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/share/russian/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/share/slovak/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/share/spanish/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/share/swedish/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/share/ukrainian/errmsg.txt:
        Changed ER_UNKNOWN_STMT_HANDLER format string
      sql/sql_class.h:
        SQL Prepared statements now can't be used by binary protocol commands
      sql/sql_lex.h:
        Added support for PREPARE stmt1 FROM @var syntax.
      sql/sql_parse.cc:
        Added support for PREPARE stmt1 FROM @var syntax.
      sql/sql_prepare.cc:
        Code cleanup
      sql/sql_yacc.yy:
        Added support for PREPARE stmt1 FROM @var syntax.
      e7710af7
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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
  21. 07 Mar, 2004 1 commit
  22. 02 Mar, 2004 1 commit
  23. 29 Feb, 2004 1 commit
  24. 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
  25. 22 Feb, 2004 1 commit
  26. 21 Feb, 2004 1 commit
    • unknown's avatar
      Fix for BUG#2757 · d68c56a4
      unknown authored
      "--read-only gives weird error on update".
      It is not fixable in 4.0 because it requires modifying
      the sql/share/*/errmsg.txt files. So it is fixed in 4.1 like this:
      the ER_SKIP_GRANT_TABLES is replaced by a more generic
      ER_OPTION_PREVENTS_STATEMENT which can be used both for
      "can't do this because of --skip-grant-tables" and
      "can't do this because of --read-only" (for this we don't use
      ER_CANT_UPDATE_WITH_READLOCK anymore).
      So now the message for --read-only is:
      "The MySQL server is running with the --read-only option so
      cannot execute this statement".
      
      
      include/mysqld_error.h:
        more general naming as more general message
      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/serbian/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
      sql/sql_acl.cc:
        Changes to use the more generic ER_OPTION_PREVENTS_STATEMENT
        instead of ER_SKIP_GRANT_TABLES:
        * use of net_printf() instead of send_error() (because send_error()
        does not support printf-like format).
        * in some places we now just do my_error() and return -1
        (only caller is mysql_execute_command() which does send_error()
        if result is -1).
        * Replaced my_printf_error() by simpler my_error() (except in 2 locations
        where there was a "we must use my_printf_error()" comment).
      sql/sql_parse.cc:
        new error code (more generic).
      d68c56a4
  27. 15 Feb, 2004 1 commit
    • unknown's avatar
      no dots in the error messages! · f7f02b48
      unknown authored
      --disable-warning in union.test
      
      
      mysql-test/t/union.test:
        cleanup
      sql/share/czech/errmsg.txt:
        no dots in the error messages!
      sql/share/danish/errmsg.txt:
        no dots in the error messages!
      sql/share/dutch/errmsg.txt:
        no dots in the error messages!
      sql/share/english/errmsg.txt:
        no dots in the error messages!
      sql/share/estonian/errmsg.txt:
        no dots in the error messages!
      sql/share/french/errmsg.txt:
        no dots in the error messages!
      sql/share/german/errmsg.txt:
        no dots in the error messages!
      sql/share/greek/errmsg.txt:
        no dots in the error messages!
      sql/share/hungarian/errmsg.txt:
        no dots in the error messages!
      sql/share/italian/errmsg.txt:
        no dots in the error messages!
      sql/share/japanese/errmsg.txt:
        no dots in the error messages!
      sql/share/korean/errmsg.txt:
        no dots in the error messages!
      sql/share/norwegian-ny/errmsg.txt:
        no dots in the error messages!
      sql/share/norwegian/errmsg.txt:
        no dots in the error messages!
      sql/share/polish/errmsg.txt:
        no dots in the error messages!
      sql/share/portuguese/errmsg.txt:
        no dots in the error messages!
      sql/share/romanian/errmsg.txt:
        no dots in the error messages!
      sql/share/russian/errmsg.txt:
        no dots in the error messages!
      sql/share/serbian/errmsg.txt:
        no dots in the error messages!
      sql/share/slovak/errmsg.txt:
        no dots in the error messages!
      sql/share/spanish/errmsg.txt:
        no dots in the error messages!
      sql/share/swedish/errmsg.txt:
        no dots in the error messages!
      sql/share/ukrainian/errmsg.txt:
        no dots in the error messages!
      f7f02b48
  28. 26 Jan, 2004 1 commit
  29. 23 Jan, 2004 1 commit
  30. 04 Jan, 2004 1 commit
    • unknown's avatar
      allow UPDATE and DELETE stetements with tables derived from subquery if they... · fbf563e8
      unknown authored
      allow UPDATE and DELETE stetements with tables derived from subquery if they are not updated (BUG#2117)
      allow delete table by alias in multi-delete statement
      
      
      
      include/mysqld_error.h:
        new error message about non-updateable table
      mysql-test/r/derived.result:
        test of multi-update and multi-delete
      mysql-test/t/derived.test:
        test of multi-update and multi-delete
      sql/share/czech/errmsg.txt:
        new error message about non-updateable table
      sql/share/danish/errmsg.txt:
        new error message about non-updateable table
      sql/share/dutch/errmsg.txt:
        new error message about non-updateable table
      sql/share/english/errmsg.txt:
        new error message about non-updateable table
      sql/share/estonian/errmsg.txt:
        new error message about non-updateable table
      sql/share/french/errmsg.txt:
        new error message about non-updateable table
      sql/share/german/errmsg.txt:
        new error message about non-updateable table
      sql/share/greek/errmsg.txt:
        new error message about non-updateable table
      sql/share/hungarian/errmsg.txt:
        new error message about non-updateable table
      sql/share/italian/errmsg.txt:
        new error message about non-updateable table
      sql/share/japanese/errmsg.txt:
        new error message about non-updateable table
      sql/share/korean/errmsg.txt:
        new error message about non-updateable table
      sql/share/norwegian-ny/errmsg.txt:
        new error message about non-updateable table
      sql/share/norwegian/errmsg.txt:
        new error message about non-updateable table
      sql/share/polish/errmsg.txt:
        new error message about non-updateable table
      sql/share/portuguese/errmsg.txt:
        new error message about non-updateable table
      sql/share/romanian/errmsg.txt:
        new error message about non-updateable table
      sql/share/russian/errmsg.txt:
        new error message about non-updateable table
      sql/share/serbian/errmsg.txt:
        new error message about non-updateable table
      sql/share/slovak/errmsg.txt:
        new error message about non-updateable table
      sql/share/spanish/errmsg.txt:
        new error message about non-updateable table
      sql/share/swedish/errmsg.txt:
        new error message about non-updateable table
      sql/share/ukrainian/errmsg.txt:
        new error message about non-updateable table
      sql/sql_parse.cc:
        allow delete table by alias
        separate error message for try to delete derived table
      sql/sql_update.cc:
        test "is updated table derived?"
      sql/sql_yacc.yy:
        error message in case of try to update derived table
      fbf563e8
  31. 23 Dec, 2003 1 commit
  32. 19 Dec, 2003 1 commit
    • unknown's avatar
      Fixes after merge with 4.0 · 9c2a63e3
      unknown authored
      Cleaned up embedded library access and query cache handling
      Changed min stack size to 128K (to allow longer MyISAM keys)
      Fixed wrong priority for XOR (should be less than NEG to get -1^1 to work)
      
      
      client/mysqldump.c:
        Fixed bugs found after merge
      include/mysql_embed.h:
        Disable query cache when using embedded version
      myisam/mi_check.c:
        Removed not used variable
      mysql-test/r/auto_increment.result:
        Fixed bugs found after merge
      mysql-test/r/bdb.result:
        Fixed bugs found after merge
      mysql-test/r/func_group.result:
        Fixed bugs found after merge
      mysql-test/r/func_str.result:
        Fixed bugs found after merge
      mysql-test/r/func_time.result:
        Fixed bugs found after merge
      mysql-test/r/group_by.result:
        Fixed bugs found after merge
      mysql-test/r/innodb.result:
        Fixed bugs found after merge
      mysql-test/r/insert.result:
        Fixed bugs found after merge
      mysql-test/r/join_outer.result:
        Fixed bugs found after merge
      mysql-test/r/loaddata.result:
        Fixed bugs found after merge
      mysql-test/r/multi_update.result:
        Fixed bugs found after merge
      mysql-test/r/mysqldump.result:
        Update results
      mysql-test/r/rpl_EE_error.result:
        Fixed bugs found after merge
      mysql-test/r/rpl_multi_update.result:
        Fixed bugs found after merge
      mysql-test/r/symlink.result:
        Update results
      mysql-test/r/type_blob.result:
        Update results
      mysql-test/r/type_datetime.result:
        Update results
      mysql-test/r/type_decimal.result:
        Update results
      mysql-test/r/type_enum.result:
        Fixed bugs found after merge
      mysql-test/r/type_timestamp.result:
        Update results
      mysql-test/r/union.result:
        Update results
      mysql-test/r/warnings.result:
        Update results
      mysql-test/t/bdb.test:
        Fix test for 4.1
      mysql-test/t/innodb.test:
        Fix test for 4.1
      mysql-test/t/multi_update.test:
        Fix test for 4.1
      mysql-test/t/mysqldump.test:
        Fix test for 4.1
      mysql-test/t/rpl_EE_error.test:
        Fix test for 4.1
      mysql-test/t/rpl_multi_update.test:
        Fix test for 4.1
      mysql-test/t/union.test:
        Cleanup
      mysys/charset.c:
        Check results from my_once_alloc()
      mysys/my_handler.c:
        part of 4.0 merge
      sql-common/client.c:
        Part of 4.0 merge
      sql/field.cc:
        After merge fixes
      sql/field.h:
        After merge fixes
      sql/ha_innodb.cc:
        Remove duplicate include files
      sql/item.cc:
        Changed automatic int conversion to be of type binary
      sql/item.h:
        After merge fixes
      sql/item_func.cc:
        Changed automatic int conversion to be of type binary
      sql/item_func.h:
        After merge fixes
      sql/item_strfunc.cc:
        Added comments
      sql/item_subselect.cc:
        Indentation fixes
      sql/item_sum.cc:
        Changed automatic int conversion to be of type binary
      sql/item_sum.h:
        After merge fixes
      sql/mysql_priv.h:
        Cleanup embedded library access checks
      sql/mysqld.cc:
        Changed min stack size to 128K (to allow longer MyISAM keys)
      sql/set_var.cc:
        Fixed compiler warnings
      sql/share/czech/errmsg.txt:
        Better error message
      sql/share/danish/errmsg.txt:
        Better error message
      sql/share/dutch/errmsg.txt:
        Better error message
      sql/share/english/errmsg.txt:
        Better error message
      sql/share/estonian/errmsg.txt:
        Better error message
      sql/share/french/errmsg.txt:
        Better error message
      sql/share/greek/errmsg.txt:
        Better error message
      sql/share/hungarian/errmsg.txt:
        Better error message
      sql/share/italian/errmsg.txt:
        Better error message
      sql/share/japanese/errmsg.txt:
        Better error message
      sql/share/korean/errmsg.txt:
        Better error message
      sql/share/norwegian-ny/errmsg.txt:
        Better error message
      sql/share/norwegian/errmsg.txt:
        Better error message
      sql/share/polish/errmsg.txt:
        Better error message
      sql/share/romanian/errmsg.txt:
        Better error message
      sql/share/russian/errmsg.txt:
        Better error message
      sql/share/serbian/errmsg.txt:
        Better error message
      sql/share/slovak/errmsg.txt:
        Better error message
      sql/share/spanish/errmsg.txt:
        Better error message
      sql/share/swedish/errmsg.txt:
        Better error message
      sql/share/ukrainian/errmsg.txt:
        Better error message
      sql/sql_acl.h:
        Cleaned up embedded library acccess checks
      sql/sql_base.cc:
        After merge fixes
      sql/sql_client.cc:
        After merge fixes
      sql/sql_parse.cc:
        After merge fixes
        Changed access check code for embedded library (needed to make code shorter and ensure that check_table_access() is called)
        Recoded create-table handling for CREATE TABLE ... SELECT to make code shorter and faster
      sql/sql_prepare.cc:
        Add missing arguments
      sql/sql_select.cc:
        After merge fixes
      sql/sql_update.cc:
        After merge fixes
      sql/sql_yacc.yy:
        Fixed wrong priority for XOR (should be less than NEG to get -1^1 to work)
      sql/table.cc:
        After merge fixes
      9c2a63e3
  33. 17 Dec, 2003 1 commit
    • unknown's avatar
      added error message for receiving variable with wrong GLOBAL|LOCAL type · d6be93aa
      unknown authored
      (bug #2086)
      
      
      include/mysqld_error.h:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      mysql-test/r/variables.result:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      mysql-test/t/variables.test:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/set_var.cc:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/czech/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/danish/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/dutch/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/english/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/estonian/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/french/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/german/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/greek/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/hungarian/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/italian/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/japanese/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/korean/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/norwegian-ny/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/norwegian/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/polish/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/portuguese/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/romanian/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/russian/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/slovak/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/spanish/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/swedish/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      sql/share/ukrainian/errmsg.txt:
        added error message for receiving variable with wrong GLOBAL|LOCAL type
      d6be93aa