Interesting Bug

Sharing one Unique Interesting bug identified during testing

Case #1 - Property_Id values mismatch was the primary issue. Two tables were defined in two databases. The scenario is Property_Id on Database A is based on master tables defined , example Master A. Issue was## mapping of MasterA was used in DatabaseB instead of MasterB. It was difficult to identify as Property_Id values were always overlapping for a smaller set of input data

Database A

MasterA

Property_Id Value

1    A

2    B

3    C

.......

10    D

TableA

Property_Id  Local_Id (Identity Column) Value

1 1

2 2

3 3

1 4

2 5

2 6

Database B

MasterB

Property_Id Value

10    A

20    B

30    C

TableB (Expected)

Property_Id          Local_Id (Identity Column) Value

10 1

20 2

30 3

10 4

20 5

20 6

TableB (Actual)

Property_Id           Local_Id (Identity Column) Value

1 1

2 2

3 3

10 4

2 5

2 6

The bug was not easily identified as Property values in MasterA and MasterB overlapped.  The values were matching in most cases for a smaller dataset.

Happy Learning!!!