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)