NH.Search and query produced

0 views
Skip to first unread message

JozefSevcik

unread,
Jan 29, 2009, 12:55:49 PM1/29/09
to nhusers
Hi all,

just starting with NH.Search, NH trunk, NH.Search trunk.
using (IFullTextSession s = ...
{
string q = "Code:ALPHA";
var result = s.CreateFullTextQuery<Customer>(q)
.List<Customer>();
}

250 Documents in Lucene are relevant for this query, for example.
Problem:
Expected 1 SQL query produced by NHibernate:
select a,b,c from Customer where Id in (IDs-returned-by-lucene)

But instead of this, NHibernate produces 250 SQL queries,
each with 'where id = x', namely for every Id returned from lucene it
produces query.

Am I missing something ?

Thank you !

Ayende Rahien

unread,
Jan 29, 2009, 2:15:12 PM1/29/09
to nhu...@googlegroups.com
 I think this is a bug.

Jozef Sevcik

unread,
Jan 29, 2009, 2:20:13 PM1/29/09
to nhu...@googlegroups.com
Thanks for info. Should I raise JIRA for that ?

Thanks

2009/1/29 Ayende Rahien <aye...@ayende.com>:
--
S pozdravom / Best regards,

Jozef Ševčík
sev...@styxys.com

+420 608 782 813
+420 222 364 769

Ayende Rahien

unread,
Jan 29, 2009, 2:23:36 PM1/29/09
to nhu...@googlegroups.com
yes

2009/1/29 Jozef Sevcik <sev...@styxys.com>

JozefSevcik

unread,
Jan 30, 2009, 9:53:01 AM1/30/09
to nhusers
Thanks.
Issue+patch+comment: http://nhjira.koah.net/browse/NHSR-17
Reply all
Reply to author
Forward
0 new messages