Release Notes - Teiid - Version 10.0 - HTML format

Quality Risk

  • [TEIID-3347] - Most subplans do not show node stats
  • [TEIID-4178] - OData and Rest wars use different conventions
  • [TEIID-4978] - Document issue with SQLAlchemy/Superset and table names containing .
  • [TEIID-4999] - Archetypes should not use Teiid packages
  • [TEIID-5003] - Deprecate BatchedCommand, use BulkCommand instead
  • [TEIID-5008] - Range checks should not use transform logic
  • [TEIID-5021] - Latest openjdk does not include anon cipher suites
  • [TEIID-5025] - Improve BufferManagerCleaner shutdown
  • [TEIID-5028] - SystemFunctions should be loaded once
  • [TEIID-5053] - Env function usage should be restricted by default
  • [TEIID-5055] - Mark more functions using the TeiidFunction annotation as pushdown eligilble

Component Upgrade

  • [TEIID-5073] - Building Salesforce adapter/translator pair issues

Enhancement

  • [TEIID-2052] - Add Problem/Resolution to query problem using the query plan
  • [TEIID-2703] - Refactor value retrieval to class based
  • [TEIID-3280] - Embedded Teiid | VDB scoped translators
  • [TEIID-3537] - Use array binding for postgresql dependent join
  • [TEIID-3738] - Add multi-tenant functionality
  • [TEIID-4099] - Improve with clause performance with incremental materialization
  • [TEIID-4452] - Pushdown SQL/XML
  • [TEIID-4498] - Generalize subquery batch processing
  • [TEIID-4567] - UCASE and LCASE functions do not work with CLOBs.
  • [TEIID-4572] - Grouping by and faceted search for Solr tranlator
  • [TEIID-4750] - Map to BigInteger in more circumstances
  • [TEIID-4790] - Support solr authentication
  • [TEIID-4904] - Add support for identify security to the infinispan connector
  • [TEIID-4918] - Enhance infinispan support for muti-threaded puts or using putAll
  • [TEIID-4941] - [RFE] Display a more informative error message when a query takes too long and times out
  • [TEIID-4943] - Allow translators to declare if copied criteria should be included
  • [TEIID-4946] - Support function SUBSTRING_INDEX in MySQL5ExecutionFactory
  • [TEIID-4956] - Support AuotFailOver on Embedded based connections
  • [TEIID-4963] - JDBC LocalProfile should not bind with jboss-modules
  • [TEIID-4992] - Add OSDQ set functions
  • [TEIID-4993] - for each row trigger forcing txn to start
  • [TEIID-4994] - For materialization, use "Ignore return values" option to improve performance
  • [TEIID-4995] - Investigate use of org.apache.poi.ss.usermodel.DataFormatter in Excel translator
  • [TEIID-5000] - Allow for importing excel timestamp columns
  • [TEIID-5002] - Use WildFly 11 Server Environment
  • [TEIID-5012] - Add the VDB description and creation timestamp information to the Sys.Virtualdatabases table as new columns (Database Description, Database Creation timestamp)
  • [TEIID-5016] - Exploit left outer join associativity prior to join planning
  • [TEIID-5017] - More aggressively use enhanced join sorted index to prevent buffering
  • [TEIID-5043] - Add an option to output plan text as yaml
  • [TEIID-5074] - Support a way provide SEQUENCE in TeiidDialect

