db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-608) Documentation will require changes once dynamic parameters are supported for unary minus and unary plus.
Date Wed, 15 Feb 2006 23:46:45 GMT
    [ 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


Mime
View raw message