260708 14:56:51 [ERROR] /data/db/vendor/mariadb/server/install-asan/bin/mariadbd got signal 11 ;
Sorry, we probably made a mistake, and this is a bug.

Your assistance in bug reporting will enable us to fix this for the next release.
To report this bug, see https://mariadb.com/docs/general-resources/community/community/bug-tracking/reporting-bugs about how to report
a bug on https://jira.mariadb.org/.

Please include the information from the server start above, to the end of the
information below.

Server version: 13.1.0-MariaDB-asan source revision: 34dd221590eb9d6dbda701031fcf8a84df9821fd

The information page at https://mariadb.com/docs/server/reference/product-development/mariadb-fault-finding/how-to-produce-a-full-stack-trace-for-mariadbdcontains instructions to obtain a better version of the backtrace below.
Following these instructions will help MariaDB developers provide a fix quicker.

Attempting backtrace. Include this in the bug report.
(note: Retrieving this information may fail)

Thread pointer: 0x52c0001d0220
stack_bottom = 0x77c134a54000 thread_stack 0xb00000
sanitizer_common/sanitizer_common_interceptors.inc:4193(__interceptor_backtrace.part.0)[0x7fc155645c0e]
mysys/stacktrace.c:216(my_print_stacktrace)[0x55cb0475614b]
sql/signal_handler.cc:227(handle_fatal_signal)[0x55cb035136f2]
libc_sigaction.c:0(__restore_rt)[0x7fc154842520]
sql/table.h:2708(TABLE_LIST::get_tablenr())[0x55cb02afb3d6]
sql/sql_select.cc:2367(JOIN::optimize_inner())[0x55cb02d988f7]
sql/sql_select.cc:2018(JOIN::optimize())[0x55cb02d9c38c]
sql/sql_derived.cc:1049(mysql_derived_optimize(THD*, LEX*, TABLE_LIST*))[0x55cb02a8196a]
sql/sql_derived.cc:203(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x55cb02a7fd87]
sql/sql_select.cc:2583(JOIN::optimize_inner())[0x55cb02d984c3]
sql/sql_select.cc:2018(JOIN::optimize())[0x55cb02d9c38c]
sql/sql_select.cc:5425(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55cb02d9c724]
sql/sql_select.cc:636(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x55cb02d9e4d5]
sql/sql_parse.cc:4709(mysql_execute_command(THD*, bool))[0x55cb02bc8165]
sql/sql_prepare.cc:5367(Prepared_statement::execute(String*, bool, select_result*, Server_side_cursor**))[0x55cb02c41eff]
sql/sql_prepare.cc:4726(Prepared_statement::execute_loop(String*, bool, select_result*, Server_side_cursor**, InstrSlice const&, unsigned char*, unsigned char*))[0x55cb02c434f5]
sql/sql_prepare.cc:3518(mysql_stmt_execute_common(THD*, unsigned long, unsigned char*, unsigned char*, unsigned long, bool, bool, bool))[0x55cb02c46faa]
sql/sql_prepare.cc:3288(mysqld_stmt_execute(THD*, char*, unsigned int))[0x55cb02c47681]
sql/sql_parse.cc:1830(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55cb02bd40f5]
sql/sql_parse.cc:1439(do_command(THD*, bool))[0x55cb02bd91c6]
sql/sql_connect.cc:1510(do_handle_one_connection(CONNECT*, bool))[0x55cb0303b4ad]
sql/sql_connect.cc:1422(handle_one_connection)[0x55cb0303b88d]
perfschema/pfs.cc:2201(pfs_spawn_thread)[0x55cb03e1b1e9]
nptl/pthread_create.c:442(start_thread)[0x7fc154894ac3]
x86_64/clone3.S:83(__clone3)[0x7fc1549268d0]

Connection ID (thread ID): 6
Status: NOT_KILLED
Query (0x52d0002be3e8): insert into t1298
select 
    (cast(((subq_0.a2 &0xffffffff)+2147483648)&0xffffffff as signed)-2147483648) as a1,
    (lead((cast(((subq_0.a1 &0xffff)+32768)&0xffff as signed)-32768), 84) over (partition by subq_0.a2, subq_0.a4 order by subq_0.a5) + cast(subq_0.a3 as double)) as a2,
    subq_0.a2 as a3,
    cast(? as char) as a4,
    (NOT NOT (subq_0.a3 <=> case when (subq_0.a6 <= (
            select 
                  ? as a1
                from t1388 as ref_5
                where (NOT NOT (cast((((cast(? as char) <> cast(? as char)) &0xff)+128)&0xff as signed)-128))
              union (
                select 
                  ? as a1
                from t1363 as ref_6
                where (NOT NOT (? <= ?))
              )
              limit 1
            )) then cast(subq_0.a5 as decimal) else cast(subq_0.a1 as decimal) end)) as a5,
    cast(? as char) as a6,
    ? as a7,
    subq_0.a5 as a8
  from (select 
          (NOT NOT (? < ?)) as a1,
          (? & ?) as a2,
          cast(stddev_samp(cast(? as double)) over (partition by ref_0.a1, ref_0.a2 order by ref_0.a3) as double) as a3,
          ? as a4,
          ref_0.a3 as a5,
          ? as a6
        from v1396 as ref_0
        where ((? not in (
            select 
                  cast(? as char) as a1
                from v1434 as ref_1
                where (1=1)
              union (
                select 
                  ? as a1
                from t1438 as ref_2
                where (? between ? and ?)
              )
            ))
            and
          (? in (
            select distinct
                  cast(? as double) as a1
                from t1472 as ref_3
                where (1=1)
              union (
                select 
                  ? as a1
                from t1216 as ref_4
                where (? between ? and ?)
              )
              order by a1
            )))) as subq_0
  where (cast(? as char) not like 'xwsp8%sw')

Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,duplicateweedout=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off,hash_join_cardinality=on,cset_narrowing=on,sargable_casefold=on,reorder_outer_joins=off

Writing a core file...
Working directory at /data/nvme3/db/vendor/mariadb/server/asan-runtime/data
Resource Limits (excludes unlimited resources):
Limit                     Soft Limit           Hard Limit           Units     
Max stack size            8388608              unlimited            bytes     
Max core file size        8589934592           8589934592           bytes     
Max processes             2062076              2062076              processes 
Max open files            1048576              1048576              files     
Max locked memory         67581202432          67581202432          bytes     
Max pending signals       2062076              2062076              signals   
Max msgqueue size         819200               819200               bytes     
Max nice priority         0                    0                    
Max realtime priority     0                    0                    
Core pattern: |/usr/local/bin/coredump_handler /var/cores/core-%h-%e-%u-%g-%p-%t-%c - %c

Kernel version: Linux version 6.8.0-124-generic (buildd@lcy02-amd64-109) (x86_64-linux-gnu-gcc-12 (Ubuntu 12.3.0-1ubuntu1~22.04.3) 12.3.0, GNU ld (GNU Binutils for Ubuntu) 2.38) #124~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Tue May 26 21:05:19 UTC