Skip to content
CI Build

Add v8 to ci #118

Sign in to view logs

Add v8 to ci

Add v8 to ci #118

GitHub Actions / Test Report failed Nov 8, 2023 in 0s

286 tests run, 9 skipped, 46 failed.

Annotations

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testTimestampOra(String, String)[1] 

Multiple Failures (2 failures)
	java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C11" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (2 failures)
	java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C11" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testTimestampOra(OracleSqlDialectIT.java:910)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
		at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
		at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testTimestampOra$40(OracleSqlDialectIT.java:911)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C11" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT.assertExplainVirtual(OracleSqlDialectIT.java:461)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testTimestampOra$41(OracleSqlDialectIT.java:912)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testTimestampOra(String, String)[2] 

Multiple Failures (2 failures)
	java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C12" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (2 failures)
	java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C12" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testTimestampOra(OracleSqlDialectIT.java:910)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
		at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
		at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testTimestampOra$40(OracleSqlDialectIT.java:911)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C12" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT.assertExplainVirtual(OracleSqlDialectIT.java:461)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testTimestampOra$41(OracleSqlDialectIT.java:912)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testTimestampOra(String, String)[3] 

Multiple Failures (2 failures)
	java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C13" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (2 failures)
	java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C13" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testTimestampOra(OracleSqlDialectIT.java:910)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
		at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
		at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testTimestampOra$40(OracleSqlDialectIT.java:911)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C13" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT.assertExplainVirtual(OracleSqlDialectIT.java:461)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testTimestampOra$41(OracleSqlDialectIT.java:912)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testTimestampOra(String, String)[4] 

Multiple Failures (3 failures)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got TIMESTAMP(3) WITH LOCAL TIME ZONE. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C14" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C14" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (3 failures)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got TIMESTAMP(3) WITH LOCAL TIME ZONE. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C14" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C14" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testTimestampOra(OracleSqlDialectIT.java:910)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got TIMESTAMP(3) WITH LOCAL TIME ZONE. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C14" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT$DatatypeTest.assertExpressionExecutionTimestampResult(OracleSqlDialectIT.java:917)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testTimestampOra$39(OracleSqlDialectIT.java:910)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more
	Suppressed: java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
		at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
		at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testTimestampOra$40(OracleSqlDialectIT.java:911)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C14" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT.assertExplainVirtual(OracleSqlDialectIT.java:461)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testTimestampOra$41(OracleSqlDialectIT.java:912)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testTimestampOra(String, String)[5] 

Multiple Failures (3 failures)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got TIMESTAMP(3) WITH LOCAL TIME ZONE. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C15" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C15" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (3 failures)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got TIMESTAMP(3) WITH LOCAL TIME ZONE. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C15" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C15" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testTimestampOra(OracleSqlDialectIT.java:910)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got TIMESTAMP(3) WITH LOCAL TIME ZONE. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C15" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT$DatatypeTest.assertExpressionExecutionTimestampResult(OracleSqlDialectIT.java:917)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testTimestampOra$39(OracleSqlDialectIT.java:910)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more
	Suppressed: java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
		at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
		at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testTimestampOra$40(OracleSqlDialectIT.java:911)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C15" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT.assertExplainVirtual(OracleSqlDialectIT.java:461)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testTimestampOra$41(OracleSqlDialectIT.java:912)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testNumberColumns(String, String, String, String)[5] 

Multiple Failures (1 failure)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(2000000) UTF8, but got VARCHAR(40) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT TO_CHAR("TABLE_ORACLE_ALL_DATA_TYPES"."C5") FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (1 failure)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(2000000) UTF8, but got VARCHAR(40) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT TO_CHAR("TABLE_ORACLE_ALL_DATA_TYPES"."C5") FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testNumberColumns(OracleSqlDialectIT.java:793)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(2000000) UTF8, but got VARCHAR(40) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT TO_CHAR("TABLE_ORACLE_ALL_DATA_TYPES"."C5") FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT.assertExpressionExecutionBigDecimalResult(OracleSqlDialectIT.java:454)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testNumberColumns$25(OracleSqlDialectIT.java:793)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testNumberColumns(String, String, String, String)[6] 

Multiple Failures (1 failure)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(36,0), but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C_NUMBER36" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (1 failure)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(36,0), but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C_NUMBER36" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testNumberColumns(OracleSqlDialectIT.java:793)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(36,0), but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C_NUMBER36" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT.assertExpressionExecutionBigDecimalResult(OracleSqlDialectIT.java:454)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testNumberColumns$25(OracleSqlDialectIT.java:793)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testNumberColumns(String, String, String, String)[7] 

