Bug #110181 tmp_table_size=51200 causing error that tmp does not exists

• Submitted: 23 Feb 2023 9:45
• Modified: 23 Feb 2023 10:02
• Reporter: Yunus UYANIK
• Status: Verified
• Category: MySQL Server: Information schema
• Severity: S3 (Non-critical)
• Version: 8.0.32
• OS: Any
• CPU Architecture: Any

[23 Feb 2023 9:45] Yunus UYANIK

Description:
When selecting some of the tables in information_schema with tmp_table_size=51200, MySQL gives an error.

ADMINISTRABLE_ROLE_AUTHORIZATIONS
APPLICABLE_ROLES
ROLE_TABLE_GRANTS 

How to repeat:
mysqld  Ver 8.0.32 for Linux on x86_64 (MySQL Community Server - GPL)

mysql> set global tmp_table_size=51200;

mysql> show global variables like 'tmp_table_size';
+----------------+-------+
| Variable_name  | Value |
+----------------+-------+
| tmp_table_size | 51200 |
+----------------+-------+

mysql> select * from information_schema.APPLICABLE_ROLES;
ERROR 1146 (42S02): Table './tmp/#sql113a_8_1' doesn't exist

[23 Feb 2023 10:02] MySQL Verification Team

Hello Yunus UYANIK,

Thank you for the report and feedback.

regards,
Umesh