Sub-task

• [TEIID-3349] - Allow column type to be altered
• [TEIID-4353] - Create a teiid feature pack
• [TEIID-4481] - Support for the upsert statement which is provided by Salesforce API
• [TEIID-4497] - Add upsert support for JDG
• [TEIID-4513] - Create a dummy pg_prepared_xacts table
• [TEIID-4545] - Phoenix/Hbase should support functions
• [TEIID-4593] - Failed to load module org.jboss.teiid.rest-service" due to change in feature pack
• [TEIID-4641] - Create upsert/delete refresh support
• [TEIID-4719] - Add a ddl equivalent to the metadata tag

Feature Request

• [TEIID-4213] - Cassandra translator: enable pushdown of aggregate functions
• [TEIID-4284] - Implement Salesforce Bulk API for SELECTS to Salesforce Connector
• [TEIID-4455] - Impala Translator - Change planning step for from_unixtime() pushdown
• [TEIID-4524] - Add support for Microsoft SQL Server Sequences to the translator
• [TEIID-4532] - Provide one-way or cryptographic hash functions
• [TEIID-4556] - Phoenix/Hbase should support join
• [TEIID-4618] - Mongodb auto-increment primary key
• [TEIID-4622] - Adding new data quality functions from osDQ
• [TEIID-4629] - Offer a ddl solution to replace the vdb.xml
• [TEIID-4630] - Polish the teiid rest generated war

Bug

