starred/WYGIWYH
1
0
Fork 0
mirror of https://github.com/eitchtee/WYGIWYH.git synced 2026-07-31 08:58:49 +02:00
Code Issues 14 Packages Projects Releases 10 Wiki Activity

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

New Issue
Closed
opened 2025-12-28 23:25:51 +01:00 by adam · 1 comment
adam commented 2025-12-28 23:25:51 +01:00
Owner
Copy Link
Copy Source

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
adam commented 2025-12-28 23:25:52 +01:00
Author
Owner
Copy Link
Copy Source

@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.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
bug
bug
documentation
enhancement
help wanted
pull-request
Mirrored from GitHub Pull Request
 question
No labels bug
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
adam (Adam Melkus)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/WYGIWYH#82