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