[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16610180#comment-16610180 ]
Vladimir Sitnikov commented on CALCITE-2535: -------------------------------------------- Oh, I think I know an example: {code:sql}select coalesce(case when count(*)>0 then 1 else null end, 0/0) from values(1){code} Not sure what to put instead of ..., but the idea is as follows: during regular execution, 0/0 will never be reached. However constant-folder might be too eager to constant-fold "0/0" computation making the SQL to fail. > Runtime failure check not working in SqlTesterImpl.java > ------------------------------------------------------- > > Key: CALCITE-2535 > URL: https://issues.apache.org/jira/browse/CALCITE-2535 > Project: Calcite > Issue Type: Bug > Components: core > Reporter: Hongze Zhang > Assignee: Julian Hyde > Priority: Major > > Problem at SqlTesterImpl#checkFails: > When argument "runtime" is specified as true, error assertion and error > message matching will not be performed. > This issue could result in wrong test result in SqlOperatorBaseTest. -- This message was sent by Atlassian JIRA (v7.6.3#76005)