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

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

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • N/A
    • 11.2(EOL)
    • 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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31284 SIGSEGV in VDec2_lazy::VDec2_lazy | Item_func_plus::decimal_op

          • Critical - Crashes, loss of data, severe memory leak.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31633 Assertion `!item->null_value' failed in Type_handler::Item_send_str

          • Major - Major loss of function.
          • Closed

          Activity

            alice Alice Sherepa added a comment - 

             
            CREATE TABLE  t1 ( id varchar(1));
            		 
            INSERT INTO  t1 VALUES (NULL), (NULL), ('a'), ('c'), ('d'), ('d'), ('d'), ('f'), ('g'), ('h'), ('l'), ('m'), ('m'), ('o'), ('o'), ('u'), ('v'), ('w'), ('x'), ('y');
            		 
             
            		 
            SELECT ( AES_ENCRYPT(  id,  id ) ) ^ 'i' from t1 ;


            mariadbd: 11/sql/sql_type.cc:302: VDec::VDec(Item*): Assertion `(m_ptr == __null) == item->null_value' failed.
            		 
            230705 17:39:05 [ERROR] mysqld got signal 6 ;
            		 
             
            		 
            Server version: 11.2.0-MariaDB-debug-log source revision: 7c7de020b576a42bd381a9060c3076f85da0d9d4
            		 
             
            		 
            sql/sql_type.cc:302(VDec::VDec(Item*))[0x562b66e8f18c]
            		 
            sql/item_func.cc:6491(Func_handler_bit_xor_dec_to_ulonglong::to_longlong_null(Item_handled_func*) const)[0x562b672c3e67]
            		 
            sql/item_func.h:696(Item_handled_func::Handler_int::val_int(Item_handled_func*) const)[0x562b67228cf9]
            		 
            sql/item_func.h:784(Item_handled_func::val_int())[0x562b66ed97c7]
            		 
            sql/sql_type.cc:7488(Type_handler::Item_send_longlong(Item*, Protocol*, st_value*) const)[0x562b66eb7044]
            		 
            sql/sql_type.h:5761(Type_handler_longlong::Item_send(Item*, Protocol*, st_value*) const)[0x562b66ed3700]
            		 
            sql/item.h:1236(Item::send(Protocol*, st_value*))[0x562b6640abc8]
            		 
            sql/protocol.cc:1332(Protocol::send_result_set_row(List<Item>*))[0x562b664cad6f]
            		 
            sql/sql_class.cc:3125(select_send::send_data(List<Item>&))[0x562b6666fbca]
            		 
            sql/sql_class.h:5756(select_result_sink::send_data_with_check(List<Item>&, st_select_lex_unit*, unsigned long long))[0x562b669aabb9]
            		 
            sql/sql_select.cc:24697(end_send(JOIN*, st_join_table*, bool))[0x562b66960cac]
            		 
            sql/sql_select.cc:23664(evaluate_join_record(JOIN*, st_join_table*, int))[0x562b66958a93]
            		 
            sql/sql_select.cc:23468(sub_select(JOIN*, st_join_table*, bool))[0x562b66957982]
            		 
            sql/sql_select.cc:22948(do_select(JOIN*, Procedure*))[0x562b66954c23]
            		 
            sql/sql_select.cc:4933(JOIN::exec_inner())[0x562b668d322d]
            		 
            sql/sql_select.cc:4710(JOIN::exec())[0x562b668d05e4]
            		 
            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*))[0x562b668d4d35]
            		 
            sql/sql_select.cc:627(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x562b668a44a9]
            		 
            sql/sql_parse.cc:6030(execute_sqlcom_select(THD*, TABLE_LIST*))[0x562b667c59ca]
            		 
            sql/sql_parse.cc:3944(mysql_execute_command(THD*, bool))[0x562b667b65de]
            		 
            sql/sql_parse.cc:7769(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x562b667d080f]
            		 
            sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x562b667a8cef]
            		 
            sql/sql_parse.cc:1405(do_command(THD*, bool))[0x562b667a5a39]
            		 
            sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x562b66c80d17]
            		 
            sql/sql_connect.cc:1320(handle_one_connection)[0x562b66c80674]
            		 
            perfschema/pfs.cc:2203(pfs_spawn_thread)[0x562b678fda46]
            		 
            nptl/pthread_create.c:478(start_thread)[0x7f4454218609]
            		 
             
            		 
            Query (0x6290001092a8): SELECT ( AES_ENCRYPT(  id,  id ) ) ^ 'i' from t1

            alice Alice Sherepa added a comment - CREATE TABLE t1 ( id varchar (1)); INSERT INTO t1 VALUES ( NULL ), ( NULL ), ( 'a' ), ( 'c' ), ( 'd' ), ( 'd' ), ( 'd' ), ( 'f' ), ( 'g' ), ( 'h' ), ( 'l' ), ( 'm' ), ( 'm' ), ( 'o' ), ( 'o' ), ( 'u' ), ( 'v' ), ( 'w' ), ( 'x' ), ( 'y' );   SELECT ( AES_ENCRYPT( id, id ) ) ^ 'i' from t1 ; mariadbd: 11/sql/sql_type.cc:302: VDec::VDec(Item*): Assertion `(m_ptr == __null) == item->null_value' failed. 230705 17:39:05 [ERROR] mysqld got signal 6 ;   Server version: 11.2.0-MariaDB-debug-log source revision: 7c7de020b576a42bd381a9060c3076f85da0d9d4   sql/sql_type.cc:302(VDec::VDec(Item*))[0x562b66e8f18c] sql/item_func.cc:6491(Func_handler_bit_xor_dec_to_ulonglong::to_longlong_null(Item_handled_func*) const)[0x562b672c3e67] sql/item_func.h:696(Item_handled_func::Handler_int::val_int(Item_handled_func*) const)[0x562b67228cf9] sql/item_func.h:784(Item_handled_func::val_int())[0x562b66ed97c7] sql/sql_type.cc:7488(Type_handler::Item_send_longlong(Item*, Protocol*, st_value*) const)[0x562b66eb7044] sql/sql_type.h:5761(Type_handler_longlong::Item_send(Item*, Protocol*, st_value*) const)[0x562b66ed3700] sql/item.h:1236(Item::send(Protocol*, st_value*))[0x562b6640abc8] sql/protocol.cc:1332(Protocol::send_result_set_row(List<Item>*))[0x562b664cad6f] sql/sql_class.cc:3125(select_send::send_data(List<Item>&))[0x562b6666fbca] sql/sql_class.h:5756(select_result_sink::send_data_with_check(List<Item>&, st_select_lex_unit*, unsigned long long))[0x562b669aabb9] sql/sql_select.cc:24697(end_send(JOIN*, st_join_table*, bool))[0x562b66960cac] sql/sql_select.cc:23664(evaluate_join_record(JOIN*, st_join_table*, int))[0x562b66958a93] sql/sql_select.cc:23468(sub_select(JOIN*, st_join_table*, bool))[0x562b66957982] sql/sql_select.cc:22948(do_select(JOIN*, Procedure*))[0x562b66954c23] sql/sql_select.cc:4933(JOIN::exec_inner())[0x562b668d322d] sql/sql_select.cc:4710(JOIN::exec())[0x562b668d05e4] 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*))[0x562b668d4d35] sql/sql_select.cc:627(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x562b668a44a9] sql/sql_parse.cc:6030(execute_sqlcom_select(THD*, TABLE_LIST*))[0x562b667c59ca] sql/sql_parse.cc:3944(mysql_execute_command(THD*, bool))[0x562b667b65de] sql/sql_parse.cc:7769(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x562b667d080f] sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x562b667a8cef] sql/sql_parse.cc:1405(do_command(THD*, bool))[0x562b667a5a39] sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x562b66c80d17] sql/sql_connect.cc:1320(handle_one_connection)[0x562b66c80674] perfschema/pfs.cc:2203(pfs_spawn_thread)[0x562b678fda46] nptl/pthread_create.c:478(start_thread)[0x7f4454218609]   Query (0x6290001092a8): SELECT ( AES_ENCRYPT( id, id ) ) ^ 'i' from t1

            People

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