Support Article
Large Datapage index COLLATE NOCASE creation error in IOS Device
SA-74591
Summary
Error occurs on declaring a large datapage for offline in pyDataPageWhitelistForOffline:.
Error Messages
no such column: Name COLLATE NOCASE
Steps to Reproduce
- Create a datapage.
- Declare the datapage as large. Verify the below syntax to declare the datapage as large:
D_Property;large;[["index1_column1","index1_column2","index1_column3"],["index2_column1","index1_column2","index2_column3 COLLATE NOCASE"]]
Root Cause
In the native client implementation, broken SQL syntax was generated when COLLATE NOCASE attributes were used.
Resolution
Perform the following local-change:
Hybrid Client Patch Release (7.41.2.2) is created.
Set this version in the pyHCBuildVersion declare expression rule. This change is required until HC 7.41.2.2+ version becomes the default mapping.
Tags:
Published August 15, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.