Geoff hendrey wrote:
I posted a comment with a suggestion on an approach for dealing with
case-insensitive comparisons.
Any feedback?
https://issues.apache.org/jira/browse/DERBY-1748?focusedCommentId=12606166#action_12606166
Hi Geoff,
I have commented on the issue. Your latest proposal sounds to me like
DERBY-455 (expression indexes). That would be a very elegant, powerful
feature but I think that DERBY-481 (generated columns) entails less
effort and gives us most of the power of expression indexes. As you note
in your comment, generated columns have limited value if you don't index
them.
Thanks,
-Rick