Skip to content

Fixed vulnerability CVE-2023-42503 #183

Fixed vulnerability CVE-2023-42503

Fixed vulnerability CVE-2023-42503 #183

GitHub Actions / Test Report failed Oct 24, 2023 in 0s

267 tests run, 0 skipped, 27 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.testNonDefaultGeometry

Multiple Failures (1 failure)
	java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_GEOMETRY4321"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_GEOMETRY4321: Data type mismatch in column number 1 (1-indexed).Expected GEOMETRY(4321), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_GEOMETRY4321"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_GEOMETRY4321"') (Session: 1780619561813934080)
Raw output
org.opentest4j.MultipleFailuresError: 
Multiple Failures (1 failure)
	java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_GEOMETRY4321"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_GEOMETRY4321: Data type mismatch in column number 1 (1-indexed).Expected GEOMETRY(4321), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_GEOMETRY4321"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_GEOMETRY4321"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualSchemaTypes(AbstractExasolSqlDialectIT.java:911)
	at com.exasol.adapter.dialects.exasol.DataTypeAssertion$Builder.runAssert(DataTypeAssertion.java:101)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testNonDefaultGeometry(AbstractExasolSqlDialectIT.java:784)
	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)
	Suppressed: java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_GEOMETRY4321"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_GEOMETRY4321: Data type mismatch in column number 1 (1-indexed).Expected GEOMETRY(4321), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_GEOMETRY4321"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_GEOMETRY4321"') (Session: 1780619561813934080)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertResultSetType(AbstractExasolSqlDialectIT.java:924)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.lambda$assertVirtualSchemaTypes$4(AbstractExasolSqlDialectIT.java:914)
		at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
		at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
		at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
		at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
		at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
		at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
		at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:578)
		... 6 more
	Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_GEOMETRY4321: Data type mismatch in column number 1 (1-indexed).Expected GEOMETRY(4321), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_GEOMETRY4321"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_GEOMETRY4321"') (Session: 1780619561813934080)
		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:193)
		... 15 more

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

Multiple Failures (1 failure)
	java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_HASHTYPE16_BIT"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_HASHTYPE16_BIT: Data type mismatch in column number 1 (1-indexed).Expected HASHTYPE(2 BYTE), but got VARCHAR(4) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_HASHTYPE16_BIT"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_HASHTYPE16_BIT"') (Session: 1780619561813934080)
Raw output
org.opentest4j.MultipleFailuresError: 
Multiple Failures (1 failure)
	java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_HASHTYPE16_BIT"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_HASHTYPE16_BIT: Data type mismatch in column number 1 (1-indexed).Expected HASHTYPE(2 BYTE), but got VARCHAR(4) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_HASHTYPE16_BIT"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_HASHTYPE16_BIT"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualSchemaTypes(AbstractExasolSqlDialectIT.java:911)
	at com.exasol.adapter.dialects.exasol.DataTypeAssertion$Builder.runAssert(DataTypeAssertion.java:101)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testHashTypeWithBitSize(AbstractExasolSqlDialectIT.java:766)
	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)
	Suppressed: java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_HASHTYPE16_BIT"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_HASHTYPE16_BIT: Data type mismatch in column number 1 (1-indexed).Expected HASHTYPE(2 BYTE), but got VARCHAR(4) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_HASHTYPE16_BIT"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_HASHTYPE16_BIT"') (Session: 1780619561813934080)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertResultSetType(AbstractExasolSqlDialectIT.java:924)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.lambda$assertVirtualSchemaTypes$4(AbstractExasolSqlDialectIT.java:914)
		at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
		at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
		at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
		at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
		at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
		at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
		at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:578)
		... 6 more
	Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_HASHTYPE16_BIT: Data type mismatch in column number 1 (1-indexed).Expected HASHTYPE(2 BYTE), but got VARCHAR(4) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_HASHTYPE16_BIT"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_HASHTYPE16_BIT"') (Session: 1780619561813934080)
		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:193)
		... 15 more

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

Expected: ResultSet with <1> rows and <5> columns
     but: ResultSet with <1> rows and <6> columns
Raw output
java.lang.AssertionError: 

Expected: ResultSet with <1> rows and <5> columns
     but: ResultSet with <1> rows and <6> columns
	at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
	at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVsQuery(AbstractExasolSqlDialectIT.java:356)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testWildcards(AbstractExasolSqlDialectIT.java:850)
	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)

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

