Bug #97936 ERROR 1443 when select * from information_schema.tables
Submitted: 10 Dec 2019 3:22 Modified: 10 Dec 2019 3:50
Reporter: Jia Xu Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Information schema Severity:S3 (Non-critical)
Version:5.6, 5.6.46 OS:Any
Assigned to: CPU Architecture:Any
Tags: Security definer, VIEW

[10 Dec 2019 3:22] Jia Xu
Description:
ERROR 1443 when select * from information_schema.tables

How to repeat:
create database if not exists sbtest;
use sbtest;
create table if not exists t1 (id int);
CREATE ALGORITHM=UNDEFINED DEFINER=`xx1`@`%` SQL SECURITY DEFINER VIEW project AS SELECT `sbtest`.`t1`.`id` AS `id` from `sbtest`.`t1` group by `sbtest`.`t1`.`id`;
select * from information_schema.tables;

---------------------------------------------

mysqltest: At line 5: query 'select * from information_schema.tables' failed: 1143: SELECT command denied to user ''@'%' for column 'id' in table 't1'
[10 Dec 2019 3:50] Umesh Shastry
Hello Jia Xu,

Thank you for the report and test case.
Observed that 5.6.46 is affected.

regards,
Umesh