On 3 January 2013 17:24, Andrea Zagli <aza...@libero.it> wrote:
> libgda change the following sql statement
>
>
> SELECT p.pr_cod_prat, p.pr_prat_num1, p.pr_prat_num2, p.pr_prat_num3,
> p.pr_dat_fin, pr.gi_num_provv2, pr.gi_dat_ini,
> COALESCE (p.pr_prat_desc || '\n', '') || COALESCE (n.pr_prat_note1, '') ||
> COALESCE (n.pr_prat_note2, '') || COALESCE (n.pr_prat_note3, '') ||
> COALESCE (n.pr_prat_note4, '') AS note,
> s.gi_dat_ini AS data_vendita,
> r.gi_dat_sca
> FROM m1_tabpr_prat p
> LEFT JOIN gi_tab_stopr s ON p.pr_cod_prat = s.pr_prat_succ
> LEFT JOIN m1_tabpr_note n ON p.pr_cod_prat = n.pr_cod_prat
> LEFT JOIN gi_tab_provv pr ON p.pr_cod_prat = pr.pr_cod_prat
> LEFT JOIN gi_tab_provril r ON pr.gi_num_provv1 = r.gi_num_provv1
> AND pr.gi_num_provv2 = r.gi_num_provv2 AND pr.gi_num_provv3 =
> r.gi_num_provv3
> WHERE p.pr_prat_num1 IN ('AMB', 'IAMB')
> AND s.pr_cod_prat IS NULL
> AND (pr.gi_num_provv1 = 'AUTAM' OR pr.gi_seq_provv IS NULL)
> ORDER BY p.pr_prat_num3, p.pr_prat_num2
>
>
> removing parenthesis on penultimate line
>
> i'm using libgda from git branch 4.2
>
Hi!
The problem is not present with the current git's master branch (which will
hopefully soon be version 5.2): if you run the example attached program,
you'll get the following output which shows the bug is not there:
$ ./test
SELECT
p.pr_cod_prat,
p.pr_prat_num1,
p.pr_prat_num2,
p.pr_prat_num3,
p.pr_dat_fin,
pr.gi_num_provv2,
pr.gi_dat_ini,
(COALESCE ((p.pr_prat_desc || '
'), '') || COALESCE (n.pr_prat_note1, '') || COALESCE (n.pr_prat_note2, '')
|| COALESCE (n.pr_prat_note3, '') || COALESCE (n.pr_prat_note4, '')) AS
note,
s.gi_dat_ini AS data_vendita,
r.gi_dat_sca
FROM m1_tabpr_prat AS p
LEFT JOIN gi_tab_stopr AS s ON ((p.pr_cod_prat = s.pr_prat_succ))
LEFT JOIN m1_tabpr_note AS n ON ((p.pr_cod_prat = n.pr_cod_prat))
LEFT JOIN gi_tab_provv AS pr ON ((p.pr_cod_prat = pr.pr_cod_prat))
LEFT JOIN gi_tab_provril AS r ON (((pr.gi_num_provv1 = r.gi_num_provv1)
AND (pr.gi_num_provv2 = r.gi_num_provv2) AND (pr.gi_num_provv3 =
r.gi_num_provv3)))
WHERE (p.pr_prat_num1 IN ('AMB', 'IAMB')) AND (s.pr_cod_prat IS NULL) AND
((pr.gi_num_provv1 = 'AUTAM') OR (pr.gi_seq_provv IS NULL))
ORDER BY p.pr_prat_num3 ASC, p.pr_prat_num2 ASC
I suggest you use a more recent version of Libgda.
Regards,
Vivien
bugtester.txz
Description: Binary data
_______________________________________________ gnome-db-list mailing list gnome-db-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnome-db-list
