Bug #107660 Assertion in val_decimal() failed in MySQL 8.0.29
Description:
An assertion failure occurred in mysql-8.0.29-debug-asan.
Test case:
```
CREATE TABLE t1 ( c0 INT , c1 DECIMAL ( 10 , 0 ) , UNIQUE KEY c1 ( c1 ) ) ;
INSERT INTO t1 SELECT 0 , 0 ;
SELECT 'fixme' ca3 FROM t1 ra0 LEFT JOIN ( SELECT - 0 AS ca2 FROM ( ( t1 ra2 JOIN t1 ra3 ON ra3 . c1 = ra2 . c1 ) JOIN t1 ra4 ON ra4 . c1 = ra2 . c1 ) ) AS ra1 ON false HAVING SUM( ra0 . c1 ) > ( SELECT SUM( 'fixme' ) ca0 FROM t1 ra5 LEFT OUTER JOIN ( SELECT - SUM( ra0 . c0 ) AS ca1 FROM t1 ra7 ) AS ra6 ON false ) WINDOW v AS ( ) ;
```
Log file:
```
2022-06-25T16:51:36.279438Z 0 [System] [MY-010931] [Server] /home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld: ready for connections. Version: '8.0.29-debug-asan' socket: '/tmp/mysql.sock' port: 3306 Source distribution.
mysqld: /home/mysql-server/mysql-8.0.29-origin/sql/field.cc:2032: virtual my_decimal *Field_num::val_decimal(my_decimal *) const: Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index()))' failed.
20:33:41 UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x627000070100
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7fbd6cda0b20 thread_stack 0x100000
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(__interceptor_backtrace+0x5b) [0x5e4e34b]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x10d) [0xb6ab1cd]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(print_fatal_signal(int)+0x389) [0x8149469]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(handle_fatal_signal+0x175) [0x8149ab5]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390) [0x7fbd9f444390]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38) [0x7fbd9d938438]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a) [0x7fbd9d93a03a]
/lib/x86_64-linux-gnu/libc.so.6(+0x2dbe7) [0x7fbd9d930be7]
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc92) [0x7fbd9d930c92]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld() [0x6040b5b]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Item_field::val_decimal(my_decimal*)+0x16c) [0x621ac7c]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Item_sum_sum::add()+0x2c6) [0x6959ae6]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(AggregateIterator::Read()+0xb05) [0x6a928a5]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(FilterIterator::Read()+0xd5) [0x6a8fe55]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Query_expression::ExecuteIteratorQuery(THD*)+0x104a) [0x7e1fcaa]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Query_expression::execute(THD*)+0x2bd) [0x7e215dd]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Sql_cmd_dml::execute_inner(THD*)+0x2d7) [0x7b670f7]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Sql_cmd_dml::execute(THD*)+0xe1d) [0x7b6423d]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(mysql_execute_command(THD*, bool)+0x3583) [0x794fbc3]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(dispatch_sql_command(THD*, Parser_state*)+0x1b5d) [0x7945c8d]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x974a) [0x793c61a]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(do_command(THD*)+0xf9c) [0x794149c]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld() [0x80d00a2]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld() [0xd6ac2da]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba) [0x7fbd9f43a6ba]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7fbd9da0a51d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (61700020d81c): SELECT 'fixme' ca3 FROM t1 ra0 LEFT JOIN ( SELECT - 0 AS ca2 FROM ( ( t1 ra2 JOIN t1 ra3 ON ra3 . c1 = ra2 . c1 ) JOIN t1 ra4 ON ra4 . c1 = ra2 . c1 ) ) AS ra1 ON false HAVING SUM( ra0 . c1 ) > ( SELECT SUM( 'fixme' ) ca0 FROM t1 ra5 LEFT OUTER JOIN ( SELECT - SUM( ra0 . c0 ) AS ca1 FROM t1 ra7 ) AS ra6 ON false ) WINDOW v AS ( )
Connection ID (thread ID): 42551
Status: NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
```
How to repeat:
Run the test case:
```
CREATE TABLE t1 ( c0 INT , c1 DECIMAL ( 10 , 0 ) , UNIQUE KEY c1 ( c1 ) ) ;
INSERT INTO t1 SELECT 0 , 0 ;
SELECT 'fixme' ca3 FROM t1 ra0 LEFT JOIN ( SELECT - 0 AS ca2 FROM ( ( t1 ra2 JOIN t1 ra3 ON ra3 . c1 = ra2 . c1 ) JOIN t1 ra4 ON ra4 . c1 = ra2 . c1 ) ) AS ra1 ON false HAVING SUM( ra0 . c1 ) > ( SELECT SUM( 'fixme' ) ca0 FROM t1 ra5 LEFT OUTER JOIN ( SELECT - SUM( ra0 . c0 ) AS ca1 FROM t1 ra7 ) AS ra6 ON false ) WINDOW v AS ( ) ;
```
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.054 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.