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
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.