SQLite

View Ticket
Login
Ticket Hash: 25e09aa2ab20d67a241b0164ac6818a27ea248d0
Title: Lint mode
Status: Closed Type: Feature_Request
Severity: Important Priority: Immediate
Subsystem: Parser Resolution: Rejected
Last Modified: 2014-03-11 13:19:13
Version Found In:
Description:
It would be really nice if there was some sort of "lint" mode so that it would be possible to point out to developers when they are doing something nonsensical, undefined or suboptimal.
User Comments:
nobody (claiming to be Roger Binns) added on 2013-02-11 01:37:43:
Additional examples from the mailing list:

* Doing "natrual" join
* Nonsensical aggregate function use
* Using double quotes for strings
* Adding an ORDER BY random() if no order is present

nobody added on 2013-02-20 21:49:05:
more than one row returned by a subquery used as an expression

http://thread.gmane.org/gmane.comp.db.sqlite.general/79670