Multiple Failures (1 failure)
	java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTERVAL_YEAR_TO_MONTH"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_YEAR_TO_MONTH: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL YEAR(2) TO MONTH, but got VARCHAR(6) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_YEAR_TO_MONTH"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_YEAR_TO_MONTH"') (Session: 1780619561813934080)
Raw output
org.opentest4j.MultipleFailuresError: 
Multiple Failures (1 failure)
	java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTERVAL_YEAR_TO_MONTH"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_YEAR_TO_MONTH: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL YEAR(2) TO MONTH, but got VARCHAR(6) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_YEAR_TO_MONTH"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_YEAR_TO_MONTH"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualSchemaTypes(AbstractExasolSqlDialectIT.java:911)
	at com.exasol.adapter.dialects.exasol.DataTypeAssertion$Builder.runAssert(DataTypeAssertion.java:101)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testDefaultIntervalYearToMonth(AbstractExasolSqlDialectIT.java:794)
	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)
	Suppressed: java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTERVAL_YEAR_TO_MONTH"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_YEAR_TO_MONTH: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL YEAR(2) TO MONTH, but got VARCHAR(6) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_YEAR_TO_MONTH"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_YEAR_TO_MONTH"') (Session: 1780619561813934080)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertResultSetType(AbstractExasolSqlDialectIT.java:924)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.lambda$assertVirtualSchemaTypes$4(AbstractExasolSqlDialectIT.java:914)
		at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
		at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
		at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
		at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
		at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
		at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
		at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:578)
		... 6 more
	Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_YEAR_TO_MONTH: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL YEAR(2) TO MONTH, but got VARCHAR(6) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_YEAR_TO_MONTH"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_YEAR_TO_MONTH"') (Session: 1780619561813934080)
		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:193)
		... 15 more

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.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:148)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testVarcharMappingAscii(AbstractExasolSqlDialectIT.java:202)
	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) ASCII, but got VARCHAR(20) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_VARCHAR20_ASCII"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_VARCHAR20_ASCII"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.selectAllFrom(AbstractExasolSqlDialectIT.java:180)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.selectAllFromCorrespondingVirtualTable(AbstractExasolSqlDialectIT.java:176)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualTableContents(AbstractExasolSqlDialectIT.java:146)
	... 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) ASCII, but got VARCHAR(20) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_VARCHAR20_ASCII"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_VARCHAR20_ASCII"') (Session: 1780619561813934080)
	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:193)
	... 7 more

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

Multiple Failures (1 failure)
	java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_GEOMETRY"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_GEOMETRY: Data type mismatch in column number 1 (1-indexed).Expected GEOMETRY, but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_GEOMETRY"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_GEOMETRY"') (Session: 1780619561813934080)
Raw output
org.opentest4j.MultipleFailuresError: 
Multiple Failures (1 failure)
	java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_GEOMETRY"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_GEOMETRY: Data type mismatch in column number 1 (1-indexed).Expected GEOMETRY, but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_GEOMETRY"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_GEOMETRY"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualSchemaTypes(AbstractExasolSqlDialectIT.java:911)
	at com.exasol.adapter.dialects.exasol.DataTypeAssertion$Builder.runAssert(DataTypeAssertion.java:101)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testDefaultGeometry(AbstractExasolSqlDialectIT.java:775)
	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)
	Suppressed: java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_GEOMETRY"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_GEOMETRY: Data type mismatch in column number 1 (1-indexed).Expected GEOMETRY, but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_GEOMETRY"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_GEOMETRY"') (Session: 1780619561813934080)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertResultSetType(AbstractExasolSqlDialectIT.java:924)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.lambda$assertVirtualSchemaTypes$4(AbstractExasolSqlDialectIT.java:914)
		at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
		at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
		at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
		at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
		at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
		at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
		at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:578)
		... 6 more
	Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_GEOMETRY: Data type mismatch in column number 1 (1-indexed).Expected GEOMETRY, but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_GEOMETRY"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_GEOMETRY"') (Session: 1780619561813934080)
		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:193)
		... 15 more

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

Multiple Failures (1 failure)
	java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTERVAL_DAY_TO_SECOND"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_DAY_TO_SECOND: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL DAY(2) TO SECOND(3), but got VARCHAR(16) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_DAY_TO_SECOND"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_DAY_TO_SECOND"') (Session: 1780619561813934080)
