On 3/5/2016 7:48 AM, Paul van Helden wrote: > SELECT * FROM tleft, tright WHERE Txt=Flt; -- returns a match! > > Is it because of the following from https://www.sqlite.org/datatype3.html
No. It is because Flt has REAL affinity, but 1.0 has no affinity. You can use CAST to explicitly give it one: SELECT * FROM test WHERE A = CAST(1.0 as REAL); -- returns 1. See also: https://www.sqlite.org/datatype3.html#compaff -- Igor Tandetnik
