diff options
author | Sergei Golubchik <sergii@pisem.net> | 2013-10-18 08:10:51 -0700 |
---|---|---|
committer | Sergei Golubchik <sergii@pisem.net> | 2013-10-18 08:10:51 -0700 |
commit | 72d8b533cc102aad6be5046a0fe8b8e63ec1e218 (patch) | |
tree | edd77fe431acee4ba0fa859a8fcb650dad971771 /scripts | |
parent | 8122996a599fcb6dc600f27fddbed47a2579c6b8 (diff) | |
download | mariadb-git-72d8b533cc102aad6be5046a0fe8b8e63ec1e218.tar.gz |
Fixes for mysql-test failures
mysql-test/r/acl_roles_show_grants.result:
one can do SHOW GRANTS for himself
mysql-test/t/acl_roles_set_role-table-column-priv.test:
correct error message
mysql-test/t/acl_roles_show_grants.test:
one can SHOW GRANTS for himself
sql/sql_acl.cc:
bugfixing:
* don't assign with && - it can shortcut and the second assignment won't be executed
* correct the test in check_grant_all_columns() - want_access should not be modified
*
sql/sql_cmd.h.OTHER:
add new commands at the end
sql/sql_db.cc:
don't call acl_get() if all privileges are already satisfied
(crashes when run with --skip-grants, because acl data stuctures aren't initialized)
sql/sql_parse.cc:
* test for current_user in get_current_user()
* map explicitly specified user@host to current_user
Diffstat (limited to 'scripts')
-rw-r--r-- | scripts/mysql_system_tables.sql | 6 |
1 files changed, 1 insertions, 5 deletions
diff --git a/scripts/mysql_system_tables.sql b/scripts/mysql_system_tables.sql index de6c33fb4f9..30bea5d9b0f 100644 --- a/scripts/mysql_system_tables.sql +++ b/scripts/mysql_system_tables.sql @@ -41,11 +41,7 @@ CREATE TABLE IF NOT EXISTS user ( Host char(60) binary DEFAULT '' NOT NULL, Us -- Remember for later if user table already existed set @had_user_table= @@warning_count != 0; -CREATE TABLE IF NOT EXISTS roles_mapping ( - HostFk char(60) binary DEFAULT '' NOT NULL, - UserFk char(16) binary DEFAULT '' NOT NULL, - RoleFk char(16) binary DEFAULT '' NOT NULL -); +CREATE TABLE IF NOT EXISTS roles_mapping (HostFk char(60) binary DEFAULT '' NOT NULL, UserFk char(16) binary DEFAULT '' NOT NULL, RoleFk char(16) binary DEFAULT '' NOT NULL); CREATE TABLE IF NOT EXISTS func ( name char(64) binary DEFAULT '' NOT NULL, ret tinyint(1) DEFAULT '0' NOT NULL, dl char(128) DEFAULT '' NOT NULL, type enum ('function','aggregate') COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (name) ) engine=MyISAM CHARACTER SET utf8 COLLATE utf8_bin comment='User defined functions'; |