Assertion 0 fails in handler::index_type() when executing SHOW INDEX on an indexed DuckDB table.

INSTALL SONAME 'ha_duckdb';

CREATE TABLE t (a INT PRIMARY KEY) ENGINE=DuckDB;

SHOW INDEX FROM t;

mariadbd: /test/11.4_dbg/sql/handler.h:4048: virtual const char *handler::index_type(uint): Assertion `0' failed.

Core was generated by `/test/MD061026-mariadb-11.4.13-linux-x86_64-dbg/bin/mariadbd --no-defaults --lo'.

Program terminated with signal SIGABRT, Aborted.

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

[Current thread is 1 (LWP 925400)]

(gdb) bt

#0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

#1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78

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

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

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

#5  0x00007d51e062881b in __assert_fail_base (fmt=0x7d51e07d1208 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x7550fa7c5a1a "0", file=file@entry=0x7550fa7798c5 "/test/11.4_dbg/sql/handler.h", line=line@entry=4048, function=function@entry=0x7550fa77a13a "virtual const char *handler::index_type(uint)") at ./assert/assert.c:96

#6  0x00007d51e063b517 in __assert_fail (assertion=0x7550fa7c5a1a "0", file=0x7550fa7798c5 "/test/11.4_dbg/sql/handler.h", line=4048, function=0x7550fa77a13a "virtual const char *handler::index_type(uint)")at ./assert/assert.c:105

#7  0x00007550f73dfc7e in handler::index_type (this=0x7550fc2fdf38, key_number=0) at /test/11.4_dbg/sql/handler.h:4048

#8  0x000059ced97b201e in get_schema_stat_record (thd=0x7550fc000d58, tables=0x7550fc020438, table=0x7550fc2f3710, res=false, db_name=0x7550fc01a198, table_name=0x7550fc01a1a8)at /test/11.4_dbg/sql/sql_show.cc:7306

#9  0x000059ced97a075f in fill_schema_table_by_open (thd=0x7550fc000d58, mem_root=0x7550fc006cb0, is_show_fields_or_keys=true, table=0x7550fc2f3710, schema_table=0x59cedb051880 <schema_tables+2368>, orig_db_name=0x7550fc01a198, orig_table_name=0x7550fc01a1a8, open_tables_state_backup=0x7d51b38d7ed0, can_deadlock=false)at /test/11.4_dbg/sql/sql_show.cc:4862

#10 0x000059ced979f1ea in get_all_tables (thd=0x7550fc000d58, tables=0x7550fc01bb38, cond=0x0) at /test/11.4_dbg/sql/sql_show.cc:5418

#11 0x000059ced97ad02a in get_schema_tables_result (join=0x7550fc01cd18, executed_place=PROCESSED_BY_JOIN_EXEC)at /test/11.4_dbg/sql/sql_show.cc:9473

#12 0x000059ced9746d18 in JOIN::exec_inner (this=0x7550fc01cd18)at /test/11.4_dbg/sql/sql_select.cc:5066

#13 0x000059ced97461d0 in JOIN::exec (this=0x7550fc01cd18)at /test/11.4_dbg/sql/sql_select.cc:4893

#14 0x000059ced9720f1c in mysql_select (thd=0x7550fc000d58, tables=0x7550fc01bb38, fields=@0x7550fc005b18: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7550fc01a9e8, last = 0x7550fc01baf0, elements = 14}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2701396736, result=0x7550fc01ccf0, unit=0x7550fc005018, select_lex=0x7550fc005860) at /test/11.4_dbg/sql/sql_select.cc:5416

#15 0x000059ced9720995 in handle_select (thd=0x7550fc000d58, lex=0x7550fc004f38, result=0x7550fc01ccf0, setup_tables_done_option=0)at /test/11.4_dbg/sql/sql_select.cc:643

#16 0x000059ced96c6a21 in execute_sqlcom_select (thd=0x7550fc000d58, all_tables=0x7550fc01bb38) at /test/11.4_dbg/sql/sql_parse.cc:6209

