[nhibernate-issues] [NHJIRA] Updated: (NH-2318) Template functions fail with certain combinations of arguments.

[Patrick E. (JIRA) <nh...@gm...>]

     [ http://216.121.112.228/browse/NH-2318?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Patrick Earl updated NH-2318:
-----------------------------

    Attachment: ISqlFunctionParameterReordering.patch

ISqlFunctionParameterReordering.patch combines all previous changes and will apply cleanly against the current trunk.  IMHO, this patch provides significant benefit as it provides a straight-forward path for the LINQ provider to delegate the handling of null-safe equality to the dialect.  This would allow databases to use "<=>" and "IS NOT DISTINCT FROM" instead of the very long, and likely unperformant, "(A is null and B is null) or (A is not null and B is not null and A = B)".

> Template functions fail with certain combinations of arguments.
> ---------------------------------------------------------------
>
>                 Key: NH-2318
>                 URL: http://216.121.112.228/browse/NH-2318
>             Project:  NHibernate
>          Issue Type: Bug
>          Components: Core
>    Affects Versions: 3.0.0.Alpha2
>            Reporter: Patrick Earl
>            Assignee: Richard Brown
>         Attachments: HqlParameterReordering.patch, ISqlFunctionParameterReordering.patch, SqlFunctionProjectionFix.patch, TrimFunctionsTest.patch, TrimFunctionsTest2.patch
>
>
> Some template functions such as TRIM() fail since they use repeated arguments in the template.  Additionally, the LEADING and TRAILING trim emulation functions have their ltrim and rtrim reversed.  Included is a unit test that demonstrates that failure.

-- 
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