Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-25593

Assertion `0' failed in Type_handler_temporal_result::Item_get_date on double EXECUTE

    XMLWordPrintable

Details

    Description

      PREPARE stmt FROM 'SELECT ?';
      EXECUTE stmt USING current_timestamp;
      EXECUTE stmt USING @param1;
      

      or

      PREPARE s FROM 'SELECT ? FROM DUAL';
      EXECUTE s USING current_time;
      EXECUTE s USING DEFAULT;
      

      Leads to:

      10.6.0 8dd35a2507f8d63ca8df9335d2c6072d5c0e3b86 (Debug)

      mysqld: /test/10.6_dbg/sql/sql_type.cc:5098: virtual void Type_handler_temporal_result::Item_get_date(THD*, Item*, Temporal::Warn*, MYSQL_TIME*, date_mode_t) const: Assertion `0' failed.
      

      10.6.0 8dd35a2507f8d63ca8df9335d2c6072d5c0e3b86 (Debug)

      Core was generated by `/test/MD160321-mariadb-10.6.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
          at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      [Current thread is 1 (Thread 0x14d5f4cb9700 (LWP 544198))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x0000560272a27d0b in my_write_core (sig=sig@entry=6) at /test/10.6_dbg/mysys/stacktrace.c:424
      #2  0x00005602721bf313 in handle_fatal_signal (sig=6) at /test/10.6_dbg/sql/signal_handler.cc:331
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x000014d609b22859 in __GI_abort () at abort.c:79
      #6  0x000014d609b22729 in __assert_fail_base (fmt=0x14d609cb8588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x560272d444ac "0", file=0x560272be8668 "/test/10.6_dbg/sql/sql_type.cc", line=5098, function=<optimized out>) at assert.c:92
      #7  0x000014d609b33f36 in __GI___assert_fail (assertion=assertion@entry=0x560272d444ac "0", file=file@entry=0x560272be8668 "/test/10.6_dbg/sql/sql_type.cc", line=line@entry=5098, function=function@entry=0x560272be9338 "virtual void Type_handler_temporal_result::Item_get_date(THD*, Item*, Temporal::Warn*, MYSQL_TIME*, date_mode_t) const") at assert.c:101
      #8  0x00005602720d6762 in Type_handler_temporal_result::Item_get_date (this=<optimized out>, thd=<optimized out>, item=0x14d5bc01f530, warn=<optimized out>, ltime=0x14d5f4cb6c58, fuzzydate=<optimized out>) at /test/10.6_dbg/sql/sql_type.cc:5098
      #9  0x00005602720f0ccd in Type_handler::Item_get_date_with_warn (this=0x5602735019c0 <type_handler_datetime2>, thd=thd@entry=0x14d5bc000db8, item=item@entry=0x14d5bc01f530, ltime=ltime@entry=0x14d5f4cb6c58, fuzzydate=fuzzydate@entry={m_mode = date_mode_t::FRAC_TRUNCATE}) at /test/10.6_dbg/sql/sql_type.cc:5023
      #10 0x00005602721e2889 in Item_param::get_date (this=this@entry=0x14d5bc01f530, thd=0x14d5bc000db8, res=res@entry=0x14d5f4cb6c58, fuzzydate={m_mode = date_mode_t::FRAC_TRUNCATE}) at /test/10.6_dbg/sql/item.cc:4423
      #11 0x00005602720f2135 in Type_handler::Item_send_datetime (this=<optimized out>, item=0x14d5bc01f530, protocol=0x14d5bc0013a0, buf=0x14d5f4cb6c50) at /test/10.6_dbg/sql/sql_basic_types.h:81
      #12 0x0000560272040a9d in Type_handler_datetime_common::Item_send (this=<optimized out>, item=<optimized out>, protocol=<optimized out>, buf=<optimized out>) at /test/10.6_dbg/sql/sql_type.h:6378
      #13 0x0000560271dfecc0 in Item::send (this=0x14d5bc01f530, protocol=0x14d5bc0013a0, buffer=0x14d5f4cb6c50) at /test/10.6_dbg/sql/item.h:1066
      #14 0x0000560271dfc3ca in Protocol::send_result_set_row (this=this@entry=0x14d5bc0013a0, row_items=row_items@entry=0x14d5bc01f1f8) at /test/10.6_dbg/sql/protocol.cc:1331
      #15 0x0000560271e9286b in select_send::send_data (this=0x14d5bc01ff28, items=@0x14d5bc01f1f8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14d5bc01f6f0, last = 0x14d5bc01f6f0, elements = 1}, <No data fields>}) at /test/10.6_dbg/sql/sql_class.cc:3020
      #16 0x0000560271f814e3 in select_result_sink::send_data_with_check (sent=0, u=<optimized out>, items=<optimized out>, this=<optimized out>) at /test/10.6_dbg/sql/sql_class.h:5554
      #17 JOIN::exec_inner (this=this@entry=0x14d5bc013df8) at /test/10.6_dbg/sql/sql_select.cc:4345
      #18 0x0000560271f82540 in JOIN::exec (this=this@entry=0x14d5bc013df8) at /test/10.6_dbg/sql/sql_select.cc:4257
      #19 0x0000560271f80619 in mysql_select (thd=thd@entry=0x14d5bc000db8, tables=0x0, fields=@0x14d5bc01f1f8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14d5bc01f6f0, last = 0x14d5bc01f6f0, elements = 1}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2201171004160, result=0x14d5bc01ff28, unit=0x14d5bc01d550, select_lex=0x14d5bc01f0a8) at /test/10.6_dbg/sql/sql_select.cc:4733
      #20 0x0000560271f808df in handle_select (thd=thd@entry=0x14d5bc000db8, lex=lex@entry=0x14d5bc01d488, result=result@entry=0x14d5bc01ff28, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.6_dbg/sql/sql_select.cc:417
      #21 0x0000560271ef5434 in execute_sqlcom_select (thd=thd@entry=0x14d5bc000db8, all_tables=0x0) at /test/10.6_dbg/sql/sql_parse.cc:6230
      #22 0x0000560271f02046 in mysql_execute_command (thd=0x14d5bc000db8) at /test/10.6_dbg/sql/sql_parse.cc:3926
      #23 0x0000560271f1b5e1 in Prepared_statement::execute (this=this@entry=0x14d5bc01aee8, expanded_query=expanded_query@entry=0x14d5f4cb7de0, open_cursor=open_cursor@entry=false) at /test/10.6_dbg/sql/sql_prepare.cc:5038
      #24 0x0000560271f1b92f in Prepared_statement::execute_loop (this=this@entry=0x14d5bc01aee8, expanded_query=expanded_query@entry=0x14d5f4cb7de0, open_cursor=open_cursor@entry=false, packet=packet@entry=0x0, packet_end=packet_end@entry=0x0) at /test/10.6_dbg/sql/sql_prepare.cc:4500
      #25 0x0000560271f1be66 in mysql_sql_stmt_execute (thd=thd@entry=0x14d5bc000db8) at /test/10.6_dbg/sql/sql_prepare.cc:3577
      #26 0x0000560271f020a6 in mysql_execute_command (thd=thd@entry=0x14d5bc000db8) at /test/10.6_dbg/sql/sql_parse.cc:3942
      #27 0x0000560271eee876 in mysql_parse (thd=thd@entry=0x14d5bc000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14d5f4cb8410) at /test/10.6_dbg/sql/sql_parse.cc:7998
      #28 0x0000560271efd1e7 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14d5bc000db8, packet=packet@entry=0x14d5bc00b359 "", packet_length=packet_length@entry=26, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_class.h:1318
      #29 0x0000560271f005c1 in do_command (thd=0x14d5bc000db8, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_parse.cc:1397
      #30 0x0000560272058178 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5602755db278, put_in_cache=put_in_cache@entry=true) at /test/10.6_dbg/sql/sql_connect.cc:1410
      #31 0x000056027205877d in handle_one_connection (arg=arg@entry=0x5602755db278) at /test/10.6_dbg/sql/sql_connect.cc:1312
      #32 0x0000560272503a5b in pfs_spawn_thread (arg=0x560275523a48) at /test/10.6_dbg/storage/perfschema/pfs.cc:2201
      #33 0x000014d60a030609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #34 0x000014d609c1f293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      10.5.10 031b3dfc22c3d37769d49da902401b26a24f12b4 (Debug)

      mysqld: /test/10.5_dbg/sql/sql_type.cc:5098: virtual void Type_handler_temporal_result::Item_get_date(THD*, Item*, Temporal::Warn*, MYSQL_TIME*, date_mode_t) const: Assertion `0' failed.
      

      10.5.10 031b3dfc22c3d37769d49da902401b26a24f12b4 (Debug)

      Core was generated by `/test/MD160321-mariadb-10.5.10-linux-x86_64-dbg/bin/mysqld --no-defaults --core'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
          at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      [Current thread is 1 (Thread 0x14a9e00b3700 (LWP 544230))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x00005565eedb9f45 in my_write_core (sig=sig@entry=6) at /test/10.5_dbg/mysys/stacktrace.c:424
      #2  0x00005565ee4fcadf in handle_fatal_signal (sig=6) at /test/10.5_dbg/sql/signal_handler.cc:331
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x000014a9f610e859 in __GI_abort () at abort.c:79
      #6  0x000014a9f610e729 in __assert_fail_base (fmt=0x14a9f62a4588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5565ef0d61d6 "0", file=0x5565eef7c0e8 "/test/10.5_dbg/sql/sql_type.cc", line=5098, function=<optimized out>) at assert.c:92
      #7  0x000014a9f611ff36 in __GI___assert_fail (assertion=assertion@entry=0x5565ef0d61d6 "0", file=file@entry=0x5565eef7c0e8 "/test/10.5_dbg/sql/sql_type.cc", line=line@entry=5098, function=function@entry=0x5565eef7cdb8 "virtual void Type_handler_temporal_result::Item_get_date(THD*, Item*, Temporal::Warn*, MYSQL_TIME*, date_mode_t) const") at assert.c:101
      #8  0x00005565ee413994 in Type_handler_temporal_result::Item_get_date (this=<optimized out>, thd=<optimized out>, item=0x14a9b001f5a8, warn=<optimized out>, ltime=0x14a9e00b0c08, fuzzydate=<optimized out>) at /test/10.5_dbg/sql/sql_type.cc:5098
      #9  0x00005565ee42deff in Type_handler::Item_get_date_with_warn (this=0x5565ef899760 <type_handler_datetime2>, thd=thd@entry=0x14a9b0000db8, item=item@entry=0x14a9b001f5a8, ltime=ltime@entry=0x14a9e00b0c08, fuzzydate=fuzzydate@entry={m_mode = date_mode_t::FRAC_TRUNCATE}) at /test/10.5_dbg/sql/sql_type.cc:5023
      #10 0x00005565ee520acb in Item_param::get_date (this=this@entry=0x14a9b001f5a8, thd=0x14a9b0000db8, res=res@entry=0x14a9e00b0c08, fuzzydate={m_mode = date_mode_t::FRAC_TRUNCATE}) at /test/10.5_dbg/sql/item.cc:4423
      #11 0x00005565ee42f367 in Type_handler::Item_send_datetime (this=<optimized out>, item=0x14a9b001f5a8, protocol=0x14a9b0001390, buf=0x14a9e00b0c00) at /test/10.5_dbg/sql/sql_basic_types.h:81
      #12 0x00005565ee379d17 in Type_handler_datetime_common::Item_send (this=<optimized out>, item=<optimized out>, protocol=<optimized out>, buf=<optimized out>) at /test/10.5_dbg/sql/sql_type.h:6378
      #13 0x00005565ee13126a in Item::send (this=0x14a9b001f5a8, protocol=0x14a9b0001390, buffer=0x14a9e00b0c00) at /test/10.5_dbg/sql/item.h:1066
      #14 0x00005565ee12e786 in Protocol::send_result_set_row (this=this@entry=0x14a9b0001390, row_items=row_items@entry=0x14a9b001f270) at /test/10.5_dbg/sql/protocol.cc:1085
      #15 0x00005565ee1c860b in select_send::send_data (this=0x14a9b001ffa0, items=@0x14a9b001f270: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14a9b001f768, last = 0x14a9b001f768, elements = 1}, <No data fields>}) at /test/10.5_dbg/sql/sql_class.cc:3018
      #16 0x00005565ee2ba17b in select_result_sink::send_data_with_check (sent=0, u=<optimized out>, items=<optimized out>, this=<optimized out>) at /test/10.5_dbg/sql/sql_class.h:5328
      #17 JOIN::exec_inner (this=this@entry=0x14a9b0013f38) at /test/10.5_dbg/sql/sql_select.cc:4335
      #18 0x00005565ee2bb1d8 in JOIN::exec (this=this@entry=0x14a9b0013f38) at /test/10.5_dbg/sql/sql_select.cc:4247
      #19 0x00005565ee2b92b1 in mysql_select (thd=thd@entry=0x14a9b0000db8, tables=0x0, fields=@0x14a9b001f270: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14a9b001f768, last = 0x14a9b001f768, elements = 1}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2201171004160, result=0x14a9b001ffa0, unit=0x14a9b001d5e0, select_lex=0x14a9b001f120) at /test/10.5_dbg/sql/sql_select.cc:4723
      #20 0x00005565ee2b9577 in handle_select (thd=thd@entry=0x14a9b0000db8, lex=lex@entry=0x14a9b001d518, result=result@entry=0x14a9b001ffa0, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.5_dbg/sql/sql_select.cc:417
      #21 0x00005565ee22c4cd in execute_sqlcom_select (thd=thd@entry=0x14a9b0000db8, all_tables=0x0) at /test/10.5_dbg/sql/sql_parse.cc:6308
      #22 0x00005565ee239657 in mysql_execute_command (thd=0x14a9b0000db8) at /test/10.5_dbg/sql/sql_parse.cc:4004
      #23 0x00005565ee2536f4 in Prepared_statement::execute (this=this@entry=0x14a9b001af78, expanded_query=expanded_query@entry=0x14a9e00b1d60, open_cursor=open_cursor@entry=false) at /test/10.5_dbg/sql/sql_prepare.cc:5023
      #24 0x00005565ee253a41 in Prepared_statement::execute_loop (this=this@entry=0x14a9b001af78, expanded_query=expanded_query@entry=0x14a9e00b1d60, open_cursor=open_cursor@entry=false, packet=packet@entry=0x0, packet_end=packet_end@entry=0x0) at /test/10.5_dbg/sql/sql_prepare.cc:4486
      #25 0x00005565ee253f78 in mysql_sql_stmt_execute (thd=thd@entry=0x14a9b0000db8) at /test/10.5_dbg/sql/sql_prepare.cc:3568
      #26 0x00005565ee2396b7 in mysql_execute_command (thd=thd@entry=0x14a9b0000db8) at /test/10.5_dbg/sql/sql_parse.cc:4020
      #27 0x00005565ee225611 in mysql_parse (thd=thd@entry=0x14a9b0000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14a9e00b23d0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:8089
      #28 0x00005565ee2344d0 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14a9b0000db8, packet=packet@entry=0x14a9b000b499 "", packet_length=packet_length@entry=26, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_class.h:1257
      #29 0x00005565ee237c33 in do_command (thd=0x14a9b0000db8) at /test/10.5_dbg/sql/sql_parse.cc:1370
      #30 0x00005565ee3921dd in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5565f10687e8, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1410
      #31 0x00005565ee3928e1 in handle_one_connection (arg=arg@entry=0x5565f10687e8) at /test/10.5_dbg/sql/sql_connect.cc:1312
      #32 0x00005565ee84a1b9 in pfs_spawn_thread (arg=0x5565f0f91fc8) at /test/10.5_dbg/storage/perfschema/pfs.cc:2201
      #33 0x000014a9f661c609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #34 0x000014a9f620b293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      10.4.19 1ea6ac3c953f847da033254d5df67f57987a1884 (Debug)

      mysqld: /test/10.4_dbg/sql/sql_type.cc:4614: virtual void Type_handler_temporal_result::Item_get_date(THD*, Item*, Temporal::Warn*, MYSQL_TIME*, date_mode_t) const: Assertion `0' failed.
      

      10.4.19 1ea6ac3c953f847da033254d5df67f57987a1884 (Debug)

      Core was generated by `/test/MD160321-mariadb-10.4.19-linux-x86_64-dbg/bin/mysqld --no-defaults --core'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
          at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      [Current thread is 1 (Thread 0x155024101700 (LWP 546929))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x000055c610176b25 in my_write_core (sig=sig@entry=6) at /test/10.4_dbg/mysys/stacktrace.c:386
      #2  0x000055c60f8772e6 in handle_fatal_signal (sig=6) at /test/10.4_dbg/sql/signal_handler.cc:344
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x0000155039db0859 in __GI_abort () at abort.c:79
      #6  0x0000155039db0729 in __assert_fail_base (fmt=0x155039f46588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55c6103e5304 "0", file=0x55c61029bcc0 "/test/10.4_dbg/sql/sql_type.cc", line=4614, function=<optimized out>) at assert.c:92
      #7  0x0000155039dc1f36 in __GI___assert_fail (assertion=assertion@entry=0x55c6103e5304 "0", file=file@entry=0x55c61029bcc0 "/test/10.4_dbg/sql/sql_type.cc", line=line@entry=4614, function=function@entry=0x55c61029c758 "virtual void Type_handler_temporal_result::Item_get_date(THD*, Item*, Temporal::Warn*, MYSQL_TIME*, date_mode_t) const") at assert.c:101
      #8  0x000055c60f76a58e in Type_handler_temporal_result::Item_get_date (this=<optimized out>, thd=<optimized out>, item=0x154fd0020458, warn=<optimized out>, ltime=0x1550240fc5b8, fuzzydate=<optimized out>) at /test/10.4_dbg/sql/sql_type.cc:4614
      #9  0x000055c60f782d73 in Type_handler::Item_get_date_with_warn (this=0x55c610a825d0 <type_handler_datetime2>, thd=thd@entry=0x154fd0000d90, item=item@entry=0x154fd0020458, ltime=ltime@entry=0x1550240fc5b8, fuzzydate=fuzzydate@entry={m_mode = date_mode_t::FRAC_TRUNCATE}) at /test/10.4_dbg/sql/sql_type.cc:4539
      #10 0x000055c60f899695 in Item_param::get_date (this=this@entry=0x154fd0020458, thd=0x154fd0000d90, res=res@entry=0x1550240fc5b8, fuzzydate={m_mode = date_mode_t::FRAC_TRUNCATE}) at /test/10.4_dbg/sql/item.cc:4353
      #11 0x000055c60f78417f in Type_handler::Item_send_datetime (this=<optimized out>, item=0x154fd0020458, protocol=0x154fd0001368, buf=0x1550240fc5b0) at /test/10.4_dbg/sql/sql_basic_types.h:79
      #12 0x000055c60f78ce8f in Type_handler_datetime_common::Item_send (this=<optimized out>, item=<optimized out>, protocol=<optimized out>, buf=<optimized out>) at /test/10.4_dbg/sql/sql_type.h:5717
      #13 0x000055c60f4aace0 in Item::send (this=0x154fd0020458, protocol=0x154fd0001368, buffer=0x1550240fc5b0) at /test/10.4_dbg/sql/item.h:1042
      #14 0x000055c60f4a8aa8 in Protocol::send_result_set_row (this=this@entry=0x154fd0001368, row_items=row_items@entry=0x154fd0020118) at /test/10.4_dbg/sql/protocol.cc:1037
      #15 0x000055c60f541e41 in select_send::send_data (this=0x154fd0020e48, items=@0x154fd0020118: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x154fd0020618, last = 0x154fd0020618, elements = 1}, <No data fields>}) at /test/10.4_dbg/sql/sql_class.cc:3007
      #16 0x000055c60f6280ab in JOIN::exec_inner (this=this@entry=0x154fd0013478) at /test/10.4_dbg/sql/sql_select.cc:4365
      #17 0x000055c60f6290b6 in JOIN::exec (this=this@entry=0x154fd0013478) at /test/10.4_dbg/sql/sql_select.cc:4269
      #18 0x000055c60f6271d6 in mysql_select (thd=thd@entry=0x154fd0000d90, tables=0x0, wild_num=0, fields=@0x154fd0020118: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x154fd0020618, last = 0x154fd0020618, elements = 1}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x154fd0020e48, unit=0x154fd001e4c0, select_lex=0x154fd001ffd0) at /test/10.4_dbg/sql/sql_select.cc:4707
      #19 0x000055c60f6274ff in handle_select (thd=thd@entry=0x154fd0000d90, lex=lex@entry=0x154fd001e400, result=result@entry=0x154fd0020e48, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.4_dbg/sql/sql_select.cc:410
      #20 0x000055c60f598df2 in execute_sqlcom_select (thd=thd@entry=0x154fd0000d90, all_tables=0x0) at /test/10.4_dbg/sql/sql_parse.cc:6444
      #21 0x000055c60f5a3fc1 in mysql_execute_command (thd=0x154fd0000d90) at /test/10.4_dbg/sql/sql_parse.cc:3963
      #22 0x000055c60f5c930b in Prepared_statement::execute (this=this@entry=0x154fd000c120, expanded_query=expanded_query@entry=0x1550240fea90, open_cursor=open_cursor@entry=false) at /test/10.4_dbg/sql/sql_prepare.cc:4996
      #23 0x000055c60f5c9667 in Prepared_statement::execute_loop (this=this@entry=0x154fd000c120, expanded_query=expanded_query@entry=0x1550240fea90, open_cursor=open_cursor@entry=false, packet=packet@entry=0x0, packet_end=packet_end@entry=0x0) at /test/10.4_dbg/sql/sql_prepare.cc:4465
      #24 0x000055c60f5c9d90 in mysql_sql_stmt_execute (thd=thd@entry=0x154fd0000d90) at /test/10.4_dbg/sql/sql_prepare.cc:3566
      #25 0x000055c60f5a402b in mysql_execute_command (thd=thd@entry=0x154fd0000d90) at /test/10.4_dbg/sql/sql_parse.cc:3979
      #26 0x000055c60f5aeebb in mysql_parse (thd=thd@entry=0x154fd0000d90, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x155024100490, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_parse.cc:7985
      #27 0x000055c60f5b1719 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x154fd0000d90, packet=packet@entry=0x154fd001a351 "", packet_length=packet_length@entry=26, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_class.h:1170
      #28 0x000055c60f5b4f4e in do_command (thd=0x154fd0000d90) at /test/10.4_dbg/sql/sql_parse.cc:1373
      #29 0x000055c60f6ed726 in do_handle_one_connection (connect=connect@entry=0x55c612f31260) at /test/10.4_dbg/sql/sql_connect.cc:1412
      #30 0x000055c60f6ed845 in handle_one_connection (arg=0x55c612f31260) at /test/10.4_dbg/sql/sql_connect.cc:1316
      #31 0x000015503a36d609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #32 0x0000155039ead293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      10.3.29 eb7c5530eccb7d6782077e5562f5a471d2ccbc01 (Debug)

      mysqld: /test/10.3_dbg/sql/sql_type.cc:3351: virtual bool Type_handler_temporal_result::Item_get_date(Item*, MYSQL_TIME*, ulonglong) const: Assertion `0' failed.
      

      10.3.29 eb7c5530eccb7d6782077e5562f5a471d2ccbc01 (Debug)

      Core was generated by `/test/MD160321-mariadb-10.3.29-linux-x86_64-dbg/bin/mysqld --no-defaults --core'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
          at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      [Current thread is 1 (Thread 0x14dc4c096700 (LWP 545893))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x0000558768ac8b86 in my_write_core (sig=sig@entry=6) at /test/10.3_dbg/mysys/stacktrace.c:386
      #2  0x0000558768273b91 in handle_fatal_signal (sig=6) at /test/10.3_dbg/sql/signal_handler.cc:343
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x000014dc4fdd8859 in __GI_abort () at abort.c:79
      #6  0x000014dc4fdd8729 in __assert_fail_base (fmt=0x14dc4ff6e588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x558768ced10a "0", file=0x558768bb4918 "/test/10.3_dbg/sql/sql_type.cc", line=3351, function=<optimized out>) at assert.c:92
      #7  0x000014dc4fde9f36 in __GI___assert_fail (assertion=assertion@entry=0x558768ced10a "0", file=file@entry=0x558768bb4918 "/test/10.3_dbg/sql/sql_type.cc", line=line@entry=3351, function=function@entry=0x558768bb4ae8 "virtual bool Type_handler_temporal_result::Item_get_date(Item*, MYSQL_TIME*, ulonglong) const") at assert.c:101
      #8  0x000055876818c905 in Type_handler_temporal_result::Item_get_date (this=0x5587693252a0 <type_handler_datetime2>, item=0x14dbe801f190, ltime=0x14dc4c0918a8, fuzzydate=<optimized out>) at /test/10.3_dbg/sql/sql_type.cc:3351
      #9  0x000055876828f0af in Item_param::get_date (this=this@entry=0x14dbe801f190, res=res@entry=0x14dc4c0918a8, fuzzydate=0) at /test/10.3_dbg/sql/item.cc:4591
      #10 0x000055876819a216 in Type_handler::Item_send_datetime (this=<optimized out>, item=0x14dbe801f190, protocol=0x14dbe8001348, buf=0x14dc4c0918a0) at /test/10.3_dbg/sql/sql_class.h:4940
      #11 0x000055876819dcb3 in Type_handler_datetime_common::Item_send (this=<optimized out>, item=<optimized out>, protocol=<optimized out>, buf=<optimized out>) at /test/10.3_dbg/sql/sql_type.h:2904
      #12 0x0000558767f002b8 in Item::send (this=0x14dbe801f190, protocol=0x14dbe8001348, buffer=0x14dc4c0918a0) at /test/10.3_dbg/sql/item.h:884
      #13 0x0000558767efdbee in Protocol::send_result_set_row (this=this@entry=0x14dbe8001348, row_items=row_items@entry=0x14dbe801e310) at /test/10.3_dbg/sql/protocol.cc:999
      #14 0x0000558767f90869 in select_send::send_data (this=0x14dbe801f360, items=@0x14dbe801e310: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14dbe801f348, last = 0x14dbe801f348, elements = 1}, <No data fields>}) at /test/10.3_dbg/sql/sql_class.cc:2945
      #15 0x00005587680621e7 in JOIN::exec_inner (this=this@entry=0x14dbe80117c0) at /test/10.3_dbg/sql/sql_select.cc:4010
      #16 0x0000558768062fbe in JOIN::exec (this=this@entry=0x14dbe80117c0) at /test/10.3_dbg/sql/sql_select.cc:3919
      #17 0x00005587680639f9 in mysql_select (thd=thd@entry=0x14dbe8000d90, tables=0x0, wild_num=0, fields=@0x14dbe801e310: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14dbe801f348, last = 0x14dbe801f348, elements = 1}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x14dbe801f360, unit=0x14dbe801da60, select_lex=0x14dbe801e1e8) at /test/10.3_dbg/sql/sql_select.cc:4327
      #18 0x0000558768063ca8 in handle_select (thd=thd@entry=0x14dbe8000d90, lex=lex@entry=0x14dbe801d9a0, result=result@entry=0x14dbe801f360, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.3_dbg/sql/sql_select.cc:370
      #19 0x0000558767fdc555 in execute_sqlcom_select (thd=thd@entry=0x14dbe8000d90, all_tables=0x0) at /test/10.3_dbg/sql/sql_parse.cc:6343
      #20 0x0000558767fe7360 in mysql_execute_command (thd=0x14dbe8000d90) at /test/10.3_dbg/sql/sql_parse.cc:3874
      #21 0x000055876800a73c in Prepared_statement::execute (this=this@entry=0x14dbe800a470, expanded_query=expanded_query@entry=0x14dc4c093c60, open_cursor=open_cursor@entry=false) at /test/10.3_dbg/sql/sql_prepare.cc:5023
      #22 0x000055876800aa97 in Prepared_statement::execute_loop (this=this@entry=0x14dbe800a470, expanded_query=expanded_query@entry=0x14dc4c093c60, open_cursor=open_cursor@entry=false, packet=packet@entry=0x0, packet_end=packet_end@entry=0x0) at /test/10.3_dbg/sql/sql_prepare.cc:4451
      #23 0x000055876800b3bb in mysql_sql_stmt_execute (thd=thd@entry=0x14dbe8000d90) at /test/10.3_dbg/sql/sql_prepare.cc:3543
      #24 0x0000558767fe73c0 in mysql_execute_command (thd=thd@entry=0x14dbe8000d90) at /test/10.3_dbg/sql/sql_parse.cc:3890
      #25 0x0000558767ff14c4 in mysql_parse (thd=thd@entry=0x14dbe8000d90, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14dc4c095540, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.3_dbg/sql/sql_parse.cc:7867
      #26 0x0000558767ff3c32 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14dbe8000d90, packet=packet@entry=0x14dbe80198f1 "", packet_length=packet_length@entry=26, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.3_dbg/sql/sql_class.h:1139
      #27 0x0000558767ff6ddf in do_command (thd=0x14dbe8000d90) at /test/10.3_dbg/sql/sql_parse.cc:1398
      #28 0x000055876811c7db in do_handle_one_connection (connect=connect@entry=0x55876c3dacd0) at /test/10.3_dbg/sql/sql_connect.cc:1403
      #29 0x000055876811ca12 in handle_one_connection (arg=0x55876c3dacd0) at /test/10.3_dbg/sql/sql_connect.cc:1308
      #30 0x000014dc502de609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #31 0x000014dc4fed5293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Bug confirmed present in:
      MariaDB: 10.3.29 (dbg), 10.4.19 (dbg), 10.5.10 (dbg), 10.6.0 (dbg)

      Bug (or feature/syntax) confirmed not present in:
      MariaDB: 10.2.38 (dbg), 10.2.38 (opt), 10.3.29 (opt), 10.4.19 (opt), 10.5.10 (opt), 10.6.0 (opt)

      Attachments

        Activity

          People

            shulga Dmitry Shulga
            ramesh Ramesh Sivaraman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.