[hibernate-issues] [Hibernate-JIRA] Created: (HHH-6856) RowValueConstructorSyntax with In syntax is not working
RowValueConstructorSyntax with In syntax is not working
-------------------------------------------------------
Key: HHH-6856
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6856
Project: Hibernate Core
Issue Type: Bug
Components: query-sql
Affects Versions: 4.0.0.CR6
Reporter: Strong Liu
Assignee: Strong Liu
Fix For: 4.0.0.next
_org.hibernate.test.hql.HQLTest#testRowValueConstructorSyntaxInInList_ fails on oracle.
because this HQL "from LineItem l where l.id in
(('a1',1,'b1'),('a2',2,'b2'))" is not correctly
parsed.
it throws the following exception:
{quote}
16:43:59,245 DEBUG QueryTranslatorImpl:252 - --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (LineItem)
+-[SELECT_CLAUSE] SelectClause: '{derived select clause}'
| +-[SELECT_EXPR] SelectExpressionImpl: 'lineitem0_.customerId as customerId30_,
lineitem0_.orderNumber as orderNum2_30_, lineitem0_.productId as productId30_'
{FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy
properties,classAlias=l,role=null,tableName=LineItem,tableAlias=lineitem0_,origin=null,columns={,className=LineItem}}}
| \-[SQL_TOKEN] SqlFragment: 'lineitem0_.quantity as quantity30_'
+-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1,
fromElements=1, fromElementByClassAlias=[l], fromElementByTableAlias=[lineitem0_],
fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
| \-[FROM_FRAGMENT] FromElement: 'LineItem lineitem0_'
FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy
properties,classAlias=l,role=null,tableName=LineItem,tableAlias=lineitem0_,origin=null,columns={,className=LineItem}}
\-[WHERE] SqlNode: 'where'
\-[IN] InLogicOperatorNode: 'in'
+-[DOT] DotNode: '(lineitem0_.customerId, lineitem0_.orderNumber,
lineitem0_.productId)'
{propertyName=id,dereferenceType=2,propertyPath=id,path=l.id,tableAlias=lineitem0_,className=LineItem,classAlias=l}
| +-[ALIAS_REF] IdentNode: '(lineitem0_.customerId, lineitem0_.orderNumber,
lineitem0_.productId)' {alias=l, className=LineItem, tableAlias=lineitem0_}
| \-[IDENT] IdentNode: 'id' {originalText=id}
\-[IN_LIST] SqlNode: 'inList'
+-[VECTOR_EXPR] SqlNode: '{vector}'
| +-[QUOTED_STRING] LiteralNode: ''a1''
| +-[NUM_INT] LiteralNode: '1'
| \-[QUOTED_STRING] LiteralNode: ''b1''
\-[VECTOR_EXPR] SqlNode: '{vector}'
+-[QUOTED_STRING] LiteralNode: ''a2''
+-[NUM_INT] LiteralNode: '2'
\-[QUOTED_STRING] LiteralNode: ''b2''
16:43:59,249 DEBUG ErrorCounter:82 - throwQueryException() : no errors
16:43:59,252 ERROR ErrorCounter:54 - <AST>:0:0: unexpected AST node: {vector}
16:43:59,254 ERROR ErrorCounter:50 - <AST>:0:0: unexpected AST node: {vector}
<AST>:0:0: unexpected AST node: {vector}
at org.hibernate.hql.internal.antlr.SqlGeneratorBase.inList(SqlGeneratorBase.java:3155)
at
org.hibernate.hql.internal.antlr.SqlGeneratorBase.exoticComparisonExpression(SqlGeneratorBase.java:2965)
at
org.hibernate.hql.internal.antlr.SqlGeneratorBase.comparisonExpr(SqlGeneratorBase.java:1219)
at
org.hibernate.hql.internal.antlr.SqlGeneratorBase.booleanExpr(SqlGeneratorBase.java:857)
{quote}
I think the key is here
{code:title=sql-gen.g}
inList
: #(IN_LIST { out(" "); } ( parenSelect | simpleExprList ) )
;
simpleExprList
: { out("("); } (e:simpleExpr { separator(e," , "); } )* {
out(")"); }
;
// A simple expression, or a sub-select with parens around it.
expr
: simpleExpr
| #( VECTOR_EXPR { out("("); } (e:expr { separator(e," , "); } )* {
out(")"); } )
| parenSelect
| #(ANY { out("any "); } quantified )
| #(ALL { out("all "); } quantified )
| #(SOME { out("some "); } quantified )
;
{code}
fromt this grammar, inList doesn't accept VECTOR
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira