Help for Array and like uses together

SQL++
23 
CRATE INDEX ix11 ON db(type, LOWER(fname));
CRATE INDEX ix12 ON db(type, LOWER(main.ls.name));
CRATE INDEX ix13 ON db(type, ARRAY LOWER(u.name)  FOR u IN uns END);
SELECT *, true fname_matched FROM db WHERE type = "P" AND (LOWER(fname) LIKE "owner%" OR LOWER(fname) LIKE "d%")
UNION ALL
SELECT *, true lname_matched FROM db WHERE type = "P" AND (LOWER(main.ls.name) LIKE "owner%" OR LOWER(main.ls.name) LIKE "d%")
UNION ALL
SELECT *, true uns_matched FROM db WHERE type = "P" AND ANY u IN uns SATISFIES LOWER(u.name) LIKE "owner%" OR LOWER(u.name) LIKE "d%" END ;