MySQL SelectDecorator - subselect limit parameter not prefixed (fix included)

[smartwebproducts]

• I was not able to find an open or closed issue matching what I'm seeing.
• This is not a question. (Questions should be asked on slack (Signup for Slack here) or our forums.)

When you have a FROM clause that includes a query with a LIMIT in it, and you try to prepare the query, you get following error:

Fatal error: Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined in vendor/zendframework/zend-db/src/Adapter/Driver/Pdo/Statement.php:239
Stack trace:
#0 vendor/zendframework/zend-db/src/Adapter/Driver/Pdo/Statement.php(239): PDOStatement->execute()

The reason for this is because the parameter name for the subselect's limit is :limit while in the parameterContainer it is :subselect1limit.

This problem is rectified by modifying line 55 of src/Sql/Platform/Mysql/SelectDecorator.php from:

return [$driver->formatParameterName('limit')];

to

return [$driver->formatParameterName($paramPrefix . 'limit')];

[tptrixtop]

Looks like that was fixed by this PR #300 )

[michalbundyra]

This repository has been closed and moved to laminas/laminas-db; a new issue has been opened at laminas/laminas-db#50.