[ 
https://issues.apache.org/jira/browse/DERBY-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12502938
 ] 

Mamta A. Satoor commented on DERBY-2777:
----------------------------------------

Collation does not apply to parameters to "+","-","SQRT", "ABS/ABSVAL" because 
they only take numeric values.

DERBY-2777
Unary arithmetic operators "+","-","SQRT", "ABS/ABSVAL" only take numeric 
parameters and hence no need to worry about collation information on parameters 
to these operators.

> Parameters should take their collation from the context in which they are 
> getting used rather than the current compilation schema
> ---------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2777
>                 URL: https://issues.apache.org/jira/browse/DERBY-2777
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.3.0.0
>            Reporter: Mamta A. Satoor
>            Assignee: Mamta A. Satoor
>
> With revision 542646, changes were made so that parameters will take their 
> collation from current compilation schema. But based on the following thread 
> http://www.nabble.com/Collation-and-parameter-markers-(-)-tf3866040.html , 
> using the collation from the context would be the correct thing to do for the 
> parameters.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to