GG 21.7 Replicat abend when table has "default on null" using a sequence
GG Microservices 21.7, Oracle db 19.16 on OEL 7.9.
Created a table with a number column autopopulated on null from a sequence. Can insert ok most of the time, but deletes abend the replicat every other time, and the updates always seem to abend.
Goal of autopopulate is to avoid source code changes. I don't see any documentation restricting this usage. Sequence is not replicated so is created manually on target, but in theory it should not be invoked on the target anyway because the replicat applies logical change records.
Use case:
create table gg_tbl_ui2 (cola number, colb number, colc number, gg_pkui number default on null gg_pkui_seq_mds.nextval);