2.2.0: Dependency Upgrade on top of 2.1.1

Summary

Updated dependencies to fix vulnerability CVE-2022-45688 in test dependency org.json:json:jar:20220924.

Please note that updated dependency virtual-schema-common-jdbc adds support for a new adapter property MAX_TABLE_COUNT and fixes ambiguous results by escaping SQL wildcards such as underscore _ and percent % in names of catalogs, schemas, and tables when retrieving column metadata from JDBC driver.

Security

• #18: Fixed vulnerabilities

Dependency Updates

Compile Dependency Updates

• Updated com.exasol:error-reporting-java:1.0.0 to 1.0.1
• Updated com.exasol:virtual-schema-common-jdbc:10.0.1 to 10.5.0

Test Dependency Updates

• Updated com.exasol:exasol-test-setup-abstraction-java:0.3.2 to 2.0.0
• Updated com.exasol:test-db-builder-java:3.4.1 to 3.4.2
• Updated com.exasol:udf-debugging-java:0.6.4 to 0.6.8
• Updated com.exasol:virtual-schema-common-jdbc:10.0.1 to 10.5.0
• Updated com.fasterxml.jackson.core:jackson-databind:2.13.4.2 to 2.14.2
• Updated com.google.cloud:google-cloud-bigquery:2.17.1 to 2.23.2
• Updated org.junit.jupiter:junit-jupiter:5.9.1 to 5.9.2
• Updated org.mockito:mockito-junit-jupiter:4.8.1 to 5.2.0
• Updated org.testcontainers:jdbc:1.17.5 to 1.17.6
• Updated org.testcontainers:junit-jupiter:1.17.5 to 1.17.6

Plugin Dependency Updates

• Updated com.exasol:artifact-reference-checker-maven-plugin:0.4.0 to 0.4.2
• Updated com.exasol:error-code-crawler-maven-plugin:1.1.2 to 1.2.2
• Updated com.exasol:project-keeper-maven-plugin:2.8.0 to 2.9.4
• Updated io.github.zlika:reproducible-build-maven-plugin:0.15 to 0.16
• Updated org.apache.maven.plugins:maven-assembly-plugin:3.3.0 to 3.5.0
• Updated org.apache.maven.plugins:maven-enforcer-plugin:3.1.0 to 3.2.1
• Updated org.apache.maven.plugins:maven-failsafe-plugin:3.0.0-M5 to 3.0.0-M8
• Updated org.apache.maven.plugins:maven-jar-plugin:3.2.2 to 3.3.0
• Updated org.apache.maven.plugins:maven-surefire-plugin:3.0.0-M5 to 3.0.0-M8
• Updated org.codehaus.mojo:flatten-maven-plugin:1.2.7 to 1.3.0
• Updated org.codehaus.mojo:versions-maven-plugin:2.10.0 to 2.14.2

2.1.0: Updated dependencies

Summary

Updated dependencies to fix vulnerabilities and changed error code prefix from VS-BIGQ to VSBIGQ.

Refactorings

• #11: Removed individual system property test.vs-logs and unconditional activation of LOG_LEVEL=ALL in favor of default system properties supported by test-db-builder-java, see TDBJ User Guide.
• #13 Updated to latest version of virtual-schema-common-jdbc providing enhanced data type detection of result sets in import statements. However there is no additional benefit as BigQuery uses SELECT FROM VALUES.
• #10: Changed error code prefix from VS-BIGQ to VSBIGQ.

Fixed vulnerabilities

• #12: Fixed vulnerabilities
  • com.google.protobuf:protobuf-java:jar:3.21.1 in test
    • CVE-2022-3171, severity CWE-400: Uncontrolled Resource Consumption ('Resource Exhaustion') (7.5)
  • com.fasterxml.jackson.core:jackson-databind:jar:2.13.3 in test
    • CVE-2022-42003, severity CWE-502: Deserialization of Untrusted Data (7.5)
    • CVE-2022-42004, severity CWE-502: Deserialization of Untrusted Data (7.5)

Dependency Updates

Compile Dependency Updates

• Updated com.exasol:error-reporting-java:0.4.1 to 1.0.0
• Updated com.exasol:virtual-schema-common-jdbc:9.0.5 to 10.0.1

Test Dependency Updates

• Updated com.exasol:hamcrest-resultset-matcher:1.5.1 to 1.5.2
• Updated com.exasol:test-db-builder-java:3.3.3 to 3.4.1
• Updated com.exasol:virtual-schema-common-jdbc:9.0.5 to 10.0.1
• Added com.fasterxml.jackson.core:jackson-databind:2.13.4.2
• Updated com.google.cloud:google-cloud-bigquery:2.14.0 to 2.17.1
• Removed io.grpc:grpc-core:1.48.0
• Removed io.netty:netty-common:4.1.79.Final
• Updated org.junit.jupiter:junit-jupiter:5.8.2 to 5.9.1
• Updated org.mockito:mockito-junit-jupiter:4.6.1 to 4.8.1
• Updated org.testcontainers:jdbc:1.17.3 to 1.17.5
• Updated org.testcontainers:junit-jupiter:1.17.3 to 1.17.5

Plugin Dependency Updates

• Updated com.exasol:error-code-crawler-maven-plugin:1.1.1 to 1.1.2
• Updated com.exasol:project-keeper-maven-plugin:2.5.0 to 2.8.0
• Updated org.apache.maven.plugins:maven-enforcer-plugin:3.0.0 to 3.1.0

2.0.2: Fix data type conversion

Summary

This release fixes conversions of the following BigQuery data types: DATE, TIMESTAMP, DATETIME and GEOGRAPHY.

It also fixes the following vulnerabilities by updating dependencies:

• CVE-2022-24823
• sonatype-2021-0818

Bugfixes

• #7: Fixed conversion of BigQuery data types DATE, TIMESTAMP, DATETIME and GEOGRAPHY.

Dependency Updates

Compile Dependency Updates

• Updated com.exasol:virtual-schema-common-jdbc:9.0.4 to 9.0.5

Test Dependency Updates

• Added com.exasol:exasol-test-setup-abstraction-java:0.3.2
• Added com.exasol:hamcrest-resultset-matcher:1.5.1
• Added com.exasol:test-db-builder-java:3.3.3
• Added com.exasol:udf-debugging-java:0.6.4
• Updated com.exasol:virtual-schema-common-jdbc:9.0.4 to 9.0.5
• Added com.google.cloud:google-cloud-bigquery:2.14.0
• Added io.grpc:grpc-core:1.48.0
• Added io.netty:netty-common:4.1.79.Final
• Updated org.junit.jupiter:junit-jupiter:5.8.1 to 5.8.2
• Updated org.mockito:mockito-junit-jupiter:4.1.0 to 4.6.1
• Added org.testcontainers:jdbc:1.17.3
• Added org.testcontainers:junit-jupiter:1.17.3

Plugin Dependency Updates

