Skip to content

SQLite where condition with binary column not working #468

@zeleznypa

Description

@zeleznypa

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions