Server Crash on COMPRESS and UNCOMPRESS operations

SELECT (('3OEzBckDFjkyU806W' IN (CAST((UNCOMPRESS((COMPRESS('KC5dW')))) AS CHAR(4)), 'cPoctFED6hBW1kdqXfYmNVCW')));

Server version: 12.1.2-MariaDB-ubu2404 source revision: 70117463f032d59f8e328335e19b59157d34cf07

The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/

contains 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: 0x7019c0000c68

stack_bottom = 0x701a18221000 thread_stack 0x49000

Printing to addr2line failed

mariadbd(my_print_stacktrace+0x30)[0x629b00731660]

mariadbd(handle_fatal_signal+0x223)[0x629b0028bcf3]

/lib/x86_64-linux-gnu/libc.so.6(+0x45330)[0x701a1b57a330]

mariadbd(_Z8err_convPcjPKcjPK15charset_info_st+0x31)[0x629afff0ae21]

mariadbd(+0xcb5b91)[0x629b00391b91]

mariadbd(_ZN18Item_char_typecast24val_str_generic_finalizeEP6StringS1_+0x2eb)[0x629b0039202b]

mariadbd(_ZN9in_string3setEjP4Item+0x31)[0x629b002d7c01]

mariadbd(_ZN12Item_func_in13fix_in_vectorEv+0x70)[0x629b002ec820]

mariadbd(_ZNK26Type_handler_string_result44Item_func_in_fix_comparator_compatible_typesEP3THDP12Item_func_in+0x130)[0x629b001c0a90]

mariadbd(_ZN12Item_func_in18fix_length_and_decEP3THD+0x7c)[0x629b002ec6bc]

mariadbd(_ZN9Item_func10fix_fieldsEP3THDPP4Item+0x116)[0x629b00312dd6]

mariadbd(_Z12setup_fieldsP3THD20Bounds_checked_arrayIP4ItemER4ListIS2_E17enum_column_usagePS6_S9_b9THD_WHERE+0x2c9)[0x629affecf569]

mariadbd(_ZN4JOIN7prepareEP10TABLE_LISTP4ItemjP8st_orderbS5_S3_S5_P13st_select_lexP18st_select_lex_unit+0x629)[0x629afffbc829]

mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x876)[0x629afffc2aa6]

mariadbd(_Z13handle_selectP3THDP3LEXP13select_resulty+0x17a)[0x629afffc2e4a]

mariadbd(+0x887121)[0x629afff63121]

mariadbd(_Z21mysql_execute_commandP3THDb+0x3957)[0x629afff6ed47]

mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x19a)[0x629afff7886a]

mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x1064)[0x629afff69664]

mariadbd(_Z10do_commandP3THDb+0x199)[0x629afff6ab89]

mariadbd(_Z24do_handle_one_connectionP7CONNECTb+0x6b3)[0x629b00108aa3]

mariadbd(handle_one_connection+0x71)[0x629b00108ee1]

mariadbd(+0xde029e)[0x629b004bc29e]

/lib/x86_64-linux-gnu/libc.so.6(+0x9caa4)[0x701a1b5d1aa4]

/lib/x86_64-linux-gnu/libc.so.6(__clone+0x44)[0x701a1b65ea64]

Connection ID (thread ID): 3

Status: NOT_KILLED

Query (0x7019c0010d40): SELECT (('3OEzBckDFjkyU806W' IN (CAST((UNCOMPRESS((COMPRESS('KC5dW')))) AS CHAR(4)), 'cPoctFED6hBW1kdqXfYmNVCW')))

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

Writing a core file...

Working directory at /var/lib/mysql

Resource Limits (excludes unlimited resources):

Limit                     Soft Limit           Hard Limit           Units

Max stack size            8388608              unlimited            bytes

Max core file size        0                    unlimited            bytes

Max open files            1048576              1048576              files

Max pending signals       63381                63381                signals

Max msgqueue size         819200               819200               bytes

Max nice priority         0                    0

Max realtime priority     0                    0

Core pattern: |/wsl-capture-crash %t %E %p %s

Kernel version: Linux version 6.6.87.2-microsoft-standard-WSL2 (root@439a258ad544) (gcc (GCC) 11.2.0, GNU ld (GNU Binutils) 2.37) #1 SMP PREEMPT_DYNAMIC Thu Jun  5 18:30:46 UTC 2025