Courious (I think this worked on previous versions):

This query returns 1 row:

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'

This query raises "#401 The column FacturarA does not exist":

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

due CLIENTE AS FACTURARA is not valid for "WHERE FacturarA = 'G07682735'"

Then this UNION should return the same error:

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

but it runs ok and returns 1 row from MAEXPEDI plus ALL rows in MAFACTU

Tiago,

<< Then this UNION should return the same error: >>

Yes, it is not issuing an exception as needed.  I'll have a fix in the next
build.

--
Tim Young
Elevate Software
www.elevatesoft.com