Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.0.1
-
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