MySQL - Avoid duplicate column id issue

By Otacon Rex on 12 May
In our project, we needed to overcome this issue. It happens when MySQL is not able to distinguish columns with the same name, even if they belong to different database tables. Accordingly to Outsystems support team investigation, this issue might occur unexpectedly.

To overcome this, we needed to add a alias for each column that share the same name with different tables (column id). I suggest that the platform automatically does that generating for each column an alias (format e.g. tablename_columnname). This way, it would work just fine without developers need to worry about this
Otacon Rex28 Sep (4 weeks ago)

This is easy to solve and an huge issue to live with :(