• Updated com.exasol:artifact-reference-checker-maven-plugin:0.3.1 to 0.4.0
• Updated com.exasol:error-code-crawler-maven-plugin:0.6.0 to 1.1.1
• Updated com.exasol:project-keeper-maven-plugin:1.3.2 to 2.5.0
• Updated io.github.zlika:reproducible-build-maven-plugin:0.13 to 0.15
• Updated org.apache.maven.plugins:maven-clean-plugin:3.1.0 to 2.5
• Updated org.apache.maven.plugins:maven-compiler-plugin:3.8.1 to 3.10.1
• Updated org.apache.maven.plugins:maven-deploy-plugin:3.0.0-M1 to 2.7
• Updated org.apache.maven.plugins:maven-enforcer-plugin:3.0.0-M3 to 3.0.0
• Added org.apache.maven.plugins:maven-failsafe-plugin:3.0.0-M5
• Updated org.apache.maven.plugins:maven-install-plugin:3.0.0-M1 to 2.4
• Updated org.apache.maven.plugins:maven-jar-plugin:3.2.0 to 3.2.2
• Updated org.apache.maven.plugins:maven-resources-plugin:3.2.0 to 2.6
• Updated org.apache.maven.plugins:maven-site-plugin:3.9.1 to 3.3
• Updated org.apache.maven.plugins:maven-surefire-plugin:3.0.0-M3 to 3.0.0-M5
• Added org.codehaus.mojo:flatten-maven-plugin:1.2.7
• Updated org.codehaus.mojo:versions-maven-plugin:2.7 to 2.10.0
• Updated org.jacoco:jacoco-maven-plugin:0.8.5 to 0.8.8
• Added org.sonarsource.scanner.maven:sonar-maven-plugin:3.9.1.2184
• Updated org.sonatype.ossindex.maven:ossindex-maven-plugin:3.1.0 to 3.2.0

2.0.1 – Dependency Updates

Dependency Updates

Compile Dependency Updates

• Updated com.exasol:error-reporting-java:0.2.2 to 0.4.1
• Updated com.exasol:virtual-schema-common-jdbc:9.0.1 to 9.0.4

Test Dependency Updates

• Updated com.exasol:virtual-schema-common-jdbc:9.0.1 to 9.0.4
• Updated org.junit.jupiter:junit-jupiter:5.7.1 to 5.8.1
• Updated org.mockito:mockito-junit-jupiter:3.8.0 to 4.1.0

Plugin Dependency Updates

• Updated com.exasol:error-code-crawler-maven-plugin:0.1.1 to 0.6.0
• Updated com.exasol:project-keeper-maven-plugin:0.4.2 to 1.3.2
• Added io.github.zlika:reproducible-build-maven-plugin:0.13

Removed `SQL_DIALECT` property

Summary

The SQL_DIALECT property used when executing a CREATE VIRTUAL SCHEMA from the Exasol database is obsolete from this version. Please, do not provide this property anymore.

Features

• #3: Added new capabilities for scalar functions.

Dependencies Updates

Runtime Dependencies

• Updated com.exasol:error-reporting-java:0.2.0 to 0.2.2
• Updated com.exasol:virtual-schema-common-jdbc:8.0.0 to 9.0.1

Test Dependencies

• Updated org.junit.jupiter:junit-jupiter:5.7.0 to 5.7.1
• Updated org.mockito:mockito-junit-jupiter:3.6.28 to 3.7.7

Plugin Dependencies

• Added com.exasol:error-code-crawler-maven-plugin:0.1.1

Migration from the virtual-schemas repository

Features / Enhancements

• #1: Migrated from the virtual-schemas repository

Runtime Dependencies

• Added com.exasol:virtual-schema-common-jdbc:8.0.0
• Added com.exasol:error-reporting-java:0.2.0

Test Dependencies

• Added org.hamcrest:hamcrest:2.2
• Added org.junit.jupiter:junit-jupiter:5.7.0
• Added org.mockito:mockito-junit-jupiter:3.6.28

Plugin Dependencies

• Added org.jacoco:jacoco-maven-plugin:0.8.5
• Added org.apache.maven.plugins:maven-surefire-plugin:3.0.0-M3
• Added org.apache.maven.plugins:maven-compiler-plugin:3.8.1
• Added org.apache.maven.plugins:maven-assembly-plugin:3.3.0
• Added org.apache.maven.plugins:maven-enforcer-plugin:3.0.0-M3
• Added org.codehaus.mojo:versions-maven-plugin:2.7
• Added com.exasol:artifact-reference-checker-maven-plugin:0.3.1
• Added com.exasol:project-keeper-maven-plugin:0.4.2
• Added org.sonatype.ossindex.maven:ossindex-maven-plugin:3.1.0