Re: [hibernate-dev] Various "row value construct" alike syntax and Dialect class

On Sun 27 May 2012 02:52:23 AM CDT, Łukasz Antoniak wrote: Ok. And this form comes about because of the multi-table HQL splitting to use temp tables right? As an alternative suggestion, why don't we just have envers directly perform an SQL UPDATE? Its really just the ParentEntity_AUD table you want to update right? And this is really just to lock the table right? Ok, then the issue is naming. See the issue is not the subquery. The subquery does not even have a row value constructor; "select c1, d1" is just a simple select list. The problem is that the dialect does not support the use of a subquery as the predicate of a logical expression where the other predicate is a tuple. Basically they are doing too simplistic of type checking on the 2 predicates. So maybe supportsRowValueConstructorPredicateAndSubqueryPredicateInLogicalExpression(). I assume it is the same problem with all forms of logical expressions (=, !=, >, etc), not just IN? Could you verify that? We might want to consider consolidating these together as well into a composite class that reports the dialects level of tuple support. That unfortunately would have to wait for the next major rev. My point is just that the third query does not involve an IN expression. So why would it fall under supportsRowValueConstructorSyntax*InInList*? -- steve(a)hibernate.org http://hibernate.org