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

            Bug ID: 170757
           Summary: Basedocumenter
           Product: LibreOffice
           Version: unspecified
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Extensions
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 205488
  --> https://bugs.documentfoundation.org/attachment.cgi?id=205488&action=edit
Errormessage

Hi,

in my database is a query 

SELECT CONCAT( "Companies"."NAME", CONCAT( ' - ', CONCAT(
"Companies"."DEPARTMENT", CONCAT( ' - ', CONCAT( "Personen"."PREFIX", CONCAT( '
', CONCAT( "Personen"."TITLE", CONCAT( ' ', CONCAT( "Personen"."FIRSTNAME",
CONCAT( ' ', "Personen"."LASTNAME" ) ) ) ) ) ) ) ) ) ), "Personen"."ID" FROM
"Companies", "Personen" WHERE ( "KUNDE" = TRUE ) AND ( "Personen"."ID_COMPANY"
= "Companies"."ID" ) ORDER BY "NAME", "LASTNAME"

which works well (the concat is necessary, || doesnt work).

After the scan is passed Basedocumenter hangs up at documentation with an SQL
error (see attached image).

If i remove the query from the database BD completes the documentation.
There is also a view in the database with nearly the same definition like the
query, there are no problems.

btw, i changed the code as described in bug report 159697.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to