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
This may sound crazy, but is there a way to compile SQLite without its B-tree
and table code? This would be for a use case with _only_ virtual tables — i.e.
SQLite being used as a SQL query engine on top of a different data store*. It
would be nice not to drag in too much unused code.
—Jens
*
On 20/12/62 22:03, test user wrote:
Hello,
I have a search box on a website that uses FTS5/MATCH.
MATCH seems to take its own custom language for matching.
1. Is it safe to just pass the users query to MATCH ? via the SQLite bind
FFI?
Users could specify a query that uses excessive resource
On Saturday, 21 December, 2019 03:27, Thomas Kurz
wrote:
>I have a problem when opening a read-only database, which is a WAL-mode
>database.
>When trying to open it in read-only mode, i.e. using
>file:test.sqlite?mode=ro, SHM and WAL file are created. That's
>unpleasant, but the actual problem
On 21 Dec 2019, at 11:12am, Thomas Kurz wrote:
>> Do the same thing again without the mode=ro
>> Do the files get deleted this time ?
>
> No, this shows the same behavior, but in this case, it's actually what I'd
> expect.
Your problem would seem to be related to all WAL operations, not just r
On 16/12/2019 13:38, carsten.muencheberg wrote:
> I am working on a generic cache for prepared statements
I really wish SQLite had a statement cache behind the scenes, so that
devs don't have to keep re-implementing a statement cache. I would be
delighted to delete the statement cache code in AP
Yeh but it doesn’t explicitly say anything about how secure it is to pass a
string directly to “match”.
Other scalar values that are passed to a query via binding are safe as they
are just data saved to the DB file.
But as the MATCH x string contains a language it is going to be interpreted
or co
> Do the same thing again without the mode=ro
> Do the files get deleted this time ?
No, this shows the same behavior, but in this case, it's actually what I'd
expect.
> Does the program have enough privs over the database file's folder ?
Yeah, sure, actually the file's on a FAT32 drive.
_
On 21 Dec 2019, at 10:27am, Thomas Kurz wrote:
> Result: SHM and WAL files are kept.
Do the same thing again without the mode=ro
Do the files get deleted this time ?
Does the program have enough privs over the database file's folder ?
___
sqlite-user
I have a problem when opening a read-only database, which is a WAL-mode
database.
When trying to open it in read-only mode, i.e. using file:test.sqlite?mode=ro,
SHM and WAL file are created. That's unpleasant, but the actual problem is the
two files don't get deleted when closing the database.
14 matches
Mail list logo
