| Bug #112503 | Assertion Failure in /mysql-8.0.34/sql/field.cc:7119 | ||
|---|---|---|---|
| Submitted: | 26 Sep 11:48 | Modified: | 26 Sep 11:50 |
| Reporter: | xin wen | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: DML | Severity: | S6 (Debug Builds) |
| Version: | 8.0.34 | OS: | Ubuntu (20.04) |
| Assigned to: | CPU Architecture: | Any | |
[26 Sep 11:49]
xin wen
GDB info
Attachment: GDB_info.txt (text/plain), 7.54 KiB.
[26 Sep 11:50]
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
Description: Run these queries: CREATE TABLE t0 ( c37 TEXT , INDEX i0 ( c37 ( 1 ) ) ) REPLACE AS SELECT 76 AS c16 ; INSERT INTO t0 VALUES ( 7976053896441037821 , 115 ) , ( 39 , -32 ) ; ALTER TABLE t0 DROP COLUMN c16 ; INSERT INTO t0 VALUES ( 105 ) , ( 81 ) ; SELECT t0 . c37 AS c39 FROM ( SELECT ( REPLACE ( 114 , 'F;I{J<ty#HqV`|&v' , 'w GBE?A)' ) NOT IN ( c59 SOUNDS LIKE SPACE ( ORD ( c59 ) ) IS TRUE , 95 , -100 ) ) - SUM( c59 ) & LN ( 75 ) IS NOT NULL AS c43 FROM ( SELECT MAKE_SET ( t0 . c37 , ~ TRIM( TRAILING FROM -63 ) , 'gni=qDVSIM8!>{2\\/nl_5tP/Czf{VsK6Z4Ucu>vjyqjs$z:S3m' ) AS c59 FROM t0 ) AS t1 JOIN t0 ON t0 . c37 = t0 . c37 IN ( DEFAULT ( t1 . c59 ) ) GROUP BY c59 ) AS t2 JOIN t0 ON t2 . c43 = t0 . c37 LEFT OUTER JOIN t0 AS t3 USING ( c37 ) ; Will trigger assertion failure: /home/wx/mysql-8.0.34/sql/field.cc:7119: virtual longlong Field_blob::val_int() const: Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index()))' failed. How to repeat: Run the queries above.