We're updating the issue view to help you get more done. 

Using a constant collection as the source of the ANY, ALL, etc operators will interpret sequence as a query source instead of a multi-valued parameter or an erroneus query

Description

Actual SQL:

The generated query contains a sub select on the table of the sequences type, resulting in a transparent loss of the contraint. Queries such as this one should instead generate a WHERE IN clause or result in an immediate error.

Expected SQL:

Note:

  • For types using multi-part IDs this logic will not be supported just like it is not supported when using multi-part IDs in a CONTAINS operation.

  • At this time, it is not supported to use entities with CONTAINS operations. Instead, the IDs must be passed into the query. This constraint will also apply to the ANY operation.

  • This also affects ALL and other result operators.

TODO: Update linked Wiki-page when issue is fixed.

Assignee

Michael Ketting

Reporter

SJ

Labels

None

Components

Fix versions

Affects versions

Priority

Normal
Configure