Simon Slavin-3 wrote: > > > >> sqlite> select * from ip_domain_table where ttl < 9999999999 limit 1; >> 107.35.138.41|127.2.0.2|1266895619 > > Although you have defined your column type as INTEGER, it's possible that > you have some values in that column which are of other types. Even the > record you show may have been put into the file with '1266895619' > representing a TEXT value. I believe that a text value would not satisfy > your WHERE clause in a consistent manner. > > Can you try something like > > SELECT ttl,typeof(ttl) FROM ip_domain_table WHERE ttl < 9999999999 LIMIT > 10 > >
sqlite> SELECT ttl,typeof(ttl) FROM ip_domain_table WHERE ttl < 9999999999 LIMIT 10 ...> ; 1266895620|integer 1266895620|integer 1266895620|integer 1266895639|integer 1266895639|integer 1266895638|integer 1266895638|integer 1266895653|integer 1266895654|integer 1266895653|integer -- View this message in context: http://old.nabble.com/sqlite3-delete-does-not-delete-everything--tp27865654p27866048.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users