Release Notes - Teiid - Version 9.3 - HTML format

Quality Risk

  • [TEIID-2167] - Permissions should also specify object type
  • [TEIID-2465] - Add additional size limitations
  • [TEIID-2711] - Better support for Oracle SQLXML values
  • [TEIID-3862] - Documentation in kit for certain datasources missing
  • [TEIID-4051] - Swagger metadata includes internal java constructs
  • [TEIID-4065] - Accumulo encoding property is effectively unused
  • [TEIID-4308] - runtime build unit test dump lots of log and error trace
  • [TEIID-4561] - Deprecate the PassthroughIdentityLoginModule
  • [TEIID-4669] - Issues with jConnect and Sybase IQ
  • [TEIID-4672] - Sheet with header becomes invalid
  • [TEIID-4765] - The notion of resolving order may need to be extended beyond a schema
  • [TEIID-4773] - Provide property example with file translator
  • [TEIID-4777] - google package name misspelled
  • [TEIID-4786] - Report more information with max block exception
  • [TEIID-4788] - DDL vdb is expensive to process
  • [TEIID-4809] - lob performance issues
  • [TEIID-4815] - How could I debug JDV memory allocation properly
  • [TEIID-4818] - Report a more informational message than TooLongFrameException
  • [TEIID-4821] - Debug Plan is missing Annotation about JOIN Pushdown

Enhancement

  • [TEIID-3360] - Provide an option to virtualize source exceptions
  • [TEIID-3624] - No way to associate enterprise data types in dynamic vdb constructs
  • [TEIID-4218] - MongoDB metadata import fails when user has insufficient permissions
  • [TEIID-4489] - Adjust defaults and use of 1 to 10 data sources to recommend the SMALL size
  • [TEIID-4518] - Add support for JDG 7.1
  • [TEIID-4572] - Grouping by and faceted search for Solr tranlator
  • [TEIID-4624] - Integrate with Debezium for Result set cache invalidation
  • [TEIID-4625] - Consider consolidating/managing materialization status tables
  • [TEIID-4626] - Add a full snapshot refresh strategy based upon table modifications
  • [TEIID-4646] - Add engine support for lead/lag aggregate functions
  • [TEIID-4717] - Add Support for 'ALLOW FILTERING' in Teiid Cassandra Translator
  • [TEIID-4718] - Enable JDG resource adapter to support HotRod SSL
  • [TEIID-4724] - Allow support for vdb.ddl in the .vdb files
  • [TEIID-4738] - Change JDG Materialization to use Upsert
  • [TEIID-4749] - Cassandra type mapping
  • [TEIID-4761] - Support lpad/rpad pushdown to sql server
  • [TEIID-4766] - MySQL LEFT JOIN performance issue with external materialization management
  • [TEIID-4770] - The convert script generates empty GRANT statements for roles that don't have permission to access a certain schema.
  • [TEIID-4787] - Add Netzza datasource configuration example
  • [TEIID-4789] - OData - Allow reading/writing messages in GZIP format
  • [TEIID-4824] - Add unique id as a configuration property in the Google Resource adapter
  • [TEIID-4826] - OAuth2 add option to set access_token directly in login module
  • [TEIID-4831] - Allow buffer cleaner to evict more
  • [TEIID-4835] - Implement column level incoming dependencies
  • [TEIID-4865] - DISTINCT not pushed down to multisource sources
  • [TEIID-4872] - JSON Functions need more examples

Feature Request

  • [TEIID-2820] - Support Couchbase as a resource
  • [TEIID-3522] - Provide Data Aggregation Extension to OData V4
  • [TEIID-3647] - Create native connector to interact with HDFS as a datasource
  • [TEIID-3733] - Add support for web scraping
  • [TEIID-3825] - Add a wildfly-swarm-teiid Fraction for running teiid as an uberjar
  • [TEIID-4030] - Improve Geometry Type Handling in HANA Translator
  • [TEIID-4091] - Allow a PreParser instance per vdb
  • [TEIID-4253] - Add support for Google Cloud SQL
  • [TEIID-4516] - Add support for updating child objects
  • [TEIID-4517] - Add support for deleting child objects
  • [TEIID-4526] - Integrate with Debezium for CDC for maintaining materialized views
  • [TEIID-4552] - Missing support for connection to Facebook via OAuth 2
  • [TEIID-4557] - Enable memory management at the query level
  • [TEIID-4558] - Query Plan Analyzer
  • [TEIID-4578] - Create SqlAlchemy Dialect for Teiid
  • [TEIID-4709] - Enable JDG resource adapter to pass the username/password to HotRod Client
  • [TEIID-4733] - Streamline JDG integration
  • [TEIID-4742] - Provide query prioritization feature
  • [TEIID-4795] - Add support for Oracle TRUNC function
  • [TEIID-4833] - Oracle JDBC Connector: Support for LISTAGG

Bug

  • [TEIID-4501] - Salesforce 34 resource adapter should default to the 34 api
  • [TEIID-4575] - No such accessible property/method in the class after deploy vdb
  • [TEIID-4755] - WS SOAP Response with WS-A Headers results in ClassCastException
  • [TEIID-4763] - Max open statements property limits statements count to n+1
  • [TEIID-4767] - Driver is reporting driver version for database version
  • [TEIID-4771] - The convert script generates GRANT TEMPORARY_TABLE ON DATABASE statements but these fail.
  • [TEIID-4772] - incorrect metadata for array columns in pg metadata
  • [TEIID-4774] - Convert VDB utility does not work when translator overrides are present
  • [TEIID-4776] - Issues with array type metadata
  • [TEIID-4779] - External materialization Issues
  • [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-4792] - Unable to use WHERE clause against a JDG data source - ISPN000402: The type com.redhat.demo.sko.pojo.Call has no property named .....
  • [TEIID-4794] - Unable to use JDG as data source after restarting JDG i.e. JDG crash
  • [TEIID-4797] - Oracle: empty catalog messed up VDB schemas name
  • [TEIID-4803] - Mandatory property for external materialization is not listed properly
  • [TEIID-4804] - External materialization documentation - Maria DB example DDL contains OPTIONS
  • [TEIID-4805] - External materialization documentation - status table needs to be UPDATABLE
  • [TEIID-4806] - Infinispan DSL Resource Adapter: NullPointerException when Admin user/password not provided
  • [TEIID-4807] - DDL format of a vdb lacks import information
  • [TEIID-4808] - Infinispan Cache Resource Adapter: NullPointerException
  • [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-4817] - Infinispan DSL Resource Adapter: can't query after JDG restart
  • [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-4825] - Google translator throws Column doesn't exist in the worksheet
  • [TEIID-4827] - Require Java 1.8 for building/runtime
  • [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-4834] - Wrong pushdown of ST_Touches to Oracle
  • [TEIID-4838] - View with a union that projects nulls fails to resolve properly
  • [TEIID-4841] - Remove jboss-logging-generator dependency
  • [TEIID-4844] - Google translator unexpected behavior for comparison with time
  • [TEIID-4845] - Google translator comparison with boolean value matches all rows
  • [TEIID-4847] - Google translator ClientLogin not supported
  • [TEIID-4850] - translator map-cache install failed
  • [TEIID-4852] - Wrong OData results with multiple self relationships
  • [TEIID-4854] - Google translator fails to update timestamp value reformatted after update
  • [TEIID-4856] - OData - Teiid throws IndexOutOfBoundsException if user requests value of nonexistent propery
  • [TEIID-4860] - OData4 swallowing exception message
  • [TEIID-4861] - ASSERTION FAILED: expected reference to be not null
  • [TEIID-4868] - formats in timestampformat functions on sybase are ignored.
  • [TEIID-4869] - Fix endpoint url for the "odata4service-as-a-datasource" in the embedded quickstart
  • [TEIID-4874] - SQL Server translator should support full outer join by default
  • [TEIID-4875] - Planning issue with multiple aggregate decompositions through a join tree
  • [TEIID-4876] - Salesforce connector not working properly in 9.2.2 release
  • [TEIID-4877] - Boolean syntax is broken on pg 9.5 data sources

Task

  • [TEIID-4185] - Add more documentation about Embedded
  • [TEIID-4642] - Investigate class loading when using pojo with annotations so the resource-adapter module doesn't need updating
  • [TEIID-4657] - Explain how the pojo module.xml should be configured
  • [TEIID-4762] - Split the configure api separately
  • [TEIID-4781] - upgrade MongoDB Java Driver
  • [TEIID-4820] - Move the infinispan connector project to the JDG repo
  • [TEIID-4873] - couchbase translator should support upsert and batch insert
  • [TEIID-4878] - Upgrade accumulo and solr libraries

Sub-task

  • [TEIID-4536] - Support create schema with multiple statements
  • [TEIID-4652] - SybaseIQ translator: DAYOFYEAR function not pushed correctly
  • [TEIID-4653] - SybaseIQ translator: Input parameter not set in prepared statement in source command
  • [TEIID-4734] - Restart during materialization load, does not update Materialized views anymore
  • [TEIID-4736] - JDG resource adapter does not reconnect properly when JDG as mat cache is restarted
  • [TEIID-4758] - Permanent materialization load failure is when JDG source goes down
  • [TEIID-4768] - Clarify Caching guide using external materializaion
  • [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-4782] - Change framework to catch RutineException from translator/connector
  • [TEIID-4862] - Create documents/examples for couchbase connector
  • [TEIID-4866] - Enhance SQL Alchemy integration to work with Superset

Edit/Copy Release Notes

The text area below allows the project release notes to be edited and copied to another document.