Hey folks! I'm currently using sqruff 0.19.1 installed via cargo on Windows 10 working with the DuckDB dialect. For some reason a LOAD spatial; is throwing off the rest of my linting rules.
LOAD spatial;
-- SUMMARIZE cpd_incidents;
-- DESCRIBE cpd_incidents;
SELECT location FROM cpd_incidents LIMIT 1;
SELECT
crimeday AS "Crime Day",
count(crimeday) AS "Crime Count"
FROM
cpd_incidents
WHERE
crimeday IS NOT NULL
GROUP BY
crimeday
ORDER BY
"Crime Count" DESC;
Becomes
LOAD spatial ;
-- SUMMARIZE cpd_incidents;
-- DESCRIBE cpd_incidents;
SELECT location FROM cpd_incidents LIMIT 1 ;
SELECT
crimeday AS "Crime Day",
count (crimeday) AS "Crime Count"
FROM
cpd_incidents
WHERE
crimeday IS NOT NULL
GROUP BY
crimeday
ORDER BY
"Crime Count" DESC ;
When I remove the LOAD spatial; my linting rules are parsed properly.
-- LOAD spatial;
-- SUMMARIZE cpd_incidents;
-- DESCRIBE cpd_incidents;
SELECT location FROM cpd_incidents LIMIT 1;
SELECT
crimeday AS "Crime Day",
count(crimeday) AS "Crime Count"
FROM
cpd_incidents
WHERE
crimeday IS NOT NULL
GROUP BY
crimeday
ORDER BY
"Crime Count" DESC;
Hey folks! I'm currently using sqruff 0.19.1 installed via cargo on Windows 10 working with the DuckDB dialect. For some reason a
LOAD spatial;
is throwing off the rest of my linting rules.Becomes
When I remove the LOAD spatial; my linting rules are parsed properly.