bug report on psql odbc 9.01.02.00 ( seems beeing there since 9.00.03.10 ) - Mailing list pgsql-odbc
Hello,
odbs 9.01.02.00 parses subqueries incorrectly :
SELECT DISTINCT G_T0.personne_uid ,
G_T0.personne_num ,
G_T0.personne_eid|| TO_CHAR(1, '9999999999') ,
substr(md5(to_char(random()*1000000,'999999')),1,6)
FROM public.data_personne G_T0 INNER JOIN (SELECT G_T3.contrat_assure_uid AS G_F1
FROM public.data_contrat G_T3,
public.dim_contrat_nature G_T4,
public.dim_contrat_statut G_T5
WHERE ( G_T5.contrat_statut_uid = G_T3.contrat_statut_uid )
AND ( G_T4.contrat_nature_uid = G_T3.contrat_nature_uid )
AND ( G_T4.contrat_nature_eid = 'S' AND G_T3.contrat_eid NOT LIKE '%groupe' AND ( G_T5.contrat_statut_eid IN ('in_force' , 'pending_1' ) OR G_T3.contrat_date_resiliation IS NULL OR G_T3.contrat_date_resiliation >= NOW() )
) G_T2
ON G_T2.G_F1 = G_T0.personne_uid } LEFT OUTER JOIN public.data_espace_client_internet G_T1
ON G_T0.personne_uid = G_T1.espace_client_internet_personne_uid
WHERE G_T1.espace_client_internet_uid IS NULL
give now the error "subquery in FROM must have an alias"
It was perfectly execute with the old version 8.03.04.00
 | Renaud JOUBERT - Administrateur BD - Pôle fonctionnel 6 à 14 rue du Piave 16920 Angoulême cedex 09 renaud.joubert@smatis.fr Tel : 05 45 39 36 35 Fax : 05 45 39 36 39 |
 | Pensez à l'environnement avant d'imprimer ce message / Think about the environment before printing |
pgsql-odbc by date: