On Sun, May 12, 2013 at 7:55 AM, Tomasz Pawlak < tomasz.paw...@cs.put.poznan.pl> wrote:
> > So, type of '1' is 'text'. > > * If one operand has INTEGER, REAL or NUMERIC affinity and the other > operand as TEXT or NONE affinity then NUMERIC affinity is applied to other > operand. " > > So, if we compare 1 with '1' (e.g. 1='1'), '1' should be converted to > numeric, right? > No. '1' has type 'text' but it has no affinity at all. Likewise 1 has type 'integer' but no affinity. So no conversions take place, and the answer is FALSE. Affinity is only associated with table columns. Literals never have affinity. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users