Here is an example:

CREATE VIEW "vTableIndexes" AS
select  "TableName", list(IndexDir) as "IndexColNames" from
(select "TableName", "ColumnName"+if("Descending",' Desc','') as "IndexDir" from "information"."indexcolumns"
       order by "tablename", "indexname", "ordinalpos") as T1
group by "tablename", "IndexName";

select * from vTableIndexes where IndexColNames like 'p%';

Why is IndexColNames case sensitive when Information.ColumnName was case-insensitive?
Example: The Select statement above won't find IndexColNames that start with 'P%'

Barry

Barry


I can confirm it with 2.11b3 ansi

Like yourself I have no idea of the cause or how to do something about it. All I can suggest is email Tim direct.

Roy Lambert [Team Elevate]

>I can confirm it with 2.11b3 ansi
Like yourself I have no idea of the cause or how to do something about it. All I can suggest is email Tim direct.<

Roy, thanks for confirming it. Tim got back to me and he will have a fix for it in the next release.

Barry