Releases: exasol/sql-statement-builder
4.6.1 Upgrade Project Keeper
This release upgrades Project Keeper and dependencies.
Dependency Updates
Test Dependency Updates
- Added
org.junit.jupiter:junit-jupiter-params:5.13.4 - Removed
org.junit.jupiter:junit-jupiter:5.12.2 - Removed
org.mockito:mockito-core:5.17.0 - Updated
org.mockito:mockito-junit-jupiter:5.17.0to5.20.0
Plugin Dependency Updates
- Updated
com.exasol:error-code-crawler-maven-plugin:2.0.3to2.0.5 - Updated
com.exasol:project-keeper-maven-plugin:5.0.1to5.4.3 - Updated
com.exasol:quality-summarizer-maven-plugin:0.2.0to0.2.1 - Updated
io.github.git-commit-id:git-commit-id-maven-plugin:9.0.1to9.0.2 - Updated
org.apache.maven.plugins:maven-artifact-plugin:3.6.0to3.6.1 - Updated
org.apache.maven.plugins:maven-clean-plugin:3.4.1to3.5.0 - Updated
org.apache.maven.plugins:maven-compiler-plugin:3.14.0to3.14.1 - Updated
org.apache.maven.plugins:maven-enforcer-plugin:3.5.0to3.6.2 - Updated
org.apache.maven.plugins:maven-gpg-plugin:3.2.7to3.2.8 - Updated
org.apache.maven.plugins:maven-javadoc-plugin:3.11.2to3.12.0 - Updated
org.apache.maven.plugins:maven-surefire-plugin:3.5.2to3.5.4 - Updated
org.codehaus.mojo:flatten-maven-plugin:1.7.0to1.7.3 - Updated
org.codehaus.mojo:versions-maven-plugin:2.18.0to2.19.1 - Updated
org.itsallcode:openfasttrace-maven-plugin:1.6.1to2.3.0 - Updated
org.jacoco:jacoco-maven-plugin:0.8.12to0.8.14 - Updated
org.sonarsource.scanner.maven:sonar-maven-plugin:5.0.0.4389to5.2.0.4988 - Added
org.sonatype.central:central-publishing-maven-plugin:0.9.0 - Removed
org.sonatype.plugins:nexus-staging-maven-plugin:1.7.0
4.6.0 Timestamps with precision
This release adds support for specifying the fractional seconds precision for columns of type TIMESTAMP and
TIMESTAMP WITH LOCAL TIMEZONE
Features
- #176 Support
TIMESTAMPwith precision
Dependency Updates
Test Dependency Updates
- Updated
nl.jqno.equalsverifier:equalsverifier:3.14.1to3.19.4 - Removed
org.hamcrest:hamcrest-all:1.3 - Added
org.hamcrest:hamcrest:3.0 - Updated
org.junit.jupiter:junit-jupiter:5.9.2to5.12.2 - Updated
org.mockito:mockito-core:5.2.0to5.17.0 - Updated
org.mockito:mockito-junit-jupiter:5.2.0to5.17.0
Plugin Dependency Updates
- Updated
com.exasol:error-code-crawler-maven-plugin:1.2.2to2.0.3 - Updated
com.exasol:project-keeper-maven-plugin:2.9.6to5.0.1 - Added
com.exasol:quality-summarizer-maven-plugin:0.2.0 - Added
io.github.git-commit-id:git-commit-id-maven-plugin:9.0.1 - Removed
io.github.zlika:reproducible-build-maven-plugin:0.16 - Added
org.apache.maven.plugins:maven-artifact-plugin:3.6.0 - Updated
org.apache.maven.plugins:maven-clean-plugin:3.2.0to3.4.1 - Updated
org.apache.maven.plugins:maven-compiler-plugin:3.10.1to3.14.0 - Updated
org.apache.maven.plugins:maven-deploy-plugin:3.1.0to3.1.4 - Updated
org.apache.maven.plugins:maven-enforcer-plugin:3.2.1to3.5.0 - Updated
org.apache.maven.plugins:maven-gpg-plugin:3.0.1to3.2.7 - Updated
org.apache.maven.plugins:maven-install-plugin:3.1.2to3.1.4 - Updated
org.apache.maven.plugins:maven-javadoc-plugin:3.4.1to3.11.2 - Updated
org.apache.maven.plugins:maven-site-plugin:3.12.1to3.21.0 - Updated
org.apache.maven.plugins:maven-surefire-plugin:3.0.0-M8to3.5.2 - Added
org.apache.maven.plugins:maven-toolchains-plugin:3.2.0 - Added
org.basepom.maven:duplicate-finder-maven-plugin:2.0.1 - Updated
org.codehaus.mojo:flatten-maven-plugin:1.3.0to1.7.0 - Updated
org.codehaus.mojo:versions-maven-plugin:2.14.2to2.18.0 - Updated
org.jacoco:jacoco-maven-plugin:0.8.8to0.8.12 - Updated
org.sonarsource.scanner.maven:sonar-maven-plugin:3.9.1.2184to5.0.0.4389 - Updated
org.sonatype.plugins:nexus-staging-maven-plugin:1.6.13to1.7.0
4.5.3: Removed outdated `maven.exasol.com` references
Summary
In this release, we removed references to the discontinued Exasol maven.exasol.com artifactory.
Refactoring
- #165: Removed references to outdated
maven.exasol.comartifactory repository
Dependency Updates
Test Dependency Updates
- Updated
nl.jqno.equalsverifier:equalsverifier:3.10.1to3.14.1 - Updated
org.junit.jupiter:junit-jupiter:5.9.0to5.9.2 - Updated
org.mockito:mockito-core:4.7.0to5.2.0 - Updated
org.mockito:mockito-junit-jupiter:4.7.0to5.2.0
Plugin Dependency Updates
- Updated
com.exasol:error-code-crawler-maven-plugin:1.1.2to1.2.2 - Updated
com.exasol:project-keeper-maven-plugin:2.6.2to2.9.6 - Updated
io.github.zlika:reproducible-build-maven-plugin:0.15to0.16 - Updated
org.apache.maven.plugins:maven-deploy-plugin:3.0.0-M1to3.1.0 - Updated
org.apache.maven.plugins:maven-enforcer-plugin:3.1.0to3.2.1 - Updated
org.apache.maven.plugins:maven-javadoc-plugin:3.4.0to3.4.1 - Updated
org.apache.maven.plugins:maven-surefire-plugin:3.0.0-M5to3.0.0-M8 - Updated
org.codehaus.mojo:flatten-maven-plugin:1.2.7to1.3.0 - Updated
org.codehaus.mojo:versions-maven-plugin:2.10.0to2.14.2 - Updated
org.itsallcode:openfasttrace-maven-plugin:1.6.0to1.6.1
4.5.2: Fix broken links check
Summary
This release fixes the broken links checker and updates dependencies.
Bugfixes
- #158: Fixed broken links checker
Dependency Updates
Test Dependency Updates
- Updated
nl.jqno.equalsverifier:equalsverifier:3.10to3.10.1 - Updated
org.junit.jupiter:junit-jupiter:5.8.2to5.9.0 - Updated
org.mockito:mockito-core:4.4.0to4.7.0 - Updated
org.mockito:mockito-junit-jupiter:4.4.0to4.7.0
Plugin Dependency Updates
- Updated
com.exasol:error-code-crawler-maven-plugin:0.7.1to1.1.2 - Updated
com.exasol:project-keeper-maven-plugin:2.2.0to2.6.2 - Updated
org.apache.maven.plugins:maven-clean-plugin:3.1.0to2.5 - Updated
org.apache.maven.plugins:maven-compiler-plugin:3.9.0to3.10.1 - Updated
org.apache.maven.plugins:maven-enforcer-plugin:3.0.0to3.1.0 - Updated
org.apache.maven.plugins:maven-install-plugin:2.5.2to2.4 - Updated
org.apache.maven.plugins:maven-jar-plugin:3.2.2to2.4 - Updated
org.apache.maven.plugins:maven-javadoc-plugin:3.3.1to3.4.0 - Updated
org.apache.maven.plugins:maven-resources-plugin:3.2.0to2.6 - Updated
org.apache.maven.plugins:maven-site-plugin:3.11.0to3.3 - Updated
org.codehaus.mojo:versions-maven-plugin:2.8.1to2.10.0 - Updated
org.itsallcode:openfasttrace-maven-plugin:1.5.0to1.6.0 - Updated
org.jacoco:jacoco-maven-plugin:0.8.7to0.8.8 - Added
org.sonarsource.scanner.maven:sonar-maven-plugin:3.9.1.2184 - Updated
org.sonatype.ossindex.maven:ossindex-maven-plugin:3.1.0to3.2.0 - Updated
org.sonatype.plugins:nexus-staging-maven-plugin:1.6.8to1.6.13
4.5.1: Java 17 compatibility
Summary
In this release we added compatibility for Java 17 and updated dependencies.
We also fixed typos in window frame clauses ("Preceding" instead of "Preceeding").
Refactoring
Dependency Updates
Compile Dependency Updates
- Removed
com.exasol:error-reporting-java:0.4.0
Test Dependency Updates
- Updated
nl.jqno.equalsverifier:equalsverifier:3.7.1to3.10 - Updated
org.junit.jupiter:junit-jupiter:5.8.1to5.8.2 - Updated
org.mockito:mockito-core:3.12.4to4.4.0 - Updated
org.mockito:mockito-junit-jupiter:3.12.4to4.4.0
Plugin Dependency Updates
- Updated
com.exasol:error-code-crawler-maven-plugin:0.6.0to0.7.1 - Updated
com.exasol:project-keeper-maven-plugin:1.2.0to2.2.0 - Updated
io.github.zlika:reproducible-build-maven-plugin:0.13to0.15 - Updated
org.apache.maven.plugins:maven-compiler-plugin:3.8.1to3.9.0 - Updated
org.apache.maven.plugins:maven-deploy-plugin:2.8.2to3.0.0-M1 - Removed
org.apache.maven.plugins:maven-failsafe-plugin:3.0.0-M3 - Updated
org.apache.maven.plugins:maven-jar-plugin:3.2.0to3.2.2 - Updated
org.apache.maven.plugins:maven-site-plugin:3.9.1to3.11.0 - Updated
org.apache.maven.plugins:maven-surefire-plugin:3.0.0-M4to3.0.0-M5 - Added
org.codehaus.mojo:flatten-maven-plugin:1.2.7 - Updated
org.itsallcode:openfasttrace-maven-plugin:1.0.0to1.5.0
4.5.0: Support more Aggregate and Analytic functions
Summary
This release supports all aggregate and analytic functions provided by Exasol, e.g. GROUPING[_ID], PERCENTILE_CONT, NTH_VALUE and many more. See the ticket for a complete list.
We also added support for the keywords DISTINCT and ANY as well as the over_clause for analytic functions. See the user guide for how to use the name API.
Features
- #72: Added support for more Aggregate and Analytic functions
Refactoring
Documentation
- #123: Improved documentation
Dependency Updates
Compile Dependency Updates
- Added
com.exasol:error-reporting-java:0.4.0
Test Dependency Updates
- Updated
nl.jqno.equalsverifier:equalsverifier:3.6.1to3.7.1 - Updated
org.junit.jupiter:junit-jupiter:5.7.2to5.8.1 - Updated
org.mockito:mockito-core:3.10.0to3.12.4 - Updated
org.mockito:mockito-junit-jupiter:3.10.0to3.12.4
Plugin Dependency Updates
- Updated
com.exasol:error-code-crawler-maven-plugin:0.4.0to0.6.0 - Updated
com.exasol:project-keeper-maven-plugin:0.7.1to1.2.0 - Updated
org.apache.maven.plugins:maven-enforcer-plugin:3.0.0-M3to3.0.0 - Updated
org.apache.maven.plugins:maven-gpg-plugin:1.6to3.0.1 - Updated
org.apache.maven.plugins:maven-javadoc-plugin:3.2.0to3.3.1 - Updated
org.jacoco:jacoco-maven-plugin:0.8.6to0.8.7
Documentation Improvements and Refactorings
Summary
Improved documentation, added links to API documentation and refactored tests.
Refactoring
Documentation
Dependency Updates
Test Dependency Updates
- Updated
nl.jqno.equalsverifier:equalsverifier:3.5.5to3.6.1 - Updated
org.junit.jupiter:junit-jupiter:5.7.1to5.7.2 - Updated
org.mockito:mockito-core:3.8.0to3.10.0 - Updated
org.mockito:mockito-junit-jupiter:3.8.0to3.10.0
Plugin Dependency Updates
- Updated
com.exasol:error-code-crawler-maven-plugin:0.1.1to0.4.0 - Updated
com.exasol:project-keeper-maven-plugin:0.5.0to0.7.1 - Added
io.github.zlika:reproducible-build-maven-plugin:0.13 - Updated
org.apache.maven.plugins:maven-clean-plugin:2.5to3.1.0 - Updated
org.apache.maven.plugins:maven-deploy-plugin:2.7to2.8.2 - Updated
org.apache.maven.plugins:maven-install-plugin:2.4to2.5.2 - Updated
org.apache.maven.plugins:maven-jar-plugin:2.4to3.2.0 - Updated
org.apache.maven.plugins:maven-resources-plugin:2.6to3.2.0 - Updated
org.apache.maven.plugins:maven-site-plugin:3.3to3.9.1
4.4.0 - More Predicates
Summary
In this release, we have added additional Exasol predicates such as IS [NOT] NULL or [NOT] BETWEEN. We also refactored the comparison and LIKE operators.
Features / Improvements
- #104: Added additional predicates
Refactoring
- #98: Refactored comparison and like class structure
We refactored the internal representation of theComparison, the public API fromBooleanTermdid however not change. - #95: Refactored
ValueExpressionVisitor
Dependency Updates
- Updated
org.mockito:mockito-core:3.5.13to3.8.0 - Updated
org.mockito:mockito-junit-jupiter:3.5.13to3.8.0 - Updated
org.junit.jupiter:junit-jupiter:5.7.0to5.7.1 - Updated
nl.jqno.equalsverifier:equalsverifier:3.4.3to3.5.5
Plugin Updates
- Updated
org.codehaus.mojo:versions-maven-plugin:2.7to2.8.1 - Updated
org.itsallcode:openfasttrace-maven-plugin:0.1.0to1.0.0 - Updated
org.jacoco:jacoco-maven-plugin:0.8.5to0.8.6
CAST function support
Features / Enhancements
- #94: Added CAST function support
LIKE predicate support
Summary
In this release we have deprecated arithmeticExpression(...) methods of Select class.
Please, use valueExpression(...) methods instead.
Features / Enhancements
- #91: Added support for LIKE predicate.
Dependency updates
- Added org.junit.jupiter:junit-jupiter:5.7.0
- Updated org.mockito:mockito-core:3.3.3 to version 3.5.13
- Updated org.mockito:mockito-junit-jupiter:3.3.3 to version 3.5.13
- Updated nl.jqno.equalsverifier:equalsverifier:3.4.1 to version 3.4.3
- Removed org.junit.jupiter:junit-jupiter-engine
- Removed org.junit.jupiter:junit-jupiter-params
- Removed org.junit.platform:junit-platform-runner