[jira] [Created] (CALCITE-4256) RexSimplify should not simplify P AND P to P, if it contains a call to RAND or RAND_INTEGER

[Thomas Rebele (Jira)]

Thomas Rebele created CALCITE-4256:
--------------------------------------

             Summary: RexSimplify should not simplify P AND P to P, if it 
contains a call to RAND or RAND_INTEGER
                 Key: CALCITE-4256
                 URL: https://issues.apache.org/jira/browse/CALCITE-4256
             Project: Calcite
          Issue Type: Bug
            Reporter: Thomas Rebele


Example: RAND_INTEGER() = 1 AND RAND_INTEGER() = 1 is false with a higher 
probability than RAND_INTEGER() = 1

Here a test case for RexProgramTest:
{code}
@Test void testSimplifyRandomAnd() {
    checkSimplifyUnchanged(
        and(
            eq(rexBuilder.makeCall(SqlStdOperatorTable.RAND_INTEGER), 
literal(1)),
            eq(rexBuilder.makeCall(SqlStdOperatorTable.RAND_INTEGER), 
literal(1))
        ));
  }
{code}



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