  @Test public void testSelectFromNaturlaLeftOuterJoinWhereGroupBy() {


    int tests = 100;
    int columns = 5;

    for (int i = 0; i < tests; i++) {

      Columns c = new Columns(columns);
      String tableName = "table" + i;
      String whereClause = "col1=val1 AND col2=val2";
      String groupBy = "col" + i;
      String tableToJoin = "TableName" + i;

      String sql = new SELECT(c.columns).FROM(tableName)
          .NATURAL_LEFT_OUTER_JOIN(tableToJoin)
          .WHERE(whereClause)
          .GROUP_BY(groupBy)
          .asCompileableStatement().sql;
      String genSql =
          c.sql + " FROM " + tableName + " NATURAL LEFT OUTER JOIN " + tableToJoin + " WHERE "
              + whereClause + " GROUP BY " + groupBy;

      assertEquals(sql, genSql);
    }
  }