Sub-task

• [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
• [TEIID-4906] - Clean up licensing and copyright information

Feature Request

• [TEIID-2820] - Support Couchbase as a resource
• [TEIID-3825] - Add a wildfly-swarm-teiid Fraction for running teiid as an uberjar
• [TEIID-4091] - Allow a PreParser instance per vdb
• [TEIID-4552] - Missing support for connection to Facebook via OAuth 2
• [TEIID-4557] - Enable memory management at the query level
• [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-4795] - Add support for Oracle TRUNC function
• [TEIID-4833] - Oracle JDBC Connector: Support for LISTAGG
• [TEIID-4880] - Join Elimination in Star Schema
• [TEIID-4901] - Add parallel source query handling for when IN criteria values exceed MaxInCriteriaSize for translator

Bug

• [TEIID-4501] - Salesforce 34 resource adapter should default to the 34 api
• [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-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-4856] - OData - Teiid throws IndexOutOfBoundsException if user requests value of nonexistent propery
• [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
• [TEIID-4882] - Nested dependent join planning issue
• [TEIID-4887] - Domain mode configuration fails with CNF
• [TEIID-4890] - DatabaseMetadata Procedure Columns order is incorrect
• [TEIID-4892] - oData v4 error using $expand
• [TEIID-4893] - Inconsistent behavior of SUBSTRING function
• [TEIID-4899] - import foreign schema "import qualifiers" problem
• [TEIID-4913] - MetadataFactory is not replacing . in column names
• [TEIID-4926] - Couchbase - unable to retrieve data if using 'convert' in view definition
• [TEIID-4927] - Update dockerfile
• [TEIID-4928] - Couchbase - NAMEINSOURCE required for all the columns and tables
• [TEIID-4930] - Scale of 0 always reported for 0 precision
• [TEIID-4937] - OAuth2 security with OData seems to outdated with current Keycloak 3.1.0

Task

• [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-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
• [TEIID-4881] - Better account for differences between ddl and vdb.xml vdbs
• [TEIID-4923] - Support getDataSourceNames() of Embedded Admin Implemnetation

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-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
• [TEIID-4858] - hive translator is extremely slow
• [TEIID-4885] - Costing issues
• [TEIID-4889] - Separate commons-net and mongo-java-driver from api module
• [TEIID-4907] - Sybase and other import should tolerate exception retrieving foreign keys

Enhancement

• [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-4518] - Add support for JDG 7.1
• [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-4831] - Allow buffer cleaner to evict more
• [TEIID-4835] - Implement column level incoming dependencies
• [TEIID-4857] - Add file metadata such as creation and last modified date to file translator functions
• [TEIID-4865] - DISTINCT not pushed down to multisource sources
• [TEIID-4872] - JSON Functions need more examples
• [TEIID-4883] - Teiid Excel Translator should filter blank cells from header row
• [TEIID-4886] - Allow join grouping to optimize across left outer joins
• [TEIID-4925] - Importing a non-existing VDB gives no warning
• [TEIID-4933] - Enhance CouchbaseMetadataProcessor to add sampleKeyspaces property and support more typed table name
• [TEIID-4935] - Change couchbase ISARRAYTABLE OPTION optional

Edit/Copy Release Notes

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