diff options
| author | Alexander Barkov <bar@mariadb.org> | 2016-06-10 10:02:07 +0400 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2016-06-30 11:43:02 +0200 |
| commit | b5870a5dd3bdca79b7974dc1850f5ac0dde17b6a (patch) | |
| tree | 39c3990236b9d0d0d4bdc56e8de62a720b40c15d /mysql-test/t/grant.test | |
| parent | 5ba196c42865a694a286ff90e36264a5320eaff1 (diff) | |
| download | mariadb-git-b5870a5dd3bdca79b7974dc1850f5ac0dde17b6a.tar.gz | |
More test for MDEV-10134 Add full support for DEFAULT
Functions DATABASE() and USER().
Diffstat (limited to 'mysql-test/t/grant.test')
| -rw-r--r-- | mysql-test/t/grant.test | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/t/grant.test b/mysql-test/t/grant.test index d3f84596106..7bcc7c5a28a 100644 --- a/mysql-test/t/grant.test +++ b/mysql-test/t/grant.test @@ -2172,3 +2172,29 @@ drop user mysqltest_u1; set GLOBAL sql_mode=default; # Wait till we reached the initial number of concurrent sessions --source include/wait_until_count_sessions.inc + +--echo # +--echo # Start of 10.2 tests +--echo # + +--echo # +--echo # MDEV-10134 Add full support for DEFAULT +--echo # + + +CREATE TABLE t1 (a VARCHAR(30) DEFAULT USER()); +INSERT INTO t1 VALUES (); +GRANT ALL PRIVILEGES ON test.* TO dummy@localhost IDENTIFIED BY 'pwd'; +connect (conn1,localhost,dummy,pwd,test); +connection conn1; +INSERT INTO t1 VALUES (); +connection default; +disconnect conn1; +INSERT INTO t1 VALUES (); +SELECT * FROM t1; +DROP TABLE t1; +DROP USER dummy@localhost; + +--echo # +--echo # End of 10.2 tests +--echo # |