Icon View Incident Report

Serious Serious
Reported By: Heiko Knuettel
Reported On: 7/16/2008
For: Version 2.01 Build 1
# 2706 EXISTS Operator Can Cause Incorrect Scalar Sub-Query Error

I tried translating the following DBISAM query to an EDB version of the same query, and get the error message:

An error occurred with the query SELECT ALL "sonder" AS "sonder" FROM "memory"."pestizide" AS "y" WHERE "y"."aufnr" = "x"."aufnr" AND "y"."probenr" = "x"."probenr" AND "y"."sonder" IS NOT NULL (A scalar query can only return a single value)


update memory.pestaufarb x set sonder=y.sonder 
from memory.pestaufarb x 
inner join memory.pestizide y on (y.aufnr=x.aufnr) and (y.probenr=x.probenr)
where y.sonder <> null


update memory.pestaufarb x set sonder=
   (select sonder from memory.pestizide y where y.aufnr=x.aufnr and y.probenr=x.probenr)
where exists
   (select sonder from memory.pestizide y where y.aufnr=x.aufnr and y.probenr=x.probenr
and y.sonder is not null)

Resolution Resolution
Fixed Problem on 7/19/2008 in version 2.01 build 2

Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial