OdpsIfTest.java

package com.alibaba.druid.bvt.sql.odps;

import org.junit.Assert;

import com.alibaba.druid.sql.SQLUtils;

import junit.framework.TestCase;

public class OdpsIfTest extends TestCase {
    
    public void test_if() throws Exception {
        String sql = "select sum(if(a > 0, 1, 0)) from t1";
        Assert.assertEquals("SELECT SUM(IF(a > 0, 1, 0))" //
                + "\nFROM t1", SQLUtils.formatOdps(sql));
    }
}