We have ported an iPad app which runs well using GRDB on a SQLCipher database. When we run on a Mac the exact same database (even MD5 checked for binary compatibility) has issues with SQL queries that run fine on iPad. Are there any limitations on SQL usage when run on Catalyst we shouold be aware of ? One of the issues we worked around for one query involved the uses of aliases in the query for legibility. Reverting to the base table column name resolved it.
Anybody seen this before ?