Impossible to save null to nullable boolean field

[aivus]

It's impossible to save null to nullable boolean field.
PDO::PARAM_BOOL converts any values to true/false.
PDO::PARAM_NULL could be used for this purpose

But I don't see a good approach for this.
It would be great to have value in Type::getBindingType() in BooleanType or any other approach.

I can prepare PR if we find solution for this.

It was discussed in #632 but solution wasn't found.

[deeky666]

This requires a use-case that reveals the issue, at best a test case.

[aivus]

@deeky666 test exists, but it has incorrect value:

dbal/tests/Doctrine/Tests/DBAL/Functional/Ticket/DBAL630Test.php

Line 163 in 292a651

array(null, false)

And some discuss here:
https://github.com/doctrine/dbal/pull/632/files#r15512990

[deeky666]

@aivus I remember the issue. I don't see what we can do about it as it seems to be a bug in the PDO driver with emulated prepares. IMO it has to be fixed in PHP. I don't have a solution for this other than disabling emulated prepares.

[morozov]

Closing as stale and likely unrelated to the DBAL.

[github-actions]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.