[MDEV-11043] mysql_stmt_prepare() fails with "unknown column" error - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.1(EOL)
Fix Version/s: 5.5.52, 10.1.18, 10.0.28
Component/s: Prepared Statements
Labels:
- upstream-fixed
Environment:
linux, mariadb-10.1.9

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)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2016-10-12 17:57

Updated:: 2016-10-19 15:00

Resolved:: 2016-10-19 15:00

Git Integration

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