Open nrainer-materialize opened 11 months ago
Further similar case:
mz:
materialize=> select '0'::text::text < '-1'::text;
?column?
----------
f
(1 row)
materialize=> select '0'::text::text < '-'::text;
?column?
----------
f
(1 row)
pg
postgres=# select '0'::text::text < '-1'::text;
?column?
----------
t
(1 row)
postgres=# select '0'::text::text < '-'::text;
?column?
----------
f
(1 row)
According to @sploiselle,
This PG output inconsistency is due to the way Rust vs. Postgres perform ordering operations.
Postgres
produces
mz
produces
⚠️ Note that there is a space character before
m
.