Platform
Learn
Community
Support
Sign up
or
Log in
Profile
messages
Messages
logout
Logout
Platform
Home
Downloads
IPP
Licensing
Project Sizing
Beta
Learn
Training
Documentation
Evaluation Guide
Community
Jobs
Home
Forums
Forge
Ideas
Badges
Members
Support
Partner Guide
Resources Library
Opportunities
Account Management
Pre Sales Demos
Sign up
or
Log in
Home
Jobs
Forums
Forge
Ideas
Members
Badges
Community
›
Ideas
›
MySQL - Avoid duplicate column id issue
Advanced Search
0
Followers
2
Likes
MySQL - Avoid duplicate column id issue
Miguel Monteiro
Miguel Monteiro
VP Technology
at
Meivcore Industry Solutions
#5 097
in Community Rank
Database
On our radar
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
Created on 12 May 2016
Comments (1
)
Miguel Monteiro
28 Sep 2016
Miguel Monteiro
VP Technology
at
Meivcore Industry Solutions
#5 097
in Community Rank
This is easy to solve and an huge issue to live with :(
views
298
Followers
0
Loading...
Loading
(hidden) New Badge Popup