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.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| 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. |
_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. |
| Workflow | MariaDB v2 [ 59231 ] | MariaDB v3 [ 62942 ] |
| Workflow | MariaDB v3 [ 62942 ] | MariaDB v4 [ 130303 ] |