1. 25 Oct, 2004 1 commit
  2. 24 Oct, 2004 1 commit
  3. 23 Oct, 2004 2 commits
    • unknown's avatar
      Fixed BUG#6029: Stored procedure specific handlers should have priority. · 4c06b4ae
      unknown authored
      
      mysql-test/r/sp.result:
        New test case for BUG#6022.
      mysql-test/t/sp.test:
        New test case for BUG#6022.
      sql/sp_rcontext.cc:
        Find the most specific condition handler, not just the first one.
        (And corrected the return type for find_handler)
      sql/sp_rcontext.h:
        Corrected return type for find_handler.
      4c06b4ae
    • unknown's avatar
      Fixed BUG#6022: Stored procedure shutdown problem with self-calling function. · d925bcd8
      unknown authored
        Fixed the pre-caching of functions. It now gives the expected stack overrun
        error for functions recursing too deep.
      
      
      mysql-test/r/sp.result:
        New test case for BUG#6022.
      mysql-test/t/sp.test:
        New test case for BUG#6022.
      sql/sp.cc:
        Cache function first, then recurse, or the pre-caching loops infinitely
        for recursive functions.
      d925bcd8
  4. 22 Oct, 2004 8 commits
    • unknown's avatar
      Updated view test result (after a warning's been removed). · d73b379c
      unknown authored
      
      mysql-test/r/view.result:
        Updated test result (after a warning's been removed).
      d73b379c
    • unknown's avatar
      Fixed BUG#6030: Stored procedure has no appropriate DROP privilege. · a50cd5c5
      unknown authored
        ...and no ALTER privilege either.
        For now, only the definer and root can drop or alter an SP.
      
      
      include/mysqld_error.h:
        New access denied error code when dropping/altering stored procedures.
      include/sql_state.h:
        New access denied error code when dropping/altering stored procedures.
      mysql-test/r/sp-error.result:
        Removed warning for "unitialized variable", as this popped up in unexpected
        places after the access control for drop/alter SPs was added. (And the warning
        was wrong and planned to be removed anyway.)
      mysql-test/r/sp-security.result:
        Added tests for access control on who's allowed to drop and alter SPs.
      mysql-test/r/sp.result:
        Updated results. (Warning removed.)
      mysql-test/t/sp-error.test:
        Removed warning for "unitialized variable", as this popped up in unexpected
        places after the access control for drop/alter SPs was added. (And the warning
        was wrong and planned to be removed anyway.)
      mysql-test/t/sp-security.test:
        Added tests for access control on who's allowed to drop and alter SPs.
      sql/share/czech/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/danish/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/dutch/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/english/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/estonian/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/french/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/german/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/greek/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/hungarian/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/italian/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/japanese/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/korean/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/norwegian-ny/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/norwegian/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/polish/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/portuguese/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/romanian/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/russian/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/serbian/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/slovak/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/spanish/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/swedish/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/share/ukrainian/errmsg.txt:
        New access denied error message when dropping/altering stored procedures.
      sql/sql_parse.cc:
        Added minimal access control for DROP/ALTER PROCEDURE/FUNCTION. Only the definer
        and root are allowed to do this.
      sql/sql_yacc.yy:
        Removed warning for "unitialized variable", as this popped up in unexpected
        places after the access control for drop/alter SPs was added. (And the warning
        was wrong and planned to be removed anyway.)
      a50cd5c5
    • unknown's avatar
      Fixed BUG#6027: Stored procedures can be renamed. · 35588c9d
      unknown authored
      Removed the support for renaming SPs. It's non-standard, conflicted with a standard
      syntax, and was a bit broken anyway.
      
      
      mysql-test/r/sp-error.result:
        Removed test for renaming procedures with alter.
      mysql-test/r/sp.result:
        Removed test for renaming procedures with alter.
      mysql-test/t/sp-error.test:
        Removed test for renaming procedures with alter.
      mysql-test/t/sp.test:
        Removed test for renaming procedures with alter.
      sql/sp.cc:
        Removed support for renaming SPs. It's non-standard, conflicted with a standard
        syntax, and was a bit broken anyway.
      sql/sp.h:
        Removed support for renaming SPs. It's non-standard, conflicted with a standard
        syntax, and was a bit broken anyway.
      sql/sql_parse.cc:
        Removed support for renaming SPs. It's non-standard, conflicted with a standard
        syntax, and was a bit broken anyway.
      sql/sql_yacc.yy:
        Removed support for renaming SPs. It's non-standard, conflicted with a standard
        syntax, and was a bit broken anyway.
      35588c9d
    • unknown's avatar
      handler.cc: · b24dd933
      unknown authored
        Typos in comments.
      
      
      sql/handler.cc:
        Typos in comments.
      b24dd933
    • unknown's avatar
      fixed db/user privileges getting (BUG#5976) · fadcd8d3
      unknown authored
      
      mysql-test/r/view.result:
        user with global DB privileges test
      mysql-test/t/view.test:
        user with global DB privileges test
      sql/sql_acl.cc:
        fixed db/user privileges getting
      fadcd8d3
    • unknown's avatar
      Merge rkalimullin@bk-internal.mysql.com:/home/bk/mysql-5.0 · 746e6e53
      unknown authored
      into gw.mysql.r18.ru:/usr/home/ram/work/5.0
      
      
      746e6e53
    • unknown's avatar
      A fix (bug #5999 Typo in code, wrong config variable naming). · e5c610d6
      unknown authored
      
      mysql-test/r/rpl_auto_increment.result:
        A fix (bug #5999 Typo in code, wrong config variable naming).
        Typo fixed.
      sql/set_var.cc:
        A fix (bug #5999 Typo in code, wrong config variable naming).
        Typo fixed.
      e5c610d6
    • unknown's avatar
      Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-5.0 · 58aa05e2
      unknown authored
      into sanja.is.com.ua:/home/bell/mysql/bk/work-view-5.0
      
      
      sql/item_strfunc.h:
        Auto merged
      sql/table.h:
        Auto merged
      58aa05e2
  5. 21 Oct, 2004 10 commits
    • unknown's avatar
      Merge rurik.mysql.com:/home/igor/mysql-5.0 · 485141ce
      unknown authored
      into rurik.mysql.com:/home/igor/dev/mysql-5.0-0
      
      
      485141ce
    • unknown's avatar
      ps.result: · a3212379
      unknown authored
        Post-merge fixes.
      sql_select.cc:
        Post-merge cleanup.
      
      
      sql/sql_select.cc:
        Post-merge cleanup.
      mysql-test/r/ps.result:
        Post-merge fixes.
      a3212379
    • unknown's avatar
      added support of view and CHECK OPTION of view to LOAD DATA (BUG#5996) · 4d204f43
      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
      4d204f43
    • unknown's avatar
      new behaviour of CHECK option build, for mor efficience and more correct: · 149fda59
      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.
      149fda59
    • unknown's avatar
      ha_innodb.cc: · d604eb99
      unknown authored
        Remove compiler warning 'skip_auto_inc_decr' : unreferenced local variable in Visual C++; of course, I still have to check Monty's auto-inc patch in whole
      
      
      sql/ha_innodb.cc:
        Remove compiler warning 'skip_auto_inc_decr' : unreferenced local variable in Visual C++; of course, I still have to check Monty's auto-inc patch in whole
      d604eb99
    • unknown's avatar
      value should be checked after 'before' trigger work (BUG#5992) · 0ea04229
      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
      0ea04229
    • unknown's avatar
      inserting single value with check option failed always get error (part of BUG#5995) · 2aad3039
      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
      2aad3039
    • unknown's avatar
      fixed default behaviour of WITH CHECK OPTIONS according to standard (BUG#5989) · e9c3bc76
      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
      e9c3bc76
    • unknown's avatar
      Allow inheriting check options if view have not WHERE clause (BUG#5988) · adc1bff4
      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
      adc1bff4
    • unknown's avatar
      fixed printing of substring_index (BUG#5911) · 0b01d95d
      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
      0b01d95d
  6. 20 Oct, 2004 9 commits
  7. 19 Oct, 2004 3 commits
    • unknown's avatar
      Merge for post-merge fixes for Item_equal patch. · a3e71bdb
      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
      a3e71bdb
    • unknown's avatar
      table.h, sql_select.h: · 05933f13
      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.
      05933f13
    • unknown's avatar
      decimal to/from bin, and utility functions · 24b608b2
      unknown authored
      
      strings/Makefile.am:
        cleanup
      24b608b2
  8. 18 Oct, 2004 3 commits
    • unknown's avatar
      compatibility fix · bd5bafe1
      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
      bd5bafe1
    • unknown's avatar
      Merge bk-internal:/home/bk/mysql-5.0/ · a6f61359
      unknown authored
      into serg.mylan:/usr/home/serg/Abk/mysql-5.0
      
      
      BitKeeper/etc/ignore:
        auto-union
      a6f61359
    • unknown's avatar
      arbitrary precision decimal numbers · decc71e6
      unknown authored
      
      strings/llstr.c:
        small optimization
      BitKeeper/etc/ignore:
        Added strings/test_decimal to the ignore list
      decc71e6
  9. 16 Oct, 2004 1 commit
    • unknown's avatar
      texi2html: · cb8f0d59
      unknown authored
        Change parsing of @image argument.
      
      
      Docs/Support/texi2html:
        Change parsing of @image argument.
      cb8f0d59
  10. 14 Oct, 2004 1 commit
    • unknown's avatar
      Implemented the stored procedure data access characteristics: · a750003f
      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.)
      a750003f
  11. 13 Oct, 2004 1 commit