lock_release_on_prepare_try() does not release lock if supremum bit is set along with other bits set in lock's bitmap

--source include/have_innodb.inc

SET GLOBAL innodb_stats_persistent=DEFAULT;

CREATE TABLE t ENGINE=InnoDB AS SELECT 1;

XA START 'a';

INSERT INTO mysql.innodb_index_stats SELECT '','' AS table_name,index_name,LAST_UPDATE,stat_name,0 AS stat_value,sample_size,stat_description FROM mysql.innodb_index_stats WHERE table_name='dummy';  # Note the SELECT is empty

INSERT INTO t VALUES (1);

XA END 'a';

XA PREPARE 'a';

mariadbd: /test/10.6_dbg/storage/innobase/lock/lock0lock.cc:5046: bool lock_rec_queue_validate(bool, page_id_t, const rec_t*, const dict_index_t*, const rec_offs*): Assertion `other_lock->is_waiting()' failed.

Core was generated by `/test/MD270923-mariadb-10.6.16-linux-x86_64-dbg/bin/mariadbd --no-defaults --co'.

Program terminated with signal SIGABRT, Aborted.

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=22878682601024)

    at ./nptl/pthread_kill.c:44

[Current thread is 1 (Thread 0x14cedbbfd640 (LWP 3118002))]

(gdb) bt

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=22878682601024) at ./nptl/pthread_kill.c:44

#1  __pthread_kill_internal (signo=6, threadid=22878682601024) at ./nptl/pthread_kill.c:78

#2  __GI___pthread_kill (threadid=22878682601024, signo=signo@entry=6) at ./nptl/pthread_kill.c:89

#3  0x000014cf0de42476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26

#4  0x000014cf0de287f3 in __GI_abort () at ./stdlib/abort.c:79

#5  0x000014cf0de2871b in __assert_fail_base (fmt=0x14cf0dfdd150 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5640babb2f76 "other_lock->is_waiting()", file=0x5640babb3628 "/test/10.6_dbg/storage/innobase/lock/lock0lock.cc", line=5046, function=<optimized out>) at ./assert/assert.c:92

#6  0x000014cf0de39e96 in __GI___assert_fail (assertion=0x5640babb2f76 "other_lock->is_waiting()", file=0x5640babb3628 "/test/10.6_dbg/storage/innobase/lock/lock0lock.cc", line=5046, function=0x5640babb4860 "bool lock_rec_queue_validate(bool, page_id_t, const rec_t*, const dict_index_t*, const rec_offs*)") at ./assert/assert.c:101

#7  0x00005640ba44b2a4 in lock_rec_queue_validate (locked_lock_trx_sys=locked_lock_trx_sys@entry=false, id=id@entry={m_id = 8589934595}, rec=rec@entry=0x14ceec624209 "testtGEN_CLUST_INDEXn_diff_pfx01", index=index@entry=0x14ceb000c0f8, offsets=offsets@entry=0x14cedbbfb100) at /test/10.6_dbg/storage/innobase/lock/lock0lock.cc:5046

#8  0x00005640ba455cd8 in lock_clust_rec_read_check_and_lock (flags=flags@entry=0, block=block@entry=0x14ceec00eba0, rec=rec@entry=0x14ceec624209 "testtGEN_CLUST_INDEXn_diff_pfx01", index=index@entry=0x14ceb000c0f8, offsets=offsets@entry=0x14cedbbfb100, mode=mode@entry=LOCK_S, gap_mode=1024, thr=0x14ceb00102a8) at /test/10.6_dbg/storage/innobase/lock/lock0lock.cc:5890

#9  0x00005640ba502ef4 in row_ins_set_shared_rec_lock (type=type@entry=1024, block=0x14ceec00eba0, rec=rec@entry=0x14ceec624209 "testtGEN_CLUST_INDEXn_diff_pfx01", index=0x14ceb000c0f8, offsets=offsets@entry=0x14cedbbfb100, thr=thr@entry=0x14ceb00102a8) at /test/10.6_dbg/storage/innobase/row/row0ins.cc:1409

#10 0x00005640ba5101cb in row_ins_duplicate_error_in_clust (thr=0x14ceb00102a8, entry=0x14ceb0012a58, cursor=0x14cedbbfadc0, flags=0) at /test/10.6_dbg/storage/innobase/include/btr0cur.h:744

#11 row_ins_clust_index_entry_low (flags=flags@entry=0, mode=<optimized out>, mode@entry=BTR_MODIFY_LEAF, index=index@entry=0x14ceb000c0f8, n_uniq=n_uniq@entry=4, entry=entry@entry=0x14ceb0012a58, n_ext=n_ext@entry=0, thr=<optimized out>) at /test/10.6_dbg/storage/innobase/row/row0ins.cc:2818

#12 0x00005640ba511380 in row_ins_clust_index_entry (index=index@entry=0x14ceb000c0f8, entry=entry@entry=0x14ceb0012a58, thr=thr@entry=0x14ceb00102a8, n_ext=n_ext@entry=0) at /test/10.6_dbg/storage/innobase/row/row0ins.cc:3242

#13 0x00005640ba512b67 in row_ins_index_entry (thr=0x14ceb00102a8, entry=0x14ceb0012a58, index=0x14ceb000c0f8) at /test/10.6_dbg/storage/innobase/row/row0ins.cc:3368

