1. 07 Oct, 2004 7 commits
    • unknown's avatar
      Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-5.0 · 32755eb5
      unknown authored
      into sanja.is.com.ua:/home/bell/mysql/bk/work-error-5.0
      
      
      sql/sql_yacc.yy:
        Auto merged
      32755eb5
    • unknown's avatar
      allow merging views with subqueries in WHERE clause (BUG#5504) · 838ccf19
      unknown authored
      
      mysql-test/r/view.result:
        test of subqueries in merged views
      mysql-test/t/view.test:
        test of subqueries in merged views
      sql/item_subselect.h:
        new method tu return place of subquery
      sql/sql_lex.cc:
        allow merging views with subqueries in WHERE clause
      sql/sql_view.cc:
        allow merging views with subqueries in WHERE clause
      838ccf19
    • unknown's avatar
      Revised BUG#5000: SPs can be created with no default database. · b2670a67
      unknown authored
      Now simply give an error if no database. (The "global SP feature" will be
      done using PATH instead.)
      
      
      mysql-test/r/sp-error.result:
        Removed test cases for undone "feature".
      mysql-test/t/sp-error.test:
        Removed test cases for undone "feature".
      sql/sql_parse.cc:
        Check if created procedure/function has a database; give error if not.
      sql/sql_yacc.yy:
        Undid the "global SP feature".
      b2670a67
    • unknown's avatar
      Fix results (becasue of strict mode) · 6b4ec894
      unknown authored
      6b4ec894
    • unknown's avatar
      test of DELETE privilege and cyclic reference added in case of altering view (BUG#5148) · e99d1415
      unknown authored
      fixed ALTER VIEW syntax
      fixed WITH CHECK OPTION clause printing in SHOW CREATE VIEW
      
      
      mysql-test/r/view.result:
        test of VIEW altering
      mysql-test/t/view.test:
        test of VIEW altering
      sql/lex.h:
        explicitly mentioned undefined algorithm
      sql/sql_show.cc:
        explicitly mentioned undefined algorithm
        added printing WITH CHECK OPTION clause
      sql/sql_view.cc:
        test of DELETE privilege and cyclic reference added in case of altering view
        effective and requested WITH CHECK OPTION parameters divided
      sql/sql_yacc.yy:
        fixed ALTER VIEW
      sql/table.cc:
        effective and requested WITH CHECK OPTION parameters divided
      sql/table.h:
        effective and requested WITH CHECK OPTION parameters divided
      e99d1415
    • unknown's avatar
      Updates tests after 'no automatic default' patch · 42c9b8d0
      unknown authored
      42c9b8d0
    • unknown's avatar
      sql_updatable_view_key replaced with updatable_views_with_limit · 95335c64
      unknown authored
      now default behaviour do not prevent any updates of view.
      Also updating VIEWs of queries without LIMIT clause will not be checked at all (there will not be even warning)
      (changes according to discussion on last dev-conf)
      
      
      mysql-test/r/view.result:
        sql_updatable_view_key replaced with updatable_views_with_limit, default behaviour changed
      mysql-test/t/view.test:
        sql_updatable_view_key replaced with updatable_views_with_limit, default behaviour changed
      sql/mysqld.cc:
        sql_updatable_view_key replaced with updatable_views_with_limit, default behaviour changed
      sql/set_var.cc:
        sql_updatable_view_key replaced with updatable_views_with_limit, default behaviour changed
      sql/sql_class.h:
        sql_updatable_view_key replaced with updatable_views_with_limit, default behaviour changed
      sql/sql_view.cc:
        sql_updatable_view_key replaced with updatable_views_with_limit, default behaviour changed
      sql/sql_view.h:
        sql_updatable_view_key replaced with updatable_views_with_limit, default behaviour changed
      95335c64
  2. 06 Oct, 2004 1 commit
    • unknown's avatar
      fixed & added comments (according to Igor's review and a bit more) · d75b2662
      unknown authored
      
      sql/item_strfunc.h:
        spelling fixed
      sql/parse_file.cc:
        spelling fixed
      sql/parse_file.h:
        spelling fixed
      sql/password.c:
        spelling fixed
      sql/sql_acl.cc:
        spelling fixed
      sql/sql_lex.cc:
        comments added and fixed
      sql/sql_parse.cc:
        spelling fixed
      sql/sql_show.cc:
        spelling fixed
      sql/sql_update.cc:
        comments fixed
      sql/sql_view.cc:
        comments added
        spelling and comments fixed
        // comments changed with /* */ ones
      sql/sql_yacc.yy:
        comments fixed
      sql/table.cc:
        spelling fixed
        comments added and fixed
      sql/table.h:
        spelling fixed
        comments fixed
      d75b2662
  3. 05 Oct, 2004 2 commits
    • unknown's avatar
      join_outer.result, join_outer.test: · ec522a9e
      unknown authored
        Added a test case for bug #5896.
      sql_select.cc:
        Fixed the problem of ignoring on expressions depending
        only on outer table when outer table either contains
        1 row or is guaranteed to return only 1 row (bug #5896).
      
      
      sql/sql_select.cc:
        Fixed the problem of ignoring on expressions depending
        only on outer tables when outer tables either contained
        1 row or is guaranteed to return not more than 1 row.
        (bug #5896).
      mysql-test/t/join_outer.test:
        Added a test case for bug #5896.
      mysql-test/r/join_outer.result:
        Added a test case for bug #5896.
      ec522a9e
    • unknown's avatar
      After merge fixes · 7779c1e5
      unknown authored
      
      mysql-test/r/mysqldump.result:
        Fixed tests (changed becasue of new checking of float numbers during parsing)
      7779c1e5
  4. 04 Oct, 2004 5 commits
    • unknown's avatar
      merge · 167daf8a
      unknown authored
      
      mysql-test/r/sp.result:
        Auto merged
      sql/sql_insert.cc:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      sql/sql_update.cc:
        Auto merged
      sql/sql_yacc.yy:
        Auto merged
      sql/table.cc:
        Auto merged
      167daf8a
    • unknown's avatar
      Fixed bug in strict mode (A state was not properly cleared on successful insert/update's) · 527c7678
      unknown authored
      
      mysql-test/mysql-test-run.sh:
        Print less text on failure
      mysql-test/r/strict.result:
        More tests for strict mode
      mysql-test/t/strict.test:
        More tests for strict mode
      sql/set_var.cc:
        Don't clear any flags in traditional mode
      sql/sql_insert.cc:
        Fixed bug in strict mode
      sql/sql_update.cc:
        Fixed bug in strict mode
      527c7678
    • unknown's avatar
      merge · 3f9e73b0
      unknown authored
      
      sql/sql_class.h:
        Auto merged
      sql/sql_parse.cc:
        Auto merged
      sql/sql_update.cc:
        Auto merged
      sql/table.cc:
        Auto merged
      3f9e73b0
    • unknown's avatar
      postmerge fix · 4b00f6b9
      unknown authored
      4b00f6b9
    • unknown's avatar
      fixed problem with freeing stack memory · 7e0e04f0
      unknown authored
      7e0e04f0
  5. 02 Oct, 2004 1 commit
    • unknown's avatar
      More fixes for strict mode: · d4f0cdc5
      unknown authored
      More tests.
      Better error messages.
      Fixed bug when checking if we updated all needed columns for INSERT.
      Give an error if we encounter a wrong float value during parsing.
      Don't print DEFAULT for columns without a default value in SHOW CREATE/SHOW FIELDS.
      Fixed UPDATE IGNORE when using STRICT mode.
      
      
      include/mysqld_error.h:
        More error messages for strict mode
      include/sql_state.h:
        Fixed wrong state
        New error message
      mysql-test/r/alter_table.result:
        Updated results for not automatic default fields
      mysql-test/r/auto_increment.result:
        Better error messages
      mysql-test/r/create.result:
        Updated results for not automatic default fields
        Better error messages
      mysql-test/r/ctype_collate.result:
        Updated results for not automatic default fields
      mysql-test/r/ctype_latin1_de.result:
        Updated results for not automatic default fields
      mysql-test/r/ctype_many.result:
        Updated results for not automatic default fields
      mysql-test/r/ctype_recoding.result:
        Updated results for not automatic default fields
      mysql-test/r/gis-rtree.result:
        Updated results for not automatic default fields
      mysql-test/r/gis.result:
        Updated results for not automatic default fields
      mysql-test/r/innodb.result:
        Updated results for not automatic default fields
      mysql-test/r/insert.result:
        Better error messages
      mysql-test/r/insert_select.result:
        Better error messages
      mysql-test/r/isam.result:
        Updated results for not automatic default fields
      mysql-test/r/key.result:
        Better error messages
      mysql-test/r/merge.result:
        Updated results for not automatic default fields
      mysql-test/r/null.result:
        Better error messages
      mysql-test/r/null_key.result:
        Better error messages
      mysql-test/r/ps_1general.result:
        Updated results for not automatic default fields
      mysql-test/r/select.result:
        Drop views that may interfere with later results
      mysql-test/r/show_check.result:
        Updated results for not automatic default fields
      mysql-test/r/sp.result:
        Updated results for not automatic default fields
      mysql-test/r/strict.result:
        More tests
      mysql-test/r/type_set.result:
        Updated results for not automatic default fields
      mysql-test/r/warnings.result:
        Better error messages
      mysql-test/t/insert.test:
        Using wrong float values now gives an error
      mysql-test/t/select.test:
        Drop views that may interfere with later results
      mysql-test/t/strict.test:
        More tests
      scripts/mysql_fix_privilege_tables.sql:
        Add missing DEFAULT's
      sql/field.cc:
        Fix some strict mode issues for float and double
      sql/field.h:
        Fix DEFAULT handling
      sql/item.cc:
        Give an error if we encounter a wrong float value during parsing.
        Give an error if we use DEFAULT() on a field that doesn't have a default value.
      sql/item.h:
        Give an error if we encounter a wrong float value during parsing.
      sql/mysqld.cc:
        More debug info
      sql/share/czech/errmsg.txt:
        Better error messages
      sql/share/danish/errmsg.txt:
        Better error messages
      sql/share/dutch/errmsg.txt:
        Better error messages
      sql/share/english/errmsg.txt:
        Better error messages
      sql/share/estonian/errmsg.txt:
        Better error messages
      sql/share/french/errmsg.txt:
        Better error messages
      sql/share/german/errmsg.txt:
        Better error messages
      sql/share/greek/errmsg.txt:
        Better error messages
      sql/share/hungarian/errmsg.txt:
        Better error messages
      sql/share/italian/errmsg.txt:
        Better error messages
      sql/share/japanese/errmsg.txt:
        Better error messages
      sql/share/korean/errmsg.txt:
        Better error messages
      sql/share/norwegian-ny/errmsg.txt:
        Better error messages
      sql/share/norwegian/errmsg.txt:
        Better error messages
      sql/share/polish/errmsg.txt:
        Better error messages
      sql/share/portuguese/errmsg.txt:
        Better error messages
      sql/share/romanian/errmsg.txt:
        Better error messages
      sql/share/russian/errmsg.txt:
        Better error messages
      sql/share/serbian/errmsg.txt:
        Better error messages
      sql/share/slovak/errmsg.txt:
        Better error messages
      sql/share/spanish/errmsg.txt:
        Better error messages
      sql/share/swedish/errmsg.txt:
        Better error messages
      sql/share/ukrainian/errmsg.txt:
        Better error messages
      sql/sql_insert.cc:
        Fixed bug in last push of checking of default values.
      sql/sql_parse.cc:
        Enum fields has always a default value
      sql/sql_show.cc:
        Don't print DEFAULT for columns without a default value in SHOW CREATE/SHOW FIELDS
      sql/sql_table.cc:
        Fixed storing/retrieving of NO_DEFAULT_VALUE_FLAG
      sql/sql_update.cc:
        Don't abort for wrong values for UPDATE IGNORE
      sql/sql_yacc.yy:
        Abort if we find a wrong float value
      sql/table.cc:
        Fixed storing/retrieving of NO_DEFAULT_VALUE_FLAG
      d4f0cdc5
  6. 01 Oct, 2004 2 commits
  7. 29 Sep, 2004 3 commits
    • unknown's avatar
      Fixed BUG#4905: Stored procedure doesn't clear for "Rows affected". · 700ed67c
      unknown authored
      
      mysql-test/r/sp.result:
        New test case for BUG#4905
      mysql-test/t/sp.test:
        New test case for BUG#4905
      sql/sql_parse.cc:
        Reset row count before CALL.
      700ed67c
    • unknown's avatar
      merge · dc85fce0
      unknown authored
      
      sql/sql_class.h:
        Auto merged
      sql/sql_lex.h:
        Auto merged
      sql/sql_update.cc:
        Auto merged
      sql/sql_view.cc:
        Auto merged
      sql/sql_yacc.yy:
        Auto merged
      sql/table.h:
        Auto merged
      dc85fce0
    • unknown's avatar
      post review changes: · a132f3db
      unknown authored
      CHECK OPTION moved to one function
      view name added to error messages
      
      
      mysql-test/r/view.result:
        error messages changed
      sql/share/czech/errmsg.txt:
        view name added
      sql/share/danish/errmsg.txt:
        view name added
      sql/share/dutch/errmsg.txt:
        view name added
      sql/share/english/errmsg.txt:
        view name added
      sql/share/estonian/errmsg.txt:
        view name added
      sql/share/french/errmsg.txt:
        view name added
      sql/share/german/errmsg.txt:
        view name added
      sql/share/greek/errmsg.txt:
        view name added
      sql/share/hungarian/errmsg.txt:
        view name added
      sql/share/italian/errmsg.txt:
        view name added
      sql/share/japanese/errmsg.txt:
        view name added
      sql/share/korean/errmsg.txt:
        view name added
      sql/share/norwegian-ny/errmsg.txt:
        view name added
      sql/share/norwegian/errmsg.txt:
        view name added
      sql/share/polish/errmsg.txt:
        view name added
      sql/share/portuguese/errmsg.txt:
        view name added
      sql/share/romanian/errmsg.txt:
        view name added
      sql/share/russian/errmsg.txt:
        view name added
      sql/share/serbian/errmsg.txt:
        view name added
      sql/share/slovak/errmsg.txt:
        view name added
      sql/share/spanish/errmsg.txt:
        view name added
      sql/share/swedish/errmsg.txt:
        view name added
      sql/share/ukrainian/errmsg.txt:
        view name added
      sql/sql_class.h:
        view reference saved
      sql/sql_insert.cc:
        CHECK OPTION moved to one function
      sql/sql_update.cc:
        CHECK OPTION moved to one function
      sql/sql_view.cc:
        view name added to error message
      sql/table.cc:
        CHECK OPTION moved to one function
      sql/table.h:
        CHECK OPTION moved to one function
      a132f3db
  8. 28 Sep, 2004 4 commits
    • unknown's avatar
      mysqldump.c: · c8612b60
      unknown authored
        Add missing semicolons.
      
      
      client/mysqldump.c:
        Add missing semicolons.
      c8612b60
    • unknown's avatar
      Merge bk-internal.mysql.com:/home/bk/mysql-5.0 · ae7e70d9
      unknown authored
      into mishka.local:/home/my/mysql-5.0
      
      
      mysql-test/r/sp.result:
        Auto merged
      sql/sql_base.cc:
        Auto merged
      sql/sql_insert.cc:
        Auto merged
      sql/sql_update.cc:
        Auto merged
      ae7e70d9
    • unknown's avatar
      Strict mode & better warnings · cf5e6660
      unknown authored
      Under strict mode MySQL will generate an error message if there was any conversion when assigning data to a field.
      Added checking of date/datetime fields.
      If strict mode, give error if we have not given value to field without a default value (for INSERT)
      
      
      client/mysqltest.c:
        Added --exit as an option to abort a test in a middle (good for debugging)
      include/my_time.h:
        Added flags to allow checking of dates in strict mode
      include/mysql_com.h:
        Added flag to check if field has a default value or not
      include/mysqld_error.h:
        New error messages for strict mode
      include/sql_state.h:
        Fixed SQL states (for strict mode tests)
      mysql-test/r/auto_increment.result:
        Updated error messages
      mysql-test/r/func_sapdb.result:
        Added test for ALLOW_INVALID_DATES
      mysql-test/r/func_str.result:
        Updated error messages
      mysql-test/r/func_time.result:
        Updated error messages
      mysql-test/r/insert.result:
        Updated error messages
      mysql-test/r/loaddata.result:
        Updated error messages
      mysql-test/r/select.result:
        Updated error messages
      mysql-test/r/sp.result:
        Updated error messages
      mysql-test/r/timezone2.result:
        Updated error messages
      mysql-test/r/type_datetime.result:
        Updated error messages
      mysql-test/r/type_decimal.result:
        Updated error messages
      mysql-test/r/type_float.result:
        Updated error messages
      mysql-test/r/type_ranges.result:
        Updated error messages
      mysql-test/r/type_time.result:
        Updated error messages
      mysql-test/r/type_uint.result:
        Updated error messages
      mysql-test/r/warnings.result:
        Updated error messages
      mysql-test/t/func_sapdb.test:
        Aded test
      sql-common/my_time.c:
        Added checking of dates
      sql/field.cc:
        Better error messages
        Optimization of warning handling (by introducing of check_int())
        Changed to use my_strtoll10()
      sql/field.h:
        Added check_int()
      sql/item_func.cc:
        Warnings when dividing by NULL
      sql/item_func.h:
        Warnings when dividing by NULL
      sql/item_timefunc.cc:
        Testing of date/datetime
        Use macros instead of constants
      sql/mysql_priv.h:
        New modes (part of strict mode)
      sql/mysqld.cc:
        New modes (part of strict mode)
      sql/opt_range.cc:
        Simple optimizations
      sql/protocol.cc:
        Add note/warning level to find_handler()
      sql/set_var.cc:
        Added mode 'traditional'
      sql/share/czech/errmsg.txt:
        New error messages for strict mode
      sql/share/danish/errmsg.txt:
        New error messages for strict mode
      sql/share/dutch/errmsg.txt:
        New error messages for strict mode
      sql/share/english/errmsg.txt:
        New error messages for strict mode
      sql/share/estonian/errmsg.txt:
        New error messages for strict mode
      sql/share/french/errmsg.txt:
        New error messages for strict mode
      sql/share/german/errmsg.txt:
        New error messages for strict mode
      sql/share/greek/errmsg.txt:
        New error messages for strict mode
      sql/share/hungarian/errmsg.txt:
        New error messages for strict mode
      sql/share/italian/errmsg.txt:
        New error messages for strict mode
      sql/share/japanese/errmsg.txt:
        New error messages for strict mode
      sql/share/korean/errmsg.txt:
        New error messages for strict mode
      sql/share/norwegian-ny/errmsg.txt:
        New error messages for strict mode
      sql/share/norwegian/errmsg.txt:
        New error messages for strict mode
      sql/share/polish/errmsg.txt:
        New error messages for strict mode
      sql/share/portuguese/errmsg.txt:
        New error messages for strict mode
      sql/share/romanian/errmsg.txt:
        New error messages for strict mode
      sql/share/russian/errmsg.txt:
        New error messages for strict mode
      sql/share/serbian/errmsg.txt:
        New error messages for strict mode
      sql/share/slovak/errmsg.txt:
        New error messages for strict mode
      sql/share/spanish/errmsg.txt:
        New error messages for strict mode
      sql/share/swedish/errmsg.txt:
        New error messages for strict mode
      sql/share/ukrainian/errmsg.txt:
        New error messages for strict mode
      sql/sp_rcontext.cc:
        Add note/warning level to find_handler()
      sql/sp_rcontext.h:
        Add note/warning level to find_handler()
      sql/sql_base.cc:
        Fix bug for detecting crashed table
      sql/sql_class.cc:
        Variables for strct mode
      sql/sql_class.h:
        Variables for strct mode
      sql/sql_error.cc:
        In strict mode, convert warnings to errors
      sql/sql_insert.cc:
        Strict mode
        If strict mode, give error if we have not given value to field without a default value
      sql/sql_load.cc:
        Strict mode
      sql/sql_parse.cc:
        Strict mode.
        Add flag to field if it doesn't have a default value
      sql/sql_select.cc:
        Added comment
        Prepare for upper level handling of table->status
      sql/sql_union.cc:
        Added THD to write_record()
      sql/sql_update.cc:
        Strict mode
      sql/table.cc:
        Handling of default values
      sql/time.cc:
        Checking of dates
      cf5e6660
    • unknown's avatar
      fix test suite for portability · 1999f6c2
      unknown authored
      1999f6c2
  9. 26 Sep, 2004 2 commits
  10. 24 Sep, 2004 4 commits
    • unknown's avatar
      Merge gbichot@bk-internal.mysql.com://home/bk/mysql-5.0 · fb8c82a9
      unknown authored
      into mysql.com:/home/mysql_src/mysql-5.0
      
      fb8c82a9
    • unknown's avatar
      In binary log events, flags are 2 bytes, not 4. Using 4 resulted in buffer... · c2bc847c
      unknown authored
      In binary log events, flags are 2 bytes, not 4. Using 4 resulted in buffer overflow (and on a certain build it resulted in overwriting another part of the event without crashing :( ).
      
      
      sql/log_event.cc:
        flags are 2 bytes, not 4. Using 4 resulted in buffer overflow (and on a certain build it resulted in overwriting another part of the event without crashing :( ).
      c2bc847c
    • unknown's avatar
      For now we will require super privilege for creating/dropping trigger because proper · ea82ef87
      unknown authored
      privilege checking is not in place yet.
      
      ea82ef87
    • unknown's avatar
      new show create view output · 49a282af
      unknown authored
      mysqldump view support (BUG#4972)
      workaround to allow view work after LOCK TABLES
      
      
      client/mysqldump.c:
        view support
      mysql-test/r/lowercase_view.result:
        new show create view output
      mysql-test/r/view.result:
        new show create view output
        test of locked views
      mysql-test/t/view.test:
        new show create view output
        test of locked views
      sql/sql_base.cc:
        workaround to allow view work after LOCK TABLES
      sql/sql_show.cc:
        new show create view output (to help mysql dump detect views)
      49a282af
  11. 18 Sep, 2004 1 commit
  12. 17 Sep, 2004 8 commits