[MDEV-11043] mysql_stmt_prepare() fails with "unknown column" error Created: 2016-10-12  Updated: 2016-10-19  Resolved: 2016-10-19

Status: Closed
Project: MariaDB Server
Component/s: Prepared Statements
Affects Version/s: 10.1
Fix Version/s: 5.5.52, 10.1.18, 10.0.28

Type: Bug Priority: Major
Reporter: tg(x) Assignee: Unassigned
Resolution: Fixed Votes: 0
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;"



 Comments   
Comment by Elena Stepanova [ 2016-10-19 ]

The problem was fixed by a merge of this commit from upstream:

commit 8bb95e9a974b5eee44764698fafc56279f8b7691
Author: Sreeharsha Ramanavarapu <sreeharsha.ramanavarapu@oracle.com>
Date:   Wed Aug 3 09:58:36 2016 +0530
 
    Bug #24380263: INCORRECT BEHAVIOR WITH PARAMETER AND
                   DERIVED TABLE IN JOIN

The fix is in 5.5.52, 10.1.18, 10.2.2, and will be in 10.0.28 when it's released.

Generated at Thu Feb 08 07:46:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.