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
• Status: Verified
• Category: MySQL Server: Information schema
• Severity: S3 (Non-critical)
• Version: 5.6, 5.6.46
• OS: Any
• 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] MySQL Verification Team

Hello Jia Xu,

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

regards,
Umesh