Assertion `tmp != ((long long) 0x8000000000000000LL)' failed in TIME_from_longlong_datetime_packed on EXPLAIN

INSTALL PLUGIN Spider SONAME 'ha_spider.so';

CREATE USER Spider@localhost IDENTIFIED BY 'PWD123';

CREATE SERVER srv FOREIGN DATA WRAPPER MYSQL OPTIONS (SOCKET '../socket.sock',DATABASE 'test',user 'Spider',PASSWORD 'PWD123');

CREATE TABLE t (c INT) ENGINE=InnoDB;

CREATE TABLE t2 (DATE DATETIME,KEY DATE (DATE)) ENGINE=Spider COMMENT='WRAPPER "mysql",srv "srv",TABLE "t"';

EXPLAIN SELECT 1 FROM DUAL WHERE (0) IN (SELECT * FROM t2);

mariadbd: /test/11.2_dbg/sql/compat56.cc:271: void TIME_from_longlong_datetime_packed(MYSQL_TIME*, longlong): Assertion `tmp != ((long long) 0x8000000000000000LL)' failed.

Core was generated by `/test/MD141024-mariadb-11.2.6-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'.

Program terminated with signal SIGABRT, Aborted.

Download failed: Invalid argument.  Continuing without source file ./nptl/./nptl/pthread_kill.c.

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

[Current thread is 1 (LWP 183160)]

(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  0x0000154490c4526e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26

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

#5  0x0000154490c2881b in __assert_fail_base (fmt=0x154490dd01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x55e54aea0860 "tmp != ((long long) 0x8", '0' <repeats 15 times>, "LL)", file=file@entry=0x55e54aea0650 "/test/11.2_dbg/sql/compat56.cc", line=line@entry=271, function=function@entry=0x55e54aea0820 "void TIME_from_longlong_datetime_packed(MYSQL_TIME*, longlong)") at ./assert/assert.c:94

#6  0x0000154490c3b507 in __assert_fail (assertion=0x55e54aea0860 "tmp != ((long long) 0x8", '0' <repeats 15 times>, "LL)", file=0x55e54aea0650 "/test/11.2_dbg/sql/compat56.cc", line=271, function=0x55e54aea0820 "void TIME_from_longlong_datetime_packed(MYSQL_TIME*, longlong)") at ./assert/assert.c:103

#7  0x000055e54a41a1f0 in TIME_from_longlong_datetime_packed (ltime=ltime@entry=0x154483f66950, tmp=tmp@entry=-9223372036854775808)at /test/11.2_dbg/sql/compat56.cc:271

#8  0x000055e54a428638 in Field_datetimef::get_TIME (this=<optimized out>, ltime=0x154483f66950, pos=0x1544485cb4e1 "", fuzzydate={m_mode = date_mode_t::CONV_NONE})at /test/11.2_dbg/sql/field.cc:7254

#9  0x000055e54a443219 in Field_datetimef::get_date (this=<optimized out>, ltime=<optimized out>, fuzzydate=<optimized out>)at /test/11.2_dbg/sql/field.h:3993

#10 0x000055e54a4206cf in Field_datetime_with_dec::val_str (this=0x1544480fc250, str=0x154483f669c8, unused=<optimized out>)at /test/11.2_dbg/sql/field.cc:7200

#11 0x0000154483ece800 in Field::val_str (str=0x154483f669c8, this=0x1544480fc250) at /test/11.2_dbg/sql/field.h:1053

#12 Field::val_str (new_ptr=0x1544485cb4e1 "", str=0x154483f669c8, this=0x1544480fc250) at /test/11.2_dbg/sql/field.h:1613

#13 spider_db_mysql_util::append_column_value (this=0x154483f1e800 <spider_db_mysql_utility>, spider=<optimized out>, str=0x154448051910, field=0x1544480fc250, new_ptr=0x1544485cb4e1 "", is_like=false, access_charset=0x55e54b8a9a00 <my_charset_latin1>)at /test/11.2_dbg/storage/spider/spd_db_mysql.cc:3528

#14 0x0000154483e66e36 in spider_db_append_key_where_internal (str=0x154448051910, str_part=str_part@entry=0x0, str_part2=str_part2@entry=0x0, start_key=0x154483f67290, end_key=0x0, spider=0x1544480c92f0, set_order=false, sql_type=1, dbton_id=0)at /test/11.2_dbg/storage/spider/spd_db_conn.cc:1680

#15 0x0000154483ed9709 in spider_mbase_handler::append_key_where (this=<optimized out>, str=<optimized out>, str_part=str_part@entry=0x0, str_part2=str_part2@entry=0x0, start_key=<optimized out>, end_key=<optimized out>, sql_type=1, set_order=false)at /test/11.2_dbg/storage/spider/spd_db_mysql.cc:9664

#16 0x0000154483ed9756 in spider_mbase_handler::append_key_where_part (this=<optimized out>, start_key=<optimized out>, end_key=<optimized out>, sql_type=<optimized out>)at /test/11.2_dbg/storage/spider/spd_db_mysql.cc:9648

#17 0x0000154483eb8cd9 in ha_spider::append_key_where_sql_part (this=this@entry=0x1544480c92f0, start_key=start_key@entry=0x154483f67290, end_key=end_key@entry=0x0, sql_type=sql_type@entry=1)at /test/11.2_dbg/storage/spider/ha_spider.cc:9069

#18 0x0000154483e67e1b in spider_db_append_key_where (start_key=start_key@entry=0x154483f67290, end_key=end_key@entry=0x0, spider=spider@entry=0x1544480c92f0)at /test/11.2_dbg/storage/spider/spd_db_conn.cc:1995

#19 0x0000154483eb9925 in ha_spider::index_read_map_internal (this=0x1544480c92f0, buf=0x1544480fc198 "\377\200", key=0x1544485cb4e0 "", keypart_map=1, find_flag=<optimized out>)at /test/11.2_dbg/storage/spider/ha_spider.cc:1480

#20 0x0000154483eb9ba1 in ha_spider::index_read_map (this=0x1544480c92f0, buf=0x1544480fc198 "\377\200", key=<optimized out>, keypart_map=<optimized out>, find_flag=<optimized out>)at /test/11.2_dbg/storage/spider/ha_spider.cc:1585

#21 0x000055e54a458658 in handler::ha_index_read_map (this=0x1544480c92f0, buf=0x1544480fc198 "\377\200", key=0x1544485cb4e0 "", keypart_map=1, find_flag=find_flag@entry=HA_READ_KEY_EXACT)at /test/11.2_dbg/sql/handler.cc:3750

#22 0x000055e54a56425a in subselect_indexsubquery_engine::exec (this=0x1544485cba28) at /test/11.2_dbg/sql/item_subselect.cc:4581

#23 0x000055e54a55c3b8 in Item_subselect::exec (this=this@entry=0x1544480152b0)at /test/11.2_dbg/sql/item_subselect.cc:817

#24 0x000055e54a55f34d in Item_in_subselect::exec (this=0x1544480152b0)at /test/11.2_dbg/sql/item_subselect.cc:999

#25 0x000055e54a559475 in Item_in_subselect::val_bool (this=0x1544480152b0)at /test/11.2_dbg/sql/item_subselect.cc:2015

#26 0x000055e54a01b0ab in Item::val_bool_result (this=<optimized out>)at /test/11.2_dbg/sql/item.h:1817

#27 0x000055e54a4a52e6 in Item_in_optimizer::val_int (this=0x1544485c8b50)at /test/11.2_dbg/sql/item_cmpfunc.cc:1735

#28 0x000055e54a36fa9c in Type_handler_int_result::Item_val_bool (this=<optimized out>, item=<optimized out>)at /test/11.2_dbg/sql/sql_type.cc:5242

#29 0x000055e54a01afde in Item::val_bool (this=0x1544485c8b50)at /test/11.2_dbg/sql/item.h:1721

#30 0x000055e54a185e19 in Item::eval_const_cond (this=0x1544485c8b50)at /test/11.2_dbg/sql/item.h:1728

#31 Item::remove_eq_conds (this=0x1544485c8b50, thd=<optimized out>, cond_value=0x154448016938, top_level_arg=<optimized out>)at /test/11.2_dbg/sql/sql_select.cc:20804

#32 0x000055e54a1892d1 in optimize_cond (join=join@entry=0x154448016598, conds=0x1544485c8b50, join_list=0x1544480138e0, ignore_on_conds=ignore_on_conds@entry=false, cond_value=cond_value@entry=0x154448016938, cond_equal=cond_equal@entry=0x154448016a60, flags=1)at /test/11.2_dbg/sql/sql_select.cc:20346

#33 0x000055e54a1d5f33 in JOIN::optimize_inner (this=this@entry=0x154448016598)at /test/11.2_dbg/sql/sql_select.cc:2416

#34 0x000055e54a1d6eae in JOIN::optimize (this=this@entry=0x154448016598)at /test/11.2_dbg/sql/sql_select.cc:2003

#35 0x000055e54a1d6fce in mysql_select (thd=thd@entry=0x154448000d58, tables=0x0, fields=@0x1544480139e0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x154448013c78, last = 0x154448013c78, elements = 1}, <No data fields>}, conds=0x1544480152b0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2164525828, result=0x154448015ef8, unit=0x1544480052b0, select_lex=0x154448013728)at /test/11.2_dbg/sql/sql_select.cc:5344

#36 0x000055e54a1d7ab9 in mysql_explain_union (thd=thd@entry=0x154448000d58, unit=unit@entry=0x1544480052b0, result=result@entry=0x154448015ef8)at /test/11.2_dbg/sql/sql_select.cc:31266

#37 0x000055e54a135410 in execute_sqlcom_select (thd=thd@entry=0x154448000d58, all_tables=0x154448014348) at /test/11.2_dbg/sql/sql_parse.cc:6116

#38 0x000055e54a1415bc in mysql_execute_command (thd=thd@entry=0x154448000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false)at /test/11.2_dbg/sql/sql_parse.cc:3984

#39 0x000055e54a1482ce in mysql_parse (thd=thd@entry=0x154448000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x154483f682a0)at /test/11.2_dbg/sql/sql_parse.cc:7938

#40 0x000055e54a14a786 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x154448000d58, packet=packet@entry=0x15444800b319 "", packet_length=packet_length@entry=58, blocking=blocking@entry=true)at /test/11.2_dbg/sql/sql_class.h:248

#41 0x000055e54a14c9c2 in do_command (thd=0x154448000d58, blocking=blocking@entry=true) at /test/11.2_dbg/sql/sql_parse.cc:1407

#42 0x000055e54a2b9fe7 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55e54d2702d8, put_in_cache=put_in_cache@entry=true)at /test/11.2_dbg/sql/sql_connect.cc:1439

#43 0x000055e54a2ba2ef in handle_one_connection (arg=arg@entry=0x55e54d2702d8)at /test/11.2_dbg/sql/sql_connect.cc:1341

#44 0x000055e54a701f14 in pfs_spawn_thread (arg=0x55e54d23f428)at /test/11.2_dbg/storage/perfschema/pfs.cc:2201

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

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