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

queries return random data when they have inline comments

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.0.1
    • 1.0.3
    • ExeMgr
    • None
    • 1.0.3

    Description

      Alpha customer reported following issue:

      We continue to do testing, actively, with the ColumnStore engine… and our tools place in-line comments in some of the queries.
      If you place inline comments in the queries, random data is returned, so I suspect there’s a bug within the parsing of the query strings?

      Removing the inline comments results in successful querying of data.

      example:

      Before:
      SELECT
      d.*,
      c.cause_name
      FROM gbd.output_epi_multi_year_v263 d
      LEFT JOIN shared.cause_hierarchy ch ON ch.cause_id = d.cause_id
      LEFT JOIN shared.cause c ON c.cause_id = d.cause_id
      WHERE measure_id = 5 – prevalence
      AND year_start_id = 1990
      AND year_end_id = 2015
      AND location_id = 160
      AND metric_id = 2 – percent
      AND sex_id = 3 – both sexes
      AND age_group_id = 22 – all ages
      AND ch.level = 2 – cause hierarchy level 1
      ORDER BY val ASC – lowest to highest values
      LIMIT 1

      After:
      SELECT
      d.*,
      c.cause_name
      FROM gbd.output_epi_multi_year_v263 d
      LEFT JOIN shared.cause_hierarchy ch ON ch.cause_id = d.cause_id
      LEFT JOIN shared.cause c ON c.cause_id = d.cause_id
      WHERE measure_id = 5
      AND year_start_id = 1990
      AND year_end_id = 2015
      AND location_id = 160
      AND metric_id = 2
      AND sex_id = 3
      AND age_group_id = 22
      AND ch.level = 2
      ORDER BY val ASC
      LIMIT 1

      Attachments

        Issue Links

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              hill David Hill (Inactive)
              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.