? Bug in key – lower

[ajith]

Executing

create testable (testcol) key lower (testcol)

in QueryView shows an error query: synatx error create testable (testcol) key @ lower (testcol).
If i remove lower, it works fine. Is there an error in what I have typed or is it a bug?

ajith

[amckinlay]

Hi Ajith,

I have removed support for “lower” indexes since they weren’t fully implemented.

My plan is to allow indexing a rule (which could do lower). This has the advantage that you have a way to access the original field(s) as well as the transformed field. One issue is that if you modify the code of the rule, then the index has to be rebuilt, but this is hard to detect automatically.

[ajith]

Hi Andrew,
Thanks for the reply. Indexes should be fine with a rule. If I want people to restrict entry in a key field to only one case, I should use a control rule to check the case?
ajith

[amckinlay]

Yes, you can handle it in the user interface.

[Author]

Posts