self joins throw an error
Closed this issue · 1 comments
dimitri-yatsenko commented
>> common.Animal*common.Animal
Object dj.GeneralRelvar
Primary key: animal_id
Dependent attributes: real_id, date_of_birth, sex, owner, line, animal_notes, animal_ts
Contents:
Error using mym
Not unique table/alias: 'animal'
Error in dj.Connection/query (line 348)
ret=mym(self.connId, queryStr, v{:});
Error in dj.GeneralRelvar/exists (line 178)
yes = self.conn.query(sprintf('SELECT EXISTS(SELECT 1 FROM %s LIMIT 1) as yes', sql));
Error in dj.GeneralRelvar/display (line 83)
if self.exists
dimitri-yatsenko commented
seems like a harmless fix. In every join, the second table is aliased.