Skip to content

Releases: exasol/exasol-virtual-schema

8.0.0: Charset is always `utf-8`, deprecated IMPORT_DATA_TYPES `FROM_RESULT_SET` value

02 Apr 14:05
@github-actions github-actions
8.0.0
1c0ec6b
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Learn about vigilant mode.
Compare
Choose a tag to compare
8.0.0: Charset is always `utf-8`, deprecated IMPORT_DATA_TYPES `FROM_RESULT_SET` value Latest
Latest

The behaviour when it comes to character sets is now simplified,
The target charset is now always UTF-8.

The IMPORT_DATA_TYPES property (and value FROM_RESULT_SET) are now deprecated (change in vs-common-jdbc):
An exception will be thrown when users useFROM_RESULT_SET. The exception message warns the user that the value is no longer supported and the property itself is also deprecated.

Using timestamps with local timezone in the Exasol virtual schema now returns a proper timestamp with local timezone.

Querying char and varchar datatypes in LOCAL mode are now returned with UTF8 characterset, as expected.

Refactoring

  • #105: Updated tests to include Exasol V8/ Update to vsjdbc 12.0.0

Dependency Updates

Compile Dependency Updates

  • Updated com.exasol:virtual-schema-common-jdbc:11.0.2 to 12.0.0

Test Dependency Updates

  • Added com.exasol:udf-debugging-java:0.6.11
  • Updated com.exasol:virtual-schema-common-jdbc:11.0.2 to 12.0.0

Plugin Dependency Updates

  • Updated com.exasol:error-code-crawler-maven-plugin:1.3.1 to 2.0.1
  • Updated com.exasol:project-keeper-maven-plugin:3.0.1 to 4.2.0
  • Updated org.apache.maven.plugins:maven-compiler-plugin:3.11.0 to 3.12.1
  • Updated org.apache.maven.plugins:maven-failsafe-plugin:3.2.3 to 3.2.5
  • Updated org.apache.maven.plugins:maven-javadoc-plugin:3.4.1 to 3.6.3
  • Updated org.apache.maven.plugins:maven-surefire-plugin:3.2.3 to 3.2.5
  • Updated org.codehaus.mojo:flatten-maven-plugin:1.5.0 to 1.6.0
Assets 6
Loading

7.2.0: Add parameter `GENERATE_JDBC_DATATYPE_MAPPING_FOR_EXA`

22 Feb 10:35
@kaklakariada kaklakariada
7.2.0
af1f463
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Learn about vigilant mode.
Compare
Choose a tag to compare
7.2.0: Add parameter `GENERATE_JDBC_DATATYPE_MAPPING_FOR_EXA`

Summary

Using IMPORT FROM EXA might lead to some unexpected datatype mappings. Unlike for a JDBC connection there's no explicit data mapping being generated when using IMPORT FROM EXA. The Exasol specific types GEOMETRY, INTERVAL YEAR TO MONTH, INTERVAL DAY TO SECOND and HASHTYPE are mapped to VARCHAR. This release adds parameter GENERATE_JDBC_DATATYPE_MAPPING_FOR_EXA. When setting this to true, the data types are mapped as expected.

Setting GENERATE_JDBC_DATATYPE_MAPPING_FOR_EXA to true also fixes a bug when joining a table in a virtual schema with a normal table on a HASHTYPE column. This failed before in Exasol 7.1 with error message Feature not supported: Incomparable Types: VARCHAR(32) UTF8 and HASHTYPE(16 BYTE)!.

See the user guide for details.

This release also fixes vulnerabilities CVE-2024-25710 and CVE-2024-26308 in transitive test dependency org.apache.commons:commons-compress.

Security

Bugfixes

  • #119: Fixed data types for IMPORT FROM EXA

Dependency Updates

Test Dependency Updates

  • Updated com.exasol:exasol-testcontainers:6.6.3 to 7.0.1
  • Updated com.exasol:hamcrest-resultset-matcher:1.6.3 to 1.6.4
  • Updated com.exasol:test-db-builder-java:3.5.2 to 3.5.3
  • Updated org.junit.jupiter:junit-jupiter:5.10.1 to 5.10.2
  • Updated org.mockito:mockito-junit-jupiter:5.7.0 to 5.10.0
  • Updated org.slf4j:slf4j-jdk14:2.0.9 to 2.0.12
  • Updated org.testcontainers:junit-jupiter:1.19.2 to 1.19.6

