Sub-task
- [TEIID-3749] - Remove CXF patch file for "PATCH" http transport issue
- [TEIID-3750] - Allow the parsing of an expression
- [TEIID-3782] - OData V4: Support system options over the operation based collections
- [TEIID-3906] - OData v4 - definition of OData-Isolation header is either being ignored or is not implemented correctly
- [TEIID-3911] - Nearly all odata4 errors reported as internal server errors
- [TEIID-3962] - remove invalid character handling from Teiid odata4 logic
- [TEIID-3968] - OData 4 array type handling
- [TEIID-3972] - Create asciidoc generation from javacc doc
- [TEIID-3992] - Improve performance of pg system tables
- [TEIID-4035] - Parameter alias without value returns http status code 500
- [TEIID-4038] - OData returns bad number of entities with $count and $expand
- [TEIID-4039] - Resolving of entityid with additional system options fail
- [TEIID-4040] - Representation of OData error does not contain error code.
- [TEIID-4041] - OData response does not contain header "allow"
- [TEIID-4042] - OData returns status code 200 instead of 204 if there are no expanded entities
- [TEIID-4043] - If some functionality is not supported then OData should return status code 501 instead of 500
- [TEIID-4044] - OData ignores entities with empty list of related entities if $filter is applied to expanded entities
- [TEIID-4045] - OData throws unknown error if $select is applied to expanded entity
- [TEIID-4046] - OData - $skip is beeing ignored
- [TEIID-4047] - OData - $top with negative value return status code 500
- [TEIID-4054] - OData - creation of entity (POST) returns exception (status code 500)
- [TEIID-4055] - OData - updating of raw value fails (PUT method to URL with path $value)
- [TEIID-4056] - OData - PUT cannot parse entity
- [TEIID-4057] - OData - if PUT fails, next update request fails because table in DB is still locked
- [TEIID-4058] - OData - Request entity which does not exist return 204 instead of 404
- [TEIID-4059] - OData - $ref after $expand does not work
- [TEIID-4060] - OData - $count after $expand does not work
- [TEIID-4061] - OData - request is not traslated to valid SQL
- [TEIID-4062] - OData - $crossjoin fails due to missing class
- [TEIID-4063] - OData - $all returns 500 without message (generic error page of EAP)
- [TEIID-4064] - OData - missing non-nullable property
- [TEIID-4067] - OData - service returns generic EAP page in case of 404
- [TEIID-4082] - OData - null literal is not supported
- [TEIID-4085] - OData doesn't support mulitiple usage of arithmetic operators
- [TEIID-4086] - OData - Math functions floor and ceiling doesn't accept number as parameter
- [TEIID-4087] - OData - Math function round doesn't accept decimal number as parameter
- [TEIID-4103] - OData - wrong string indexing in string functions indexof and substring
- [TEIID-4110] - Odata - date functions does't accept date string as a parameter
- [TEIID-4121] - Enhancing the External Materialization
- [TEIID-4138] - Move teiid embedded example doc to gitbook
- [TEIID-4143] - Wrong Content-Type in error response from odata
- [TEIID-4156] - Odata - incorrect count with query option $count=true
- [TEIID-4222] - replace JBoss AS to WildFly
- [TEIID-4231] - OData - NPE when accessing inactive vdb
Feature Request
- [TEIID-2293] - Update Object-Translator to add support for JPA/Hibernate search annotations in the metadata processor
- [TEIID-2403] - SAML support in Teiid based web services
- [TEIID-3462] - Add support for semantic versioning of VDBs
- [TEIID-3520] - Add support for Swagger Translator
- [TEIID-3601] - support larger row counts
- [TEIID-3725] - In the JDG translators, enable named cache swapping so that materialization can be supported
- [TEIID-3792] - Add support for searching in array types
- [TEIID-3869] - Enable Teiid to be exposed as a GIS compliant data source
- [TEIID-3894] - Teiid transport ssl attributes should add some default values
- [TEIID-3913] - Support OAuth security on OData interface using Keycloak
- [TEIID-3918] - HIVE translator does not support direct query procedure
- [TEIID-3919] - Add support for using Security mapping modules in security domain for teiid
- [TEIID-4076] - Refine autoCommitTxn detect
- [TEIID-4084] - Improve with clause performance via inlining
- [TEIID-4092] - Add vdb for demonstrate internal materialization
- [TEIID-4202] - Support Lateral join and procedure pushdown
- [TEIID-4205] - send results proactively under a cursor as it looks like the ODBC client requires a transaction.
- [TEIID-4327] - Provide arche-type for creating UDF
Bug
- [TEIID-2754] - DatabaseMetaData reports views as tables
- [TEIID-2762] - Can't deploy or execute VDB by JBDS with setting useDisk property to false
- [TEIID-3684] - RoleBasedCredentialMapIdentityLoginModule throws exception at startup time
- [TEIID-3685] - org.teiid.padSpace does not affect to the "IN" operator
- [TEIID-3748] - Impala translator - SELECT and HAVING statements are translating differently for Case statements
- [TEIID-3790] - Restrict any authenticated roles
- [TEIID-3815] - Oracle translator - OFFSET function does not work
- [TEIID-3872] - Error with odata entity create with generated keys
- [TEIID-3914] - Datetime values not properly encoded in OData4 entity identifiers
- [TEIID-3921] - Accumulo translator doesn't end query execution when there are no tablet servers
- [TEIID-3929] - Accumulo does not return null values
- [TEIID-3930] - Accumulo translator: select rowid returns empty resultset
- [TEIID-3933] - Accumulo translator: problem comparing number literals
- [TEIID-3937] - Multiplying two columns in CASE statement overrides pushdown (Impala)
- [TEIID-3938] - EdmDate and EdmTimeOfDay output in local timezone
- [TEIID-3943] - Add schema name to oracle packaged objects
- [TEIID-3944] - Accumulo translator: rowid column is compared as string in WHERE clause
- [TEIID-3949] - Subqueries are wrongly pushed down to the underlying datasource
- [TEIID-3950] - UDFs aren't found when using old function definitions model
- [TEIID-3951] - Stored procedure in view model from SQL server 2000
- [TEIID-3953] - .TeiidRuntimeException: TEIID20001 The modeled datatype string for column 1 doesn't match the runtime type "java.math.BigDecimal".
- [TEIID-3954] - OData 4 procedure/action result set lob handling incorrect
- [TEIID-3956] - Retrieving just a stream property fails for OData4
- [TEIID-3958] - NPE Executing Against Web Service Source using invokeHttp() procedure without stream parameter
- [TEIID-3960] - Otherwise evaluatable constructs will inhibit pushdown
- [TEIID-3963] - Arrays returned by actions/functions from odata4 result in errors
- [TEIID-3964] - Cassandra does not account for null values
- [TEIID-3966] - google spreadsheet translator using Collections.singletonList instance returned by the runtime doesn't support the set method.
- [TEIID-3969] - Missing translators in cli scripts
- [TEIID-3970] - Documentation on RARs is out of date
- [TEIID-3971] - Clob.getSubstring(int,int) returns empty or whole string
- [TEIID-3973] - org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate COLUMN1: No value was available
- [TEIID-3974] - MIN and MAX on boolean not supported in Vertica
- [TEIID-3975] - 8.13+ Teiid Client should work on JRE 1.6
- [TEIID-3978] - Remove AddressWrapper
- [TEIID-3979] - Teiid generates queries containing VARCHAR without a size, causing an HSQL syntax error
- [TEIID-3980] - NPE with Salesforce retrieve query and no matching entity
- [TEIID-3981] - Salesforce-34 connector dependency on "com.force.api" is wrong
- [TEIID-3983] - External Materialization MATVIEW_ONERROR_ACTION WAIT problem
- [TEIID-3989] - PartialResultsWarning not being returned
- [TEIID-3990] - Issues with nested correlated references
- [TEIID-3993] - Teiid: indexOutOfBoundsException on union + count distinct query
- [TEIID-3994] - AliasSymbol wrapping AliasSymbol error
- [TEIID-3995] - SAP HANA materialization:function loadMatView with argument invalidate set to true problem
- [TEIID-4002] - Configuring of JDG DSL resource adapter still requires marshaller and protobuf when using annotations to define schema
- [TEIID-4003] - Vertica and DB2 translators use incorrect push down of WEEK function
- [TEIID-4006] - Texttable column header option toString incorrect
- [TEIID-4007] - Unparseable model name if user changes odata4 context root
- [TEIID-4008] - Sending teiid varbinary value (x'') to Microsoft SQL Server errors
- [TEIID-4011] - automatic/autonomous refresh of materialized views does not work
- [TEIID-4015] - Error or incorrect value when there is a conflict between local and correlated names
- [TEIID-4018] - Class loading issue using ProtoSchemaBuilder to register annotated pojo
- [TEIID-4019] - teiid-standalone-mode-install.cli executed failed due to 'authentication-security-domain' be removed
- [TEIID-4022] - Materialization issue dynamic SQL command can't be executed due ambiguous group name
- [TEIID-4023] - Exception with unresolved Array expression hashcode
- [TEIID-4024] - Server fails to shutdown if vdb with REST service generation is deployed
- [TEIID-4025] - Web admin console typo when setting time-slice-in-milliseconds attribute
- [TEIID-4028] - adding salesforce-34 resource adapter does not work through the cli
- [TEIID-4031] - Missing dependency in module com.fasterxml.jackson.dataformat.yaml
- [TEIID-4032] - Olingo V4
- [TEIID-4034] - Google spreadsheet translator issues
- [TEIID-4050] - database logging doesn't add command and audit loggers for domain mode
- [TEIID-4066] - Odata translator ClassNotFoundException: com.sun.ws.rs.ext.RuntimeDelegateImpl
- [TEIID-4068] - wrong handling if pg client requests ssl, but it's not configured on the server
- [TEIID-4070] - Issues with resource adapters with api modules in wildfly
- [TEIID-4072] - Duplicate columns for insert should not be allowed
- [TEIID-4073] - OData filters should accept boolean expressions
- [TEIID-4077] - Mysql5 translator - unknow column in having clause
- [TEIID-4078] - Oracle translator - query fails - ORA-00979: not a GROUP BY expression
- [TEIID-4089] - Teiid JDBC driver does not reset the update count when calling getMoreResults(int)
- [TEIID-4090] - Issue with entitysets/properties ending in auth or token
- [TEIID-4093] - OData authentication fails with NPE when gss-pattern related properties are included in VDB
- [TEIID-4096] - AssertionError with independent side of a dependent join that has an ordered limit
- [TEIID-4104] - FORMATTIMESTAMP function is not correctly pushed down when a column is passed as FORMAT argument
- [TEIID-4105] - ODATA: Duplicate NavigationProperty name
- [TEIID-4107] - HSQL Syntax error when Teiid sends it a join query with no parenthesis
- [TEIID-4109] - spatial_ref_sys reference needs qualified
- [TEIID-4112] - ORA-32039: recursive WITH clause must have column alias list
- [TEIID-4114] - Expanding logic in the format conversion for parsing and formatting of dates
- [TEIID-4115] - XMLTABLE single element in sequence invalid conversion
- [TEIID-4118] - Temp capabilities for null ordering not correct if default is changed
- [TEIID-4120] - Teiid on Oracle Spatial generates incorrect SQL
- [TEIID-4123] - Issues with odbc metadata
- [TEIID-4124] - add literal date format YYYY-MM-DD to the SQL Server translator
- [TEIID-4125] - Problem with SOAP war generated in TD
- [TEIID-4130] - Prevent blocked exceptions from being thrown in AccessNode open
- [TEIID-4133] - SQL Server requires CAST when using NULL in anchor part of recursive CTE
- [TEIID-4134] - Oracle requires column alias list when using recursive CTE
- [TEIID-4135] - Invalid query when using recursive CTE with translators that do not suport RCTE pushdown
- [TEIID-4136] - Sybase/SQL Server translator varchar length incorrect
- [TEIID-4144] - Mismanagement of output columns in ruleimplementjoinstrategy
- [TEIID-4146] - Using JDG Library Mode, unable to perform insert (
- [TEIID-4147] - matpg_datatype should include more type mappings
- [TEIID-4148] - Add "org.modeshape.jdbc" dependency to teiid jdbc translator module
- [TEIID-4150] - Infinispan dsl resource-adapter has not valid module.xml
- [TEIID-4151] - AssertionError: Delete failed
- [TEIID-4157] - Hive/Impala translator - Translators throw ClassCastException
- [TEIID-4158] - Hive/Impala translator - select distinct and gorup by is not supported in one query
- [TEIID-4160] - Impala - result set is not sorted if ORDER BY is defined in query
- [TEIID-4165] - HBase translator - time values are not translated correctly
- [TEIID-4166] - JDG remote cache translator (DSL) - In predicate does not support more than 1024 values
- [TEIID-4168] - Odd resolving error with implicit temp groups
- [TEIID-4170] - Correct documentation on materialized view indexes
- [TEIID-4172] - Missing Link to "Custom Resource Adapters "
- [TEIID-4175] - Certain nested dependent join structure will cause fewer results than expected
- [TEIID-4181] - Accumulo translator: AccumuloDataTypeManager various data types issues
- [TEIID-4184] - Timestamps need to be submitted without supporting {ts} for OSI PI translator
- [TEIID-4188] - Anonymous SSL connection fail with IBM JDK
- [TEIID-4192] - If a column is blank the TEXTAGG function excludes it from the output
- [TEIID-4194] - Informix translator - constant time values are translated as timestamp
- [TEIID-4195] - Informix - min/max functions are not supported for boolean values
- [TEIID-4196] - Redshift - function TO_TIMESTAMP does not exist
- [TEIID-4197] - Redshift - some comparison conditions are not supported with ANY, SOME and ALL
- [TEIID-4199] - Redshift fails locate pushdown
- [TEIID-4203] - QueryResolverException thow in resolving loadMatView
- [TEIID-4204] - Examples dynamicvdb-restservice - rest client returns always empty body
- [TEIID-4207] - Limit pushdown is incorrect for simpledb
- [TEIID-4209] - Primary key import fails with OSIsoft PI translator
- [TEIID-4211] - Wrong rewriting of CTEs when pushed down to PostgreSQL
- [TEIID-4214] - Null pointer exception with trace log
- [TEIID-4215] - Clean up typos in error messages
- [TEIID-4216] - AUTHENTICATION_TRUST_ALL_LOCAL attribute not showing up in teiid read-resource
- [TEIID-4220] - Unsupported encoding when POSTing to odata on Windows
- [TEIID-4221] - HANA translator: incorrect pushdown of week function
- [TEIID-4223] - Hana translator: incorrect pushdown of QUARTER function
- [TEIID-4224] - HANA translator : incorrect pushdown of DAYOFWEEK function
- [TEIID-4226] - HANA translator: boolean type converted to tinyint in each convert
- [TEIID-4229] - ODBC driver documentation needs to include additional information on driver options
- [TEIID-4232] - Wrong detection of recursive plans when same aliases are used in nested CTEs
- [TEIID-4235] - dynamic sql recursion check not valid after caught exception
- [TEIID-4236] - OData - incorrect SQL in example
- [TEIID-4237] - INNER JOIN returns incorrect results
- [TEIID-4244] - Assertion failed error when joining duplicate rows to a table from other source
- [TEIID-4246] - HANA translator: boolean column is not valid boolean expression in HANA
- [TEIID-4248] - Build change for 8.13 caused the release notes to miss the version replacement
- [TEIID-4254] - PG transport SSL Warning during the client connection
- [TEIID-4255] - Transformation exception when parsing time in SAP NW Gateway
- [TEIID-4256] - Hive translator - types in IN predicate should be of same type
- [TEIID-4260] - Accumulo: Resource adapter fails to load
- [TEIID-4262] - Wrong result (empty or NULL) with an view and a single disjunction for join criteria
Task
- [TEIID-3286] - Deprecate the support for Client JDK 1.5, to be removed in v9
- [TEIID-3559] - Refactor Object and Infinispan translator / connectors
- [TEIID-3871] - moving documentation from confluence to gitbook
- [TEIID-3932] - Upgrade the Olingo library to 4.2.0
- [TEIID-3945] - Switch to more standard locations for google dependencies
- [TEIID-4014] - remove oid from system tables
- [TEIID-4141] - Move REST auto-generate code into in its own module
- [TEIID-4179] - Update the documentation of the ODBC with connection properties
- [TEIID-4180] - Improve the documentation on ODBC SSL
- [TEIID-4328] - Update connector and translator arche-types based on wildfly
Release
- [TEIID-3729] - Teiid 9 tasks
Enhancement
- [TEIID-2476] - Exclude hidden tables/columns from metadata
- [TEIID-2694] - Support for Blob Input in Teiid REST services
- [TEIID-2734] - Add native query support to Cassandra
- [TEIID-3050] - allow for more incremental insert with iterator
- [TEIID-3480] - External Materialization status
- [TEIID-3489] - Can a function be added to filter certain ASCII chars below 31 and above 127 out of an XML Document
- [TEIID-3509] - Consolidate internal and external materialization management
- [TEIID-3583] - Need documentation on possible property settings to use
- [TEIID-3599] - Excel translator and dynamic filenames
- [TEIID-3758] - Allow for a 2048 bit DH key exchange
- [TEIID-3849] - Writes using Cassandra connector are very slow
- [TEIID-3909] - Add support for odata translator geospatial handling
- [TEIID-3917] - Allow partial projection of window functions
- [TEIID-3934] - Additional must pushdown support
- [TEIID-3941] - Upgrade Accumulo libraries to 1.6.4 version
- [TEIID-3942] - Accumulo translators should use LexiCoders to preserve the native ordering
- [TEIID-3957] - Impala translator - Add pushdown of offset in LIMIT clause to overcome difference in LIMIT clause
- [TEIID-4005] - Allow dependent join row value to be split
- [TEIID-4016] - Teiid parser fails to address co-existence of SQL comment and cache hint prior to rest of SQL string
- [TEIID-4075] - Netezza translator to support common table expressions
- [TEIID-4080] - Prevent expired client/server certificates from being accepted
- [TEIID-4101] - Internal materialization documentation should be more clear about implicit loading
- [TEIID-4106] - Rename and align infinispan translators/resource-adapters for their purpose
- [TEIID-4111] - Impala translator - add all date pushdown functions
- [TEIID-4137] - Postgresql translator should support recursive common table expressions
- [TEIID-4142] - Use a universal procedure to update Mat View
- [TEIID-4159] - Hive translator - select distinct count(*) is not supported
- [TEIID-4189] - Allow ndv calculation to consider types
- [TEIID-4210] - Allow limits to apply to the final sort pass
Quality Risk
- [TEIID-3669] - Look at consolidating to a single session service
- [TEIID-3752] - Remove the assignToModel admin method
- [TEIID-3753] - Change widenComparisonToString to false by default
- [TEIID-3797] - Use the term local consistently
- [TEIID-3912] - Centralize type handling for odata4
- [TEIID-3936] - Wildfly kit is missing jboss integration docs
- [TEIID-3939] - Refined Behavior of Connection.setReadOnly
- [TEIID-3948] - Provide a different mechanism to update odata wars
- [TEIID-3959] - dynamic VDB, Not loading UDF , Showing class Not Found .
- [TEIID-3965] - Remove unnecessary severe logs from the client
- [TEIID-3967] - Function class not found results in an uncaught exception
- [TEIID-3985] - NativeMetadataRepository swallowing original exceptions
- [TEIID-3986] - Materialization planning should be sensitive to property changes
- [TEIID-3987] - SYSADMIN.setProperty should resolve property keys
- [TEIID-3988] - Narrow when serial source access is used
- [TEIID-3999] - more aspects of materialization metadata should be validated
- [TEIID-4001] - Make error handling check for content type in OData4
- [TEIID-4020] - Add xquery to message when it is invalid
- [TEIID-4052] - Dynamic SQL exception should include evaluated sql
- [TEIID-4098] - Always preserve columns order in google spreadsheets models
- [TEIID-4108] - Embedded examples need to mention the Teiid project version
- [TEIID-4122] - Improve performance of odbc client column metadata query
- [TEIID-4126] - PlanToProcessConverter logical conjunction contains condition with no effect (x==x)
- [TEIID-4140] - Node statistics not populated when node returns a buffer
- [TEIID-4154] - Remove the dynamic vdb terminology
- [TEIID-4164] - Correct the transitive dependencies in OData4 translator
- [TEIID-4169] - Deployment/start sequence issue
- [TEIID-4176] - Initialize temp table metadata cardinality as 0
- [TEIID-4186] - Prevent partial aggregate pushdown based upon type
- [TEIID-4206] - Validate property setters
- [TEIID-4240] - Anonymous procedure blocks should be used for materialization scripts
- [TEIID-4241] - Remove dependencies used for embedded examples
- [TEIID-4270] - Update docs about connection-type property
- [TEIID-4301] - Migration Guide From Teiid 8.x: Java versions swapped?
- [TEIID-4336] - Errors in logs during server shutdown
Edit/Copy Release Notes
The text area below allows the project release notes to be edited and copied to another document.