
Patch: d553_100518_0045.jar
Application of this patch requires full shutdown and restart of the MetaMatrix Server.
If running in a clustered environment, full shutdown of all MetaMatrix Servers may be required.


Case: 230440
Description: 11/03/2008 Fix for issue using LIKE criteria with WebService sources.

Case: 223729
Description: 11/04/2008 Fix an issue rewriting query with limit clause for Oracle.

Case: 222237
Description: 11/04/2008 Fix a XML join planning issue.

Case: 222948
Description: 11/04/2008 Fix error when using Oracle SEQUENCE.

Case: 223729
Description: 11/03/2008 Fix an issue rewriting query with limit clause for Oracle.

Case: 235785
Description: 11/10/2008 Fix an issue converting timestamp to string for Oracle.

Case: 244298
Description: 12/09/2008 Removes unnecessary alias when converting union query for Oracle.

Case: 248869
Description: 12/15/2008 Fix for non-unique ResponseOut values with WebService sources.

Case: 250055
Description: 01/06/2008 Minor change to the strategy of copying criteria.

Case: 259340
Description: 02/05/2009 Additional fix for resolving datatype for XML element when there are multiple documents.

Case: 280794
Description: 04/08/2009 MS Access ODBC connector capabilities will not reflect that CASE is not supported.

Case: 281516
Description: 04/13/2009 Added MOD() scalar function to DB2 connector capabilities class.

Case: TEIID-100
Description: 04/22/2009 Salesforce connector should explicitly handle InvalidQueryLocatorFault

Case: TEIID-96
Description: 04/22/2009 Salesforce connector isn't consistently protecting against null values in binding parameters

Case: TEIID-55
Description: 04/22/2009 Salesforce connector doesn't expose standard connection pooling or caching connector properties

Case: 289582
Description: 04/24/2009 Add optional parenthesis for joins for MySql.

Case: IT-294562
Description: 05/15/2009 Fixed issue in where a SQLException that was thrown during query execution could be lost if an exception was thrown during resource clean-up as a result of the original SQLException.

Case: IT-315187
Description: 07/07/2009 Resolves Salesforce Connector 'Connection Reset' issue with MatView scripts.

Case: IT-317813
Description: 07/30/2009 Fix Oracle Spatial Connector's translator to properly translate function parameters that are to be of type SDO_GEOMETRY. The fix removes the string escape from parameters that are of type String when the parameter is being used in place of SDO_GEOMETRY type parameters.

Case: JBEDSP-1073
Description: 07/30/2009 Fix an issue with using CONVERT(timeValue, timestamp) or CONVERT(dateValue, timestamp) resulting in an invalid Oracle query.

Case: JBEDSP-1074
Description: 07/30/2009 Oracle Spatial connector was adding extra blank spaces at the beginning of the SELECT clause.

Case: IT-367003
Description: 01/18/2010 
    	 	Time, date, and timestamp literals are being sent to Oracle as 
    	 	to_timestamp() regardless of their data type
    	 

Case: IT-367003
Description: 01/18/2010 
    	 	Timestamp literals with fractional seconds result in source query 
    	 	execution performance when being compared to less percise time types
    	 

Case: IT-815453
Description: 05/18/2010 Improved OracleSQLTranslator to support LIMITs in SubqueryInCriteria 
