Version: 5.1.0
Bug Description
If I have a column id of type blob in the SQLite database containing the binary form of UUIDv7, then I can write ->where('[id] = %bin', $id) where ID is the binary value of UUID, and everything works.
I can also say ->setupResult('setType', 'id', Type::Binary) even though it is not necessary at all...
Unfortunately, [id] = ? or [id] in %in tends to convert the binary string to a string, which ultimately does not work.
Steps To Reproduce
https://github.com/zeleznypa/dibi-binary-issue/blob/main/src/example.php
Version: 5.1.0
Bug Description
If I have a column
idof type blob in the SQLite database containing the binary form of UUIDv7, then I can write->where('[id] = %bin', $id)where ID is the binary value of UUID, and everything works.I can also say
->setupResult('setType', 'id', Type::Binary)even though it is not necessary at all...Unfortunately,
[id] = ?or[id] in %intends to convert the binary string to a string, which ultimately does not work.Steps To Reproduce
https://github.com/zeleznypa/dibi-binary-issue/blob/main/src/example.php