Sub-task
- [TEIID-4228] - ODBC "Parse Statements" option can result in changes in LENGTH metadata for columns
- [TEIID-4376] - EXECUTE IMMEDIATE should accept clob
- [TEIID-4378] - Support clob concat
- [TEIID-4390] - Expand level support
- [TEIID-4392] - Expand star support
- [TEIID-4397] - Allow $it to be used in expand
- [TEIID-4399] - Remove $levels restrictions
- [TEIID-4403] - Refine array_agg support
Feature Request
- [TEIID-2289] - Create quickstart to demonstrate using Hive/Hadoop
- [TEIID-4100] - Full odata expand support
- [TEIID-4191] - Add a NOQUOTE option for the TEXTAGG function
- [TEIID-4200] - Provide support for Wildfly 10
- [TEIID-4227] - Impala Translator - Support Multiple Count Distinct with Group By
- [TEIID-4245] - Add support for fetch syntax "FETCH cursorname"
- [TEIID-4247] - OData - support date and time functions
- [TEIID-4289] - Add transaction command support for syntax BEGIN/ROLLBACK/COMMIT WORK
- [TEIID-4296] - File translator cannot find a file without an extensioin
- [TEIID-4323] - Add support for first/last/absolute/relative "FETCH " syntax
- [TEIID-4341] - Provide arche-type for creating a PreParser
- [TEIID-4393] - Add new Geospatial functions
- [TEIID-4394] - Impala Translator - add pushdown support for window functions
- [TEIID-4404] - Add a maven plugin which can start, stop teiid serrver
- [TEIID-4421] - Teiid Translator per source/version
- [TEIID-4422] - Impala Translator - add pushdown support for concat and concat_ws functions
- [TEIID-4440] - Add an option to materialize common tables
- [TEIID-4444] - Add a built-in delegating translator that allows overriding all supports
- [TEIID-4490] - Insert with multiple values doesn't allow subqueries
Bug
- [TEIID-3771] - Teiid throws an NPE while executing query with nested subquery IN predicate
- [TEIID-4129] - Wrong results with cross model join on 2 varchar fields
- [TEIID-4183] - MSSQL JDBC driver invalidates kerberos ticket on Connection.close()
- [TEIID-4243] - Use BatchUpdateException
- [TEIID-4256] - Hive translator - types in IN predicate should be of same type
- [TEIID-4263] - StringToTimestamp in convert fails during DST transition hour
- [TEIID-4269] - numeric calculated fields not displayed with odata4
- [TEIID-4272] - NPE when CTE and subuquery without a WITH clause are pushed together
- [TEIID-4273] - With clause used in evaluatable subquery in a fully pushed user query is seen as missing temp table
- [TEIID-4274] - FunctionMethods don't set datatypes
- [TEIID-4276] - Default for max sessions not consistently updated
- [TEIID-4277] - Infinispan Cache DSL translator: materialization incomplete results during view's loading
- [TEIID-4279] - Text Based LoginModule does not find properties files
- [TEIID-4280] - NPE in RuleMergeVirtual when running a query with nested CTEs
- [TEIID-4283] - External Materialization interleaving loads SYSADMIN.loadMatView
- [TEIID-4286] - Edit documentation about system function ENV()
- [TEIID-4287] - An exception is thrown by PostgreSQL when nested CTEs are pushed down
- [TEIID-4288] - Cancel method against a socket based jdbc query can wait for synch timeout
- [TEIID-4290] - Rollback to savepoint should be a no op
- [TEIID-4291] - Object translator does not take into account folders where determining table name
- [TEIID-4292] - VDB file extention must be all lowercase
- [TEIID-4299] - Object translator null values correctly
- [TEIID-4304] - Correct handling with subquery in on clause
- [TEIID-4305] - message key overrode for TEIID-3811
- [TEIID-4309] - loadMatView getting the row count may not be correct
- [TEIID-4310] - Sessions can not be shown in web-console runtime sub-panel
- [TEIID-4311] - Teiid Admin Api not support to create XA datasource on Jboss server.
- [TEIID-4312] - INNER and LEFT joins of CTEs fail or return incorrect results
- [TEIID-4317] - Always init translator capabilities
- [TEIID-4320] - Costing calculation issues
- [TEIID-4321] - VDB Validation is showing warnings, but failing deployment
- [TEIID-4324] - TEIID30019 Unexpected exception for request ... java.lang.AssertionError: Batch not found in storage
- [TEIID-4325] - ASSERTION FAILED: expected reference to be not null
- [TEIID-4326] - Swagger translator bugs and enhancement request
- [TEIID-4329] - Using JDG annotations, unable to provide package name qualification for serialization
- [TEIID-4330] - Better planning with chained makedep scenarios
- [TEIID-4331] - Use of st_geomfromText wrapped around a UDF fails.
- [TEIID-4334] - Prepared insert resolving failure with implicitly named temp table
- [TEIID-4335] - No buffer when close is called
- [TEIID-4337] - External materialization status table's PK too long for MySQL InnoDB
- [TEIID-4338] - Hana and Vertica should be marked as requiring a source
- [TEIID-4339] - Hot Rod ExecutionFactory name misspelled
- [TEIID-4342] - loadMatView afterLoadScript error when calling a function
- [TEIID-4343] - Impala Translator - With Clause Support
- [TEIID-4344] - OData static context - if resource does not exist then Teiid throws NPE and returns empty page
- [TEIID-4351] - JDG: Does not support 1-to-1 relationship
- [TEIID-4354] - patch to CXF no longer needed with new version of the CXF in 9.0 series.
- [TEIID-4359] - Salesforce importer needs to mark createable fields as updateable
- [TEIID-4360] - default token type needs to be "bearer" for OAuth2 access code negotiation
- [TEIID-4362] - OData V4 - replace '+' with spaces in sample URLs in documentation
- [TEIID-4367] - Fail to deploy VDB with TextTable SELECTOR
- [TEIID-4372] - Impala AVG returns double when bigdecimal is expected
- [TEIID-4374] - Procedure missing for an OData metadata request to a Swagger VDB
- [TEIID-4377] - Blob/clob start index message incorrect
- [TEIID-4380] - ODatat 4 deep insert works for only a single expand
- [TEIID-4381] - OData expand with count and top=0 returns all children
- [TEIID-4382] - array_agg does not properly handle array values
- [TEIID-4384] - Issue with ordered offset
- [TEIID-4385] - Nested subquery in an aggregate fails to evaluate
- [TEIID-4387] - Issues with $it support
- [TEIID-4389] - Local connection waits for active VDB 1,000,000 times longer than specified in waitForLoad property
- [TEIID-4391] - NONDETERMINISTIC functions incorrectly optimized out of ORDER BY
- [TEIID-4396] - Missing images in the Admin section of the documentation
- [TEIID-4402] - Insert statement with a date field fails
- [TEIID-4405] - delete using in statement does not remove records from temporary table
- [TEIID-4406] - group by cast(... as date) results in NullPointException
- [TEIID-4407] - Salesforce delete/update without a predicate does nothing
- [TEIID-4408] - Salesforce delete/update doesn't affect more than a single batch
- [TEIID-4410] - ConnectorWorkItem setting of convertIn should be based upon the execution factory
- [TEIID-4411] - With clauses in subqueries that appear in inline views should be pulled up
- [TEIID-4417] - Issues with OData query generation logic
- [TEIID-4418] - Pushdown of a correlated with clause contains wrong correlated reference
- [TEIID-4423] - UPDATE command with non-pushdown functions leads to TEIID30253 error
- [TEIID-4424] - Error when factory overrides initCapabilities due WrappedConnection is what Teiid is passing
- [TEIID-4426] - Teiid modules have invalid module descriptor (module.xml)
- [TEIID-4432] - HSQL translator should advertise that a connection is needed for capabilities
- [TEIID-4434] - Results returned by google spreadhseet may have columns missing labels, preventing the VDB to load
- [TEIID-4435] - HIVE: decimal datatype is treated like a string
- [TEIID-4436] - TEIID11008:PSQLException-ERROR: missing FROM-clause entry for table "anon_grp0" running a query with GROUP BY and UNION ALL
- [TEIID-4439] - salesforce-34 translator dependencies issues
- [TEIID-4443] - STRING_AGG should not be decomposable
- [TEIID-4448] - Multi-way join predicate inappropriately removed
- [TEIID-4451] - Teradata translator - Unable to evaluate SUM(B.LongNum) in subquery
- [TEIID-4457] - Impala/Hive pushdown function definitions
- [TEIID-4460] - A view field defined as clob, on a google spreadsheeet model, returns data truncated to string type length
- [TEIID-4463] - No results with cross source outer join and offset only
- [TEIID-4465] - Update google ra config
- [TEIID-4466] - Inconsistent synchronization around odbc sync handling
- [TEIID-4468] - Google translator evaluates 0 as not NULL for operator <>
- [TEIID-4469] - Insert with query expression does not apply source hint to target
- [TEIID-4471] - Assertion error with temp table delete
- [TEIID-4473] - Google translator string empty cell is evaluated as NULL
- [TEIID-4477] - LDAP connector disconnects intermittently with error "TEIID12002"
- [TEIID-4478] - The 1-to-1 relationship currently doesn't work and doesn't error either
- [TEIID-4482] - Not null not enforced with temp table expression
- [TEIID-4483] - Not null constraint is not checked on temp table update
- [TEIID-4484] - Random test failure with cancelled query
- [TEIID-4485] - import-vdb VDB name case-sensitive
- [TEIID-4487] - NPE if using multi-value prepared INSERT
- [TEIID-4494] - Differentiate requests pending close
- [TEIID-4495] - Salesforce - unable to use CXF configuration with version 34
- [TEIID-4507] - Array index out of bounds exception with anon procedure and update count
- [TEIID-4508] - DDL procedure update count not handled correctly
- [TEIID-4511] - st_Intersection not implemented
Task
- [TEIID-3754] - Remove OData V2 implementation of the Server
- [TEIID-3940] - Add an embedded example around continuous queries
- [TEIID-4264] - PI: Verify the connectivity with PI Server
- [TEIID-4266] - Convert the Teiid examples to gitbook
- [TEIID-4268] - Add OAuth JWT documentation
- [TEIID-4322] - Add embedded quickstart using sockets
- [TEIID-4400] - Deprecate XML Document Models
- [TEIID-4416] - Remove references to -ds.xml from docs
- [TEIID-4430] - Update the Olingo library to 4.3
- [TEIID-4433] - Google gdata dependency needs to be in its own module
- [TEIID-4458] - Provide Maven configuration for all artifacts on Downloads page
- [TEIID-4462] - Document Salesforce extension metadata
- [TEIID-4496] - Add more explicit documentation about out of memory handlng
Quality Risk
- [TEIID-3329] - Rationalize older spatial support with the new
- [TEIID-3600] - DB2 - error getting substring if "from position" is out of range
- [TEIID-4257] - Nesting join parens cause H2 performance issue
- [TEIID-4267] - Add units into the cli description of transport property "authentication-sessions-expiration-timelimit"
- [TEIID-4281] - MySQL translator should warn about useCursorFetch
- [TEIID-4306] - xa datasource create cli not work due to datasource change in wildfly 10
- [TEIID-4313] - use consistent ordering for group collectors
- [TEIID-4332] - Enhance costing to better guess at ndv
- [TEIID-4346] - Remove excel-odbc translator
- [TEIID-4373] - Resolving invalid hosts may take a long time in tests
- [TEIID-4379] - OData entity row created twice
- [TEIID-4420] - AccessNode should display subplans in plan
- [TEIID-4442] - Remove option to allow for multiple security domains
- [TEIID-4446] - Rationalize precision/scale
- [TEIID-4450] - Consolidate Version class
- [TEIID-4459] - Convert project semi-joins to (dependent) join queries
- [TEIID-4461] - Salesforce translator - foreign tables does not support query statements by default
- [TEIID-4480] - Change the default log level for command_log in the community kit to warn
- [TEIID-4486] - Improve performance of st_extent
- [TEIID-4488] - Add a more localized way to set the default escape
- [TEIID-4491] - Refine uniqueidentifier support for SQL Server
- [TEIID-4502] - Remove references to deprecated UseConnectorMetadata in docs/examples
Enhancement
- [TEIID-2715] - Extension metadata is not visible when queried through OData
- [TEIID-3630] - Support merge statement pushdown
- [TEIID-3801] - Upgrade Infinispan translator to support 6.4.x version (JDG 6.6)
- [TEIID-4000] - Better handling for large bulk inserts
- [TEIID-4021] - MSSQL Pagination
- [TEIID-4187] - Extend support for PI OLEDB Enterprise Queries in OSI PI Translator
- [TEIID-4225] - HANA translator : DAYNAME function is not pushed
- [TEIID-4238] - Remove need for quotes around cursor name declarations/fetches
- [TEIID-4275] - No NIS is setup for the Procedure parameters during the JDBC metadata import
- [TEIID-4278] - MySQL 5 should support distinct aggregates
- [TEIID-4293] - Some Management CLI should setAllowedValues
- [TEIID-4297] - Add UDF functions based on OSDQ for POC
- [TEIID-4307] - Infinispan DSL Translator: Can't execute update when foreign table name differs from POJO's simple name
- [TEIID-4314] - Add DeleteFile call to File Translator
- [TEIID-4319] - Deprecate automatically adding of the class object to the source table
- [TEIID-4333] - Change default of SupportsComapareCriteriaOrdered to true
- [TEIID-4357] - Add documentation on exposing Teiid as a GeoServer data source
- [TEIID-4358] - JDG: Retain supported dependencies in the module.xml for out-of-the-box usage
- [TEIID-4366] - Provide CORS support on OData Service
- [TEIID-4395] - Oracle translator should pushdown clob conversion
- [TEIID-4409] - Change infinispan translators to determine if annotations are used to configure JDG by using connection
- [TEIID-4419] - Allow pre-evaluation of uncorrelated scalar subqueries in more circumstances
- [TEIID-4449] - Allow limited replanning of subplans that use only common tables
- [TEIID-4456] - Enable the abiltiy to support nested and non-nested message descriptors
Edit/Copy Release Notes
The text area below allows the project release notes to be edited and copied to another document.