Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
12.0.2
-
None
-
mariadb:latest (12.0.2-MariaDB), Linux x86_64
-
Not for Release Notes
Description
I have reproduced a server crash on the latest MariaDB Docker image (12.0.2-MariaDB).
This appears to be related to MDEV-22825.
*Reproduction Steps:*
1. Start a MariaDB 12.0.2 instance.
2. Execute the following SQL:
create database if not exists ReproduceDB;
|
use ReproduceDB;
|
SET optimizer_switch= 'condition_pushdown_for_subquery=on' ;
|
CREATE TABLE main_tab (f1 INT );
|
INSERT INTO main_tab VALUES (1),(2);
|
CREATE TABLE sec_tab (f2 INT );
|
INSERT INTO main_tab VALUES (3),(4);
|
SELECT * FROM main_tab, sec_tab WHERE f2 IN ( SELECT f1 FROM main_tab HAVING f1 = 5 ) AND f1 = 6 AND ( 0 OR f1 = f2 );
|
*Observed Behavior:*
The query causes the MariaDB server process to crash (container exits with code 137).
Attachments
Issue Links
- duplicates
-
-
- Confirmed
-