Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Evergreen] Inconsistencies with Postgres (collection) #21981

Open
10 of 86 tasks
nrainer-materialize opened this issue Sep 26, 2023 · 22 comments
Open
10 of 86 tasks

[Evergreen] Inconsistencies with Postgres (collection) #21981

nrainer-materialize opened this issue Sep 26, 2023 · 22 comments
Labels
C-bug Category: something is broken T-correctness Theme: relates to consistency and correctness of results.

Comments

@nrainer-materialize
Copy link
Contributor

nrainer-materialize commented Sep 26, 2023 •
edited

What version are you using?

Materialize

v0.70.2 (a73fa5e) - v0.112.x+

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
Beta Give feedback
  1. Postgres inconsistency: age, to_char and other functions ignore timezone or have 1h offset #22016
  2. Postgres inconsistency: timezone function produces different value #21999
    jkosh44
  3. Postgres inconsistency: jsonb's || operator produces empty result when applied with simple values #23578
    T-correctness

medium
Beta Give feedback
  1. Postgres inconsistency: Different number parsing with respect to sign #21993
  2. Postgres inconsistency: replace with empty text #22001
    T-correctness
  3. Postgres inconsistency: date_trunc on seconds #22017
  4. Postgres inconsistency: regexp_split_to_array with linebreaks and other whitespaces #22011
  5. Postgres inconsistency: regexp_match, regexp_replace, regexp_split_to_array with linebreak #22000
  6. Postgres inconsistency: Overflow behavior #21994
  7. Postgres inconsistency: Underflow behavior #21995
  8. Postgres inconsistency: math aggregation functions (different precision) #22003
  9. Postgres inconsistency: comparison of real with decimal not working for large values #22022
  10. Postgres inconsistency: extract year from date #23586
    T-correctness
  11. Postgres inconsistency: timestamp - timestamp returns different representation #24578
  12. Decimal 0s are not shown (but are in Postgres) #25723
    C-bug
  13. Postgres inconsistency: timezone definition differs #26521
  14. Postgres inconsistency: translate inconsistency with special characters #26553
    C-bug
    maddyblue
  15. Postgres inconsistency: ERROR: Evaluation error: null character not permitted #26754
    C-bug
    nrainer-materialize
  16. Postgres inconsistency: upper on eszett #26846
  17. Postgres inconsistency: bpchar in mz has different default length specification: bpchar(1) #27247
    A-ADAPTER C-bug
    chaas
  18. Postgres inconsistency: record type: null values dropped #28130
  19. Postgres inconsistency: record type: array and range unpacked #28131
  20. Postgres inconsistency: jsonb, jsonb_object_agg: different date string #28137
  21. Postgres inconsistency: jsonb: numeric field overflow #28169
  22. Postgres inconsistency: short date format #28284
  23. Postgres inconsistency: record type: bytea representation #28392
  24. Postgres inconsistency: table functions: combination with operations with NULL #28806
  25. Postgres inconsistency: unnest on array uses wrong order #29143

low
Beta Give feedback
  1. Postgres inconsistency: timestamp precision does not support null #22014
  2. Postgres inconsistency: ordering on text (min/max, <, ...) different #22002
  3. Postgres inconsistency: mod with high value #22005
  4. Postgres inconsistency: lpad with negative length #21997
  5. Postgres inconsistency: date_trunc: unsupported datetime precisions #21996
  6. Postgres inconsistency: fail on timestamp trunc with unsupported precision #22020
  7. Postgres inconsistency: split_part with negative field position #22023
  8. Postgres inconsistency: non-existing functions for given parameters in mz #22024
  9. Postgres inconsistency: round overflows #22028
  10. Postgres inconsistency: infinity timestamp out of range #22264
  11. Postgres inconsistency: nullif produces return value of different type #22267
  12. Postgres inconsistency: different handling of invalid regex value #22956
  13. Postgres inconsistency: different handling of invalid time unit #22957
  14. Postgres inconsistency: different handling of invalid regex flag #22958
  15. Postgres inconsistency: different handling of invalid time zone #22984
  16. Postgres inconsistency: whitespace diff in jsonb output #23571
  17. Postgres inconsistency: regex replace uses other character to access groups #23605
    A-ADAPTER advent-of-code
  18. Postgres inconsistency: different specification of default DECIMAL type #24678
  19. Postgres inconsistency: different string representation of floating-point type values #24687
  20. Postgres inconsistency: different behavior casting empty time string #24736
  21. Postgres inconsistency: date parsing fails due to unknown units #25228
  22. apd: Value returned from cast to scale N may not actually fit in scale N #7021
    A-sql C-bug P2 T-correctness
    sploiselle
  23. repr: intervals accept various incorrect things that postgres rejects #7062
    A-sql C-bug T-correctness
  24. Postgres inconsistency: base 64 decoding with new line and tab #25937
  25. Postgres inconsistency: allow LIMIT after OFFSET #26272
  26. Postgres inconsistency: float instead of int returned (on int operation) #26306
  27. Postgres inconsistency: ordering on JSON different #26309
  28. Postgres inconsistency: imprecise comparison between REAL and DECIMAL #26323
  29. Postgres inconsistency: different error handling when extracting from timestamp #27078
  30. Postgres inconsistency: array_agg(pg_typeof(...)) in pg flattens result #27150
  31. Postgres inconsistency: round uses REAL precision in mz but DOUBLE in pg #27191
  32. Postgres inconsistency: array_agg on character not yet supported #27252
  33. Postgres inconsistency: bpchar (and char) trim newline #27253
  34. Postgres inconsistency: coalesce on bpchar and char together with text trims #27278
  35. Postgres inconsistency: casting bpchar or char to bytea produces different result #27282
  36. Postgres inconsistency: Ordering with min/max on array (timestamptz[]) #27457
    C-bug
  37. Postgres inconsistency: modulo on double with large / tiny values #27634
  38. Postgres inconsistency: different formatting of array_agg on range #28007
  39. Postgres inconsistency: no implicit casting from smallint[] to numeric[] #28024
  40. Postgres inconsistency: jsonb_agg: non-scalar key #28141
  41. Postgres inconsistency: jsonb_agg: non-quoted numbers #28143
  42. Postgres inconsistency: bigint out of range #28145
  43. Postgres inconsistency: record type: no nullif function #28159
  44. Postgres inconsistency: jsonb_object_agg: different order by result #28192
  45. Postgres inconsistency: jsonb_agg, jsonb_object_agg: bpchar without spaces #28193
  46. Postgres inconsistency: infinity to decimal #28240
  47. Postgres inconsistency: array functions ALL and ANY with NULL or empty array #28300
  48. RQG: IS NULL on table alias behaving differently than in Postgres #28109
    C-bug
  49. Postgres inconsistency: array_agg on arrays not yet supported #28384
  50. Postgres inconsistency: table functions: aggregate functions are not allowed in their arguments #28390
  51. Postgres inconsistency: table functions: not allowed in other table functions #28393
  52. Postgres inconsistency: avg on interval #28559
    C-feature
    nrainer-materialize
  53. Postgres inconsistency: floor return type #28801
  54. Postgres inconsistency: regex flag n #28805
  55. Postgres inconsistency: numeric return type #28852
  56. Postgres inconsistency: table functions: not allowed in aggregate function calls #28871

