Simplified SQL Query for Problem Diagnosis

Problem Description

When attempting to execute a complex SQL query from MDEV-32760, it will crash. To make it easier to diagnose and fix the issue, I have simplified the original query. The simplified query is intended to replicate the behavior that leads to the system crash, allowing us to focus on the core issue without getting lost in the complexity of the original query.

Original reproduce step:

CREATE TABLE t0 ( c56 INT , c12 CHAR ) ;

INSERT INTO t0 VALUES ( DEFAULT , DEFAULT ) , ( DEFAULT , DEFAULT ) ;

CREATE VIEW v0 AS SELECT c56 AS c33 , c56 AS c16 , -81 AS c45 FROM t0 ;

SELECT VARIANCE( c45 ) AS c36 FROM v0 GROUP BY c45 , c16 HAVING c16 = 61 IN ( 33 , -36 , LENGTH ( REVERSE ( c45 ) = 48 IN ( SELECT CONVERT ( c16 , UNSIGNED ) AS c60 FROM v0 ) ) = 47 ) ;

Minimal reproduce step:

CREATE TABLE t0 ( c56 INT , c12 CHAR ) ;

INSERT INTO t0 VALUES ( DEFAULT , DEFAULT ) , ( DEFAULT , DEFAULT ) ;

CREATE VIEW v0 AS SELECT c56 , c56 AS c16 , -81 AS c45 FROM t0 ;

SELECT  c45   FROM v0

GROUP BY  c16 

HAVING c16 = 61 IN (   c45  = 48 IN ( SELECT c16   FROM v0 )  ) ;

I kindly request the development team to examine this simplified query to identify the root cause of the MDEV-32760 and fix the issue as soon as possible. By the way, please let me know if this simplified query is useful.I believe that by analyzing and fixing this simplified query, you can more easily locate the problem in the original complex query.

Thank you for your hard work and support!