@Test
  public void testWhere() {
    String[] expectedHeader =
        new String[] {
          "s1", "s3", "s4",
        };
    String[] retArray = new String[] {};
    tableResultSetEqualTest(
        "select s1, s3, s4 from sg1 where s2>0", expectedHeader, retArray, DATABASE_NAME);

    tableResultSetEqualTest(
        "select s1, s3, s4 from sg1 where s2 is not null", expectedHeader, retArray, DATABASE_NAME);

    retArray =
        new String[] {
          "1,true,false,", "2,true,null,", "3,null,false,",
        };
    tableResultSetEqualTest(
        "select s1, s3, s4 from sg1 where s2 is null and s5 is null",
        expectedHeader,
        retArray,
        DATABASE_NAME);

    retArray =
        new String[] {
          "1,true,false,", "2,true,null,", "3,null,false,",
        };
    expectedHeader =
        new String[] {
          "s1", "s3", "s4",
        };
    tableResultSetEqualTest(
        "select s1, s3, s4 from sg1 where s2 is null and s5 is null order by device",
        expectedHeader,
        retArray,
        DATABASE_NAME);
  }
LogicOperations: !, &&, ||

<p>See
'https://learn.microsoft.com/zh-cn/sql/connect/ado-net/sql/handle-null-values?view=sql-server-ver16'
integration-test/src/test/java/org/apache/iotdb/relational/it/query/old/query/IoTDBNullOperandTableIT.java