On 18 February 2016 at 15:29, Richard Hipp <drh at sqlite.org> wrote: > On 2/18/16, Simon Davies <simon.james.davies at gmail.com> wrote: >> > > The documentation says: "An expression of the form "CAST(expr AS > type)" has an affinity thta is the same as a column with a declared > type of "type".". Since the RHS of the <= operator now has affinity, > that affinity is applied to the LHS operand as well, resulting in both > operands being treated as integers for the purpose of the comparison. > -- > D. Richard Hipp
I was aware that CAST produces affinity as quoted, but not that a literal integer does not... What is the affinity of a literal integer? I have had a quick search through the documentation but did not find anything. Regards, Simon
