Virtual Schema for Redshift 2.0.2, released 2022-??-??

February 16, 2023 ยท View on GitHub

Code name: Enhanced Data Type Detection for Result Sets Latest

Summary

Starting with version 7.1.14 Exasol database uses the capabilities reported by each virtual schema to provide select list data types for each push down request. Based on this information the JDBC virtual schemas no longer need to infer the data types of the result set by inspecting its values. Instead the JDBC virtual schemas can now use the information provided by the database.

This release provides enhanced data type detection for result sets by updating virtual-schema-common-jdbc to version 10.1.0. If this new detection mechanism causes issues (e.g. with encoding of CHAR and VARCHAR types) you can disable it by setting IMPORT_DATA_TYPES to value FROM_RESULT_SET when creating the virtual schema. See the documentation of JDBC adapter properties for details.

Refactorings

  • #12: Updated dependencies to use latest version of VSJDBC

Bugfixes

  • #10: Fixed broken links checker

Dependency Updates

Compile Dependency Updates

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

Test Dependency Updates

  • Updated com.exasol:virtual-schema-common-jdbc:9.0.4 to 10.1.0
  • Updated org.junit.jupiter:junit-jupiter:5.8.1 to 5.9.2
  • Updated org.mockito:mockito-junit-jupiter:4.1.0 to 5.1.1

Plugin Dependency Updates

  • Updated com.exasol:artifact-reference-checker-maven-plugin:0.3.2 to 0.4.2
  • Updated com.exasol:error-code-crawler-maven-plugin:0.1.1 to 1.2.2
  • Updated com.exasol:project-keeper-maven-plugin:1.3.1 to 2.9.3
  • Updated io.github.zlika:reproducible-build-maven-plugin:0.13 to 0.16
  • Updated org.apache.maven.plugins:maven-assembly-plugin:3.3.0 to 3.4.2
  • Updated org.apache.maven.plugins:maven-compiler-plugin:3.8.1 to 3.10.1
  • Updated org.apache.maven.plugins:maven-enforcer-plugin:3.0.0-M3 to 3.1.0
  • Updated org.apache.maven.plugins:maven-jar-plugin:3.2.0 to 3.3.0
  • Updated org.apache.maven.plugins:maven-surefire-plugin:3.0.0-M3 to 3.0.0-M8
  • Added org.codehaus.mojo:flatten-maven-plugin:1.3.0
  • Updated org.codehaus.mojo:versions-maven-plugin:2.7 to 2.14.2
  • 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