[MDEV-26108] Crash with query referencing twice CTE that uses embedded recursive CTE - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.4(EOL), 10.5(EOL), 10.6
Fix Version/s: 10.4.21, 10.5.12, 10.6.4
Component/s: Optimizer - CTE
Labels:
None

Description

Processing of a query containing at least two references to the same CTE that uses an embedded recursive CTE causes a crash of the server in 10.4+.
Here's a simple test case that demonstrates this problem.

create table t1 (a int);

insert into t1 values (5), (7);

with cte_e as (

  with recursive cte_r as (

    select a from t1 union select a+1 as a from cte_r r where a < 10

  ) select * from cte_r

) select * from cte_e s1, cte_e s2 where s1.a=s2.a;

Attachments

Issue Links

relates to

MDEV-25103 Crash at JOIN::reinit - calling stored procedure

Closed

MDEV-26025 Server crashes while executing query with CTE in PS/SP

Closed

Activity

People

Assignee:: Igor Babaev (Inactive)

Reporter:: Igor Babaev (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2021-07-07 22:17

Updated:: 2021-08-24 13:11

Resolved:: 2021-07-10 02:09

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

1d 4h 20m

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.