This query has always executed without error. The following query uses a LEFT OUTER JOIN to list all “facility_id” values from the Facility Service as well as the “itemid” from the Notes Service’s Note Association Records that matches the “facility_id” or “NULL” if no association exists. Previous to this patch, such a query would not return the correct rows and either generate an unknown exception in the associated log file or cause the application to crash.įor example, imagine you need a list of all Facility IDs in your Facility Service along with any notes from the Note Service that may be associated with the facilities in the list, knowing that most facilities do not have associated notes. The CygNet ODBC driver has recently been patched such that it returns the correct rows for a query that processes the results of a LEFT OUTER JOIN with a subsequent LEFT OUTER JOIN.
0 Comments
Leave a Reply. |