BUG: User Defined Table Types with Defaults show as different when they are not.
All of our User Defined Table Types with declared Defaults show up as different and needing to be committed when there are no differences. Then during the commit process it shows an error saying "Nothing to commit"
1
vote
Jeff Cantwell
shared this idea
-
pmiskell commented
In my case, this is caused by "DEFAULT" being passed in as a parameter of the function. Example below:
Before: fnMySQLFunction(CustomerID, DEFAULT, DEFAULT)
After: fnMySQLFunction(CustomerID,,)Thanks