• [TEIID-4294] - External Materialization MATVIEW_AFTER_LOAD_SCRIPT may not be an atomic operation
• [TEIID-4499] - OData Kerberos cannot access VDB
• [TEIID-4503] - Unhandled charset conversion exception in lobworkitem
• [TEIID-4510] - JDG Complex POJO 1-n relationship wrong results when joining parent and child table
• [TEIID-4512] - Issue with older drivers and useStreamsForLobs
• [TEIID-4528] - ddl generation / parsing semicolon handling
• [TEIID-4535] - Issues with EventDistributor
• [TEIID-4546] - On setting jboss-teiid cluster : throwing java.lang.IllegalArgumentException.
• [TEIID-4547] - getQueryPlan fails in adminapi
• [TEIID-4548] - ReadRARDescription should be a list of properties
• [TEIID-4550] - Validation issues with upsert
• [TEIID-4553] - COUNT returns inconsistent results when column statistics are not gathered
• [TEIID-4560] - Documentation issues with TEIID-3669
• [TEIID-4564] - Add an option to AdminShell to specify the profile to use in domain mode
• [TEIID-4566] - Ordered limit against preserved view fails
• [TEIID-4570] - RestWebservice war Generation failed due to split out rest related logic to rest-service
• [TEIID-4573] - Modeshape query
• [TEIID-4574] - Rename hbase translator to phoenix
• [TEIID-4580] - ST_PointOnSurface returns point on the boundary of the polygon
• [TEIID-4581] - NPE occurs when the pkFieldName is not defined on the cacheTypeMap property
• [TEIID-4584] - SimpleDB doesn' work
• [TEIID-4588] - Duplicate column occurs when using translator to produce metadata for staging table
• [TEIID-4589] - Teiid throws NPE if multi-value insert is issued on global temporary table
• [TEIID-4590] - Fix the Select ALL logic so that it works when different object types exists
• [TEIID-4595] - Wrong pushdown of several spatial functions to Oracle
• [TEIID-4597] - Issue loading staging table
• [TEIID-4598] - NPE when analytic Source function for Greenplum doesn't get pushdown
• [TEIID-4601] - Infinispan DSL Translator: cannot insert into byte array column
• [TEIID-4603] - Insert issue when cache contains multiple pojo's with the same key value
• [TEIID-4605] - SqlServer translator - insert/update statements - timestamp is cast to datetime
• [TEIID-4607] - Postgresql translator - unable to insert NULL value to column of type Object
• [TEIID-4608] - Insert statement - multi-value insert into view - incorrect type resolution if first tuple contains NULL
• [TEIID-4609] - Sap-hana translator - unsupported cast to data type bintext
• [TEIID-4610] - Impala regexp_replace function colliding with prepared values
• [TEIID-4611] - Infinispan DSL translator - error deleting rows from table
• [TEIID-4613] - OData client does not support old servers for boolean functions
• [TEIID-4623] - Add support for analytic function "Lead" and "Lag" with GreenPlum Translator
• [TEIID-4631] - IN clause causes an error when used within a function in SELECT clause
• [TEIID-4633] - Odata $expand over Oracle tables generates bad query
• [TEIID-4634] - TEIID30003 - wrong order of arguments
• [TEIID-4637] - join of aliased views with partitioned unions not handled correctly.
• [TEIID-4638] - Mongo translator - nested embeddable tables - INNER JOIN is not symetric
• [TEIID-4639] - Mongo translator - embeddable tables - NULL primary key of embedded table in result
• [TEIID-4640] - Mongo translator - embeddable tables - creation of collection fails
• [TEIID-4644] - anonymous block dynamic issues
• [TEIID-4645] - Mongo translator - fail to initialize translator wiith property SupportsAggregatesCount
• [TEIID-4648] - MySQL unsigned type detection is incorrect
• [TEIID-4649] - SybaseIQ translator: different order of arguments in CONVERT function
• [TEIID-4650] - SybaseIQ translator: week function can't be pushed directly
• [TEIID-4651] - SybaseIQ translator: different order of arguments in LOCATE function
• [TEIID-4654] - MSSQL pagination with select distinct
• [TEIID-4655] - grammar documentation for drop is wrong
• [TEIID-4656] - parseTimestamp issue with Oracle
• [TEIID-4660] - Master build failed due to the test-integration/common test failed
• [TEIID-4661] - Subsequent queries hang after materialized view TTL expires.
• [TEIID-4666] - Google translator throws SpreadsheetOperationException for query DELETE FROM table
• [TEIID-4667] - Oracle translator - parseTime throws exception if string has extra trailing characters after standard time format
• [TEIID-4668] - Google translator skips NULL value in INSERT
• [TEIID-4673] - Translator import of google spreadsheet not updatable
• [TEIID-4676] - PrestoDB translator - convert/cast is not properly translated/pushed
• [TEIID-4677] - PrestoDB translator - date/time/timestamp values are pushed in Teiid's format ({d/t/ts '...'})
• [TEIID-4678] - PrestoDB translator - log function not translated correctly
• [TEIID-4679] - PrestoDB translator - locate function - source specific function has different order of arguments
• [TEIID-4680] - PrestoDB translator - error executing locate(string, string, int)
• [TEIID-4681] - PrestoDB tranlator - NPE while executing CHR function with illegal argument (char)
• [TEIID-4682] - PrestoDB translator - cannot use temp tables - PrestoDB could not commit transaction
• [TEIID-4683] - PrestoDB translator - dayof* functions not translated correctly
• [TEIID-4684] - PrestoDB translator - format* functions - invalid conversion to 'timestamp with timezone'
• [TEIID-4685] - PrestoDB translator - IFNULL is translated as NULLIF
• [TEIID-4686] - PrestoDB translator - ordering of joined tables fails
• [TEIID-4687] - PrestoDB translator - unsupported corelated subquery
• [TEIID-4692] - upsert delegating override not correct
• [TEIID-4693] - mysql "booleans" translation issues
• [TEIID-4694] - PrestoDB translator - NULL values not supported in SemiJoin
• [TEIID-4697] - Swagger translator issue with content type charsets
• [TEIID-4698] - Adding an INFO validation to a model can invalidate the vdb
• [TEIID-4700] - Google translator inconsistent behavior for DELETE and SELECT for null values
• [TEIID-4706] - PrestoDBMetadataProcessor load metadata failed due to Duplicate Table
• [TEIID-4710] - Request id conflict with CommandContext connection
• [TEIID-4713] - HANA translator evaluates > as >=
• [TEIID-4716] - Teiid -Prelease doesn't update the jdg slot number in kit
• [TEIID-4720] - changes in requiresLeftLinearJoin and useParensForJoins needed for Hive
• [TEIID-4721] - Aggregate name incorrect in FunctionCategoryConstants
• [TEIID-4722] - TEIID30019: java.lang.AssertionError: Assertion failed assertion due to guard against a corner condition.
• [TEIID-4725] - ObjectTranslator SearchByKey limit handling issue
• [TEIID-4726] - "java.util.ConcurrentModificationException" when deploying VDB
• [TEIID-4727] - Aggregation is performed incorrectly for JOIN queries
• [TEIID-4729] - Multisource SOURCE_NAME field pushes to source
• [TEIID-4730] - Problem with Import VDB with Materialized View (external)
• [TEIID-4737] - Incorrect work of left join statement
• [TEIID-4741] - After VDB undeploy (due to VDB syntax errors), system throws several TeiidProcessingException Warnings
• [TEIID-4743] - Dependent View with External Materialization load problems
• [TEIID-4744] - Prior execution is not being closed in transactional secenario
• [TEIID-4746] - CommandContext connection is broken for Embedded admin operations
• [TEIID-4754] - Wrong result with bidirectional relationship
• [TEIID-4755] - WS SOAP Response with WS-A Headers results in ClassCastException
• [TEIID-4769] - Queries fail against SYS.Datatypes with predicates on columns other than name

