On Wed, Mar 6, 2013 at 3:49 PM, Nico Williams <[email protected]> wrote: > On Wed, Mar 6, 2013 at 3:47 PM, Petite Abeille <[email protected]> > wrote: >> Indeed. Never mind :) > > Ah, your confusion comes from the fact that type conversion still > happens when the INSERT gets around to making the record. The CHECK > constraint happens before the record is made. See the vdbe that gets > generated.
Oh... I wonder if there's a guarantee of that, or if it'd be possible that in the future CHECK constraints might get post-type conversion values. But I think it'd be risky to ever make such a change. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
