The hsql engine "forgets" to insert a table alias when a join query
is generated.
The generic driver does ok.
Example with hsql engine, the table alias in the FROM clause for table
association is missing.
SELECT
association_end.id,
association_end.name,
association_end.association_id,
association_end.reciprocal_id,
association_end.type_id,
association_end.instance_id
FROM
association,
association_end
WHERE
association_end.association_id = association_0.id
AND
association_0.name = 'made by'
-------------
Example with generic engine, which is OK
SELECT
association_end.id,
association_end.name,
association_end.association_id,
association_end.reciprocal_id,
association_end.type_id,
association_end.instance_id
FROM
association association_0,
association_end
WHERE
association_end.association_id=association_0.id
AND
(association_0.name = 'made by')
Thanks,
Eduard
