propelorm/Propel — Issue #227: Query class setDistinct fails
Author: hades200082
Created: 2011-12-12 11:08:21+00:00
State: open

$artists = SonglistQuery::create()
->select(SonglistPeer::ARTIST)
->setDistinct(SonglistPeer::ARTIST)
->find();

This results in the following SQL which fails with a syntax error...

SELECT DISTINCT AS "songlist.ARTIST" FROM `songlist`

The `AS` should not be there.