Raw output
org.opentest4j.MultipleFailuresError: 
Multiple Failures (1 failure)
	java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTERVAL_DAY_TO_SECOND"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_DAY_TO_SECOND: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL DAY(2) TO SECOND(3), but got VARCHAR(16) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_DAY_TO_SECOND"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_DAY_TO_SECOND"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualSchemaTypes(AbstractExasolSqlDialectIT.java:911)
	at com.exasol.adapter.dialects.exasol.DataTypeAssertion$Builder.runAssert(DataTypeAssertion.java:101)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testDefaultIntervalDayToSecond(AbstractExasolSqlDialectIT.java:816)
	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)
	Suppressed: java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTERVAL_DAY_TO_SECOND"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_DAY_TO_SECOND: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL DAY(2) TO SECOND(3), but got VARCHAR(16) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_DAY_TO_SECOND"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_DAY_TO_SECOND"') (Session: 1780619561813934080)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertResultSetType(AbstractExasolSqlDialectIT.java:924)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.lambda$assertVirtualSchemaTypes$4(AbstractExasolSqlDialectIT.java:914)
		at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
		at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
		at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
		at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
		at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
		at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
		at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:578)
		... 6 more
	Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_DAY_TO_SECOND: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL DAY(2) TO SECOND(3), but got VARCHAR(16) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_DAY_TO_SECOND"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_DAY_TO_SECOND"') (Session: 1780619561813934080)
		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:193)
		... 15 more

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

Unable to execute assertion query for table SINGLE_COLUMN_TABLE_GEOMETRY
Raw output
org.opentest4j.AssertionFailedError: Unable to execute assertion query for table SINGLE_COLUMN_TABLE_GEOMETRY
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualTableContents(AbstractExasolSqlDialectIT.java:148)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testGeometryMapping(AbstractExasolSqlDialectIT.java:318)
	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_GEOMETRY"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_GEOMETRY: Data type mismatch in column number 1 (1-indexed).Expected GEOMETRY, but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_GEOMETRY"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_GEOMETRY"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.selectAllFrom(AbstractExasolSqlDialectIT.java:180)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.selectAllFromCorrespondingVirtualTable(AbstractExasolSqlDialectIT.java:176)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualTableContents(AbstractExasolSqlDialectIT.java:146)
	... 4 more
Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_GEOMETRY: Data type mismatch in column number 1 (1-indexed).Expected GEOMETRY, but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_GEOMETRY"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_GEOMETRY"') (Session: 1780619561813934080)
	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:193)
	... 7 more

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

Unable to run assertion query: 'SELECT CASE WHEN C1 > 1 THEN 'YES' ELSE 'NO' END FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTEGER"'
Raw output
org.opentest4j.AssertionFailedError: Unable to run assertion query: 'SELECT CASE WHEN C1 > 1 THEN 'YES' ELSE 'NO' END FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTEGER"'
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVsQuery(AbstractExasolSqlDialectIT.java:358)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testCaseGreaterThan(AbstractExasolSqlDialectIT.java:476)
	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 CASE WHEN C1 > 1 THEN 'YES' ELSE 'NO' END FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTEGER"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTEGER: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(3) ASCII, but got VARCHAR(3) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT CASE WHEN 1 < "SINGLE_COLUMN_TABLE_INTEGER"."C1" THEN ''YES'' ELSE ''NO'' END FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTEGER"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVsQuery(AbstractExasolSqlDialectIT.java:356)
	... 4 more
Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTEGER: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(3) ASCII, but got VARCHAR(3) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT CASE WHEN 1 < "SINGLE_COLUMN_TABLE_INTEGER"."C1" THEN ''YES'' ELSE ''NO'' END FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTEGER"') (Session: 1780619561813934080)
	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:193)
	... 5 more

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

Multiple Failures (1 failure)
	java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTERVAL_YEAR4_TO_MONTH"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_YEAR4_TO_MONTH: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL YEAR(4) TO MONTH, but got VARCHAR(8) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_YEAR4_TO_MONTH"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_YEAR4_TO_MONTH"') (Session: 1780619561813934080)
