[Libreoffice-bugs] [Bug 119569] Open Sub-Form causes PostgreSQL error

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119569

--- Comment #8 from Albrecht Dreß <albrecht.dress at arcor.de> ---
I changed the (In reply to robert from comment #6)
> ... and also tested with LO 6.0.5.2 and LO 6.0.0.1 on OpenSUSE 15, 64bit rpm
> Linux. Form with subform works.
> 
> When I see the error of the description and the statement here one question:
> Do you know where this comes from - "WHERE ( 0 = 1 )"?

Good question…  I changed the PGSql server setting to “log_statement = 'all'”. 
Opening the form (using my db example) triggers the following statements (only
those to my db; in addition, there is a bunch of queries to the PGSql control
tables):

LOG:  Anweisung: SELECT * FROM "public"."tab1" WHERE ( 0 = 1 )
LOG:  Anweisung: SELECT * FROM "public"."tab1" WHERE ( 0 = 1 )
LOG:  Anweisung: SELECT * FROM "public"."tab1"
LOG:  Anweisung: SELECT * FROM "public"."tab2" WHERE ( 0 = 1 )
LOG:  Anweisung: SELECT * FROM "public"."tab1" WHERE ( 0 = 1 )
FEHLER:  Syntaxfehler bei »:« bei Zeichen 82
ANWEISUNG:  SELECT * FROM "public"."tab2" WHERE ( 0 = 1 ) AND ( (
"public"."tab2"."ref_id" = :link_from_id ) )
LOG:  Anweisung: SELECT * FROM "public"."tab2" WHERE ( 0 = 1 ) AND ( (
"public"."tab2"."ref_id" = NULL ) )
LOG:  Anweisung: SELECT * FROM "public"."tab2" WHERE ( "public"."tab2"."ref_id"
= '2' )

The last statement actually loads the data from tab2 referenced by the 1st row
in tab1.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180829/60eeb6d6/attachment-0001.html>