Using Pocket Query v2.0.7, once a query has been cached, the next time it is run (i.e. the results are pulled from the cache) the column order in the result set is reversed.
e.g.
- Query run first time results contain columns: Name, Total.
- Query run second time (results pulled from cache) and results contain columns: Total, Name
When displaying data in a simple table, this is not ideal as once cached the data is no longer presented as originally intended.
Is this a bug? or something wrong with my particular implementation?
Once caching is disabled all works as normal and the column order reflects what is defined in the SQL query.
