Description:
An assertion failure occurred in mysql-8.0.29-debug-asan:
Test case:
```
CREATE TABLE t0 ( c0 TEXT ) ;
CREATE TABLE t1 ( c0 TINYINT ( 3 ) UNSIGNED ZEROFILL , c1 FLOAT DEFAULT NULL , UNIQUE KEY c0 ( c0 ) ) ;
INSERT INTO t0 VALUES ( '292269042' ) , ( '' ) , ( NULL ) , ( 'IcK5A' ) , ( NULL ) , ( 'z)]s' ) , ( '292269042' ) , ( '4f*T' ) ;
INSERT INTO t1 VALUES ( 255 , NULL ) , ( NULL , 0 ) , ( NULL , 292269000 ) , ( 0 , NULL ) , ( NULL , NULL ) ;
SELECT ra0 . c0 FROM ( t1 ra0 , ( SELECT ( NOT ISNULL( ra2 . c0 ) AND ra2 . c0 = - 292269000 ) ca3 FROM t0 ra2 WHERE - 0.000001 ) AS ra1 ) WHERE ra0 . c1 IN ( SELECT LEFT( NULL , 0 ) ca2 FROM t1 ra3 WHERE ra3 . c1 NOT IN ( ( SELECT 0 ca0 FROM t1 ra4 ) UNION ( ( SELECT 255 ca1 FROM t0 ra5 ORDER BY ra1 . ca3 ) ) ) ) LIMIT 100 ;
```
Log file:
```
2022-06-25T21:59:29.632113Z 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/item_subselect.cc:2432: Item_subselect::trans_res Item_in_subselect::select_in_like_transformer(THD *, Query_block *, Comp_creator *): Assertion `!sl->order_list.first' failed.
23:25:46 UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x62700002d900
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 = 7f5c5251bb20 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) [0x7f5c84e70390]
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38) [0x7f5c83364438]
/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a) [0x7f5c8336603a]
/lib/x86_64-linux-gnu/libc.so.6(+0x2dbe7) [0x7f5c8335cbe7]
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc92) [0x7f5c8335cc92]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Item_in_subselect::select_in_like_transformer(THD*, Query_block*, Comp_creator*)+0xe1f) [0x684e90f]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Query_block::resolve_subquery(THD*)+0x1b03) [0x7ac71a3]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Query_block::prepare(THD*, mem_root_deque<Item*>*)+0x29f4) [0x7ab5394]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Query_expression::prepare(THD*, Query_result*, mem_root_deque<Item*>*, unsigned long long, unsigned long long)+0x100d) [0x7e1391d]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(SubqueryWithResult::prepare(THD*)+0x1f8) [0x682fc18]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Item_subselect::fix_fields(THD*, Item**)+0x318) [0x682ef88]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Item_in_subselect::fix_fields(THD*, Item**)+0x357) [0x684f507]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Query_block::setup_conds(THD*)+0x4e3) [0x7abd193]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Query_block::prepare(THD*, mem_root_deque<Item*>*)+0x1322) [0x7ab3cc2]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Query_expression::prepare(THD*, Query_result*, mem_root_deque<Item*>*, unsigned long long, unsigned long long)+0x100d) [0x7e1391d]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(SubqueryWithResult::prepare(THD*)+0x1f8) [0x682fc18]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Item_subselect::fix_fields(THD*, Item**)+0x318) [0x682ef88]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Item_in_subselect::fix_fields(THD*, Item**)+0x357) [0x684f507]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Query_block::setup_conds(THD*)+0x4e3) [0x7abd193]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Query_block::prepare(THD*, mem_root_deque<Item*>*)+0x1322) [0x7ab3cc2]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Sql_cmd_select::prepare_inner(THD*)+0x80a) [0x7b62e2a]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Sql_cmd_dml::prepare(THD*)+0x12c5) [0x7b61055]
/home/mysql-server/mysql-8.0.29-origin-dev/bin/mysqld(Sql_cmd_dml::execute(THD*)+0x8fc) [0x7b63d1c]
/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) [0x7f5c84e666ba]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7f5c8343651d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (61700019af29): SELECT ra0 . c0 FROM ( t1 ra0 , ( SELECT ( NOT ISNULL( ra2 . c0 ) AND ra2 . c0 = - 292269000 ) ca3 FROM t0 ra2 WHERE - 0.000001 ) AS ra1 ) WHERE ra0 . c1 IN ( SELECT LEFT( NULL , 0 ) ca2 FROM t1 ra3 WHERE ra3 . c1 NOT IN ( ( SELECT 0 ca0 FROM t1 ra4 ) UNION ( ( SELECT 255 ca1 FROM t0 ra5 ORDER BY ra1 . ca3 ) ) ) ) LIMIT 100
Connection ID (thread ID): 15938
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.
```
Observed that 8.0.29 release build isn't affected.
How to repeat:
Run the test case:
```
CREATE TABLE t0 ( c0 TEXT ) ;
CREATE TABLE t1 ( c0 TINYINT ( 3 ) UNSIGNED ZEROFILL , c1 FLOAT DEFAULT NULL , UNIQUE KEY c0 ( c0 ) ) ;
INSERT INTO t0 VALUES ( '292269042' ) , ( '' ) , ( NULL ) , ( 'IcK5A' ) , ( NULL ) , ( 'z)]s' ) , ( '292269042' ) , ( '4f*T' ) ;
INSERT INTO t1 VALUES ( 255 , NULL ) , ( NULL , 0 ) , ( NULL , 292269000 ) , ( 0 , NULL ) , ( NULL , NULL ) ;
SELECT ra0 . c0 FROM ( t1 ra0 , ( SELECT ( NOT ISNULL( ra2 . c0 ) AND ra2 . c0 = - 292269000 ) ca3 FROM t0 ra2 WHERE - 0.000001 ) AS ra1 ) WHERE ra0 . c1 IN ( SELECT LEFT( NULL , 0 ) ca2 FROM t1 ra3 WHERE ra3 . c1 NOT IN ( ( SELECT 0 ca0 FROM t1 ra4 ) UNION ( ( SELECT 255 ca1 FROM t0 ra5 ORDER BY ra1 . ca3 ) ) ) ) LIMIT 100 ;
```
