diff options
| author | unknown <jimw@mysql.com> | 2005-02-09 18:17:40 -0800 |
|---|---|---|
| committer | unknown <jimw@mysql.com> | 2005-02-09 18:17:40 -0800 |
| commit | 4f7a0857f17247e05ed05dd6263acba059982337 (patch) | |
| tree | 804cc70225073c3b3615d34b5e1f4759b33a9929 /mysql-test/r/grant.result | |
| parent | 425f2f91117c5cfa7d016130b0814a4bbde08274 (diff) | |
| download | mariadb-git-4f7a0857f17247e05ed05dd6263acba059982337.tar.gz | |
Re-enable alter_table test for embedded server by moving grant-related test
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
Diffstat (limited to 'mysql-test/r/grant.result')
| -rw-r--r-- | mysql-test/r/grant.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/grant.result b/mysql-test/r/grant.result index 22b34ebef62..bb37480aaf8 100644 --- a/mysql-test/r/grant.result +++ b/mysql-test/r/grant.result @@ -427,3 +427,11 @@ delete from mysql.columns_priv where user="mysqltest_3"; flush privileges; drop database mysqltest_1; drop database mysqltest_2; +create database mysqltest; +create table mysqltest.t1 (a int,b int,c int); +grant all on mysqltest.t1 to mysqltest_1@localhost; +alter table t1 rename t2; +ERROR 42000: INSERT,CREATE command denied to user 'mysqltest_1'@'localhost' for table 't2' +revoke all privileges on mysqltest.t1 from mysqltest_1@localhost; +delete from mysql.user where user=_binary'mysqltest_1'; +drop database mysqltest; |