[MDEV-28342] sys.create_synonym_db fails when a temporary table masks a base table Created: 2022-04-18  Updated: 2023-08-11  Resolved: 2022-05-12

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Temporary, Server
Affects Version/s: 10.6, 10.7, 10.8
Fix Version/s: 10.6.8, 10.7.4, 10.8.3, 10.9.1

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Anel Husakovic
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-28391 table_exists procedure fails when arg... Closed
relates to MDEV-28343 sys.create_synonym_db fails with ER_V... Closed

 Description    

create database db;
 
use db;
 
create table t (b int);
 
create temporary table t (a int);
 
 
 
call sys.create_synonym_db('db','db_copy');

10.6 7da351d8

 
mysqltest: At line 6: query 'call sys.create_synonym_db('db','db_copy')' failed: ER_VIEW_SELECT_TMPTABLE (1352): View's SELECT refers to a temporary table 't'



 Comments   
Comment by Anel Husakovic [ 2022-04-22 ]

Hi wlad can you please review
https://github.com/MariaDB/server/tree/bb-10.6-anel-MDEV-28342-create_synonym

After this patch MDEV-28343 (10.9 preview branch) will be updated.

Comment by Vladislav Vaintroub [ 2022-05-10 ]

I'm fine with it.

Comment by Anel Husakovic [ 2022-05-12 ]

Pushed with c1063a1bed0008c

Generated at Thu Feb 08 09:59:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.