Chris added a comment - 2024-09-18 14:31 Hi Daniel, I see the same issue after upgrading from 10.5.23-0+deb11u1 => 1:10.5.26-0+deb11u1. In my case there is no DISTINCT involved. It´s just a case switch in a view. When I remove the case it works. Still trying to narrow it down. just wanted to let you know that this is obviously a problem for more people. Will comeback if I narrowed it down

Chris added a comment - 2024-09-18 14:55 Hi Daniel, I narrowed it down. I attached the needed table/view definition. databaseScheme.sql When you run the attached query query.sql mariadb crashes. As soon as you replace the case statement in the view with a fixed value it works. Hope it helps to reproduce it

Chris added a comment - 2024-09-18 15:27 Hi Daniel, when I replace the case statement with if(`sb`.`state` = 5, 0, NULL) AS `availability` it works

Daniel Black added a comment - 2024-09-19 00:04 #9138 0x00000000008b7fb2 in Item_func_case_simple::do_build_clone(THD*) const () #9139 0x00000000008b7fb2 in Item_func_case_simple::do_build_clone(THD*) const () #9140 0x00000000008b7fb2 in Item_func_case_simple::do_build_clone(THD*) const () #9141 0x00000000008b7fb2 in Item_func_case_simple::do_build_clone(THD*) const () #9142 0x00000000008b7fb2 in Item_func_case_simple::do_build_clone(THD*) const () #9143 0x00000000008b7fb2 in Item_func_case_simple::do_build_clone(THD*) const () #9144 0x00000000008b7fb2 in Item_func_case_simple::do_build_clone(THD*) const () #9145 0x000000000089c808 in Item_field::derived_field_transformer_for_where(THD*, unsigned char*) () #9146 0x00000000008c77ee in Item_args::transform_args(THD*, Item* (Item::*)(THD*, unsigned char*), unsigned char*) () #9147 0x00000000008c787b in Item_func::transform(THD*, Item* (Item::*)(THD*, unsigned char*), unsigned char*) () #9148 0x00000000006afb34 in transform_condition_or_part(THD*, Item*, Item* (Item::*)(THD*, unsigned char*), unsigned char*) () #9149 0x00000000006cdb2d in st_select_lex::pushdown_cond_into_where_clause(THD*, Item*, Item**, Item* (Item::*)(THD*, unsigned char*), unsigned char*) () #9150 0x00000000006afd9b in pushdown_cond_for_derived(THD*, Item*, TABLE_LIST*) () #9151 0x0000000000703435 in JOIN::optimize_inner() () #9152 0x00000000007011d8 in JOIN::optimize() () #9153 0x00000000006fd41e in 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*) () #9154 0x00000000006fd323 in handle_select(THD*, LEX*, select_result*, unsigned long) () #9155 0x00000000006e1c09 in execute_sqlcom_select(THD*, TABLE_LIST*) () #9156 0x00000000006dcdb9 in mysql_execute_command(THD*, bool) () #9157 0x00000000006d945c in mysql_parse(THD*, char*, unsigned int, Parser_state*) () #9158 0x00000000006d7e7b in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) () #9159 0x00000000006d97a7 in do_command(THD*, bool) () #9160 0x00000000007ade82 in do_handle_one_connection(CONNECT*, bool) () #9161 0x00000000007adce9 in handle_one_connection () #9162 0x0000000000a15c85 in pfs_spawn_thread () #9163 0x00007f09e2aa66d7 in start_thread () from /lib64/libc.so.6 #9164 0x00007f09e2b2a60c in clone3 () from /lib64/libc.so.6

Daniel Black added a comment - 2024-09-19 00:48 Thank you very much for the test case. I can confirm that by using your test case this has already been fixed for the next release.