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
> 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
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
>
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
___
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
5 matches
Mail list logo