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

crash in Item_func_json_extract::read_json

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.2.9
    • 10.2.12
    • JSON
    • None
    • Win64
    • 10.2.12

    Description

      Version: '10.2.9-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
      mysqld.exe!String::append()[sql_string.cc:451]
      mysqld.exe!Item_func_json_extract::read_json()[item_jsonfunc.cc:782]
      mysqld.exe!Item_func_json_extract::val_int()[item_jsonfunc.cc:881]
      mysqld.exe!evaluate_join_record()[sql_select.cc:18661]
      mysqld.exe!sub_select()[sql_select.cc:18563]
      mysqld.exe!do_select()[sql_select.cc:18107]
      mysqld.exe!JOIN::exec_inner()[sql_select.cc:3485]
      mysqld.exe!JOIN::exec()[sql_select.cc:3279]
      mysqld.exe!mysql_select()[sql_select.cc:3680]
      mysqld.exe!handle_select()[sql_select.cc:361]
      mysqld.exe!execute_sqlcom_select()[sql_parse.cc:6434]
      mysqld.exe!mysql_execute_command()[sql_parse.cc:3461]
      mysqld.exe!mysql_parse()[sql_parse.cc:7880]
      mysqld.exe!dispatch_command()[sql_parse.cc:1814]
      mysqld.exe!do_command()[sql_parse.cc:1359]
      mysqld.exe!threadpool_process_request()[threadpool_common.cc:366]
      mysqld.exe!tp_callback()[threadpool_common.cc:192]
      

      How to repeat

      drop table if exists t;
      create table t(a double not null)engine=innodb;
      insert into t values (2),(1);
      select 1 from t where json_extract(a,'$','$[81]');
      

      Attachments

        Activity

          People

            holyfoot Alexey Botchkov
            sbester1 sbester1
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.