Plugin Dependency Updates

  • Updated com.exasol:project-keeper-maven-plugin:2.9.16 to 3.0.1
  • Updated org.apache.maven.plugins:maven-failsafe-plugin:3.2.2 to 3.2.3
  • Updated org.apache.maven.plugins:maven-surefire-plugin:3.2.2 to 3.2.3
  • Added org.apache.maven.plugins:maven-toolchains-plugin:3.1.0
  • Updated org.codehaus.mojo:versions-maven-plugin:2.16.1 to 2.16.2
Assets 9
Loading

7.1.6: Fix CVE-2023-4043 in test dependency `org.eclipse.parsson:parsson`

21 Nov 10:01
@kaklakariada kaklakariada
7.1.6
9ef6b13
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.
Compare
Choose a tag to compare
7.1.6: Fix CVE-2023-4043 in test dependency `org.eclipse.parsson:parsson`

Summary

This release fixes vulnerability CVE-2023-4043 in test dependency org.eclipse.parsson:parsson.

Security

Dependency Updates

Test Dependency Updates

  • Updated com.exasol:exasol-testcontainers:6.6.2 to 6.6.3
  • Updated com.exasol:hamcrest-resultset-matcher:1.6.1 to 1.6.3
  • Updated com.exasol:test-db-builder-java:3.5.1 to 3.5.2
  • Updated org.jacoco:org.jacoco.agent:0.8.10 to 0.8.11
  • Updated org.junit.jupiter:junit-jupiter:5.10.0 to 5.10.1
  • Updated org.mockito:mockito-junit-jupiter:5.6.0 to 5.7.0
  • Updated org.testcontainers:junit-jupiter:1.19.1 to 1.19.2

Plugin Dependency Updates

  • Updated com.exasol:error-code-crawler-maven-plugin:1.3.0 to 1.3.1
  • Updated com.exasol:project-keeper-maven-plugin:2.9.12 to 2.9.16
  • Updated org.apache.maven.plugins:maven-dependency-plugin:3.6.0 to 3.6.1
  • Updated org.apache.maven.plugins:maven-enforcer-plugin:3.4.0 to 3.4.1
  • Updated org.apache.maven.plugins:maven-failsafe-plugin:3.1.2 to 3.2.2
  • Updated org.apache.maven.plugins:maven-surefire-plugin:3.1.2 to 3.2.2
  • Updated org.codehaus.mojo:versions-maven-plugin:2.16.0 to 2.16.1
  • Updated org.jacoco:jacoco-maven-plugin:0.8.10 to 0.8.11
  • Updated org.sonarsource.scanner.maven:sonar-maven-plugin:3.9.1.2184 to 3.10.0.2594
Assets 9
Loading

7.1.5: Dependency Upgrade

24 Oct 08:43
@ckunki ckunki
7.1.5
67c24c4
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.
Compare
Choose a tag to compare
7.1.5: Dependency Upgrade

Summary

This release fixes vulnerability CVE-2023-42503 in transitive test dependency to org.apache.commons:commons-compress via exasol-testcontainers by updating dependencies.

Security

*#110: Fixed vulnerability CVE-2023-42503 in test dependency org.apache.commons:commons-compress

Dependency Updates

Compile Dependency Updates

  • Updated com.exasol:virtual-schema-common-jdbc:11.0.1 to 11.0.2

Test Dependency Updates

  • Updated com.exasol:exasol-testcontainers:6.6.1 to 6.6.2
  • Updated com.exasol:hamcrest-resultset-matcher:1.6.0 to 1.6.1
  • Updated com.exasol:test-db-builder-java:3.4.2 to 3.5.1
  • Updated com.exasol:virtual-schema-common-jdbc:11.0.1 to 11.0.2
  • Updated org.junit.jupiter:junit-jupiter:5.9.3 to 5.10.0
  • Updated org.mockito:mockito-junit-jupiter:5.4.0 to 5.6.0
  • Updated org.slf4j:slf4j-jdk14:2.0.7 to 2.0.9
  • Updated org.testcontainers:junit-jupiter:1.18.3 to 1.19.1

