laravel-pdo-odbc icon indicating copy to clipboard operation
laravel-pdo-odbc copied to clipboard

Issue With Prepared Statements

Open aldobarr opened this issue 6 months ago • 1 comments

I recently reported an issue with named parameter bindings to the snowflake pdo driver but after a bit more digging it looks like the issue might actually be with this package.

Please see this issue for full details: https://github.com/snowflakedb/pdo_snowflake/issues/396

But to summarize, it looks like named parameter binds are not working as they should be. Come to think of it the reason it most likely didn't break in our production is because our prod environment is not yet on 1.2.5. So potentially something about 1.2.5 broke it.

While debugging this and going through this package's code during execution, it looks like the package is trying to handle the parameters itself instead of passing them to the statement to let PDO handle it...? And only when positional params are used otherwise bindings are entirely ignored...? It seems very strange to me the way this package is implementing PDO.

aldobarr avatar Aug 21 '24 15:08 aldobarr