Situation: After upgrade to April 2019 from November 2018, we are experiencing difference in loading and handling of guids (uniqueidentifier) sql server columns. columns values are now loaded in lowercase.
Simple loading of a sql server table containing columns of type - uniqueidentifier ( containing guid in the form xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx) is now loading in lowercase.
e.g. Column A is loaded with a row value of '6F9619FF-8B86-D011-B42D-00C04FC964FF' as '6f9619ff-8b86-d011-b42d-00c04fc964ff'.
This creates a problem in Qlik when you are trying to retrieve a particular row in an in-memory dataset by using a where clause like 'where A = '6F9619FF-8B86-D011-B42D-00C04FC964FF' , say you are looking for a particular client data. This now results in no data being returned because April 2019 version now make the where clause look like 'where A = '6f9619ff-8b86-d011-b42d-00c04fc964ff'
I know I can do a workaround using upper or lower but it is not compatible with the older code written against November 2018. Has anyone experience this? Is this related to any odbc driver load change to the data manager? Any input will be appreciated. Thank you.
