bug report on psql odbc 9.01.02.00 ( seems beeing there since 9.00.03.10 )

From: JOUBERT Renaud <renaud(dot)joubert(at)smatis(dot)fr>
To: pgsql-odbc(at)postgresql(dot)org
Subject: bug report on psql odbc 9.01.02.00 ( seems beeing there since 9.00.03.10 )
Date: 2012-11-30 13:16:20
Message-ID: 2146113297.1517076.1354281380653.JavaMail.root@srv1mail.smatis.mut
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc


Hello,

i want to report a bug on psql odbc 9.01.02.00 ( seems beeing there since 9.00.03.10 )
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

www.smatis.fr
Renaud JOUBERT - Administrateur BD - Pôle fonctionnel
6 à 14 rue du Piave
16920 Angoulême cedex 09
renaud(dot)joubert(at)smatis(dot)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

Browse pgsql-odbc by date

  From Date Subject
Next Message Копыченко Павел 2012-12-06 18:08:53 Very slow perfomance for selecting big data resultsets.
Previous Message Tom Evans 2012-11-20 23:06:02 Re: [psqlodbc-Bugs][1011246] Windows 2012 64bit ODBC Administrator crashes