<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 - SQL-statement shows also columns of "OrderBY"-section in Tools > SQL"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107954">107954</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>SQL-statement shows also columns of "OrderBY"-section in Tools > SQL
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>4.0.0.3 release
</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=133402" name="attach_133402" title="Open the database and try the SQL-code in Tools > SQL.">attachment 133402</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=133402&action=edit" title="Open the database and try the SQL-code in Tools > SQL.">[details]</a></span>
Open the database and try the SQL-code in Tools > SQL.
Open the attached database.
Start Tools > SQL
Mark 'Show output of "select"-statements
Execute the following code:
SELECT "Nachname", "Vorname" FROM "Teilnehmer" ORDER BY "Nachname", "Vorname"
ASC
It will show
<Nachname>,<Vorname>,<Nachname>,<Vorname>,
Now start
SELECT "Nachname", "Vorname" FROM "Teilnehmer" ORDER BY "Nachname" ASC
It will show
<Nachname>,<Vorname>,<Nachname>,
Every field, which is included in ORDER BY, will be repeated at the end of the
row.
This bug appears in LO 4.0.0.3, where it has been introduced to show the
output, up to LO 5.4.0.0 alpha1. Tested with OpenSUSE 42.1 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>