[MDEV-14982]  Crash occurs when executing duplicate SELECT query in INSERT statement. Created: 2018-01-18  Updated: 2018-04-03  Resolved: 2018-04-03

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Insert
Affects Version/s: 10.2.6
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Hangyoo, Woo Assignee: Alice Sherepa
Resolution: Incomplete Votes: 0
Labels: crash
Environment:

Ubuntu 16.04 Xenial.
MariaDB 10.2.6

Attachments: Text File MariaDB-Crash-Insert-sub-select.txt    

 Description   

INSERT INTO TABLE1 (FIELDS ....)
SELECT ...
FROM (
SELECT ...
ORDER BY .....
FROM (
SELECT ....
FROM (
SELECT ....
FROM TABLE2 AAA
JOIN TABLE3 BBB ON B
....
JOIN TABLE4 SHM ON ...
LEFT JOIN TABLE 5 BIC ON ...
JOIN TABLE5 BRM ON ...
JOIN TABLE6 CPM ON ...
JOIN TABLE7 COD ON ...
WHERE ... 'WHERE-CONDITION') STL) X1) X2

 Comments   
Comment by Elena Stepanova [ 2018-01-23 ]

Are you using any JSON functions?

Comment by Hangyoo, Woo [ 2018-02-19 ]

No, I'm not using JSON Functions.
Thanks.

Comment by Alice Sherepa [ 2018-02-20 ]

please add exact query and structure of tables, that are involved in it or a testcase, so I will have a chance to reproduce it on my side.

Comment by Hangyoo, Woo [ 2018-03-06 ]

The Crash problem I mentioned above seems to be the same as the MDEV-14857 issue.
When upgrading from 10.2.11 to 10.2.13, there are no crashed issues at all.

Thanks

Comment by Alice Sherepa [ 2018-03-06 ]

Good) I will keep this bug report open for some time, in case this crash appears again, please notify me.

Generated at Thu Feb 08 08:17:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.