--source include/have_innodb.inc

CREATE TABLE t (a BLOB, b VARCHAR(2048), PRIMARY KEY (b)) ENGINE=InnoDB;

INSERT INTO t VALUES

 (REPEAT('x',4805),'a'), (REPEAT('x',16111),'b'), (REPEAT('x',65535),'c'),

 (REPEAT('x',11312),'d'), (REPEAT('x',35177),'e'), (REPEAT('x',65535),'f'),

 (REPEAT('x',1988),'g'), (NULL,REPEAT('x',2048)), (REPEAT('x',2503),'h'),

 (REPEAT('x',33152),'i'), (REPEAT('x',65535),'j'), (REPEAT('x',1988),'k'),

 (REPEAT('x',65535),'l'), (REPEAT('x',65535),'m'), (REPEAT('x',65535),'n'),

 (REPEAT('x',65535),'o'), (REPEAT('x',1988),'p'), (REPEAT('x',2503),'q'),

 (REPEAT('x',65535),'r'), (REPEAT('x',65535),'s'), (REPEAT('x',65535),'t'),

 (REPEAT('x',3169),'u'), (REPEAT('x',7071),'v'), (REPEAT('x',16111),'w'),

 (REPEAT('x',2325),'x'), (REPEAT('x',33152),'y'), (REPEAT('x',65535),'z'),

 (REPEAT('x',65535),'aa'), (REPEAT('x',16111),'bb'), (REPEAT('x',4805),'cc'),

 (REPEAT('x',65535),'dd');

ALTER TABLE t FORCE, ALGORITHM=COPY;

# Cleanup

DROP TABLE t;

