2.0.599r3: Query that should work returns Unable to resolve the identifier"#t1"."ContratoId"

Hello there,

This query as far as I see is a valid one, but returns this error in the 2.0599r3 version.
The problem seems to be the LEFT JOINs, even if they don't (or shouldn't) affect the
only part where #t1.ContratoId is referenced. Changing them for JOIN "solves" the problem,
but doesn't return the correct resultset.

Query:

SELECT
Contratos.*
INTO #t1
FROM
Contratos
WHERE
Contratos.Numero = ?;

SELECT
#t1.*,
Clientes.*,
Agentes.*,
Agencias.*,
Comercializadoras.*,
TiposContrato.*,
FacturarA.ClaveCliente AS FacturarAClaveCliente,
FacturarA.NombreFiscal AS FacturarANombreFiscal,
FacturarA.RFC AS FacturarARFC,
FacturarA.Direccion AS FacturarADireccion,
(SELECT MIN(FechaInicial) FROM PautasContrato WHERE ContratoId = #t1.ContratoId) AS
FechaInicialContrato,
(SELECT MAX(FechaFinal) FROM PautasContrato WHERE ContratoId = #t1.ContratoId) AS
FechaFinalContrato,
UsuarioAlta.Clave AS ClaveUsuarioAlta,
PlanesFranceses.ClavePlan AS ClavePlanFrances,
PlanesFranceses.Descripcion AS DescripcionPlanFrances
FROM #t1
LEFT JOIN Clientes ON (Clientes.ClienteId = #t1.ClienteId)
LEFT JOIN Agentes ON (Agentes.AgenteId = #t1.AgenteId)
LEFT JOIN Agencias ON (Agencias.AgenciaId = #t1.AgenciaId)
LEFT JOIN Comercializadoras ON (Comercializadoras.ComercializadoraId =
#t1.ComercializadoraId)
LEFT JOIN TiposContrato ON (TiposContrato.TipoContratoId = #t1.TipoContratoId)
LEFT JOIN Clientes AS FacturarA ON (FacturarA.ClienteId = #t1.ClienteIdAFacturar)
LEFT JOIN Usuarios AS UsuarioAlta ON (UsuarioAlta.UsuarioId = #t1.UsuarioAlta)
LEFT JOIN PlanesFranceses ON (PlanesFranceses.PlanFrancesId = #t1.PlanFrancesId);

ErrorString: (thank's very much for the query logging capability!!!)

Unexpected exception object raised: [Exception] Error in statement: Unable to resolve the
identifier
"#t1"."ContratoId"<[--!þException.Class=Exceptionþ!--]><[--!þException.Message=Error in
statement: Unable to resolve the identifier "#t1"."ContratoId"þ!--]>

Changing the query to create a second temporary table, and getting those two values in
that third query, solves the issue, but I believe this should be fixed, or I'm doing
something incorrect here?

Regards,

--
Rodrigo Gómez [NDX]

"Rodrigo Gómez [NDX]" wrote:

> Hello there,
>
> This query as far as I see is a valid one, but returns this error in the
> 2.0599r3 version. The problem seems to be the LEFT JOINs, even if they

Known problem. Issues #2258 and #2254 (for left and right respectively). We're
just working on these.

--

Hannes Danzl [NexusDB Developer]
Newsgroup archive at http://www.tamaracka.com/search.htm

> Known problem. Issues #2258 and #2254 (for left and right respectively). We're
> just working on these.

Ok, thanks. Because this affects a lot of my queries... :-S

Regards,

--
Rodrigo Gómez [NDX]