Release Notes - Teiid - Version 8.5 - HTML format

Sub-task

  • [TEIID-1892] - Support the get/setArray methods of JDBC resultsets/statements
  • [TEIID-2555] - Support pushdown of entire dependent joins
  • [TEIID-2558] - Add translator support for dependent join pushdown
  • [TEIID-2559] - Add additional make dep hint options

Feature Request

  • [TEIID-247] - Add support for array types
  • [TEIID-1522] - propagate all projected constants from non-merged view layers
  • [TEIID-2067] - Global temporary tables
  • [TEIID-2249] - Enable the use of temporary tables for those data sources that support them instead of IN criteria for EDS
  • [TEIID-2336] - Pushdown support for arraytable
  • [TEIID-2443] - Support Language feature for "With Rollup"
  • [TEIID-2527] - Dynamically change the sources in a multi-source model
  • [TEIID-2528] - Support an encypted storage mode
  • [TEIID-2584] - Add management features to materialization
  • [TEIID-2589] - Subplans are repeated in the reported query plan
  • [TEIID-2619] - Add an option to force executions to complete in a single thread
  • [TEIID-2662] - A materializated view with function based indexes fails

Bug

  • [TEIID-2035] - DeleteDataSource method on Admin API does not completely delete the Connection Factory
  • [TEIID-2294] - Allow to use alias name to lookup the certificate from keysore at jdbc ssl transport layer
  • [TEIID-2475] - The RelationalNode.collectNodeStats is only subtracting out the last node
  • [TEIID-2549] - Join planning produces cross joins with limited costing
  • [TEIID-2551] - Delegating does not work for the createXXXExecution methods
  • [TEIID-2553] - Partial insert statements being submitted with incorrect default values
  • [TEIID-2556] - Dependent join pushdown with array type incorrect
  • [TEIID-2557] - Provide support for Composite Foreign Keys in MongoDB
  • [TEIID-2560] - wrong result with distinct independent values in a depedent join
  • [TEIID-2563] - assignDataSource issues
  • [TEIID-2564] - Correlated subqueries throws TEIID30328
  • [TEIID-2565] - Problem with DDL returned via admin api - column has erroneous datatype
  • [TEIID-2568] - Order by is omitted when projection is raised above ordering with grouping
  • [TEIID-2570] - blocked code lookup needs to consider key value
  • [TEIID-2573] - Default source sql for varbinary in JDBC is incorrect
  • [TEIID-2574] - HiveMetadata procesor typo in importer property name
  • [TEIID-2575] - Hive's Binary Type Handling by Teiid
  • [TEIID-2576] - Oracle driver throws ArrayIndexOutOfBounds on bulk insert
  • [TEIID-2580] - xsi:nil is not honored by xmltable
  • [TEIID-2581] - vararg stored procedure error with empty call
  • [TEIID-2587] - source hint placed in with clause
  • [TEIID-2588] - create temp table with not null column toString not correct
  • [TEIID-2591] - Incorrect values returned from system table on dependent side of join
  • [TEIID-2596] - enabled cipher suites property cannot be set
  • [TEIID-2606] - Duplicate resource during restart of server with dynamically generated REST WAR file
  • [TEIID-2609] - teiid-odata-8.3.0.Final.war generates exception at startup
  • [TEIID-2610] - pg protocol issues
  • [TEIID-2612] - Teiid ODBC compatibility with perl-DBD-Pg for postgresql is broken
  • [TEIID-2615] - Teiid 8.5 TEIID30238 Duplicate key on #MAT_PG_CATALOG.MATPG_RELATT
  • [TEIID-2626] - If a column type is not set, null values will be written into persisted batches
  • [TEIID-2628] - StackOverflowError Running Query Against REST Service
  • [TEIID-2631] - Issues with multiple returnable statements in a procedure
  • [TEIID-2632] - Atomic blocks don't reset the transaction context on completion
  • [TEIID-2633] - Criteria is assumed needed when no other predicates determined during RuleRaiseAccess
  • [TEIID-2634] - Dynamic SQL will fail to execute in an exception handling block
  • [TEIID-2635] - Block exit does not reset the temptablestore
  • [TEIID-2636] - Stream corruption errors when doing big query
  • [TEIID-2637] - Catching exceptions in BatchIterator.more masks problems
  • [TEIID-2638] - CLI Scripts are incorrectly referencing the cache within the cache container, should reference cache container
  • [TEIID-2639] - Internally generated and user submitted anonymous blocks can't access temp tables from the surrounding scope
  • [TEIID-2641] - improve transaction handling in procedures
  • [TEIID-2646] - Invalid native query message values are incorrect.
  • [TEIID-2650] - A jboss server in domain mode does not advertise its teiid runtime-version
  • [TEIID-2651] - Embedded missing dependencies
  • [TEIID-2652] - Dependencies set on OLAP translator's module.xml are incomplete
  • [TEIID-2654] - CXF Logging Configuration Example - Missing Entry?
  • [TEIID-2656] - Teiid OData Servlet throws java.lang.NullPointerException on every GET
  • [TEIID-2658] - Teiid domain CLI script does execute to completion on EAP 6.1-Alpha
  • [TEIID-2660] - OData procedure issues
  • [TEIID-2664] - Misc OData issues

