I have a table wich has some 32lacks of records, i will be adding a new column to it. I will be first implementing the changes in the dev version of the table.
Now the table is loaded by first getting values for it from other tables. I will be making changes in this fetch queries to get the values for an additional column.
Now to be sure of the changes in the Dev version of the table, such that the new column gets populated with appropriate values, what can be the test cases to verify that my code is working.
I will be doing a count* for sure to check the prod and dev version.
what can be the other cases.