Schema validator should be more forgiving of column type mismatches

Description

Many databases have fewer internal types than type codes defined by the JDBC `Types` enumeration, especially since the ANSI SQL spec fails to meaningfully distinguish some of its types. This means that sometimes the JDBC column metadata has a different type code to the one we used to create the table. The schema validator should handle this more gracefully.

Environment

None

Assignee

Gavin King

Reporter

Gavin King

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

backportDecision

Undecided

Components

Priority

Major
Configure