<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0" /> <base href="https://hibernate.atlassian.net" />
<title>Message Title</title>
</head>
<body class="jira" style="color: #333; font-family: Arial, sans-serif; font-size: 14px; line-height: 1.429">
<table id="background-table" cellpadding="0" cellspacing="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background-color: #f5f5f5; border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<!-- header here -->
<tr>
<td id="header-pattern-container" style="padding: 0px; border-collapse: collapse; padding: 10px 20px">
<table id="header-pattern" cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<td id="header-avatar-image-container" valign="top" style="padding: 0px; border-collapse: collapse; vertical-align: top; width: 32px; padding-right: 8px"> <img id="header-avatar-image" class="image_fix" src="https://secure.gravatar.com/avatar/498a6a417c06712f4b5ae4a39ea4f2b6?d=mm&s=48" height="32" width="32" border="0" style="border-radius: 3px; vertical-align: top" />
</td>
<td id="header-text-container" valign="middle" style="padding: 0px; border-collapse: collapse; vertical-align: middle; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 1px"> <a class="user-hover" rel="Jezyk" id="email_Jezyk" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?name=Jezyk" style="color:#6c797f;; color: #3b73af; text-decoration: none">Maciej Jezierski</a> <strong>created</strong> an issue
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td id="email-content-container" style="padding: 0px; border-collapse: collapse; padding: 0 20px">
<table id="email-content-table" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; border-spacing: 0; border-collapse: separate">
<tr>
<!-- there needs to be content in the cell for it to render in some clients -->
<td class="email-content-rounded-top mobile-expand" style="padding: 0px; border-collapse: collapse; color: #fff; padding: 0 15px 0 16px; height: 15px; background-color: #fff; border-left: 1px solid #ccc; border-top: 1px solid #ccc; border-right: 1px solid #ccc; border-bottom: 0; border-top-right-radius: 5px; border-top-left-radius: 5px; height: 10px; line-height: 10px; padding: 0 15px 0 16px; mso-line-height-rule: exactly">
</td>
</tr>
<tr>
<td class="email-content-main mobile-expand " style="padding: 0px; border-collapse: collapse; border-left: 1px solid #ccc; border-right: 1px solid #ccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #fff">
<table class="page-title-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<td class="page-title-pattern-first-line " style="padding: 0px; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; padding-top: 10px"> <a href="https://hibernate.atlassian.net/browse/HHH" style="color: #3b73af; text-decoration: none">Hibernate ORM</a> / <a href="https://hibernate.atlassian.net/browse/HHH-9779" style="color: #3b73af; text-decoration: none"><img src="cid:jira-generated-image-static-bug-c6b0b515-df54-4050-ac80-2b6e8d8561b7" height="16" width="16" border="0" align="absmiddle" alt="Bug" style="vertical-align: text-bottom" /></a> <a href="https://hibernate.atlassian.net/browse/HHH-9779" style="color: #3b73af; text-decoration: none">HHH-9779</a>
</td>
</tr>
<tr>
<td style="vertical-align: top;; padding: 0px; border-collapse: collapse; padding-right: 5px; font-size: 20px; line-height: 30px; mso-line-height-rule: exactly" class="page-title-pattern-header-container"> <span class="page-title-pattern-header" style="font-family: Arial, sans-serif; padding: 0; font-size: 20px; line-height: 30px; mso-text-raise: 2px; mso-line-height-rule: exactly; vertical-align: middle"> <a href="https://hibernate.atlassian.net/browse/HHH-9779" style="color: #3b73af; text-decoration: none">Collection as parameter in MEMBER OF-clause fail when contains more than 1 element</a> </span>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="email-content-main mobile-expand wrapper-special-margin" style="padding: 0px; border-collapse: collapse; border-left: 1px solid #ccc; border-right: 1px solid #ccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #fff; padding-top: 10px; padding-bottom: 5px">
<table class="keyvalue-table" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Issue Type:
</th>
<td class="has-icon" style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <img src="cid:jira-generated-image-static-bug-c6b0b515-df54-4050-ac80-2b6e8d8561b7" height="16" width="16" border="0" align="absmiddle" alt="Bug" style="vertical-align: text-bottom" /> Bug
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Affects Versions:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
4.3.8
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Assignee:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
Unassigned
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Attachments:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
1 element stacktrace, 2 elements stacktrace
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Components:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
hibernate-core
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Created:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
07/May/2015 07:44 AM
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Environment:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top">
Dialect: org.hibernate.dialect.MySQL5Dialect <br /> Driver: com.mysql.jdbc.Driver <br /> Spring data jpa
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Priority:
</th>
<td class="has-icon" style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <img src="cid:jira-generated-image-static-major-a8a23a5e-3e8a-4e29-a576-510835ef910e" height="16" width="16" border="0" align="absmiddle" alt="Major" style="vertical-align: text-bottom" /> Major
</td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">
Reporter:
</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <a class="user-hover" rel="Jezyk" id="email_Jezyk" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?name=Jezyk" style="color:#6c797f;; color: #3b73af; text-decoration: none">Maciej Jezierski</a>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="email-content-main mobile-expand issue-description-container" style="padding: 0px; border-collapse: collapse; border-left: 1px solid #ccc; border-right: 1px solid #ccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #fff; padding-top: 5px; padding-bottom: 10px">
<table class="text-paragraph-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 2px">
<tr>
<td class="text-paragraph-pattern-container mobile-resize-text " style="padding: 0px; border-collapse: collapse; padding: 0 0 10px 0">
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">I am trying to get query with calling with IN-clause. Probably it treats collection element as a single one. Expected behaviour is to map all elements (N > 1). When we got single element query is fine. Below I present stacktrace and testing case. HQL is generated fine.</p>
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0"><b>GIVEN:</b></p>
<div class="code panel" style="border-width: 1px;; border: 1px solid #ccc; background: #f5f5f5; font-size: 12px; line-height: 1.333; font-family: monospace; border: 1px solid #ccc; -moz-border-radius: 3px 3px 3px 3px; border-radius: 3px 3px 3px 3px; margin: 9px 0">
<div class="codeHeader panelHeader" style="border-bottom-width: 1px;; border-bottom: 1px solid #ccc; padding: 9px 12px">
<b>Category.java</b>
</div>
<div class="codeContent panelContent" style="padding: 9px 12px">
<pre class="code-java" style="margin: 10px 0 0 0; max-height: 30em; overflow: auto; white-space: pre-wrap; word-wrap: normal">
<span class="code-keyword" style="color: #000091">public</span> <span class="code-keyword" style="color: #000091">enum</span> Category {
CATEGORY(1), CATEGORY2(2);
<span class="code-keyword" style="color: #000091">private</span> <span class="code-keyword" style="color: #000091">final</span> <span class="code-object" style="color: #910091">Integer</span> id;
Category(<span class="code-object" style="color: #910091">Integer</span> id) { <span class="code-keyword" style="color: #000091">this</span>.id=id; }
<span class="code-keyword" style="color: #000091">public</span> <span class="code-object" style="color: #910091">Integer</span> getId() { <span class="code-keyword" style="color: #000091">return</span> id; }
}
</pre>
</div>
</div>
<div class="code panel" style="border-width: 1px;; border: 1px solid #ccc; background: #f5f5f5; font-size: 12px; line-height: 1.333; font-family: monospace; border: 1px solid #ccc; -moz-border-radius: 3px 3px 3px 3px; border-radius: 3px 3px 3px 3px; margin: 9px 0">
<div class="codeHeader panelHeader" style="border-bottom-width: 1px;; border-bottom: 1px solid #ccc; padding: 9px 12px">
<b>Comic.java</b>
</div>
<div class="codeContent panelContent" style="padding: 9px 12px">
<pre class="code-java" style="margin: 10px 0 0 0; max-height: 30em; overflow: auto; white-space: pre-wrap; word-wrap: normal">
@Entity
@Table(name = <span class="code-quote" style="color: #009100">"comic"</span>)
<span class="code-keyword" style="color: #000091">public</span> class Comic {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
<span class="code-keyword" style="color: #000091">private</span> <span class="code-object" style="color: #910091">int</span> id;
@Column(name = <span class="code-quote" style="color: #009100">"category"</span>)
@Enumerated(EnumType.STRING)
@ElementCollection(fetch = FetchType.LAZY)
@CollectionTable(name = <span class="code-quote" style="color: #009100">"model_categories"</span>, joinColumns = @JoinColumn(name = <span class="code-quote" style="color: #009100">"model_id"</span>))
<span class="code-keyword" style="color: #000091">private</span> Set<Category> categories;
<span class="code-keyword" style="color: #000091">public</span> <span class="code-object" style="color: #910091">int</span> getId() {
<span class="code-keyword" style="color: #000091">return</span> id;
}
<span class="code-keyword" style="color: #000091">public</span> void setId(<span class="code-object" style="color: #910091">int</span> id) {
<span class="code-keyword" style="color: #000091">this</span>.id = id;
}
<span class="code-keyword" style="color: #000091">public</span> Set<Category> getCategories() {
<span class="code-keyword" style="color: #000091">return</span> categories;
}
<span class="code-keyword" style="color: #000091">public</span> void setCategories(Set<Category> categories) {
<span class="code-keyword" style="color: #000091">this</span>.categories = categories;
}
}
</pre>
</div>
</div>
<div class="code panel" style="border-width: 1px;; border: 1px solid #ccc; background: #f5f5f5; font-size: 12px; line-height: 1.333; font-family: monospace; border: 1px solid #ccc; -moz-border-radius: 3px 3px 3px 3px; border-radius: 3px 3px 3px 3px; margin: 9px 0">
<div class="codeHeader panelHeader" style="border-bottom-width: 1px;; border-bottom: 1px solid #ccc; padding: 9px 12px">
<b>HQL</b>
</div>
<div class="codeContent panelContent" style="padding: 9px 12px">
<pre class="code-java" style="margin: 10px 0 0 0; max-height: 30em; overflow: auto; white-space: pre-wrap; word-wrap: normal">
from Comic c where c.updated is not <span class="code-keyword" style="color: #000091">null</span> and (:category) MEMBER OF c.categories
</pre>
</div>
</div>
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0"><b>WHEN:</b></p>
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">1 element in collection</p>
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0"><b>THEN</b>: return results</p>
<div class="code panel" style="border-width: 1px;; border: 1px solid #ccc; background: #f5f5f5; font-size: 12px; line-height: 1.333; font-family: monospace; border: 1px solid #ccc; -moz-border-radius: 3px 3px 3px 3px; border-radius: 3px 3px 3px 3px; margin: 9px 0">
<div class="codeHeader panelHeader" style="border-bottom-width: 1px;; border-bottom: 1px solid #ccc; padding: 9px 12px">
<b>generated sql</b>
</div>
<div class="codeContent panelContent" style="padding: 9px 12px">
<pre class="code-java" style="margin: 10px 0 0 0; max-height: 30em; overflow: auto; white-space: pre-wrap; word-wrap: normal">
select count(model0_.id) as col_0_0_ from model model0_ where (? in (select categories1_.category from model_categories categories1_ where model0_.id=categories1_.model_id))
</pre>
</div>
</div>
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0"><b>WHEN:</b></p>
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">2 elements in collection</p>
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0"><b>THEN:</b> exception error</p>
<div class="code panel" style="border-width: 1px;; border: 1px solid #ccc; background: #f5f5f5; font-size: 12px; line-height: 1.333; font-family: monospace; border: 1px solid #ccc; -moz-border-radius: 3px 3px 3px 3px; border-radius: 3px 3px 3px 3px; margin: 9px 0">
<div class="codeContent panelContent" style="padding: 9px 12px">
<div class="error">
<span class="error">Unable to find source-code formatter for language: stacktrace.</span> Available languages are: actionscript, html, java, javascript, none, sql, xhtml, xml
</div>
<pre style="margin: 10px 0 0 0; max-height: 30em; overflow: auto; white-space: pre-wrap; word-wrap: normal">
2015-05-07 14:57:54.827 DEBUG 1003 --- [nio-8080-exec-1] o.h.h.internal.ast.QueryTranslatorImpl : parse() - HQL: select count(c) from pl.comic.domain.model.Comic c where c.updated is not <span class="code-keyword" style="color: #000091">null</span> and (:categories_0_, :categories_1_) MEMBER OF c.categories
2015-05-07 14:57:54.830 DEBUG 1003 --- [nio-8080-exec-1] o.h.h.internal.ast.QueryTranslatorImpl : --- HQL AST ---
\-[QUERY] Node: 'query'
+-[SELECT_FROM] Node: 'SELECT_FROM'
| +-[FROM] Node: 'from'
| | \-[RANGE] Node: 'RANGE'
| | +-[DOT] Node: '.'
| | | +-[DOT] Node: '.'
| | | | +-[DOT] Node: '.'
| | | | | +-[DOT] Node: '.'
| | | | | | +-[IDENT] Node: 'pl'
| | | | | | \-[IDENT] Node: 'comic'
| | | | | \-[IDENT] Node: 'domain'
| | | | \-[IDENT] Node: 'model'
| | | \-[IDENT] Node: 'Comic'
| | \-[ALIAS] Node: 'c'
| \-[SELECT] Node: 'select'
| \-[COUNT] Node: 'count'
| \-[IDENT] Node: 'c'
\-[WHERE] Node: 'where'
\-[AND] Node: 'and'
+-[IS_NOT_NULL] Node: 'is not <span class="code-keyword" style="color: #000091">null</span>'
| \-[DOT] Node: '.'
| +-[IDENT] Node: 'c'
| \-[IDENT] Node: 'updated'
\-[IN] Node: 'in'
+-[VECTOR_EXPR] Node: '{vector}'
| +-[COLON] Node: ':'
| | \-[IDENT] Node: 'categories_0_'
| \-[COLON] Node: ':'
| \-[IDENT] Node: 'categories_1_'
\-[IN_LIST] Node: 'inList'
\-[ELEMENTS] Node: 'elements'
\-[DOT] Node: '.'
+-[IDENT] Node: 'c'
\-[IDENT] Node: 'categories'
2015-05-07 14:57:54.831 DEBUG 1003 --- [nio-8080-exec-1] o.h.hql.internal.ast.ErrorCounter : throwQueryException() : no errors
2015-05-07 14:57:54.831 DEBUG 1003 --- [nio-8080-exec-1] o.h.hql.internal.antlr.HqlSqlBaseWalker : select << begin [level=1, statement=select]
2015-05-07 14:57:54.841 DEBUG 1003 --- [nio-8080-exec-1] o.h.hql.internal.ast.tree.FromElement : FromClause{level=1} : pl.comic.domain.model.Comic (c) -> comic0_
2015-05-07 14:57:54.841 DEBUG 1003 --- [nio-8080-exec-1] o.h.h.i.ast.tree.FromReferenceNode : Resolved : c -> comic0_.id
2015-05-07 14:57:54.842 DEBUG 1003 --- [nio-8080-exec-1] o.h.h.i.ast.tree.FromReferenceNode : Resolved : c -> comic0_.id
2015-05-07 14:57:54.842 DEBUG 1003 --- [nio-8080-exec-1] o.h.hql.internal.ast.tree.DotNode : getDataType() : updated -> org.hibernate.type.DateType@476943e7
2015-05-07 14:57:54.842 DEBUG 1003 --- [nio-8080-exec-1] o.h.h.i.ast.tree.FromReferenceNode : Resolved : c.updated -> comic0_.updated
2015-05-07 14:57:54.842 DEBUG 1003 --- [nio-8080-exec-1] o.h.h.i.ast.tree.FromReferenceNode : Resolved : c -> comic0_.id
2015-05-07 14:57:54.842 DEBUG 1003 --- [nio-8080-exec-1] o.h.hql.internal.ast.tree.DotNode : getDataType() : categories -> org.hibernate.type.SetType(pl.comic.domain.model.Comic.categories)
2015-05-07 14:57:54.842 DEBUG 1003 --- [nio-8080-exec-1] o.h.hql.internal.ast.tree.FromElement : FromClause{level=1} : <span class="code-keyword" style="color: #000091">null</span> (<no alias>) -> categories1_
2015-05-07 14:57:54.842 DEBUG 1003 --- [nio-8080-exec-1] o.h.hql.internal.ast.tree.FromClause : addCollectionJoinFromElementByPath() : c.categories -> comic_categories
2015-05-07 14:57:54.842 DEBUG 1003 --- [nio-8080-exec-1] o.h.hql.internal.ast.tree.DotNode : dereferenceCollection() : Created <span class="code-keyword" style="color: #000091">new</span> FROM element <span class="code-keyword" style="color: #000091">for</span> c.categories : comic_categories categories1_
2015-05-07 14:57:54.842 DEBUG 1003 --- [nio-8080-exec-1] o.h.hql.internal.ast.tree.MethodNode : Creating elements <span class="code-keyword" style="color: #000091">for</span> c.categories[].elements
2015-05-07 14:57:54.842 DEBUG 1003 --- [nio-8080-exec-1] o.h.h.internal.ast.tree.FromElementType : toColumns(categories1_,elements) : subquery = select categories1_.category from comic_categories categories1_ where comic0_.id=categories1_.comic_id
2015-05-07 14:57:54.843 DEBUG 1003 --- [nio-8080-exec-1] o.h.hql.internal.antlr.HqlSqlBaseWalker : select : finishing up [level=1, statement=select]
2015-05-07 14:57:54.843 DEBUG 1003 --- [nio-8080-exec-1] o.h.hql.internal.ast.HqlSqlWalker : processQuery() : ( SELECT ( {select clause} ( count comic0_.id ) ) ( FromClause{level=1} ) ( where ( and ( is not <span class="code-keyword" style="color: #000091">null</span> ( comic0_.updated comic0_.id updated ) ) ( in ( {vector} ? ? ) ( inList ( select categories1_.category from comic_categories categories1_ where comic0_.id=categories1_.comic_id ( . comic0_.id categories ) ) ) ) ) ) )
2015-05-07 14:57:54.843 DEBUG 1003 --- [nio-8080-exec-1] o.h.hql.internal.ast.util.JoinProcessor : Using FROM fragment [comic comic0_]
2015-05-07 14:57:54.843 DEBUG 1003 --- [nio-8080-exec-1] o.h.hql.internal.antlr.HqlSqlBaseWalker : select >> end [level=1, statement=select]
2015-05-07 14:57:54.843 DEBUG 1003 --- [nio-8080-exec-1] o.h.h.internal.ast.QueryTranslatorImpl : --- SQL AST ---
\-[SELECT] QueryNode: 'SELECT' querySpaces (comic_categories,comic)
+-[SELECT_CLAUSE] SelectClause: '{select clause}'
| +-[COUNT] CountNode: 'count'
| | \-[ALIAS_REF] IdentNode: 'comic0_.id' {alias=c, className=pl.comic.domain.model.Comic, tableAlias=comic0_}
| \-[SELECT_COLUMNS] SqlNode: ' as col_0_0_'
+-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=2, fromElementByClassAlias=[c], fromElementByTableAlias=[categories1_, comic0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[c.categories], impliedElements=[]}
| +-[FROM_FRAGMENT] FromElement: 'comic comic0_' FromElement{explicit,collection join,not a fetch join,fetch non-lazy properties,classAlias=c,role=<span class="code-keyword" style="color: #000091">null</span>,tableName=comic,tableAlias=comic0_,origin=<span class="code-keyword" style="color: #000091">null</span>,columns={,className=pl.comic.domain.model.Comic}}
| \-[FROM_FRAGMENT] ImpliedFromElement: '' ImpliedFromElement{implied,collection join,not a fetch join,fetch non-lazy properties,classAlias=<span class="code-keyword" style="color: #000091">null</span>,role=pl.comic.domain.model.Comic.categories,tableName={none},tableAlias=categories1_,origin=comic comic0_,columns={,className=<span class="code-keyword" style="color: #000091">null</span>}}
\-[WHERE] SqlNode: 'where'
\-[AND] SqlNode: 'and'
+-[IS_NOT_NULL] IsNotNullLogicOperatorNode: 'is not <span class="code-keyword" style="color: #000091">null</span>'
| \-[DOT] DotNode: 'comic0_.updated' {propertyName=updated,dereferenceType=PRIMITIVE,getPropertyPath=updated,path=c.updated,tableAlias=comic0_,className=pl.comic.domain.model.Comic,classAlias=c}
| +-[ALIAS_REF] IdentNode: 'comic0_.id' {alias=c, className=pl.comic.domain.model.Comic, tableAlias=comic0_}
| \-[IDENT] IdentNode: 'updated' {originalText=updated}
\-[IN] InLogicOperatorNode: 'in'
+-[VECTOR_EXPR] SqlNode: '{vector}'
| +-[NAMED_PARAM] ParameterNode: '?' {name=categories_0_, expectedType=<span class="code-keyword" style="color: #000091">null</span>}
| \-[NAMED_PARAM] ParameterNode: '?' {name=categories_1_, expectedType=<span class="code-keyword" style="color: #000091">null</span>}
\-[IN_LIST] SqlNode: 'inList'
\-[SQL_TOKEN] CollectionFunction: 'select categories1_.category from comic_categories categories1_ where comic0_.id=categories1_.comic_id' {method=elements,selectColumns=[select categories1_.category from comic_categories categories1_ where comic0_.id=categories1_.comic_id],fromElement=categories1_}
\-[DOT] DotNode: '.' {propertyName=categories,dereferenceType=COLLECTION,getPropertyPath=categories,path=c.categories,tableAlias=categories1_,className=<span class="code-keyword" style="color: #000091">null</span>,classAlias=<span class="code-keyword" style="color: #000091">null</span>}
+-[ALIAS_REF] IdentNode: 'comic0_.id' {alias=c, className=pl.comic.domain.model.Comic, tableAlias=comic0_}
\-[IDENT] IdentNode: 'categories' {originalText=categories}
2015-05-07 14:57:54.843 DEBUG 1003 --- [nio-8080-exec-1] o.h.hql.internal.ast.ErrorCounter : throwQueryException() : no errors
2015-05-07 14:57:54.844 DEBUG 1003 --- [nio-8080-exec-1] o.h.h.internal.ast.QueryTranslatorImpl : HQL: select count(c) from pl.comic.domain.model.Comic c where c.updated is not <span class="code-keyword" style="color: #000091">null</span> and (:categories_0_, :categories_1_) MEMBER OF c.categories
2015-05-07 14:57:54.844 DEBUG 1003 --- [nio-8080-exec-1] o.h.h.internal.ast.QueryTranslatorImpl : SQL: select count(comic0_.id) as col_0_0_ from comic comic0_ where (comic0_.updated is not <span class="code-keyword" style="color: #000091">null</span>) and ((? , ?) in (select categories1_.category from comic_categories categories1_ where comic0_.id=categories1_.comic_id))
2015-05-07 14:57:54.844 DEBUG 1003 --- [nio-8080-exec-1] o.h.hql.internal.ast.ErrorCounter : throwQueryException() : no errors
2015-05-07 14:57:54.852 DEBUG 1003 --- [nio-8080-exec-1] org.hibernate.SQL : select count(comic0_.id) as col_0_0_ from comic comic0_ where (comic0_.updated is not <span class="code-keyword" style="color: #000091">null</span>) and ((? , ?) in (select categories1_.category from comic_categories categories1_ where comic0_.id=categories1_.comic_id))
Hibernate: select count(comic0_.id) as col_0_0_ from comic comic0_ where (comic0_.updated is not <span class="code-keyword" style="color: #000091">null</span>) and ((? , ?) in (select categories1_.category from comic_categories categories1_ where comic0_.id=categories1_.comic_id))
2015-05-07 14:57:54.852 DEBUG 1003 --- [nio-8080-exec-1] o.h.e.j.internal.LogicalConnectionImpl : Obtaining JDBC connection
2015-05-07 14:57:54.852 DEBUG 1003 --- [nio-8080-exec-1] o.h.e.j.internal.LogicalConnectionImpl : Obtained JDBC connection
2015-05-07 14:57:54.883 DEBUG 1003 --- [nio-8080-exec-1] o.h.engine.jdbc.spi.SqlExceptionHelper : could not extract ResultSet [n/a]
java.sql.SQLException: Operand should contain 2 column(s)
</pre>
</div>
</div>
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0"><b>EXPECTED:</b> return results</p>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="email-content-main mobile-expand " style="padding: 0px; border-collapse: collapse; border-left: 1px solid #ccc; border-right: 1px solid #ccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #fff">
<table id="actions-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 1px">
<tr>
<td id="actions-pattern-container" valign="middle" style="padding: 0px; border-collapse: collapse; padding: 10px 0 10px 24px; vertical-align: middle; padding-left: 0">
<table align="left" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<td class="actions-pattern-action-icon-container" style="padding: 0px; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 0px; vertical-align: middle"> <a href="https://hibernate.atlassian.net/browse/HHH-9779#add-comment" target="_blank" title="Add Comment" style="color: #3b73af; text-decoration: none"> <img class="actions-pattern-action-icon-image" src="cid:jira-generated-image-static-comment-icon-5c0e406b-7c53-4d7f-aa2d-536cd4d1b352" alt="Add Comment" title="Add Comment" height="16" width="16" border="0" style="vertical-align: middle" /> </a>
</td>
<td class="actions-pattern-action-text-container" style="padding: 0px; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 4px; padding-left: 5px"> <a href="https://hibernate.atlassian.net/browse/HHH-9779#add-comment" target="_blank" title="Add Comment" style="color: #3b73af; text-decoration: none">Add Comment</a>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<!-- there needs to be content in the cell for it to render in some clients -->
<tr>
<td class="email-content-rounded-bottom mobile-expand" style="padding: 0px; border-collapse: collapse; color: #fff; padding: 0 15px 0 16px; height: 5px; line-height: 5px; background-color: #fff; border-top: 0; border-left: 1px solid #ccc; border-bottom: 1px solid #ccc; border-right: 1px solid #ccc; border-bottom-right-radius: 5px; border-bottom-left-radius: 5px; mso-line-height-rule: exactly">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td id="footer-pattern" style="padding: 0px; border-collapse: collapse; padding: 12px 20px">
<table id="footer-pattern-container" cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<td id="footer-pattern-text" class="mobile-resize-text" width="100%" style="padding: 0px; border-collapse: collapse; color: #999; font-size: 12px; line-height: 18px; font-family: Arial, sans-serif; mso-line-height-rule: exactly; mso-text-raise: 2px">
This message was sent by Atlassian JIRA <span id="footer-build-information">(v6.5-OD-03-002#65000-<span title="b8f65f822a3fd2ca02be441f51a3c335a581ff1e" data-commit-id="b8f65f822a3fd2ca02be441f51a3c335a581ff1e}">sha1:b8f65f8</span>)</span>
</td>
<td id="footer-pattern-logo-desktop-container" valign="top" style="padding: 0px; border-collapse: collapse; padding-left: 20px; vertical-align: top">
<table style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tr>
<td id="footer-pattern-logo-desktop-padding" style="padding: 0px; border-collapse: collapse; padding-top: 3px"> <img id="footer-pattern-logo-desktop" src="cid:jira-generated-image-static-footer-desktop-logo-4d707d65-cd0c-4a18-b8cf-47299138a2c8" alt="Atlassian logo" title="Atlassian logo" width="169" height="36" class="image_fix" />
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>