v.19.3New Features

Support for Arbitrary Constant Expressions in LIMIT Clause

Support for arbitrary constant expressions in LIMIT clause. #4246 (k3box)
Support for arbitrary constant expressions in the LIMIT clause.

Why it matters

This feature allows users to use any constant expression within the LIMIT clause instead of just literal numbers, enabling more flexible and dynamic query limits.

How to use it

Simply use any constant expression (e.g., arithmetic operations, function calls returning constants) inside the LIMIT clause of your query, for example:

sql<br>SELECT * FROM table LIMIT 10 + 5<br>