Re: [sqlite] IMPORT fails INTEGER column but lets same data sail through as INT

2013-03-20 Thread Richard Hipp
On Wed, Mar 20, 2013 at 8:37 AM, rol...@logikalsolutions.com < rol...@logikalsolutions.com> wrote: > In this case they should be exactly the same. Obviously it is a bug in > 3.7.9 > which got fixed in 3.7.15 > I cannot reproduce the problem in the official SQLite 3.7.9 either. Nor on 3.7.8 or 3

Re: [sqlite] IMPORT fails INTEGER column but lets same data sail through as INT

2013-03-20 Thread rol...@logikalsolutions.com
> On March 20, 2013 at 7:18 AM Simon Davies > wrote: > > > Makes absolutely no sense. INT and INTEGER should be exactly the same. For > > this limited set of data both should have worked. > > INT and INTEGER are not exactly the same: > http://www.sqlite.org/lang_createtable.html#rowid > > In ve

Re: [sqlite] IMPORT fails INTEGER column but lets same data sail through as INT

2013-03-20 Thread Simon Davies
On 19 March 2013 15:08, rol...@logikalsolutions.com wrote: > version 3.7.9 2011-11-01 00:52:41 > KUbuntu 12.04 LTS 32-bit > > ex1.sql > > CREATE TABLE table_ex1( > Groupid INTEGER PRIMARY KEY, > GroupName TEXT > ); > .separator '|' > .import ex1.csv table_ex1 > .quit > > ex1.csv > 1|NONE > 2|TWO >

Re: [sqlite] IMPORT fails INTEGER column but lets same data sail through as INT

2013-03-20 Thread Clemens Ladisch
rol...@logikalsolutions.com wrote: > sqlite> .read ex1.sql > Error: datatype mismatch Works for me with 3.7.15.2. > INT and INTEGER should be exactly the same. INTEGER PRIMARY KEY is a special case: http://www.sqlite.org/autoinc.html Regards, Clemens ___

[sqlite] IMPORT fails INTEGER column but lets same data sail through as INT

2013-03-20 Thread rol...@logikalsolutions.com
version 3.7.9 2011-11-01 00:52:41 KUbuntu 12.04 LTS 32-bit ex1.sql CREATE TABLE table_ex1( Groupid INTEGER PRIMARY KEY, GroupName TEXT ); .separator '|' .import ex1.csv table_ex1 .quit ex1.csv 1|NONE 2|TWO 3|THREE 4|FOUR 5|FIVE sqlite> .read ex1.sql Error: datatype mismatch sqlite> .quit ex2.s