diff options
author | unknown <msvensson@shellback.(none)> | 2006-02-28 13:54:32 +0100 |
---|---|---|
committer | unknown <msvensson@shellback.(none)> | 2006-02-28 13:54:32 +0100 |
commit | 26dab541e14d7ebfa17af64f6e3789d0953f1242 (patch) | |
tree | 044b586be95579aedeafed3502ab4bd4c1bf6ebf /mysql-test/t/grant2.test | |
parent | bab96216a88f087c662967df993b67898801774d (diff) | |
download | mariadb-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.test | 11 |
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); |