2006-06-02

SQLite does not like CSV fixtures with id column

Yesterday I tried to switch to SQLite 3 for testing. Unfortunately tests failed with mysterious error:

SQL logic error or missing database (SQLite3::SQLException)

Some time later I pinpointed the problem. Fixtures for join class where in CSV format. For some reason SQL does not tolerate CSV fixtures including id field. Changing fixture to yaml fixed the fault.

0 comments: