DISTINCT queries doesn't function in PostgreSQL since r1830

In revision 1830 a patch for quoting identifiers is introduced; since then, queries that involve the DISTINCT parameter (i.e., distinct=True) does not function in PostgreSQL when the arguments are quoted. This is due to the tbl_row_count parameter that is intorduced by the distinct clause (sometimes even in subqueries, i.e., SELECT ... FROM (SELECT DISTINCT ... )).

Attached is a slight modification of the selectresults.py unittest, using uppercase identifiers, which passes the tests in SQLite but not in PostgreSQL 8.1.

Regards,

Raul Garcia.

Comments (1)