Icon View Incident Report

Serious Serious
Reported By: Tiago Ameller
Reported On: 3/16/2009
For: Version 2.02 Build 10
# 2958 UNIONed SELECT Statements Not Binding Column References Properly

The following query should raise an exception due CLIENTE AS FACTURARA is not valid for "WHERE FacturarA = 'G07682735'", but it runs ok and returns 1 row from MAEXPEDI plus ALL rows in MAFACTU.

SELECT   0 AS TIPO,   ANO AS ANO_SERIE,   CODIGO,   FECHA,   ASUNTO,   SERIE,   FACTURA,   FECHAFACTURA,   HISTORICO,   FACTURARA,   
AVISOSYCOBROS,   TOTALFACTURA,   TOTALFACTURA - COBRADOCUENTA AS PENDIENTE,   IF(FECHAANULACION IS NULL,FALSE,TRUE) AS 
ANULADO FROM MAEXPEDI
WHERE FacturarA = 'G07682735'
UNION
SELECT   1 AS TIPO,   SERIE AS ANO_SERIE,   CODIGO,   FECHA,   ASUNTO,   SERIE,   CODIGO AS FACTURA,   FECHA AS FECHAFACTURA,   
HISTORICO,   CLIENTE AS FACTURARA,   AVISOSYCOBROS,   TOTALFACTURA,   TOTALFACTURA - COBRADOCUENTA AS PENDIENTE,   IF
(FECHAANULACION IS NULL,FALSE,TRUE) AS ANULADO FROM MAFACTU 
WHERE FacturarA = 'G07682735'
ORDER BY FECHA DESC



Comments Comments
The columns in the UNIONed query were being bound to the first query's FROM tables instead of the UNIONed query's FROM tables.


Resolution Resolution
Fixed Problem on 3/17/2009 in version 2.02 build 11


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 LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image