Skip to content

Updated tests to include Exasol V8/ Update to vsjdbc 12.0.0 / Fix issues #252

Updated tests to include Exasol V8/ Update to vsjdbc 12.0.0 / Fix issues

Updated tests to include Exasol V8/ Update to vsjdbc 12.0.0 / Fix issues #252

GitHub Actions / Test Report failed Mar 7, 2024 in 0s

371 tests run, 25 skipped, 4 failed.

Annotations

Check failure on line 1 in src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java

See this annotation in the file changed.

@github-actions github-actions / Test Report

ExasolSqlDialectExaConnectionIT.testCreateVirtualSchemaWithIgnoreErrorsProperty

Error executing 'SELECT NOW() - INTERVAL '1' MINUTE FROM "VIRTUAL_SCHEMA_IGNORES_ERRORS"."SINGLE_COLUMN_TABLE_BOOLEAN"': Execution of SQL Statement failed on external EXASolution. ['.' character is not allowed within quoted identifiers [line 1, column 23] (Session: 1792879169082949632)] (Session: 1792879046000508928)
Raw output
java.sql.SQLException: Error executing 'SELECT NOW() - INTERVAL '1' MINUTE FROM "VIRTUAL_SCHEMA_IGNORES_ERRORS"."SINGLE_COLUMN_TABLE_BOOLEAN"': Execution of SQL Statement failed on external EXASolution. ['.' character is not allowed within quoted identifiers [line 1, column 23] (Session: 1792879169082949632)] (Session: 1792879046000508928)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:219)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testCreateVirtualSchemaWithIgnoreErrorsProperty(AbstractExasolSqlDialectIT.java:603)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
Caused by: java.sql.SQLException: Execution of SQL Statement failed on external EXASolution. ['.' character is not allowed within quoted identifiers [line 1, column 23] (Session: 1792879169082949632)] (Session: 1792879046000508928)
	at com.exasol.jdbc.ExceptionFactory.createSQLException(ExceptionFactory.java:258)
	at com.exasol.jdbc.EXASQLException.getSQLExceptionIntern(EXASQLException.java:50)
	at com.exasol.jdbc.AbstractEXAStatement.execute(AbstractEXAStatement.java:478)
	at com.exasol.jdbc.EXAStatement.execute(EXAStatement.java:289)
	at com.exasol.jdbc.AbstractEXAStatement.executeQuery(AbstractEXAStatement.java:614)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:217)
	... 4 more

Check failure on line 1 in src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionWithDataTypesIT.java

See this annotation in the file changed.

@github-actions github-actions / Test Report

ExasolSqlDialectExaConnectionWithDataTypesIT.testCreateVirtualSchemaWithIgnoreErrorsProperty

Error executing 'SELECT NOW() - INTERVAL '1' MINUTE FROM "VIRTUAL_SCHEMA_IGNORES_ERRORS"."SINGLE_COLUMN_TABLE_BOOLEAN"': ETL-4213: Execution of SQL Statement failed on external EXASolution. ['.' character is not allowed within quoted identifiers [line 1, column 23] (Session: 1792879477716353024)] (Session: 1792879304759640064)
Raw output
java.sql.SQLException: Error executing 'SELECT NOW() - INTERVAL '1' MINUTE FROM "VIRTUAL_SCHEMA_IGNORES_ERRORS"."SINGLE_COLUMN_TABLE_BOOLEAN"': ETL-4213: Execution of SQL Statement failed on external EXASolution. ['.' character is not allowed within quoted identifiers [line 1, column 23] (Session: 1792879477716353024)] (Session: 1792879304759640064)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:219)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testCreateVirtualSchemaWithIgnoreErrorsProperty(AbstractExasolSqlDialectIT.java:603)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
Caused by: java.sql.SQLException: ETL-4213: Execution of SQL Statement failed on external EXASolution. ['.' character is not allowed within quoted identifiers [line 1, column 23] (Session: 1792879477716353024)] (Session: 1792879304759640064)
	at com.exasol.jdbc.ExceptionFactory.createSQLException(ExceptionFactory.java:258)
	at com.exasol.jdbc.EXASQLException.getSQLExceptionIntern(EXASQLException.java:50)
	at com.exasol.jdbc.AbstractEXAStatement.execute(AbstractEXAStatement.java:478)
	at com.exasol.jdbc.EXAStatement.execute(EXAStatement.java:289)
	at com.exasol.jdbc.AbstractEXAStatement.executeQuery(AbstractEXAStatement.java:614)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:217)
	... 4 more

