[nhibernate-issues] [NHJIRA] Commented: (NH-2540) Linq ignoring configured query-substitutions

[Yogesh J. (JIRA) <nh...@gm...>]

    [ http://216.121.112.228/browse/NH-2540?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=20571#action_20571 ] 

Yogesh Jagota commented on NH-2540:
-----------------------------------

When I said 2.1 behaved the same way, it meant it also passed addInvoices as Boolean and not String. So, I don't think it is standard behavior.

> Linq ignoring configured query-substitutions
> --------------------------------------------
>
>                 Key: NH-2540
>                 URL: http://216.121.112.228/browse/NH-2540
>             Project:  NHibernate
>          Issue Type: Bug
>          Components: Linq Provider
>    Affects Versions: 3.0.0.GA
>            Reporter: Yogesh Jagota
>            Assignee: Patrick Earl
>            Priority: Major
>             Fix For: 3.1.0
>
>         Attachments: Generated SQL.txt
>
>
> 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. Generated SQL is attached.
> Reason:
> 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 the convention. 
> From generated SQL:
> "!addInvoices" is passed as a string in the sql query and int in the previous version:
> 3.0.0.1002: @p1 = True [Type: Int32 (0)] 
> 3.0.0.4000: @p1 = 'True' [Type: String (0)] 
> Also, the IsCreditNote database field is compared to 'true' and 'false' in the new version, and with 1 and 0 in the previous version.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://216.121.112.228/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira