added a new test: test_distinct() for DISTINCT.