Sqllite coalesce problem when running django testcases

Question

I am using django for running my project. And I am using postgresql_psycopg2 engine for my production db, but the test runner uses sqllite3 for running the tests. Keeping my production db(postgresql)in mind I tried building a query which uses "coalesce". But sqllite3 doesn't recognize this. How do I get pass this. I can use postgresql_psycopg2 even for my test running(just to avoid wastage of time), but its too slow. How do I get pass this?

Answer 1

Sqlite does support coalesce but requires at least two arguments. I believe that the Postgresl implementation only requires one parameter while Sqlite requires at least two. Perhaps you are using coalesce with only one parameter in Postgresql and that is breaking when moving to Sqlite?

Could you post the code that is failing?