Can't select by blob field

[wangfenjin]

What happens?

After insert into table, select by equal seems not work

To Reproduce

D CREATE TABLE blobs (b BYTEA);
D INSERT INTO blobs VALUES('\xaa\xff\xaa'), ('\xAA\xFF\xAA\xAA\xFF\xAA'), ('\xAA\xFF\xAA\xAA\xFF\xAA\xAA\xFF\xAA');
D SELECT * FROM blobs;
┌──────────────────────────────────────┐
│                  b                   │
├──────────────────────────────────────┤
│ \xAA\xFF\xAA                         │
│ \xAA\xFF\xAA\xAA\xFF\xAA             │
│ \xAA\xFF\xAA\xAA\xFF\xAA\xAA\xFF\xAA │
└──────────────────────────────────────┘
D SELECT * FROM blobs where b = '\xaa\xff\xaa';
D SELECT * FROM blobs where b = '\xAA\xFF\xAA';
D

OS:

macOS

DuckDB Version:

0.5.0

DuckDB Client:

capi

Full Name:

WANG FENJIN

Affiliation:

Personal

Have you tried this on the latest master branch?

• I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• I agree

[wangfenjin]

More specially, 0.5.0 release break this test case, I can't figure out how to fix the issue
https://github.com/wangfenjin/duckdb-rs/blob/5b72aa7a2693a214d621c78710a058db31021fa0/src/types/to_sql.rs#L318-L339

[wangfenjin]

I tried the 0.4.0 binary, the command line also not work.

But the test code do works for 0.4.0

[lokax]

This problem is caused by changing the '\xAA'(one byte) into ('\', 'x', 'A', 'A')(4 byte) when checking the zonemap. I will try to fix it

[wangfenjin]

Thanks!

Not sure we will prepare a hot-fix release for this, or will wait for next version?