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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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