Posted Sunday, June 13, 2004 @ 20:59:18
when showing results of queries with multiple nested joins, for some of the queries the DbTable shows one or more empty rows, besides the actual result rows.
For example, the following query results in an empty row besides the expected rows:
SELECT distinct dataelement.* FROM (((((form INNER JOIN modulelookup ON form.id = modulelookup.formId) INNER JOIN module ON modulelookup.moduleid = module.id) INNER JOIN questlookup ON module.id = questlookup.moduleId) INNER JOIN question ON questlookup.questionId = question.id) INNER JOIN dataelementlookup ON question.id = dataelementlookup.questionid) INNER JOIN dataelement ON dataelementlookup.dataelementId = dataelement.id WHERE form.id = "2";
The same query when used through another client doesnt lead to empty rows being shown. I am using MySql V 4.0, and J2SE 1.4