Query q = MetaModelHelper.parseQuery(dc, "SELECT DISTINCT foo, bar AS f FROM sch.tbl");
assertEquals("SELECT DISTINCT tbl.foo, tbl.bar AS f FROM sch.tbl", q.toSql());
}
public void testSimpleSelectFrom() throws Exception {
Query q = MetaModelHelper.parseQuery(dc, "SELECT foo\nFROM sch.tbl");
assertEquals("SELECT tbl.foo FROM sch.tbl", q.toSql());
assertEquals(1, q.getFromClause().getItemCount());
FromItem fromItem = q.getFromClause().getItem(0);
assertNull("FROM item was an expression based item, which indicates it was not parsed",
fromItem.getExpression());
assertNotNull(fromItem.getTable());
assertEquals("tbl", fromItem.getTable().getName());
assertEquals(1, q.getSelectClause().getItemCount());
SelectItem selectItem = q.getSelectClause().getItem(0);
assertNull("SELECT item was an expression based item, which indicates it was not parsed",
selectItem.getExpression());
assertNotNull(selectItem.getColumn());
assertEquals("foo", selectItem.getColumn().getName());
assertNull(q.getFirstRow());
assertNull(q.getMaxRows());
}