Re: [sqlite] Problem importing integers from csv

2010-12-09 Thread Ryan Johnson
On 12/9/2010 6:46 PM, Simon Slavin wrote: > On 10 Dec 2010, at 12:20am, Ryan Johnson wrote: > >> On 12/9/2010 4:56 PM, Igor Tandetnik wrote: >>> On 12/9/2010 6:42 PM, Ryan Johnson wrote: create table a(x,y INTEGER); >>> This creates a table with column x having no affinity, and column y >>>

Re: [sqlite] Problem importing integers from csv

2010-12-09 Thread Simon Slavin
On 10 Dec 2010, at 12:20am, Ryan Johnson wrote: > On 12/9/2010 4:56 PM, Igor Tandetnik wrote: >> On 12/9/2010 6:42 PM, Ryan Johnson wrote: >>> create table a(x,y INTEGER); >> This creates a table with column x having no affinity, and column y >> having integer affinity. Is this what you meant? >

Re: [sqlite] Problem importing integers from csv

2010-12-09 Thread Igor Tandetnik
On 12/9/2010 7:20 PM, Ryan Johnson wrote: > In general, is "1"=1 ever true? With all the talk of dynamic typing, > etc. I would have expected so, but now I wonder... '1'=1 is of course false. But '1'=x, where x is a column having integer affinity and value 1, is true. -- Igor Tandetnik

Re: [sqlite] Problem importing integers from csv

2010-12-09 Thread Ryan Johnson
On 12/9/2010 4:56 PM, Igor Tandetnik wrote: > On 12/9/2010 6:42 PM, Ryan Johnson wrote: >> create table a(x,y INTEGER); > This creates a table with column x having no affinity, and column y > having integer affinity. Is this what you meant? Doh! That explains why I couldn't repro with only a

Re: [sqlite] Problem importing integers from csv

2010-12-09 Thread Igor Tandetnik
On 12/9/2010 6:42 PM, Ryan Johnson wrote: > create table a(x,y INTEGER); This creates a table with column x having no affinity, and column y having integer affinity. Is this what you meant? -- Igor Tandetnik ___ sqlite-users mailing list

Re: [sqlite] Problem importing integers from csv

2010-12-09 Thread Ryan Johnson
On 12/9/2010 4:10 PM, Simon Slavin wrote: > On 9 Dec 2010, at 11:04pm, Ryan Johnson wrote >> I'm a new user to sqlite (I just compiled sqlite-autoconf-3070400 on >> ), and am running into what seems to be a bad interaction between >> type affinity and integer comparisons. >> >> I'm importing

Re: [sqlite] Problem importing integers from csv

2010-12-09 Thread Simon Slavin
On 9 Dec 2010, at 11:04pm, Ryan Johnson wrote: > I'm a new user to sqlite (I just compiled sqlite-autoconf-3070400 on > ), 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

[sqlite] Problem importing integers from csv

2010-12-09 Thread Ryan Johnson
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