Updates Made To Boolean (bit Datatype) Were Not Captured Correctly. (Doc ID 2409157.1)

Last updated on MARCH 08, 2019

Applies to:

Symptoms

Updates made to Boolean (bit datatype) were not captured correctly. update from 0 to 1 is captured correctly but not vice-versa.

and below is the GG filter used on this column, which worked fine when we are on GG Build 12.1 , but stopped working for update case from 1 to 0 since we upgraded to 12.3 (CDC capture).

FILTER (@EVAL(@AFTER(<COLUMN NAME>), 1, 0 OR @AFTER(<COLUMN NAME>) = 0 , 1, @COLTEST(<COLUMN NAME>, NULL), 1,0))

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.