Release Notes - Teiid - Version 8.9 - HTML format

Bug

  • [TEIID-2914] - Infinispan Connector didn't have the advanced searching option exposed
  • [TEIID-3037] - Incorrect odata4j jar name
  • [TEIID-3045] - warning with translator usage
  • [TEIID-3048] - Conflicting CXF versions being used in Embedded kit
  • [TEIID-3049] - odbc still commits with disableLocalTxn
  • [TEIID-3051] - grant all should not be transitive to importing vdbs
  • [TEIID-3052] - Error on using MAKEDEP hint within union
  • [TEIID-3054] - The Object and Infinispan translators do not support negation (">" or "<") properly
  • [TEIID-3055] - Querying JDG local cache using greater than value cause exception
  • [TEIID-3057] - Kerberos ODBC connection on Teiid 8.8.0
  • [TEIID-3058] - Cassandra: cannot compare timestamp field in where clause
  • [TEIID-3065] - SOLR: NPE When issued query with SORT
  • [TEIID-3067] - External Materialization Management Issues
  • [TEIID-3071] - Module needs to be updated for new Saxon-HE
  • [TEIID-3074] - NPE When using External Materialization management is use
  • [TEIID-3077] - SOLR: Type date should be converted into Timestamp
  • [TEIID-3079] - Security domain associated with data source is not getting deleted while deleting the data source,post server restart.
  • [TEIID-3080] - incorrect foreign keys
  • [TEIID-3081] - Correct test errors with Java 8
  • [TEIID-3082] - Error with sideways correlation and aggregate decomposition
  • [TEIID-3083] - Fix modules so the versions are substituted at build time
  • [TEIID-3089] - TEIID10078 Invalid double format in String: Age
  • [TEIID-3092] - error with xml project minimization
  • [TEIID-3093] - SOLR: Translator ignores "Name In Source" attribute of table columns
  • [TEIID-3094] - SOLR: minus sign is not escaped
  • [TEIID-3097] - Model names should not be allowed to contain .
  • [TEIID-3099] - RejectedExecutionException for Teiid during high query load
  • [TEIID-3100] - SOLR: Connector ignores CoreName property
  • [TEIID-3101] - Assertion failed with UNION then EXCEPT
  • [TEIID-3103] - ODBC fetch fails to send command complete
  • [TEIID-3104] - ArrayImpl toString not correct
  • [TEIID-3106] - BufferManager Cleaner consuming 90% of total CPU time
  • [TEIID-3107] - NPE when WS translator not used with ContentHeaders argument
  • [TEIID-3109] - Duplicate key on matpg_relatt
  • [TEIID-3110] - name in source should not be omitted in ddl
  • [TEIID-3111] - Function with multi-part names not resolving correctly
  • [TEIID-3112] - Incorrect plural name with parent to child join
  • [TEIID-3113] - Incorrect parent name for child to parent query
  • [TEIID-3115] - Invalid Query With OrderBy in SubQuery Table
  • [TEIID-3117] - NullPointerException while creating source model from Excel table
  • [TEIID-3118] - Excel translator is not able to manage WHERE clause with time value
  • [TEIID-3123] - Exception when using dense_rank() in Teiid Development
  • [TEIID-3124] - InetAddress getLocalHost return UnknownHostException cause Teiid service start failed in JBoss Server
  • [TEIID-3127] - Multiple subquery arguments prevent plan completion
  • [TEIID-3128] - Issue while querying Salesforce.
  • [TEIID-3130] - NPE in excel translator if xlsx file is missing
  • [TEIID-3133] - Impala Time/Date/Timestamp handling
  • [TEIID-3134] - Impala sorting Issue
  • [TEIID-3135] - Result of query depends on Locale
  • [TEIID-3136] - Possible threading issues with index metadata loading
  • [TEIID-3138] - EmbeddedServer does not shutdown the session monitor
  • [TEIID-3139] - Common table expressions are not pre-evaluated
  • [TEIID-3144] - Unrelated correlated subquery in order by not working
  • [TEIID-3152] - result set close after session close reported as an error
  • [TEIID-3160] - Teiid inappropriately narrowing
  • [TEIID-3161] - Generated sql with trim strings is incorrect for insert variables and with clause
  • [TEIID-3162] - Class files checked into Git
  • [TEIID-3164] - Second connection to VDB through Kerberos authentication ends with exception
  • [TEIID-3165] - TeiidDataSource ignores jassName
  • [TEIID-3168] - SQL Server requires N prefix for unicode literals
  • [TEIID-3170] - Change build to include spring framework jar dependencies for WS translator
  • [TEIID-3171] - NullPointerException in LogonImpl when Credential Delegate is not enabled
  • [TEIID-3176] - Processing exception with function/procedure column and non-short scale
  • [TEIID-3178] - Handling for null values in plan nodes
  • [TEIID-3183] - Join sort order altered inappropriately
  • [TEIID-3184] - pg metadata always reports column names as lower case
  • [TEIID-3188] - ORA-01702: a view is not appropriate here
  • [TEIID-3190] - The modeled datatype integer for column 0 doesn't match the runtime type "java.lang.String" - TEIID 8.9.BETA1
  • [TEIID-3191] - Teiid global temporary table error with first invocation
  • [TEIID-3193] - Teiid not removing/setting the correct TCCL before calling getMetadata on translator
  • [TEIID-3198] - NPE on running an "execute immediate" command defined in a virtual procedure (Teiid-8.9.0-CR2)
  • [TEIID-3199] - node next batch processing time is computed incorrectly
  • [TEIID-3201] - Pushing a predicate when it is used only in a window function partition
  • [TEIID-3207] - JDBC native query with literals
  • [TEIID-3213] - Getting error when running adminshell load {script}
  • [TEIID-3215] - External Materialization ON_VDB_START_SCRIPT invocation issues
  • [TEIID-3217] - XMLTable type conversions result in npe
  • [TEIID-3222] - Dependent join planning modifies left outer to inner join

