A delete query against a view fails, when in WHERE clause there is a filter on non-directly mapped column. Please note, that the integer type is only example, this happens for any type (time/date/timestamp amongst other).
And following query:
I get an error:
- This happens on both empty and non-empty cache.
- For a column, which is directly mapped from a source column to view column, such problem doesn't exist.
- Given the limited type support on JDG's side I consider this blocking issue, as there's no workaround for such operation.