Details
-
Bug
-
Resolution: Done
-
P3: Somewhat important
-
4.4.3
-
None
Description
Setting a relation to the same relational table (and the same displaycolumn) to different columns of the source table.
e.g.
relmodel.setRelation(0, QSqlRelation("reltable", "relindexcolumn", "reldisplaycolumn));
relmodel.setRelation(1, QSqlRelation("reltable", "relindexcolumn", "reldisplaycolumn));
relmodel.setRelation(2, QSqlRelation("reltable", "relindexcolumn", "reldisplaycolumn));
Expected to see:
This should generate unique fieldnames e.g.
select
relTblA_0.reldisplaycolumn reltable_reldisplaycolumn_0,
relTblA_1.reldisplaycolumn reltable_reldisplaycolumn_1,
relTblA_2.reldisplaycolumn reltable_reldisplay_column2 ....
Got instead:
instead the resulting sql looks like
select
relTblA_0.reldisplaycolumn reltable_reldisplaycolumn,
relTblA_1.reldisplaycolumn reltable_reldisplaycolumn,
relTblA_2.reldisplaycolumn reltable_reldisplaycolumn ...
The same alias is generated for all 3 columns.