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

queries return random data when they have inline comments

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.0.1
    • Fix Version/s: 1.0.3
    • Component/s: ExeMgr
    • Labels:
      None
    • Sprint:
      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

              Assignee:
              dleeyh Daniel Lee
              Reporter:
              hill David Hill
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: