Feature Request

• [TEIID-2813] - Report translator CPU time
• [TEIID-2883] - Support Actian Analytics as a data source
• [TEIID-2884] - Support for Amazon Elastic MapReduce
• [TEIID-3323] - Add support for Vertica as as data source
• [TEIID-3327] - Translator for OSIsoft PI
• [TEIID-3370] - Add translator for OData V4 based service
• [TEIID-3411] - LDAP translator and multi-valued arrays
• [TEIID-3442] - Apache Spark support via SparkSQL and DataFrames
• [TEIID-3492] - Provide a mechanism for users to modify the salesforce api version
• [TEIID-3493] - Use certificates in Salesforce SOAP API calls
• [TEIID-3521] - Provide Swagger support on auto-generated REST web services
• [TEIID-3530] - dependent join enhancements
• [TEIID-3545] - Improvements in default handling
• [TEIID-3611] - Create a quickstart to demonstrate REST Service Through VDB
• [TEIID-3618] - Salesforce SSO using OAuth2 (RefreshToken, JWT)
• [TEIID-3668] - Support OAuth with JWT Bearer Access Token
• [TEIID-3714] - update webservice example to show how to invoke wsdl base procedures and swagger json based procedures
• [TEIID-3719] - Add Log4j 1 Logger Adapter
• [TEIID-3727] - Add a latest version of the salesforce connectivity to the server kit

Bug

• [TEIID-3501] - IN clause - teradata does not support "CAST( ... AS ...)" statement in "IN(...)"
• [TEIID-3502] - Teiid returns integer/long overflow values
• [TEIID-3515] - make makedep and related hints consistent
• [TEIID-3526] - Issues with insert and query expression with a common table expression
• [TEIID-3533] - Infinispan-dsl-cache translator: can't insert value into BYTE and BIGINTEGER columns
• [TEIID-3535] - Infinispan-dsl-cache translator: NPE when inserting data if a table doesn't have primary key defined
• [TEIID-3536] - Infinispan-dsl-cache translator: Can't delete or update rows which were previously inserted through hotrod protocol
• [TEIID-3539] - Infinispan-dsl-cache translator: Can't use IS [NOT] NULL operator for non-string columns
• [TEIID-3542] - Logging does not print full queries which contain ESCAPE '\u0000' clause
• [TEIID-3548] - Creation of embedded complex not supported by odata production
• [TEIID-3549] - Join conditions with OR generate a wrong JDBC query
• [TEIID-3550] - Missing status of VDB in jboss-cli console
• [TEIID-3551] - NPE creating trigger on a view that doesn't exist
• [TEIID-3552] - NPE on calling the native query procedure with null variable parameter
• [TEIID-3555] - Like expression in select statement fails against Sybase
• [TEIID-3556] - BufferManager reserve memory variable is decremented twice
• [TEIID-3557] - Can't reload VDB in domain mode
• [TEIID-3558] - Duplicate records being for formed for Internal Materialized View cluster
• [TEIID-3562] - Teradata15 - teiid shifts date/time/timestamp values according to timezone.
• [TEIID-3563] - Problems with capabilities initialization
• [TEIID-3566] - insert value pushed inappropriately
• [TEIID-3573] - Infinispan-dsl-cache translator: Operator <> incorrectly handles NULL values
• [TEIID-3574] - Teiid ODBC driver inconsistent error logs
• [TEIID-3576] - Issues with waitForLoad
• [TEIID-3586] - Literal date comparisons with databasetimezone set are incorrect
• [TEIID-3588] - A procedure without a return/results throws an exception through odata
• [TEIID-3589] - MongoDB metadata import fails with NPE
• [TEIID-3592] - XMLFOREST returns source rather than view column names
• [TEIID-3598] - MongoDB string functions - different handling of NULL values
• [TEIID-3602] - NU.XOM dependency not defined for XOM for EAP Kit
• [TEIID-3603] - missing property key for ERR.015.008.0032
• [TEIID-3604] - jsontoxml produces wrong result with nested multi-dimensional arrays
• [TEIID-3616] - HBase translator - NPE if date value is 'null'
• [TEIID-3619] - HBase translator - INSERT and UPDATE statements have no effect
• [TEIID-3620] - HBase translator - date, time, timestamp values are not translated correctly
• [TEIID-3621] - HBase translator - UPDATE statement requires primary key
• [TEIID-3622] - HBase translator - INSERT could rewrite the data
• [TEIID-3623] - HBase translator - boolean and biginteger values are not translated correctly
• [TEIID-3625] - JDG translator has disabled capabilities for GT and LT
• [TEIID-3627] - Infinispan-dsl-cache translator: comparison operators(GE,LE) problem with string
• [TEIID-3628] - Server socket setting issues
• [TEIID-3629] - Teiid DDL columns options for Salesforce column have wrong name for "Calculated" property
• [TEIID-3632] - Performance issue retrieving data source and translator definitions through the AdminFactory
• [TEIID-3634] - Issues with cloning on several language objects
• [TEIID-3635] - Auto configuration of buffermanager values can be incorrect
• [TEIID-3640] - Improper initialization when memory buffer size is over 2 GB.
• [TEIID-3641] - ANSI 89 joins not translating to 92 syntax correctly
• [TEIID-3643] - VDB based kerberos authentication does not work with ODBC
• [TEIID-3652] - Teiid could push some outer joins to the source database, but does not
• [TEIID-3654] - Exception with system table subquery
• [TEIID-3658] - VDBs may start before transport service
• [TEIID-3661] - Spatial functions broken
• [TEIID-3662] - IN predicate against a materialized/temp table index without an order by returns wrong results
• [TEIID-3663] - ST_Transform only works in tests
• [TEIID-3665] - Undeployable dynamic vdb if its runtime name does not have extension ".xml"
• [TEIID-3666] - VDB can deploy before datasource is bound
• [TEIID-3671] - filter on child table not working
• [TEIID-3672] - Odata - if table does not contain element with required key then teiid trows NPE
• [TEIID-3673] - Subquery field with limit giving a wrong JDBC SQL in Oracle
• [TEIID-3674] - NOT IN construct behaves inconsistently
• [TEIID-3678] - Unable to import native metada from HBase
• [TEIID-3681] - Subquery field added in wrong place in generated JDBC SQL
• [TEIID-3686] - OData DELETE nonexisting row - wrong response code
• [TEIID-3688] - StaxSource XMLEvent error with a comment
• [TEIID-3692] - Impala/Hive string literals
• [TEIID-3696] - Duplicates are not always removed when UNION and GROUP BY clauses are used in a subquery
• [TEIID-3698] - non-selectable columns will cause OData failures
• [TEIID-3699] - execute immediate only checks immediate parent scope
• [TEIID-3702] - dependency and validation logic incorrect
• [TEIID-3703] - Cannot make references to view columns in view update
• [TEIID-3704] - ROUND() function fails when pushed down to PostgreSQL with real/double precision datatypes
• [TEIID-3707] - Wrong Data returned when a procedure is executed in the SELECT clause
• [TEIID-3709] - PreparedStatement parameters should not be cleared after addBatch
• [TEIID-3710] - Model defined without source information causes NoSuchElementException and further IllegalStateException in teiid-async-threads
• [TEIID-3711] - Teiid XML Plan not showing Aggregate function
• [TEIID-3716] - Error joining file data sources
• [TEIID-3720] - DDLString Visitor not writing the OPTIONS value for Procedure parameters
• [TEIID-3726] - CTEs combined with constant values yield an error message
• [TEIID-3728] - WS Translator: The format for multiple header values is incorrect
• [TEIID-3739] - Dynamic VDB that imports another VDB does not get redeployed if the imported VDB is redeployed
• [TEIID-3742] - out of range values not checked in sum aggregate
• [TEIID-3743] - Multiple Count Distinct Columns Fails for Impala
• [TEIID-3747] - Deploying a .vdb where a dynamic vdb has already been deployed, fails due to duplicates
• [TEIID-3751] - NPE in GroupingNode on running a query with CTEs and GROUP BY clause
• [TEIID-3756] - Order By clause specified in STRING_AGG function is skipped when pushed down to PostgreSQL
• [TEIID-4002] - Configuring of JDG DSL resource adapter still requires marshaller and protobuf when using annotations to define schema

