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: 19/Jan/16 05:53 AM
Component/s: Engine
Affects Version/s: 2.1 Beta 2, 2.1.0, 2.1.1
Fix Version/s: 2.5 Beta 1

Issue Links:

QA Status: Done successfully

 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   Change History   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.