Raw output
org.opentest4j.MultipleFailuresError: 
Multiple Failures (1 failure)
	java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTERVAL_YEAR4_TO_MONTH"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_YEAR4_TO_MONTH: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL YEAR(4) TO MONTH, but got VARCHAR(8) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_YEAR4_TO_MONTH"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_YEAR4_TO_MONTH"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualSchemaTypes(AbstractExasolSqlDialectIT.java:911)
	at com.exasol.adapter.dialects.exasol.DataTypeAssertion$Builder.runAssert(DataTypeAssertion.java:101)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testNonDefaultIntervalYearToMonth(AbstractExasolSqlDialectIT.java:805)
	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)
	Suppressed: java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTERVAL_YEAR4_TO_MONTH"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_YEAR4_TO_MONTH: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL YEAR(4) TO MONTH, but got VARCHAR(8) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_YEAR4_TO_MONTH"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_YEAR4_TO_MONTH"') (Session: 1780619561813934080)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertResultSetType(AbstractExasolSqlDialectIT.java:924)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.lambda$assertVirtualSchemaTypes$4(AbstractExasolSqlDialectIT.java:914)
		at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
		at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
		at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
		at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
		at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
		at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
		at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:578)
		... 6 more
	Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_YEAR4_TO_MONTH: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL YEAR(4) TO MONTH, but got VARCHAR(8) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_YEAR4_TO_MONTH"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_YEAR4_TO_MONTH"') (Session: 1780619561813934080)
		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:193)
		... 15 more

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

Multiple Failures (1 failure)
	java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTERVAL_DAY4_TO_SECOND6"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_DAY4_TO_SECOND6: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL DAY(4) TO SECOND(6), but got VARCHAR(21) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_DAY4_TO_SECOND6"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_DAY4_TO_SECOND6"') (Session: 1780619561813934080)
Raw output
org.opentest4j.MultipleFailuresError: 
Multiple Failures (1 failure)
	java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTERVAL_DAY4_TO_SECOND6"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_DAY4_TO_SECOND6: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL DAY(4) TO SECOND(6), but got VARCHAR(21) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_DAY4_TO_SECOND6"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_DAY4_TO_SECOND6"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualSchemaTypes(AbstractExasolSqlDialectIT.java:911)
	at com.exasol.adapter.dialects.exasol.DataTypeAssertion$Builder.runAssert(DataTypeAssertion.java:101)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testNonDefaultIntervalDayToSecond(AbstractExasolSqlDialectIT.java:827)
	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)
	Suppressed: java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTERVAL_DAY4_TO_SECOND6"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_DAY4_TO_SECOND6: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL DAY(4) TO SECOND(6), but got VARCHAR(21) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_DAY4_TO_SECOND6"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_DAY4_TO_SECOND6"') (Session: 1780619561813934080)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertResultSetType(AbstractExasolSqlDialectIT.java:924)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.lambda$assertVirtualSchemaTypes$4(AbstractExasolSqlDialectIT.java:914)
		at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
		at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
		at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
		at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
		at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
		at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
		at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:578)
		... 6 more
	Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_DAY4_TO_SECOND6: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL DAY(4) TO SECOND(6), but got VARCHAR(21) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_DAY4_TO_SECOND6"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_DAY4_TO_SECOND6"') (Session: 1780619561813934080)
		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:193)
		... 15 more

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"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_BOOLEAN: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3) WITH LOCAL TIME ZONE, but got TIMESTAMP(3). (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT TIMESTAMP ''2023-10-24 07:06:52.722'' FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_BOOLEAN"') (Session: 1780619561813934080)
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: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3) WITH LOCAL TIME ZONE, but got TIMESTAMP(3). (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT TIMESTAMP ''2023-10-24 07:06:52.722'' FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_BOOLEAN"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testCreateVirtualSchemaWithIgnoreErrorsProperty(AbstractExasolSqlDialectIT.java:579)
	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: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3) WITH LOCAL TIME ZONE, but got TIMESTAMP(3). (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT TIMESTAMP ''2023-10-24 07:06:52.722'' FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_BOOLEAN"') (Session: 1780619561813934080)
	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:193)
	... 4 more

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

Multiple Failures (1 failure)
	java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_HASHTYPE4_BYTE"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_HASHTYPE4_BYTE: Data type mismatch in column number 1 (1-indexed).Expected HASHTYPE(4 BYTE), but got VARCHAR(8) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_HASHTYPE4_BYTE"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_HASHTYPE4_BYTE"') (Session: 1780619561813934080)
