list(distinct) doesn't sort any more if chars < a are leading
-------------------------------------------------------------
Key: CORE-5011
URL: http://tracker.firebirdsql.org/browse/CORE-5011
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 RC 1
Environment: Firebird 3 RC1 build 32144, Win7 32Bit
Reporter: Volker Rehn
Testcase below. leading chars > z are sorted, while chars < a are not. Previous
versions sorted chars < a too.
select
cast(list(distinct name1) as varchar(1000)) list1,
cast(list(distinct name2) as varchar(1000)) list2,
cast(list(distinct name3) as varchar(1000)) list3,
cast(list(distinct name4) as varchar(1000)) list4,
cast(list(distinct name5) as varchar(1000)) list5,
cast(list(distinct name6) as varchar(1000)) list6,
cast(list(distinct name7) as varchar(1000)) list7
from (
select name name1,
lpad('', pos, '.') || name name2,
lpad('', pos, ' ') || name name3,
lpad('', pos, 'A') || name name4,
lpad('', pos, 'a') || name name5,
lpad('', pos, '|') || name name6,
lpad('', pos, '~') || name name7
from (
select 1 pos, 'abc' name from rdb$database
union all
select 2, 'def' from rdb$database
union all
select 3, 'ghi' from rdb$database
union all
select 4, 'jkl' from rdb$database
union all
select 5, 'mno' from rdb$database
union all
select 6, 'pqr' from rdb$database
)
)
result:
LIST1
abc,def,ghi,jkl,mno,pqr
LIST2
..def,......pqr,...ghi,....jkl,.....mno,.abc
LIST3
pqr, def, ghi, jkl, mno, abc
LIST4
AAdef,AAAAAApqr,AAAghi,AAAAjkl,AAAAAmno,Aabc
LIST5
aabc,aadef,aaaaaapqr,aaaghi,aaaajkl,aaaaamno
LIST6
|abc,||def,|||ghi,||||jkl,|||||mno,||||||pqr
LIST7
~abc,~~def,~~~ghi,~~~~jkl,~~~~~mno,~~~~~~pqr
Volker
--
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
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
