<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_UNCONFIRMED "
title="UNCONFIRMED - Can Not Group in SQL on EXTRACT(YEAR FROM in Firebird Embedded"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131448">bug 131448</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>NEW
</td>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>robert@familiegrosskopf.de
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>1
</td>
<td>
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Can Not Group in SQL on EXTRACT(YEAR FROM in Firebird Embedded"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131448#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Can Not Group in SQL on EXTRACT(YEAR FROM in Firebird Embedded"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131448">bug 131448</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>Can't see anybody, who has confirmed a buggy behavior here.
Have tested this:
SELECT "Car", SUM("Cost") , EXTRACT(YEAR FROM "ServiceDate") AS "Year"
FROM "tblService"
GROUP BY "Car", "Year"
ORDER BY "Year" DESC
No problem to execute this query. But you can't change from this query to the
query-GUI. It won't understand the code.
Then I tried
SELECT "Car", SUM("Cost") , EXTRACT(YEAR FROM "ServiceDate")
FROM "tblService"
GROUP BY "Car", EXTRACT(YEAR FROM "ServiceDate")
ORDER BY EXTRACT(YEAR FROM "ServiceDate") DESC
Without any alias and it throws an error, because Base couldn't understand this
code. So I switched to direct SQL executing and this code works, too.
Tested with LO 6.4.2.2 on OpenSUSE 15.1 64bit rpm Linux
So I couldn't find any buggy behavior here. I switch it back to unconfirmed,
because it must be confirmed by other person like the bug reporter.</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>