[#MDEV-5266] MySQL:57657 - Temporary MERGE table with temporary underlying is broken by ALTER

[MDEV-5266] MySQL:57657 - Temporary MERGE table with temporary underlying is broken by ALTER Created: 2013-11-08 Updated: 2014-11-17 Resolved: 2013-12-01
Status:	Closed
Project:	MariaDB Server
Component/s:	None
Affects Version/s:	10.0.5, 5.1.67, 5.2.14, 5.3.12, 5.5.34
Fix Version/s:	5.5.35, 10.0.7, 5.1.73, 5.2.15, 5.3.13

Type:

Bug

Priority:

Minor

Reporter:

Elena Stepanova

Assignee:

Sergei Golubchik

Resolution:

Fixed

Votes:

Labels:

upstream

Description

MySQL bug http://bugs.mysql.com/bug.php?id=57657 was fixed in 5.6.5, but the fix apparently was not merged to 10.0. It should be, eventually.

Test case from the bug report:

create temporary table t1_temp(i int);

create temporary table tm_temp_temp (i int) engine=merge union=(t1_temp) insert_method=last;

alter table tm_temp_temp insert_method=first;

check table tm_temp_temp;

Comments

Comment by Sergei Golubchik [ 2013-12-01 ]

pushed in 5.1

Comment by Daniel Bartholomew [ 2014-01-29 ]

Generated at Thu Feb 08 07:02:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.