Multiple Failures (1 failure)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(2000000) UTF8, but got VARCHAR(40) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT TO_CHAR("TABLE_ORACLE_ALL_DATA_TYPES"."C6") FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (1 failure)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(2000000) UTF8, but got VARCHAR(40) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT TO_CHAR("TABLE_ORACLE_ALL_DATA_TYPES"."C6") FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testNumberColumns(OracleSqlDialectIT.java:793)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(2000000) UTF8, but got VARCHAR(40) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT TO_CHAR("TABLE_ORACLE_ALL_DATA_TYPES"."C6") FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT.assertExpressionExecutionBigDecimalResult(OracleSqlDialectIT.java:454)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testNumberColumns$25(OracleSqlDialectIT.java:793)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testNumberColumns(String, String, String, String)[8] 

Multiple Failures (1 failure)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(10,5), but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C7" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (1 failure)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(10,5), but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C7" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testNumberColumns(OracleSqlDialectIT.java:793)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(10,5), but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C7" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT.assertExpressionExecutionBigDecimalResult(OracleSqlDialectIT.java:454)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testNumberColumns$25(OracleSqlDialectIT.java:793)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testDate(String)[1] 

Multiple Failures (1 failure)
	java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (1 failure)
	java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testDate(OracleSqlDialectIT.java:865)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
		at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
		at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testDate$35(OracleSqlDialectIT.java:866)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 44 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testDate(String)[2] 

Multiple Failures (2 failures)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got DATE. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C10" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (2 failures)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got DATE. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C10" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testDate(OracleSqlDialectIT.java:865)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected TIMESTAMP(3), but got DATE. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C10" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT$DatatypeTest.assertExpressionExecutionDateResult(OracleSqlDialectIT.java:870)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testDate$34(OracleSqlDialectIT.java:865)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 44 more
	Suppressed: java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
		at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
		at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testDate$35(OracleSqlDialectIT.java:866)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 44 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testSelectAllTimestampColumns(String, String)[1] 

Multiple Failures (3 failures)
	java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
	java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
	java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (3 failures)
	java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
	java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
	java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testSelectAllTimestampColumns(OracleSqlDialectIT.java:966)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
		at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
		at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testSelectAllTimestampColumns$49(OracleSqlDialectIT.java:967)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more
	Suppressed: java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
		at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
		at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testSelectAllTimestampColumns$50(OracleSqlDialectIT.java:968)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more
	Suppressed: java.lang.AssertionError: 
Expected: "TIMESTAMP"
     but: was "TIMESTAMP(3)"
		at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
		at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testSelectAllTimestampColumns$51(OracleSqlDialectIT.java:969)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testSelectAllTimestampColumns(String, String)[2] 

Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_TIMESTAMPS: Data type mismatch in column number 2 (1-indexed).Expected TIMESTAMP(3), but got TIMESTAMP(3) WITH LOCAL TIME ZONE. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_TIMESTAMPS"."A", "TABLE_ORACLE_TIMESTAMPS"."B", "TABLE_ORACLE_TIMESTAMPS"."C" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_TIMESTAMPS"') (Session: 1781982152711667712)
Raw output 
java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_TIMESTAMPS: Data type mismatch in column number 2 (1-indexed).Expected TIMESTAMP(3), but got TIMESTAMP(3) WITH LOCAL TIME ZONE. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_TIMESTAMPS"."A", "TABLE_ORACLE_TIMESTAMPS"."B", "TABLE_ORACLE_TIMESTAMPS"."C" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_TIMESTAMPS"') (Session: 1781982152711667712)
	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.oracle.OracleSqlDialectIT$DatatypeTest.testSelectAllTimestampColumns(OracleSqlDialectIT.java:965)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	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 com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testIntervalYear(String)[2] 

Multiple Failures (1 failure)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(2000000) UTF8, but got VARCHAR(7) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT TO_CHAR("TABLE_ORACLE_ALL_DATA_TYPES"."C16") FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (1 failure)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(2000000) UTF8, but got VARCHAR(7) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT TO_CHAR("TABLE_ORACLE_ALL_DATA_TYPES"."C16") FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testIntervalYear(OracleSqlDialectIT.java:930)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(2000000) UTF8, but got VARCHAR(7) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT TO_CHAR("TABLE_ORACLE_ALL_DATA_TYPES"."C16") FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT$DatatypeTest.assertExpressionExecutionStringResult(OracleSqlDialectIT.java:584)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testIntervalYear$42(OracleSqlDialectIT.java:930)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 44 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testAggregateSingleGroup(String, String)[2] 

