1. 16 Oct, 2004 1 commit
    • unknown's avatar
      texi2html: · 0a69b06e
      unknown authored
        Change parsing of @image argument.
      
      
      Docs/Support/texi2html:
        Change parsing of @image argument.
      0a69b06e
  2. 14 Oct, 2004 1 commit
    • unknown's avatar
      Implemented the stored procedure data access characteristics: · f7635ca5
      unknown authored
      NO SQL
      CONTAINS SQL (default)
      READS SQL DATA
      MODIFIES SQL DATA
      
      These are needed as hints for the replication.
      (Before this, we did have the default in the mysql.proc table, but no support in the parser.)
      
      
      mysql-test/r/sp.result:
        Modified test cases for new data access characteristics.
      mysql-test/t/sp.test:
        Modified test cases for new data access characteristics.
      scripts/mysql_create_system_tables.sh:
        We now support all the SP data access characteristics (not just CONTAINS SQL).
      scripts/mysql_fix_privilege_tables.sql:
        We now support all the SP data access characteristics (not just CONTAINS SQL).
      sql/lex.h:
        New tokens for SP data access characteristics.
      sql/sp.cc:
        Store, print and support alter of data access characteristics.
      sql/sp_head.cc:
        Added SP_ prefix to some symbols.
      sql/sql_lex.h:
        Added SP_ prefix to some symbols, and added SP data access enum.
      sql/sql_yacc.yy:
        Parse SP data access characteristics.
        (And allow "alter ... language sql", mostly as a formality, it was accidently
         put in the wrong clause before.)
      f7635ca5
  3. 13 Oct, 2004 1 commit
  4. 12 Oct, 2004 5 commits
  5. 11 Oct, 2004 5 commits
    • unknown's avatar
      column name changd · 7f6f4927
      unknown authored
      7f6f4927
    • unknown's avatar
      After merge adjustment of tests due to changes in cost estimates. · e49c0669
      unknown authored
      
      BitKeeper/etc/ignore:
        Added server-tools/instance-manager/mysqlmanager to the ignore list
      e49c0669
    • unknown's avatar
      Merge with implementation of WL#1724. · 16c3b9ae
      unknown authored
      
      sql/ha_myisam.cc:
        Auto merged
      sql/handler.cc:
        Auto merged
      sql/item.cc:
        Auto merged
      sql/item.h:
        Auto merged
      sql/item_sum.cc:
        Auto merged
      sql/item_sum.h:
        Auto merged
      sql/key.cc:
        Auto merged
      sql/mysql_priv.h:
        Auto merged
      sql/opt_sum.cc:
        Auto merged
      sql/sql_acl.cc:
        Auto merged
      sql/sql_handler.cc:
        Auto merged
      sql/sql_insert.cc:
        Auto merged
      sql/sql_select.h:
        Auto merged
      sql/opt_range.cc:
        Manual merge
      sql/sql_select.cc:
        Manual merge
      16c3b9ae
    • unknown's avatar
      Manual merge with implementation for WL#1724 · e8b74f68
      unknown authored
      e8b74f68
    • unknown's avatar
      Fixes for WL#1724 required by the third code review. · 22ecf1d7
      unknown authored
      
      sql/item.cc:
        Document actual behavior.
      sql/opt_range.cc:
        - Added a test for range predicates comparing incomparable argumens
        - Removed TRP_GROUP_MIN_MAX class members that are not used.
        - Uncommented CPU cost
        - More standard function return values
      sql/sql_select.cc:
        Remove unnecessary test.
      22ecf1d7
  6. 10 Oct, 2004 3 commits
    • unknown's avatar
      fix privileges for old style privileges tables on fly (as it do... · b2229863
      unknown authored
      fix privileges for old style privileges tables on fly (as it do mysql_fix_privilege_tables dut if we have not it run)
      fixed forgoten test
      
      
      mysql-test/r/ps_1general.result:
        SHOW TABLE putput changed
      sql/sql_acl.cc:
        fix privileges for old style privileges tables on fly (as it do mysql_fix_privilege_tables dut if we have not it run)
      b2229863
    • unknown's avatar
      showing table type now is controled by new parameter 'FULL' of SHOW TABLES... · 819a23d4
      unknown authored
      showing table type now is controled by new parameter 'FULL' of SHOW TABLES command (SHOW FULL TABLES) (as it was decided on last dev conf)
      
      
      mysql-test/r/connect.result:
        returned SHOW TABLES default behaviour
      mysql-test/r/ctype_recoding.result:
        returned SHOW TABLES default behaviour
      mysql-test/r/drop.result:
        returned SHOW TABLES default behaviour
      mysql-test/r/lowercase_table.result:
        returned SHOW TABLES default behaviour
      mysql-test/r/rename.result:
        returned SHOW TABLES default behaviour
      mysql-test/r/rpl000009.result:
        returned SHOW TABLES default behaviour
      mysql-test/r/rpl_error_ignored_table.result:
        returned SHOW TABLES default behaviour
      mysql-test/r/select.result:
        returned SHOW TABLES default behaviour
      mysql-test/r/sp.result:
        returned SHOW TABLES default behaviour
      mysql-test/r/system_mysql_db.result:
        returned SHOW TABLES default behaviour
      mysql-test/r/view.result:
        test of new parameter od SHOW TABLES and default behaviour without parameter
      mysql-test/t/view.test:
        test of new parameter od SHOW TABLES and default behaviour without parameter
      sql/mysql_priv.h:
        parameter added to mysqld_show_tables
      sql/sql_parse.cc:
        parameter added to mysqld_show_tables
      sql/sql_show.cc:
        showing table type now is controled by new parameter 'FULL' of SHOW TABLES command (SHOW FULL TABLES)
      sql/sql_yacc.yy:
        showing table type now is controled by new parameter 'FULL' of SHOW TABLES command (SHOW FULL TABLES)
      819a23d4
    • unknown's avatar
      prevent substituting Item_ref as VIEW fields in WHERE conditions (BUG#5969) · 7327133d
      unknown authored
      prevent filling temporary tables of views on list fields command
      
      
      sql/opt_range.cc:
        debug output fixed
      sql/sql_base.cc:
        prevent substituting Item_ref as VIEW fields in WHERE conditions
      sql/sql_parse.cc:
        prevent filling temporary tables of views on list fields command
      7327133d
  7. 09 Oct, 2004 2 commits
  8. 08 Oct, 2004 3 commits
  9. 07 Oct, 2004 9 commits
    • unknown's avatar
      Portability fix (Got different results for double -> longlong when compiling... · 8af6d0e7
      unknown authored
      Portability fix (Got different results for double -> longlong when compiling with full optimization)
      
      
      8af6d0e7
    • unknown's avatar
      changes in SHOW CREATE VIEW output · 48cd7d38
      unknown authored
      48cd7d38
    • 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 01 Oct, 2004 1 commit