Release Notes - Teiid - Version 10.0 - HTML format

Quality Risk

  • [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
  • [TEIID-5078] - Expand docs on CXF logging
  • [TEIID-5103] - ManagedConnectionFactory hashCode/equals
  • [TEIID-5106] - Tables names are case sensitive in Postgres/Oracle/MSSQL but not in Teiid.
  • [TEIID-5111] - Teiid Designer uses 0 as a default length value
  • [TEIID-5114] - Correct JDBCMetdataProcessor name
  • [TEIID-5130] - Document/refine behavior of treating result parameter as the first parameter

Component Upgrade

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

Enhancement

  • [TEIID-4099] - Improve with clause performance
  • [TEIID-4567] - UCASE and LCASE functions do not work with CLOBs.
  • [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] - Minimize creating redundant copied predicates
  • [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-4984] - Support for netezza pushdown 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
  • [TEIID-5086] - Couchbase translator enable configuration of query consistency level

Feature Request

  • [TEIID-1131] - Document/expand sequence support
  • [TEIID-4711] - Add multiple operator supports to Impala translator (case insensitive ilike, iregex, etc))
  • [TEIID-4784] - Provide functionality to perform RENAME table in DDL scripts
  • [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
  • [TEIID-5099] - Add facility for passing header values in @JsonTable
  • [TEIID-5100] - Provide facility for HTTP method in @jsonTable annotation

Bug

  • [TEIID-3883] - Properly project generated keys
  • [TEIID-4854] - Google translator fails to update timestamp value reformatted after update
  • [TEIID-4860] - OData4 swallowing exception message
  • [TEIID-4870] - Google translator unexpected behavior for view update without trigger
  • [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-5041] - Couchbase documentID column enforced also in a view
  • [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
  • [TEIID-5075] - Couchbase incorrect update count returned
  • [TEIID-5076] - Couchbase update syntax error
  • [TEIID-5077] - Couchbase strange behaviour for long numbers
  • [TEIID-5079] - Salesforce issues
  • [TEIID-5081] - FORMATTIMESTAMP is not pushed down to postgresql but formattimestamp is
  • [TEIID-5082] - Salesforce default URL incorrect
  • [TEIID-5085] - NullPointerException after SortUtility blocks in initialSort
  • [TEIID-5088] - Infinispan Hotrod bigdecimal/biginteger compared as strings
  • [TEIID-5089] - Using Teiid Conn. importer in Designer, the cache name is set to "default"
  • [TEIID-5090] - Issues with matview scripts
  • [TEIID-5092] - Joining tables from S3 occasionaly fails with NumberFormatException
  • [TEIID-5093] - Amazon s3 csv/xml lookup querry exception
  • [TEIID-5094] - Is DISTINCT FROM evaluation with two null values
  • [TEIID-5098] - Unsyncronized static date format for Salesforce bulk inserts
  • [TEIID-5104] - BigInteger mapped to string for OData 4
  • [TEIID-5107] - teiid-olingo-*.war not deploying in wildfly when using domain
  • [TEIID-5109] - Set operations and parenthesis
  • [TEIID-5116] - Osisoft Translator - NULL values in numeric columns returned as zeroes
  • [TEIID-5117] - Osisoft Translator - Casting to bigdecimal results in NULL value
  • [TEIID-5118] - Osisoft Translator - NPE when using ORDER BY
  • [TEIID-5119] - Osisoft Translator - Teiid pushes cast from Timestamp to Time
  • [TEIID-5120] - Osisoft Translator - Wrong pushdown of LENGTH function
  • [TEIID-5121] - Streaming lob exception with shared tuple source
  • [TEIID-5128] - transaction support value not cloned on access node
  • [TEIID-5133] - XmlTable path language is not always identical to XPathValue expressions

Task

  • [TEIID-4474] - Re-license under a more permissive license
  • [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-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.