Setting to allow temp tables to support case insensitivityNot planned
I would like to request a feature, a setting of sorts, to allow Data Virtuality to treat WHERE\JOIN conditions with case insensitivity. I understand that doing so on the JOIN logic would be more challenging, but having the WHERE clause be case insensitive would be great. Also I think this should be an optional setting so people can choose one or the other.
Un Sang Oum
Comment actionsOfficial comment
Hello Un Sang,
thank you for your feature request. We have evaluated the feasibility of implementing the feature you asked for.
Unfortunately, during the evaluation we came to the conclusion that this implementation is not realistic at that moment of time.
The current sorting order being the key for performant joins across different databases (since its is compatible with the database sortings known as Posix, "C", BINARY etc.) -- as was probably already mentioned in a different situation -- is just one important aspect to take into account.
Apart from this, this sorting order is being used and relied on ubiquitously in our software, so that the effort of changing it and -- even more importantly -- testing and QA-ing the possible consequences and problems arising from such fundamental change, is overwhelming in comparison to the effort of using of applying UCASE function to achieve case-insensitive comparison or ordering.
In general, the improvement suggestion absolutely makes sense, so that we are adding it into the roadmap backlog -- but given the above we cannot give any ETA on this implementation as of now.
Please sign in to leave a comment.