Raw output
org.opentest4j.MultipleFailuresError: 
Multiple Failures (1 failure)
	java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_HASHTYPE4_BYTE"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_HASHTYPE4_BYTE: Data type mismatch in column number 1 (1-indexed).Expected HASHTYPE(4 BYTE), but got VARCHAR(8) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_HASHTYPE4_BYTE"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_HASHTYPE4_BYTE"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualSchemaTypes(AbstractExasolSqlDialectIT.java:911)
	at com.exasol.adapter.dialects.exasol.DataTypeAssertion$Builder.runAssert(DataTypeAssertion.java:101)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testNonDefaultHashType(AbstractExasolSqlDialectIT.java:757)
	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)
	Suppressed: java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_HASHTYPE4_BYTE"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_HASHTYPE4_BYTE: Data type mismatch in column number 1 (1-indexed).Expected HASHTYPE(4 BYTE), but got VARCHAR(8) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_HASHTYPE4_BYTE"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_HASHTYPE4_BYTE"') (Session: 1780619561813934080)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertResultSetType(AbstractExasolSqlDialectIT.java:924)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.lambda$assertVirtualSchemaTypes$4(AbstractExasolSqlDialectIT.java:914)
		at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
		at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
		at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
		at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
		at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
		at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
		at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:578)
		... 6 more
	Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_HASHTYPE4_BYTE: Data type mismatch in column number 1 (1-indexed).Expected HASHTYPE(4 BYTE), but got VARCHAR(8) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_HASHTYPE4_BYTE"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_HASHTYPE4_BYTE"') (Session: 1780619561813934080)
		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:193)
		... 15 more

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

Unable to run assertion query: 'SELECT CAST(C1 AS GEOMETRY(5)) FROM "THE_VS"."SINGLE_COLUMN_TABLE_VARCHAR20"'
Raw output
org.opentest4j.AssertionFailedError: Unable to run assertion query: 'SELECT CAST(C1 AS GEOMETRY(5)) FROM "THE_VS"."SINGLE_COLUMN_TABLE_VARCHAR20"'
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVsQuery(AbstractExasolSqlDialectIT.java:358)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT$CastAssertionBuilder.verify(AbstractExasolSqlDialectIT.java:1007)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testCastVarcharAsGeometry(AbstractExasolSqlDialectIT.java:442)
	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 CAST(C1 AS GEOMETRY(5)) FROM "THE_VS"."SINGLE_COLUMN_TABLE_VARCHAR20"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_VARCHAR20: Data type mismatch in column number 1 (1-indexed).Expected GEOMETRY(5), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT CAST("SINGLE_COLUMN_TABLE_VARCHAR20"."C1" AS GEOMETRY(5)) FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_VARCHAR20"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVsQuery(AbstractExasolSqlDialectIT.java:356)
	... 5 more
Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_VARCHAR20: Data type mismatch in column number 1 (1-indexed).Expected GEOMETRY(5), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT CAST("SINGLE_COLUMN_TABLE_VARCHAR20"."C1" AS GEOMETRY(5)) FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_VARCHAR20"') (Session: 1780619561813934080)
	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:193)
	... 6 more

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

Unable to run assertion query: 'SELECT CASE C1 WHEN 1 THEN 'YES' WHEN 2 THEN 'PERHAPS' ELSE 'NO' END FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTEGER"'
Raw output
org.opentest4j.AssertionFailedError: Unable to run assertion query: 'SELECT CASE C1 WHEN 1 THEN 'YES' WHEN 2 THEN 'PERHAPS' ELSE 'NO' END FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTEGER"'
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVsQuery(AbstractExasolSqlDialectIT.java:358)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testCaseEqual(AbstractExasolSqlDialectIT.java:467)
	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 CASE C1 WHEN 1 THEN 'YES' WHEN 2 THEN 'PERHAPS' ELSE 'NO' END FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTEGER"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTEGER: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(7) ASCII, but got VARCHAR(7) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT CASE "SINGLE_COLUMN_TABLE_INTEGER"."C1" WHEN 1 THEN ''YES'' WHEN 2 THEN ''PERHAPS'' ELSE ''NO'' END FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTEGER"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVsQuery(AbstractExasolSqlDialectIT.java:356)
	... 4 more
Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTEGER: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(7) ASCII, but got VARCHAR(7) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT CASE "SINGLE_COLUMN_TABLE_INTEGER"."C1" WHEN 1 THEN ''YES'' WHEN 2 THEN ''PERHAPS'' ELSE ''NO'' END FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTEGER"') (Session: 1780619561813934080)
	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:193)
	... 5 more

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

Multiple Failures (1 failure)
	java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_HASHTYPE"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_HASHTYPE: Data type mismatch in column number 1 (1-indexed).Expected HASHTYPE(16 BYTE), but got VARCHAR(32) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_HASHTYPE"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_HASHTYPE"') (Session: 1780619561813934080)
