I've corrected this bug, can you check with the master version if it's Ok
for you?
Vivien
On 23 January 2013 09:14, Andrea Zagli <aza...@libero.it> wrote:
> Il giorno mar 22 gen 2013 21:35:21 CET, Vivien Malerba ha scritto:
>
> On 22 January 2013 10:22, Vivien Malerba <vmale...@gmail.com> wrote:
>>
>>>
>>> On 22 January 2013 09:29, Andrea Zagli <aza...@libero.it> wrote:
>>>
>>> Il giorno mer 09 gen 2013 21:50:57 CET, Vivien Malerba ha scritto:
>>>>
>>>> [...]
>>>>>
>>>>> I suggest you use a more recent version of Libgda.
>>>>>
>>>>
>>>>
>>>> what files of branch 5.x could i copy to solve this problem?
>>>>
>>>>
>>> I'll locate the changes from Git and tell you tonight (UTC).
>>>
>>>
>> I checked with libgda 4.2 branch from git and there is no problem, the
>> output is exactely the same as the master branch. Can you check with the
>> test case code I've sent you?
>>
>
>
> yes, the test works... but if i exec the same query inside gda-browser
> (connected to oracle) the result is
>
> Really PREPARED: 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 ASC, p.pr_prat_num2 ASC
>
>
>
> PS: could the "really prepared" output be optional?
>
>
_______________________________________________
gnome-db-list mailing list
gnome-db-list@gnome.org
https://mail.gnome.org/mailman/listinfo/gnome-db-list
