[ 
https://issues.apache.org/jira/browse/CALCITE-4424?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17244630#comment-17244630
 ] 

Jiatao Tao commented on CALCITE-4424:
-------------------------------------

Hi [~julianhyde], functions like current_time/current_date may be 
deterministic, but rand must not be deterministic, we've met this: CALCITE-4413 
and we need a non-deterministic function list, current only 
SqlSequenceValueOperator override isDeterministic. 

> Complete non-deterministic function
> -----------------------------------
>
>                 Key: CALCITE-4424
>                 URL: https://issues.apache.org/jira/browse/CALCITE-4424
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>            Reporter: Jiatao Tao
>            Assignee: Jiatao Tao
>            Priority: Major
>              Labels: pull-request-available
>          Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> Current only SqlSequenceValueOperator override isDeterministic, func like 
> RAND doesn't override isDeterministic, these func seems are not 
> deterministic(the list comes from "isDynamicFunction"):
> 1. SqlAbstractTimeFunction
> 2. SqlBaseContextVariable
> 3. SqlCurrentDateFunction
> 4. SqlRandFunction
> 5. SqlRandIntegerFunction
>  
>   



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to