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, 2 failed.

Annotations

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.testCharMappingAscii

Unable to execute assertion query for table SINGLE_COLUMN_TABLE_CHAR20_ASCII
Raw output
org.opentest4j.AssertionFailedError: Unable to execute assertion query for table SINGLE_COLUMN_TABLE_CHAR20_ASCII
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualTableContents(AbstractExasolSqlDialectIT.java:172)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testCharMappingAscii(AbstractExasolSqlDialectIT.java:254)
	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: Error executing 'SELECT * FROM "THE_VS"."SINGLE_COLUMN_TABLE_CHAR20_ASCII"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_CHAR20_ASCII: Data type mismatch in column number 1 (1-indexed).Expected CHAR(20) UTF8, but got CHAR(20) ASCII. (pushdown query: SELECT "SINGLE_COLUMN_TABLE_CHAR20_ASCII"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_CHAR20_ASCII") (Session: 1792879530403168256)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:219)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.selectAllFrom(AbstractExasolSqlDialectIT.java:204)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.selectAllFromCorrespondingVirtualTable(AbstractExasolSqlDialectIT.java:200)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualTableContents(AbstractExasolSqlDialectIT.java:170)
	... 4 more
Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_CHAR20_ASCII: Data type mismatch in column number 1 (1-indexed).Expected CHAR(20) UTF8, but got CHAR(20) ASCII. (pushdown query: SELECT "SINGLE_COLUMN_TABLE_CHAR20_ASCII"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_CHAR20_ASCII") (Session: 1792879530403168256)
	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)
	... 7 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.testVarcharMappingAscii

Unable to execute assertion query for table SINGLE_COLUMN_TABLE_VARCHAR20_ASCII
Raw output
org.opentest4j.AssertionFailedError: Unable to execute assertion query for table SINGLE_COLUMN_TABLE_VARCHAR20_ASCII
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualTableContents(AbstractExasolSqlDialectIT.java:172)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testVarcharMappingAscii(AbstractExasolSqlDialectIT.java:226)
	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: Error executing 'SELECT * FROM "THE_VS"."SINGLE_COLUMN_TABLE_VARCHAR20_ASCII"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_VARCHAR20_ASCII: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(20) UTF8, but got VARCHAR(20) ASCII. (pushdown query: SELECT "SINGLE_COLUMN_TABLE_VARCHAR20_ASCII"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_VARCHAR20_ASCII") (Session: 1792879530403168256)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:219)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.selectAllFrom(AbstractExasolSqlDialectIT.java:204)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.selectAllFromCorrespondingVirtualTable(AbstractExasolSqlDialectIT.java:200)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualTableContents(AbstractExasolSqlDialectIT.java:170)
	... 4 more
Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_VARCHAR20_ASCII: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(20) UTF8, but got VARCHAR(20) ASCII. (pushdown query: SELECT "SINGLE_COLUMN_TABLE_VARCHAR20_ASCII"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_VARCHAR20_ASCII") (Session: 1792879530403168256)
	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)
	... 7 more