Re: [sqlite] crash dropping table

2018-04-18 Thread Simon Slavin
On 18 Apr 2018, at 5:59pm, Mark Wagner wrote: > I will try to produce a repro case that I can share out (the database I was > testing on has lots of personal data that I will first try to delete). Before you do anything else to it, make a copy and use the SQLite shell to do PRAGMA integri

Re: [sqlite] crash dropping table

2018-04-18 Thread Mark Wagner
I will try to produce a repro case that I can share out (the database I was testing on has lots of personal data that I will first try to delete). Thanks for the responses. @David Note that those weren't the precise commands (i.e. drop command was "drop table x;"). On Wed, Apr 18, 2018 at 9:56

Re: [sqlite] crash dropping table

2018-04-18 Thread Simon Slavin
On 18 Apr 2018, at 4:47pm, Mark Wagner wrote: > I have a simple test case wherein I delete from a number of tables and then > drop one of those tables. This crashes sqlite3. > > So something like this: > > begin; > delete from x; > delete from y; > delete from z; > drop x; << crashes here >

Re: [sqlite] crash dropping table

2018-04-18 Thread David Raymond
crash) What journal mode is the database using? Etc... -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Mark Wagner Sent: Wednesday, April 18, 2018 11:48 AM To: SQLite mailing list Subject: [sqlite] crash dropping table I have a simp

Re: [sqlite] crash dropping table

2018-04-18 Thread Richard Hipp
On 4/18/18, Mark Wagner wrote: > I have a simple test case wherein I delete from a number of tables and then > drop one of those tables. This crashes sqlite3. > > So something like this: > > begin; > delete from x; > delete from y; > delete from z; > drop x; << crashes here Can you send in a re

Re: [sqlite] crash dropping table

2018-04-18 Thread Kees Nuyt
On Wed, 18 Apr 2018 15:47:47 +, Mark Wagner wrote: > Sorry for my ignorance but is there a procedure for > submitting bugs for things like this? The procedure is to mail bugs to this mailing list, including version info, so you did exactly the right thing. -- Regards, Kees Nuyt ___

[sqlite] crash dropping table

2018-04-18 Thread Mark Wagner
I have a simple test case wherein I delete from a number of tables and then drop one of those tables. This crashes sqlite3. So something like this: begin; delete from x; delete from y; delete from z; drop x; << crashes here Sorry for my ignorance but is there a procedure for submitting bugs fo