Task

• [TEIID-3567] - Create a combined example for use hadoop hdfs as a datasource
• [TEIID-3644] - Create a embedded example to show security authentication with picketlink

Quality Risk

• [TEIID-3503] - Development with Embedded teiid should not require dependency on EAP
• [TEIID-3506] - Move downloads off of sourceforge
• [TEIID-3507] - Matview vdb start/stop scripts are not cluster safe
• [TEIID-3525] - dependent join handling of multi-way joins
• [TEIID-3553] - Odata - if table name is ambiguous, teiid returns result from first table
• [TEIID-3605] - Relax hard coded restriction on accessnode parallelism
• [TEIID-3612] - NPE in connectorworkitem after close
• [TEIID-3613] - Greedy join planning above exhaustive threshold issues
• [TEIID-3626] - Quickstart readme mark down formatting issues
• [TEIID-3633] - Metadata exceptions don't provide the table name
• [TEIID-3636] - SalesForce.com aggregate function query issues
• [TEIID-3639] - pg metadata query not qualified
• [TEIID-3651] - misc performance enhancements
• [TEIID-3655] - Generated REST Service war do not allow any no-rest url
• [TEIID-3664] - Timing issue with ping
• [TEIID-3667] - LDAPSyncQueryExecution.createSearchContext() hides a root cause when an error occurs
• [TEIID-3670] - Salesforce query issue
• [TEIID-3690] - Add a custom error page for rest war
• [TEIID-3697] - minimize invalid session exceptions in the logs
• [TEIID-3705] - Build issue in security
• [TEIID-3722] - Add an option to not widen comparisons to string

Component Upgrade

• [TEIID-3645] - Upgrade of Amazon aws sdk version

Enhancement

• [TEIID-3546] - Add distinct from syntax in for each row procedures
• [TEIID-3561] - Support HTTP Basic Digest mode in Web Service connector
• [TEIID-3568] - Order By and Limit are not getting pushed to the database, when Union and join are used together.
• [TEIID-3569] - OData servlet throws TEIID10036/TEIID40087 when disabling security
• [TEIID-3577] - Add cli script to configure audit and command logging
• [TEIID-3587] - Add ability to load translator module based "slot" classfication
• [TEIID-3591] - Report user query CPU time
• [TEIID-3594] - Change the default for command logging to write User query (start/end)
• [TEIID-3595] - Add to audit logging the user that logs in and out
• [TEIID-3659] - subquery unnesting missed
• [TEIID-3687] - Provide infinispan-cache translator override to add supportsNotCriteria
• [TEIID-3694] - Netezza translator - add additional support for other regexp functions
• [TEIID-3700] - Add a type mapping for impala decimal
• [TEIID-3712] - Add support for DATE/TIME/TIMESTAMP keyword literals
• [TEIID-3721] - Add OPTIONS capability to Procedure ResultSet
• [TEIID-3736] - Allow date formatted string literals to be parsed as timestamps
• [TEIID-3744] - WS: PATCH Method is not supported
• [TEIID-3745] - Procedure input parsing enhancements

Edit/Copy Release Notes

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