Feature Request

  • [TEIID-219] - Add a way to limit or suppress queries that exceed a threshold Cost-Based Optimizer value
  • [TEIID-1131] - Document/expand sequence support
  • [TEIID-2894] - Add support for the row lock query(SELECT FOR UPDATE) to the source database
  • [TEIID-3157] - Allow streaming without an intermediate copy
  • [TEIID-3454] - Dependent Join optimizations for Netezza and Hive
  • [TEIID-3494] - TABLE() can execute in parallel
  • [TEIID-3868] - Add a json type with search support
  • [TEIID-4012] - Implement XA transaction support for Teiid ODBC
  • [TEIID-4356] - Add asort of connection test for "connection definitions" of resource adapters
  • [TEIID-4438] - Crate ability to filter include/exclude tables during the import across all translators
  • [TEIID-4525] - postgresql translator - remove all nulls & non printable characters
  • [TEIID-4558] - Query Plan Analyzer
  • [TEIID-4565] - Add objects table to system schema
  • [TEIID-4711] - Add multiple operator supports to Impala translator (case insensitive ilike, iregex, etc))
  • [TEIID-4760] - optional object name manipulations while executing IMPORT FOREIGN SCHEMA
  • [TEIID-4784] - Provide functionality to perform RENAME table in DDL scripts
  • [TEIID-4863] - Run teiid embedded via Spring Boot
  • [TEIID-4888] - Support for SetQueryLimit
  • [TEIID-4964] - AWS S3 Connector
  • [TEIID-4981] - Support Amazon S3 Transaltor
  • [TEIID-5013] - Google Spreadsheet Data Sources with custom client_id and client_secret
  • [TEIID-5026] - Add function to transform timestamp into Unix time

Bug

  • [TEIID-3883] - Properly project generated keys
  • [TEIID-4854] - Google translator fails to update timestamp value reformatted after update
  • [TEIID-4884] - Google spreadsheet throws Error when getting batch 401:Unauthorized
  • [TEIID-4896] - Two VDB's referencing same teiid_ispn:cache is not using the same cache
  • [TEIID-4942] - Statement batch does not enforce autoCommitTxn
  • [TEIID-4947] - Error with Salesforce translator if criteria on outer join on a custom table is from the right side table
  • [TEIID-4950] - PostgreSQL Linux ODBC driver v09.06.0100 and newer does not work with Teiid Server 9.1.1
  • [TEIID-4951] - get-schema CLI call ending up NPE
  • [TEIID-4953] - JOIN of CTEs fails if one of them is dependent and has window functions with inner DISTINCT in underlying queries
  • [TEIID-4955] - add cassandra failed message in server start up
  • [TEIID-4957] - Setting Connection Type on VDB of a Domain Managed server gets set back to default after server restart
  • [TEIID-4960] - Problems when using External Materialized Views
  • [TEIID-4961] - External Materialized View With State Loaded but 0 Cardinality
  • [TEIID-4962] - 9.3 teiid-standalone-mode-install.cli gives an error on startup
  • [TEIID-4967] - Couchbase - incorrect data returned from VIEW if one value is NULL
  • [TEIID-4968] - oids are not unique in pg_attribute
  • [TEIID-4969] - Couchbase - ORDER BY returns empty result
  • [TEIID-4970] - Couchbase - GROUP BY returns empty result
  • [TEIID-4972] - Couchbase - query with comparison criteria not properly translated
  • [TEIID-4973] - Couchbase - Teiid returns empty result if source query fails
  • [TEIID-4974] - Couchbase - TRANSLATE function is transalted as REPLACE
  • [TEIID-4975] - Couchbase - SUBSTRING function is not translated correctly
  • [TEIID-4976] - criteria duplicated when criteria includes the same columns as dependent join criteria
  • [TEIID-4980] - arche-type parent not available in maven
  • [TEIID-4982] - Wrong exception thrown getDataSource()
  • [TEIID-4983] - Couchbase tests rely on unpredictable order
  • [TEIID-4986] - Couchbase import nested array handling
  • [TEIID-4987] - SOAP12 WSDL procedure ignored during metadata import
  • [TEIID-4988] - Oracle - table alias is not used in whole query
  • [TEIID-4989] - Impala - Select * fails with reserved words in query
  • [TEIID-4990] - Embedded Teiid with JPA layer Transaction Management detection
  • [TEIID-4996] - Teiid embedded with Solr (exception max boolean clauses)
  • [TEIID-5001] - TextTable usage in UNION/UNION ALL queries with JOINs fails with "No value was available" or NPE errors
  • [TEIID-5004] - INNER JOINs of two CTEs fail with ASSERTION FAILED error message
  • [TEIID-5005] - Boolean expression is incorrectly rewritten in WHERE condition and causes errors on PG
  • [TEIID-5006] - NPE when querying RAR description of infinispan-hotrod resource adapter
  • [TEIID-5014] - Unable to use parameterized query with node pg module and Teiid/JBoss VDB
  • [TEIID-5019] - Makedep hint using @ syntax sometimes ignored
  • [TEIID-5020] - Join query results in NullPointerException
  • [TEIID-5024] - Embedded soapservice fails with cxf jaxb class not found
  • [TEIID-5027] - Translator infinispan-hotrod incorrect data type import
  • [TEIID-5029] - Regression with outer join optimization
  • [TEIID-5030] - Couchbase error in date/timestamp/time datatype pushdown
  • [TEIID-5031] - Couchbase issues in functions where result is different datatype than the argument
  • [TEIID-5033] - Couchbase substring function is 0-based
  • [TEIID-5035] - Couchbase INTERSECT doesn't return any values
  • [TEIID-5036] - Couchbase EXCEPT returns more values than expected
  • [TEIID-5037] - Couchbase UNION doesn't work correctly
  • [TEIID-5039] - Couchbase document type definition for a table
  • [TEIID-5042] - Couchbase supported data types restriction issues
  • [TEIID-5044] - Using "SHOW PLAN" statement only shows initial plan
  • [TEIID-5045] - Rewriter allows "true" criteria to be modified
  • [TEIID-5046] - DuplicateRecordException when adding some tables with dots in columns
  • [TEIID-5048] - Docs updatable views
  • [TEIID-5050] - CLOB instead of STRING
  • [TEIID-5051] - UUID translating
  • [TEIID-5054] - autoFailover with a multi-batch result timing issue
  • [TEIID-5056] - Infinispan Hotrod error on DDL metadata change
  • [TEIID-5057] - Infinispan Hotrod error when '-' in Source model name
  • [TEIID-5058] - Infinispan Hotrod VDB needs to be redeployed after JDG restart
  • [TEIID-5059] - CacheEntry memory leak due to issues with touch method
  • [TEIID-5060] - Infinispan Hotrod Translator UPDATE on primary key column
  • [TEIID-5062] - Infinispan Hotrod Translator NPE for DELETE with WHERE clause on a view
  • [TEIID-5063] - Issues with bigdecimal values and odata
  • [TEIID-5064] - Update olingo version to the 4.4
  • [TEIID-5065] - Unable to connect to VDB having names with unicode characters
  • [TEIID-5067] - Incorrect source query with simple inherent updates
  • [TEIID-5068] - Couchbase retrieval causes ClassCastException
  • [TEIID-5069] - Blob getBytes() handling of input streams reads the stream multiple times without a reset
  • [TEIID-5071] - Teiid designer Odata4 model import fails to load metadata and throws java.lang.NullPointerException

