squawk icon indicating copy to clipboard operation
squawk copied to clipboard

Error message about non-robust constraint drop is bugged

Open sbdchd opened this issue 4 years ago • 0 comments

it recommends:

  help: Consider wrapping in a transaction or adding a IF NOT EXISTS clause if the statment supports it.

when it should say

  help: Consider wrapping in a transaction or adding a IF EXISTS clause if the statment supports it.

For dropping a constraint, it should say:

IF EXISTS instead of IF NOT EXISTS

For adding a constraint, it should say:

IF EXISTS (which it does right now)

sbdchd avatar Jul 09 '21 15:07 sbdchd