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

server crash - query with NOT IN

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.0.0
    • None
    • None
    • None
    • linux

    Description

      when running query with not in a error occurs segment fault and server crash
      i will attach query and others files

      query:

      SELECT COUNT(*) FROM spamov_importacao_arquivos AS a 
      WHERE tipo='c' AND datahora_gmt>='0000-00-00 00:00:00' AND datahora_gmt<='2012-12-03 01:59:59' 
      AND (tipo_arquivo,arquivo_id) NOT IN (
      	SELECT tipo_arquivo,arquivo_id FROM spamov_importacao_arquivos_datas WHERE 
      	(tipo_arquivo,arquivo_id)=(a.tipo_arquivo,a.arquivo_id)
      )

      Attachments

        Activity

          People

            elenst Elena Stepanova
            rspadim roberto spadim
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.