On 17 Aug 2015, at 5:08pm, Olivier Barthelemy <barthelemy at geovariances.com> wrote:
> As stated in the second question of my first message, shouldn't there be > some check in sqlite that the type in the constraints are compatible with > the fields, with an error at table creation? SQLite allows what was done, on purpose. For compatibility with other SQL engines. The problem lies with the programmer who used a SQLite type of BOOLEAN but then allowed comparisons with strings. Or if that SQL code was done automatically by some library or framework, the person who wrote that. Simon.