Release Notes - Teiid - Version 9.2 - HTML format

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

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

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

Edit/Copy Release Notes

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