source: class FilterPreProcessorTest  {
  
      @Test
      public void test_合并_AND条件() {
  
target:         TableNode table = new TableNode("TABLE1");
          table.query("ID > 1 AND ID < 10");
          table.build();
          FilterPreProcessor.optimize(table, true, null);
          Assert.assertEquals(table.getWhereFilter().toString(), "(TABLE1.ID > 1 AND TABLE1.ID < 10)");
  
          table.query("ID > 1 AND ID < 10 AND ID >= 2 AND ID < 11");
          table.build();
          FilterPreProcessor.optimize(table, true, null);
          Assert.assertEquals(table.getWhereFilter().toString(), "(TABLE1.ID >= 2 AND TABLE1.ID < 10)");
  
          table.query("ID > 1 AND ID < 0");
          table.build();
          try {
              FilterPreProcessor.optimize(table, true, null);
              Assert.fail();
          } catch (EmptyResultFilterException e) {
              // 会出现EmptyResultFilterException异常
          }
      }
  
  }