Issue Details (XML | Word | Printable)

Key: CORE-4084
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Critical Critical
Assignee: Adriano dos Santos Fernandes
Reporter: Thomas Beckmann
Votes: 0
Watchers: 0
Operations

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

Regression: Group by fails if subselect-column is involved

Created: 17/Apr/13 02:16 PM   Updated: 29/May/15 01:36 PM
Component/s: Engine
Affects Version/s: 3.0 Initial
Fix Version/s: 3.0 Alpha 1

Environment: W7/64, WI-T3.0.0.30338 Firebird 3.0 Unstable

QA Status: Done successfully


 Description  « Hide
The following statement works as expected in FB2.5 but fails in 3.0, returning "SQL error code = -104. Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause)."

select
  iif(D is null, 10, 0) + SYS as SYS,
  count(*)
from (select
    (select d.RDB$RELATION_ID from RDB$DATABASE d) as D,
    coalesce(r.RDB$SYSTEM_FLAG, 0) as SYS
  from RDB$RELATIONS r)
group by 1

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Sean Leyne added a comment - 17/Apr/13 04:17 PM
This is a 3.0 regression

Adriano dos Santos Fernandes added a comment - 17/Apr/13 04:36 PM
Sean, every bug targeting only 3.0 is obviously a regression (in relation to < 3.0). And almost every bug related to existing functionality is a regression in relation to some version, or it's a bug related to a new feature.

I fail to see how this adds information to the 3.0 tickets.

Thomas Beckmann added a comment - 18/Apr/13 05:16 AM
Hi Adriano,

I just did a download of the nightly build, which tells me, version is "WI-T3.0.0.30367 Firebird 3.0 Unstable" - and that still contains the bug. Will the fix come later?

Dmitry Yemanov added a comment - 18/Apr/13 09:36 AM
You were slightly faster than our snapshot build farm :-) Now the today's version is there, buildno is 30370.