diff options
Diffstat (limited to 'mysql-test/main/empty_user_table.test')
| -rw-r--r-- | mysql-test/main/empty_user_table.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/main/empty_user_table.test b/mysql-test/main/empty_user_table.test new file mode 100644 index 00000000000..b54f2109e30 --- /dev/null +++ b/mysql-test/main/empty_user_table.test @@ -0,0 +1,20 @@ +# +# MDEV-4462 mysqld gets SIGFPE when mysql.user table is empty +# + +source include/not_embedded.inc; + +create table t1 as select * from mysql.user; +truncate table mysql.user; +flush privileges; + +# connecting via unix socket gives ER_ACCESS_DENIED_ERROR +# connecting via tcp/ip gives ER_HOST_NOT_PRIVILEGED +--replace_result $MASTER_MYSOCK MASTER_SOCKET $MASTER_MYPORT MASTER_PORT +--error ER_ACCESS_DENIED_ERROR,ER_HOST_NOT_PRIVILEGED +connect (fail,localhost,u1); + +insert mysql.user select * from t1; +drop table t1; +flush privileges; + |