db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3297) Document SIGN, SQRT, RAND, RANDOM, COSH, COT, SINH and TANH functions.
Date Thu, 10 Jan 2008 18:37:34 GMT

    [ https://issues.apache.org/jira/browse/DERBY-3297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12557746#action_12557746
] 

Daniel John Debrunner commented on DERBY-3297:
----------------------------------------------

Actually RAND is not a synonym for RANDOM.

ij> values rand();
ERROR 42Y03: 'RAND' is not recognized as a function or procedure.

RAND is a broken function that takes an INTEGER seed parameter. It's to match the JDBC escaped
function spec but it's broken because it will always return the same value for a given seed.

> Document SIGN, SQRT, RAND, RANDOM, COSH, COT, SINH and TANH functions.
> ----------------------------------------------------------------------
>
>                 Key: DERBY-3297
>                 URL: https://issues.apache.org/jira/browse/DERBY-3297
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>            Reporter: Daniel John Debrunner
>            Assignee: Thomas Nielsen
>            Priority: Minor
>         Attachments: d3297-doc-1.diff, d3297-doc-1.stat, d3297-doc-2.diff, rreffunccosh.html,
rreffunccot.html, rreffuncrand.html, rreffuncrandom.html, rreffuncsign.html, rreffuncsinh.html,
rreffunctanh.html, toc.html
>
>
> These functions were added by DERBY-1808

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


Mime
View raw message