search

stephencelis / SQLite.swift

A type-safe, Swift-language layer over SQLite3.
MIT License
9.68k stars 1.56k forks source link

syntax error when using != and >= and <= in Xcode 10.2 #892

Closed arjavlad closed 5 years ago

arjavlad commented 5 years ago

var query = getTable().filter(expressionStatus != 81).filter(expressionDueDate <= today || expressionStartDate <= today)

query.asSQL() gives me this query. SELECT * FROM "AIRISDLTask" WHERE (("status" !=(::) 81) AND (("dueDate" <=(::) '2019-03-26T12:31:38.356') OR ("startDate" <=(::) '2019-03-26T12:31:38.356')))

When this query is executed it returns error:

[logging] near ":_": syntax error

I'm using latest pods and Xcode 10.2

tanzolone commented 5 years ago

Duplicate of #888