Dear SQLiters,
I can not figure out what I am doing wrong. In testing, I simplified to the following: CREATE TABLE cosSquared(refVolume INT, vecVolume INT, cosSquared REAL); SELECT refVolume, CAST(10*max(cosSquared) AS INT) FROM cosSquared GROUP BY refVolume; refVolume CAST(10*max(cosSquared) AS INT) ---------- ------------------------------- 2 9 3 9 4 9 5 9 ............. 31 9 32 9 33 9 That is, we see that for refVolumes between 2 and 33, the value of the CAST() is always 9. Thus, I expect the following statement to output the same list of refVolumes. But it does not: SELECT DISTINCT refVolume FROM cosSquared WHERE (refVolume, CAST(10*cosSquared AS INT)) = (SELECT refVolume, 9 FROM cosSquared); refVolume ---------- 2 What am I doing wrong? I am using version 3.16. Thank you for your help, Roman _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