Plugin Dependency Updates

  • Updated com.exasol:project-keeper-maven-plugin:2.9.9 to 2.9.12
  • Updated org.apache.maven.plugins:maven-enforcer-plugin:3.3.0 to 3.4.0
Assets 9
Loading

7.1.4: Fix Issue With Integer Constants in `GROUP BY`

12 Jul 09:36
@kaklakariada kaklakariada
7.1.4
7bc2aee
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.
Compare
Choose a tag to compare
7.1.4: Fix Issue With Integer Constants in `GROUP BY`

Summary

This release fixes an issue with queries using DISTINCT with integer constants. The Exasol SQL processor turns DISTINCT <integer> into GROUP BY <integer> before push-down as an optimization. The adapter must not feed this back as Exasol interprets integers in GROUP BY clauses as column numbers which could lead to invalid results or the following error:

42000:Wrong column number. Too small value 0 as select list column reference in GROUP BY (smallest possible value is 1)

To fix this, Exasol VS now replaces integer constants in GROUP BY clauses with a constant string.

Please that you can still safely use GROUP BY <column-number> in your original query, since Exasol internally converts this to GROUP BY "<column-name>", so that the virtual schema adapter can tell both situations apart.

Bugfixes

  • #108: Fixed issue with integer constants in GROUP BY

Dependency Updates

Compile Dependency Updates

  • Updated com.exasol:virtual-schema-common-jdbc:11.0.0 to 11.0.1

Test Dependency Updates

  • Updated com.exasol:exasol-testcontainers:6.6.0 to 6.6.1
  • Updated com.exasol:virtual-schema-common-jdbc:11.0.0 to 11.0.1

Plugin Dependency Updates

  • Updated org.apache.maven.plugins:maven-assembly-plugin:3.3.0 to 3.6.0
Assets 9
Loading

7.1.3: Refactoring

07 Jul 07:42
@ckunki ckunki
7.1.3
bd134d6
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.
Compare
Choose a tag to compare
7.1.3: Refactoring

Summary

This release replaces Adapter Property IS_LOCAL from virtual-schema-common-java by a constant in the current project as this property is specific to Exasol Virtual Schema.

See also ticket VSCOMJAVA #273 removing the adapter property from virtual-schema-common-java.

Refactoring

  • #85: Replaced adapter property IS_LOCAL from virtual-schema-common-java by a constant in VSEXA.

Dependency Updates

Compile Dependency Updates

  • Updated com.exasol:virtual-schema-common-jdbc:10.5.0 to 11.0.0

Test Dependency Updates

  • Updated com.exasol:virtual-schema-common-jdbc:10.5.0 to 11.0.0
  • Updated org.jacoco:org.jacoco.agent:0.8.9 to 0.8.10

Plugin Dependency Updates

  • Updated com.exasol:error-code-crawler-maven-plugin:1.2.3 to 1.3.0
  • Updated com.exasol:project-keeper-maven-plugin:2.9.7 to 2.9.9
  • Updated org.apache.maven.plugins:maven-dependency-plugin:3.5.0 to 3.6.0
  • Updated org.apache.maven.plugins:maven-failsafe-plugin:3.0.0 to 3.1.2
  • Updated org.apache.maven.plugins:maven-gpg-plugin:3.0.1 to 3.1.0
  • Updated org.apache.maven.plugins:maven-surefire-plugin:3.0.0 to 3.1.2
  • Updated org.basepom.maven:duplicate-finder-maven-plugin:1.5.1 to 2.0.1
  • Updated org.codehaus.mojo:flatten-maven-plugin:1.4.1 to 1.5.0
  • Updated org.codehaus.mojo:versions-maven-plugin:2.15.0 to 2.16.0
  • Updated org.jacoco:jacoco-maven-plugin:0.8.9 to 0.8.10
Assets 9
Loading

7.1.2: Documentation Update

20 Jun 17:10
@ckunki ckunki
7.1.2
38546d2
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.
Compare
Choose a tag to compare
7.1.2: Documentation Update

