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

On 7 December 2012 06:02, Sumit S.
[email protected] wrote:

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.

Colin

On 7 December 2012 14:59, Colin L. [email protected] wrote:

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.