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

Reply via email to