Implement SQL Query Validator in Quarry
Open, Needs TriagePublic
Actions

Assigned To

None

Authored By

	Tohaomg
	Feb 28 2018, 7:45 PM

Description

I have to wait for ages while my query is queued, just to learn that there is a syntax error. Is it possible to preprocess queries so that syntax errors are reported at once?

Related Objects

Mentioned In: T74874: Provide a way to add hyperlink in Quarry results/output
T188564: Quarry should refuse to save results that are way too large

Event Timeline

Tohaomg created this task.Feb 28 2018, 7:45 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 28 2018, 7:45 PM

Reedy renamed this task from SQL Syntax errors in Quarry to Implement SQL Query Validator in Quarry.Feb 28 2018, 8:21 PM

Quarry isn't supposed to be slow in 'queued'. I'll investigate.

zhuyifei1999 mentioned this in T188564: Quarry should refuse to save results that are way too large.Feb 28 2018, 11:04 PM

Is there an open source 'SQL Query Validator' that supports MySQL syntax? My quick google search didn't find anything.

Seb35 mentioned this in T74874: Provide a way to add hyperlink in Quarry results/output.Oct 15 2018, 12:49 PM

A possible solution would be to use CodeMirror and the linting addon since it is already used in Quarry, but there is no support for linting the SQL syntax. If someone is interested, it could be an upstream contribution, and then it could be integrated on Quarry.

The problem is, this isn't really standardized SQL, but MySQL / MariaDB variant. Upstreaming this sounds unlikely.

Implement SQL Query Validator in QuarryOpen, Needs TriagePublicActions

Description

Related Objects

Event Timeline

Implement SQL Query Validator in Quarry
Open, Needs TriagePublic
Actions