summaryrefslogtreecommitdiff
path: root/mysql-test/t/grant2.test
diff options
context:
space:
mode:
authorunknown <msvensson@shellback.(none)>2006-02-28 13:54:32 +0100
committerunknown <msvensson@shellback.(none)>2006-02-28 13:54:32 +0100
commit26dab541e14d7ebfa17af64f6e3789d0953f1242 (patch)
tree044b586be95579aedeafed3502ab4bd4c1bf6ebf /mysql-test/t/grant2.test
parentbab96216a88f087c662967df993b67898801774d (diff)
downloadmariadb-git-26dab541e14d7ebfa17af64f6e3789d0953f1242.tar.gz
Merge 5.0 -> 5.1
mysql-test/r/grant2.result: Update test result mysql-test/t/grant2.test: Explicitly specify "columns" when inserting into mysql.user and mysql.db
Diffstat (limited to 'mysql-test/t/grant2.test')
-rw-r--r--mysql-test/t/grant2.test11
1 files changed, 4 insertions, 7 deletions
diff --git a/mysql-test/t/grant2.test b/mysql-test/t/grant2.test
index 32861d1b184..39ac0b0d105 100644
--- a/mysql-test/t/grant2.test
+++ b/mysql-test/t/grant2.test
@@ -439,13 +439,10 @@ create database TESTDB;
create table t2(a int);
create temporary table t1 as select * from mysql.user;
delete from mysql.user where host='localhost';
-INSERT INTO mysql.user VALUES
-('%','mysqltest_1',password('password'),'N','N','N','N','N','N',
-'N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N',
-'','','','',0,0,0,0);
-INSERT INTO mysql.db VALUES
-('%','TESTDB','mysqltest_1','Y','Y','Y','Y','Y','Y','N','Y','Y','Y','Y','N','Y','Y','Y','
-Y','N');
+INSERT INTO mysql.user (host, user, password) VALUES
+('%','mysqltest_1',password('password'));
+INSERT INTO mysql.db (host, db, user, select_priv) VALUES
+('%','TESTDB','mysqltest_1','Y');
FLUSH PRIVILEGES;
connect (con1,localhost,mysqltest_1,password,TESTDB);