[MDEV-31324] Crash by subselect with unused columns Created: 2023-05-22  Updated: 2023-06-03  Resolved: 2023-05-22

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Subquery
Affects Version/s: 10.11.3, 10.10.4
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: Rico Koerner Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: crash
Environment:

Debian 11.7 amd64

Attachments: File error.log-10.10     File error.log-10.11    
Issue Links:
Duplicate
duplicates MDEV-31240 Crash with condition pushable into de... Closed

 Description   

The server crashes after select with unused columns in a subselect with the following pattern:
SELECT DISTINCT col1 FROM (SELECT col1, col2 FROM foo)
The problem is col2.
In version 10.10.3 and 10.11.2 the same query does not cause errors.

 Comments   
Comment by Alice Sherepa [ 2023-05-22 ]

Thanks!
This is the same problem as MDEV-31240. Setting optimizer_switch="split_materialized=off" could be used as a workaround until the fix is released.

Generated at Thu Feb 08 10:22:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.