PDO, query with boolean parameters fails silently

nette / database

💾 A database layer with a familiar PDO-like API but much more powerful. Building queries, advanced joins, drivers for MySQL, PostgreSQL, SQLite, MS SQL Server and Oracle.

https://doc.nette.org/database

Other

512 stars 108 forks source link

PDO, query with boolean parameters fails silently #231

Closed peldax closed 5 years ago

peldax commented 5 years ago

bug fix
BC break? most likely not

Work around an PHP bug, where mysql query with boolean parameters and disabled emulated prepare-statements fails silently. Bool value is interepreted incorrectly, more information in php bugtracker thread:

https://bugs.php.net/bug.php?id=38546

There is currently work being done in fixing the issue on the PHP end.

peldax commented 5 years ago

After 13 years, bug got fixed in PHP 7.3.7 !!

dg commented 5 years ago

I hope it will not do problems in other databases.