Bug #112501 Assertion Failure in /mysql-8.0.34/sql/item_sum.cc:784
Submitted: 26 Sep 2023 11:44 Modified: 26 Sep 2023 11:49
Reporter: xin wen Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S6 (Debug Builds)
Version:8.0.34 OS:Ubuntu (20.04)
Assigned to: CPU Architecture:Any

[26 Sep 2023 11:44] xin wen 
Description:
Run these queries:

CREATE TABLE t0 ( c26 DECIMAL ( 26 ) DEFAULT ( 100 ) ) ;
INSERT INTO t0 VALUES ( DEFAULT ) , ( DEFAULT ) ;
CREATE INDEX i0 ON t0 ( c26 ) ;
INSERT INTO t0 VALUES ( -107 ) , ( -108 ) ;
SELECT c26 AS c38 FROM t0 WHERE IF ( 91 = SOME ( SELECT PI ( ) % NULLIF ( t0 . c26 , 1 ) | RAND ( t0 . c26 ) AS c46 FROM t0 ) , OCT ( 4907588636007314062 ) REGEXP TRIM( LEADING 415825826347058372 FROM RAND ( ) LIKE TRUE ) , NOT t0 . c26 IN ( -105 NOT REGEXP CASE t0 . c26 WHEN 101 THEN RAND ( ) OR RAND ( -23 ) % ACOS ( 82 ) / RAND ( ) NOT LIKE RAND ( ) ELSE 47 END , 44 , -119 ) ) & ( SELECT STDDEV_SAMP( t0 . c26 IS NOT UNKNOWN ) IN ( SELECT c26 AS c12 FROM t0 ) AS c57 GROUP BY c26 , c26 , c26 , c26 , c26 , c26 , c26 , c26 WITH ROLLUP WINDOW w0 AS ( PARTITION BY c26 ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) LIMIT 1 ) IS NOT NULL > ALL ( SELECT c26 AS c57 FROM t0 HAVING FLOOR ( t0 . c26 ) ) HAVING CASE -76 WHEN 71 THEN 60 ELSE 57 END + 26 ;

Will trigger assertion failure:
mysqld: /home/wx/mysql-8.0.34/sql/item_sum.cc:784: virtual void Item_sum::fix_after_pullout(Query_block*, Query_block*): Assertion `aggr_query_block != removed_query_block' failed.

How to repeat:
Run the queries above.
[26 Sep 2023 11:44] xin wen 
GDB info

Attachment: GDB_info.txt (text/plain), 7.42 KiB.
[26 Sep 2023 11:49] MySQL Verification Team 
Hello xin wen,

Thank you for the report and test case.
Observed that 8.0.34 debug build is affected.

regards,
Umesh