Task

  • [TEIID-4474] - Re-license under a more permissive license
  • [TEIID-4500] - Make documents to capable of building outside the GitBooks
  • [TEIID-4781] - upgrade MongoDB Java Driver
  • [TEIID-4894] - Remove xml document models
  • [TEIID-4910] - Update build to utilize a maven docker plugin
  • [TEIID-4944] - Remove misc deprecated code
  • [TEIID-4952] - release notes is not having tokens replaced

Sub-task

  • [TEIID-4208] - Increase plan parallelism
  • [TEIID-4536] - Support create schema with multiple statements
  • [TEIID-4540] - Make admin methods the same for ddl vdbs
  • [TEIID-4577] - Upgrade CXF to 3.1.8, which resolves password obfuscation issue
  • [TEIID-4911] - Teiid embedded support Spring boot
  • [TEIID-4916] - Ensure modules have only a single or compatible licenses
  • [TEIID-4922] - Re-license other root projects
  • [TEIID-4924] - Push Teiid artifacts to maven central
  • [TEIID-4929] - Add a User Guide for teiid spring boot starter
  • [TEIID-4939] - Enhance translator auto-detect and ddl deployment
  • [TEIID-4940] - Create a sample to demonstrate use Spring datasource and transaction manager
  • [TEIID-5052] - Document optional dependencies
  • [TEIID-5072] - Generated keys should be passed from triggers

Edit/Copy Release Notes

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