subselect with union and order by return wrong result.
-------------------------------------------------------
Key: CORE-5169
URL: http://tracker.firebirdsql.org/browse/CORE-5169
Project: Firebird Core
Issue Type: Bug
Environment: 2.5.3 windows
Reporter: IL
espectin 8, 7, 6, 5, 4 but order don't apply correct.
got 1,2,3,4,5,6
select first 5 xx
from
(select xx from
(select 1 as xx from rdb$database
union
select 2 from rdb$database
union
select 3 from rdb$database
union
select 4 from rdb$database
union
select 5 from rdb$database
union
select 6 from rdb$database
union
select 7 from rdb$database
union
select 8 from rdb$database
)
order by xx desc
)
order by xx
--
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
------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
