Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-812

Cross engine join and a filter where the string contains a quote character

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 1.0.9
    • 1.0.11, 1.1.0
    • ExeMgr
    • None
    • 2017-15

    Description

      We found a bug when you have a query with cross engine join and a filter where the string contains a quote character:

      select r.* from column_store_table c
      join innodb_table t on t.id = c.inno_id 
      where t.title = '\''
      

      The server returns:

      Internal error: fatal error executing query in crossengine client lib(17)(17)

      The same happens with backslash char:

      select r.* from raw_detection r 
      join tracks t on t.id = r.track_id 
      where t.title = '\\'
      limit 10
      

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            playax Playax
            Votes:
            2 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.