#1 wrong usage of distinct

[Anonymous]

The mysql syntax generated does not use distinct correctly:

check the mysql query generated by:
<xml_object name="project" source="TABLE.project" valueof="COLUMN.title" distinct="true">
<xml_attribute name="id" valueof="COLUMN.id"/>
</xml_object>

MYSQL: SELECT id, DISTINCT title FROM project;

Workaround is to use a seperate child node and have it as the first child like:
<xml_object name="project" source="TABLE.project">
<xml_object name="title" valueof="COLUMN.title" distinct="true" order="ASC"/>
<xml_attribute name="id" valueof="COLUMN.id"/>
</xml_object>