Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
10.11.5, 11.1.3
-
None
-
docker quay.io/mariadb-foundation/mariadb-devel:latest
Description
Reproduce testcase:
SET default_storage_engine = InnoDB ;
CREATE TABLE v0 ( v1 INT , v2 SMALLINT NOT NULL PRIMARY KEY ) ;
SELECT v2 FROM v0 . TABLES WHERE v1 = 'x' AND v2 = 'x' ;
INSERT INTO v0 VALUES ( 99 , 'x' ) ;
INSERT INTO v0 VALUES ( v1 , v1 NOT IN ( WITH v0 AS ( SELECT 68 * 8 FROM v0 ) SELECT * FROM v0 GROUP BY v1 HAVING v1 >= NULL AND ( NULL , 9877221.000000 ) < ( NULL , 'x' ) ) ) ;
INSERT INTO v0 VALUES ( v1 , 'x' ) ;
SELECT * FROM v0 ORDER BY v2 ;
DELETE FROM t1 ;
SELECT * FROM v0 ORDER BY v1 ;
ROLLBACK ;
SELECT * FROM v0 ORDER BY v1 ;
DELETE FROM t1 ;
START TRANSACTION ;
SELECT * FROM v0 ORDER BY v1 ;
COMMIT ;
SELECT * FROM v0 ORDER BY v2 ;
DELETE FROM t1 ;
START TRANSACTION ;
SELECT * ORDER BY v2 ;
ROLLBACK ;
SELECT v1 , v1 FROM v0 WHERE v2 > 0 AND CASE ( 0 ) WHEN NOT NOT NULL THEN 'x' / 93 END < 'x' ;
DELETE FROM t1 ;
DROP TABLE v0 ;
ERROR 2013 (HY000): Lost connection to server during query
Attachments
Issue Links
- duplicates
-
MDEV-29210 Assertion `param->field_count > (uint) (copy - copy_start)' failed in setup_copy_fields, SIGSEGV in JOIN::make_sum_func_list, ASAN: use-after-poison in Copy_field::set
- Confirmed