Raw output
org.opentest4j.MultipleFailuresError: 
Multiple Failures (1 failure)
	java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_HASHTYPE"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_HASHTYPE: Data type mismatch in column number 1 (1-indexed).Expected HASHTYPE(16 BYTE), but got VARCHAR(32) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_HASHTYPE"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_HASHTYPE"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualSchemaTypes(AbstractExasolSqlDialectIT.java:911)
	at com.exasol.adapter.dialects.exasol.DataTypeAssertion$Builder.runAssert(DataTypeAssertion.java:101)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testDefaultHashType(AbstractExasolSqlDialectIT.java:748)
	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)
	Suppressed: java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_HASHTYPE"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_HASHTYPE: Data type mismatch in column number 1 (1-indexed).Expected HASHTYPE(16 BYTE), but got VARCHAR(32) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_HASHTYPE"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_HASHTYPE"') (Session: 1780619561813934080)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertResultSetType(AbstractExasolSqlDialectIT.java:924)
		at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.lambda$assertVirtualSchemaTypes$4(AbstractExasolSqlDialectIT.java:914)
		at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
		at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
		at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
		at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
		at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
		at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
		at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:578)
		... 6 more
	Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_HASHTYPE: Data type mismatch in column number 1 (1-indexed).Expected HASHTYPE(16 BYTE), but got VARCHAR(32) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_HASHTYPE"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_HASHTYPE"') (Session: 1780619561813934080)
		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:193)
		... 15 more

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

Unable to run assertion query: 'SELECT CAST(C1 AS INTERVAL YEAR (5) TO MONTH) FROM "THE_VS"."SINGLE_COLUMN_TABLE_VARCHAR30"'
Raw output
org.opentest4j.AssertionFailedError: Unable to run assertion query: 'SELECT CAST(C1 AS INTERVAL YEAR (5) TO MONTH) FROM "THE_VS"."SINGLE_COLUMN_TABLE_VARCHAR30"'
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVsQuery(AbstractExasolSqlDialectIT.java:358)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT$CastAssertionBuilder.verify(AbstractExasolSqlDialectIT.java:1007)
	at com.exasol.adapter.dialects.exasol.AbstractRemoteExasolVirtualSchemaConnectionIT.testCastVarcharAsIntervalYearToMonth(AbstractRemoteExasolVirtualSchemaConnectionIT.java:60)
	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 CAST(C1 AS INTERVAL YEAR (5) TO MONTH) FROM "THE_VS"."SINGLE_COLUMN_TABLE_VARCHAR30"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_VARCHAR30: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL YEAR(5) TO MONTH, but got VARCHAR(9) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT CAST("SINGLE_COLUMN_TABLE_VARCHAR30"."C1" AS INTERVAL YEAR (5) TO MONTH) FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_VARCHAR30"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVsQuery(AbstractExasolSqlDialectIT.java:356)
	... 5 more
Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_VARCHAR30: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL YEAR(5) TO MONTH, but got VARCHAR(9) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT CAST("SINGLE_COLUMN_TABLE_VARCHAR30"."C1" AS INTERVAL YEAR (5) TO MONTH) FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_VARCHAR30"') (Session: 1780619561813934080)
	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:193)
	... 6 more

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

Unable to run assertion query: 'SELECT CAST(C1 AS INTERVAL DAY (5) TO SECOND (2)) FROM "THE_VS"."SINGLE_COLUMN_TABLE_VARCHAR30"'
Raw output
org.opentest4j.AssertionFailedError: Unable to run assertion query: 'SELECT CAST(C1 AS INTERVAL DAY (5) TO SECOND (2)) FROM "THE_VS"."SINGLE_COLUMN_TABLE_VARCHAR30"'
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVsQuery(AbstractExasolSqlDialectIT.java:358)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT$CastAssertionBuilder.verify(AbstractExasolSqlDialectIT.java:1007)
	at com.exasol.adapter.dialects.exasol.AbstractRemoteExasolVirtualSchemaConnectionIT.testCastVarcharAsIntervalDayToSecond(AbstractRemoteExasolVirtualSchemaConnectionIT.java:53)
	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 CAST(C1 AS INTERVAL DAY (5) TO SECOND (2)) FROM "THE_VS"."SINGLE_COLUMN_TABLE_VARCHAR30"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_VARCHAR30: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL DAY(5) TO SECOND(2), but got VARCHAR(18) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT CAST("SINGLE_COLUMN_TABLE_VARCHAR30"."C1" AS INTERVAL DAY (5) TO SECOND (2)) FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_VARCHAR30"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVsQuery(AbstractExasolSqlDialectIT.java:356)
	... 5 more
Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_VARCHAR30: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL DAY(5) TO SECOND(2), but got VARCHAR(18) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT CAST("SINGLE_COLUMN_TABLE_VARCHAR30"."C1" AS INTERVAL DAY (5) TO SECOND (2)) FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_VARCHAR30"') (Session: 1780619561813934080)
	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:193)
	... 6 more

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

