Icon View Incident Report

Serious Serious
Reported By: Iztok Lajovic
Reported On: 10/6/2004
For: Version 4.12 Build 1
# 1855 IN Sub-Queries Not Being Executed Properly When RequestLive=True

The following SQL works if request live is set to false but in the case that request live is set to true it doesn't.

select * from zapr
where ident not in (select idvira from virm)

Comments Comments and Workarounds
Workaround is to not use RequestLive=True. The above sub-query should have made the query generate a canned result set, but it was not, and this was causing a problem with completing the query.

Resolution Resolution
Fixed Problem on 10/12/2004 in version 4.13 build 1