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 while as it
has personal information in which I would have to obfuscate to avoid
falling foul of the GDPR.
select m.member_no, p.title, p.initials, p.forename, p.surname,
m.address_1, m.address_2, m.address_3, m.post_town, m.county,
m.post_code, m.country, s.class_name, m.joined, s.renewed,
s.expires, s.pmt_method, m.non_renewal, m.share_info,
m.last_changed, p.person_id, r.region
from person p join mem_pers mp on p.person_id = mp.person_id
join member m on mp.member_no = m.member_no
join current_member_status s on m.member_no = s.member_no
left join in_region r on m.county = r.county
join mem_dates d on s.expires > d.renewal_date where m.non_renewal = ''
and p.person_id in
order by m.country, m.county, p.surname, p.initials
And if it does still crash, please provide the database schema to help with debugging.
From: sqlite-users [mailto:[hidden email]] 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 3/5/19, Peter Hardman <[hidden email]> wrote:
> 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?