Bug #112470 | Assertion Failure in /mysql-8.0.34/sql/item_sum.cc:642 | ||
---|---|---|---|
Submitted: | 26 Sep 9:30 | Modified: | 26 Sep 9:32 |
Reporter: | xin wen | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DDL | Severity: | S6 (Debug Builds) |
Version: | 8.0.34 | OS: | Ubuntu (20.04) |
Assigned to: | CPU Architecture: | Any |
[26 Sep 9:30]
xin wen
[26 Sep 9:32]
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 9:33]
MySQL Verification Team
- release build ./mtr --nocheck-testcases bug112470 Logging: ./mtr --nocheck-testcases bug112470 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 ( CONSTRAINT cc0 CHECK ( c52 > REPEAT ( -77 , COS ( -5093762040897600327 ) ) + TRIM( -112 ) REGEXP ( SELECT STDDEV_SAMP( QUOTE ( 10 ) AND REVERSE ( -6564566756798818168 ) OR RAND ( ) ) OVER ( ORDER BY 4310251258742839724 ) AS c14 GROUP BY 1 LIMIT 1 ) ) , c52 INT ) REPLACE AS SELECT 81 AS c44 WHERE -48 IS NULL ; [ 50%] main.bug112470 [ fail ] Test ended at 2023-09-26 11:32:01 CURRENT_TEST: main.bug112470 mysqltest: At line 1: Query 'CREATE TABLE t0 ( CONSTRAINT cc0 CHECK ( c52 > REPEAT ( -77 , COS ( -5093762040897600327 ) ) + TRIM( -112 ) REGEXP ( SELECT STDDEV_SAMP( QUOTE ( 10 ) AND REVERSE ( -6564566756798818168 ) OR RAND ( ) ) OVER ( ORDER BY 4310251258742839724 ) AS c14 GROUP BY 1 LIMIT 1 ) ) , c52 INT ) REPLACE AS SELECT 81 AS c44 WHERE -48 IS NULL ' failed. ERROR 3814 (HY000): An expression of a check constraint 'cc0' contains disallowed function: rand. safe_process[24137]: Child process: 24138, exit: 1 -- debug build ./mtr --nocheck-testcases bug112470 --debug-server Logging: ./mtr --nocheck-testcases bug112470 --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 ( CONSTRAINT cc0 CHECK ( c52 > REPEAT ( -77 , COS ( -5093762040897600327 ) ) + TRIM( -112 ) REGEXP ( SELECT STDDEV_SAMP( QUOTE ( 10 ) AND REVERSE ( -6564566756798818168 ) OR RAND ( ) ) OVER ( ORDER BY 4310251258742839724 ) AS c14 GROUP BY 1 LIMIT 1 ) ) , c52 INT ) REPLACE AS SELECT 81 AS c44 WHERE -48 IS NULL ; [ 50%] main.bug112470 [ fail ] Test ended at 2023-09-26 11:32:40 CURRENT_TEST: main.bug112470 mysqltest: At line 1: Query 'CREATE TABLE t0 ( CONSTRAINT cc0 CHECK ( c52 > REPEAT ( -77 , COS ( -5093762040897600327 ) ) + TRIM( -112 ) REGEXP ( SELECT STDDEV_SAMP( QUOTE ( 10 ) AND REVERSE ( -6564566756798818168 ) OR RAND ( ) ) OVER ( ORDER BY 4310251258742839724 ) AS c14 GROUP BY 1 LIMIT 1 ) ) , c52 INT ) REPLACE AS SELECT 81 AS c44 WHERE -48 IS NULL ' failed. ERROR 2013 (HY000): Lost connection to MySQL server during query