Open
Description
What happens?
I am developing quals push-down feature and have found that the query result is abnormal
pg_lakehouse=# select binary_col from t1 where binary_col = '\x68656c6c6f';
binary_col
------------
(0 rows)
pg_lakehouse=# select binary_col from t1 where binary_col = E'\\x68656c6c6f';
binary_col
------------
(0 rows)
pg_lakehouse=# select binary_col from t1;
binary_col
------------------
\x68656c6c6f
\x
\x70617271756574
(3 rows)
pg_lakehouse=# select binary_col from t1 where binary_col = E'';
binary_col
------------
\x
(1 row)
pg_lakehouse=#
To Reproduce
- export parquet file in the code. test_arrow_types.parquet
- create foreign table
CREATE FOREIGN DATA WRAPPER parquet_wrapper
HANDLER parquet_fdw_handler
VALIDATOR parquet_fdw_validator;
CREATE SERVER parquet_server
FOREIGN DATA WRAPPER parquet_wrapper;
CREATE FOREIGN TABLE t1 (
boolean_col boolean,
int8_col smallint,
int16_col smallint,
int32_col integer,
int64_col bigint,
uint8_col smallint,
uint16_col integer,
uint32_col bigint,
uint64_col numeric(20),
float32_col real,
float64_col double precision,
date32_col date,
date64_col date,
binary_col bytea,
large_binary_col bytea,
utf8_col text,
large_utf8_col text
)
SERVER parquet_server
OPTIONS (files '/home/kyss/labs/paradedb/test_arrow_types.parquet');- query
select binary_col from t1 where binary_col = '\x68656c6c6f';
select binary_col from t1 where binary_col = E'\\x68656c6c6f';
select binary_col from t1 where binary_col = E'';
select binary_col from t1;OS:
x86
ParadeDB Version:
0.8.6.
Are you using ParadeDB Docker, Helm, or the extension(s) standalone?
ParadeDB pg_lakehouse Extension
Full Name:
kyss
Affiliation:
NA
Did you include all relevant data sets for reproducing the issue?
Yes
Did you include the code required to reproduce the issue?
- Yes, I have
Did you include all relevant configurations (e.g., CPU architecture, PostgreSQL version, Linux distribution) to reproduce the issue?
- Yes, I have