On Jan 28, 2005, at 12:04 PM, Kurt Welgehausen wrote:
Yes, it seems to me that views should respect the configurations of their underlying tables, including collations, triggers, and the like. I'll submit a bug report.
It's not quite that simple. A view column may be an expression, and inferring attributes for such a column could be quite complicated. Triggers are usually associated with updates, and view updatability is a complex subject itself (SQLite views are not updatable).
Oh, right. I was thinking of the triggers I apply to views, but then those act directly on the underlying tables, so *their* triggers should work just fine.
On the other hand, I don't see why collation info for a simple column reference can't be made availabe through a view, since type info already is available -- but I certainly could be missing something.
It makes sense to me.
select * from va where lower(b) = 'this'
... Will that use the index, though?
No, not unless something has changed recently.
Gah, pity.
Regards,
David
smime.p7s
Description: S/MIME cryptographic signature
