On 30 Jun 2018, at 8:58pm, Wout Mertens <[email protected]> wrote:
> Hmm, very odd. I'll need to check what happened again. Pay a lot of attention to the type you supplied when you created the table. The post you're responding to has this line: > sqlite> create table x(x primary key); This does not supply a type for the column. There could be all sorts of weird things going on. Do the same thing but with TEXT sqlite> create table x(x TEXT primary key); and you're more likely to be able to predict what happens. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

