After dumping the database I found that the line of insertion looks like this
INSERT INTO "repetition" VALUES(617,X'323031322D31322D32332031393A33303A3436',X'30',X'323031322D31322D32332031393A33303A3436',0,1,1,0); Does SQLite manage the insertion with hexadecimal characters? On 12/23/2012 09:19 PM, Larry Brasfield wrote: > Patrik Nilsson wrote: >> > What do you get with query >> > select * from repetition where cast(interval as integer)==0 and >> > interval>0 >> >> "select * from repetition where cast(interval as integer)==0 and >> interval>0 and id=617" >> >> With this I get the same as the strange one. Without "id=617" it is >> still selected. > > This boils the probable possibilities down to: > 1. Your "interval" column for that row contains a real number greater > than zero which is rendered, perhaps by the column's type affinity, to > integer 0; or > 2. SQLite is broken in a very basic way that only you have encountered > and brought here. > > My money is on #1. > > You might to a table dump using the SQLite shell to see which case it is. > > Cheers, _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
