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

Assertion `!field->is_null()' failed in my_decimal::my_decimal

    XMLWordPrintable

Details

    Description

      Reproducible on 10.4-10.5, with MyIsam, not with InnoDB, with empty table t1.

      create table t1 (a1 int, a2 decimal(10,0) not null) engine=myisam;
      select min(1 mod a1), bit_or(a2) over () from t1;
      

      10.4 ea7830eef48333e28f98a9

      #3  <signal handler called>
      #4  0x00007f75bc066428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
      #5  0x00007f75bc06802a in __GI_abort () at abort.c:89
      #6  0x00007f75bc05ebd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x55b47e2f8ab5 "!field->is_null()", file=file@entry=0x55b47e2f8a38 "/10.4/sql/my_decimal.cc", line=line@entry=382, function=function@entry=0x55b47e2f8c10 <my_decimal::my_decimal(Field*)::__PRETTY_FUNCTION__> "my_decimal::my_decimal(Field*)") at assert.c:92
      #7  0x00007f75bc05ec82 in __GI___assert_fail (assertion=0x55b47e2f8ab5 "!field->is_null()", file=0x55b47e2f8a38 "/10.4/sql/my_decimal.cc", line=382, function=0x55b47e2f8c10 <my_decimal::my_decimal(Field*)::__PRETTY_FUNCTION__> "my_decimal::my_decimal(Field*)") at assert.c:101
      #8  0x000055b47d8df4f3 in my_decimal::my_decimal (this=0x7f75b45b90c0, field=0x7f756419eb30) at /10.4/sql/my_decimal.cc:382
      #9  0x000055b47d756d82 in Field::do_field_decimal (copy=0x7f7564017870) at /10.4/sql/field_conv.cc:416
      #10 0x000055b47d495b64 in copy_fields (param=0x7f75640177d0) at /10.4/sql/sql_select.cc:25029
      #11 0x000055b47d48d65c in end_write (join=0x7f7564015170, join_tab=0x7f7564017428, end_of_records=false) at /10.4/sql/sql_select.cc:21786
      #12 0x000055b47d4a0868 in AGGR_OP::put_record (this=0x7f7564017ac8, end_of_records=false) at /10.4/sql/sql_select.cc:28596
      #13 0x000055b47d4a64f1 in AGGR_OP::put_record (this=0x7f7564017ac8) at /10.4/sql/sql_select.h:1046
      #14 0x000055b47d48954a in sub_select_postjoin_aggr (join=0x7f7564015170, join_tab=0x7f7564017428, end_of_records=false) at /10.4/sql/sql_select.cc:20086
      #15 0x000055b47d488f38 in do_select (join=0x7f7564015170, procedure=0x0) at /10.4/sql/sql_select.cc:19904
      #16 0x000055b47d45dbf9 in JOIN::exec_inner (this=0x7f7564015170) at /10.4/sql/sql_select.cc:4459
      #17 0x000055b47d45cd36 in JOIN::exec (this=0x7f7564015170) at /10.4/sql/sql_select.cc:4241
      #18 0x000055b47d45e44b in mysql_select (thd=0x7f7564000af0, tables=0x7f7564014108, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f7564015148, unit=0x7f7564004a18, select_lex=0x7f7564013260) at /10.4/sql/sql_select.cc:4673
      #19 0x000055b47d44dee4 in handle_select (thd=0x7f7564000af0, lex=0x7f7564004958, result=0x7f7564015148, setup_tables_done_option=0) at /10.4/sql/sql_select.cc:422
      #20 0x000055b47d4147ac in execute_sqlcom_select (thd=0x7f7564000af0, all_tables=0x7f7564014108) at /10.4/sql/sql_parse.cc:6359
      #21 0x000055b47d40ae98 in mysql_execute_command (thd=0x7f7564000af0) at /10.4/sql/sql_parse.cc:3898
      #22 0x000055b47d41878d in mysql_parse (thd=0x7f7564000af0, rawbuf=0x7f7564013198 "select min(1 mod a1), bit_or(a2) over () from t1", length=48, parser_state=0x7f75b45ba3f0, is_com_multi=false, is_next_command=false) at /10.4/sql/sql_parse.cc:7900
      #23 0x000055b47d404d2d in dispatch_command (command=COM_QUERY, thd=0x7f7564000af0, packet=0x7f75641372a1 "", packet_length=48, is_com_multi=false, is_next_command=false) at /10.4/sql/sql_parse.cc:1842
      #24 0x000055b47d4034a3 in do_command (thd=0x7f7564000af0) at /10.4/sql/sql_parse.cc:1360
      #25 0x000055b47d58c3fe in do_handle_one_connection (connect=0x55b48080e9d0) at /10.4/sql/sql_connect.cc:1412
      #26 0x000055b47d58c127 in handle_one_connection (arg=0x55b48080e9d0) at /10.4/sql/sql_connect.cc:1316
      #27 0x000055b47df8d87d in pfs_spawn_thread (arg=0x55b48077dc80) at /10.4/storage/perfschema/pfs.cc:1869
      #28 0x00007f75bd5556ba in start_thread (arg=0x7f75b45bb700) at pthread_create.c:333
      #29 0x00007f75bc13841d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
      

      No visible effect on non-debug build

      Attachments

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.