1. 19 Oct, 2004 3 commits
    • unknown's avatar
      Merge for post-merge fixes for Item_equal patch. · a9da1869
      unknown authored
      
      BitKeeper/etc/ignore:
        auto-union
      mysql-test/r/range.result:
        Auto merged
      mysql-test/r/select.result:
        Auto merged
      mysql-test/t/range.test:
        Auto merged
      sql/item.cc:
        Auto merged
      sql/opt_range.cc:
        Auto merged
      sql/opt_sum.cc:
        Auto merged
      sql/sql_select.h:
        Auto merged
      sql/item.h:
        Manual merge
      sql/sql_select.cc:
        Manual merge
      a9da1869
    • unknown's avatar
      table.h, sql_select.h: · fcab6583
      unknown authored
        Added the code processing on expressions for applying
        multiple equalities.
      sql_select.cc:
        Post-merge fixes for Item_equal patch.
        Added the code processing on expressions for applying
        multiple equalities.
      Many files:
        Post-merge fixes for Item_equal patch.
      item_cmpfunc.cc:
        Post-merge fixes for Item_equal patch.
        Fixed a problem when an equality field=const cannot be applied to
        the predicate P(field,c) for constant propagation as a conversion
        of field is needed.
      item.h, item.cc:
        Fixed a problem when an equality field=const cannot be applied to
        the predicate P(field,c) for constant propagation as a conversion
        of field is needed.
      
      
      mysql-test/r/func_test.result:
        Post-merge fixes for Item_equal patch.
      mysql-test/r/index_merge.result:
        Post-merge fixes for Item_equal patch.
      mysql-test/r/join_nested.result:
        Post-merge fixes for Item_equal patch.
      mysql-test/r/range.result:
        Post-merge fixes for Item_equal patch.
      sql/item.cc:
        Fixed a problem when an equality field=const cannot be applied to
        the predicate P(field,c) for constant propagation as a conversion
        of field is needed.
      sql/item.h:
        Fixed a problem when an equality field=const cannot be applied to
        the predicate P(field,c) for constant propagation as a conversion
        of field is needed.
      sql/item_cmpfunc.cc:
        Post-merge fixes for Item_equal patch.
        Fixed a problem when an equality field=const cannot be applied to
        the predicate P(field,c) for constant propagation as a conversion
        of field is needed.
      sql/opt_range.cc:
        Post-merge fixes for Item_equal patch.
      sql/sql_select.cc:
        Post-merge fixes for Item_equal patch.
        Added the code processing on expressions for applying
        multiple equalities.
      sql/sql_select.h:
        Added the code processing on expressions for applying
        multiple equalities.
      sql/table.h:
        Added the code processing on expressions for applying
        multiple equalities.
      fcab6583
    • unknown's avatar
      decimal to/from bin, and utility functions · b86a19bc
      unknown authored
      
      strings/Makefile.am:
        cleanup
      b86a19bc
  2. 18 Oct, 2004 3 commits
    • unknown's avatar
      compatibility fix · c5ded716
      unknown authored
      test results corrected
      
      
      mysql-test/r/range.result:
        test results corrected
      mysql-test/t/range.test:
        test results corrected
      sql/opt_range.cc:
        compatibility fix
      c5ded716
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.0/ · d953b148
      unknown authored
      into serg.mylan:/usr/home/serg/Abk/mysql-5.0
      
      
      BitKeeper/etc/ignore:
        auto-union
      d953b148
    • unknown's avatar
      arbitrary precision decimal numbers · d36af6f0
      unknown authored
      
      strings/llstr.c:
        small optimization
      BitKeeper/etc/ignore:
        Added strings/test_decimal to the ignore list
      d36af6f0
  3. 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
  4. 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
  5. 13 Oct, 2004 1 commit
  6. 12 Oct, 2004 5 commits
  7. 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
  8. 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
  9. 09 Oct, 2004 3 commits
    • unknown's avatar
      Merge for Item_equal. · 3c6f7f63
      unknown authored
      
      BitKeeper/etc/ignore:
        auto-union
      mysql-test/r/bdb.result:
        Auto merged
      mysql-test/r/func_group.result:
        Auto merged
      mysql-test/r/innodb.result:
        Auto merged
      mysql-test/r/heap_btree.result:
        Auto merged
      mysql-test/r/select.result:
        Auto merged
      mysql-test/r/user_var.result:
        Auto merged
      mysql-test/t/range.test:
        Auto merged
      sql/item_func.cc:
        Auto merged
      sql/item_func.h:
        Auto merged
      sql/item_row.cc:
        Auto merged
      sql/item_strfunc.h:
        Auto merged
      sql/opt_sum.cc:
        Auto merged
      sql/sql_list.h:
        Auto merged
      mysql-test/r/func_test.result:
        Post-automerge resolution of conflicts
      mysql-test/r/index_merge.result:
        Post-automerge resolution of conflicts
      mysql-test/r/join_outer.result:
        Post-automerge resolution of conflicts
      mysql-test/r/range.result:
        Post-automerge resolution of conflicts
      mysql-test/r/subselect.result:
        Post-automerge resolution of conflicts
      sql/item.cc:
        Post-automerge resolution of conflicts
      sql/item.h:
        Post-automerge resolution of conflicts
      sql/item_cmpfunc.cc:
        Post-automerge resolution of conflicts
      sql/item_cmpfunc.h:
        Post-automerge resolution of conflicts
      sql/opt_range.cc:
        Post-automerge resolution of conflicts
      sql/sql_select.cc:
        Post-automerge resolution of conflicts
      sql/sql_select.h:
        Post-automerge resolution of conflicts
      3c6f7f63
    • unknown's avatar
      Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-5.0 · 8ccc49df
      unknown authored
      into sanja.is.com.ua:/home/bell/mysql/bk/work-error-5.0
      
      8ccc49df
    • unknown's avatar
      fixed incorrect type custing (fixed problem with runing tests with --debug... · 18215127
      unknown authored
      fixed incorrect type custing (fixed problem with runing tests with --debug (thanks, Sergei Gluhov spoted it))
      
      
      mysql-test/r/view.result:
        PS with multiupdate and view with collate
      mysql-test/t/view.test:
        PS with multiupdate and view with collate
      sql/sql_update.cc:
        fixed incorrect type custing
      18215127
  10. 08 Oct, 2004 3 commits
  11. 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
  12. 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
  13. 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