You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
If I create an expression index on a column, then the index information isn't retrieved through the call to SQLStatistics. Thus,
create table expressive (user_name char(20) not null);
insert into expressive values ('bob');
insert into expressive values ('tom');
insert into expressive values ('vlad');
commit;
create unique index expressive_idx on expressive computed by (lower(user_name));
commit;
The information about expressive_idx does not show up in the call to SQLStatistics.
It seems that the problem is that expression indexes don't have an entry in rdb$index_segments. Thus ln 107 in IscDbc/IscIndexInfoResultSet.cpp should be a LEFT JOIN and not an inner JOIN.
Alexander also said that if an index is based on an expression, the expression should return in COLUMN_NAME, per spec. This is column RDB$EXPRESSION_SOURCE.
Submitted by: Bill Oliver (verbguy)
Attachments:
OdbcFb.zip
If I create an expression index on a column, then the index information isn't retrieved through the call to SQLStatistics. Thus,
create table expressive (user_name char(20) not null);
insert into expressive values ('bob');
insert into expressive values ('tom');
insert into expressive values ('vlad');
commit;
create unique index expressive_idx on expressive computed by (lower(user_name));
commit;
The information about expressive_idx does not show up in the call to SQLStatistics.
It seems that the problem is that expression indexes don't have an entry in rdb$index_segments. Thus ln 107 in IscDbc/IscIndexInfoResultSet.cpp should be a LEFT JOIN and not an inner JOIN.
Alexander also said that if an index is based on an expression, the expression should return in COLUMN_NAME, per spec. This is column RDB$EXPRESSION_SOURCE.
Commits: e9ec288 2f98d7e
The text was updated successfully, but these errors were encountered: