Hello,

The nHibernate JIRA is currently inaccessible, and I couldn't find any mention of this issue on the forum or by searching cached pages of the JIRA.

Name and version of the database you are using:
SQL Server 2000

Hibernate version:
1.0.2

Code between sessionFactory.openSession() and session.close():
IList mappedObjectCollection = session.CreateCriteria(typeof(T)).List();

session.CreateQuery("from T t where t in :objectsToLoad")
.SetParameterList("objectsToLoad", mappedObjectCollection, NHibernateUtil.Entity(typeof(T)))
.List();


The mapping of the T class uses the GUID generator for its primary key, mapped to a property called "Key". When I execute the code with the SetParameterList directive, I notice that the generated SQL is incorrect (see below). I've replaced the selected columns of the T with '*' class for brevity.

The generated SQL (show_sql=true):

exec sp_executesql
N'select * from T t0_ where (t0_.Key in @p0 , @p1 , @p2)',
N'@p0 uniqueidentifier,@p1 uniqueidentifier,@p2 uniqueidentifier',
@p0 = 'F44B4D98-311C-4800-B600-9C7499C7AF22',
@p1 = '36FFAC14-61F7-4673-985C-7DF8BE21D9AC',
@p2 = 'A7EBCDB0-36C2-48D3-B8DD-9CE56568BD56'


Note the first parenthesis in the where clause -- it is in the wrong location. The parenthesis should be between the 'in' directive and the first parameter.

Hi,

Did you executed it?
If so, what happens?

Yes, I executed the code. The SQL is rejected by SQL Server with the error:

The expected syntax in the where clause is:

Sergey was kind to note in the JIRA issue I opened that this issue is easily mitigated by enclosing the parameter ':objectsToLoad' in parentheses.

Thanks!