select(distinct=...) may produce faulty sql for sqlite

[pembeci]

This one works:

In [45]: db().select(db.player.country, distinct = True)
Out[45]: <Rows (40)>

In [46]: db._lastsql
Out[46]: 'SELECT DISTINCT player.country FROM player;'

But the other option given in the book does not:

In [47]: db().select(db.player.country, distinct = db.player.country)
OperationalError: near "ON": syntax error

In [48]: db._lastsql
Out[48]: 'SELECT DISTINCT ON (player.country) player.country FROM player;'

I didn't test it with other DB engines since I don't currently have one installed.

[cassiobotaro]

@gi0baro I think it's pydal related.

[gi0baro]

@cassiobotaro yep seems to me too. Can you open up an issue on pyDAL?