|
From: Nick D. (JIRA) <tr...@fi...> - 2013-07-24 07:46:32
|
wrong order in LIST() function when group by distinct
-----------------------------------------------------
Key: CORE-4146
URL: http://tracker.firebirdsql.org/browse/CORE-4146
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.2 Update 1
Environment: Win7, FB2.5.2
Reporter: Nick Dirov
select distinct f1, list(f2)
from
(select f1, f2
from
(select 1 as f1, 'a' as f2 from rdb$database
union
select 2 as f1, 'b' as f2 from rdb$database
union
select 2 as f1, 'c' as f2 from rdb$database
union
select 3 as f1, 'e' as f2 from rdb$database)
order by 1, 2 desc)
group by 1
return
1- a
2- b,c
3- e
instead of expected
1- a
2- c,b
^^^^
3- e
so as we watch order by clause ignored when group by distinct ..
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
|