1. 21 Oct, 2004 7 commits
    • unknown's avatar
      added support of view and CHECK OPTION of view to LOAD DATA (BUG#5996) · d83b8d32
      unknown authored
      
      mysql-test/r/view.result:
        LOAD DATA with view and CHECK OPTION
      mysql-test/t/view.test:
        LOAD DATA with view and CHECK OPTION
      sql/log_event.cc:
        new parameter for load data
      sql/mysql_priv.h:
        new parameter for load data
      sql/sql_lex.cc:
        LOAD DATA supported by view
      sql/sql_load.cc:
        added support of view and CHECK OPTION of view to LOAD DATA
      sql/sql_parse.cc:
        new parameter for CHECK OPTION
      d83b8d32
    • unknown's avatar
      new behaviour of CHECK option build, for mor efficience and more correct: · 11d8bf16
      unknown authored
      check option build only according most top VIEW  CHECK OPTION TYPE  (BUG#5993)
      
      
      mysql-test/r/view.result:
        CASCADED should be used for all underlaying VIEWs
      mysql-test/t/view.test:
        CASCADED should be used for all underlaying VIEWs
      sql/sql_base.cc:
        new behaviour of CHECK option build, for mor efficience and more correct.
      sql/table.cc:
        new behaviour of CHECK option build, for mor efficience and more correct.
      sql/table.h:
        new behaviour of CHECK option build, for mor efficience and more correct.
      11d8bf16
    • unknown's avatar
      value should be checked after 'before' trigger work (BUG#5992) · 3653ecb0
      unknown authored
      
      mysql-test/r/view.result:
        changing value by trigger and CHECK OPTION
      mysql-test/t/view.test:
        changing value by trigger and CHECK OPTION
      sql/sql_insert.cc:
        value should be checked after 'before' trigger work
      3653ecb0
    • unknown's avatar
      inserting single value with check option failed always get error (part of BUG#5995) · 19671bd9
      unknown authored
      
      mysql-test/r/view.result:
        inserting single value with check option failed always get error
      mysql-test/t/view.test:
        inserting single value with check option failed always get error
      sql/sql_insert.cc:
        inserting single value with check option failed always get error
      19671bd9
    • unknown's avatar
      fixed default behaviour of WITH CHECK OPTIONS according to standard (BUG#5989) · 5f1c9cca
      unknown authored
      
      mysql-test/r/view.result:
        fixed default behaviour of WITH CHECK OPTIONS according to standard
      sql/sql_yacc.yy:
        fixed default behaviour of WITH CHECK OPTIONS according to standard
      5f1c9cca
    • unknown's avatar
      Allow inheriting check options if view have not WHERE clause (BUG#5988) · 2c8aa3bb
      unknown authored
      
      mysql-test/r/view.result:
        test of cascaded check option for whiew without WHERE clause
      mysql-test/t/view.test:
        test of cascaded check option for whiew without WHERE clause
      sql/table.cc:
        Allow inheriting check options if view have not WHERE clause
      2c8aa3bb
    • unknown's avatar
      fixed printing of substring_index (BUG#5911) · 55f12a29
      unknown authored
      
      mysql-test/r/func_str.result:
        fixed printing of substring_index
      mysql-test/r/view.result:
        test of substring_index with view
      mysql-test/t/view.test:
        test of substring_index with view
      sql/item_strfunc.h:
        fixed printing of substring_index
      55f12a29
  2. 20 Oct, 2004 6 commits
  3. 19 Oct, 2004 1 commit
  4. 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
  5. 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
  6. 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
  7. 13 Oct, 2004 1 commit
  8. 12 Oct, 2004 5 commits
  9. 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
  10. 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
  11. 09 Oct, 2004 2 commits
  12. 08 Oct, 2004 3 commits
  13. 07 Oct, 2004 2 commits