[MDEV-3582] LP:978847 - Server crashes in Item_ref::real_item on INSERT .. SELECT with FROM subquery and derived_merge=ON Created: 2012-04-11 Updated: 2015-02-02 Resolved: 2012-10-04 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Critical |
| Reporter: | Elena Stepanova | Assignee: | Oleksandr Byelkin |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | Launchpad | ||
| Attachments: |
|
| Description |
|
#4 <signal handler called> bzr version-info Notes: Minimal optimizer_switch: derived_merge=on EXPLAIN for the SELECT with the minimal switch: Test case: SET optimizer_switch = 'derived_merge=on'; CREATE TABLE t1 ( a INT, b INT ); INSERT INTO t1 SELECT * FROM
|
| Comments |
| Comment by Igor Babaev [ 2012-04-15 ] |
|
Re: Server crashes in Item_ref::real_item on INSERT .. SELECT with FROM subquery and derived_merge=ON |
| Comment by Oleksandr Byelkin [ 2012-04-18 ] |
|
Re: Server crashes in Item_ref::real_item on INSERT .. SELECT with FROM subquery and derived_merge=ON i.e. it inserts two times (3,2) and no (2,1). |
| Comment by Oleksandr Byelkin [ 2012-04-18 ] |
|
Re: Server crashes in Item_ref::real_item on INSERT .. SELECT with FROM subquery and derived_merge=ON |
| Comment by Oleksandr Byelkin [ 2012-04-18 ] |
|
Re: Server crashes in Item_ref::real_item on INSERT .. SELECT with FROM subquery and derived_merge=ON |
| Comment by Oleksandr Byelkin [ 2012-04-18 ] |
|
Re: Server crashes in Item_ref::real_item on INSERT .. SELECT with FROM subquery and derived_merge=ON |
| Comment by Rasmus Johansson (Inactive) [ 2012-05-03 ] |
|
Launchpad bug id: 978847 |