Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
None
-
None
Description
create schema if not exists crashtest;
|
use crashtest;
|
CREATE TABLE `PROJECTS` (`LIBRARY_ID` int(11) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
insert into PROJECTS (LIBRARY_ID) values (1046);
|
 |
ANALYZE FORMAT = JSON
|
with recursive
|
effective_project_security as (
|
select project.LIBRARY_ID
|
from PROJECTS as project
|
where project.LIBRARY_ID = 1046
|
union all
|
select project_child.LIBRARY_ID
|
from PROJECTS as project_parent
|
inner join effective_project_security as project_child
|
on project_parent.LIBRARY_ID = project_child.LIBRARY_ID
|
where 1=1),
|
effective_descendant_security as (
|
select project.LIBRARY_ID
|
from PROJECTS as project
|
inner join effective_project_security
|
on project.LIBRARY_ID = effective_project_security.LIBRARY_ID
|
where 1=1)
|
select * from PROJECTS as main;
|
This script will crash mariadb server: signal 11.
tested on 10.5.10-7-MariaDB-enterprise
Not all ANALYZE on recursive CTE will crash the server. Customer provided one that does not crash.
Attachments
Issue Links
- duplicates
-
MDEV-23160 SIGSEGV in Explain_node::print_explain_for_children on UNION SELECT or on EXPLAIN EXTENDED (on optimized builds)
- Closed