Setting generator value twice in single transaction will set it to zero [CORE4173]

[firebird-automations]

Submitted by: prenosil (prenosil)

SQL> SET AUTODDL OFF;
SQL> SET GENERATOR G TO 111;
SQL> COMMIT;
SQL> SELECT Gen_id(G,0) FROM RDB$DATABASE;
GEN_ID

              111

SQL> SET GENERATOR G TO 222;
SQL> SELECT Gen_id(G,0) FROM RDB$DATABASE;
GEN_ID

              222

SQL> SET GENERATOR G TO 333;
SQL> SELECT Gen_id(G,0) FROM RDB$DATABASE;
GEN_ID

              333

SQL> COMMIT;
SQL> SELECT Gen_id(G,0) FROM RDB$DATABASE;
GEN_ID

                0

Commits: a1362f9 FirebirdSQL/fbt-repository@5f76ae2

[firebird-automations]

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

[firebird-automations]

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 2 [ 10560 ]

[firebird-automations]

Commented by: Sean Leyne (seanleyne)

Did this affect previous versions, or was this a regression introduced in v3?

[firebird-automations]

Commented by: @dyemanov

v3 only, as indicated in the ticket. And just FYI: I don't like the subjects being changed for "regression" ;-) Usually, this is obvious from the ticket itself.

[firebird-automations]

Modified by: @pavel-zotov

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

QA Status: Done successfully