<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:robert@familiegrosskopf.de" title="Robert Großkopf <robert@familiegrosskopf.de>"> <span class="fn">Robert Großkopf</span></a>
</span> changed
<a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Query-designer removes the SQL keyword AS in front of an Aliasname"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=90561">bug 90561</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>RESOLVED
</td>
<td>REOPENED
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>robert@familiegrosskopf.de
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>FIXED
</td>
<td>---
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Query-designer removes the SQL keyword AS in front of an Aliasname"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=90561#c11">Comment # 11</a>
on <a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Query-designer removes the SQL keyword AS in front of an Aliasname"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=90561">bug 90561</a>
from <span class="vcard"><a class="email" href="mailto:robert@familiegrosskopf.de" title="Robert Großkopf <robert@familiegrosskopf.de>"> <span class="fn">Robert Großkopf</span></a>
</span></b>
<pre>Couldn't confirm this bug has been fixed. Have tested it with LO 6.2.5.2.
Created a query an added an alias for a field in the GUI. No "AS" appears in
the SQL-code. Added "AS" to the SQL-code, changed back to the design view and
then to SQL view. "AS" has been gone again.
All tested with an internal HSQLDB on LO 6.2.5.2 with OpenSUSE 15 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>