Troubleshooting-SHOW-DatabaseMetaData-getFunctionColumns does not enforce ordering

The NuoDB Migrator contains data type registrations for all standard JDBC types and vendor-specific types for MSSQL, PostgreSQL, MySQL, Oracle, and DB2. A metadata error during schema generation, "Unsupported type VARCHAR, type code 12, length 20 on table datatypes1 column c1" for example, indicates that a type needs to be introduced to NuoDB Migrator additionally:

nuodb-migrator schema ... --type.code=12 --type.name=varchar(n)

A SQL type name template--type.namecan contain placeholders, that will be substituted with type specifiers during type name creation, wherepis a placeholder for a precision,sis a scale andnis a maximum size.