Multiple Failures (2 failures)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(10,5), but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT CAST(MIN("TABLE_ORACLE_ALL_DATA_TYPES"."C7") AS FLOAT) FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(10,5), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT CAST(MIN("TABLE_ORACLE_ALL_DATA_TYPES"."C7") AS FLOAT) FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (2 failures)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(10,5), but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT CAST(MIN("TABLE_ORACLE_ALL_DATA_TYPES"."C7") AS FLOAT) FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(10,5), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT CAST(MIN("TABLE_ORACLE_ALL_DATA_TYPES"."C7") AS FLOAT) FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testAggregateSingleGroup(OracleSqlDialectIT.java:611)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(10,5), but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT CAST(MIN("TABLE_ORACLE_ALL_DATA_TYPES"."C7") AS FLOAT) FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT$DatatypeTest.assertExpressionExecutionStringResult(OracleSqlDialectIT.java:584)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testAggregateSingleGroup$4(OracleSqlDialectIT.java:611)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(10,5), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT CAST(MIN("TABLE_ORACLE_ALL_DATA_TYPES"."C7") AS FLOAT) FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT.assertExplainVirtual(OracleSqlDialectIT.java:461)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testAggregateSingleGroup$5(OracleSqlDialectIT.java:612)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testOrderByColumn(String)[2] 

Multiple Failures (2 failures)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected CHAR(50) ASCII, but got VARCHAR(50) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C1" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" ORDER BY "TABLE_ORACLE_ALL_DATA_TYPES"."C1" DESC NULLS LAST') (Session: 1781982152711667712)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected CHAR(50) ASCII, but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C1" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" ORDER BY "TABLE_ORACLE_ALL_DATA_TYPES"."C1" DESC NULLS LAST') (Session: 1781982152711667712)
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (2 failures)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected CHAR(50) ASCII, but got VARCHAR(50) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C1" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" ORDER BY "TABLE_ORACLE_ALL_DATA_TYPES"."C1" DESC NULLS LAST') (Session: 1781982152711667712)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected CHAR(50) ASCII, but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C1" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" ORDER BY "TABLE_ORACLE_ALL_DATA_TYPES"."C1" DESC NULLS LAST') (Session: 1781982152711667712)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testOrderByColumn(OracleSqlDialectIT.java:697)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected CHAR(50) ASCII, but got VARCHAR(50) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C1" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" ORDER BY "TABLE_ORACLE_ALL_DATA_TYPES"."C1" DESC NULLS LAST') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT$DatatypeTest.assertExpressionExecutionStringResult(OracleSqlDialectIT.java:584)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testOrderByColumn$14(OracleSqlDialectIT.java:697)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 44 more
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected CHAR(50) ASCII, but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C1" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" ORDER BY "TABLE_ORACLE_ALL_DATA_TYPES"."C1" DESC NULLS LAST') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT.assertExplainVirtual(OracleSqlDialectIT.java:461)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testOrderByColumn$15(OracleSqlDialectIT.java:698)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 44 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testBinaryDouble(String)[2] 

Multiple Failures (1 failure)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(2000000) UTF8, but got VARCHAR(40) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT TO_CHAR("TABLE_ORACLE_ALL_DATA_TYPES"."C_BINDOUBLE") FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (1 failure)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(2000000) UTF8, but got VARCHAR(40) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT TO_CHAR("TABLE_ORACLE_ALL_DATA_TYPES"."C_BINDOUBLE") FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testBinaryDouble(OracleSqlDialectIT.java:829)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(2000000) UTF8, but got VARCHAR(40) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT TO_CHAR("TABLE_ORACLE_ALL_DATA_TYPES"."C_BINDOUBLE") FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT$DatatypeTest.assertExpressionExecutionDoubleResult(OracleSqlDialectIT.java:836)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testBinaryDouble$29(OracleSqlDialectIT.java:829)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 44 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testFloatNumbers(String, String, String, String)[4] 

