> On March 20, 2013 at 7:18 AM Simon Davies <[email protected]> > 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 version 3.7.15.1 your example does not produce the "datatype mismatch" > error. > 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 Roland Hughes, President Logikal Solutions (630)-205-1593 - cell http://www.theminimumyouneedtoknow.com http://www.infiniteexposure.net _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

