Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.6, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.7(EOL), 10.8(EOL)
-
None
Description
CREATE TEMPORARY TABLES privilege is supposed to allow all actions with temporary tables created by the session.
However, while it also allows to run SHOW COLUMNS on such tables, it's not sufficient to get a result, it remains empty.
Oddly, SHOW INDEX works.
create database db; |
create user foo@localhost; |
grant create temporary tables on db.* to foo@localhost; |
|
--connect (con1,localhost,foo,,db)
|
create temporary table tmp (a int, key(a)); |
show create table tmp; |
show columns in tmp; |
show index in tmp; |
|
# Cleanup
|
--disconnect con1
|
--connection default
|
drop database db; |
drop user foo@localhost; |
bb-10.9-anel 32274c3e8a4 |
show columns in tmp; |
Field Type Null Key Default Extra |
show index in tmp; |
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Ignored |
tmp 1 a 1 a A NULL NULL NULL YES BTREE NO |
Attachments
Issue Links
- relates to
-
MDEV-28544 Appending SELECT privilege not applied on show columns and show index
- Closed
-
MDEV-28548 ER_TABLEACCESS_DENIED_ERROR is missing information about DB
- Closed
-
MDEV-28783 Privilege inconsistency between show columns and information_schema.columns
- Open
-
MDEV-12459 The information_schema tables for getting temporary tables info is missing, at least for innodb there is no INNODB_TEMP_TABLE_INFO
- Closed
-
MDEV-28544 Appending SELECT privilege not applied on show columns and show index
- Closed
- links to