search

MaterializeInc / materialize

The data warehouse for operational workloads.
https://materialize.com
Other
5.65k stars 459 forks source link

Postgres Inconsistency with comparison #23852

Open jkosh44 opened 6 months ago

jkosh44 commented 6 months ago

What version of Materialize are you using?

v0.80.0

What is the issue?

We have the following inconsistency with PostgreSQL:

postgres=# select '00:00:00.36' >= '0.35';
 ?column? 
----------
 f
(1 row)
materialize=> select '00:00:00.36' >= '0.35';
 ?column? 
----------
 t
(1 row)
jkosh44 commented 6 months ago

It's possible that this is somehow related to one of the following issues:

It also possible that it's completely unrelated.