[sqlite] index broken by insert

From: Roman Fleysher Sent: Tuesday, May 19, 2015 3:48 PM To: General Discussion of SQLite Database Subject: RE: [sqlite] index broken by insert Dear Richard, Dear Simon, Dear SQLiters, It is such a pleasure to deal with smart people. Pure joy. How quickly Simon figured out the problem

[sqlite] index broken by insert

M (GMT-05:00) To: General Discussion of SQLite Database Subject: Re: [sqlite] index broken by insert On 5/19/15, Roman Fleysher wrote: > CREATE TRIGGER demographicInsert AFTER INSERT ON subject FOR EACH ROW BEGIN > INSERT INTO Exam (subjectID, examID, examType) VALUES (NEW.subjectID, >

[sqlite] index broken by insert

-- Dear SQLiters, -- Here is schema first, table is below, -- followed by offending statement. -- you can copy and paste the entire body -- my comments are SQL compatible - -- STEP 1 -- -- create gender and handedness tables to fix possible values -- then

[sqlite] index broken by insert

-bounces at mailinglists.sqlite.org] on behalf of Igor Korot [ikoro...@gmail.com] Sent: Tuesday, May 19, 2015 1:35 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] index broken by insert Hi, Roman, On Tue, May 19, 2015 at 1:23 PM, Roman Fleysher wrote: > "Confirmation&q

[sqlite] index broken by insert

_ From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at mailinglists.sqlite.org] on behalf of Roman Fleysher [roman.fleys...@einstein.yu.edu] Sent: Tuesday, May 19, 2015 12:25 PM To: General Discussion of SQLite Database Subject: [sqlite] index broken by insert Dear SQLiters, I

[sqlite] index broken by insert

Dear SQLiters, I do not really know what info to provide for sufficient information. I use SQLite shell only for all create/insert manipulations. This insert below causes PRAGMA integrity_check; to report missing index (what appears to be on every inserted row): SQLite version 3.8.8.3

[sqlite] index broken by insert

On 5/19/15, Roman Fleysher wrote: > > How will i know the patch/new version is available? By checking ticket > link? > Version 3.8.10.2 will appear on https://www.sqlite.org/download.html It takes about 16 hours to run a full test cycle of SQLite on Linux and Windows, which is the minimum

[sqlite] index broken by insert

On 5/19/15, Roman Fleysher wrote: > CREATE TRIGGER demographicInsert AFTER INSERT ON subject FOR EACH ROW BEGIN > INSERT INTO Exam (subjectID, examID, examType) VALUES (NEW.subjectID, > NEW.subjectID, 'demographicExam'); Your workaround is to change the insert into examID to cast it to type

[sqlite] index broken by insert

Trouble ticket is here: https://www.sqlite.org/src/tktview/34cd55d68e On 5/19/15, Roman Fleysher wrote: > -- Dear SQLiters, > > -- Here is schema first, table is below, > -- followed by offending statement. > -- you can copy and paste the entire body > -- my comments are SQL compatible > >

[sqlite] index broken by insert

On 5/19/15, Roman Fleysher wrote: > Yes, I can provide full schema and data set. As far as I remember this > mailing list does not accept attachments. Would that be OK to send in body > of email? It is not that big. > Yes, please. Send in the body of the email. -- D. Richard Hipp drh at

[sqlite] index broken by insert

___ > From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces > at mailinglists.sqlite.org] on behalf of Roman Fleysher [roman.fleysher at > einstein.yu.edu] > Sent: Tuesday, May 19, 2015 12:25 PM > To: General Discussion of SQLite Database > Subject: [sqlite] index broke