
Patch: r553_110208_0052.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: 232624
Description: 11/04/2008 Fix for exception when CASE resolves to null

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

Case: 223249
Description: 11/04/2008 Fix an issue with join planning.

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

Case: 236455
Description: 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.

Case: 238290
Description: 11/17/2008 Support using XML connector in transaction.

Case: 242438
Description: 12/04/2008 Adding new LDAP Membership Domain prop to control whether connection pooling is used

Case: 242438
Description: 12/04/2008 Adding new LDAP Membership Domain prop to control whether connection pooling is used

Case: 236419
Description: 12/09/2008 Fixes an issue rewriting query with function and group by clause.

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

Case: 222791
Description: 12/18/2008 Fixed rule to correctly process duplicate columns for the case where a Limit on returned rows is specified.

Case: 256944
Description: 02/05/2009 Fix an issue closing transaction too early.

Case: 259834
Description: 02/09/2009 Fixed optimization issue in where a non-deterministic function would get merged with a parent plan node.

Case: 266931
Description: 02/19/2009 Fixed SQL conversion issue with long aliases on Oracle

Case: 267168
Description: 02/20/2009 Fix a planning error pushing criteria containing aggregate through union

Case: 269005
Description: 02/24/2009 Fix an error collecting commands for union

Case: 269222
Description: 03/03/2009 Fixes an issue in where the Command Logger would potentially log the optimized version of a user query as the User Command instead of the original query submitted by the client.

Case: 271173
Description: 03/13/2009 Fix for NPE in complex aggregate query 

Case: 271922
Description: 03/13/2009 Changed socket server log level of client/server connection initialization error EOFException from error to warning.

Case: 270389
Description: 03/17/2009 Remove optional parenthesis for joins.

Case: 275865
Description: 03/25/2009 Change user name to blank if password is blank for LDAP membership domain.

Case: 277333
Description: 03/26/2009 Fix for missing symbol problem with SELECT INTO for mat view

Case: 280004
Description: 03/27/2009 Fix for YEAR function Oracle conversion issue

Case: 284099
Description: 04/16/2009 Fixed an issue with using batched updates in a PreparedStatement in where that multiple executions of the batch with different number of batched values would result in incorrect plans being used from the plan cache.

Case: ------
Description: 04/30/2009 Added Log messages upon change in audit logging.

Case: IT-289262
Description: 04/29/2009 Fixed invalid query issue that could occur when a BETWEEN expression appeared in an aggregate function.

Case: TEIID-547
Description: 05/07/2009 Audit messages in the system log file - for CCE

Case: 289126
Description: 05/12/2009 Fix a few issues when throwing XAException

Case: 291841
Description: 05/20/2009 Fix for Oracle MatView CREATE script using DATE for TIMESTAMP

Case: 300614
Description: 05/29/2009 Change join planning to put non-join criteria in where clause

Case: 304235
Description: 06/05/2009 Fix date time format for salesforce connector

Case: 281239
Description: 06/12/2009 Fix for usability problem - change UDF -deterministic- property default to true

Case: 306434
Description: 06/16/2009 Fix an issue obtaining connector capability

Case: JBEDSP-1055
Description: 05/26/2009 Fixed an issue dealing with how JoinPredicate equality was invalid due to invalid join criteria comparison.

Case: IT-302851
Description: 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.

Case: IT-325001
Description: 08/05/2009 Fixes connector result set caching error

Case: 326081
Description: 08/06/2009 Fix check for sql update.

Case: 334947
Description: 09/01/2009 Fix an error cloning limit node.

Case: IT-335306
Description: 09/02/2009 Resolves issue with MatView script generation under certain conditions.

Case: IT-344017
Description: 09/18/2009 Resolves issue with partial results error handling with stored procedures.

Case: 334625
Description: 09/18/2009 Support for inline view in relate mapping classes

Case: 315603
Description: 10/27/2009 Fix a few problems returning partial results warnings

Case: 361849
Description: 11/04/2009 Fix an error obtaining projected symbols from virtual procedure

Case: IT-367765
Description: 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.

Case: IT-365640
Description: 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.

Case: IT-374894
Description: 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

Case: JBEDSP-1133
Description: 12/16/2009 Prepared Batch Update reuses values from original cached statement

Case: IT-365640
Description: 12/16/2009 
    	 	Result set cache can throw a NPE if results that used to be there have 
    	 	been removed
    	 

Case: 378299
Description: 01/11/2010 Fix for -failed to project- problem with function calls in Group By

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-376654
Description: 01/26/2010 
    	 	Clustered nodes may not see each other on a Multi-honed server
    	 	
    	 	Adds support for using host level property jgroups.bind.address so 
    	 	that MetaMatrix Host Controller and Server VM can use the same 
    	 	network interface for their message bus instance.  To expose the 
    	 	property in the MetaMatrix Console the following component type 
    	 	definition property must be added to the Host ComponentType:
    	 	
    	 	<PropertyDefinition Name="jgroups.bind.address" DisplayName="JGroups Bind Address" ShortDescription="The JGroups bind address determines which network interface JGroups will use for listening and outbound network requests." DefaultValue="" Multiplicity="1" />
    	 

Case: IT-414883
Description: 02/04/2010 Changes to support JDK 1.6 clients

Case: 423523
Description: 02/12/2009 Fix to propagate column aliases across UNION SELECTs for DB2

Case: 541413
Description: 02/24/2010 Fix for ConcurrentModificationException with more than 2 left outer joins

Case: IT-517713
Description: 03/05/2010 Performance improvement for BufferManager

Case: IT-640143
Description: 03/23/2010 Mod MMClob toString to construct and return full String

Case: SFDC-393370
Description: 1/18/2011 Resolves issue with row limits push strategy in query planning

Case: SFDC-24122
Description: 1/26/2011 Fixed issue with Relate Planner resolution of nested mapping classes

Case: SFDC-411875
Description: 2/2/2011 XML-Relational SOAP connector fix, adds Use Http Chunking property
