Fixed double literals

Summary

In this released we fixed double literals.

Bugfixes:

• #47: Fixed wrong data type for double literals
• #49: Fixed double literal rendering

Dependency Updates

Compile Dependency Updates

• Updated com.exasol:virtual-schema-common-jdbc:9.0.1 to 9.0.2

Test Dependency Updates

• Updated com.exasol:virtual-schema-common-jdbc:9.0.1 to 9.0.2

Plugin Dependency Updates

• Updated com.exasol:project-keeper-maven-plugin:0.4.2 to 0.5.0

Removed `SQL_DIALECT` property

Summary

The SQL_DIALECT property is obsolete. Please, do not provide this property anymore.

Feature

• #32: Get Geometry SRID(https://en.wikipedia.org/wiki/Spatial_reference_system#Identifier) from a system table instead of the hardcoded value.

Refactoring

• #40: Updated to the latest common part and added integration tests for new logic.
• #42: Enabled disabled integration tests after Exasol docker 7.0.7 became available.
• #36: Added error codes to the exception messages.

Dependency Updates

Runtime Dependencies

• Added com.exasol:error-reporting-java:0.2.2
• Updated com.exasol:virtual-schema-common-jdbc:7.0.0 to 9.0.1
• Updated com.exasol:exasol-jdbc:7.0.3 to 7.0.7
• Updated org.jacoco:org.jacoco.agent:0.8.5 to 0.8.6

Test Dependencies

• Updated com.exasol:exasol-testcontainer:3.3.1 to 3.5.0
• Updated com.exasol:hamcrest-resultset-matcher:1.2.1 to 1.4.0
• Updated com.exasol:test-db-builder-java:2.0.0 to 3.0.0
• Updated org.mockito:mockito-junit-jupiter:3.6.0 to 3.7.7
• Updated org.testcontainers:junit-jupiter:1.15.0 to 1.15.2
• Updated org.junit.jupiter:junit-jupiter:5.7.0 to 5.7.1
• Removed junit:junit:4.13.1

Maven Plugins

• Added com.exasol:error-code-crawler-maven-plugin:0.1.1
• Updated com.exasol:project-keeper-maven-plugin:0.4.0 to 0.4.2
• Updated org.codehaus.mojo:versions-maven-plugin:2.7 to 2.8.1

Fixed credentials exposure in EXA connection

Breaking Changes

If you used IMPORT ... FROM EXA in a previous version, you need to remove the old property EXA_CONNECTION_STRING,
create a named connection definition of type EXA with CREATE CONNECTION and provide the name of that definition in the
new property EXA_CONNECTION.

The old variant is intentionally not supported anymore to tighten security.

Bug Fixes

• #24: Get interval precision from system table.

Refactoring

• #24: Refactored integration tests.

Test Dependency Updates

• Added com.exasol:udf-debugging-java:0.3.0
• Added org.jacoco:org.jacoco.agent:0.8.5

Plugin Updates

• Added com.exasol:project-keeper-maven-plugin:0.4.0
• Added org.apache.maven.plugins:maven-dependency-plugin:3.1.2
• Updated org.jacoco:jacoco-maven-plugin:0.8.5 to 0.8.6

Security Update

Summary

Classification: High

Please update your adapters as soon as possible!

This release fixes several SQL injection vulnerabilities on the remote database of the virtual schema.
The local Exasol database defining the virtual schema is not affected.

This release also provides support for new capabilities:

FN_BIT_LROTATE
FN_BIT_RROTATE
FN_BIT_LSHIFT
FN_BIT_RSHIFT
FN_FROM_POSIX_TIME
FN_HOUR
FN_INITCAP
FN_AGG_EVERY
FN_AGG_SOME
FN_AGG_MUL_DISTINCT
FN_HASHTYPE_MD5
FN_HASHTYPE_SHA1
FN_HASHTYPE_SHA256
FN_HASHTYPE_SHA512
FN_HASHTYPE_TIGER
FN_MIN_SCALE
FN_AGG_LISTAGG
FN_AGG_LISTAGG_DISTINCT
FN_AGG_LISTAGG_SEPARATOR
FN_AGG_LISTAGG_ON_OVERFLOW_ERROR
FN_AGG_LISTAGG_ON_OVERFLOW_TRUNCATE
FN_AGG_LISTAGG_ORDER_BY
FN_AGG_COUNT_TUPLE

Bugs

• #30: Fixed a CVE-2020-15250 in a transitive dependency.

Features / Enhancements

• #16: Get interval precision from system table.

Documentation

• #15: Improved the documentation.

Refactoring:

