Use case-sensitive object definition
Better support for the "Use case-sensitive object definition". Especially for changes in columns that are used in foreign keys. Now it is possible to commit changes such that the "Use case-sensitive object definition" cannot be used anymore.
- Link the database to source control with “Use case-sensitive object definition” turned off (which seems to be default?)
- Create two tables, one with a foreign key referencing the other table.
- Save these tables to the working folder
- Alter the case of the field referenced by the foreign key and alter something else on the same table too. That way the change in case will show up in the “Commit changes” tab. Save the changes to the working folder.
- Turn on the “Use case-sensitive object definition” setting
- Switch to the “Commit changes” -> error
4
votes
Erik Zijp
shared this idea