GROUP BY concatenation with empty string [CORE2215] #2643
Labels
affect-version: 1.5.4
affect-version: 1.5.5
affect-version: 1.5.6
affect-version: 2.0.0
affect-version: 2.0.1
affect-version: 2.0.2
affect-version: 2.0.3
affect-version: 2.0.4
affect-version: 2.0.5
affect-version: 2.1.0
affect-version: 2.1.1
affect-version: 2.1.2
affect-version: 2.1.3
affect-version: 2.5 Alpha 1
affect-version: 2.5 Beta 1
affect-version: 2.5 Beta 2
component: engine
fix-version: 2.1.4
fix-version: 2.5 Beta 1
priority: major
qa: done successfully
type: bug
Submitted by: Alex Bekhtin (afgm)
Is related to QA272
CREATE TABLE ATTRIBUTES_DICTIONARY (
ID INTEGER NOT NULL,
NAME VARCHAR(256)
);
select http://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.
Commits: b2112b9 da73861
The text was updated successfully, but these errors were encountered: