Re: [sqlite] Inconsistency in the treatment of numbers?

On Thu, Jun 04, 2009 at 02:14:19PM -0700, PFudd scratched on the wall: > Hi.. > > I'm not sure if I've found a bug or not. I've created a table like so: > > CREATE TABLE desc (number primary key, full_line); Lacking a type, the affinity will be NONE. That means no conversion will be done.

[sqlite] Inconsistency in the treatment of numbers?

Hi.. I'm not sure if I've found a bug or not. I've created a table like so: CREATE TABLE desc (number primary key, full_line); Then I've loaded it with taxonomy numbers from NCBI (where "9606" means "Homo Sapiens", for instance). sqlite> select * From desc where number="9606"; 9606|Homo