-
Notifications
You must be signed in to change notification settings - Fork 228
/
teiid-releasenotes.html
305 lines (275 loc) · 36.9 KB
/
teiid-releasenotes.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=utf-8">
<TITLE>Teiid ${project.version} Release Notes</TITLE>
</HEAD>
<BODY LANG="en-US" DIR="LTR">
<P><A HREF="http://www.teiid.org/"><IMG SRC="https://www.jboss.org/dms/teiid/images/teiid-banner.png" NAME="graphics1" ALT="Teiid" ALIGN=BOTTOM WIDTH=800></A>
<H1>Teiid ${project.version} Release Notes</H1>
<P>Teiid ${project.version} adds performance features, microservice enablement, the upgrade to WildFly 11, and removes legacy features.
<H2>Overview</H2>
<UL>
<LI><A HREF="#Highlights">Highlights</A>
<LI><A HREF="#Compatibility">Compatibility Issues</A>
<LI><A HREF="#Configuration">Configuration Issues</A>
<LI><A HREF="#Other">Other Issues</A>
<LI><A HREF="#LibraryUpdates">Thirdparty Library Updates</A>
<LI><A HREF="#Details">Detailed Release Notes</A>
<LI><A HREF="#Documentation">Additional Docs and Help</A>
<LI><A HREF="#Licenses">Licenses</A>
<LI><A HREF="#About">About JBoss</A>
</UL>
<H2><A NAME="Highlights"></A>Highlights</H2>
<ul>
<li><a href="https://issues.jboss.org/browse/TEIID-4981">TEIID-4981</a> Amazon S3 translator support, now read the objects directly from Amazon S3 with security</li>
<li><a href="https://issues.jboss.org/browse/TEIID-5026">TEIID-5026</a> The behavior of the FROM_UNIXTIME function was corrected and the related datetime functions UNIX_TIMESTAMP, TO_MILLIS, and FROM_MILLIS were added.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-1131">TEIID-1131</a> Added support for importing sequence information.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-5073">TEIID-5073</a> Added a salesforce-41 translator/resource adapter pair, which defaults to accessing the v40 salesforce API.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4208">TEIID-4208</a> Added parallelism to plan execution involving large sorts.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-5002">TEIID-5002</a> Upgraded to WildFly 11</li>
</ul>
<h2><a name="Compatibility">Compatibility Issues</a></h2>
<ul>
<li>Support for named parameter syntax using param=value has been deprecated, since it is ambiguous with a comparison predicate boolean value expression. param<b>=></b>value should be used instead.
<li>decodeinteger/decodestring have been deprecated. A CASE expression should be used instead.
<li><a href="https://issues.jboss.org/browse/TEIID-3159">TEIID-3159</a> The SAP Netweaver Gateway translator (sap-nw-gateway) has been renamed to just SAP Gateway (sap-gateway). Usage of sap-nw-gateway is deprecated.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4205">TEIID-4205</a> By default, the wrapping begin/commit of a UseDeclareFetch cursor will be ignored as Teiid does not require a transaction. Set the org.teiid.honorDeclareFetchTxn system property to false to revert to the old behavior which honored the transaction.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4240">TEIID-4240</a> The usage of ; delimited statements for materialization scripts has been deprecated. An anonymous procedure block should be used instead if multiple statements are needed.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4228">TEIID-4228</a> Precision and scale values greater than 32767 are deprecated.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4228">TEIID-4228</a> Not using a semicolon delimiter between statements is deprecated and should only be relied on for backwards compatibility.
<li><a href="https://issues.jboss.org/browse/TEIID-4731">TEIID-4731</a> The default authentication scheme for MongoDB resource adapter has been changed to SCRAM_SHA_1 to match with latest versions of MongoDB. If using MongoDB version less than 3.0, to restore previous functionality change/add SecurityType to 'None' in the resource adapter configuration.
</ul>
<h4>from 9.3</h4>
<ul>
<li><a href="https://issues.jboss.org/browse/TEIID-4894">TEIID-4894</a> The XML document model feature has been removed. You must use OData or SQL/XML to create XML documents.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4924">TEIID-4924</a> Maven coordinates for Teiid artifacts have changed. They will now be pushed directly to Maven Central and will use the org.teiid group instead of org.jboss.teiid.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-5026">TEIID-5026</a> The FROM_UNIXTIME function now returns a string rather than a timestamp value and no longer is rewritten to the timestampadd function. The functionality now matches that of HIVE/IMPALA. See also the to_millis and from_millis functions.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-5012">TEIID-5012</a> A Description column was added to SYS.VirtualDatabases. </li>
</ul>
<h4>from 9.2</h4>
<ul>
<li><a href="https://issues.jboss.org/browse/TEIID-3624">TEIID-3624</a> The introduction of domain types modified several of the system tables. The isPhysical column was removed from the SYS.Datatypes table.
SYS.Datatypes added Type, TypeCode, Literal_Prefix, and Literal_Suffix columns. The SYS.Columns, SYS.ProcedureParams, and SYS.FunctionParams tables added TypeName, TypeCode, and ColumnSize columns.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4827">TEIID-4827</a> Java 1.8 is now required for building and running Teiid.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4890">TEIID-4890</a> The ProcedureParameters system table will report return parameters as position 0.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4866">TEIID-4866</a> For usability with SQLAlchemy and Superset the version() function over ODBC will report ""PostgreSQL 8.2" rather than "Teiid version". You can use the system property org.teiid.pgVersion to control this further.</li>
</ul>
<h4>from 9.1</h4>
<ul>
<li><a href="https://issues.jboss.org/browse/TEIID-4574">TEIID-4574</a> Phoenix/Hbase Translator has been renamed phoenix and the usage of the HBaseExecutionFactory and the hbase translator name has been deprecated.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4501">TEIID-4501</a> The salesforce-34 resource adapter defaults to the version 34 api rather than version 22 api.</li>
</ul>
<h4>from 9.0</h4>
<ul>
<li><a href="https://issues.jboss.org/browse/TEIID-3754">TEIID-3754</a> OData Version 2 support is removed. Please use OData V4. Note that there are many changes in specification with V4 vs V2.
<li><a href="https://issues.jboss.org/browse/TEIID-4400">TEIID-4400</a> XML Document Models have been deprecated. OData or SQL/XML should be used instead.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4317">TEIID-4317</a> ExecutionFactory.initCapabilities will always be called - either during start if isSourceRequiredForCapabilities returns false, or later if true.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4346">TEIID-4346</a> The excel-odbc translator has been removed. Please use the excel translator instead.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4332">TEIID-4332</a> Due to costing logic changes plans may be different that in previous releases. Please raise an issue is you feel a plan is not appropriate.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4421">TEIID-4421</a> Removed the deprecated EmbeddedServer.addTranslator(ExecutionFactory) method.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4442">TEIID-4442</a> Removed the interpretation of the security-domain setting for the session service as a comma separated list of domains. Also added the USER(boolean) function to control
if the USER function returns a name with the security domain. Finally the DatabaseMetaData and CommandContext getUserName will both return the simple user name without the domain.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4228">TEIID-4228</a> Precision/scale will now be set consistently. Values reported from JDBC/OData/ODBC metadata may be different if your current metadata declares a bigdecimal type with default precision.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4423">TEIID-4423</a> Uncorrelated subqueries will be treated as deterministic regardless of functions used within them. Prior releases treated most uncorrelated subqueries as non-deterministic if they contained a non-deterministic function.</li>
</ul>
<h4>from 8.x</h4>
<ul>
<li><a href="https://issues.jboss.org/browse/TEIID-2694">TEIID-2694</a> In the autogenerated web service, if a procedure is designed for POST method, and one of its IN/INOUT parameters is either a LOB or VARBINARY then that service can only invoked using "multipart/form-data". This allows user to send large binary files for processing in Teiid</li>
<li><a href="https://issues.jboss.org/browse/TEIID-3462">TEIID-3462</a> Semantic versioning requires the VDB version to be a string, rather than an integer field. This affects several public classes including CommandLogMessage, VDB, Session, EventListener, VDBImport, ExecutionContext, and MetadataRepository. Any custom command logging or materialization status tables will need the version field updated as well.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4147">TEIID-4147</a> ODBC type handling will now report the type name as the PostgreSQL type rather than the Teiid type.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-3601">TEIID-3601</a> changed the rowCount field on CommandLogMessages from Integer to Long.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-3752">TEIID-3752</a> the admin assignToModel method was removed</li>
<li><a href="https://issues.jboss.org/browse/TEIID-3684">TEIID-3684</a> RoleBasedCredentialMapIdentityLoginModule removed, consider using alternative login modules with roles to restrict access to VDB</li>
<li><a href="https://issues.jboss.org/browse/TEIID-2476">TEIID-2476</a> The AuthorizationValidator and PolicyDecider interfaces had minor changes - see their javadocs for new/altered methods</li>
<li><a href="https://issues.jboss.org/browse/TEIID-3503">TEIID-3503</a> To better isolate dependencies a separate teiid-jboss-admin jar was created from classes in teiid-admin - most notably AdminFactory was moved there.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4206">TEIID-4206</a> TranslatorProperty annotations on methods without setters must have the readOnly attribute as true.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-3814">TEIID-3814</a> In the autogenerated web service, the model name in the path is now case sensitive.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-2267">TEIID-2267</a> The custom appenders for command and audit logging has been changed, now they need to be developed for java.util.logging based Handler.
<li><a href="https://issues.jboss.org/browse/TEIID-3553">TEIID-3553</a> Ambiguous OData v2 entity set and function names will throw an exception rather than resolving to the first found.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-3515">TEIID-3515</a> MAKEIND was added as a reserved word.
<li><a href="https://issues.jboss.org/browse/TEIID-3576">TEIID-3576</a> the waitForLoad connection property has been deprecated.
<li><a href="https://issues.jboss.org/browse/TEIID-2813">TEIID-2813</a> a source end event will be sent to the command log when an error occurs rather than being omitted.
<li><a href="https://issues.jboss.org/browse/TEIID-3736">TEIID-3736</a> string literals values matching the date format can be directly resolved as timestamps.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-3727">TEIID-3727</a> The version 22 salesforce translator and resource adapter have been deprecated.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-3380">TEIID-3380</a>/<a href="https://issues.jboss.org/browse/TEIID-3663">TEIID-3663</a> The SecurityHelper interface has changed to allow for easier control over GSS authentication
<li><a href="https://issues.jboss.org/browse/TEIID-3372">TEIID-3372</a> DDL and DDL-FILE metadata repositories have deprecating using the respective ddl and ddl-file model properties.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-3390">TEIID-3390</a> temporary lobs are now cleaned up when the result set is closed - even for local connections.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-3210">TEIID-3210</a> Added supportsCompareCriteriaOrderedExclusive, which defaults to supportsCompareCriteriaOrdered, to specifically support < and > pushdown.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-3282">TEIID-3282</a> Changed the WEEK function to compute the ISO 8601 by default (org.teiid.iso8601Week=true) and ensured pushdowns do the same. Changed the dayOfWeek function to be unaffected by the iso8601Week setting.
<li><a href="https://issues.jboss.org/browse/TEIID-2904">TEIID-2904</a> The createMetadataProcessor method on JDBCExcutionFactory has been deprecated. Use getMetadataProcessor instead.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-2793">TEIID-2793</a> Searchability metadata will not prevent more complicated expressions from being pushed down.
<li><a href="https://issues.jboss.org/browse/TEIID-2794">TEIID-2794</a> Schema scoped functions are checked for ambiguity. Schema qualification may be needed to resolve properly.
<li><a href="https://issues.jboss.org/browse/TEIID-2840">TEIID-2840</a> Internal materialized view ttl refresh is now blocking by default. To keep the old behavior of lazy invalidation, use the vdb property lazy-invalidation=true
<li><a href="https://issues.jboss.org/browse/TEIID-2667">TEIID-2667</a> The jdbc importer importKeys parameter is now correctly defaulted to true.
<li><a href="https://issues.jboss.org/browse/TEIID-2737">TEIID-2737</a> The 'native' procedure exposed by translators has been renames as the direct query feature. The related ExecutionFactory methods supportsNativeQueries and nativeQueryProcedure name have been deprecated and replaced with supportsDirectQueryProcedure and directQueryProcedureName.
<li><a href="https://issues.jboss.org/browse/TEIID-2580">TEIID-2580</a> Both xpathValue and XMLTABLE will return null when retrieving the value for a single element marked with xis:nil="true".
<li><a href="https://issues.jboss.org/browse/TEIID-2590">TEIID-2590</a> Both the source specific and the general hint if present will be included as the source hint for Oracle.
<li><a href="https://issues.jboss.org/browse/TEIID-2603">TEIID-2603</a> TableStats and ColumnStats numeric values are held as Number, rather than Integer.
<li><a href="https://issues.jboss.org/browse/TEIID-2613">TEIID-2613</a> The rowcount is reset to 0 after a non-update command statement is issued.
<li><a href="https://issues.jboss.org/browse/TEIID-2422">TEIID-2422</a> using calendar based timestampdiff by default. See the Admin Guide for using the org.teiid.calendarTimestampDiff to control backwards compatibility.
<li><a href="https://issues.jboss.org/browse/TEIID-2477">TEIID-2477</a> Most of the JDBC translator static String version constants were replaced by org.teiid.translator.jdbc.Version constants. Use the .toString() method to obtain a version string if needed.
<li><a href="https://issues.jboss.org/browse/TEIID-2344">TEIID-2344</a> non-available JDBC sources in partial results mode or source with connection factories that require an ExecutionContext to obtain a connection will require manual setting of the database version metadata property. The affected sources are: db2, derby, oracle, postgresql, sqlserver, sybase, teiid
<li><a href="https://issues.jboss.org/browse/TEIID-2444">TEIID-2444</a> The deployment platform for Teiid has been changed to EAP 6.1.Alpha1, older or non-EAP deployments are not supported.
<li><a href="https://issues.jboss.org/browse/TEIID-2429">TEIID-2429</a> Sorts over data sets over a single batch are not guaranteed to be sorted in a stable manor to improve performance. The sort will still be correct with respect to the sort keys.
<li><a href="https://issues.jboss.org/browse/TEIID-1979">TEIID-1979</a> The resource adaptors are now deployed through modules, and have shorter names as identifiers. Connection Factories created with previous versions must be re-configured.
<li><a href="https://issues.jboss.org/browse/TEIID-2253">TEIID-2253</a> the multi-source implementation logic was significantly altered the following changes were introduced.
<ul>
<li>If not auto-populated, the multi-source column acts as a pseudo-column and will not be selectable via a wildcard SELECT * nor tbl.*
<li>Multi-source inserts must specify a single source as their target.
<li>The join planning behavior in multi-source mode was not consistent and did not work in all situations. To ensure consistency multi-source tables being joined together should specify a join predicate on the source name column - i.e. tbl1.source_name = tbl2.source_name.
For backwards compatibility a the system property org.teiid.implicitMultiSourceJoin was introduced to control whether multi-source joins are effectively partitioned by source without a source_name predicate. The property defaults to true, the pre 8.3 behavior - but should be
switched to false for later versions unless the issues with implicit join planning are addressed.
</ul>
<li><a href="https://issues.jboss.org/browse/TEIID-2317">TEIID-2317</a> byte[] char[] and java.util.Date instances returned as object values will be left in tact and not automatically converted to BinaryType, ClobType, and Timestamp respectively. The values may still be cast to those types.
<li><a href="https://issues.jboss.org/browse/TEIID-2149">TEIID-2149</a> the subqueryUnnestDefault property no longer influences cost based decisions to treat subqueries as merge joins. In nearly all circumstances this is desirable, but may require the use of nounnest hint to prevent forming the join if desired.
<li><a href="https://issues.jboss.org/browse/TEIID-2166">TEIID-2166</a> array_get will return null if the index is out of bounds rather than raising an error.
<li><a href="https://issues.jboss.org/browse/TEIID-2175">TEIID-2175</a> for 8.0 and 8.1 clients the server will check if serialized date/time values fall outside of 32-bit value ranges (year 1900 - 9999 for dates and times between years 1901 and 2038) and throw an exception. The previous behavior was
to truncate. The exception and the use of 32 bit serialization can be avoided by setting the system property org.teiid.longDatesTimes to true.
<li><a href="https://issues.jboss.org/browse/TEIID-2184">TEIID-2184</a> to be consistent with the rest of Teiid's logic the system functions dayName and monthName will return values from the default locale, rather than only the English names. Use the system property org.teiid.enDateNames true to revert to the pre-8.2 behavior.
<li><a href="https://issues.jboss.org/browse/TEIID-2187">TEIID-2187</a> the CONSTRAINT keyword is not correctly used in table DDL. It should be replaced with a comma from scripts to be compatible with 8.2. If desired, 8.2 now supports the CONSTRAINT keyword to provide a name for each constraint.
<li><a href="https://issues.jboss.org/browse/TEIID-2181">TEIID-2181</a> system tables no longer contain valid OIDs. That responsibility has moved to the pg_catalog.
<li><a href="https://issues.jboss.org/browse/TEIID-1386">TEIID-1386</a> the SQLState and errorCode reported by a TeiidSQLException will typically be from the top level nested SQLException. If there is also a nested TeiidException, the TeiidSQLException.teiidCode will be set to the TeiidException.getCode value and the TeiidSQLException.errorCode will be set
to the integer suffix of the teiidCode if possible.
<li><a href="https://issues.jboss.org/browse/TEIID-2226">TEIID-2226</a> All statements that return result sets that are executed as command statements in a procedure are validated against the expected resultset columns of the procedure.
If the statement is not intended to be returnable, WITHOUT RETURN can be added to the end of the statement.
<li><a href="https://issues.jboss.org/browse/TEIID-2235">TEIID-2235</a> The MetadataRepository.setNext method was removed and MetadataRepository was converted to an abstract class rather than an interface. Also if an instance of a DefaultMetadataRepository is used, it will only affect metadata already loaded in the repository chain.
<li><a href="https://issues.jboss.org/browse/TEIID-2237">TEIID-2237</a> teiid_ is a reserved DDL namespace prefix and the MetadataFactory class no longer throws TranslatorExceptions, instead the unchecked MetadataException is thrown.
<li><a href="https://issues.jboss.org/browse/TEIID-2243">TEIID-2243</a> by default Teiid will not pushdown the default null sort order of nulls low when no null sort order is specified. Set the system property org.teiid.pushdownDefaultNullOrder to true mimic the 8.1 and older release behavior.
<li>org.teiid.metadata.Schema holds FunctionMethods by uuid rather than name to accommodate overridden method signatures.
<li>MetadataFactory no longer extends Schema. Use the MetadataFactory.getSchema method to get the target Schema.
<li>DDL created VIRTUAL pushdown functions should be referenced in the ExecutionFactory.getSupportedFunctions by their full schema.function name.
<li>DDL functions/procedures defined without the VIRTUAL keyword are by default VIRTUAL. Use the FOREIGN keyword to indicate that they are source specific.
<li>FunctionMethod.getFullName returns the proper schema, not category qualified name.
<li>VDB.getUrl has been removed.
<li>VDB.Status now has four states - LOADING, ACTIVE, FAILED, REMOVED. To check for validity use the isValid method, rather than checking for the VALID state. FAILED deployments will still be accessible via the admin getVDB methods.
<li>The standalone and cli configuration files specify a setting for the teiid subsystem policy-decider-module. If a module is not specified, then data roles will not be checked.
<li>local connections specifying a VDB version will wait for their VDB to finish loading before allowing a connection, see the waitForLoad connection property for more.
<li>jsonToXml document elements will contain xsi:type attribute values of decimal and boolean respectively for number and boolean json values to allow for differentiation from string values.
<li>Result set cache entries can now have updatable set to false to indicate that updates should not purge the entry.
<li>Datatype default values have been corrected for Teiid built-in types. All datatypes are now nullable by default, only character string types are case sensitive, numeric types have radix 10, and length/precision/scale have been set appropriately.
<li>pg catalog and dynamic vdb created metadata will use a generated Teiid id rather than a random UUID.
<li>transport ssl config no longer uses the enabled attribute. Use mode=disabled to disable the usage of encryption.
<li><a href="https://issues.jboss.org/browse/TEIID-2105">TEIID-2105</a> If a MetadataRepository throws a RuntimeException during load, that will be treated as a non-recoverable error and the VDB will have a FAILED status.
<li><a href="https://issues.jboss.org/browse/TEIID-2105">TEIID-2105</a> It was an undocumented behavior that is a source did not specify a jndi connection that "java:/name" would be assumed. That is no longer the case. It the source needs a connection, then one must be specified.
<li><a href="https://issues.jboss.org/browse/TEIID-2127">TEIID-2127</a> if ExecutionFactory.isSourceRequired returns true (the default) then not obtaining a connection will for an Execution will result in an error. If an ExecutionFactory does not use a source, then no connection-jndi-name should be
specified and isSourceRequired should return false (see setSourceRequired). If isSourceRequired returns false and a connection-jndi-name is specified, then Teiid will still attempt to obtain a connection, but no exception will be thrown if a connection isn't available.
<li><a href="https://issues.jboss.org/browse/TEIID-2138">TEIID-2138</a> the odbc layer will report standard_conforming_strings as on, rather than off to better reflect the string literal handling of Teiid.
</ul>
<h2><a name="Configuration">Configuration Issues</a></h2>
See the <a href="teiid-docs/teiid_admin_guide.pdf">Admin Guide</a> for more on configuration and installation.
<h4>from 9.2</h4>
<ul>
<li><a href="https://issues.jboss.org/browse/TEIID-4820">TEIID-4820</a> The JDG specific connectivity is being separated from the main community project. It will be made available separately and as part of the product.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4858">TEIID-4858</a> The Hive translator now has order by support turned off by default.</li>
</ul>
<h4>from 9.1</h4>
<ul>
<li><a href="https://issues.jboss.org/browse/TEIID-4533">TEIID-4533</a> The default for the max-staleness of the resultset cache was changed from 60 seconds to 0 seconds. You may use the cli to alter this new default if necessary.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-4707">TEIID-4707</a> The PrestoDB driver is no longer pre-installed. This allows for newer client versions to be used as needed. The documentation has been updated to reflect this as well.</li>
</ul>
<h4>from 9.0</h4>
<ul>
<li><a href="https://issues.jboss.org/browse/TEIID-4129">TEIID-4129</a> in order to prevent invalid results from a sort/merge join, the sort operation will undergo additional checks. If org.teiid.assumeMatchingCollation is false (the default) and a translator does not specify a collationLocale, then the sort for a sort/merge join will not be pushed.
Teiid defaults to the Java UCS-2 collation, which may not match the default collation for sources, particular tables, or columns. You may set the system property org.teiid.assumeMatchingCollation true to restore the old default behavior or selectively update the translators to report a collationLocale matching org.teiid.collationLocale (UCS-2 if unset).</li>
</ul>
<h4>from 8.x</h4>
<ul>
<li><a href="https://issues.jboss.org/browse/TEIID-2754">TEIID-2754</a> view are reported as VIEW table type in the metadata. Use the connection property reportAsViews=false to restore the old behavior.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-3753">TEIID-3753</a> org.teiid.widenComparisonToString now defaults to false.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-3669">TEIID-3669</a> there is now a single session service. Common configuration properties need to be consolidated. With <a href="https://issues.jboss.org/browse/TEIID-3790">TEIID-3790</a> this also means that you may want to change the default of trust-all-local to false to restrict local pass-through connections. Also the VDB REST passthrough-auth property is no longer used.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-3797">TEIID-3797</a> the embedded transport is now known as the local transport.</li>
<li>TEIID-3859 the "native" 9999 management port is no longer used. AdminShell will default to the http 9990 management port instead.
<li><a href="https://issues.jboss.org/browse/TEIID-3594">TEIID-3594</a> User query command log entries are now logged at the INFO level on the org.teiid.COMMAND_LOG context. This allows command logging of just the user query events by setting the logging level to INFO. The level will default to WARN in the standard install or to DEBUG when running the auditcommand scripts.
<li><a href="https://issues.jboss.org/browse/TEIID-3192">TEIID-3192</a> The CXF config is no longer a valid option for the Salesforce resource adapter. Please log an issue if there is feature from the CXF config that you were using that is not present on the new resource adapter.
<li><a href="https://issues.jboss.org/browse/TEIID-3177">TEIID-3177</a> ODBC connections will be required to be secure based upon the SSL mode setting. If the mode is enabled, then the client must request an SSL connection. If the mode is login, then the client must use GSS authentication. To revert to the prior behavior, the system property org.teiid.ODBCRequireSecure can be set to false.</li>
<li><a href="https://issues.jboss.org/browse/TEIID-2512">TEIID-2512</a> the usage of the metadata element text as the "raw schema text" may not be appropriate in all situations. The ddl and ddl-file metadata repositories will check for the ddl and ddl-file model properties respectively.
<li><a href="https://issues.jboss.org/browse/TEIID-2707">TEIID-2707</a> the org.teiid.joinPrefetchBatches property is no longer used.
<li><a href="https://issues.jboss.org/browse/TEIID-2429">TEIID-2429</a> the default for maxProcessingKb has effectively doubled (the old default would use approaximately 4MB), while the maxReserveKb default has been reduced to 70% of the memory past the first gigabyte instead of 75%.
<li><a href="https://issues.jboss.org/browse/TEIID-2445">TEIID-2445</a> the UseConnectorMetadata and supports-multi-source-bindings properties have been deprecated, but will still be respected if present.
There is no equavalent to UserConnectorMetadata=true as it is always implied. UseConnectorMetadata=false has been replaced by cache-metadata=false, which can be placed at either the vdb or model level.
supports-multi-source-bindings has been replaced by multisource, which no longer needs to be specified if more than one source is configured.
<li><a href="https://issues.jboss.org/browse/TEIID-2510">TEIID-2510</a> the time-slice-in-millseconds has been corrected to be time-slice-in-milliseconds
<li>The connector batch size setting is no longer used. Instead a fetch size will be sent to the translator that is 2 times the working batch size or the non-pushed limit, whichever is less.
<li>The file translator now defaults to exceptionIfFileNotFound=true, you can set the translator property to false to preserve the old behavior of returning null.
<li><a href="https://issues.jboss.org/browse/TEIID-2086">TEIID-2086</a> <a href="https://issues.jboss.org/browse/TEIID-2168">TEIID-2168</a> prepared plan and result set caches are now configured as infinispan caches. See the teiid cache container in the configuration. You may also control the transactional aspects of the result set cache on the resultset and resultset-repl caches via the configuration.
<li><a href="https://issues.jboss.org/browse/TEIID-1241">TEIID-1241</a> the web services connector property ConfigName was deprecated in favor of EndPointName. There were also ServiceName, NamespaceUri, and Wsdl properties added, which are used to point the
<li>teiid-security-users and teiid-security-roles properties files have been moved under the configuration directory of their respective deployment.
</ul>
<h2><a name="Other">Other Issues</a></h2>
<ul>
<li><a href="https://issues.jboss.org/browse/TEIID-1281">TEIID-1281</a> - Negative start indexing is not supported by DB2 and Derby databases. Usage of the Teiid SUBSTRING against these sources should not use negative start values.
<li><a href="https://issues.jboss.org/browse/TEIID-1008">TEIID-1008</a> - Most versions of Oracle and MySQL do not support deeply nested correlated references. There is currently no workaround for this issue.
<li>For compatibility with the 7.0 release if a stored procedure parameter list begins with identifier=, then it will be parsed as a named parameter invocation even if the intent was to use a comparison predicate
as the first parameter value. The workaround is to use nesting parens, e.g. call proc((identifier=value), ...), which clarifies that this is positional value. This workaround will not be needed in later releases.
<li>TEIID-586 - Salesforce LIKE pushdown is case insensitive, while LIKE evaluated by Teiid is case sensitive unless an alternative collation is used. Care should be taken to ensure consistent results
if mixed case values are being searched.
<li><a href="https://issues.jboss.org/browse/TEIID-2836">TEIID-2836</a> - Data from DB2 on z/OS in EBCDIC may not be represented correctly at runtime. It is recommended that the values are converted to ASCII or another common character set.
<li><a href="https://issues.jboss.org/browse/TEIID-2998">TEIID-2998</a> - Google spreadsheets containing all string data do not detect their row data and labels correctly on the Google backend.
<li><a href="https://issues.jboss.org/browse/TEIID-3070">TEIID-3070</a> - Netty threads may inappropriately take up CPU resources. This affects most EAP releases. Upgrade the AS version of Netty to 3.6.10.Final to address this issue.
<li><a href="https://issues.jboss.org/browse/TEIID-3289">TEIID-3289</a> - The timestamp to string conversion performed in MySQL will produce a string with all of the trailing zeros (up to 6) for the fractional seconds. This differs from the expected Teiid/Java format.
<li>TEIID-2836 - Data from DB2 on z/OS in EBCDIC may not be represented correctly at runtime. It is recommended that the values are converted to ASCII or another common character set.
<li>TEIID-2998 - Google spreadsheets containing all string data do not detect their row data and labels correctly on the Google backend.
<li>TEIID-3070 - Netty threads may inappropriately take up CPU resources. This affects most EAP releases. Upgrade the AS version of Netty to 3.6.10.Final to address this issue.
<li>TEIID-3289 - The timestamp to string conversion performed in MySQL will produce a string with all of the trailing zeros (up to 6) for the fractional seconds. This differs from the expected Teiid/Java format.
<li>TEIID-3779 - There are a host of Phoenix issues that Teiid is currently not working around for HBase access. If you hit any of these, please let us know so that we can work with the Phoenix community to get it resolved. Generally Phoenix has issues with subquery evaluation and certain datatypes, such as char and timestamp.
<ul>
<li>TEIID-3772 TEIID-3769 TEIID-3766 are not likely to occur and generate an exception.
<li>TEIID-3774 is unlikely but can return inaccurate results.
<li>TEIID-3768 affects correlated subquery comparison using an aggregate of a char value and can return inaccurate results.
</ul>
</li>
<li>TEIID-3808 - The Informix driver handling of timezone information is inconsistent - even if the databaseTimezone translator property is set. Consider ensuring that the Informix server and the application server are in the same timezone.
<li>TEIID-3805 - SAP Hana returns an empty string rather than null for the substring function when the from index is larger than the string length.
<li>TEIID-3816 - Informix can return incorrect results for subquery comparisons involving a boolean value and a subquery that has only a single row. If you encounter such a scneario and need Teiid to compensate, then please open an issue.
</ul>
<h2><a name="LibraryUpdates">Thirdparty Library Updates</a></h2>
The following components have been updated:
<h4>From 9.3</h4>
<ul>
<li>The MongoDB client was upgraded to 3.4.2</li>
</ul>
<h4>From 9.2</h4>
<ul>
<li>Solr and related dependencies were updated to Solr version 6.4.1</li>
<li>Accumulo and related dependencies were updated to Accumulo version 1.7.3</li>
</ul>
<h4>From 9.1</h4>
<ul>
<li>The cassandra driver and associated dependencies were upgraded to 3.1.3.</li>
<li>The prestodb driver has has been removed.</li>
</ul>
<h2><a name="Details">Detailed Release Notes</a></h2>
<a href="https://issues.jboss.org/secure/ReleaseNote.jspa?projectId=12310782">Detailed Release Notes - Teiid - Version ${project.version}</a>
<h2><a name="Documentation">Documentation and Help</a></h2>
The <a href="http://www.jboss.org/teiid/">Teiid community project</a> is hosted on jboss.org.
Documentation and help may be obtained from the local distribution under <a href="teiid-docs">teiid-docs</a> or the following locations.
<ul>
<li><a href="http://www.jboss.org/teiid/docs">Online Documentation</a></li>
<li><a href="https://community.jboss.org/wiki/TheTeiidProject">Wiki</a></li>
<li><a href="http://jira.jboss.org/jira/browse/TEIID">JIRA</a></li>
<li><a href="http://community.jboss.org/en/teiid?view=discussions">Forums</a></li>
</ul>
<h2><a name="Licenses">Licenses</a></h2>
<p>Teiid is licensed under the <a href="LICENSE-lgpl-2.1.txt">LGPL</a>. The
license texts for Teiid and the thirdparty components it uses may be found in the <a href="teiid-docs/licenses">teiid-docs/licenses</a>
directory of the distribution.
</p>
<h2><a name="About">About JBoss, a
division of Red Hat</a></h2>
<p>JBoss, a division of <a href="http://www.redhat.com/jboss/">Red
Hat</a>, is in the business of
providing
superior technical support to our customers. Our goal is to make
Professional Open Source™ the <b>SAFE
CHOICE</b>
for you. We accomplish this by backing up our open source Java products
with technical support services that are delivered by the core
developers themselves. We can help you to train your staff and provide
you with support at every stage of the application lifecycle - from
development and integration through deployment and maintenance. Visit
the <a href="http://www.jboss.com/services/index">JBoss
Services</a> page for more
information.</p>
</BODY>
</HTML>