Summary

This release updates the documentation for the Exasol Virtual Schema dialect regarding known limitations.

Features

  • #104: Updated documentation regarding known limitations

Dependency Updates

Compile Dependency Updates

  • Updated com.exasol:exasol-jdbc:7.1.19 to 7.1.20
  • Removed org.glassfish:jakarta.json:2.0.1

Test Dependency Updates

  • Updated com.exasol:exasol-testcontainers:6.5.1 to 6.6.0
  • Updated com.exasol:hamcrest-resultset-matcher:1.5.3 to 1.6.0
  • Updated org.jacoco:org.jacoco.agent:0.8.8 to 0.8.9
  • Updated org.junit.jupiter:junit-jupiter:5.9.2 to 5.9.3
  • Updated org.mockito:mockito-junit-jupiter:5.2.0 to 5.4.0
  • Updated org.testcontainers:junit-jupiter:1.17.6 to 1.18.3

Plugin Dependency Updates

  • Updated com.exasol:error-code-crawler-maven-plugin:1.2.2 to 1.2.3
  • Updated com.exasol:project-keeper-maven-plugin:2.9.6 to 2.9.7
  • Updated org.apache.maven.plugins:maven-compiler-plugin:3.10.1 to 3.11.0
  • Updated org.apache.maven.plugins:maven-deploy-plugin:3.1.0 to 3.1.1
  • Updated org.apache.maven.plugins:maven-enforcer-plugin:3.2.1 to 3.3.0
  • Updated org.apache.maven.plugins:maven-failsafe-plugin:3.0.0-M8 to 3.0.0
  • Updated org.apache.maven.plugins:maven-surefire-plugin:3.0.0-M8 to 3.0.0
  • Added org.basepom.maven:duplicate-finder-maven-plugin:1.5.1
  • Updated org.codehaus.mojo:flatten-maven-plugin:1.3.0 to 1.4.1
  • Updated org.codehaus.mojo:versions-maven-plugin:2.14.2 to 2.15.0
  • Updated org.jacoco:jacoco-maven-plugin:0.8.8 to 0.8.9
Assets 9
Loading

7.1.1: Minor Fixes on Top of Version 7.1.0

29 Mar 17:10
@ckunki ckunki
7.1.1
7aff111
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.
Compare
Choose a tag to compare
7.1.1: Minor Fixes on Top of Version 7.1.0

Summary

This release fixes some minor problems and adds additional integration tests incl. a test for escaping wildcard when retrieving table metadata from JDBC driver and removes local classes in favor of those provided by version 10.4.0 of VSCJDBC.

Bugfixes

  • #89: Fixed inconsistent semantics of adapter property IMPORT_FROM_EXA
  • #90: Added test to verify that ALTER VIRTUAL SCHEMA triggers adapter properties validation

Documentation

  • #94: Added test for Add test for escaping wildcard when retrieving table metadata from JDBC driver.
  • #95: Removed duplicated classes

Dependency Updates

Compile Dependency Updates

  • Updated com.exasol:exasol-jdbc:7.1.17 to 7.1.19
  • Updated com.exasol:virtual-schema-common-jdbc:10.2.0 to 10.5.0

Test Dependency Updates

  • Updated com.exasol:hamcrest-resultset-matcher:1.5.2 to 1.5.3
  • Updated com.exasol:virtual-schema-common-jdbc:10.2.0 to 10.5.0
  • Updated org.mockito:mockito-junit-jupiter:5.1.1 to 5.2.0
  • Updated org.slf4j:slf4j-jdk14:2.0.6 to 2.0.7

Plugin Dependency Updates

  • Updated com.exasol:project-keeper-maven-plugin:2.9.3 to 2.9.6
  • Updated org.apache.maven.plugins:maven-deploy-plugin:3.0.0 to 3.1.0
  • Updated org.apache.maven.plugins:maven-enforcer-plugin:3.1.0 to 3.2.1
Assets 9
Loading

7.1.0: Mandatory Property SCHEMA_NAME

10 Mar 11:12
@ckunki ckunki
7.1.0
8136ef9
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.
Compare
Choose a tag to compare
7.1.0: Mandatory Property SCHEMA_NAME