discarded
Beta Give feedback
  1. Postgres inconsistency: decade for time without time zone #22232
  2. Postgres inconsistency: to_char: unknown units #25227

Deviations not considered a bug (but possibly worth documenting)

Other related ticket not in these task lists
@nrainer-materialize nrainer-materialize added the C-bug Category: something is broken label Sep 26, 2023
@philip-stoev philip-stoev added the T-correctness Theme: relates to consistency and correctness of results. label Oct 2, 2023
@nrainer-materialize nrainer-materialize mentioned this issue Oct 2, 2023
Closed
@nrainer-materialize
Copy link
Contributor Author

nrainer-materialize commented Nov 6, 2023 •
edited

I added further small issues classified as low:

@nrainer-materialize
Copy link
Contributor Author

I have added two issues regarding the data type JSONB:

@chaas chaas changed the title Inconsistencies with Postgres (collection) [Evergreen] Inconsistencies with Postgres (collection) Jan 3, 2024
@chaas chaas removed their assignment Jan 3, 2024
@nrainer-materialize
Copy link
Contributor Author

nrainer-materialize commented Jan 22, 2024 •
edited

Added

@nrainer-materialize
Copy link
Contributor Author

Added

@nrainer-materialize
Copy link
Contributor Author

Added

@nrainer-materialize nrainer-materialize mentioned this issue Jan 25, 2024
Merged
@nrainer-materialize
Copy link
Contributor Author

Added

@nrainer-materialize
Copy link
Contributor Author

nrainer-materialize commented Feb 14, 2024 •
edited

Added

@nrainer-materialize
Copy link
Contributor Author

Added

@nrainer-materialize
Copy link
Contributor Author

Added

@nrainer-materialize
Copy link
Contributor Author

nrainer-materialize commented Mar 28, 2024 •
edited

Added

@nrainer-materialize
Copy link
Contributor Author

Added

@nrainer-materialize
Copy link
Contributor Author

Added

@nrainer-materialize
Copy link
Contributor Author

Added

@nrainer-materialize
Copy link
Contributor Author

Added

@nrainer-materialize
Copy link
Contributor Author

nrainer-materialize commented May 23, 2024 •
edited

Added

@nrainer-materialize nrainer-materialize mentioned this issue May 24, 2024
Merged
@nrainer-materialize
Copy link
Contributor Author

nrainer-materialize commented Jul 3, 2024 •
edited

Added

@nrainer-materialize
Copy link
Contributor Author

nrainer-materialize commented Jul 10, 2024 •
edited

Added

@nrainer-materialize
Copy link
Contributor Author

Added

@nrainer-materialize
Copy link
Contributor Author

Added

@nrainer-materialize
Copy link
Contributor Author

Added

@nrainer-materialize
Copy link
Contributor Author

nrainer-materialize commented Aug 5, 2024 •
edited

Added

@nrainer-materialize
Copy link
Contributor Author

Added

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
C-bug Category: something is broken T-correctness Theme: relates to consistency and correctness of results.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@philip-stoev @chaas @nrainer-materialize