Check failure on line 1 in src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectJdbcConnectionIT.java

See this annotation in the file changed.

@github-actions github-actions / Test Report

ExasolSqlDialectJdbcConnectionIT.testCreateVirtualSchemaWithIgnoreErrorsProperty

Error executing 'SELECT NOW() - INTERVAL '1' MINUTE FROM "VIRTUAL_SCHEMA_IGNORES_ERRORS"."SINGLE_COLUMN_TABLE_BOOLEAN"': ETL-5402: JDBC-Client-Error: Failed to initialize Query: '.' character is not allowed within quoted identifiers [line 1, column 23] (Session: 1792878957805436928) (Session: 1792878749366419456)
Raw output
java.sql.SQLException: Error executing 'SELECT NOW() - INTERVAL '1' MINUTE FROM "VIRTUAL_SCHEMA_IGNORES_ERRORS"."SINGLE_COLUMN_TABLE_BOOLEAN"': ETL-5402: JDBC-Client-Error: Failed to initialize Query: '.' character is not allowed within quoted identifiers [line 1, column 23] (Session: 1792878957805436928) (Session: 1792878749366419456)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:219)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testCreateVirtualSchemaWithIgnoreErrorsProperty(AbstractExasolSqlDialectIT.java:603)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
Caused by: java.sql.SQLException: ETL-5402: JDBC-Client-Error: Failed to initialize Query: '.' character is not allowed within quoted identifiers [line 1, column 23] (Session: 1792878957805436928) (Session: 1792878749366419456)
	at com.exasol.jdbc.ExceptionFactory.createSQLException(ExceptionFactory.java:258)
	at com.exasol.jdbc.EXASQLException.getSQLExceptionIntern(EXASQLException.java:50)
	at com.exasol.jdbc.AbstractEXAStatement.execute(AbstractEXAStatement.java:478)
	at com.exasol.jdbc.EXAStatement.execute(EXAStatement.java:289)
	at com.exasol.jdbc.AbstractEXAStatement.executeQuery(AbstractEXAStatement.java:614)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:217)
	... 4 more

Check failure on line 1 in src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectLocalConnectionIT.java

See this annotation in the file changed.

@github-actions github-actions / Test Report

ExasolSqlDialectLocalConnectionIT.testCreateVirtualSchemaWithIgnoreErrorsProperty

Error executing 'SELECT NOW() - INTERVAL '1' MINUTE FROM "VIRTUAL_SCHEMA_IGNORES_ERRORS"."SINGLE_COLUMN_TABLE_BOOLEAN"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_BOOLEAN: Error during compilation: '.' character is not allowed within quoted identifiers [line 1, column 23] (pushdown query: SELECT LOCALTIMESTAMP '2024-03-07 14:54:06.998' FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_BOOLEAN") (Session: 1792879557936283648)
Raw output
java.sql.SQLException: Error executing 'SELECT NOW() - INTERVAL '1' MINUTE FROM "VIRTUAL_SCHEMA_IGNORES_ERRORS"."SINGLE_COLUMN_TABLE_BOOLEAN"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_BOOLEAN: Error during compilation: '.' character is not allowed within quoted identifiers [line 1, column 23] (pushdown query: SELECT LOCALTIMESTAMP '2024-03-07 14:54:06.998' FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_BOOLEAN") (Session: 1792879557936283648)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:219)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testCreateVirtualSchemaWithIgnoreErrorsProperty(AbstractExasolSqlDialectIT.java:603)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_BOOLEAN: Error during compilation: '.' character is not allowed within quoted identifiers [line 1, column 23] (pushdown query: SELECT LOCALTIMESTAMP '2024-03-07 14:54:06.998' FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_BOOLEAN") (Session: 1792879557936283648)
	at com.exasol.jdbc.ExceptionFactory.createSQLException(ExceptionFactory.java:258)
	at com.exasol.jdbc.EXASQLException.getSQLExceptionIntern(EXASQLException.java:50)
	at com.exasol.jdbc.AbstractEXAStatement.execute(AbstractEXAStatement.java:478)
	at com.exasol.jdbc.EXAStatement.execute(EXAStatement.java:289)
	at com.exasol.jdbc.AbstractEXAStatement.executeQuery(AbstractEXAStatement.java:614)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:217)
	... 4 more