If so try to check our JIRA before add a new ticket (IIRC it should be fixed but I'm not completely sure)
On Thu, Feb 17, 2011 at 10:05 AM, Yogesh Jagota <[email protected]>wrote: > I know what the negation operator means. > > What I wanted to say was, The latter version always returns the result > as this, regardless of the value of addInvoices... > where b.Customer == AddressedToCustomer && b.IsCreditNote == false > > I found out the reason. The reason is that I am using a convention to > convert bools into ints (true=1, false=0). The previous version is > doing this conversion, the newer version isn't. The bool is converted > to a string in the newer version (as is the default in sqlite driver), > but it should be converted to int according to my convention. > > See how "!addInvoices" is passed as a parameter in the sql query: > 3.0.0.1002: @p1 = True [Type: Int32 (0)] > 3.0.0.4000: @p1 = 'True' [Type: String (0)] > > Also, the IsCreditNote is checked using 'true' and 'false' in the new > version, and with 1 and 0 in the previous version. > > The summary is, 3.0.0.4000 is not taking my conventions into account. > I haven't changed anything except the references to the dlls. > > I am using fluent hibernate, if that matters. > > Thanks again. > > On Feb 17, 5:40 pm, Fabio Maulo <[email protected]> wrote: > > == !addInvoices mean: equals to the negation of addInvoices > > > > On Thu, Feb 17, 2011 at 7:57 AM, Yogesh Jagota > > <[email protected]>wrote: > > > > > > > > > > > > > > > > > > > > > I have this query: > > > > > var items = (from b in session.Query<InvoiceDetail>() > > > where b.Customer == AddressedToCustomer && > > > b.IsCreditNote == ! > > > addInvoices > > > orderby b.DueDate , b.InvoiceNumber > > > select b).ToList(); > > > > > This query works fine on 3.0.0.1002, but fails on 3.0.0.4000. The > > > latter version always returns the result as if addInvoices was always > > > true. > > > > > SQL Generated in 3.0.0.1002: > > > 2011-02-17 15:55:43,612 DEBUG select invoicedet0_.Id as Id3_, > > > invoicedet0_.InvoiceNumber as InvoiceN2_3_, > > > invoicedet0_.DocumentNumber as Document3_3_, invoicedet0_.DocumentDate > > > as Document4_3_, invoicedet0_.DueDate as DueDate3_, > > > invoicedet0_.DivisionDetails as Division6_3_, invoicedet0_.IsInvoice > > > as IsInvoice3_, invoicedet0_.IsCreditNote as IsCredit8_3_, > > > invoicedet0_.OriginalAmount as Original9_3_, invoicedet0_.Amount as > > > Amount3_, invoicedet0_.LRNo as LRNo3_, invoicedet0_.LRDate as > > > LRDate3_, invoicedet0_.DispatchedBy as Dispatc13_3_, > > > invoicedet0_.CreditDays as CreditDays3_, invoicedet0_.CustomerId as > > > CustomerId3_ from InvoiceDetails invoicedet0_ where > > > ((invoicedet0_.CustomerId is null) and (@p0 is null) or > > > invoicedet0_.CustomerId=@p0) and case when invoicedet0_.IsCreditNote=1 > > > then 1 else 0 end=case when @p1=1 then 1 else 0 end order by > > > invoicedet0_.DueDate asc, invoicedet0_.InvoiceNumber asc;@p0 = 101790 > > > [Type: Int32 (0)], @p1 = False [Type: Int32 (0)] > > > 2011-02-17 15:55:43,618 DEBUG select invoicedet0_.Id as Id3_, > > > invoicedet0_.InvoiceNumber as InvoiceN2_3_, > > > invoicedet0_.DocumentNumber as Document3_3_, invoicedet0_.DocumentDate > > > as Document4_3_, invoicedet0_.DueDate as DueDate3_, > > > invoicedet0_.DivisionDetails as Division6_3_, invoicedet0_.IsInvoice > > > as IsInvoice3_, invoicedet0_.IsCreditNote as IsCredit8_3_, > > > invoicedet0_.OriginalAmount as Original9_3_, invoicedet0_.Amount as > > > Amount3_, invoicedet0_.LRNo as LRNo3_, invoicedet0_.LRDate as > > > LRDate3_, invoicedet0_.DispatchedBy as Dispatc13_3_, > > > invoicedet0_.CreditDays as CreditDays3_, invoicedet0_.CustomerId as > > > CustomerId3_ from InvoiceDetails invoicedet0_ where > > > ((invoicedet0_.CustomerId is null) and (@p0 is null) or > > > invoicedet0_.CustomerId=@p0) and case when invoicedet0_.IsCreditNote=1 > > > then 1 else 0 end=case when @p1=1 then 1 else 0 end order by > > > invoicedet0_.DueDate asc, invoicedet0_.InvoiceNumber asc;@p0 = 101790 > > > [Type: Int32 (0)], @p1 = True [Type: Int32 (0)] > > > > > SQL Generated in 3.0.0.4000: > > > 2011-02-17 16:22:15,275 DEBUG select invoicedet0_.Id as Id3_, > > > invoicedet0_.InvoiceNumber as InvoiceN2_3_, > > > invoicedet0_.DocumentNumber as Document3_3_, invoicedet0_.DocumentDate > > > as Document4_3_, invoicedet0_.DueDate as DueDate3_, > > > invoicedet0_.DivisionDetails as Division6_3_, invoicedet0_.IsInvoice > > > as IsInvoice3_, invoicedet0_.IsCreditNote as IsCredit8_3_, > > > invoicedet0_.OriginalAmount as Original9_3_, invoicedet0_.Amount as > > > Amount3_, invoicedet0_.LRNo as LRNo3_, invoicedet0_.LRDate as > > > LRDate3_, invoicedet0_.DispatchedBy as Dispatc13_3_, > > > invoicedet0_.CreditDays as CreditDays3_, invoicedet0_.CustomerId as > > > CustomerId3_ from InvoiceDetails invoicedet0_ where > > > invoicedet0_.CustomerId=@p0 and case when invoicedet0_.IsCreditNote=1 > > > then 'true' else 'false' end=case when @p1='true' then 'true' else > > > 'false' end order by invoicedet0_.DueDate asc, > > > invoicedet0_.InvoiceNumber asc;@p0 = 101790 [Type: Int32 (0)], @p1 = > > > 'False' [Type: String (0)] > > > 2011-02-17 16:22:15,279 DEBUG select invoicedet0_.Id as Id3_, > > > invoicedet0_.InvoiceNumber as InvoiceN2_3_, > > > invoicedet0_.DocumentNumber as Document3_3_, invoicedet0_.DocumentDate > > > as Document4_3_, invoicedet0_.DueDate as DueDate3_, > > > invoicedet0_.DivisionDetails as Division6_3_, invoicedet0_.IsInvoice > > > as IsInvoice3_, invoicedet0_.IsCreditNote as IsCredit8_3_, > > > invoicedet0_.OriginalAmount as Original9_3_, invoicedet0_.Amount as > > > Amount3_, invoicedet0_.LRNo as LRNo3_, invoicedet0_.LRDate as > > > LRDate3_, invoicedet0_.DispatchedBy as Dispatc13_3_, > > > invoicedet0_.CreditDays as CreditDays3_, invoicedet0_.CustomerId as > > > CustomerId3_ from InvoiceDetails invoicedet0_ where > > > invoicedet0_.CustomerId=@p0 and case when invoicedet0_.IsCreditNote=1 > > > then 'true' else 'false' end=case when @p1='true' then 'true' else > > > 'false' end order by invoicedet0_.DueDate asc, > > > invoicedet0_.InvoiceNumber asc;@p0 = 101790 [Type: Int32 (0)], @p1 = > > > 'True' [Type: String (0)] > > > > > Can somebody help me in this regard. > > > > > Thanks. > > > > > -- > > > 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. > > > > -- > > Fabio Maulo > > -- > 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. > > -- Fabio Maulo -- 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.
