On 6/3/62 16:37, Peter Hardman wrote:
So, I forgot I had emails from the list turned off....
Integrity check shows no results.
The query fails from the CLI
The schema (of a very much cut down database) is attached.
Can you post the results of running the ".fullschema" command in the
shell tool?
Thanks,
Dan.
And if it does still crash, please provide the database schema to help
with debugging.
-----Original Message-----
From: sqlite-users [mailto:sqlite-users-bounces at
mailinglists.sqlite.org] On Behalf Of Simon Slavin
Sent: Tuesday, March 05, 2019 3:14 PM
To: SQLite mailing list
Subject: Re: [sqlite] Segmentation fault running a query
On 5 Mar 2019, at 8:06pm, Peter Hardman <peter at
somborneshetlands.co.uk> wrote:
> If i run the following query from Python 3.7 using the sqlite3 DBAPI
adapter or from sqlitebrowser I get a segmentation fault.
Please find the SQLite command-line tool on your computer. If you
don't already have one you can download one for your platform in the
section "Precompiled Binaries" on
<https://sqlite.org/download.html>
Using that program, please run
PRAGMA integrity_check;
If that reports no problems (should return no results) then please run
your SELECT query in that program just to verify that it gets the same
result your own code does.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users