subselect « Composite « JPA Q&A

  1. JPA Q&A
  2. Composite
  3. subselect




1. Sybase dialect, composite keys and subselect    forum.hibernate.org

Hibernate version: 3.1b1 Sybase ASE doesn't support the syntax where (c1,c2) in (select v1, v2 ...) This is generated for composite keys in bidi one-to-many when fetch="subselect" is set. Isn't that a typical case where the dialect should drive how the query is being built? I'd conjecture that the following are equivalent: 1) select * from T1 where c11,c12 in (select ...