Sub-task
- [TEIID-1091] - Add remaining SQL/XML functions
- [TEIID-3282] - inconsistencies with the week function
- [TEIID-3284] - Remove the prestodb jar
Feature Request
- [TEIID-991] - Request for support of Sybase IQ as a supported data source
- [TEIID-1049] - Create data source for each VDB deployed automaticaly
- [TEIID-2194] - Allow the mat view cache hint to be specified via a property
- [TEIID-2384] - Managing Spatial Data Types
- [TEIID-2700] - Add CRUD support to Infinispan translator/connector
- [TEIID-2816] - HBase Connector/Translator
- [TEIID-2850] - Add options to support sql server variant type
- [TEIID-2882] - Add support for Presto DB
- [TEIID-3043] - Build a Docker image based kit for Teiid
- [TEIID-3046] - Add support for recursive common table expressions
- [TEIID-3121] - Teiid Standalone Server
- [TEIID-3169] - Update infinispan-cache translator to use DSLQuery in library mode
- [TEIID-3225] - TRACE level logging to request conflicting NAMESPACE and PATH references in WS request/response sets
- [TEIID-3251] - Support OAuth 1.0 & OAuth 2.0 Authorization with Web Service resource-adapter
- [TEIID-3256] - Add support for single line -- comments
- [TEIID-3258] - Add support for quoted identifiers in set/show
- [TEIID-3288] - Upgrade JDG DSL querying using hotrod client over protobuffers to JDG 6.4
- [TEIID-3301] - Add GEOMETRY_COLUMNS view
- [TEIID-3305] - Add system functions for GeoJSON
- [TEIID-3309] - Add system functions for GML2
- [TEIID-3339] - Adding the multisource column does not work with variadic procedures
- [TEIID-3340] - JDBC direct query execution binding is incorrect
Bug
- [TEIID-1680] - issues with correlation and aggregation
- [TEIID-2932] - Datastax: fail to access PortfolioDemo (demo schema that provided by Datastax)
- [TEIID-2988] - MongoDB: Function substring - starting index and number of arguments
- [TEIID-3073] - Tableau Connection Issues
- [TEIID-3187] - Error Casting TimeStamp to Date using Impala
- [TEIID-3197] - Fix install script on RHEL 6.5
- [TEIID-3205] - Push down supported select expression even if other select expressions are not supported by the source
- [TEIID-3209] - Issues with mat view ttl
- [TEIID-3212] - Materialized Views Documentation Issues
- [TEIID-3219] - Excel Translator Wrong Result From Columns With Interleaved Null Values
- [TEIID-3223] - An issue with time in WHERE clause - SQLServer
- [TEIID-3228] - SOLR: Date and Timestamp parsing is incorrect
- [TEIID-3229] - Inappropriate pushdown of a must pushdown function
- [TEIID-3235] - IndexOutOfBoundsException when using GROUP BY
- [TEIID-3236] - Copy criteria within a left outer join removes predicates
- [TEIID-3238] - Cassandra: Access to Cassandra fails with CNF "sun/misc/Unsafe"
- [TEIID-3242] - issues with data roles and foreign temp tables
- [TEIID-3248] - Null handling in XMLQUERY and XMLTABLE
- [TEIID-3249] - XMLCOMMENT missing validation
- [TEIID-3250] - Rewritten unknown expression in select becomes false
- [TEIID-3263] - Invalid aggregate value
- [TEIID-3267] - OPTION NOCACHE causes ConcurrentModificationException
- [TEIID-3268] - Dependent values can exceed source settings
- [TEIID-3269] - Oracle pushdown time formatting incorrect
- [TEIID-3271] - JDBC Translator | Incorrect Update count reported on Batched Update Execution
- [TEIID-3273] - Exception while using biginteger column with SUM function
- [TEIID-3277] - Setting SupportsLucenceSearch to false doesn't disable
- [TEIID-3281] - MongoDB: EmptyStackException when joining tables
- [TEIID-3290] - Auto generated REST WAR truncates the larger payloads
- [TEIID-3293] - Missing message for key "gss_auth_failed"
- [TEIID-3294] - dynamic vdb imports nvarchar2 as object
- [TEIID-3296] - Some criteria are missing when indexes are used on the source tables
- [TEIID-3299] - Errors when calculating bytes sent.
- [TEIID-3310] - Nesting aliases that match the engine recontext logic can lead to naming conflicts
- [TEIID-3315] - problem with function TRIM
- [TEIID-3316] - MongoDB: Getting "unrecognized field \"cursor" when connecting to MongoDB 2.4.8 using Teiid 8.9.1
- [TEIID-3319] - Union with different datatypes gives error in mysql
- [TEIID-3324] - Boolean fields with null are evaluated to false
- [TEIID-3325] - Subquery hints in row based conditions not honored
- [TEIID-3328] - Syntax error at or near "." running an INSERT INTO query in PostgreSQL
- [TEIID-3331] - Problem with dynamic vdb column metadata - for salesforce source w/import property
- [TEIID-3333] - Dynamic VDB deployment - JDBCMetadataProcessor NPE
- [TEIID-3334] - MongoDB: invalid ip address and port number
- [TEIID-3341] - Metadata load failure between retries of multi-source models
- [TEIID-3344] - Querying server-generated REST WAR fails with NPE when parameter is of type string
- [TEIID-3348] - MongoDB: Teiid 8.10 CR are not compatible with MongoDB 2.4.8
- [TEIID-3352] - Can't cast from decimal to boolean in postgresql
- [TEIID-3353] - In SQL Server INSERT ... VALUES clause UUID is not substituted
- [TEIID-3368] - The database-service.jar needs version version in its name
- [TEIID-3457] - Teiid 8.9.1 throw null exception when use AVG function on jboss-eap 6.3
Task
- [TEIID-3194] - Fix tab/spaces in codebase
- [TEIID-3226] - Need to upgrade org.springframework to at least version 3.2.12
- [TEIID-3239] - Cassandra: Update JAVA driver version to 2.1.3
- [TEIID-3365] - Update settings.xml to reflect JBoss maven repository changes
Component Upgrade
- [TEIID-3192] - Migrate Salesforce connectivity to sf partner api jars
Enhancement
- [TEIID-1170] - Support subqueries in temp table update/delete criteria
- [TEIID-2243] - Add ability to configure (change default) support for nulls first/last
- [TEIID-2407] - Support temporary table on commit behavior
- [TEIID-2561] - Allow nested MERGE of entities in MongoDB translators
- [TEIID-2821] - Getting invalid Query against Postgres DB
- [TEIID-3053] - Detect when returnable procedure results need to be processed in the procedure
- [TEIID-3137] - Change infinispan-cache translator to support JDG 6 and no longer support pre 6.0 infinispan
- [TEIID-3163] - Add TEXTTABLE capability to support Custom Line Separator
- [TEIID-3167] - Enhance TEXTTABLE to support TRIM as a configurable option for Delimited Text Files
- [TEIID-3202] - Add the translator to the log entry when the model is loaded
- [TEIID-3203] - Determine automatically when to use data shipment joins
- [TEIID-3208] - Remove outer join based solely on join predicates
- [TEIID-3216] - Implement INSERT, UPDATE and DELETE support for google-spreadsheet connector
- [TEIID-3220] - Datafederation quick start needs materialization teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT changed to match docs
- [TEIID-3224] - MongoDB: support direct query execution for Shell type command
- [TEIID-3227] - Add support for sub-expression pushing of must pushdown functions
- [TEIID-3243] - MongoDB: doens't support more than 1 aggregation in SQL
- [TEIID-3247] - MongoDB: Add "MinDistance" to near and nearSphere geo spatial functions
- [TEIID-3253] - Expand allowed order by expressions
- [TEIID-3266] - Support set session characteristics for txn isolation level
- [TEIID-3274] - Change archetypes to create independent projects
- [TEIID-3287] - Auto generated REST war does not query parameters
- [TEIID-3307] - PostgreSQL: Implement Teiid spatial
Quality Risk
- [TEIID-3210] - Refine ordered comparison pushdown support
- [TEIID-3230] - Sybase translator changes
- [TEIID-3234] - better detail messages related to caching
- [TEIID-3237] - Prevent processing cross joins with unknown cardinalities
- [TEIID-3259] - dynamic sql cannot use into with updates
- [TEIID-3275] - remaining work should always be canceled
- [TEIID-3283] - Create workaround for sybase grouping issue
- [TEIID-3326] - Add back a drools quick start
- [TEIID-3330] - Add relational node id to plans to match debug log
- [TEIID-3337] - Netty exception related to close logged at warn level
Edit/Copy Release Notes
The text area below allows the project release notes to be edited and copied to another document.