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

crash in Item_func_json_extract::read_json

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

          sbester1 sbester1 created issue -

          Thanks for the report and test case.

          elenst Elena Stepanova added a comment - Thanks for the report and test case.
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Fix Version/s 10.2 [ 14601 ]
          Assignee Alexey Botchkov [ holyfoot ]
          elenst Elena Stepanova made changes -
          Status Open [ 1 ] Confirmed [ 10101 ]
          serg Sergei Golubchik made changes -
          Sprint 10.2.12 [ 216 ]
          holyfoot Alexey Botchkov made changes -
          Status Confirmed [ 10101 ] In Progress [ 3 ]
          holyfoot Alexey Botchkov added a comment - http://lists.askmonty.org/pipermail/commits/2017-December/011762.html
          holyfoot Alexey Botchkov made changes -
          issue.field.resolutiondate 2017-12-25 04:39:54.0 2017-12-25 04:39:54.138
          holyfoot Alexey Botchkov made changes -
          Fix Version/s 10.2.12 [ 22810 ]
          Fix Version/s 10.2 [ 14601 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 82873 ] MariaDB v4 [ 152923 ]

          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.