#14 row_ins_index_entry_step (thr=0x14ceb00102a8, node=0x14ceb000fff0) at /test/10.6_dbg/storage/innobase/row/row0ins.cc:3536

#15 row_ins (thr=0x14ceb00102a8, node=0x14ceb000fff0) at /test/10.6_dbg/storage/innobase/row/row0ins.cc:3661

#16 row_ins_step (thr=thr@entry=0x14ceb00102a8) at /test/10.6_dbg/storage/innobase/row/row0ins.cc:3790

#17 0x00005640ba4d2dda in que_thr_step (thr=0x14ceb00102a8) at /test/10.6_dbg/storage/innobase/que/que0que.cc:567

#18 que_run_threads_low (thr=0x14ceb00102a8) at /test/10.6_dbg/storage/innobase/que/que0que.cc:644

#19 que_run_threads (thr=0x14ceb00102a8) at /test/10.6_dbg/storage/innobase/que/que0que.cc:664

#20 0x00005640ba4d3391 in que_eval_sql (info=info@entry=0x14ceb0012618, sql=sql@entry=0x5640bac09718 "PROCEDURE INDEX_STATS_SAVE () IS\nBEGIN\nDELETE FROM \"mysql/innodb_index_stats\"\nWHERE\ndatabase_name = :database_name AND\ntable_name = :table_name AND\nindex_name = :index_name AND\nstat_name = :stat_name;"..., trx=trx@entry=0x14cf04822680) at /test/10.6_dbg/storage/innobase/que/que0que.cc:703

#21 0x00005640ba6aecf8 in dict_stats_exec_sql (pinfo=pinfo@entry=0x14ceb0012618, sql=sql@entry=0x5640bac09718 "PROCEDURE INDEX_STATS_SAVE () IS\nBEGIN\nDELETE FROM \"mysql/innodb_index_stats\"\nWHERE\ndatabase_name = :database_name AND\ntable_name = :table_name AND\nindex_name = :index_name AND\nstat_name = :stat_name;"..., trx=trx@entry=0x14cf04822680) at /test/10.6_dbg/storage/innobase/dict/dict0stats.cc:548

#22 0x00005640ba6af421 in dict_stats_save_index_stat (index=index@entry=0x14ceb000d868, last_update=last_update@entry=1696488608, stat_name=<optimized out>, stat_name@entry=0x14cedbbfc120 "n_diff_pfx01", stat_value=2, sample_size=0x14ceb000da50, stat_description=stat_description@entry=0x14cedbbfc2d0 "DB_ROW_ID", trx=0x14cf04822680) at /test/10.6_dbg/storage/innobase/dict/dict0stats.cc:3156

#23 0x00005640ba6b3ae0 in dict_stats_save (table_orig=table_orig@entry=0x14ce9801eb08, only_for_index=only_for_index@entry=0x0) at /test/10.6_dbg/storage/innobase/dict/dict0stats.cc:3425

#24 0x00005640ba6b666b in dict_stats_update (table=table@entry=0x14ce9801eb08, stats_upd_option=stats_upd_option@entry=DICT_STATS_RECALC_PERSISTENT) at /test/10.6_dbg/storage/innobase/dict/dict0stats.cc:4087

#25 0x00005640ba6b9abc in dict_stats_process_entry_from_recalc_pool (thd=0x14ceb0003848) at /test/10.6_dbg/storage/innobase/dict/dict0stats_bg.cc:343

#26 dict_stats_func () at /test/10.6_dbg/storage/innobase/dict/dict0stats_bg.cc:382

#27 0x00005640ba746269 in tpool::thread_pool_generic::timer_generic::run (this=0x5640bcac47e0) at /test/10.6_dbg/tpool/tpool_generic.cc:343

#28 tpool::thread_pool_generic::timer_generic::execute (arg=0x5640bcac47e0) at /test/10.6_dbg/tpool/tpool_generic.cc:363

#29 0x00005640ba747126 in tpool::task::execute (this=0x5640bcac4820) at /test/10.6_dbg/tpool/task.cc:37

#30 0x00005640ba744cee in tpool::thread_pool_generic::worker_main (this=0x5640bc7350f0, thread_var=0x5640bc735920) at /test/10.6_dbg/tpool/tpool_generic.cc:580

#31 0x00005640ba7460be in std::__invoke_impl<void, void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> (__t=<optimized out>, __f=<optimized out>) at /usr/include/c++/11/bits/invoke.h:74

#32 std::__invoke<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> (__fn=<optimized out>) at /usr/include/c++/11/bits/invoke.h:96

#33 std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::_M_invoke<0ul, 1ul, 2ul> (this=<optimized out>) at /usr/include/c++/11/bits/std_thread.h:259

#34 std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> >::operator() (this=<optimized out>) at /usr/include/c++/11/bits/std_thread.h:266

#35 std::thread::_State_impl<std::thread::_Invoker<std::tuple<void (tpool::thread_pool_generic::*)(tpool::worker_data*), tpool::thread_pool_generic*, tpool::worker_data*> > >::_M_run (this=<optimized out>) at /usr/include/c++/11/bits/std_thread.h:211

#36 0x000014cf0e2dc253 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6

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

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