SQLite Forum

Small Mistake in Delete Limit Railroad Diagram
Login

Small Mistake in Delete Limit Railroad Diagram

(1) By SeverKetor on 2021-09-23 23:33:19 [source]

Just noticed this as I was double-checking something, but the delete-stmt-limited diagram on <https://www.sqlite.org/lang_delete.html> shows one of the arrows coming from the ordering terms going to the end of the statement. Actually trying a statement like DELETE FROM table ORDER BY Column results in "Error: ORDER BY without LIMIT on DELETE".

(2) By Larry Brasfield (larrybr) on 2021-09-24 00:29:29 in reply to 1 [link] [source]

Thanks for the tip. Fixed on trunk, to reach doc pages in due time.

(3) By SeverKetor on 2023-08-05 20:38:01 in reply to 1 [link] [source]

It took me almost 2 years, but I just noticed the update diagram also makes it look like you can do ORDER BY without LIMIT.