LONG VARCHAR / LONG VARBINARY are not detected as CLOB / BLOB

[mkarg]

Search first

• I searched and no similar issues were found

Description

liquibase update apparently does not correctly detect the types LONG VARCHAR, LONG NVARCHAR, LONG BINARY and LONG VARBINARY as CLOB / BLOB. Instead, it detects it as "Unknown" type. As a result, such a schema applied upon a RDBMS that does not know that type names (but does know that types using a different name) will fail.

Steps To Reproduce

1. SQL Anywhere:

CREATE TABLE T (C LONG VARCHAR)

liquibase generateChangelog

2. PostgreSQL:

liquibase update

Expected/Desired Behavior

BLOB / CLOB should get detected.

Liquibase Version

master

Database Vendor & Version

SAP SQL Anywhere 17.0.11, PostgreSQL 15.3

Liquibase Integration

N/A

Liquibase Extensions

N/A

OS and/or Infrastructure Type/Provider

Windows 10 Pro (German)

Additional Context

N/A

Are you willing to submit a PR?

• I'm willing to submit a PR (Thank you!)