When we create Virtual Schema without setting SCHEMA_NAME property, it's created successfully. But when we use SELECT, NullPointerException will be thrown, because SCHEMA_NAME is required to query the schema in the source.
How to reproduce:
CREATE VIRTUAL SCHEMA virtual_schema_sqlserver
USING schema_sqlserver.adapter_script_sqlserver
WITH
SQL_DIALECT = 'SQLSERVER'
CONNECTION_NAME = 'jdbc_connection_sqlserver'
CATALOG_NAME = 'master'';
Problem
When we create Virtual Schema without setting SCHEMA_NAME property, it's created successfully. But when we use SELECT, NullPointerException will be thrown, because SCHEMA_NAME is required to query the schema in the source.
How to reproduce:
CREATE VIRTUAL SCHEMA virtual_schema_sqlserver USING schema_sqlserver.adapter_script_sqlserver WITH SQL_DIALECT = 'SQLSERVER' CONNECTION_NAME = 'jdbc_connection_sqlserver' CATALOG_NAME = 'master'';
SELECT * FROM virtual_schema_sqlserver."visits";