On Wed, Oct 30, 2019 at 11:26 AM Richard Hipp <d...@sqlite.org> wrote:
> On 10/29/19, Keith Medcalf <kmedc...@dessus.com> wrote: > > > > Before you change anything, I think that is incorrect for the various > > datetime functions. I think they SHOULD be permitted in CHECK > constraints > > and in generated always columns, whether those are stored or virtual, > > whether or not parameters are given since they are constant. They should > > not be permitted in indexes however unless they are pure (deterministic). > > i believe the purpose of a CHECK constraint is declare an eternal > truth about the database content, not merely something that was true > at the point in time when the content was first inserted. Am I wrong? > The kind of CHECK constraint Keith mentioned would run afoul of https://www.sqlite.org/pragma.html#pragma_integrity_check so you're probably right that allowing these non-deterministic function is not a good idea (on 2nd thought...) --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users