Skip to content
CI Build next Java

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

Sign in to view logs

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

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

Triggered via pull request March 5, 2024 15:16
@pj-spoelderspj-spoelders
synchronize #116
refactor/add_v8_to_ci
Status Success
Total duration 1m 0s
Artifacts –

ci-build-next-java.yml

on: pull_request
java-17-compatibility
45s
java-17-compatibility
Fit to window
Zoom out
Zoom in

Annotations

26 errors
ExasolSqlDialectExaConnectionIT.testNonDefaultGeometry: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L1
Multiple Failures (1 failure) java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_GEOMETRY4321"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_GEOMETRY4321: Data type mismatch in column number 1 (1-indexed).Expected GEOMETRY(4321), but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_GEOMETRY4321"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_GEOMETRY4321"') (Session: 1792700493200424960)
ExasolSqlDialectExaConnectionIT.testHashTypeWithBitSize: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L1
Multiple Failures (1 failure) java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_HASHTYPE16_BIT"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_HASHTYPE16_BIT: Data type mismatch in column number 1 (1-indexed).Expected HASHTYPE(2 BYTE), but got VARCHAR(4) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_HASHTYPE16_BIT"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_HASHTYPE16_BIT"') (Session: 1792700493200424960)
ExasolSqlDialectExaConnectionIT.testDefaultIntervalYearToMonth: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L1
Multiple Failures (1 failure) java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTERVAL_YEAR_TO_MONTH"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_YEAR_TO_MONTH: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL YEAR(2) TO MONTH, but got VARCHAR(6) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_YEAR_TO_MONTH"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_YEAR_TO_MONTH"') (Session: 1792700493200424960)
ExasolSqlDialectExaConnectionIT.testDefaultGeometry: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L1
Multiple Failures (1 failure) java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_GEOMETRY"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_GEOMETRY: Data type mismatch in column number 1 (1-indexed).Expected GEOMETRY, but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_GEOMETRY"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_GEOMETRY"') (Session: 1792700493200424960)
ExasolSqlDialectExaConnectionIT.testDefaultIntervalDayToSecond: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L1
Multiple Failures (1 failure) java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTERVAL_DAY_TO_SECOND"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_DAY_TO_SECOND: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL DAY(2) TO SECOND(3), but got VARCHAR(16) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_DAY_TO_SECOND"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_DAY_TO_SECOND"') (Session: 1792700493200424960)
ExasolSqlDialectExaConnectionIT.testGeometryMapping: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L1
Unable to execute assertion query for table SINGLE_COLUMN_TABLE_GEOMETRY
ExasolSqlDialectExaConnectionIT.testCaseGreaterThan: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L1
Unable to run assertion query: 'SELECT CASE WHEN C1 > 1 THEN 'YES' ELSE 'NO' END FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTEGER"'
ExasolSqlDialectExaConnectionIT.testNonDefaultIntervalYearToMonth: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L1
Multiple Failures (1 failure) java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTERVAL_YEAR4_TO_MONTH"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_YEAR4_TO_MONTH: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL YEAR(4) TO MONTH, but got VARCHAR(8) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_YEAR4_TO_MONTH"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_YEAR4_TO_MONTH"') (Session: 1792700493200424960)
ExasolSqlDialectExaConnectionIT.testNonDefaultIntervalDayToSecond: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L1
Multiple Failures (1 failure) java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTERVAL_DAY4_TO_SECOND6"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_INTERVAL_DAY4_TO_SECOND6: Data type mismatch in column number 1 (1-indexed).Expected INTERVAL DAY(4) TO SECOND(6), but got VARCHAR(21) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_INTERVAL_DAY4_TO_SECOND6"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_INTERVAL_DAY4_TO_SECOND6"') (Session: 1792700493200424960)
ExasolSqlDialectExaConnectionIT.testNonDefaultHashType: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L1
Multiple Failures (1 failure) java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_HASHTYPE4_BYTE"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_HASHTYPE4_BYTE: Data type mismatch in column number 1 (1-indexed).Expected HASHTYPE(4 BYTE), but got VARCHAR(8) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_HASHTYPE4_BYTE"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_HASHTYPE4_BYTE"') (Session: 1792700493200424960)
ExasolSqlDialectExaConnectionIT.testCastVarcharAsGeometry: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L1
Unable to run assertion query: 'SELECT CAST(C1 AS GEOMETRY(5)) FROM "THE_VS"."SINGLE_COLUMN_TABLE_VARCHAR20"'
ExasolSqlDialectExaConnectionIT.testCaseEqual: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L1
Unable to run assertion query: 'SELECT CASE C1 WHEN 1 THEN 'YES' WHEN 2 THEN 'PERHAPS' ELSE 'NO' END FROM "THE_VS"."SINGLE_COLUMN_TABLE_INTEGER"'
ExasolSqlDialectExaConnectionIT.testDefaultHashType: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L1
Multiple Failures (1 failure) java.sql.SQLException: Error executing 'SELECT C1 FROM "THE_VS"."SINGLE_COLUMN_TABLE_HASHTYPE"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_HASHTYPE: Data type mismatch in column number 1 (1-indexed).Expected HASHTYPE(16 BYTE), but got VARCHAR(32) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "SINGLE_COLUMN_TABLE_HASHTYPE"."C1" FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_HASHTYPE"') (Session: 1792700493200424960)
ExasolSqlDialectExaConnectionIT.testCastVarcharAsIntervalYearToMonth: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L1
Unable to run assertion query: 'SELECT CAST(C1 AS INTERVAL YEAR (5) TO MONTH) FROM "THE_VS"."SINGLE_COLUMN_TABLE_VARCHAR30"'
ExasolSqlDialectExaConnectionIT.testCastVarcharAsIntervalDayToSecond: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L1
Unable to run assertion query: 'SELECT CAST(C1 AS INTERVAL DAY (5) TO SECOND (2)) FROM "THE_VS"."SINGLE_COLUMN_TABLE_VARCHAR30"'
ExasolSqlDialectExaConnectionIT.testIntervalYearToMonthMapping: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L1
Unable to execute assertion query for table SINGLE_COLUMN_TABLE_INTERVAL_YEAR_9_TO_MONTH
ExasolSqlDialectExaConnectionIT.testIntervalDayToSecondMapping: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L1
Unable to execute assertion query for table SINGLE_COLUMN_TABLE_INTERVAL_DAY_9_TO_SECOND
ExasolSqlDialectExaConnectionIT.testPasswordNotVisibleInImportFromExa: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L78
Error executing 'EXPLAIN VIRTUAL SELECT * FROM "THE_VS"."T1"': Adapter generated invalid pushdown query for virtual table T1: Data type mismatch in column number 1 (1-indexed).Expected VARCHAR(20) UTF8, but got VARCHAR(2000000) UTF8. (pushdown query: IMPORT FROM EXA AT "EXA_CONNECTION" STATEMENT 'SELECT "T1"."C1" FROM "SOURCE_SCHEMA"."T1"') (Session: 1792700493200424960)
ExasolSqlDialectExaConnectionIT.testCharMappingAscii: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L110
Unable to execute assertion query for table SINGLE_COLUMN_TABLE_CHAR20_ASCII
ExasolSqlDialectExaConnectionIT.testCharMappingUtf8: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L116
Unable to execute assertion query for table SINGLE_COLUMN_TABLE_CHAR20_UTF8
ExasolSqlDialectExaConnectionIT.testCastVarcharToChar: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L122
Unable to run assertion query: 'SELECT CAST(C1 AS CHAR(40)) FROM "THE_VS"."SINGLE_COLUMN_TABLE_VARCHAR20"'
ExasolSqlDialectLocalConnectionIT.: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectLocalConnectionIT.java#L1
Container startup failed for image exasol/docker-db:8.24.0
ExasolSqlDialectExaConnectionIT.testCreateVirtualSchemaWithIgnoreErrorsProperty: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionIT.java#L1
Error executing 'SELECT NOW() - INTERVAL '1' MINUTE FROM "VIRTUAL_SCHEMA_IGNORES_ERRORS"."SINGLE_COLUMN_TABLE_BOOLEAN"': Execution of SQL Statement failed on external EXASolution. ['.' character is not allowed within quoted identifiers [line 1, column 23] (Session: 1792700735132205056)] (Session: 1792700572664987648)
ExasolSqlDialectExaConnectionWithDataTypesIT.testCreateVirtualSchemaWithIgnoreErrorsProperty: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectExaConnectionWithDataTypesIT.java#L1
Error executing 'SELECT NOW() - INTERVAL '1' MINUTE FROM "VIRTUAL_SCHEMA_IGNORES_ERRORS"."SINGLE_COLUMN_TABLE_BOOLEAN"': ETL-4213: Execution of SQL Statement failed on external EXASolution. ['.' character is not allowed within quoted identifiers [line 1, column 23] (Session: 1792700993088520192)] (Session: 1792700823755816960)
ExasolSqlDialectJdbcConnectionIT.testCreateVirtualSchemaWithIgnoreErrorsProperty: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectJdbcConnectionIT.java#L1
Error executing 'SELECT NOW() - INTERVAL '1' MINUTE FROM "VIRTUAL_SCHEMA_IGNORES_ERRORS"."SINGLE_COLUMN_TABLE_BOOLEAN"': ETL-5402: JDBC-Client-Error: Failed to initialize Query: '.' character is not allowed within quoted identifiers [line 1, column 23] (Session: 1792700486269206528) (Session: 1792700281692487680)
ExasolSqlDialectLocalConnectionIT.testCreateVirtualSchemaWithIgnoreErrorsProperty: src/test/java/com/exasol/adapter/dialects/exasol/ExasolSqlDialectLocalConnectionIT.java#L1
Error executing 'SELECT NOW() - INTERVAL '1' MINUTE FROM "VIRTUAL_SCHEMA_IGNORES_ERRORS"."SINGLE_COLUMN_TABLE_BOOLEAN"': Adapter generated invalid pushdown query for virtual table SINGLE_COLUMN_TABLE_BOOLEAN: Error during compilation: '.' character is not allowed within quoted identifiers [line 1, column 23] (pushdown query: SELECT LOCALTIMESTAMP '2024-03-05 15:21:42.192' FROM "SOURCE_SCHEMA"."SINGLE_COLUMN_TABLE_BOOLEAN") (Session: 1792700099934289920)