content: package com.alibaba.druid.bvt.sql.odps;
  
  import com.alibaba.druid.sql.SQLUtils;
  import junit.framework.TestCase;
  
  public class OdpsAlterTableDropPartitionTest extends TestCase {
      public void test_if() throws Exception {
          String sql = "alter table sale_detail drop if exists partition (sale_date='201312', region='hangzhou');";
          assertEquals("ALTER TABLE sale_detail"
                  + "\n\tDROP IF EXISTS PARTITION (sale_date = '201312', region = 'hangzhou');", SQLUtils.formatOdps(sql));
          assertEquals("alter table sale_detail"
                  + "\n\tdrop if exists partition (sale_date = '201312', region = 'hangzhou');", SQLUtils.formatOdps(sql, SQLUtils.DEFAULT_LCASE_FORMAT_OPTION));
      }
  
      public void test_purge() throws Exception {
          String sql = "alter table my_log drop partition (ds='20150618') purge;";
          assertEquals("ALTER TABLE my_log"
                  + "\n\tDROP PARTITION (ds = '20150618') PURGE;", SQLUtils.formatOdps(sql));
          assertEquals("alter table my_log"
                  + "\n\tdrop partition (ds = '20150618') purge;", SQLUtils.formatOdps(sql, SQLUtils.DEFAULT_LCASE_FORMAT_OPTION));
      }
  }
  