Project

General

Profile

Bug #3130

remove p2j_id_generator_sequence from generated index ddl

Added by Ovidiu Maxiniuc almost 8 years ago. Updated about 7 years ago.

Status:
Closed
Priority:
Low
Start date:
Due date:
% Done:

100%

billable:
No
vendor_id:
GCD
case_num:

History

#1 Updated by Ovidiu Maxiniuc almost 8 years ago

  • Subject changed from remove p2j_id_generator_sequence from index ddl to remove p2j_id_generator_sequence from generated index ddl

The fact that the p2j_id_generator_sequence DDL is emitted into the index DDL file at conversion is a bug. This has nothing to do with indexes and must be removed. If the generated index ddl is applied to a database these declarations will broke the database by resetting the id generator so there will be record id collisions.

The only moment for creating/resetting the value of this sequence is after a fresh database import.

#2 Updated by Ovidiu Maxiniuc almost 8 years ago

  • Status changed from New to WIP

Task branch 3130a was created from trunk rev 11066.
The fix for the issue was committed as revision 11067.

#3 Updated by Eric Faulhaber about 7 years ago

Ovidiu, please rebase branch 3130a to the latest trunk and get this fix regression tested (conversion only) and merged to trunk as soon as possible. Thanks.

#4 Updated by Ovidiu Maxiniuc about 7 years ago

3130a passed conversion testing on devsrv01 and ETF on local workstation. It was merged to trunk as revision 11149.
The notification email was sent to team and the task branch was archived.

#5 Updated by Greg Shah about 7 years ago

  • % Done changed from 0 to 100
  • Status changed from WIP to Closed
  • Assignee set to Ovidiu Maxiniuc
  • Target version set to Cleanup and Stablization for Server Features

Also available in: Atom PDF