I’ve used the of sqlite database
inspector in the past to report on action history in ActionHistory.db
without any problems. I’m attempting to create a property to find the oldest access time of a file in each of my relays cache to determine approximately how long I can maintain data in the relay cache before it gets purged out. In order to do this I am running relevance using the of sqlite database
inspector against DownloadCache.db
The fixlet debugger seems to be mangling the results related to the data types

But, what I get from the command line tool sqlite3.exe is more in line with what I would expect to see.

If I look at the schema for that table it shows that the SHA1 is a text and the others are integer

Why would I be getting these strange results?
Incidentally, I can get around the issue by changing the query a little.
