An error occurred fetching the project authors.
  1. 10 Jan, 2006 1 commit
    • unknown's avatar
      WL #1034 (Internal CRON) pre-push updates · 1ef97f1f
      unknown authored
      - fixed test results
      - fixed bug caught by information_schema.test . Bison temporal
        variables are very nice but extremely error-prone (Count one more
        time just to be sure).
      
      
      mysql-test/r/connect.result:
        fix result for WL#1034 (internal CRON)
      mysql-test/r/events.result:
        fix result for WL#1034 (internal CRON)
      mysql-test/r/grant.result:
        fix result for WL#1034 (internal CRON)
      mysql-test/r/information_schema.result:
        fix result for WL#1034 (internal CRON)
      mysql-test/r/lowercase_table_grant.result:
        fix result for WL#1034 (internal CRON)
      mysql-test/r/ps.result:
        fix result for WL#1034 (internal CRON)
      mysql-test/r/system_mysql_db.result:
        fix result for WL#1034 (internal CRON)
      mysql-test/t/events.test:
        fix result for WL#1034 (internal CRON)
      sql/sql_yacc.yy:
        - fix bug introduced by me when making usage of temporal
          bison variables. COUNT 7 times then write!
      1ef97f1f
  2. 28 Nov, 2005 1 commit
    • unknown's avatar
      grant.result: · 12de238b
      unknown authored
        After merge fix.
      
      
      mysql-test/r/grant.result:
        After merge fix.
      12de238b
  3. 24 Nov, 2005 1 commit
    • unknown's avatar
      Don't use PATH_MAX for FN_REFLEN as this uses too much stack space · 97bfd41f
      unknown authored
      Larger stack size neaded for open table on x86 64 bit
      Fix failing test cases
      Deleted symlink from bk
      
      
      BitKeeper/etc/ignore:
        added libmysqld/ha_blackhole.cc
      BitKeeper/deleted/.del-ha_blackhole.cc~727c69ef7846623a:
        Delete: libmysqld/ha_blackhole.cc
      include/my_global.h:
        Don't use PATH_MAX for FN_REFLEN as this uses too much stack space.
        (With a PATH_MAX of 4096, we use 80K for opening a table as there is several objects of size FN_REFLEN on stack)
      mysql-test/r/federated.result:
        Update results after error message changes
      mysql-test/r/grant.result:
        Update results after error message changes
      mysql-test/r/grant2.result:
        Update results after error message changes
      sql/ha_federated.cc:
        Fix error messages to be more consistent
      sql/mysql_priv.h:
        Stack size to have when opening a table
        (This was needed on x86 64 bit Linux)
      sql/share/errmsg.txt:
        Remove quotes around error string for federated as two quotes in the output looks strange
      sql/sql_base.cc:
        More correct stack size
      sql/sql_parse.cc:
        Set thread_stack before store_globals()
      sql/unireg.h:
        More correct MAX_DBKEY_LENGTH
      97bfd41f
  4. 14 Nov, 2005 1 commit
    • unknown's avatar
      Bug#14406 GRANTS ON objects with non-ascii names borked after FLUSH PRIVILEGES · a2e5a9f9
      unknown authored
      ps_grant.result:
        Fixing result order.
      grant.result:
        Adding test case,
        fixing result order.
      grant.test:
        Adding test case.
      sql_acl.cc:
        Fixed that my_charset_latin1 was incorrectly used instead of system_charset_info.
        This problem was previously fixed by Ingo in 5.0.
        This patch is basically a backport of the same changes into 4.1.
      
      
      sql/sql_acl.cc:
        Bug#14406 GRANTS ON objects with non-ascii names borked after FLUSH PRIVILEGES
        Fixed that my_charset_latin1 was incorrectly used instead of system_charset_info.
        This problem was previously fixed by Ingo in 5.0.
        This patch is basically a backport of the same changes into 4.1.
      mysql-test/t/grant.test:
        Adding test case.
      mysql-test/r/grant.result:
        Adding test case,
        fixing result order.
      mysql-test/r/ps_grant.result:
        Fixing result order.
      a2e5a9f9
  5. 08 Aug, 2005 1 commit
    • unknown's avatar
      grant.result: · f4e06591
      unknown authored
        After merge fix
      
      
      mysql-test/r/grant.result:
        After merge fix
        ,
      f4e06591
  6. 04 Aug, 2005 1 commit
    • unknown's avatar
      grant.result, grant.test: · 9e3562d7
      unknown authored
        fixing tests accordingly
      item.cc:
        Bug #10892 user variables not auto cast for comparisons
        When mixing strings with different character sets,
        and coercibility is the same, we allow conversion
        if one character set is superset for other character set.
      
      
      sql/item.cc:
        Bug #10892 user variables not auto cast for comparisons
        When mixing strings with different character sets,
        and coercibility is the same, we allow conversion
        if one character set is superset for other character set.
      mysql-test/t/grant.test:
        fixing tests accordingly
      mysql-test/r/grant.result:
        fixing tests accordingly
      9e3562d7
  7. 05 Jul, 2005 2 commits
    • unknown's avatar
      Fix test cases · 8218398c
      unknown authored
      mysql-test/r/query_cache.result:
        Remove stray empty line
      mysql-test/r/grant.result:
        Update results
      mysql-test/t/grant.test:
        Fix test case to
      8218398c
    • unknown's avatar
      added processing of view grants to table grants (BUG#9795) · 200f03fd
      unknown authored
      mysql-test/r/grant.result:
        test of new table privileges
      mysql-test/r/system_mysql_db.result:
        added new table priveleges
      mysql-test/r/view_grant.result:
        error changed
      mysql-test/t/grant.test:
        test of new table privileges
      mysql-test/t/view_grant.test:
        error changed
      scripts/mysql_create_system_tables.sh:
        add new table privileges
      scripts/mysql_fix_privilege_tables.sql:
        fixed system tables fix script
      sql/sql_acl.h:
        fixed coding/decoding new tables grants
      200f03fd
  8. 20 Jun, 2005 1 commit
  9. 22 Mar, 2005 1 commit
    • unknown's avatar
      sql_acl.cc, sql_acl.h, sql_parse.cc · 30a23278
      unknown authored
        New privilege CREATE USER (CREATE_USER_ACL, Create_user_priv) added
      grant2.test:
        new tests (mostly backported from jani's patch)
      system_mysql_db.result, sp.result, grant2.result, grant.result:
        results updated
      
      
      mysql-test/r/grant.result:
        results updated
      mysql-test/r/grant2.result:
        results updated
      mysql-test/r/sp.result:
        results updated
      mysql-test/r/system_mysql_db.result:
        results updated
      mysql-test/t/grant2.test:
        new tests (mostly backported from jani's patch)
      scripts/mysql_create_system_tables.sh:
        Create_user_priv added
      scripts/mysql_fix_privilege_tables.sql:
        Create_user_priv added
      sql/sql_acl.cc:
        Create_user_priv added
      sql/sql_acl.h:
        Create_user_priv added
      sql/sql_parse.cc:
        Create_user_priv added
      sql/sql_show.cc:
        Create_user_priv added
      sql/sql_yacc.yy:
        Create_user_priv added
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      30a23278
  10. 10 Feb, 2005 1 commit
    • unknown's avatar
      Re-enable alter_table test for embedded server by moving grant-related test · 4f7a0857
      unknown authored
      to grant.test and using replace_column to neuter the Privileges column in
      SHOW FULL COLUMNS.
      
      
      BitKeeper/deleted/.del-alter_table.result.es~a1077916d429e443:
        Delete: mysql-test/r/alter_table.result.es
      mysql-test/t/alter_table.test:
        Add replace_column for grant-related column
        Move grant-related test to grant.test
      mysql-test/r/alter_table.result:
        Update results
      mysql-test/t/grant.test:
        Move grant-related test from alter_table.test
      mysql-test/r/grant.result:
        Add test results
      mysql-test/mysql-test-run.sh:
        Don't skip alter_table test for embedded server
      4f7a0857
  11. 15 Jan, 2005 1 commit
    • unknown's avatar
      Enable warnings for 'no default' fields being set to default when they · 2f19824d
      unknown authored
      are not specified in an insert. Most of these changes are actually to
      clean up the test suite to either specify defaults to avoid warnings,
      or add the warnings to the results. Related to bug #5986.
      
      
      mysql-test/t/index_merge_ror.test:
        Set default on columns to avoid warnings
      mysql-test/t/ctype_many.test:
        Add defaults to avoid warnings
      mysql-test/t/ctype_latin1_de.test:
        Add defaults to avoid warnings
      mysql-test/t/gis-rtree.test:
        Remove field that isn't used in test
      mysql-test/t/limit.test:
        set default values
      mysql-test/t/null.test:
        Specify default values
      mysql-test/t/order_by.test:
        add default value
      mysql-test/t/show_check.test:
        Add defaults
      mysql-test/t/sp.test:
        Add default value
      mysql-test/t/type_blob.test:
        Set default value
      mysql-test/t/type_ranges.test:
        Set default values
      mysql-test/r/create.result:
        Update results
      mysql-test/r/ctype_latin1_de.result:
        Update results
      mysql-test/r/ctype_many.result:
        Update results
      mysql-test/r/gis-rtree.result:
        Update results
      mysql-test/r/grant.result:
        Update results
      mysql-test/r/grant2.result:
        Update results
      mysql-test/r/help.result:
        Update results
      mysql-test/r/limit.result:
        Update results
      mysql-test/r/null.result:
        Update results
      mysql-test/r/order_by.result:
        Update results
      mysql-test/r/rpl000001.result:
        Update results
      mysql-test/r/sp.result:
        Update results
      mysql-test/r/strict.result:
        Update results
      mysql-test/r/type_blob.result:
        Update results
      mysql-test/r/type_ranges.result:
        Update results
      mysql-test/r/warnings.result:
        Update results
      sql/sql_insert.cc:
        Change check_that_all_fields_are_given_values() to issue warnings for all
        fields, and not only run when thd->abort_on_warning is set and error on
        just the first field.
      2f19824d
  12. 31 Dec, 2004 2 commits
    • unknown's avatar
      post-merge · 31c4511d
      unknown authored
      31c4511d
    • unknown's avatar
      After merge fixes · 45199f54
      unknown authored
      Cleanup of mi_print_error() handling
      Deleted 'merge' directory
      
      
      BitKeeper/deleted/.del-mrg_close.c~1fa9230422daa62a:
        Delete: merge/mrg_close.c
      BitKeeper/deleted/.del-mrg_create.c~b747c8ec2b801f6:
        Delete: merge/mrg_create.c
      BitKeeper/deleted/.del-mrg_delete.c~38b4156885bb4537:
        Delete: merge/mrg_delete.c
      BitKeeper/deleted/.del-mrg_extra.c~7eb6181e1761907e:
        Delete: merge/mrg_extra.c
      BitKeeper/deleted/.del-mrg_info.c~37728e7238cc5a11:
        Delete: merge/mrg_info.c
      BitKeeper/deleted/.del-mrg_locking.c~112756a2d581e1d0:
        Delete: merge/mrg_locking.c
      BitKeeper/deleted/.del-mrg_open.c~6e1d5c8bfa62a519:
        Delete: merge/mrg_open.c
      BitKeeper/deleted/.del-mrg_panic.c~e204e43cd6d55406:
        Delete: merge/mrg_panic.c
      BitKeeper/deleted/.del-mrg_rrnd.c~6087c3dd7ecb77:
        Delete: merge/mrg_rrnd.c
      BitKeeper/deleted/.del-mrg_rsame.c~3e8ed4be2a0952b1:
        Delete: merge/mrg_rsame.c
      BitKeeper/deleted/.del-mrg_static.c~75a4b78a165dbd0:
        Delete: merge/mrg_static.c
      BitKeeper/deleted/.del-mrg_update.c~4110a4f1fbf1ab45:
        Delete: merge/mrg_update.c
      BitKeeper/deleted/.del-Makefile.am~41238af048e60515:
        Delete: merge/Makefile.am
      BitKeeper/deleted/.del-make-ccc~4f1acbfc127e25d5:
        Delete: merge/make-ccc
      BitKeeper/deleted/.del-mrg_def.h~a10557d12a87ef1c:
        Delete: merge/mrg_def.h
      BitKeeper/deleted/.del-.cvsignore~2f287ba794db3da7:
        Delete: merge/.cvsignore
      include/myisam.h:
        Added 'share' to st_mi_keydef' to not have to pass 'st_myisam_info' to functions
      myisam/ft_static.c:
        Removed compiler warning
      myisam/mi_delete.c:
        Cleanup of mi_print_error() handling
        Break if get_key() return 0
        Don't test for HA_ERR_CRASHED; Print errors when my_errno is set
      myisam/mi_extra.c:
        Cleanup of mi_print_error() handling
      myisam/mi_key.c:
        Cleanup of mi_print_error() handling
      myisam/mi_keycache.c:
        Cleanup of mi_print_error() handling
      myisam/mi_locking.c:
        Cleanup of mi_print_error() handling
      myisam/mi_open.c:
        Added 'my_isam_share' to MI_KEYDEF
      myisam/mi_page.c:
        Cleanup of mi_print_error() handling
      myisam/mi_range.c:
        get_key() calls mi_print_error() if needed
      myisam/mi_rkey.c:
        Cleanup of mi_print_error() handling
      myisam/mi_search.c:
        Cleanup of mi_print_error() handling
        Break if get_key() return 0
        Don't test for HA_ERR_CRASHED; Print errors when my_errno is set
      myisam/mi_update.c:
        Cleanup of mi_print_error() handling
      myisam/mi_write.c:
        Cleanup of mi_print_error() handling
        Break if get_key() return 0
        Don't test for HA_ERR_CRASHED; Print errors when my_errno is set
      myisam/myisamdef.h:
        Cleanup of mi_print_error() handling
      mysql-test/r/grant.result:
        Update results after merge
      mysql-test/r/timezone2.result:
        Update results after merge
      mysql-test/t/grant.test:
        New error numbers
      mysql-test/t/timezone2.test:
        New error numbers
      sql/item_func.cc:
        Remove duplicate include file
      sql/sql_acl.cc:
        Remove warnings from valgrind
      sql/tztime.cc:
        Print wrong timezone names to log
      45199f54
  13. 30 Dec, 2004 2 commits
    • unknown's avatar
      After merge fixes · 2e8d13c7
      unknown authored
      config/ac-macros/character_sets.m4:
        Added latin1_spanish_ci
      dbug/dbug_analyze.c:
        Remove compiler warnings
      include/my_handler.h:
        Reorder structure arguments to be more optimal
      innobase/dict/dict0load.c:
        Fixed wrong define tag (for MySQL 5.0)
      innobase/fil/fil0fil.c:
        Fixed compiler warning
      innobase/os/os0file.c:
        Fixed compiler warning
      myisam/ft_boolean_search.c:
        Fixed compiler warning
      myisam/ft_static.c:
        Update to use new HA_KEYSEG structure
      myisam/mi_open.c:
        Simple optimization
      myisammrg/myrg_static.c:
        Removed compiler warning
      mysql-test/r/grant.result:
        Update results after merge
      mysql-test/r/index_merge.result:
        Update results after merge
      mysql-test/r/information_schema_inno.result:
        Add missing drop table
      mysql-test/r/lowercase_table.result:
        safety fix
      mysql-test/r/multi_update.result:
        safety fix
      mysql-test/r/ps_1general.result:
        safety fix
      mysql-test/r/ps_2myisam.result:
        Update results after merge
        (set is not anymore of binary type)
      mysql-test/r/ps_3innodb.result:
        Update results after merge
      mysql-test/r/ps_4heap.result:
        Update results after merge
      mysql-test/r/ps_5merge.result:
        Update results after merge
      mysql-test/r/ps_6bdb.result:
        Update results after merge
      mysql-test/r/show_check.result:
        Update results after merge
      mysql-test/r/subselect.result:
        Update results after merge
        (added missing quotes)
      mysql-test/r/timezone2.result:
        Update results after merge
      mysql-test/r/view.result:
        Update results after merge
        (note that INSERT IGNORE will work again after next merge from 4.1)
      mysql-test/t/derived.test:
        Removed empty line
      mysql-test/t/grant.test:
        Update results after merge
      mysql-test/t/information_schema_inno.test:
        added missing drop table
      mysql-test/t/lowercase_table.test:
        safety fix
      mysql-test/t/multi_update.test:
        safety fix
      mysql-test/t/ps_1general.test:
        safety fix
      mysql-test/t/view.test:
        update error codes after merge
      ndb/src/mgmsrv/main.cpp:
        after merge fix
      ndb/tools/ndb_test_platform.cpp:
        removed compiler warnings
      regex/main.c:
        remove compiler warnings
      sql/field.cc:
        Remove compiler warning
      sql/gen_lex_hash.cc:
        Added DBUG support
      sql/ha_myisam.cc:
        Removed warning from valgrind
      sql/ha_ndbcluster.cc:
        Remove compiler warning
      sql/item_cmpfunc.cc:
        Better to use val_int() instead of val_real() as we don't want Item_func_nop_all to return different value than the original ref element
      sql/mysqld.cc:
        Remove compiler warning
      sql/sql_acl.cc:
        More debugging
      sql/sql_lex.cc:
        Remove unnecessary 'else'
      sql/sql_parse.cc:
        After merge fixes
        Simplify reset of thd->server_status for SQLCOM_CALL
      sql/sql_prepare.cc:
        After merge fixes
        Removed possible core dump in mysql_stmt_fetch()
      sql/sql_update.cc:
        After merge fixes (together with Sanja)
      strings/ctype-czech.c:
        Remove compiler warning
      strings/ctype-ucs2.c:
        Remove compiler warning
      strings/ctype-win1250ch.c:
        Remove compiler warning
      strings/xml.c:
        Remove compiler warning
      tests/client_test.c:
        Fix test to work with 5.0
      vio/test-sslserver.c:
        Portability fix
      2e8d13c7
    • unknown's avatar
  14. 29 Dec, 2004 2 commits
    • unknown's avatar
      WL#1339. More post-merge fixes. · 23517e16
      unknown authored
      Updated test results after adding max_user_connections column
      to mysql.user table.
      
      
      mysql-test/r/grant.result:
        Updated test results after adding max_user_connections column
        to mysql.user table.
      mysql-test/r/information_schema.result:
        Updated test results after adding max_user_connections column
        to mysql.user table.
      23517e16
    • unknown's avatar
      WL#1339 "Add per account max_user_connections limit (maximum number · 05b709fc
      unknown authored
      of concurrent connections for the same account)"
      
      Added support of account specific max_user_connections limit. Made all
      user limits to be counted per account instead of the old behavior,
      which was per user/host accounting. Added option which enables the old
      behavior. Added testing of these to the test suite.
      
      (After review version).
      
      
      client/mysqltest.c:
        Extended mysqltest to be able to handle connect() statements for which
        error is expected.
        
        - Added replace_dynstr_append() utility function.
        - added connect_n_handle_errors() function which connects with server
          without retries and handles errors as if "connect" was usual
          statement.
        - do_connect(): added ability to handle connects which are expected
          to return an error.
        - run_query_normal(): Moved all expected-error-handling code to separate
          normal_handle_error()/normal_handle_no_error() functions to be able
          to reuse them in connect_n_handle_errors().
      mysql-test/r/grant.result:
        Fixed test results since one more column to mysql.user was added.
      mysql-test/r/system_mysql_db.result:
        Fixed test results since one more column to mysql.user was added.
      scripts/mysql_create_system_tables.sh:
        Added max_user_connections column to mysql.user table for storing
        new maximal concurrent connections per account limit.
      scripts/mysql_fix_privilege_tables.sql:
        Added max_user_connections column to mysql.user table for storing
        new maximal concurrent connections per account limit.
      sql/lex.h:
        Added MAX_USER_CONNECTIONS symbol used for specifying
        maximum number of concurrent connections per account.
      sql/mysql_priv.h:
        Added declaration of opt_old_style_user_limits variable which is defined
        in sql/mysqld.cc used in sql/sql_parse.cc.
      sql/mysqld.cc:
        Added "old-style-user-limits" option which forces user limits to behave
        in old way i.e. to be counted per user/host pair instead of per account.
        Added comment describing mqh_used variable.
      sql/set_var.cc:
        Added sys_var_max_user_conn class which implements support for the new 
        behavior of max_user_connections variable. Now the global instance of
        this variable holds default maximum number of concurrent connections per
        account (as it was before) and the session instance gives read-only
        access to account-specific version of this limit.
      sql/set_var.h:
        Added sys_var_max_user_conn class which implements support for the new 
        behavior of max_user_connections variable. Now the global instance of
        this variable holds default maximum number of concurrent connections per
        account (as it was before) and the session instance gives read-only
        access to account-specific version of this limit.
      sql/sql_acl.cc:
        Added support for account-specific MAX_USER_CONNECTIONS limit.
        Tweaked USER_RESOURCES and their handling for better clarity.
      sql/sql_parse.cc:
        Added support for account-specific MAX_USER_CONNECTIONS (maximum number
        of concurrent connections per account) limit. Changed default behavior
        of all user limits to be per account instead of per user+host.
        '--old-style-user-limits' option was added to enable the old behavior.
        Made maximum number of connections per hour to be independant on the
        value of global max_user_connections variable.
      sql/sql_yacc.yy:
        Added support of new MAX_USER_CONNECTIONS limit to grammar.
        Renamed USER_RESOURCES::connections member to conn_per_hour and bits
        member to specified_limits. Also enum is used instead of naked numbers
        when we are working with specified_limits.
      sql/structs.h:
        USER_RESOURCES struct:
         - Added user_conn member to store the maximum number of concurrent 
           connections for an account. Renamed connections member to 
           conn_per_hour for less ambiguity.
         - Renamed member 'bits' to 'specified_limits' for the sake of clarity.
           The member was used as a flag indicating which limits were mentioned
           in GRANT clause.
         - Added comments.
        USER_CONN struct:
         - Removed unused user_len member.
         - Added comments.
      05b709fc
  15. 23 Dec, 2004 2 commits
    • unknown's avatar
      Make GRANTs, which change SSL attributes and/or user limits, · 4a5ca0bc
      unknown authored
      to behave well on 5.0 tables (well now you can't use tables from 4.1
      and 5.0 with 4.0 because former use utf8, but still it is nice to have
      similar code in acl_init() and replace_user_table()).
      This also will make such GRANTs working in 5.0 (they are broken now).
      
      
      mysql-test/r/grant.result:
        Added test for GRANT which manipulates user limits.
      mysql-test/t/grant.test:
        Added test for GRANT which manipulates user limits.
      4a5ca0bc
    • unknown's avatar
      WL#925 - Privileges for stored routines · 09ce0b33
      unknown authored
        Implement fine-grained control over access to stored procedures
        Privileges are cached (same way as existing table/column privs)
        
      
      
      mysql-test/include/system_db_struct.inc:
        WL#925 - Privileges for stored routines
          New system table: procs_priv
      mysql-test/r/connect.result:
        WL#925 - Privileges for stored routines
          New system table: procs_priv
      mysql-test/r/grant.result:
        WL#925 - Privileges for stored routines
          user table has additional privilege attributes
          SHOW PRIVILEGES amended
      mysql-test/r/grant2.result:
        Fix result
      mysql-test/r/information_schema.result:
        WL#925 - Privileges for stored routines
          New system table procs_priv
          New user privileges
      mysql-test/r/show_check.result:
        Fix result
      mysql-test/r/sp-security.result:
        WL#925 - Privileges for stored routines
          Fix existing tests to work with new privileges
          New tests for new privileges
      mysql-test/r/sp.result:
        WL#925 - Privileges for stored routines
          Fix SHOW PRIVILEGES results
      mysql-test/r/system_mysql_db.result:
        WL#925 - Privileges for stored routines
          New system table: procs_priv
          user and db tables have new privilege attributes
      mysql-test/t/grant2.test:
        Fix test
      mysql-test/t/show_check.test:
        Fix test
      mysql-test/t/sp-security.test:
        WL#925 - Privileges for stored routines
          Allow existing tests to run with new privilege checks
          New tests for privileges
      mysql-test/t/system_mysql_db_fix.test:
        WL#925 - Privileges for stored routines
          New system table: procs_priv
      scripts/mysql_create_system_tables.sh:
        WL#925 - Privileges for stored routines
          db and user has new privilege attributes
          new system table: procs_priv
      scripts/mysql_fix_privilege_tables.sql:
        WL#925 - Privileges for stored routines
          new system table: procs_priv
      scripts/mysql_install_db.sh:
        WL#925 - Privileges for stored routines
          Amend comment
      sql/item_func.cc:
        WL#925 - Privileges for stored routines
          Privilege check for stored FUNCTION routine
      sql/lex.h:
        WL#925 - Privileges for stored routines
          new token ROUTINE
      sql/mysql_priv.h:
        WL#925 - Privileges for stored routines
          New function: check_procedure_access()
      sql/mysqld.cc:
        WL#925 - Privileges for stored routines
          system option automatic-sp-privileges
      sql/set_var.cc:
        WL#925 - Privileges for stored routines
          system option automatic-sp-privileges
      sql/share/errmsg.txt:
        WL#925 - Privileges for stored routines
          rename errormessage to conform:
            ER_SP_ACCESS_DENIED_ERROR -> ER_PROCACCESS_DENIED_ERROR
          New error messages
            ER_NONEXISTING_PROC_GRANT, ER_PROC_AUTO_GRANT_FAIL, ER_PROC_AUTO_REVOKE_FAIL
      sql/sp.cc:
        WL#925 - Privileges for stored routines
          new function: sp_exists_routine()
      sql/sp.h:
        WL#925 - Privileges for stored routines
          new function: sp_exists_routine()
      sql/sql_acl.cc:
        WL#925 - Privileges for stored routines
          Implementation for SP privileges.
          Privileges are cached in memory hash.
          New functions:
            mysql_procedure_grant()
            check_grant_procedure()
            sp_revoke_privileges()
            sp_grant_privileges()
      sql/sql_acl.h:
        WL#925 - Privileges for stored routines
          New privilege bits: CREATE_PROC_ACL, ALTER_PROC_ACL
          Alter confusing bit-segments to be shifted
          New macros: fix_rights_for_procedure() get_rights_for_procedure()
          New functions:
            mysql_procedure_grant()
            check_grant_procedure()
            sp_grant_privileges()
            sp_revoke_privileges()
      sql/sql_lex.h:
        WL#925 - Privileges for stored routines
          new all_privileges attribute in LEX
      sql/sql_parse.cc:
        WL#925 - Privileges for stored routines
          Remove function: check_sp_definer_access()
          Add handling for SP grants/revokes
          Add privilege checks for stored procedure invocation
      sql/sql_show.cc:
        WL#925 - Privileges for stored routines
          update result for SHOW PRIVILEGES
      sql/sql_yacc.yy:
        WL#925 - Privileges for stored routines
          New token ROUTINE
          rename some rules
          handle CREATE ROUTINE / ALTER ROUTINE privileges
      09ce0b33
  16. 18 Dec, 2004 2 commits
    • unknown's avatar
      Fix test results · b1eb4521
      unknown authored
      b1eb4521
    • unknown's avatar
      Bug#7391 - Multi-table UPDATE security regression · 4f9a0a06
      unknown authored
        Add in missing privilege checks. 
        Tests for the privileges.
      
      
      mysql-test/r/grant.result:
        Bug#7391 - Multi-table UPDATE security regression
          Tests column, table and db level access
      mysql-test/t/grant.test:
        Bug#7391 - Multi-table UPDATE security regression
          Tests column, table and db level access
      sql/sql_update.cc:
        Bug#7391 - Multi-table UPDATE security regression
          Add in missing privilege checks.
      4f9a0a06
  17. 06 Dec, 2004 1 commit
    • unknown's avatar
      After merge fixes · a1fba2da
      unknown authored
      Fixed compiler warnings
      Fix core dump when sending SIGHUP to mysqld
      
      
      mysql-test/r/drop_temp_table.result:
        After merge fixes
      mysql-test/r/grant.result:
        After merge fixes
      mysql-test/r/group_min_max.result:
        After merge fixes
      mysql-test/r/innodb.result:
        After merge fixes
      mysql-test/r/insert_select.result:
        After merge fixes
      mysql-test/r/rpl_charset.result:
        After merge fixes
      mysql-test/r/rpl_create_database.result:
        After merge fixes
      mysql-test/r/rpl_loaddata_rule_m.result:
        After merge fixes
      mysql-test/t/rpl_charset.test:
        After merge fixes
      mysql-test/t/rpl_create_database.test:
        After merge fixes
      sql-common/client.c:
        After merge fixes
      sql/item.cc:
        After merge fixes
      sql/mysqld.cc:
        Fix core dump when sending SIGHUP to mysqld
      sql/sql_acl.cc:
        Better comment
      sql/sql_derived.cc:
        Fixed comment
        Added missing DBUG_RETURN
      sql/sql_insert.cc:
        Fixed compiler warnings
        After merge fixes
      sql/sql_lex.cc:
        After merge fixes
        Removed compiler warnings
      sql/sql_parse.cc:
        After merge fixes
      sql/sql_select.cc:
        More debugging
      sql/sql_table.cc:
        Added missing DBUG_VOID_RETURN
      sql/sql_update.cc:
        Fixed compiler warning
      sql/sql_view.cc:
        Added missing DBUG_RETURN
        Fixed compiler warnings
        Added flag to signal that the view is a derived table
      a1fba2da
  18. 02 Dec, 2004 1 commit
    • unknown's avatar
      Fixes (bug #6932: 'revoke all privileges...' doesn't remove all proper columns from columns_priv · 491a3d90
      unknown authored
             bug #6933: error in the tests/grant.pl test).
      
      
      mysql-test/r/grant.result:
        A fix (bug #6932: 'revoke all privileges...' doesn't remove all proper columns from columns_priv).
      mysql-test/t/grant.test:
        A fix (bug #6932: 'revoke all privileges...' doesn't remove all proper columns from columns_priv).
      sql/sql_acl.cc:
        A fix (bug #6932: 'revoke all privileges...' doesn't remove all proper columns from columns_priv).
        The problem is that we use whole key length (including 'Column_name' keypart)                          
        during scanning the 'columns_priv' table in case of revoke_grant.
      tests/grant.pl:
        A fix (bug #6933: error in the tests/grant.pl test).
      491a3d90
  19. 27 Nov, 2004 1 commit
    • unknown's avatar
      create/drop/rename user cleanup · 257763a9
      unknown authored
      dbug/user.r:
        help cralified
      include/mysqld_error.h:
        new error message added
      mysql-test/r/grant.result:
        results updated
      mysql-test/r/grant2.result:
        results updated
      mysql-test/t/grant.test:
        results updated
      mysql-test/t/grant2.test:
        results updated
      sql/share/czech/errmsg.txt:
        error message updated
      sql/share/danish/errmsg.txt:
        error message updated
      sql/share/dutch/errmsg.txt:
        error message updated
      sql/share/english/errmsg.txt:
        error message updated
      sql/share/estonian/errmsg.txt:
        error message updated
      sql/share/french/errmsg.txt:
        error message updated
      sql/sql_acl.cc:
        changed error reporting for create/drop/rename user to be consistent with drop table
      sql/share/german/errmsg.txt:
        error message updated
      sql/share/greek/errmsg.txt:
        error message updated
      sql/share/hungarian/errmsg.txt:
        error message updated
      sql/share/italian/errmsg.txt:
        error message updated
      sql/share/japanese/errmsg.txt:
        error message updated
      sql/share/korean/errmsg.txt:
        error message updated
      sql/share/norwegian-ny/errmsg.txt:
        error message updated
      sql/share/norwegian/errmsg.txt:
        error message updated
      sql/share/polish/errmsg.txt:
        error message updated
      sql/share/portuguese/errmsg.txt:
        error message updated
      sql/share/romanian/errmsg.txt:
        error message updated
      sql/share/russian/errmsg.txt:
        error message updated
      sql/share/serbian/errmsg.txt:
        error message updated
      sql/share/slovak/errmsg.txt:
        error message updated
      sql/share/spanish/errmsg.txt:
        error message updated
      sql/share/swedish/errmsg.txt:
        error message updated
      sql/share/ukrainian/errmsg.txt:
        error message updated
      257763a9
  20. 25 Nov, 2004 1 commit
    • unknown's avatar
      WL#2050 - CREATE USER and DROP USER and RENAME USER · 75e2c2fd
      unknown authored
      Added new commands CREATE USER and RENAME USER.
      Changed behaviour of DROP USER.
      Changed an error messages for the new commands.
      
      
      Docs/mysqld_error.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      include/mysqld_error.h:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Changed an error code for more general use.
      mysql-test/r/grant.result:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Changed test results.
      mysql-test/r/grant2.result:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        New test results.
      mysql-test/r/ps_1general.result:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Changed test results.
      mysql-test/t/grant.test:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Updated old tests for new behaviour of DROP USER.
        It does now implicitly remove all privileges and
        does not fail when privileges are still in place.
        Fixed a typo, which left an user in the database,
        whereby other tests could be confused.
        Added a DROP USER for another test user.
      mysql-test/t/grant2.test:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Added new tests for the new features.
      sql/share/czech/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/danish/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/dutch/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/english/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/estonian/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/french/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/german/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/greek/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/hungarian/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/italian/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/japanese/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/korean/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/norwegian-ny/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/norwegian/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/polish/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/portuguese/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/romanian/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/russian/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/serbian/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/slovak/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/spanish/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/swedish/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/share/ukrainian/errmsg.txt:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Modified an error message for more general use.
      sql/sql_acl.cc:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Added a destructor for the GRANT_TABLE object to get
        rid of a hash_column in cases where a nonsense row was
        read from the privilege tables. Added code to delete
        such an object when it is not entered into the 
        column_priv_hash due to a nonsense row.
        Added function comments to two unmodified functions.
        Replaced mysql_drop_user() by the implementation of all
        of the functions as specified in the Low Level Design.
      sql/sql_acl.h:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Added prototypes for new functions.
      sql/sql_lex.h:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Added new command codes for CREATE USER and
        RENAME USER.
      sql/sql_parse.cc:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Added case clauses for the new commands CREATE USER
        and RENAME USER.
      sql/sql_yacc.yy:
        WL#2050 - CREATE USER and DROP USER and RENAME USER
        Added syntax for the new commands CREATE USER and 
        RENAME USER, reworked DROP USER, introduced a new
        'user_list' and 'rename_list', renamed the old 
        'user_list' to 'grant_list'. The difference is that
        'grant_list' contains 'grant_user' (with optional
        IDENTIFIED BY), while 'user_list' contains 'user'.
        Concentrated privilege initializazions into a new
        section 'clear_privileges'.
      75e2c2fd
  21. 12 Nov, 2004 1 commit
    • unknown's avatar
      After merge fixes · 55ae2e78
      unknown authored
      client/mysqldump.c:
        Merge with 4.0 (and reordering of options)
      client/mysqltest.c:
        Added DB as a user variable
      myisam/mi_check.c:
        Trivial cleanup
      mysql-test/r/grant.result:
        Move test to be in same order as in 4.0
      mysql-test/r/mix_innodb_myisam_binlog.result:
        Updated results
      mysql-test/r/ps_1general.result:
        Updated tests to work after privilege fixes
      mysql-test/r/timezone3.result:
        Updated results to 4.1
      mysql-test/t/ps_1general.test:
        Updated tests to work after privilege fixes
      sql-common/my_time.c:
        Applied sub-second patch from 4.0
      sql/sql_acl.cc:
        More debugging
      55ae2e78
  22. 11 Nov, 2004 1 commit
    • unknown's avatar
      Bug#6123 - GRANT USAGE creates useless mysql.db row · b19eb67f
      unknown authored
        Prevent creation of a row which grants no rights
        Test included
      
      
      mysql-test/r/grant.result:
        Test for Bug#6123
      mysql-test/t/grant.test:
        Test for Bug#6123
      sql/sql_acl.cc:
        Bug#6123
          Prevent creation of useless row
      b19eb67f
  23. 01 Oct, 2004 2 commits
    • unknown's avatar
      grant.test, grant.result, sql_acl.cc: · f0440c27
      unknown authored
        BUG #5831 Changed mysql_revoke_all() to successfully delete all privileges for a user in one pass.
      
      
      sql/sql_acl.cc:
        BUG #5831 Changed mysql_revoke_all() to successfully delete all privileges for a user in one pass.
      mysql-test/r/grant.result:
        BUG #5831 Changed mysql_revoke_all() to successfully delete all privileges for a user in one pass.
      mysql-test/t/grant.test:
        BUG #5831 Changed mysql_revoke_all() to successfully delete all privileges for a user in one pass.
      f0440c27
    • unknown's avatar
      logging_ok: · 44d855e7
      unknown authored
        Logging to logging@openlogging.org accepted
      sql_acl.cc, grant.test, grant.result:
        BUG 5831 Changed mysql_revoke_all() to successfully delete all privileges for a user in one pass.
      
      
      mysql-test/r/grant.result:
        BUG 5831 Changed mysql_revoke_all() to successfully delete all privileges for a user in one pass.
      mysql-test/t/grant.test:
        BUG 5831 Changed mysql_revoke_all() to successfully delete all privileges for a user in one pass.
      sql/sql_acl.cc:
        BUG 5831 Changed mysql_revoke_all() to successfully delete all privileges for a user in one pass.
      BitKeeper/etc/logging_ok:
        Logging to logging@openlogging.org accepted
      44d855e7
  24. 27 Aug, 2004 2 commits
    • unknown's avatar
      grant.result: · 3d2e2ddd
      unknown authored
        Forgot to push in the previous changeset
      
      
      mysql-test/r/grant.result:
        Forgot to push in the previous changeset
      3d2e2ddd
    • unknown's avatar
      grant.result: · 1ba9966b
      unknown authored
        Bug 4338 mysql-test-run fails if compiled with non-latin1 character set: partual fix.
      
      
      mysql-test/r/grant.result:
        Bug 4338 mysql-test-run fails if compiled with non-latin1 character set: partual fix.
      1ba9966b
  25. 19 Aug, 2004 1 commit
    • unknown's avatar
      after merge fixes · ae2bf627
      unknown authored
      strings/my_vsnprintf.c:
        %.#s support in my_vsnprintf
      BitKeeper/etc/ignore:
        Added EXCEPTIONS-CLIENT to the ignore list
      ae2bf627
  26. 12 Aug, 2004 2 commits
  27. 20 Jul, 2004 1 commit
  28. 15 Jul, 2004 1 commit
    • unknown's avatar
      VIEW · 8790b1e6
      unknown authored
      two TABLE_LIST copy eliminated
      
      
      include/mysqld_error.h:
        errors of view
      libmysqld/Makefile.am:
        new view file
      mysql-test/r/connect.result:
        SHOW TABLE show type of table
      mysql-test/r/ctype_recoding.result:
        SHOW TABLE show type of table
      mysql-test/r/drop.result:
        SHOW TABLE show type of table
      mysql-test/r/grant.result:
        new two privileges (CRETEA|SHOW VIEW)
      mysql-test/r/lowercase_table.result:
        SHOW TABLE show type of table
      mysql-test/r/ps_1general.result:
        SHOW TABLE show type of table
      mysql-test/r/rename.result:
        SHOW TABLE show type of table
      mysql-test/r/rpl000009.result:
        SHOW TABLE show type of table
      mysql-test/r/rpl_error_ignored_table.result:
        SHOW TABLE show type of table
      mysql-test/r/select.result:
        SHOW TABLE show type of table
      mysql-test/r/system_mysql_db.result:
        SHOW TABLE show type of table
        new two privileges (CRETEA|SHOW VIEW)
      mysql-test/t/system_mysql_db_fix.test:
        removing all system tables
      scripts/mysql_fix_privilege_tables.sql:
        new two privileges (CRETEA|SHOW VIEW)
      sql/Makefile.am:
        new VIEW related file
      sql/ha_myisammrg.cc:
        two TABLE_LIST copy eliminated
      sql/item.cc:
        VIEW
      sql/item.h:
        VIEW
      sql/item_subselect.cc:
        VIEW
      sql/item_subselect.h:
        VIEW
      sql/lex.h:
        VIEW
      sql/lock.cc:
        VIEW
      sql/mysql_priv.h:
        VIEW
      sql/mysqld.cc:
        VIEW
        new parameter - sql_updatable_view_key
      sql/opt_sum.cc:
        two TABLE_LIST copy eliminated
      sql/set_var.cc:
        new parameter - sql_updatable_view_key
      sql/share/czech/errmsg.txt:
        errors messages of views
      sql/share/danish/errmsg.txt:
        errors messages of views
      sql/share/dutch/errmsg.txt:
        errors messages of views
      sql/share/english/errmsg.txt:
        errors messages of views
      sql/share/estonian/errmsg.txt:
        errors messages of views
      sql/share/french/errmsg.txt:
        errors messages of views
      sql/share/german/errmsg.txt:
        errors messages of views
      sql/share/greek/errmsg.txt:
        errors messages of views
      sql/share/hungarian/errmsg.txt:
        errors messages of views
      sql/share/italian/errmsg.txt:
        errors messages of views
      sql/share/japanese/errmsg.txt:
        errors messages of views
      sql/share/korean/errmsg.txt:
        errors messages of views
      sql/share/norwegian-ny/errmsg.txt:
        errors messages of views
      sql/share/norwegian/errmsg.txt:
        errors messages of views
      sql/share/polish/errmsg.txt:
        errors messages of views
      sql/share/portuguese/errmsg.txt:
        errors messages of views
      sql/share/romanian/errmsg.txt:
        errors messages of views
      sql/share/russian/errmsg.txt:
        errors messages of views
      sql/share/serbian/errmsg.txt:
        errors messages of views
      sql/share/slovak/errmsg.txt:
        errors messages of views
      sql/share/spanish/errmsg.txt:
        errors messages of views
      sql/share/swedish/errmsg.txt:
        errors messages of views
      sql/share/ukrainian/errmsg.txt:
        errors messages of views
      sql/slave.cc:
        two TABLE_LIST copy eliminated
      sql/sp.cc:
        VIEW
      sql/sql_acl.cc:
        VIEW
      sql/sql_acl.h:
        VIEW
      sql/sql_base.cc:
        VIEW
      sql/sql_cache.cc:
        two TABLE_LIST copy eliminated
      sql/sql_class.h:
        VIEW
      sql/sql_db.cc:
        two TABLE_LIST copy eliminated
      sql/sql_delete.cc:
        VIEW
      sql/sql_derived.cc:
        VIEW
      sql/sql_handler.cc:
        two TABLE_LIST copy eliminated
      sql/sql_help.cc:
        two TABLE_LIST copy eliminated
      sql/sql_insert.cc:
        VIEW
      sql/sql_lex.cc:
        VIEW
      sql/sql_lex.h:
        VIEW
      sql/sql_load.cc:
        VIEW
      sql/sql_olap.cc:
        VIEW
      sql/sql_parse.cc:
        two TABLE_LIST copy eliminated
        VIEW
      sql/sql_prepare.cc:
        VIEW
      sql/sql_rename.cc:
        two TABLE_LIST copy eliminated
      sql/sql_select.cc:
        VIEW
      sql/sql_show.cc:
        VIEW
      sql/sql_table.cc:
        VIEW
      sql/sql_union.cc:
        VIEW
      sql/sql_update.cc:
        VIEW
      sql/sql_yacc.yy:
        VIEW
      sql/table.cc:
        VIEW
      sql/table.h:
        VIEW
      sql/tztime.cc:
        two TABLE_LIST copy eliminated
      sql/unireg.h:
        VIEW
      tests/client_test.c:
        VIEW
      8790b1e6
  29. 08 Jul, 2004 1 commit
  30. 15 Jun, 2004 1 commit
  31. 14 May, 2004 1 commit