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

mysql_stmt_prepare() fails with "unknown column" error

    XMLWordPrintable

    Details

      Description

      mysql_stmt_prepare() fails with the following query (which works from the CLI):

      "SELECT foo.bar FROM (SELECT ? AS bar) AS foo;"
      Unknown column 'foo.bar' in 'field list'

      wrapping the argument in an extra SELECT makes it work:
      "SELECT foo.bar FROM (SELECT (SELECT ?) AS bar) AS foo;"

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            tg-x tg(x)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: