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
