[Libreoffice-bugs] [Bug 126588] New: EDITING: Firebird: View could be executed, but crashes when trying to save

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 126588
           Summary: EDITING: Firebird: View could be executed, but crashes
                    when trying to save
           Product: LibreOffice
           Version: 6.3.0.2 rc
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: robert at familiegrosskopf.de

Created attachment 153022
  --> https://bugs.documentfoundation.org/attachment.cgi?id=153022&action=edit
Try to create a view with SQL-code from query "View_bericht_Monat_zweispaltig"
- saving impossible.

Open the attached database.
Execute the query "View_Bericht_Monat_zweispaltig".
Query works in Firebird.
Open this query for editing in SQL-mode.
Copy the SQL-code.
Go to Table → Create View
Switch GUI off and insert the SQL-code.
Set execution to direct SQL.
Execute the view - works.
Save the view as "Bericht_Monat_zweispaltig".
LO crashes immediately.

There are 2 specific parts in this view: 
View depends on another view in this database.
View must be executed in direct SQL.
So could be one of this parts is the one which leads to the crash.

Tested with LO 6.3.0.2 on OpenSUSE 64bit rpm Linux.

-- 
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/20190729/2ec790b6/attachment.html>