content: package com.alibaba.druid.bvt.sql.odps;
  
  import com.alibaba.druid.sql.SQLUtils;
  import junit.framework.TestCase;
  
  public class OdpsFormatCommentTest4 extends TestCase {
      public void test_column_comment() throws Exception {
          String sql = "from (select * from xxx) a"
                  + "\n -- comment_0"
                  + "\ninsert overwrite table b partition(ds='20150711')"
                  + "\nselect f0, f1, f2"
                  + "\nwhere name rlike 'xxxx'"
                  + "\n -- comment_1"
                  + "\ninsert overwrite table c partition(ds='20150711')"
                  + "\nselect f0, f1, f2"
                  + "\nwhere name rlike 'kk';";
          assertEquals(
              "FROM (\n"
                  + "\tSELECT *\n"
                  + "\tFROM xxx\n"
                  + ") a\n"
                  + "-- comment_0\n"
                  + "INSERT OVERWRITE TABLE b PARTITION (ds='20150711')\n"
                  + "SELECT f0, f1, f2\n"
                  + "WHERE name RLIKE 'xxxx' -- comment_1\n"
                  + "INSERT OVERWRITE TABLE c PARTITION (ds='20150711')\n"
                  + "SELECT f0, f1, f2\n"
                  + "WHERE name RLIKE 'kk';",
              SQLUtils.formatOdps(sql));
      }
  }
  