On 6 Sep 2017, at 11:31pm, Cecil Westerhof <cldwester...@gmail.com> wrote:

> 2017-09-07 0:20 GMT+02:00 Richard Hipp <d...@sqlite.org>:
>> On 9/6/17, Cecil Westerhof <cldwester...@gmail.com> wrote:
>>> Maybe this is correct, but it is certainly confusing.
>> The constraint check occurs before the implicit conversion.
> ​Should that not be the other way around?

This is an important point.  But I’d say not.  Constraint checks are there to 
make sure that the programmers are doing the Right Thing, not that the DBMS is 
doing the Right Thing.  So it’s the source value which is checked, not the 
value stored in the database.

To do it the other way around suggests that SQLite needs to check that SQLite 
is doing the Right Thing, which would be a waste of cycles, and a sign that the 
developers need to consult a psychiatrist.

sqlite-users mailing list

Reply via email to