Add join with normalization tests
@@ -2214,6 +2214,16 @@ public abstract class AbstractTestQueries
);
}
+ @Test
+ public void testJoinWithNormalization()
+ {
+ assertQuery("select COUNT(*) from nation a join nation b on not ((a.nationkey + b.nationkey) <> b.nationkey)");
+ assertQuery("select COUNT(*) from nation a join nation b on not (a.nationkey <> b.nationkey)");
+ assertQuery("select COUNT(*) from nation a join nation b on not (a.nationkey = b.nationkey)");
+ assertQuery("select COUNT(*) from nation a join nation b on not (not cast(a.nationkey as boolean))");
+ assertQuery("select COUNT(*) from nation a join nation b on not not not (a.nationkey = b.nationkey)");
+ }
+
@Test
public void testSelfJoin()
{
