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/alter_table.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/alter_table.result')
| -rw-r--r-- | mysql-test/r/alter_table.result | 14 |
1 files changed, 3 insertions, 11 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result index 7d2b3f01ae6..222477cece9 100644 --- a/mysql-test/r/alter_table.result +++ b/mysql-test/r/alter_table.result @@ -52,9 +52,9 @@ KEY NAME (NAME)); ALTER TABLE t1 CHANGE NAME NAME CHAR(80) not null; SHOW FULL COLUMNS FROM t1; Field Type Collation Null Key Default Extra Privileges Comment -GROUP_ID int(10) unsigned NULL PRI 0 select,insert,update,references -LANG_ID smallint(5) unsigned NULL PRI 0 select,insert,update,references -NAME char(80) latin1_swedish_ci MUL select,insert,update,references +GROUP_ID int(10) unsigned NULL PRI 0 # +LANG_ID smallint(5) unsigned NULL PRI 0 # +NAME char(80) latin1_swedish_ci MUL # DROP TABLE t1; create table t1 (n int); insert into t1 values(9),(3),(12),(10); @@ -117,14 +117,6 @@ name mysqltest drop table t1; drop database mysqltest; -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; create table t1 (n1 int not null, n2 int, n3 int, n4 float, unique(n1), key (n1, n2, n3, n4), |