[MDEV-31001] Cannot create temporary table in read only transaction Created: 2023-04-04  Updated: 2023-04-06  Resolved: 2023-04-06

Status: Closed
Project: MariaDB Server
Component/s: N/A
Affects Version/s: 10.6.12
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Pavel Cibulka Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Galera, binlog_format=ROW


 Description   

I think it was possible to create temporay table in read only transaction in the past.

When I run:

SET SESSION TRANSACTION READ ONLY;
 
CREATE TEMPORARY TABLE t (i INT);

I will get error:

Error Code: 1792. Cannot execute statement in a READ ONLY transaction



 Comments   
Comment by Alice Sherepa [ 2023-04-06 ]

No, nothing is changed there, DDL is not allowed in TRANSACTION READ ONLY (https://github.com/MariaDB/server/commit/d99b8004e6b46e2a1b321bf50825254bf841cddb#diff-98b75aeb8cf97be995000dede115b1062c25d26180190853c5da9ddfcccd27baR433 )

Generated at Thu Feb 08 10:20:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.