Date in search results displays 14th July 2042 for many finds
Bug Summary
If I type some search query into the filter of my inbox I get many finds which display 14th July 2042 (in the German date format in my case) in the search result list. If I open the actual mail the correct date is displayed. The date of the affected mails is not always the same, but the display seems to be incorrect for all of them. This only affects emails from 2013 and 2014.
Your installation
To obtain installation information, copy it from Geary's Problem Report dialog if shown (or else open the Geary Inspector by typing Shift + Alt + I) by selecting System, and clicking the Copy button, then pasting here.
- Geary version: 40.0 (Ubuntu/40.0-2)
- Installation method: apt
- Desktop environment: GNOME
- Operating system and version: Ubuntu 22.04
Relevant logs and/or screenshots
[deb] 18:02:27.0147 geary:common-fts-search-query.vala:215: Search term "buchungsbestätigung" not stemmed
[deb] 18:02:27.0148 geary:imap-db-account.vala:585: Search query: "buchungsbestätigung": ALL:CONSERVATIVE(buchungsbestätigung)
[deb] 18:02:27.0152 geary:imap-db-account.vala:615: Search SQL:
SELECT DISTINCT mt.id
FROM MessageTable AS mt
INDEXED BY MessageTableInternalDateTimeTIndex
INNER JOIN MessageLocationTable AS mlt ON mt.id = mlt.message_id
WHERE mlt.folder_id NOT IN (10,3,1) AND mt.id IN (SELECT mst.rowid FROM MessageSearchTable as mst WHERE MessageSearchTable MATCH ' ( ( "' || 'buchungsbestätigung' || '"*))') AND mlt.remove_marker IN (0, null)
ORDER BY mt.internaldate_time_t DESC
LIMIT 1000 OFFSET 0
[deb] 18:02:27.0157 geary:imap-db-account.vala:635: Matching emails found: 36
[deb] 18:02:27.0206 geary:app-remove-operation.vala:24: Removing 19 messages(s) from GearyAppSearchFolder(>$GearyAccountSearchFolder$)