Deduplication with "lax" throws an error if the comparison field has a numeric value #82

Closed
opened 2025-12-28 23:25:51 +01:00 by adam · 1 comment
Owner

Originally created by @stefan786 on GitHub (Dec 16, 2025).

If the deduplication fields are numerical (e.g. amount or date), only strict comparisons work.

django.db.utils.ProgrammingError: function upper(date) does not exist
LINE 1: ...ivate')) AND UPPER("transactions"."date"::text) = UPPER('202...
                                                              ^

Originally created by @stefan786 on GitHub (Dec 16, 2025). If the deduplication fields are numerical (e.g. `amount` or `date`), only strict comparisons work. ``` django.db.utils.ProgrammingError: function upper(date) does not exist LINE 1: ...ivate')) AND UPPER("transactions"."date"::text) = UPPER('202... ^ ```
adam added the bug label 2025-12-28 23:25:51 +01:00
adam closed this issue 2025-12-28 23:25:51 +01:00
Author
Owner

@eitchtee commented on GitHub (Dec 16, 2025):

Thanks for bringing this to my attention!

For a workaround until a fix is implemented see: https://github.com/eitchtee/WYGIWYH/discussions/452#discussioncomment-15269564

@eitchtee commented on GitHub (Dec 16, 2025): Thanks for bringing this to my attention! For a workaround until a fix is implemented see: https://github.com/eitchtee/WYGIWYH/discussions/452#discussioncomment-15269564
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/WYGIWYH#82