Two interesting bugs - Web service changes, DB column position changes

Two interesting bugs and learning's from them

Bug#1 - Due to install / upgrade paths it resulted in different ordinal position of same tables. Due to usage of select * this resulted in wrong update on columns

Automation Solution - With SQL command (link) we can figure out ordinal position differences between two same tables. Querying two environments for each tables, dumping the results in a XML. XML comparison  between them would highlight tables with different cardinal positions for two same tables.

Bug #2 - When web services are changed, the optional parameters introduced, signatures changed often fails to support backward compatibility 

Automation Solution - SOA model is open source tool for wsdl comparison. This can be used to validate wsdl differences between versions. Example code from SO

More Reads

Determine space used for each table in a SQL Server database

Happy Bugging & Learning!!!

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!!!