Reported data types does not match supported data types

marklogic-community / ml-jdbc-driver

Making JDBC connections to MarkLogic SQL/ODBC Server

Other

3 stars 4 forks source link

Reported data types does not match supported data types #7

Open bobstarbird opened 5 years ago

bobstarbird commented 5 years ago

MarkLogic TDE supports a subset of XML xsd data types (Modules/MarkLogic/tde.xsd). pg_type_id supports a subset of TDE data types (sql:pg_type_id). The documented MarkLogic SQL data types (http://docs.marklogic.com/guide/sql/SQLqueries#id_32736) is a super set of types supported by the driver. TypeInfoCache.java has typeAliases HashMap for some aliases. The critical mapping of pg_type_id(type) to OID is missing some types.

bobstarbird commented 5 years ago

Remove bytea and uuid data types from PgDatabaseMetaData since these are not supported by MarkLogic.