View previous topic :: View next topic
|
Author |
Message |
prasenjit_dey
New User
Joined: 30 Apr 2008 Posts: 20 Location: Noida
|
|
|
|
Hi everyone,
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.
PLEASE REPLY ASAP |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Quote: |
I will be making changes in this fetch queries to get the values for an additional column. |
Validate the correctness of these values. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
I will be doing a count* for sure to check the prod and dev version.
what can be the other cases. |
How will a count ensure the content is correct?
Please define "the other cases" and we may be able to offer suggestions. |
|
Back to top |
|
|
prasenjit_dey
New User
Joined: 30 Apr 2008 Posts: 20 Location: Noida
|
|
|
|
I will be doing a sum for a column....so that the total sum for that column in both tables remains the same....
I wnt to know what can be the other test case...
any suggestions.... |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
Quote: |
I wnt to know what can be the other test case... |
congruence checking depend heavily on the data, very little we can suggest |
|
Back to top |
|
|
|