Rick Hillegas wrote:
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.
How do people work around this at present? I absolutely *must* have case-insensitive indexed searches in my application.
-- Alan Burlison --