Multiple Failures (1 failure)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(2000000) UTF8, but got VARCHAR(40) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT TO_CHAR("TABLE_ORACLE_ALL_DATA_TYPES"."C_BINFLOAT") FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (1 failure)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(2000000) UTF8, but got VARCHAR(40) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT TO_CHAR("TABLE_ORACLE_ALL_DATA_TYPES"."C_BINFLOAT") FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testFloatNumbers(OracleSqlDialectIT.java:811)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(2000000) UTF8, but got VARCHAR(40) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT TO_CHAR("TABLE_ORACLE_ALL_DATA_TYPES"."C_BINFLOAT") FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT$DatatypeTest.assertExpressionExecutionFloatResult(OracleSqlDialectIT.java:818)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testFloatNumbers$27(OracleSqlDialectIT.java:811)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testFloatNumbers(String, String, String, String)[5] 

Multiple Failures (1 failure)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DOUBLE, but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C_FLOAT" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (1 failure)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DOUBLE, but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C_FLOAT" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testFloatNumbers(OracleSqlDialectIT.java:811)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DOUBLE, but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C_FLOAT" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT$DatatypeTest.assertExpressionExecutionFloatResult(OracleSqlDialectIT.java:818)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testFloatNumbers$27(OracleSqlDialectIT.java:811)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testFloatNumbers(String, String, String, String)[6] 

Multiple Failures (1 failure)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DOUBLE, but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C_FLOAT126" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (1 failure)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DOUBLE, but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C_FLOAT126" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testFloatNumbers(OracleSqlDialectIT.java:811)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DOUBLE, but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C_FLOAT126" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT$DatatypeTest.assertExpressionExecutionFloatResult(OracleSqlDialectIT.java:818)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testFloatNumbers$27(OracleSqlDialectIT.java:811)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testFilterExpression(String, String)[3] 

Multiple Failures (2 failures)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(10,5), but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C7" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" WHERE 12346 < "TABLE_ORACLE_ALL_DATA_TYPES"."C7"') (Session: 1781982152711667712)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(10,5), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C7" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" WHERE 12346 < "TABLE_ORACLE_ALL_DATA_TYPES"."C7"') (Session: 1781982152711667712)
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (2 failures)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(10,5), but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C7" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" WHERE 12346 < "TABLE_ORACLE_ALL_DATA_TYPES"."C7"') (Session: 1781982152711667712)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(10,5), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C7" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" WHERE 12346 < "TABLE_ORACLE_ALL_DATA_TYPES"."C7"') (Session: 1781982152711667712)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testFilterExpression(OracleSqlDialectIT.java:599)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(10,5), but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C7" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" WHERE 12346 < "TABLE_ORACLE_ALL_DATA_TYPES"."C7"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT$DatatypeTest.assertExpressionExecutionStringResult(OracleSqlDialectIT.java:584)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testFilterExpression$2(OracleSqlDialectIT.java:599)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(10,5), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C7" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" WHERE 12346 < "TABLE_ORACLE_ALL_DATA_TYPES"."C7"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT.assertExplainVirtual(OracleSqlDialectIT.java:461)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testFilterExpression$3(OracleSqlDialectIT.java:600)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testAggregateGroupByExpressionOra 

Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DOUBLE, but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT CAST(("TABLE_ORACLE_ALL_DATA_TYPES"."C5" + 1) AS FLOAT), CAST(MIN("TABLE_ORACLE_ALL_DATA_TYPES"."C7") AS FLOAT) FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" GROUP BY ("TABLE_ORACLE_ALL_DATA_TYPES"."C5" + 1) ORDER BY ("TABLE_ORACLE_ALL_DATA_TYPES"."C5" + 1) DESC') (Session: 1781982152711667712)
Raw output 
java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DOUBLE, but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT CAST(("TABLE_ORACLE_ALL_DATA_TYPES"."C5" + 1) AS FLOAT), CAST(MIN("TABLE_ORACLE_ALL_DATA_TYPES"."C7") AS FLOAT) FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" GROUP BY ("TABLE_ORACLE_ALL_DATA_TYPES"."C5" + 1) ORDER BY ("TABLE_ORACLE_ALL_DATA_TYPES"."C5" + 1) DESC') (Session: 1781982152711667712)
	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.oracle.OracleSqlDialectIT$DatatypeTest.testAggregateGroupByExpressionOra(OracleSqlDialectIT.java:641)
	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)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testSelectExpression(String, String)[2] 