• #18: Use test-db-builder for integration tests.
• #22: Updated to the new major version of virtual-schema-common-jdbc.
• #26: Updated to the new major version of virtual-schema-common-jdbc.

Dependency updates

• Added com.exasol:test-db-builder-java:1.1.0
• Added com.exasol:artifact-reference-checker-maven-plugin:0.3.1
• Added org.junit.jupiter:junit-jupiter:5.7.0
• Updated com.exasol:exasol-testcontainers:jar:2.0.3 to version 3.3.1
• Updated com.exasol:exasol-jdbc:6.2.5 to version 7.0.3
• Updated com.exasol:virtual-schema-common-jdbc:5.0.4 to version 7.0.0
• Updated com.exasol:hamcrest-resultset-matcher:1.1.1 to version 1.2.1
• Updated org.mockito:mockito-junit-jupiter:3.3.3 to version 3.6.0
• Updated org.testcontainers:junit-jupiter:1.14.3 to version 1.15.0
• Removed org.junit.jupiter:junit-jupiter-engine
• Removed org.junit.jupiter:junit-jupiter-params
• Removed org.junit.platform:junit-platform-runner

Added ossindex-maven-plugin and versions-maven-plugin, updated dependencies

Summary

From this release, Exasol Virtual Schema supports the new scalar function SESSION_PARAMETER.

Features / Enhancements

• #13: Added ossindex-maven-plugin and versions-maven-plugin, updated dependencies.

Dependency updates

Click to expand

• Added org.sonatype.ossindex.maven:ossindex-maven-plugin:3.1.0
• Added org.codehaus.mojo:versions-maven-plugin:2.7
• Added org.apache.maven.plugins:maven-enforcer-plugin:3.0.0-M3
• Updated org.apache.maven.plugins:maven-assembly-plugin from 3.2.0 to 3.3.0
• Updated org.apache.maven.plugins:maven-javadoc-plugin from 3.0.1 to 3.2.0
• Updated com.exasol:exasol-testcontainers from 2.0.0 to 2.0.3
• Updated com.exasol:hamcrest-resultset-matcher from 0.1.0 to 1.1.1
• Updated com.exasol:virtual-schema-common-jdbc from 5.0.1 to 5.0.2
• Updated org.junit.jupiter:junit-jupiter-engine from 5.6.1 to 5.6.2
• Updated org.junit.jupiter:junit-jupiter-params from 5.6.1 to 5.6.2
• Updated org.junit.platform:junit-platform-runner from 1.6.1 to 1.6.2
• Updated org.testcontainers:junit-jupiter from 1.13.0 to 1.14.3

Updated dependencies for a bug fix

Summary

In this release we adjusted the naming for the attached JAR file:

• Old naming pattern: exasol-virtual-schema-dist-[dialect version].jar
• New naming pattern: virtual-schema-dist-[virtual schema common jdbc version]-exasol-[dialect version].jar

The new naming pattern helps users to distinguish minor dialect changes from major adapter changes affecting all dialects.

Bug Fixes

• #11: Updated virtual-schema-common-java for fixing broken Aggregate Functions ST_INTERSECTION and ST_UNION.

Dependency updates

• Updated virtual-schema-common-jdbc from 5.0.0 to 5.0.1
• Removed virtual-schema-common-java

Removed deprecated properties

Summary

In this release we removed deprecated Virtual Schema properties CONNECTION_STRING, USERNAME and PASSWORD. Please, use CONNECTION_NAME property instead.

Changes

• #9: applied changes from the common parts, which include removing deprecated properties

New capabilities and TIMESTAMP WITH LOCAL TIME ZONE usage restrictions

Summary

In this release we added new capabilities to the Exasol dialect: IS JSON, IS NOT JSON, JSON_VALUE, MUL.

We restricted usage of TIMESTAMP WITH LOCAL TIME ZONE literal values due to the possibility to get an incorrect result when using literals and constant expressions. We recommend using 'TIMESTAMP' instead. If you are willing to take the risk and want to use TIMESTAMP WITH LOCAL TIME ZONE anyway, please, create a Virtual Schema with the following additional property IGNORE_ERRORS = 'TIMESTAMP_WITH_LOCAL_TIME_ZONE_USAGE'.

We also updated dialect documentation.

Changes

• #3: Updated the Exasol dialect documentation
• #6: Restricted usage of TIMESTAMP WITH LOCAL TIME ZONE literal values

Extracted Exasol dialect

Summary

In this release, we extracted Exasol dialect from https://github.com/exasol/row-level-security

Changes

• #1: Extracted Exasol dialect