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

Reply via email to