Is there any way to automatically validate system triggers to see if I have broken any by renaming columns in foreign keys? It upset me to discover whilst investigating a bug today the following statement in the docs, which I was not aware of previously:
Hopefully I haven't done this in too many places, but hunting through every system trigger doesn't fill me with excitement ... As a sidenote - why does it not just prevent you from renaming columns in foreign keys as it does with primary keys? EDIT: This is using 11.0.1.2352. It definitely doesn't seem to be correcting the system triggers automatically on rename! EDIT to provide an example as requested: Create a DB (using Sybase Central wizard defaults):
Then run the following SQL statement:
Oddly, what then appears to happen is that the update columns system trigger is deleted. The delete trigger remains but with the wrong key name (as the docs suggest should happen). This is with 11.0.1.2427. |