Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
Description
Feature Request
Support expressions in the LIMIT clause, not just integers,
such as SELECT * FROM tbl LIMIT (1 * :param)
Both SQLite and Postgres allow similar. And it would be kind of helpful for PHP users, to eschew the emulated prepared statement driver situation there.
(Bound parameters are interpolated as strings per default, and MariaDB doesn't permit `LIMIT '20'` clauses of course.)
It's entirely sufficient to support scalar expressions of course. There's no need for incorporating column references etc.