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-4916] - Ensure modules have only a single or compatible licenses
• [TEIID-4922] - Re-license other root projects
• [TEIID-5052] - Document optional dependencies
• [TEIID-5072] - Generated keys should be passed from triggers

Feature Request

• [TEIID-1131] - Document/expand sequence support
• [TEIID-4711] - Add multiple operator supports to Impala translator (case insensitive ilike, iregex, etc))
• [TEIID-4888] - Support for SetQueryLimit
• [TEIID-4964] - AWS S3 Connector
• [TEIID-4977] - Support materialization as the 8.12.x version did
• [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-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-5018] - Unable to deploy war using Quickstart: hibernate-on-top-of-teiid using "mvn package jboss-as:deploy" method
• [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-4185] - Add more documentation about Embedded
• [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

Quality Risk

• [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

Edit/Copy Release Notes

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