Friday, April 21, 2017

Teiid 9.3 Beta1 Released

Teiid 9.3 Beta1 has been released.  Feature highlights since Alpha2 include:
  • TEIID-4646 LEAD/LAG/FIRST_VALUE/LAST_VALUE analytic/value function support.
Feature Progress:
  • Couchbase connectivity TEIID-2820 has been committed and will evolve from here. Thanks Kylin great work.
  • SQLAlchemy/Superset access TEIID-4578 has been committed but will still undergo additional changes with more testing.
If you have any interest please evaluate these in progress features as they mature.
Beyond the feature work, there were a lot general issues addressed - nearly 90 issues have been resolved so far.

Other news:
  • A Teiid 9.2.3 will be available in about 2 weeks.
  • Teiid 10.0 work will begin in about 3 weeks.  It is anticipated there will be major changes and cleanups for that release.
Thanks,
Steve

Saturday, April 15, 2017

Teiid 9.2.2 Released

Teiid 9.2.2 is now available.  This fix release covers 13 issues:
  • [TEIID-4501] - Salesforce 34 resource adapter should default to the 34 api
  • [TEIID-4812] - Processor is not exiting the join as soon as it's determined one side contains 0 rows
  • [TEIID-4814] - BatchedUpdateException should be provided for JDBC prepared statement batches
  • [TEIID-4816] - SQL Server 2012+ offset order by issue
  • [TEIID-4819] - Tree page modifications removing the previous page, don't remove immediately
  • [TEIID-4823] - joining 2 procedures results in QueryPlannerException: TEIID30275 Join region with unsatisfied access patterns cannot be satisfied by the join criteria
  • [TEIID-4828] - ST_GeomFromGeoJson fails for certain geometry types
  • [TEIID-4830] - Parsing Error when deploying VDB with "geometry" as column name
  • [TEIID-4832] - NullPointException in GroupingNode.initialize
  • [TEIID-4844] - Google translator unexpected behavior for comparison with time
  • [TEIID-4845] - Google translator comparison with boolean value matches all rows
  • [TEIID-4852] - Wrong OData results with multiple self relationships
Teiid 9.3 Beta1 is expected this coming week.  Also if there is a need for a 9.1.5, please let us know - only 3 issues have been addressed there so far.

Thanks,
Steve

Wednesday, March 29, 2017

Teiid 9.3 Alpha2 Released

Teiid 9.3 Alpha2 has been released.  Feature highlights since Alpha1 include:
Feature Progress:
  • Couchbase connectivity is still progressing under TEIID-2820
  • JDG integration continues to get easier - but some major changes are coming, including move the JDG connectivity to its own repository TEIID-4820
Beyond the feature work, there were a lot general issues addressed - nearly 70 issues have been resolved so far.

Other news:

  • A Teiid 9.2.2 will be available in the next 1-2 weeks.
  • JIRA issue cleanup has been ongoing.  There's quite a few backlog issues that should still be dealt with.
  • Teiid 10.0 work will begin by the end of April.  It is anticipated there will be major changes and cleanups for that release.
Thanks,
Steve

Tuesday, March 14, 2017

Teiid 9.2.1 Released

Teiid 9.2.1 is now available.  This fix release covers 18 issues:
  • [TEIID-4765] - The notion of resolving order may need to be extended beyond a schema
  • [TEIID-4788] - DDL vdb is expensive to process
  • [TEIID-4809] - lob performance issues
  • [TEIID-4770] - The convert script generates empty GRANT statements for roles that don't have permission to access a certain schema.
  • [TEIID-4771] - The convert script generates GRANT TEMPORARY_TABLE ON DATABASE statements but these fail.
  • [TEIID-4774] - Convert VDB utility does not work when translator overrides are present
  • [TEIID-4776] - Issues with array type metadata
  • [TEIID-4783] - missing message keys for functions
  • [TEIID-4785] - Add options through alter table in DDL does not work.
  • [TEIID-4791] - Bypass lookup function's keycolumn reserved word
  • [TEIID-4797] - Oracle: empty catalog messed up VDB schemas name
  • [TEIID-4807] - DDL format of a vdb lacks import information
  • [TEIID-4652] - SybaseIQ translator: DAYOFYEAR function not pushed correctly
  • [TEIID-4653] - SybaseIQ translator: Input parameter not set in prepared statement in source command
  • [TEIID-4775] - External materialization, after transaction timeout, LoadState continues to be LOADING
  • [TEIID-4778] - External Materialization, When TTL is less than loading time, the scheduling is off
  • [TEIID-4780] - Clone TEIID-4734 (Backwards compatible solution)
  • [TEIID-4782] - Change framework to catch RutineException from translator/connector