Summary

This release updates VSEXA to take virtual schema property SCHEMA_NAME as mandatory in order to fix a bug when the property is not set.

Bugfixes

  • #92: Fixed broken handling of tables when SCHEMA_NAME property is not set

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.1.0 to 10.2.0

Test Dependency Updates

  • Updated com.exasol:exasol-testcontainers:6.5.0 to 6.5.1
  • Updated com.exasol:test-db-builder-java:3.4.1 to 3.4.2
  • Updated com.exasol:virtual-schema-common-jdbc:10.1.0 to 10.2.0
  • Updated org.mockito:mockito-junit-jupiter:5.0.0 to 5.1.1

Plugin Dependency Updates

  • Updated com.exasol:error-code-crawler-maven-plugin:1.2.1 to 1.2.2
  • Updated com.exasol:project-keeper-maven-plugin:2.9.1 to 2.9.3
  • Updated org.apache.maven.plugins:maven-dependency-plugin:3.3.0 to 3.5.0
  • Updated org.apache.maven.plugins:maven-failsafe-plugin:3.0.0-M7 to 3.0.0-M8
  • Updated org.apache.maven.plugins:maven-surefire-plugin:3.0.0-M7 to 3.0.0-M8
  • Updated org.codehaus.mojo:versions-maven-plugin:2.13.0 to 2.14.2
Assets 9
Loading

7.0.2: Deployment on Central Repository

19 Jan 10:21
@redcatbear redcatbear
7.0.2
5fc5a20
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Learn about vigilant mode.
Compare
Choose a tag to compare
7.0.2: Deployment on Central Repository

Summary

Exasol's RLS implementation depends on the Exasol Virtual Schema. To build it, the JAR file of the VS needs to be on the Central Repository (aka. "Maven Central").

We removed some debugging dependencies to reduce the complexity of the project.

Refactoring

  • #86: Configured deployment on Central Repository

Dependency Updates

Compile Dependency Updates

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

Test Dependency Updates

  • Removed com.exasol:exasol-test-setup-abstraction-java:0.3.2
  • Updated com.exasol:exasol-testcontainers:6.2.0 to 6.5.0
  • Updated com.exasol:hamcrest-resultset-matcher:1.5.1 to 1.5.2
  • Updated com.exasol:maven-project-version-getter:1.1.0 to 1.2.0
  • Updated com.exasol:test-db-builder-java:3.3.3 to 3.4.1
  • Removed com.exasol:udf-debugging-java:0.6.4
  • Updated com.exasol:virtual-schema-common-jdbc:10.0.1 to 10.1.0
  • Updated org.junit.jupiter:junit-jupiter:5.8.2 to 5.9.2
  • Updated org.mockito:mockito-junit-jupiter:4.6.1 to 5.0.0
  • Updated org.slf4j:slf4j-jdk14:1.7.36 to 2.0.6
  • Updated org.testcontainers:junit-jupiter:1.17.2 to 1.17.6

Plugin Dependency Updates

  • Updated com.exasol:error-code-crawler-maven-plugin:1.1.2 to 1.2.1
  • Updated com.exasol:project-keeper-maven-plugin:2.8.0 to 2.9.1
  • Updated io.github.zlika:reproducible-build-maven-plugin:0.15 to 0.16
  • Updated org.apache.maven.plugins:maven-deploy-plugin:2.7 to 3.0.0
  • Updated org.apache.maven.plugins:maven-failsafe-plugin:3.0.0-M5 to 3.0.0-M7
  • Added org.apache.maven.plugins:maven-gpg-plugin:3.0.1
  • Updated org.apache.maven.plugins:maven-jar-plugin:3.2.2 to 3.3.0
  • Added org.apache.maven.plugins:maven-javadoc-plugin:3.4.1
  • Added org.apache.maven.plugins:maven-source-plugin:3.2.1
  • Updated org.apache.maven.plugins:maven-surefire-plugin:3.0.0-M5 to 3.0.0-M7
  • 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.13.0
  • Added org.sonatype.plugins:nexus-staging-maven-plugin:1.6.13
Assets 9
Loading