<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - EDITING: Firebird: View could be executed, but crashes when trying to save"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126588">126588</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>EDITING: Firebird: View could be executed, but crashes when trying to save
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.0.2 rc
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>robert@familiegrosskopf.de
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=153022" name="attach_153022" title="Try to create a view with SQL-code from query "View_bericht_Monat_zweispaltig" - saving impossible.">attachment 153022</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=153022&action=edit" title="Try to create a view with SQL-code from query "View_bericht_Monat_zweispaltig" - saving impossible.">[details]</a></span>
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>