Thursday, August 25, 2016

Teiid 9.1 Beta1 Released

After a small delay Teiid 9.1 Beta2 has been posted.  Notable features since Alpha2:
  • TEIID-4332 Improved NDV calculations for costing.
  • TEIID-4284 Salesforce Bulk API for SELECT queries.
  • TEIID-4378 TEIID-4376 Clob enhancements to support concat and use in EXECUTE IMMEDIATE.
  • TEIID-4100 OData expand support for siblings and nested expands.
  • TEIID-4393 Additional Geospatial Functions to more fully support the SQL-MM specification.
As always thanks for all the community support including the Impala analytical function support contributed by Don Krapohl.

Steve

Friday, August 19, 2016

Teiid 9.0.3 Released

The 9.0.3 fix release is now available.  It addresses 9 issues since 9.0.2:
  • [TEIID-4343] - Impala Translator - With Clause Support
  • [TEIID-4354] - patch to CXF no longer needed with new version of the CXF in 9.0 series.
  • [TEIID-4360] - default token type needs to be "bearer" for OAuth2 access code negotiation
  • [TEIID-4372] - Impala AVG returns double when bigdecimal is expected
  • [TEIID-4384] - Issue with ordered offset
  • [TEIID-4385] - Nested subquery in an aggregate fails to evaluate
  • [TEIID-4389] - Local connection waits for active VDB 1,000,000 times longer than specified in waitForLoad property
  • [TEIID-4391] - NONDETERMINISTIC functions incorrectly optimized out of ORDER BY
  • [TEIID-4395] - Oracle translator should pushdown clob conversion
A special thanks to Marco Adrito for discovering and working through TEIID-4354 and TEIID-4360.

Looking forward 9.1 Beta1 should be available by the end of next week.

Steve

Tuesday, August 16, 2016

Teiid Designer 10.1 released to support Teiid 9.0 and Wildfly

Teiid Designer 10.1 is our first release that supports Teiid 9.0 and the Wildfly runtime environments.

This release also includes a couple dozen bug fixes (see Release Notes) and enhancements.  Of note are:
  • support for Teiid 9.0 VDB versioning (i.e. major.minor.patch values)
  • multi-character delimiter option in flat file importer
 Try it out!  Download and install....

Teiid Tooling Project Team

Friday, July 29, 2016

Teiid 9.1 Alpha2 Available

After a small delay Teiid 9.1 Alpha2 has been posted.  Notable features since Alpha1:
  • TEIID-4332 Improved NDV calculations for costing.
  • TEIID-2715 OData Metadata support for providing the metadata extension properties for OData.
Also the OData 2 service layer has been removed.  Please contact the community if you still need that functionality and want to maintain it as an independent project.

WildFly Upgrade

While most of the issues with the WildFly upgrade should be resolved.  It is unclear when progress will be made on TEIID-3834: start/stop of a data source or resource adapter requires a restart (somewhat worse behavior than WildFly 9 from our perspective)

Teiid Whipper

Whipper is a new project that will incorporate the changes made to our BQT testing framework by our Red Hat QE team and will aim to provide new features / ease of use for validation testing of all things Teiid.

Teiid Designer

Teiid Designer should have a release compatible with WildFly 9 / Teiid 8.13.x and Teiid 9.0.x in the next two weeks.  There is still no timeline yet for a Teiid Designer release compatible with WildFly 10.

The OpenShift web UI continues to progress, please contact their community is you have any interest in following or contributing to the work.

9.0.x

9.0.3 is due out in approximately 2-3 weeks.

8.13.x

If needed 8.13.7, the last fix release on 8.13, will be available by the general release of 9.1.

As always thanks for all the community support,
Steve

Sunday, July 17, 2016

Teiid 9.0.2 Released

The 9.0.2 fix release is now available.  This addresses 10 issues since 9.0.1:
  • [TEIID-4304] - Correct handling with subquery in on clause
  • [TEIID-4311] - Teiid Admin Api not support to create XA datasource on Jboss server.
  • [TEIID-4321] - VDB Validation is showing warnings, but failing deployment
  • [TEIID-4324] - TEIID30019 Unexpected exception for request ... java.lang.AssertionError: Batch not found in storage
  • [TEIID-4325] - ASSERTION FAILED: expected reference to be not null
  • [TEIID-4335] - No buffer when close is called
  • [TEIID-4338] - Hana and Vertica should be marked as requiring a source
  • [TEIID-4339] - Hot Rod ExecutionFactory name misspelled
  • [TEIID-4342] - loadMatView afterLoadScript error when calling a function
  • [TEIID-4336] - Errors in logs during server shutdown
A special thanks to Bram Gadeyne for identifying TEIID-4324 and to Mark Tawk for highlighting TEIID-4325 and TEIID-4342.

 Next up will be the 9.1 Alpha2 release by the end of the week.

Friday, July 15, 2016

Teiid 8.13.6 Released

The 8.13.6 fix release is now available.  This addresses 11 important issues:
  • [TEIID-3685] - org.teiid.padSpace does not affect to the "IN" operator
  • [TEIID-3815] - Oracle translator - OFFSET function does not work
  • [TEIID-4244] - Assertion failed error when joining duplicate rows to a table from other source
  • [TEIID-4248] - Build change for 8.13 caused the release notes to miss the version replacement
  • [TEIID-4260] - Accumulo: Resource adapter fails to load
  • [TEIID-4262] - Wrong result (empty or NULL) with an view and a single disjunction for join criteria
  • [TEIID-4280] - NPE in RuleMergeVirtual when running a query with nested CTEs
  • [TEIID-4287] - An exception is thrown by PostgreSQL when nested CTEs are pushed down
  • [TEIID-4290] - Rollback to savepoint should be a no op
  • [TEIID-4320] - Costing calculation issues
  • [TEIID-4324] - TEIID30019 Unexpected exception for request ... java.lang.AssertionError: Batch not found in storage
This is likely the second to last fix release for 8.13.  Expect an 8.13.7 in about a month and for fix releases to continue on 9.0.x after that.

Steve

Sunday, July 3, 2016

Teiid 9.0.1 Released

The 9.0.1 fix release is now available.  This release addresses 13 issues including several issues related to WITH clause processing that were found by Salvatore R.:
  • [TEIID-3685] - org.teiid.padSpace does not affect to the "IN" operator
  • [TEIID-3771] - Teiid throws an NPE while executing query with nested subquery IN predicate
  • [TEIID-4272] - NPE when CTE and subuquery without a WITH clause are pushed together
  • [TEIID-4273] - With clause used in evaluatable subquery in a fully pushed user query is seen as missing temp table
  • [TEIID-4276] - Default for max sessions not consistently updated
  • [TEIID-4280] - NPE in RuleMergeVirtual when running a query with nested CTEs
  • [TEIID-4283] - External Materialization interleaving loads SYSADMIN.loadMatView
  • [TEIID-4287] - An exception is thrown by PostgreSQL when nested CTEs are pushed down
  • [TEIID-4288] - Cancel method against a socket based jdbc query can wait for synch timeout
  • [TEIID-4290] - Rollback to savepoint should be a no op
  • [TEIID-4304] - Correct handling with subquery in on clause
  • [TEIID-4310] - Sessions can not be shown in web-console runtime sub-panel
  • [TEIID-4312] - INNER and LEFT joins of CTEs fail or return incorrect results
Expect an 8.13.6 release to follow in a couple of days.

Thanks,
Steve Hawkins