Skip to content

mismatch-column-in-data-type-change (US030)#

Automatic fix is not available.

What it does#

Checks for mismatch column in data type change.

Why not?#

For certain column data type changes, a USING clause must be provided if there is no implicit or assignment cast from old to new type. Logically, the expression in the USING should reference the original column otherwise it is most likely a mistake.

When should you?#

Almost never. When you are sure that the expression in the USING is indeed correct.

Use instead:#

The right column in the USING clause.