| Bug #112462 | Assertion Failure in home/wx/mysql-8.0.34/sql/sql_derived.cc:1641 | ||
|---|---|---|---|
| Submitted: | 26 Sep 2023 8:58 | Modified: | 26 Sep 2023 9:03 |
| 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 2023 8:58]
xin wen
[26 Sep 2023 9:03]
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
[26 Sep 2023 9:04]
MySQL Verification Team
-- 8.0.34 ./mtr --nocheck-testcases bug112462 Logging: ./mtr --nocheck-testcases bug112462 MySQL Version 8.0.34 Checking supported features Using 'all' suites Collecting tests Checking leftover processes Removing old var directory Creating var directory '/export/home/tmp/ushastry/mysql-8.0.34/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ CREATE TABLE t0 ( c0 DECIMAL ( 19 ) DEFAULT ( -95 ) ) ; INSERT INTO t0 VALUES ( -10 ) , ( -118 ) ; ALTER TABLE t0 ADD COLUMN c29 INT AFTER c0 ; INSERT INTO t0 VALUES ( -6 , 52 ) , ( 58 , 85 ) ; SELECT t3 . c49 AS c53 FROM ( SELECT CONCAT ( ( CONCAT_WS ( -103 , '>5~\\9' , '`nLDnE' ) ) = -63 IS NULL = 57 ) * ( WITH RECURSIVE t1 ( c63 ) AS ( SELECT 1 AS c63 UNION SELECT c29 + 22 AS c32 FROM t1 WHERE c29 < 4 AND c0 < -40 AND c29 < 34 AND c29 < 67 AND c63 < 78 AND c0 < -1271988362172968189 AND c0 < -71 AND c29 < 101 AND c63 < 115 ) SELECT c63 AS c55 FROM t1 CROSS JOIN t0 AS t2 WHERE t1 . c63 = 113 GROUP BY c63 , c29 LIMIT 1 ) AS c49 FROM t0 ) AS t3 JOIN t0 ON t0 . c0 = t0 . c0 GROUP BY c0 , c49 HAVING STDDEV_SAMP( t0 . c0 ) ; c53 [ 50%] main.bug112462 [ pass ] 105 [100%] shutdown_report [ pass ] -- debug build ./mtr --nocheck-testcases bug112462 --debug-server Logging: ./mtr --nocheck-testcases bug112462 --debug-server MySQL Version 8.0.34 Checking supported features - Binaries are debug compiled Using 'all' suites Collecting tests Checking leftover processes Removing old var directory Creating var directory '/export/home/tmp/ushastry/mysql-8.0.34/mysql-test/var' Installing system database Using parallel: 1 ============================================================================== TEST NAME RESULT TIME (ms) COMMENT ------------------------------------------------------------------------------ CREATE TABLE t0 ( c0 DECIMAL ( 19 ) DEFAULT ( -95 ) ) ; INSERT INTO t0 VALUES ( -10 ) , ( -118 ) ; ALTER TABLE t0 ADD COLUMN c29 INT AFTER c0 ; INSERT INTO t0 VALUES ( -6 , 52 ) , ( 58 , 85 ) ; SELECT t3 . c49 AS c53 FROM ( SELECT CONCAT ( ( CONCAT_WS ( -103 , '>5~\\9' , '`nLDnE' ) ) = -63 IS NULL = 57 ) * ( WITH RECURSIVE t1 ( c63 ) AS ( SELECT 1 AS c63 UNION SELECT c29 + 22 AS c32 FROM t1 WHERE c29 < 4 AND c0 < -40 AND c29 < 34 AND c29 < 67 AND c63 < 78 AND c0 < -1271988362172968189 AND c0 < -71 AND c29 < 101 AND c63 < 115 ) SELECT c63 AS c55 FROM t1 CROSS JOIN t0 AS t2 WHERE t1 . c63 = 113 GROUP BY c63 , c29 LIMIT 1 ) AS c49 FROM t0 ) AS t3 JOIN t0 ON t0 . c0 = t0 . c0 GROUP BY c0 , c49 HAVING STDDEV_SAMP( t0 . c0 ) ; [ 50%] main.bug112462 [ fail ] Test ended at 2023-09-26 11:02:39 CURRENT_TEST: main.bug112462 mysqltest: At line 5: Query 'SELECT t3 . c49 AS c53 FROM ( SELECT CONCAT ( ( CONCAT_WS ( -103 , '>5~\\9' , '`nLDnE' ) ) = -63 IS NULL = 57 ) * ( WITH RECURSIVE t1 ( c63 ) AS ( SELECT 1 AS c63 UNION SELECT c29 + 22 AS c32 FROM t1 WHERE c29 < 4 AND c0 < -40 AND c29 < 34 AND c29 < 67 AND c63 < 78 AND c0 < -1271988362172968189 AND c0 < -71 AND c29 < 101 AND c63 < 115 ) SELECT c63 AS c55 FROM t1 CROSS JOIN t0 AS t2 WHERE t1 . c63 = 113 GROUP BY c63 , c29 LIMIT 1 ) AS c49 FROM t0 ) AS t3 JOIN t0 ON t0 . c0 = t0 . c0 GROUP BY c0 , c49 HAVING STDDEV_SAMP( t0 . c0 ) ' failed. ERROR 2013 (HY000): Lost connection to MySQL server during query
