MySQL Bugs: #110906: Index creation assertion error 3

Bug #110906	Index creation assertion error 3
Submitted:	4 May 2023 10:56	Modified:	4 May 2023 10:58
Reporter:	Pedro Ferreira	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: DDL	Severity:	S6 (Debug Builds)
Version:	8.0.33	OS:	Ubuntu (22.04)
Assigned to:		CPU Architecture:	x86 (x86_64)
Tags:	CREATE TABLE

Description:
This issue may be related to Bug #110546. Run this statement:

CREATE TABLE t0 (c0 INT, INDEX i1 (((SELECT DISTINCT 1 FROM (SELECT 1) x(x) ORDER BY x.x)))) AS (SELECT 1 c0);

It triggers an assertion error at sql/aggregate_check.cc:116
assert((*order->item)->fixed);

The compilation parameters are the same as issue 108148:

-DWITH_DEBUG=1 -DWITH_ASAN=ON -DWITH_UBSAN=ON and boost library version 1.77

How to repeat:
Run the statement above.

Hello Pedro Ferreira,

Thank you for the report and feedback.
Observed that 8.0.33 debug build is affected.

regards,
Umesh

- 8.0.33

 ./mtr bug110906 --debug-server
Logging: ./mtr  bug110906 --debug-server
MySQL Version 8.0.33
Checking supported features
 - Binaries are debug compiled
Using 'all' suites
Collecting tests
Checking leftover processes
Removing old var directory
 - WARNING: Using the 'mysql-test/var' symlink
Creating var directory '/export/home/tmp/ushastry/mysql-8.0.33/mysql-test/var'
Installing system database
Using parallel: 1

==============================================================================
                  TEST NAME                       RESULT  TIME (ms) COMMENT
------------------------------------------------------------------------------
[ 50%] main.bug110906                            [ fail ]
        Test ended at 2023-05-04 12:58:12

CURRENT_TEST: main.bug110906
mysqltest: At line 1: Query 'CREATE TABLE t0 (c0 INT, INDEX i1 (((SELECT DISTINCT 1 FROM (SELECT 1) x(x) ORDER BY x.x)))) AS (SELECT 1 c0)' failed.
ERROR 2013 (HY000): Lost connection to MySQL server during query

-bt
#0  0x00007f3fd60bcaa1 in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000003f9296e in my_write_core(int) ()
#2  0x00000000032365f5 in handle_fatal_signal ()
#3  <signal handler called>
#4  0x00007f3fd42f6387 in raise () from /lib64/libc.so.6
#5  0x00007f3fd42f7a78 in abort () from /lib64/libc.so.6
#6  0x00007f3fd42ef1a6 in __assert_fail_base () from /lib64/libc.so.6
#7  0x00007f3fd42ef252 in __assert_fail () from /lib64/libc.so.6
#8  0x0000000003340e9f in Distinct_check::check_query(THD*) ()
#9  0x0000000003103d5f in Query_block::check_only_full_group_by(THD*) ()
#10 0x0000000003105d3b in Query_block::apply_local_transforms(THD*, bool) [clone .localalias.10] ()
#11 0x0000000003105c5b in Query_block::apply_local_transforms(THD*, bool) [clone .localalias.10] ()
#12 0x000000000310dbbc in Query_block::prepare(THD*, mem_root_deque<Item*>*) ()
#13 0x000000000318f55e in Query_expression::prepare(THD*, Query_result*, mem_root_deque<Item*>*, unsigned long long, unsigned long long) ()
#14 0x000000000357923c in Sql_cmd_create_table::execute(THD*) ()
#15 0x00000000030c24af in mysql_execute_command(THD*, bool) ()
#16 0x00000000030c5dc9 in dispatch_sql_command(THD*, Parser_state*) ()
#17 0x00000000030c752b in dispatch_command(THD*, COM_DATA const*, enum_server_command) ()
#18 0x00000000030c926e in do_command(THD*) ()
#19 0x0000000003227bb7 in handle_connection ()
#20 0x0000000004743af9 in pfs_spawn_thread ()
#21 0x00007f3fd60b7ea5 in start_thread () from /lib64/libpthread.so.0
#22 0x00007f3fd43beb2d in clone () from /lib64/libc.so.6