Issue Details (XML | Word | Printable)

Key: CORE-2215
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Alex Bekhtin
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

GROUP BY concatenation with empty string

Created: 28/Nov/08 05:31 AM   Updated: 27/Apr/11 12:49 PM
Component/s: Engine
Affects Version/s: 2.0.0, 1.5.4, 2.0.1, 2.0.2, 2.0.3, 1.5.5, 2.1.0, 2.0.4, 2.5 Alpha 1, 2.1.1, 2.0.5, 2.1.2, 2.5 Beta 1, 2.5 Beta 2, 2.1.3, 1.5.6
Fix Version/s: 2.5 Beta 1, 2.1.4

Time Tracking:
Not Specified

Environment: Firebird-2.5.0.21454-0_Win32_PEAKTOP
Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
CREATE TABLE ATTRIBUTES_DICTIONARY (
    ID INTEGER NOT NULL,
    NAME VARCHAR(256)
);

select ATR.name, count(*) from ATTRIBUTES_DICTIONARY ATR group by 1 order by 2 desc
RESULT: OK

select ATR.name||'TEXT', count(*) from ATTRIBUTES_DICTIONARY ATR group by 1 order by 2 desc
RESULT: OK

select ATR.name||'', count(*) from ATTRIBUTES_DICTIONARY ATR group by 1 order by 2 desc
ERROR: cannot sort on a field that does not exist.

select ATR.name||'', count(*) from ATTRIBUTES_DICTIONARY ATR group by ATR.name||'' order by count(*) desc
ERROR: cannot sort on a field that does not exist.




 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Adriano dos Santos Fernandes added a comment - 28/Nov/08 11:51 AM
Fixed... Bug affects a snapshot between 2.5 alpha1 and beta1.

Pavel Cisar added a comment - 27/Apr/11 12:49 PM
QA test added.