Hi all, I'm a new user to sqlite (I just compiled sqlite-autoconf-3070400 on cygwin), and am running into what seems to be a bad interaction between type affinity and integer comparisons.
I'm importing a csv file full of single-digit integer values into a table which .schema reports as "CREATE TABLE numbers(num INTEGER);" As far as I can understand from the documentation, the imported values can be losslessly and reversibly converted to INTEGER, but comparison operations (=, in, natural join) against other integers fail until I do "UPDATE numbers SET num=0+num;" Is this working as designed and I'm missing something obvious about the type system, or is this a bug? Thanks, Ryan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users