Task

  • [TEIID-2567] - issues with permission element in vdb-deployer.xsd contains problematic choice node

Quality Risk

  • [TEIID-2101] - Statement.setMaxRows is not always used
  • [TEIID-2365] - Reduce the usage of output names on the server side
  • [TEIID-2566] - standalone-teiid.xml and the CLI scripts point to different caches in the teiid subsystem
  • [TEIID-2579] - Have SSL connector support for plaintext passwords
  • [TEIID-2582] - Local connections using the calling thread should not buffer results
  • [TEIID-2586] - foreign temporary table consistency
  • [TEIID-2598] - 7.4 compatibility
  • [TEIID-2600] - IllegalArgumentException when creating datasource from an imported Webservice source model
  • [TEIID-2601] - Better handling for streamed lobs
  • [TEIID-2608] - Increase pg odbc client compatibility
  • [TEIID-2611] - Client forwards compatibility issue
  • [TEIID-2613] - implicit rowcount handling
  • [TEIID-2616] - The error should be clearer when making a non-ssl connecting to an ssl server
  • [TEIID-2621] - improve texttable error messages
  • [TEIID-2622] - Data/plan modification check is not granular enough
  • [TEIID-2629] - Message for missing translator needs improvement
  • [TEIID-2630] - SAP reponds with a 401 html page with bad or missing credentials
  • [TEIID-2645] - Invalid vdb results in NPE
  • [TEIID-2655] - Minimize the reporting of erroneous illegalstateexceptions

Component Upgrade

  • [TEIID-2552] - Upgrade javacc-maven-plugin from 2.4.1 to 2.6

Enhancement

  • [TEIID-2381] - Expanded source hint support
  • [TEIID-2390] - Improve xml/json production
  • [TEIID-2441] - Invalid character detected for charset {0}. The text may be encoded in a different charset.
  • [TEIID-2495] - Detect situations in which intermediate updates are not needed such that the updates can be grouped
  • [TEIID-2502] - Oracle Struct Serialization Error
  • [TEIID-2512] - Allow chaining of Metadata Repositories with multiple <metadata> elements in vdb.xml
  • [TEIID-2522] - Let Extract(<Oracle Date field>) extract time components
  • [TEIID-2539] - Add "allow-join" metadata based join processing on Foreign keys
  • [TEIID-2569] - Inefficient Outer Join compensation when translator restricted on KEY based joins
  • [TEIID-2571] - Generally allow must pushdown function evaluation
  • [TEIID-2572] - Add native-query functionality to pushdown functions
  • [TEIID-2590] - Use both the general and specific hint in the oracle hint
  • [TEIID-2595] - Allow for more limit/offset expressions
  • [TEIID-2597] - Allow Salesforce COnnection timeouts to be easily adjusted
  • [TEIID-2602] - Add clearer message that a VDB cannot be deployed without a JNDI name specified in the .vdb
  • [TEIID-2603] - Support larger statistic values
  • [TEIID-2604] - ODBC string error response message is incorrect
  • [TEIID-2614] - Allow anonymous procedure blocks
  • [TEIID-2618] - Add Example of SAP connection
  • [TEIID-2620] - Add support for array/list indexing in teiid script

Edit/Copy Release Notes

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