Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7468

Support expressions in LIMIT clause

    XMLWordPrintable

Details

    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

          People

            Unassigned Unassigned
            milki mario
            Votes:
            2 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.