> 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). 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. > > select * from va where lower(b) = 'this' > > ... Will that use the index, though? No, not unless something has changed recently. Regards
