NHibernate.ADOException
could not execute query [ select top 300 e.Id as Id3_0_, e.Name as Name3_0_, e.Published as Published3_0_, e.Summary as Summary3_0_, e.Title as Title3_0_, e.IsDiscussionEnabled as IsDiscus6_3_0_, e.MetaDescription as MetaDesc7_3_0_, e.MetaTitle as MetaTitle3_0_, e.HideChrome as HideChrome3_0_, e.Status as Status3_0_, e.PageTemplate as PageTem11_3_0_, (SELECT COUNT(*) from Comment where Comment.EntryID = e.ID and Comment.Status = 1) as formula0_0_ from [Entry] e inner join ( select z.*, [Rank] from [Entry] z inner join [Revision] rv on z.Id = rv.EntryId inner join CONTAINSTABLE([Revision], *, @p0) as searchTable1 on searchTable1.[Key] = rv.Id union all select z.*, [Rank] from [Entry] z inner join CONTAINSTABLE([Entry], *, @p1) as searchTable2 on searchTable2.[Key] = z.Id ) as Entries on Entries.Id = e.Id where e.Status != 'Private' order by [Rank] desc ] Name:searchString - Value:"search*" [SQL: select top 300 e.Id as Id3_0_, e.Name as Name3_0_, e.Published as Published3_0_, e.Summary as Summary3_0_, e.Title as Title3_0_, e.IsDiscussionEnabled as IsDiscus6_3_0_, e.MetaDescription as MetaDesc7_3_0_, e.MetaTitle as MetaTitle3_0_, e.HideChrome as HideChrome3_0_, e.Status as Status3_0_, e.PageTemplate as PageTem11_3_0_, (SELECT COUNT(*) from Comment where Comment.EntryID = e.ID and Comment.Status = 1) as formula0_0_ from [Entry] e inner join ( select z.*, [Rank] from [Entry] z inner join [Revision] rv on z.Id = rv.EntryId inner join CONTAINSTABLE([Revision], *, @p0) as searchTable1 on searchTable1.[Key] = rv.Id union all select z.*, [Rank] from [Entry] z inner join CONTAINSTABLE([Entry], *, @p1) as searchTable2 on searchTable2.[Key] = z.Id ) as Entries on Entries.Id = e.Id where e.Status != 'Private' order by [Rank] desc]
Source Object: at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)