Unable to execute assertion query for table SINGLE_COLUMN_TABLE_INTERVAL_YEAR_9_TO_MONTH
Raw output
org.opentest4j.AssertionFailedError: Unable to execute assertion query for table SINGLE_COLUMN_TABLE_INTERVAL_YEAR_9_TO_MONTH
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualTableContents(AbstractExasolSqlDialectIT.java:148)
	at com.exasol.adapter.dialects.exasol.AbstractRemoteExasolVirtualSchemaConnectionIT.testInvervalYearToMonthMapping(AbstractRemoteExasolVirtualSchemaConnectionIT.java:22)
	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_INTERVAL_YEAR_9_TO_MONTH"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_YEAR_9_TO_MONTH: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL YEAR(9) TO MONTH, but got VARCHAR(13) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_YEAR_9_TO_MONTH"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_YEAR_9_TO_MONTH"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.selectAllFrom(AbstractExasolSqlDialectIT.java:180)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.selectAllFromCorrespondingVirtualTable(AbstractExasolSqlDialectIT.java:176)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualTableContents(AbstractExasolSqlDialectIT.java:146)
	... 4 more
Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_YEAR_9_TO_MONTH: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL YEAR(9) TO MONTH, but got VARCHAR(13) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_YEAR_9_TO_MONTH"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_YEAR_9_TO_MONTH"') (Session: 1780619561813934080)
	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:193)
	... 7 more

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

Unable to execute assertion query for table SINGLE_COLUMN_TABLE_INTERVAL_DAY_9_TO_SECOND
Raw output
org.opentest4j.AssertionFailedError: Unable to execute assertion query for table SINGLE_COLUMN_TABLE_INTERVAL_DAY_9_TO_SECOND
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualTableContents(AbstractExasolSqlDialectIT.java:148)
	at com.exasol.adapter.dialects.exasol.AbstractRemoteExasolVirtualSchemaConnectionIT.testIntervalDayToSecondMapping(AbstractRemoteExasolVirtualSchemaConnectionIT.java:40)
	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_INTERVAL_DAY_9_TO_SECOND"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_DAY_9_TO_SECOND: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL DAY(9) TO SECOND(3), but got VARCHAR(23) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_DAY_9_TO_SECOND"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_DAY_9_TO_SECOND"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.selectAllFrom(AbstractExasolSqlDialectIT.java:180)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.selectAllFromCorrespondingVirtualTable(AbstractExasolSqlDialectIT.java:176)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualTableContents(AbstractExasolSqlDialectIT.java:146)
	... 4 more
Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_DAY_9_TO_SECOND: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL DAY(9) TO SECOND(3), but got VARCHAR(23) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_DAY_9_TO_SECOND"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_DAY_9_TO_SECOND"') (Session: 1780619561813934080)
	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:193)
	... 7 more

Check failure on line 78 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.testPasswordNotVisibleInImportFromExa

Error executing 'EXPLAIN VIRTUAL SELECT * FROM "THE_VS"."T1"': Adapter generated invalid pushdown query for virtual table T1: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(20) UTF8, but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "T1"."C1" FROM "SOURCE_SCHEMA"."T1"') (Session: 1780619561813934080)
Raw output
java.sql.SQLException: Error executing 'EXPLAIN VIRTUAL SELECT * FROM "THE_VS"."T1"': Adapter generated invalid pushdown query for virtual table T1: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(20) UTF8, but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "T1"."C1" FROM "SOURCE_SCHEMA"."T1"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
	at com.exasol.adapter.dialects.exasol.ExasolSqlDialectExaConnectionIT.explainVirtual(ExasolSqlDialectExaConnectionIT.java:103)
	at com.exasol.adapter.dialects.exasol.ExasolSqlDialectExaConnectionIT.testPasswordNotVisibleInImportFromExa(ExasolSqlDialectExaConnectionIT.java:78)
	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 T1: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(20) UTF8, but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "T1"."C1" FROM "SOURCE_SCHEMA"."T1"') (Session: 1780619561813934080)
	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:193)
	... 5 more

