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

Assertion `(m_ptr == __null) == item->null_value' failed in VDec::VDec

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • N/A
    • 11.2
    • None
    • None

    Description

      I could repeat it on preview-11.2-preview 7c7de020b576a42bd381a9, but not on 10.6-11.1 (test is not applicable for 10.4,10.5).

      CREATE TABLE t1 ( i int);
      INSERT INTO t1 VALUES (0), (847708160), (89), (NULL), (-1452802048), (30998528), (NULL), (NULL), (NULL), (5), (NULL), (NULL), (-1504051200), (7), (758710272), (477495296), (3), (956694528), (0), (NULL), (NULL), (NULL), (0), (0), (0), (0); 
       
      SELECT 1 FROM t1 GROUP BY (aes_encrypt((sys_guid()), i)) div 1;
      

      mariadbd: /git/11/sql/sql_type.cc:302: VDec::VDec(Item*): Assertion `(m_ptr == __null) == item->null_value' failed.
      230705 13:26:54 [ERROR] mysqld got signal 6 ;
       
      Server version: 11.2.0-MariaDB-debug-log source revision: 7c7de020b576a42bd381a9060c3076f85da0d9d4
       
      sql/signal_handler.cc:241(handle_fatal_signal)[0x5575fba9d5e6]
      sql/sql_type.cc:302(VDec::VDec(Item*))[0x5575fb81f18c]
      sql/sql_type.h:507(VDec2_lazy::VDec2_lazy(Item*, Item*))[0x5575fbc43f52]
      sql/item_func.cc:1616(Item_func_int_div::val_int())[0x5575fbc08d4d]
      sql/item.cc:6862(Item::save_int_in_field(Field*, bool))[0x5575fbb3049f]
      sql/sql_type.cc:4343(Type_handler_int_result::Item_save_in_field(Item*, Field*, bool) const)[0x5575fb837464]
      sql/item.cc:6872(Item::save_in_field(Field*, bool))[0x5575fbb3068b]
      sql/item.h:3489(Item_result_field::save_in_result_field(bool))[0x5575fae2df32]
      sql/sql_select.cc:28836(copy_funcs(Item**, THD const*))[0x5575fb30ea69]
      sql/sql_select.cc:24966(end_write(JOIN*, st_join_table*, bool))[0x5575fb2f356e]
      sql/sql_select.cc:32242(AGGR_OP::put_record(bool))[0x5575fb328cf9]
      sql/sql_select.h:1180(AGGR_OP::put_record())[0x5575fb33dedb]
      sql/sql_select.cc:23121(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x5575fb2e5db0]
      sql/sql_select.cc:23664(evaluate_join_record(JOIN*, st_join_table*, int))[0x5575fb2e8a93]
      sql/sql_select.cc:23468(sub_select(JOIN*, st_join_table*, bool))[0x5575fb2e7982]
      sql/sql_select.cc:22948(do_select(JOIN*, Procedure*))[0x5575fb2e4c23]
      sql/sql_select.cc:4933(JOIN::exec_inner())[0x5575fb26322d]
      sql/sql_select.cc:4710(JOIN::exec())[0x5575fb2605e4]
      sql/sql_select.cc:5239(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5575fb264d35]
      sql/sql_select.cc:627(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x5575fb2344a9]
      sql/sql_parse.cc:6030(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5575fb1559ca]
      sql/sql_parse.cc:3944(mysql_execute_command(THD*, bool))[0x5575fb1465de]
      sql/sql_parse.cc:7769(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5575fb16080f]
      sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x5575fb138cef]
      sql/sql_parse.cc:1405(do_command(THD*, bool))[0x5575fb135a39]
      sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x5575fb610d17]
      sql/sql_connect.cc:1320(handle_one_connection)[0x5575fb610674]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5575fc28da46]
      nptl/pthread_create.c:478(start_thread)[0x7f4f489da609]
       
      Query (0x6290001092a8): SELECT 1 FROM t1 GROUP BY (aes_encrypt((sys_guid()), i)) div 1
      

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              alice Alice Sherepa
              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.