I don't know why Jira is not forwarding comments for this specific bug. Here are some of my comments.
SQL standard provides a way to have generated columns. These generated columns can be created using, GENERATED ALWAYS AS <left paren><value expression><right paren> Once we have a generated column, it should be possible to create a regular B-Tree index on this generated column. I think there are several advantages of using this syntax: 1) It is standards based. 2) Since the column is visible, it is much cleaner and easier to understand the semantics 3) Fits nicely with existing syntax for identity columns. I think this is a good enhancement to add to Derby. Satheesh Mike Matrigali wrote: > don' know what is going on with jira. I have added comments on 455, and > have not seen those go to the list. > > Rick Hillegas wrote: > >> I added comments to two bugs this week (171 and 455) and was hoping >> that Jira would post these comments to the developer's list. In >> particular, I was hoping that my comment on 455 (expression indexes) >> would invite further discussion by the Store experts. Alas, Jira did >> not post my comments. Would appreciate theories about how I am >> mis-using Jira. >> >> Thanks, >> -Rick >> >> >> > > >
