
All Modeler patches are cumulative. All previous patches to this version of the Modeler are rolled up and 
included in this patch. The history below shows summary of all fixes addressed by this and previous patches.

This cumulative patch may also conatin patches for extension jars.  Extension jar patches should be added 
to connector binding classpathes as necessary (i.e. extensionjar:jdbcconn_PATCH.jar;extensionjar:jdbcconn.jar).

Installed Patch: ed553_100224_0042-win32.zip

Case      Summary
=====     ====================================================================================
230440      11/03/2008 Fix for issue using LIKE criteria with WebService sources.
219210      11/03/2008 Fix to MetaMatrix Oracle JDBC Driver in which calling getTables() failed to return VIEWs in the system schema when "VIEW" was included in the table type restriction argument and also incorrectly returned VIEWs as SYSTEM TABLEs when SYSTEM TABLE was used as the table type restriction. Updated MJjdbc.jar to 3.7.48
231960      11/04/2008 Fix an issue resolving datatype for XML element.
223729      11/04/2008 Fix an issue rewriting query with limit clause for Oracle.
222237      11/04/2008 Fix a XML join planning issue.
222948      11/04/2008 Fix error when using Oracle SEQUENCE.
223729      11/03/2008 Fix an issue rewriting query with limit clause for Oracle.
235785      11/10/2008 Fix an issue converting timestamp to string for Oracle.
236455      11/13/2008 Fixes query execution and resolver issues that would occur if a query was used as the assignment value in a virtual procedures DECLARE statement.
236831      11/13/2008 Fixes Designer issue with indexing of MatView Tables
244298      12/09/2008 Removes unnecessary alias when converting union query for Oracle.
248869      12/15/2008 Fix for non-unique ResponseOut values with WebService sources.
250055      01/06/2008 Minor change to the strategy of copying criteria.
255776      01/15/2008 Properly handle schema import when schema location is not defined.
260894      02/03/2009 Fix JDBC Importer to import CLOB as CLOB not String
234655      02/03/2009 Fix for Salesforce importer losing column info on re-import
245694      02/04/2009 Fix for Name in source -@- delimiter issue with Oracle
259340      02/05/2009 Additional fix for resolving datatype for XML element when there are multiple documents.
259834      02/09/2009 Fixed optimization issue in where a non-deterministic function would get merged with a parent plan node.
282405      04/08/2009 Resolves issue with XML Schema as Relational Source Model importer
280794      04/08/2009 MS Access ODBC connector capabilities will not reflect that CASE is not supported.
281516      04/13/2009 Added MOD() scalar function to DB2 connector capabilities class.
286251      04/20/2009 Fixes issue with WSDL and XSD to relational importers not modeling extension declarations correctly.
TEIID-100      04/22/2009 Salesforce connector should explicitly handle InvalidQueryLocatorFault
TEIID-96      04/22/2009 Salesforce connector isn't consistently protecting against null values in binding parameters
TEIID-55      04/22/2009 Salesforce connector doesn't expose standard connection pooling or caching connector properties
289582      04/24/2009 Add optional parenthesis for joins for MySql.
IT-289262      04/29/2009 Fixed invalid query issue that could occur when a BETWEEN expression appeared in an aggregate function.
IT-292570      05/05/2009 Fixed issue with structural copy of virtual views in Designer.
293227      05/08/2009 Fixed Designer SQL Validation problem with Virtual Procedures
289126      05/12/2009 Fix a few issues when throwing XAException
IT-294562      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.
JBEDSP-1050      05/29/2009 Fix issue with updated or patched extension modules in DQP plug-in for Designer not being picked up by the user's workspace if the extension module already existed.
281239      06/12/2009 Fix for usability problem - change UDF -deterministic- property default to true
JBEDSP-1055      05/26/2009 Fixed an issue dealing with how JoinPredicate equality was invalid due to invalid join criteria comparison.
IT-302851      06/30/2009 Fixed an issue in where a procedure variable used in non-join criteria could get pushed out to the source due to modification of the original command structure during query optimization.
IT-315187      07/07/2009 Resolves Salesforce Connector 'Connection Reset' issue with MatView scripts.
IT-320335      07/24/2009 Resolves issue with JDBC import of BIT column types from MySQL in Designer.
IT-317813      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.
JBEDSP-1073      07/30/2009 Fix an issue with using CONVERT(timeValue, timestamp) or CONVERT(dateValue, timestamp) resulting in an invalid Oracle query.
JBEDSP-1074      07/30/2009 Oracle Spatial connector was adding extra blank spaces at the beginning of the SELECT clause.
IT-327792      08/17/2009 Resolves issue with XML Document model generation from schema in Designer.
IT-344017      09/18/2009 Resolves issue with partial results error handling with stored procedures.
IT-367765      11/25/2009 Fixed an issue with using batched updates in a PreparedStatement in where that multiple executions of the prepared statement would reuse values from the first execution if the update was being performed against a view/virtual table.
IT-365640      12/04/2009 Fixed a problem where an empty batch can result in a NullPointerException when attempting to return a tuple from the batch during query processing.
IT-374894      12/16/2009 StackOverflowError when top level query uses the same symbol name and group alias that is in a second level query or sub-query
JBEDSP-1133      12/16/2009 Prepared Batch Update reuses values from original cached statement
IT-365640      12/16/2009 
    	 	Result set cache can throw a NPE if results that used to be there have 
    	 	been removed
    	 
IT-367003      01/18/2010 
    	 	Time, date, and timestamp literals are being sent to Oracle as 
    	 	to_timestamp() regardless of their data type
    	 
IT-367003      01/18/2010 
    	 	Timestamp literals with fractional seconds result in source query 
    	 	execution performance when being compared to less percise time types
    	 
423523      02/12/2009 Fix to propagate column aliases across UNION SELECTs for DB2
541413      02/24/2010 Fix for ConcurrentModificationException with more than 2 left outer joins
