public void testDistinctManyFields() throws Exception {
DataSource d = ds.executeSQL(
"select distinct id1, id2 from sort ;");
d.start();
assertTrue(d.getRowCount() == 4);
assertTrue(((BooleanValue)d.getFieldValue(0, 0).equals(ValueFactory.createValue(0))).getValue());
assertTrue(((BooleanValue)d.getFieldValue(0, 1).equals(ValueFactory.createValue(1))).getValue());
assertTrue(((BooleanValue)d.getFieldValue(1, 0).equals(ValueFactory.createValue(0))).getValue());
assertTrue(((BooleanValue)d.getFieldValue(1, 1).equals(ValueFactory.createValue(3))).getValue());