Release Notes - Teiid - Version 9.1 - HTML format

Sub-task

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.