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

Assertion `maybe_null || !null_value' failed in Item_func_round::time_op

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5, 10.4(EOL)
    • 10.5
    • Temporal Types
    • None

    Description

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (a time not null) engine=innodb;
      SELECT STD(0) FROM t1 ORDER BY ROUND(a);
       
      DROP TABLE t1;
      

      10.4 5a42a114fdc9cacb6e64

      #6  0x00007fabaf624bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x55d698342fe0 "maybe_null || !null_value", file=file@entry=0x55d698342c40 "/10.4/sql/item_func.cc", line=line@entry=2552, function=function@entry=0x55d698344a40 <Item_func_round::time_op(THD*, st_mysql_time*)::__PRETTY_FUNCTION__> "virtual bool Item_func_round::time_op(THD*, MYSQL_TIME*)") at assert.c:92
      #7  0x00007fabaf624c82 in __GI___assert_fail (assertion=0x55d698342fe0 "maybe_null || !null_value", file=0x55d698342c40 "/10.4/sql/item_func.cc", line=2552, function=0x55d698344a40 <Item_func_round::time_op(THD*, st_mysql_time*)::__PRETTY_FUNCTION__> "virtual bool Item_func_round::time_op(THD*, MYSQL_TIME*)") at assert.c:101
      #8  0x000055d69781513a in Item_func_round::time_op (this=0x7fab54102c40, thd=0x7fab54000a88, to=0x7faba837e9c0) at /10.4/sql/item_func.cc:2552
      #9  0x000055d697825d8f in Item_func_hybrid_field_type::time_op_with_null_check (this=0x7fab54102c40, thd=0x7fab54000a88, ltime=0x7faba837e9c0) at /10.4/sql/item_func.h:681
      #10 0x000055d69780e089 in Item_func_hybrid_field_type::val_str_from_time_op (this=0x7fab54102c40, str=0x7fab5404df20) at /10.4/sql/item_func.cc:903
      #11 0x000055d69763a4cb in Type_handler_time_common::Item_func_hybrid_field_type_val_str (this=0x55d698c60c30 <type_handler_time2>, item=0x7fab54102c40, str=0x7fab5404df20) at /10.4/sql/sql_type.cc:4879
      #12 0x000055d6973f0fee in Item_func_hybrid_field_type::val_str (this=0x7fab54102c40, str=0x7fab5404df20) at /10.4/sql/item_func.h:769
      #13 0x000055d6977ab550 in Item_copy_string::copy (this=0x7fab5404def0) at /10.4/sql/item.cc:4837
      #14 0x000055d69749ade5 in copy_fields (param=0x7fab5404c090) at /10.4/sql/sql_select.cc:25006
      #15 0x000055d69749d7b4 in JOIN::clear (this=0x7fab5404be70) at /10.4/sql/sql_select.cc:25970
      #16 0x000055d6974923b8 in end_send_group (join=0x7fab5404be70, join_tab=0x7fab5404d718, end_of_records=true) at /10.4/sql/sql_select.cc:21664
      #17 0x000055d69748e9d4 in sub_select (join=0x7fab5404be70, join_tab=0x7fab5404d370, end_of_records=true) at /10.4/sql/sql_select.cc:20287
      #18 0x000055d69748e0f6 in do_select (join=0x7fab5404be70, procedure=0x0) at /10.4/sql/sql_select.cc:19878
      #19 0x000055d697462c38 in JOIN::exec_inner (this=0x7fab5404be70) at /10.4/sql/sql_select.cc:4452
      #20 0x000055d697461d72 in JOIN::exec (this=0x7fab5404be70) at /10.4/sql/sql_select.cc:4234
      #21 0x000055d697463489 in mysql_select (thd=0x7fab54000a88, tables=0x7fab540f6510, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x7fab540fdd70, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fab540f10a0, unit=0x7fab540049c8, select_lex=0x7fab540382e0) at /10.4/sql/sql_select.cc:4666
      #22 0x000055d697452dee in handle_select (thd=0x7fab54000a88, lex=0x7fab54004908, result=0x7fab540f10a0, setup_tables_done_option=0) at /10.4/sql/sql_select.cc:420
      #23 0x000055d697418771 in execute_sqlcom_select (thd=0x7fab54000a88, all_tables=0x7fab540f6510) at /10.4/sql/sql_parse.cc:6359
      #24 0x000055d69740dd7e in mysql_execute_command (thd=0x7fab54000a88) at /10.4/sql/sql_parse.cc:3898
      #25 0x000055d69741c8b3 in mysql_parse (thd=0x7fab54000a88, rawbuf=0x7fab5417c010 "SELECT STD(0) FROM t1 ORDER BY ROUND(a)", length=39, parser_state=0x7faba837ffd0, is_com_multi=false, is_next_command=false) at /10.4/sql/sql_parse.cc:7900
      #26 0x000055d69740794e in dispatch_command (command=COM_QUERY, thd=0x7fab54000a88, packet=0x7fab54007bc9 "", packet_length=39, is_com_multi=false, is_next_command=false) at /10.4/sql/sql_parse.cc:1842
      #27 0x000055d697405faf in do_command (thd=0x7fab54000a88) at /10.4/sql/sql_parse.cc:1360
      #28 0x000055d6975964e3 in do_handle_one_connection (connect=0x55d69a677978) at /10.4/sql/sql_connect.cc:1412
      #29 0x000055d69759620c in handle_one_connection (arg=0x55d69a677978) at /10.4/sql/sql_connect.cc:1316
      #30 0x000055d697ff3955 in pfs_spawn_thread (arg=0x55d69a60bbe8) at /10.4/storage/perfschema/pfs.cc:1869
      #31 0x00007fabb0b1b6ba in start_thread (arg=0x7faba8381700) at pthread_create.c:333
      #32 0x00007fabaf6fe41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
      

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.