Task

• [TEIID-4398] - Write a utility to convert a .VDB with Index file into -vdb.xml or DDL format
• [TEIID-4437] - Convert Teiid build to use "feature-pack"
• [TEIID-4476] - Upgrade Cassandra Client library
• [TEIID-4505] - Clarify JDG doc's
• [TEIID-4699] - Summary of PrestoDB translator issues
• [TEIID-4701] - Create a quick start/embedded examples to demonstrate PrestoDB as a datasource

Quality Risk

• [TEIID-4533] - Change the default max-staleness for the resultset cache to 0
• [TEIID-4542] - Phoenix/Hbase junit test code, resource should be more clean
• [TEIID-4549] - Salesforce import issues
• [TEIID-4551] - Improve exception handling in Admin methods
• [TEIID-4563] - Too much COMMAND_LOG
• [TEIID-4586] - Query plan should show if xmltable is streaming
• [TEIID-4663] - Support a more secure block mode for client/server encryption
• [TEIID-4664] - Arquillian test failed due to new added ftp connector
• [TEIID-4707] - upgrade pre-intalled PrestoDB driver

Enhancement

• [TEIID-3755] - Allow embedded to set the default authentication type
• [TEIID-3952] - Update to updatable internal materialized view should update the materialized view as well as the database
• [TEIID-4298] - Support in Odata4 for the Partner NavigationProperty attribute
• [TEIID-4441] - Add FTP/SFTP based access to the File Resource Adapter
• [TEIID-4453] - Update database logging to semantic versioning and logoninfo
• [TEIID-4472] - Add CLI scripts for standalone "HA" and "FULL-HA" configurations
• [TEIID-4492] - When using annotations, add option that specifies all child classes to register as part of the JDG schema
• [TEIID-4493] - Add support for integration with qgis
• [TEIID-4504] - Provide an option to ignore the atomic block handling of triggers
• [TEIID-4509] - Implement transaction detection for procedures
• [TEIID-4515] - Phoenix/Hbase should support offset
• [TEIID-4521] - Add ability to sent ApplicationName thru ODBC connection
• [TEIID-4543] - Rewrite parse/format of standard formats to cast instead
• [TEIID-4544] - Change Teradata defaults for dependent joins
• [TEIID-4582] - Enable flexibiliy in use of colon delimiter when defining cacheTypeMap property
• [TEIID-4596] - Teiid does not return genereted keys after executeBatch
• [TEIID-4620] - MongoDB: Model "_id" during metadata import as string data type
• [TEIID-4621] - Add cli script to install swagger translator
• [TEIID-4627] - High-level event handling
• [TEIID-4632] - Clarify in doc's when a MAKEDEP temp table push down will be performed
• [TEIID-4643] - Add encrypt/decrypt functions
• [TEIID-4671] - Sybase translator should support parse/format timestamp
• [TEIID-4702] - Clarify that JDG is what's supported, not infinispan
• [TEIID-4731] - Unable to connect to MongoDB pod from JBoss Data Virtualization (on OpenShift)
• [TEIID-4751] - Allow any collection type to be source of OBJECTTABLE
• [TEIID-4756] - Improve log messages when using an UDAF without the required classes defined in VDB
• [TEIID-4759] - PrestoDB - not all custom timezone IDs are supported

Edit/Copy Release Notes

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