Closed morozov closed 3 weeks ago
Maybe @cjbj knows what's going on there?
I guess bool is not supported at all by PDO OCI and bool is converted to string. In PHP, false
is converted to empty string (https://3v4l.org/NkDMT). Empty string in Oracle is always converted to null
(https://docs.oracle.com/database/121/SQLRF/sql_elements005.htm) by Oracle database.
So this issue seems like a duplicate of https://github.com/php/php-src/issues/12603.
So this issue seems like a duplicate of #12603.
FWIW, it doesn't mention pdo_oci
.
As already mentioned, pdo_oci does not support PARAM_BOOL
and will interpret it as PARAM_STR
as a fallback.
Of course it is possible to change it to accommodate PARAM_BOOL
, but that cannot be done in a stable version of php.
From 8.4 onwards pdo_oci is unbundled and is now a PECL extension. If there are no objections, perhaps this issue should be forwarded to the oci repository.
No feedback was provided. The issue is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so. Thank you.
Description
The following code:
Resulted in this output:
But I expected this output instead:
PHP Version
PHP 8.3.8
Operating System
Linux
The issue was originally reported as bug #81586, discovered via https://github.com/doctrine/dbal/issues/2481.