[ http://issues.apache.org/jira/browse/DERBY-608?page=comments#action_12366561 ]
Mamta A. Satoor commented on DERBY-608: --------------------------------------- In the doc hit that you found, Reference Guide topic "Where dynamic parameters are allowed", we should change number 13 to say that dynamic parameters are allowed as the operand of the unary operator - or +. And then we can include following eg create table t1 (c11 int, c12 smallint, c13 double, c14 char(3)) select * from t1 where c11 between -? and +? Type of both the unary parameters in the sql above is INT based on the context in which they are used ie because C11 is INT, the unary parameters also get the type INT. Also, at the end of this topic, there is an example which mentions that unary dynamic parameters are not allowed. That should be changed to. My suggestion is that we should remove the example used there. "Once the type of a dynamic parameter is determined based on the expression it is in, that expression is allowed anywhere it would normally be allowed if it did not include a dynamic parameter." > Documentation will require changes once dynamic parameters are supported for > unary minus and unary plus. > -------------------------------------------------------------------------------------------------------- > > Key: DERBY-608 > URL: http://issues.apache.org/jira/browse/DERBY-608 > Project: Derby > Type: Sub-task > Components: Documentation > Versions: 10.2.0.0 > Reporter: Mamta A. Satoor > Fix For: 10.2.0.0 > > Once Derby-582 is resolved, the documentation for unary -/+ should be updated > to reflect support for dynamic parameters for unary +/-. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
