summaryrefslogtreecommitdiff
path: root/mysql-test/r/alter_table.result
diff options
context:
space:
mode:
authorjimw@mysql.com <>2005-04-01 19:17:15 -0800
committerjimw@mysql.com <>2005-04-01 19:17:15 -0800
commit5865330a9e27c050dd644705457eb5d4415e27fd (patch)
tree0f605570b31eecc8dd6b58343d5a07d32375e540 /mysql-test/r/alter_table.result
parent2292480e795a02973b828a37f826c6e4e0192b69 (diff)
parent623a5d5a57f8f8ee2674245e0abafaef698577fb (diff)
downloadmariadb-git-5865330a9e27c050dd644705457eb5d4415e27fd.tar.gz
Merge embedded server testing changes from 4.1.
Diffstat (limited to 'mysql-test/r/alter_table.result')
-rw-r--r--mysql-test/r/alter_table.result14
1 files changed, 3 insertions, 11 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result
index 03d0ebf5433..88b04b292ea 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 NO PRI 0 select,insert,update,references
-LANG_ID smallint(5) unsigned NULL NO PRI 0 select,insert,update,references
-NAME char(80) latin1_swedish_ci NO MUL select,insert,update,references
+GROUP_ID int(10) unsigned NULL NO PRI 0 #
+LANG_ID smallint(5) unsigned NULL NO PRI 0 #
+NAME char(80) latin1_swedish_ci NO 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),