bug 1221: missing column in query for assurances data