Ticket for this problem is here: http://www.sqlite.org/src/info/002caede89
On Thu, Sep 15, 2011 at 10:21 AM, Filip Navara <filip.nav...@gmail.com>wrote: > Hi, > > there's a bug report filled at > > http://system.data.sqlite.org/index.html/info/ce53939214b563cb49ad2375f7c2cb365907898d > for System.Data.SQLite, but the underlying issue is reproducible with > the same database on SQLite 3.7.7.1 and my recent builds of SQLite > 3.7.8. Both crash with access violation. "pragma integrity_check;" > returns ok for the database. > > The database file is linked in the ticket and the query is > > SELECT invItemID, storageLocationID, responsiblePersonID, deviceID, > costCenterID, COALESCE(changeSuggCount, 0) AS changeSuggCount, > containerInvItemID > FROM InvItem > LEFT OUTER JOIN > ( > SELECT iicsID, invItemID AS iiID, COUNT(*) AS changeSuggCount FROM > InvItemChangeSuggestion > GROUP BY iiID > ) AS ChangeSugg ON ChangeSugg.iiID = InvItem.invItemID > LEFT OUTER JOIN > ( > SELECT iicsID AS iicsID2, propID, val FROM > InvItemPropValueChangeSuggestion > WHERE (propID = -4) > AND (val = 'AB123987') > ORDER BY apprVersion DESC > LIMIT 1 > ) AS PropValChangeSugg ON PropValChangeSugg.iicsID2 = ChangeSugg.iicsID > WHERE > (rowStatus = 1 AND (val = 'AB123987')) > OR ((invVersionID = 1) > AND (rowStatus = 1) > AND invItemID IN > ( > -- ha eredetileg illeszkedik a filter-re > SELECT invItemID FROM InvItem > WHERE (barCode = 'AB123987') > AND (invVersionID = 1) > AND (rowStatus = 1) > > UNION > > -- ha a m«¯dos«ìt«âsok ut«ân a(z) barCode illeszkedik a filter-re > SELECT invItemID FROM > ( > SELECT invItemID, val FROM > ( > SELECT invItemID, propID, val > FROM InvItemChangeSuggestion, InvItemPropValueChangeSuggestion > WHERE InvItemChangeSuggestion.iicsID = > InvItemPropValueChangeSuggestion.iicsID > AND propID = -4 > AND apprVersion <> 0 > ORDER BY registerTime ASC > ) > GROUP BY invitemID, propID > ) > WHERE (val = 'AB123987') > > EXCEPT > > -- a(z) barCode eredetileg illeszkedett, de a m«¯dos«ìt«âsok ut«ân > m«âr nem illeszkedik a filter-re > SELECT invItemID FROM > ( > SELECT invItemID, val FROM > ( > SELECT invItemID, propID, val > FROM InvItemChangeSuggestion, InvItemPropValueChangeSuggestion > WHERE InvItemChangeSuggestion.iicsID = > InvItemPropValueChangeSuggestion.iicsID > AND propID = -4 > AND apprVersion <> 0 > ORDER BY registerTime ASC > ) > GROUP BY invitemID, propID > ) > WHERE (val <> 'AB123987') > )); > > Best regards, > Filip Navara > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
