[
https://issues.apache.org/jira/browse/PHOENIX-1516?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14244484#comment-14244484
]
Julian Hyde commented on PHOENIX-1516:
--------------------------------------
I see flaws in Oracle [
https://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_random.htm#ARPLS040 ],
Postgres [ http://www.postgresql.org/docs/8.2/static/functions-math.html ],
MSSQL [ http://msdn.microsoft.com/en-us/library/ms177610.aspx ] specifications.
Liking MySQL's specification [
http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_rand
] the most. DB2 [
http://www-01.ibm.com/support/knowledgecenter/SSEPEK_11.0.0/com.ibm.db2z11.doc.sqlref/src/tpc/db2z_bif_rand.dita
] is OK except that it makes rand() the same as rand(0).
> Add RANDOM built-in function
> ----------------------------
>
> Key: PHOENIX-1516
> URL: https://issues.apache.org/jira/browse/PHOENIX-1516
> Project: Phoenix
> Issue Type: Bug
> Reporter: Lars Hofhansl
> Assignee: Lars Hofhansl
> Attachments: 1516.txt
>
>
> I often find it useful to generate some rows with random data.
> Here's a simple RANDOM() function that we could use for that.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
