kderme · GitHub

This pr fixes a small bug, which appears when using the Filter data type. The test added fails with

  src/PersistentTest.hs:87:3:
  1) persistent Filter In
       uncaught exception: SqliteException
       SQLite3 returned ErrorError while attempting to perform prepare "SELECT \"id\", \"name\", \"age\", \"color\" FROM \"Person\" WHERE (\"name\" IN ?)": near "?": syntax error

The issue is that ? should be wrapped in ( ) or sqlite can't parse it.

There seems to be more issues related to the Filter data type. For example someone could write Filter PersonName (FilterValues ["a", "b"]) Eq which will also fail. An additional fix could be:

Read the original on github.com ↗