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,
--
Larry Brasfield
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users