Re: [sqlite] Question regarding 3.23.0 (pending) and TRUE/FALSE

2018-03-02 Thread Richard Hipp
On 3/2/18, Olivier Mascia wrote: > is TRUE an alias to 1? Yes. Just to be clear, if it is possible to resolve TRUE to the name of a column in a table, then it will refer to that column. TRUE only becomes an alias for 1 if there is no other way to resolve the name. This is necessary for backward

Re: [sqlite] Question regarding 3.23.0 (pending) and TRUE/FALSE

2018-03-02 Thread Olivier Mascia
> Le 2 mars 2018 à 13:19, Richard Hipp a écrit : > >> Will insert into T values(FALSE) actually store integer 0 no matter column >> affinity or will it follow affinity? > > No. FALSE is merely an alias for 0. Affinity still applies. If the > column is of type TEXT, then it will store '0', not

Re: [sqlite] Question regarding 3.23.0 (pending) and TRUE/FALSE

2018-03-02 Thread Richard Hipp
On 3/2/18, J Decker wrote: > On Fri, Mar 2, 2018 at 4:19 AM, Richard Hipp wrote: > >> On 3/2/18, Olivier Mascia wrote: >> > >> > What values will be considered FALSE, and hence will TRUE be NOT FALSE >> > or >> > equality to some other specific value? >> >> I have a note to provide additional do

Re: [sqlite] Question regarding 3.23.0 (pending) and TRUE/FALSE

2018-03-02 Thread J Decker
On Fri, Mar 2, 2018 at 4:19 AM, Richard Hipp wrote: > On 3/2/18, Olivier Mascia wrote: > > > > What values will be considered FALSE, and hence will TRUE be NOT FALSE or > > equality to some other specific value? > > I have a note to provide additional documentation on this before the > release.

Re: [sqlite] Question regarding 3.23.0 (pending) and TRUE/FALSE

2018-03-02 Thread Richard Hipp
On 3/2/18, Olivier Mascia wrote: > > What values will be considered FALSE, and hence will TRUE be NOT FALSE or > equality to some other specific value? I have a note to provide additional documentation on this before the release. In short, a value is FALSE is, when converted into a floating poin

Re: [sqlite] Question regarding 3.23.0 (pending) and TRUE/FALSE

2018-03-02 Thread Clemens Ladisch
Olivier Mascia wrote: > What values will be considered FALSE 0, and they keyword "FALSE". FALSE is an alias for the integer 0. > and hence will TRUE be NOT FALSE or equality to some other specific value? What exactly do you mean with "be" and "equality"? The SQL = and IS operators work as speci

[sqlite] Question regarding 3.23.0 (pending) and TRUE/FALSE

2018-03-01 Thread Olivier Mascia
Dear, 3.23.0 (pending) cites: > • Recognize TRUE and FALSE as constants. (For compatibility, if there > are columns named "true" or "false", then the identifiers refer to the > columns rather than Boolean constants.) > • Support operators IS TRUE, IS FALSE, IS NOT TRUE, and IS NOT F