Re: [sqlite] Segmentation fault running a query

2019-03-06 Thread Richard Hipp
This is another example of the problem described by ticket https://www.sqlite.org/src/info/df46dfb631f75694 which is fixed in version 3.27.2. On 3/5/19, Peter Hardman wrote: > If i run the following query from Python 3.7 using the sqlite3 DBAPI > adapter or from sqlitebrowser I get a

Re: [sqlite] Segmentation fault running a query

2019-03-06 Thread Richard Hipp
On 3/6/19, Peter Hardman wrote: > > I've attached the database file (300K). > Attachments are stripped by the mailing list. Please send via private email directly to me. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Segmentation fault running a query

2019-03-06 Thread Peter Hardman
ma 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, Pet

Re: [sqlite] Segmentation fault running a query

2019-03-06 Thread Dan Kennedy
19 3:14 PM To: SQLite mailing list Subject: Re: [sqlite] Segmentation fault running a query On 5 Mar 2019, at 8:06pm, Peter Hardman 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 faul

Re: [sqlite] Segmentation fault running a query

2019-03-06 Thread Keith Medcalf
chard Hipp >Sent: Wednesday, 6 March, 2019 04:31 >To: SQLite mailing list >Subject: Re: [sqlite] Segmentation fault running a query > >On 3/6/19, Peter Hardman wrote: >> >> The schema (of a very much cut down database) is attached. > >I translated the attached sc

Re: [sqlite] Segmentation fault running a query

2019-03-06 Thread Richard Hipp
On 3/6/19, Peter Hardman wrote: > > The schema (of a very much cut down database) is attached. I translated the attached schema into SQL and appended the query. I uploaded the result to https://sqlite.org/tmp/peter-hardman-001.txt I have run the resulting script through every version of SQLite

[sqlite] Segmentation fault running a query

2019-03-06 Thread Peter Hardman
- 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 wrote: > If i

Re: [sqlite] Segmentation fault running a query

2019-03-05 Thread David Raymond
: [sqlite] Segmentation fault running a query On 5 Mar 2019, at 8:06pm, Peter Hardman 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

Re: [sqlite] Segmentation fault running a query

2019-03-05 Thread Simon Slavin
On 5 Mar 2019, at 8:06pm, Peter Hardman 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

[sqlite] Segmentation fault running a query

2019-03-05 Thread Peter Hardman
If i run the following query from Python 3.7 using the sqlite3 DBAPI adapter or from sqlitebrowser I get a segmentation fault. The query runs error free on PostgreSQL 9.6 The query fails if the 'in' list has more than two entries. Any ideas? I could create a test database but it will take a