[Evergreen] Inconsistencies with Postgres (collection)

nrainer-materialize commented 10 months ago

What version are you using?

Materialize

v0.70.2 (a73fa5e11) - v0.107+

Postgres

PostgreSQL 15.4 (Debian 15.4-1.pgdg120+1) on aarch64-unknown-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit - PostgreSQL 16.2 (Debian 16.2-1.pgdg120+2) on aarch64-unknown-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit

What are the issues?

Note that not all inconsistencies might be considered bugs. It might be worthy to update the documentation for accepted inconsistencies.

### high
- [ ] https://github.com/MaterializeInc/materialize/issues/22016
- [ ] https://github.com/MaterializeInc/materialize/issues/21999
- [ ] https://github.com/MaterializeInc/materialize/issues/23578

### medium
- [ ] https://github.com/MaterializeInc/materialize/issues/21993
- [ ] https://github.com/MaterializeInc/materialize/issues/22001
- [ ] https://github.com/MaterializeInc/materialize/issues/22017
- [ ] https://github.com/MaterializeInc/materialize/issues/22011
- [ ] https://github.com/MaterializeInc/materialize/issues/22000
- [ ] https://github.com/MaterializeInc/materialize/issues/21994
- [ ] https://github.com/MaterializeInc/materialize/issues/21995
- [ ] https://github.com/MaterializeInc/materialize/issues/22003
- [ ] https://github.com/MaterializeInc/materialize/issues/22022
- [ ] https://github.com/MaterializeInc/materialize/issues/23586
- [ ] https://github.com/MaterializeInc/materialize/issues/24578
- [ ] https://github.com/MaterializeInc/materialize/issues/25723
- [ ] https://github.com/MaterializeInc/materialize/issues/26521
- [ ] https://github.com/MaterializeInc/materialize/issues/26553
- [ ] https://github.com/MaterializeInc/materialize/issues/26754
- [ ] https://github.com/MaterializeInc/materialize/issues/26846
- [ ] https://github.com/MaterializeInc/materialize/issues/27247
- [ ] https://github.com/MaterializeInc/materialize/issues/28130
- [ ] https://github.com/MaterializeInc/materialize/issues/28131
- [ ] https://github.com/MaterializeInc/materialize/issues/28137
- [ ] https://github.com/MaterializeInc/materialize/issues/28169
- [ ] https://github.com/MaterializeInc/materialize/issues/28284
- [ ] https://github.com/MaterializeInc/materialize/issues/28392

### low
- [ ] https://github.com/MaterializeInc/materialize/issues/22014
- [ ] https://github.com/MaterializeInc/materialize/issues/22002
- [ ] https://github.com/MaterializeInc/materialize/issues/22005
- [ ] https://github.com/MaterializeInc/materialize/issues/21997
- [ ] https://github.com/MaterializeInc/materialize/issues/21996
- [ ] https://github.com/MaterializeInc/materialize/issues/22020
- [ ] https://github.com/MaterializeInc/materialize/issues/22023
- [ ] https://github.com/MaterializeInc/materialize/issues/22024
- [ ] https://github.com/MaterializeInc/materialize/issues/22028
- [ ] https://github.com/MaterializeInc/materialize/issues/22264
- [ ] https://github.com/MaterializeInc/materialize/issues/22267
- [ ] https://github.com/MaterializeInc/materialize/issues/22956
- [ ] https://github.com/MaterializeInc/materialize/issues/22957
- [ ] https://github.com/MaterializeInc/materialize/issues/22958
- [ ] https://github.com/MaterializeInc/materialize/issues/22984
- [ ] https://github.com/MaterializeInc/materialize/issues/23571
- [ ] https://github.com/MaterializeInc/materialize/issues/23605
- [ ] https://github.com/MaterializeInc/materialize/issues/24678
- [ ] https://github.com/MaterializeInc/materialize/issues/24687
- [ ] https://github.com/MaterializeInc/materialize/issues/24736
- [ ] https://github.com/MaterializeInc/materialize/issues/25228
- [ ] https://github.com/MaterializeInc/materialize/issues/7021
- [ ] https://github.com/MaterializeInc/materialize/issues/7062
- [ ] https://github.com/MaterializeInc/materialize/issues/25937
- [ ] https://github.com/MaterializeInc/materialize/issues/26272
- [ ] https://github.com/MaterializeInc/materialize/issues/26306
- [ ] https://github.com/MaterializeInc/materialize/issues/26309
- [ ] https://github.com/MaterializeInc/materialize/issues/26323
- [ ] https://github.com/MaterializeInc/materialize/issues/27078
- [ ] https://github.com/MaterializeInc/materialize/issues/27150
- [ ] https://github.com/MaterializeInc/materialize/issues/27191
- [ ] https://github.com/MaterializeInc/materialize/issues/27252
- [ ] https://github.com/MaterializeInc/materialize/issues/27253
- [ ] https://github.com/MaterializeInc/materialize/issues/27278
- [ ] https://github.com/MaterializeInc/materialize/issues/27282
- [ ] https://github.com/MaterializeInc/materialize/issues/27457
- [ ] https://github.com/MaterializeInc/materialize/issues/27634
- [ ] https://github.com/MaterializeInc/materialize/issues/28007
- [ ] https://github.com/MaterializeInc/materialize/issues/28024
- [ ] https://github.com/MaterializeInc/materialize/issues/28141
- [ ] https://github.com/MaterializeInc/materialize/issues/28143
- [ ] https://github.com/MaterializeInc/materialize/issues/28145
- [ ] https://github.com/MaterializeInc/materialize/issues/28159
- [ ] https://github.com/MaterializeInc/materialize/issues/28192
- [ ] https://github.com/MaterializeInc/materialize/issues/28193
- [ ] https://github.com/MaterializeInc/materialize/issues/28240
- [ ] https://github.com/MaterializeInc/materialize/issues/28300
- [ ] https://github.com/MaterializeInc/materialize/issues/28109
- [ ] https://github.com/MaterializeInc/materialize/issues/28384
- [ ] https://github.com/MaterializeInc/materialize/issues/28390
- [ ] https://github.com/MaterializeInc/materialize/issues/28393
- [ ] https://github.com/MaterializeInc/materialize/issues/28559

### discarded
- [ ] https://github.com/MaterializeInc/materialize/issues/22232
- [ ] https://github.com/MaterializeInc/materialize/issues/25227

Deviations not considered a bug (but possibly worth documenting)

Postgres throws the errors cannot get array length of a scalar, cannot get array length of a non-array, cannot delete from scalar, mz does not
Postgres cannot cast a boolean to int8, mz can (https://github.com/MaterializeInc/materialize/pull/24686)