Writing test cases for mysql errors

Hi,

I just encountered a MySql error for ambiguous columns. I fixed it but I need to write test cases for such happenings to avoid any such instance in future.

Regards,
Sumit

You question is, ironically, ambiguous. Can you give us a specific
example of the problem you want to test for.

Colin

Hi,

I just encountered a MySql error for ambiguous columns. I fixed it but I

need to write test cases for such happenings to avoid any such instance in

future.

You question is, ironically, ambiguous. Can you give us a specific

example of the problem you want to test for.

I joined two tables. I missed to specify the table name for some columns in the controller. I am using Jquery dataTables. This error arises only when one searches for something on this table and then tries to sort it using some specific column. So, if this column doesn’t have table name specified with it in the controller, it throws error.

Seems improbable to write a universal test case for this. Its more like a syntactical error.