Add missing 'WHERE 1' and fix column name when getting schemas

marklogic-community / ml-jdbc-driver

Making JDBC connections to MarkLogic SQL/ODBC Server

Other

3 stars 4 forks source link

Closed t-watanabe-0910 closed 4 years ago

t-watanabe-0910 commented 4 years ago

SELECT name AS TABLE_SCHEM, '' AS TABLE_CATALOG FROM sys.sys_schemas AND nspname LIKE ...

Syntax error with AND. And nspname does not exist in sys.sys_schemas.

SELECT name AS TABLE_SCHEM, '' AS TABLE_CATALOG FROM sys.sys_schemas WHERE 1 AND name LIKE ...