[MDEV-7468] Support expressions in LIMIT clause Created: 2015-01-14  Updated: 2019-02-18

Status: Open
Project: MariaDB Server
Component/s: Parser, Prepared Statements
Fix Version/s: None

Type: Task Priority: Minor
Reporter: mario Assignee: Unassigned
Resolution: Unresolved Votes: 2
Labels: 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.


Generated at Thu Feb 08 07:19:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.