On Wed, Mar 6, 2013 at 3:49 PM, Nico Williams <n...@cryptonector.com> wrote: > On Wed, Mar 6, 2013 at 3:47 PM, Petite Abeille <petite.abei...@gmail.com> > 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users