It is probably being created in the re-linq dll, which is why you do not see it being created easily.
What happens if you try using a parameter instead of a direct boolean value? For example: bool trueVal = true; var query1 = session.Query<Person>().Where(p => p.IsAngry == trueVal); Assert.That(query1.Count(), Is.EqualTo(1)); John Davidson On Mon, Jan 10, 2011 at 4:21 PM, Joe.Carr <[email protected]> wrote: > Hello, > Thanks for the reply. I updated to the most recent code, and it > appears the problem still exists in Postgres. I slightly modified the > test fixture for 2441, by adding boolean property to the model. So now > I can check : > > var query1 = session.Query<Person>().Where(p => p.IsAngry == true); > Assert.That(query1.Count(), Is.EqualTo(1)); > > The test succeeds, but the SQL generated is : > > select > cast(count(*) as int4) as col_0_0_ > from > Person person0_ > where > case > when person0_.IsAngry=TRUE then TRUE > else FALSE > end=case > when :p0=TRUE then TRUE > else FALSE > end; > :p0 = True [Type: Boolean (0)] > > I tried stepping through to find where this case statement is > generated, but haven't been able to track it down as yet. > > Could anyone point me in the right direction? Thanks again for the > help... > > -Joe > > On Jan 9, 5:36 pm, José F. Romaniello <[email protected]> wrote: > > not sure, but i think it was fixed recently: > http://216.121.112.228/browse/NH-2456 > > > > 2011/1/9 Joe.Carr <[email protected]> > > > > > > > > > > > > > > > > > The linq query : > > > > > var query = (from b in session.Query<Entity>() > > > where b.Deleted == false > > > select b); > > > > > return query.Count(); > > > > > produces (PostGreSQL dialect): > > > > > select cast(count(* ) as int4) as col_0_0_ > > > from "entity" entity0_ > > > where case > > > when entity0_.Deleted = TRUE then 1 > > > else 0 > > > end = case > > > when 0 /* :p0 */ = 1 then 1 > > > else 0 > > > end > > > > > Any idea how I might be able to get it to read : > > > > > select cast(count(* ) as int4) as col_0_0_ > > > from "entity" entity0_ > > > where entity0_.Deleted = FALSE > > > > > The hbm produced by Fluent NHibernate for the Deleted column is : > > > > > <property name="Deleted" type="System.Boolean, mscorlib, > > > Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> > > > <column name="Deleted" /> > > > </property> > > > > > Thanks beforehand for any help! > > > ? > > > > > -- > > > You received this message because you are subscribed to the Google > Groups > > > "nhusers" group. > > > To post to this group, send email to [email protected]. > > > To unsubscribe from this group, send email to > > > [email protected]<nhusers%[email protected]> > <nhusers%[email protected]<nhusers%[email protected]>> > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/nhusers?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