Check failure on line 110 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.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:148)
	at com.exasol.adapter.dialects.exasol.ExasolSqlDialectExaConnectionIT.testCharMappingAscii(ExasolSqlDialectExaConnectionIT.java:110)
	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) ASCII, but got VARCHAR(20) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_CHAR20_ASCII"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_CHAR20_ASCII"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.selectAllFrom(AbstractExasolSqlDialectIT.java:180)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.selectAllFromCorrespondingVirtualTable(AbstractExasolSqlDialectIT.java:176)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualTableContents(AbstractExasolSqlDialectIT.java:146)
	... 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) ASCII, but got VARCHAR(20) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_CHAR20_ASCII"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_CHAR20_ASCII"') (Session: 1780619561813934080)
	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:193)
	... 7 more

Check failure on line 116 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.testCharMappingUtf8

Unable to execute assertion query for table SINGLE_COLUMN_TABLE_CHAR20_UTF8
Raw output
org.opentest4j.AssertionFailedError: Unable to execute assertion query for table SINGLE_COLUMN_TABLE_CHAR20_UTF8
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualTableContents(AbstractExasolSqlDialectIT.java:148)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.verifyCharMappingUtf8(AbstractExasolSqlDialectIT.java:207)
	at com.exasol.adapter.dialects.exasol.ExasolSqlDialectExaConnectionIT.testCharMappingUtf8(ExasolSqlDialectExaConnectionIT.java:116)
	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_UTF8"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_CHAR20_UTF8: Data type mismatch in column number 1 (1-indexed).Expected CHAR(20) UTF8, but got VARCHAR(20) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_CHAR20_UTF8"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_CHAR20_UTF8"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.selectAllFrom(AbstractExasolSqlDialectIT.java:180)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.selectAllFromCorrespondingVirtualTable(AbstractExasolSqlDialectIT.java:176)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVirtualTableContents(AbstractExasolSqlDialectIT.java:146)
	... 5 more
Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_CHAR20_UTF8: Data type mismatch in column number 1 (1-indexed).Expected CHAR(20) UTF8, but got VARCHAR(20) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_CHAR20_UTF8"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_CHAR20_UTF8"') (Session: 1780619561813934080)
	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:193)
	... 8 more

Check failure on line 122 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.testCastVarcharToChar

Unable to run assertion query: 'SELECT CAST(C1 AS CHAR(40)) FROM "THE_VS"."SINGLE_COLUMN_TABLE_VARCHAR20"'
Raw output
org.opentest4j.AssertionFailedError: Unable to run assertion query: 'SELECT CAST(C1 AS CHAR(40)) FROM "THE_VS"."SINGLE_COLUMN_TABLE_VARCHAR20"'
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVsQuery(AbstractExasolSqlDialectIT.java:358)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT$CastAssertionBuilder.verify(AbstractExasolSqlDialectIT.java:1007)
	at com.exasol.adapter.dialects.exasol.ExasolSqlDialectExaConnectionIT.testCastVarcharToChar(ExasolSqlDialectExaConnectionIT.java:122)
	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 CAST(C1 AS CHAR(40)) FROM "THE_VS"."SINGLE_COLUMN_TABLE_VARCHAR20"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_VARCHAR20: Data type mismatch in column number 1 (1-indexed).Expected CHAR(40) UTF8, but got VARCHAR(40) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT CAST("SINGLE_COLUMN_TABLE_VARCHAR20"."C1" AS CHAR(40) UTF8) FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_VARCHAR20"') (Session: 1780619561813934080)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.query(AbstractExasolSqlDialectIT.java:195)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVsQuery(AbstractExasolSqlDialectIT.java:356)
	... 5 more
Caused by: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_VARCHAR20: Data type mismatch in column number 1 (1-indexed).Expected CHAR(40) UTF8, but got VARCHAR(40) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT CAST("SINGLE_COLUMN_TABLE_VARCHAR20"."C1" AS CHAR(40) UTF8) FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_VARCHAR20"') (Session: 1780619561813934080)
	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:193)
	... 6 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.testWildcards

Expected: ResultSet with <1> rows and <5> columns
     but: ResultSet with <1> rows and <6> columns
Raw output
java.lang.AssertionError: 

Expected: ResultSet with <1> rows and <5> columns
     but: ResultSet with <1> rows and <6> columns
	at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
	at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.assertVsQuery(AbstractExasolSqlDialectIT.java:356)
	at com.exasol.adapter.dialects.exasol.AbstractExasolSqlDialectIT.testWildcards(AbstractExasolSqlDialectIT.java:850)
	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)