- changed status to resolved
DISTINCT queries doesn't function in PostgreSQL since r1830
Issue #294
resolved
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)
-
repo owner - Log in to comment
changeset:1843