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
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 |