Issue Details (XML | Word | Printable)

Key: CORE-1650
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Mikhail Teplov
Votes: 0
Watchers: 0

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

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

Created: 12/Dec/07 07:18 AM   Updated: 20/Apr/11 10:15 AM
Component/s: Engine
Affects Version/s: 2.1 Beta 2, 2.1.0, 2.1.1
Fix Version/s: 2.5 Beta 1

Time Tracking:
Not Specified

Issue Links:

 Description  « Hide
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.

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Pavel Cisar added a comment - 20/Apr/11 10:15 AM
QA test added.