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

Assertion `0' failed in Item::val_native

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.4(EOL)
    • 10.4.4
    • Data types
    • None

    Description

      create table t1 (d1 timestamp(5));
      insert into t1 values ('2018-10-14 15:31:08');
       
      select lead(d1,1) over(order by d1) from t1;
      

      10.4 10dd290b4b8b8b235c8cf42e10

      mysqld: /10.4/sql/item.h:1330: virtual bool Item::val_native(THD*, Native*): Assertion `0' failed.
      190401 17:59:04 [ERROR] mysqld got signal 6 ;
       
      stdlib/abort.c:91(__GI_abort)[0x7fbf49b6f02a]
      assert/assert.c:92(__assert_fail_base)[0x7fbf49b65bd7]
      /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fbf49b65c82]
      :0(Item::val_native(THD*, Native*))[0x55f17fa82fb5]
      sql/sql_type.cc:8122(Type_handler_timestamp_common::Item_val_native_with_conversion(THD*, Item*, Native*) const)[0x55f1801a4be9]
      sql/sql_type.cc:8166(Timestamp_or_zero_datetime_native_null::Timestamp_or_zero_datetime_native_null(THD*, Item*, bool))[0x55f1801a538e]
      sql/sql_type.cc:3557(Type_handler_timestamp_common::Item_save_in_field(Item*, Field*, bool) const)[0x55f18018ed9a]
      sql/item.cc:6503(Item::save_in_field(Field*, bool))[0x55f1804bd999]
      /10.4/sql/mysqld(_ZN17Item_result_field20save_in_result_fieldEb+0x9e)[0x55f17fbaba30]
      sql/item.h:3179(Item_result_field::save_in_result_field(bool))[0x55f17fe28d8b]
      sql/sql_select.cc:25028(copy_funcs(Item**, THD const*))[0x55f17fe115cb]
      sql/sql_select.cc:21439(end_write(JOIN*, st_join_table*, bool))[0x55f17fe3f994]
      sql/sql_select.cc:28156(AGGR_OP::put_record(bool))[0x55f17fe4ca01]
      sql/sql_select.h:1046(AGGR_OP::put_record())[0x55f17fe05b94]
      sql/sql_select.cc:19738(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x55f17fe04e0d]
      sql/sql_select.cc:19556(do_select(JOIN*, Procedure*))[0x55f17fda0890]
      sql/sql_select.cc:4371(JOIN::exec_inner())[0x55f17fd9e20a]
      sql/sql_select.cc:4154(JOIN::exec())[0x55f17fda1c48]
      sql/sql_select.cc:4587(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55f17fd78ae6]
      sql/sql_select.cc:424(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55f17fcfdbea]
      sql/sql_parse.cc:6602(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55f17fcead26]
      sql/sql_parse.cc:3891(mysql_execute_command(THD*))[0x55f17fd0602c]
      sql/sql_parse.cc:8154(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55f17fcdea58]
      sql/sql_parse.cc:1834(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55f17fcdb997]
      sql/sql_parse.cc:1365(do_command(THD*))[0x55f1800506ab]
      sql/sql_connect.cc:1398(do_handle_one_connection(CONNECT*))[0x55f180050075]
      sql/sql_connect.cc:1302(handle_one_connection)[0x55f1814104b3]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fbf4a9ae6ba]
      x86_64/clone.S:111(clone)[0x7fbf49c3f41d]
      
      

      Attachments

        Activity

          People

            bar Alexander Barkov
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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