Infinite row generation in "select gen_id(..) from rdb$database" with "group by" [CORE1650]

[firebird-automations]

Submitted by: Mikhail Teplov (baloo)

Is related to QA333

When executing following query only one row is expected, but result is infinite sequence of rows:

select 1, gen_id(g, 1 )
from rdb$database
group by 1,2

Without "group by" clause it works as expected and return one row with incremented generator value.

[firebird-automations]

Modified by: @pcisar

Workflow: jira [ 13641 ] => Firebird [ 14086 ]

[firebird-automations]

Modified by: @dyemanov

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Modified by: @dyemanov

Version: 2.1.1 [ 10223 ]

Version: 2.1.0 [ 10041 ]

Fix Version: 2.5 Beta 1 [ 10251 ]

[firebird-automations]

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA333 [ QA333 ]

[firebird-automations]

Commented by: @pcisar

QA test added.

[firebird-automations]

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test => Done successfully