Note that several of these are related to the new DDL vdb feature - thanks Bram Gadeyne for the initial feedback.  This feature will continue to evolve even in 9.2.x to maintain forward compatibility with 9.3.x.

Looking forward, Teiid 9.2.2 should be available in 3-4 weeks.

Thanks,
Steve


Saturday, March 11, 2017

Teiid 9.3 Alpha1 Released

Teiid 9.3 Alpha1 has been released.  Feature highlights include:
Feature Progress:
  • Couchbase connectivity is progressing under TEIID-2820
  • The full DDL metadata system feature continues to evolve.  Several early issues have been addressed that slightly change the syntax and order or statements that supported.  This will all be reflected in the docs.  The hope is that the feature will be fully realized by the end of the 9.3 release.
  • The Debezium integration work continues as Ramesh has contributed changes to their community.
  • JDG integration continues to get easier and support for JDG 7.1 will be added.
We will try to stay to a two week pre-release cycle from this point.  Also expect a 9.2.1 early next week.

Thanks,
Steve

Tuesday, February 28, 2017

Teiid 9.1.4 Released

9.1.4 is available for download or from the Maven repository.  It addresses 8 important issues:
  • [TEIID-4737] - Incorrect work of left join statement
  • [TEIID-4754] - Wrong result with bidirectional relationship
  • [TEIID-4776] - Issues with array type metadata
  • [TEIID-4791] - Bypass lookup function's keycolumn reserved word
  • [TEIID-4775] - External materialization, after transaction timeout, LoadState continues to be LOADING
  • [TEIID-4778] - External Materialization, When TTL is less than loading time, the scheduling is off
  • [TEIID-4780] - Clone TEIID-4734 (Backwards compatible solution)
  • [TEIID-4782] - Change framework to catch RutineException from translator/connector
From here the release pace on 9.1.x will slow as primary support will be on the 9.2.x branch. There will also be a 9.3 Alpha1 release next week with significant work toward JDG, materialization, and allowing domain types.

Thanks,
Steve

Thursday, February 23, 2017

Teiid 9.0.6 Released

Teiid 9.0.6 is now available.  This release contains 12 important fixes:
  • [TEIID-4663] - Support a more secure block mode for client/server encryption
  • [TEIID-4546] - On setting jboss-teiid cluster : throwing java.lang.IllegalArgumentException.
  • [TEIID-4547] - getQueryPlan fails in adminapi
  • [TEIID-4553] - COUNT returns inconsistent results when column statistics are not gathered
  • [TEIID-4608] - Insert statement - multi-value insert into view - incorrect type resolution if first tuple contains NULL
  • [TEIID-4661] - Subsequent queries hang after materialized view TTL expires.
  • [TEIID-4668] - Google translator skips NULL value in INSERT
  • [TEIID-4710] - Request id conflict with CommandContext connection
  • [TEIID-4727] - Aggregation is performed incorrectly for JOIN queries
  • [TEIID-4732] - Teiid Server does not honor columns name in external materialization
  • [TEIID-4737] - Incorrect work of left join statement
  • [TEIID-4776] - Issues with array type metadata
It is the final release of the 9.0.x line.  You should upgrade to 9.1 or later when feasible.  Note there will be a 9.1.4 release early next week.

Thanks,
Steve