Component Upgrade

Enhancement

  • [TEIID-2958] - MongoDB: Remove the need to have parent id in embedded table
  • [TEIID-3040] - MongoDB: Remove the IDREF fields for the FK fields
  • [TEIID-3042] - expose dependency information in system tables
  • [TEIID-3050] - allow for more incremental insert with iterator
  • [TEIID-3060] - Additional cassandra type handling
  • [TEIID-3061] - MongoDB: Support VARBINARY type
  • [TEIID-3063] - Push down DISTINCT with select expression in the query and the datasource doesn't support select expressions
  • [TEIID-3066] - SOLR: Provide count(*) capability natively by translator
  • [TEIID-3072] - SOLR: Make the Id named field as PK
  • [TEIID-3098] - allow pushdown functions to be used by designer import
  • [TEIID-3102] - Provide a facility to restrict OData access to defined VDB
  • [TEIID-3105] - Can we add allowDuplicateDomains in Infinispan global configuration
  • [TEIID-3114] - Add an option to not normalize salesforce names
  • [TEIID-3119] - Improve full sort performance for dup removal and grouping
  • [TEIID-3125] - Netezza translator - add support for the LIKE_REGEX predicate.
  • [TEIID-3129] - Limit is not added with multiple nulls in select on outer query to an inline view
  • [TEIID-3131] - Broaden aggregate decomposition scenarios
  • [TEIID-3149] - External materialization management with Embedded Server
  • [TEIID-3153] - Allow to write stream data with large size (>10G)
  • [TEIID-3166] - Allow allowDiskUse setting in MongoDB translator
  • [TEIID-3180] - Use TEIID/hostname as default Kerberos principal name
  • [TEIID-3181] - Use Teiid as default JAAS application name
  • [TEIID-3185] - Support JBoss EAP 6.3 Alpha1 as host environment

Feature Request

  • [TEIID-2881] - Add support to use DSL when querying remote JDG 6.2
  • [TEIID-2948] - Implement Access Controls on management operations in Teiid
  • [TEIID-2982] - Allow to change visibility to a model from imported vdb
  • [TEIID-3019] - Change SYSADMIN.refreshMatViewRow to support a list of rows instead of just one
  • [TEIID-3030] - Update Saxon to current release (9.5.x)
  • [TEIID-3038] - Add spatial query support to the Teiid MongoDB translator
  • [TEIID-3044] - Add function metadata to system tables / databasemetadata
  • [TEIID-3059] - Support consuming SOAP based service that is secured by Kerberos authentication
  • [TEIID-3062] - Apply LIMIT 1 optimization for DISTINCT in UNION situations
  • [TEIID-3120] - honor javax.sql.DataSource LoginTimeout
  • [TEIID-3143] - LOOP on UNION leads to java.lang.ClassCastException
  • [TEIID-3147] - Add information about the amount of data (in bytes) returned by each query
  • [TEIID-3156] - Provide a mechanism to turn off string sorting
  • [TEIID-3177] - Enforce SSL connections over ODBC when Encryption Mode is enabled

Quality Risk

Task

  • [TEIID-1910] - Teiid support for EclipseLink persistance provider
  • [TEIID-3195] - Fix docs Oracle module.xml

Sub-task

  • [TEIID-3009] - perform projection minimization on with commands
  • [TEIID-3095] - Expose system and pushdown functions
  • [TEIID-3175] - Allow property lookup on function parameters

Edit/Copy Release Notes

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