mariadbd: /data/bld/10.11-asan/storage/innobase/rem/rem0cmp.cc:669: int cmp_rec_rec_simple_field(const rec_t*, const rec_t*, const rec_offs*, const rec_offs*, const dict_index_t*, ulint): Assertion `!rec_offs_nth_extern(offsets1, n)' failed.

241121 17:16:34 [ERROR] mysqld got signal 6 ;

#9  0x00007f4aca653e32 in __GI___assert_fail (assertion=0x5566705b51c0 "!rec_offs_nth_extern(offsets1, n)", file=0x5566705b4620 "/data/bld/10.11-asan/storage/innobase/rem/rem0cmp.cc", line=669, function=0x5566705b5220 "int cmp_rec_rec_simple_field(const rec_t*, const rec_t*, const rec_offs*, const rec_offs*, const dict_index_t*, ulint)") at ./assert/assert.c:101

#10 0x000055666ee1e2bf in cmp_rec_rec_simple_field (rec1=0x7f4ab9db1b5c "", rec2=0x7f4ab9eb0005 "z", offsets1=0x7f4ab9dae8a8, offsets2=0x6250003201a0, index=0x616000a9fc20, n=0) at /data/bld/10.11-asan/storage/innobase/rem/rem0cmp.cc:669

#11 0x000055666ee1e7ce in cmp_rec_rec_simple (rec1=0x7f4ab9db1b5c "", rec2=0x7f4ab9eb0005 "z", offsets1=0x7f4ab9dae8a8, offsets2=0x6250003201a0, index=0x616000a9fc20, table=0x0) at /data/bld/10.11-asan/storage/innobase/rem/rem0cmp.cc:707

#12 0x000055666eecced0 in row_merge_blocks (dup=0x7f4abb937b90, file=0x606000063698, block=0x7f4ab9db0000 "\005\024\300\001", foffs0=0x7f4abb9378b0, foffs1=0x7f4abb9378d0, of=0x7f4abb9378f0, stage=0x0, crypt_block=0x0, space=6) at /data/bld/10.11-asan/storage/innobase/row/row0merge.cc:3174

#13 0x000055666eecf36a in row_merge (trx=0x7f4ac26dc3c0, dup=0x7f4abb937b90, file=0x606000063698, block=0x7f4ab9db0000 "\005\024\300\001", tmpfd=0x60d0000101e8, num_run=0x7f4abb937a50, run_offset=0x60400002c7e8, stage=0x0, crypt_block=0x0, space=6) at /data/bld/10.11-asan/storage/innobase/row/row0merge.cc:3375

#14 0x000055666eed0437 in row_merge_sort (trx=0x7f4ac26dc3c0, dup=0x7f4abb937b90, file=0x606000063698, block=0x7f4ab9db0000 "\005\024\300\001", tmpfd=0x60d0000101e8, update_progress=true, pct_progress=0, pct_cost=0, crypt_block=0x0, space=6, stage=0x0) at /data/bld/10.11-asan/storage/innobase/row/row0merge.cc:3521

#15 0x000055666eedc8a9 in row_merge_bulk_t::write_to_index (this=0x60d0000101d0, index_no=0, trx=0x7f4ac26dc3c0) at /data/bld/10.11-asan/storage/innobase/row/row0merge.cc:5271

#16 0x000055666eedcd95 in row_merge_bulk_t::write_to_table (this=0x60d0000101d0, table=0x619000107820, trx=0x7f4ac26dc3c0) at /data/bld/10.11-asan/storage/innobase/row/row0merge.cc:5303

#17 0x000055666eedcfcf in trx_mod_table_time_t::write_bulk (this=0x608000029c60, table=0x619000107820, trx=0x7f4ac26dc3c0) at /data/bld/10.11-asan/storage/innobase/row/row0merge.cc:5325

#18 0x000055666eedd7cf in trx_t::bulk_insert_apply_low (this=0x7f4ac26dc3c0) at /data/bld/10.11-asan/storage/innobase/row/row0merge.cc:5354

#19 0x000055666eaadbe8 in trx_t::bulk_insert_apply (this=0x7f4ac26dc3c0) at /data/bld/10.11-asan/storage/innobase/include/trx0trx.h:1175

#20 0x000055666ea88883 in ha_innobase::extra (this=0x61d00032aab8, operation=HA_EXTRA_END_ALTER_COPY) at /data/bld/10.11-asan/storage/innobase/handler/ha_innodb.cc:15819

#21 0x000055666da5d6dc in copy_data_between_tables (thd=0x62c0001f0218, from=0x619000104f98, to=0x619000109598, ignore=false, order_num=0, order=0x0, copied=0x7f4abb939030, deleted=0x7f4abb939050, alter_info=0x7f4abb93bf70, alter_ctx=0x7f4abb93b0c0) at /data/bld/10.11-asan/sql/sql_table.cc:12219

#22 0x000055666da55f50 in mysql_alter_table (thd=0x62c0001f0218, new_db=0x62c0001f4fa8, new_name=0x62c0001f5410, create_info=0x7f4abb93c120, table_list=0x6290000fa368, recreate_info=0x7f4abb93beb0, alter_info=0x7f4abb93bf70, order_num=0, order=0x0, ignore=false, if_exists=false) at /data/bld/10.11-asan/sql/sql_table.cc:11372

#23 0x000055666dc1e4e9 in Sql_cmd_alter_table::execute (this=0x6290000faa98, thd=0x62c0001f0218) at /data/bld/10.11-asan/sql/sql_alter.cc:688

#24 0x000055666d759f47 in mysql_execute_command (thd=0x62c0001f0218, is_called_from_prepared_stmt=false) at /data/bld/10.11-asan/sql/sql_parse.cc:6153

#25 0x000055666d766cfe in mysql_parse (thd=0x62c0001f0218, rawbuf=0x6290000fa238 "ALTER TABLE t FORCE, ALGORITHM=COPY", length=35, parser_state=0x7f4abb93da80) at /data/bld/10.11-asan/sql/sql_parse.cc:8174

#26 0x000055666d73c466 in dispatch_command (command=COM_QUERY, thd=0x62c0001f0218, packet=0x629000271219 "", packet_length=35, blocking=true) at /data/bld/10.11-asan/sql/sql_parse.cc:1906

#27 0x000055666d739193 in do_command (thd=0x62c0001f0218, blocking=true) at /data/bld/10.11-asan/sql/sql_parse.cc:1419

#28 0x000055666dbff89b in do_handle_one_connection (connect=0x608000015238, put_in_cache=true) at /data/bld/10.11-asan/sql/sql_connect.cc:1407

#29 0x000055666dbff3fa in handle_one_connection (arg=0x6080000151b8) at /data/bld/10.11-asan/sql/sql_connect.cc:1319

#30 0x000055666e82acf0 in pfs_spawn_thread (arg=0x617000008218) at /data/bld/10.11-asan/storage/perfschema/pfs.cc:2201

#31 0x00007f4aca6a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442

#32 0x00007f4aca72861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

commit cc8eefb0dca1372378905fbae11044f20364c42d

Author: Thirunarayanan Balathandayuthapani

Date:   Tue Jul 30 11:59:01 2024 +0530

    MDEV-33087 ALTER TABLE...ALGORITHM=COPY should build indexes more efficiently