Multiple Failures (2 failures)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(11,5), but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT CAST(("TABLE_ORACLE_ALL_DATA_TYPES"."C7" + 1) AS FLOAT) FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" ORDER BY ("TABLE_ORACLE_ALL_DATA_TYPES"."C7" + 1)') (Session: 1781982152711667712)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(11,5), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT CAST(("TABLE_ORACLE_ALL_DATA_TYPES"."C7" + 1) AS FLOAT) FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" ORDER BY ("TABLE_ORACLE_ALL_DATA_TYPES"."C7" + 1)') (Session: 1781982152711667712)
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (2 failures)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(11,5), but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT CAST(("TABLE_ORACLE_ALL_DATA_TYPES"."C7" + 1) AS FLOAT) FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" ORDER BY ("TABLE_ORACLE_ALL_DATA_TYPES"."C7" + 1)') (Session: 1781982152711667712)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(11,5), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT CAST(("TABLE_ORACLE_ALL_DATA_TYPES"."C7" + 1) AS FLOAT) FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" ORDER BY ("TABLE_ORACLE_ALL_DATA_TYPES"."C7" + 1)') (Session: 1781982152711667712)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testSelectExpression(OracleSqlDialectIT.java:578)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(11,5), but got VARCHAR(1024) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT CAST(("TABLE_ORACLE_ALL_DATA_TYPES"."C7" + 1) AS FLOAT) FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" ORDER BY ("TABLE_ORACLE_ALL_DATA_TYPES"."C7" + 1)') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT$DatatypeTest.assertExpressionExecutionStringResult(OracleSqlDialectIT.java:584)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testSelectExpression$0(OracleSqlDialectIT.java:578)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected DECIMAL(11,5), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT CAST(("TABLE_ORACLE_ALL_DATA_TYPES"."C7" + 1) AS FLOAT) FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" ORDER BY ("TABLE_ORACLE_ALL_DATA_TYPES"."C7" + 1)') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT.assertExplainVirtual(OracleSqlDialectIT.java:461)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testSelectExpression$1(OracleSqlDialectIT.java:579)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more

Check failure on line 1 in com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testIntervalDay(String)[2] 

Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(2000000) UTF8, but got VARCHAR(20) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT TO_CHAR("TABLE_ORACLE_ALL_DATA_TYPES"."C17") FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" ORDER BY "TABLE_ORACLE_ALL_DATA_TYPES"."C17"') (Session: 1781982152711667712)
Raw output 
java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(2000000) UTF8, but got VARCHAR(20) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT TO_CHAR("TABLE_ORACLE_ALL_DATA_TYPES"."C17") FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES" ORDER BY "TABLE_ORACLE_ALL_DATA_TYPES"."C17"') (Session: 1781982152711667712)
	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.oracle.OracleSqlDialectIT$DatatypeTest.testIntervalDay(OracleSqlDialectIT.java:943)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	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 com/exasol/adapter/dialects/oracle/OracleSqlDialectIT$DatatypeTest

See this annotation in the file changed.

@github-actions github-actions / Test Report

OracleSqlDialectIT$DatatypeTest.testCharactersColumns(String, String, String, String)[5] 

Multiple Failures (1 failure)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected CHAR(50) ASCII, but got VARCHAR(50) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C1" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
Raw output 
org.opentest4j.MultipleFailuresError: 
Multiple Failures (1 failure)
	java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected CHAR(50) ASCII, but got VARCHAR(50) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C1" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:80)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:44)
	at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:38)
	at org.junit.jupiter.api.Assertions.assertAll(Assertions.java:2944)
	at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.testCharactersColumns(OracleSqlDialectIT.java:757)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
	at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
	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.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
	at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
	at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
	at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
	Suppressed: java.sql.SQLException: Adapter generated invalid pushdown query for virtual table TABLE_ORACLE_ALL_DATA_TYPES: Data type mismatch in column number 1 (1-indexed).Expected CHAR(50) ASCII, but got VARCHAR(50) UTF8. (pushdown query: IMPORT FROM ORA AT ORACLE_CONNECTION STATEMENT 'SELECT "TABLE_ORACLE_ALL_DATA_TYPES"."C1" FROM "SCHEMA_ORACLE_1699430414280"."TABLE_ORACLE_ALL_DATA_TYPES"') (Session: 1781982152711667712)
		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.oracle.OracleSqlDialectIT$DatatypeTest.assertExpressionExecutionStringResult(OracleSqlDialectIT.java:584)
		at com.exasol.adapter.dialects.oracle.OracleSqlDialectIT$DatatypeTest.lambda$testCharactersColumns$22(OracleSqlDialectIT.java:757)
		at org.junit.jupiter.api.AssertAll.lambda$assertAll$0(AssertAll.java:68)
		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)
		at org.junit.jupiter.api.AssertAll.assertAll(AssertAll.java:77)
		... 37 more
View more details on GitHub Actions