Fulltext search gives DataTables warning and has bugs in sorting and limit

"DataTables warning: Unexpected number of TD elements. Expected 7 and got 8. DataTables does not support rowspan / colspan in the table body, and there must be one cell for each row/column combination."

Using Firefox 3.6.2

Happens on sandbox too.

o recreate w/ sample data, type 'ada' in Find field and use 'All tables' in dropdown.

(from dgg) .....

• • • Several other bugs in the dataTables implementation:

1. The SORTING w/ the new dataTables tool is also broken. Contacts seem to be sorted by contact type, contact_id - but the table header is 'Name' and so the expectation is that clicking that header would sort the rows by name (asc / desc). We may need to change the output to be sort_name rather than display_name to facilitate this (I would do this for all the table results columns that are 'Name').

2. The 'limit' setting is not right - we should be displaying up to 10 rows from each table - but I'm seeing random limits:
Contacts 1 - 8 of 11
Activities 1 - 9 of 462
Event Participants 1 - 4 of 5