On 21 Dec 2019, at 21:42, Michael Walker (barrucadu)
wrote:
> I'm not sure the attachment to my first email got through ...
Correct. The list strips them.
--
Cheers -- Tim
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http:/
The mailing list strips attachments, btw.
Anyways, looking at that, yeah, they're all text values:
sqlite> SELECT bookIsbn, typeof(bookIsbn) FROM books WHERE bookAuthor LIKE
'%Ambrose%';
bookIsbntypeof(bookIsbn)
--
0486280381 text
9781496030 text
9781496030 text
Hi Shawn,
Thanks for your response. Though that doesn't seem to be the case:
sqlite> select bookIsbn, typeof(bookIsbn) from books where bookIsbn =
"9781496030825";
9781496030825|text
sqlite> select bookIsbn, typeof(bookIsbn) from books where bookIsbn =
"9780099477310";
9780099477310|text
The
Without seeing your table definition, this is just a guess, but maybe the
duplicate keys are stored as different types, with the primary key column
having an affinity that doesn't force one particular storage class:
sqlite> CREATE TABLE test(id PRIMARY KEY);
sqlite> INSERT INTO test VALUES('12345'
Hi,
I've somehow ended up with a table which contains two records for the same
primary key - well actually I've got two primary keys like that, so I have four
records with two primary keys between them.
I've been unable to reproduce this from a clean database, so I attach my
database file to t
5 matches
Mail list logo