TestRawSqlBuilderDistinct.java

package io.ebean;

import io.ebean.RawSql.Sql;
import io.ebean.RawSqlBuilder;
import junit.framework.TestCase;
import org.junit.Assert;

public class TestRawSqlBuilderDistinct extends TestCase {

  public void testDistinct() {

    RawSqlBuilder r = RawSqlBuilder.parse("select distinct id, name from t_cust");
    Sql sql = r.getSql();
    Assert.assertEquals("id, name", sql.getPreFrom());
    Assert.assertEquals("from t_cust", sql.getPreWhere());
    Assert.assertEquals("", sql.getPreHaving());
    Assert.assertNull(sql.getOrderBy());

  }

}