#17 0x000059ced96bbaa2 in mysql_execute_command (thd=0x7550fc000d58, is_called_from_prepared_stmt=false) at /test/11.4_dbg/sql/sql_parse.cc:4002

#18 0x000059ced96b3bc4 in mysql_parse (thd=0x7550fc000d58, rawbuf=0x7550fc019bf0 "SHOW INDEX FROM t", length=17, parser_state=0x7d51b38dab30) at /test/11.4_dbg/sql/sql_parse.cc:7928

#19 0x000059ced96b1089 in dispatch_command (command=COM_QUERY, thd=0x7550fc000d58, packet=0x7550fc00afe9 "SHOW INDEX FROM t", packet_length=17, blocking=true) at /test/11.4_dbg/sql/sql_parse.cc:1925

#20 0x000059ced96b4773 in do_command (thd=0x7550fc000d58, blocking=true)at /test/11.4_dbg/sql/sql_parse.cc:1433

#21 0x000059ced989ce79 in do_handle_one_connection (connect=0x59ceeb875348, put_in_cache=true) at /test/11.4_dbg/sql/sql_connect.cc:1508

#22 0x000059ced989cc12 in handle_one_connection (arg=0x59ceeb86b508)at /test/11.4_dbg/sql/sql_connect.cc:1420

#23 0x00007d51e069cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447

#24 0x00007d51e0729ecc in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

    Rel    o/d  Build   Commit                                    UniqueID observed             

CS  10.11  dbg  061026  76ed5b7ea0c9cddfe9386aee4a5ff42a2adf1593  No bug found                  

CS  10.11  opt  061026  76ed5b7ea0c9cddfe9386aee4a5ff42a2adf1593  No bug found                  

CS  11.4   dbg  061026  b6398296aeeeb253bdb3d1dd1620d2bb03836bf7  0|SIGABRT|handler::index_type|get_schema_stat_record|fill_schema_table_by_open|get_all_tables

CS  11.4   opt  061026  b6398296aeeeb253bdb3d1dd1620d2bb03836bf7  No bug found                  

CS  11.8   dbg  061026  dddbd5ff427894941fee3d7528ca2058e026b82e  No bug found                  

CS  11.8   opt  061026  dddbd5ff427894941fee3d7528ca2058e026b82e  No bug found                  

CS  12.3   dbg  061026  07b869588831fb9ebc6364c77cba105d6cca3b77  No bug found                  

CS  12.3   opt  061026  07b869588831fb9ebc6364c77cba105d6cca3b77  No bug found                  

CS  13.0   dbg  061026  620a4b5624222048fece7fe1789978ae0675cae2  No bug found                  

CS  13.0   opt  061026  620a4b5624222048fece7fe1789978ae0675cae2  No bug found                  

CS  13.1   dbg  061026  87e62ca17270e163a6d41b3fc8d6f4d440f1bb88  No bug found                  

CS  13.1   opt  061026  87e62ca17270e163a6d41b3fc8d6f4d440f1bb88  No bug found                  

CS  13.2   dbg  061026  9d7ab2c0092df4bc73b64b915464aecf7e5fe6c4  No bug found                  

CS  13.2   opt  061026  9d7ab2c0092df4bc73b64b915464aecf7e5fe6c4  No bug found                  

ES  11.4   dbg  060526  90f707057d44f1b5c013a0c3672fd12f32ea7085  No bug found                  

ES  11.4   opt  060526  90f707057d44f1b5c013a0c3672fd12f32ea7085  No bug found                  

ES  11.8   dbg  060526  1499789de285a8109d68d79347de0281865b28f4  No bug found                  

ES  11.8   opt  060526  1499789de285a8109d68d79347de0281865b28f4  No bug found                  

ES  12.3   dbg  280926  082387a5f3cbb877157998bb4baa95928f4aa121  No bug found                  

ES  12.3   opt  280926  082387a5f3cbb877157998bb4baa95928f4aa121  No bug found