[Sqlalchemy-tickets] Issue #3392: Regression with 1.0+ (zzzeek/sqlalchemy)
Brought to you by:
zzzeek
|
From: Luke M. <iss...@bi...> - 2015-04-27 19:27:58
|
New issue 3392: Regression with 1.0+ https://bitbucket.org/zzzeek/sqlalchemy/issue/3392/regression-with-10 Luke Macken: Hello, I'm currently hitting a regression with 1.0.0+. https://github.com/fedora-infra/bodhi/blob/develop/bodhi/views/generic.py#L36-L56 ``` #!python ProgrammingError: (psycopg2.ProgrammingError) syntax error at or near "desc" LINE 2: ...(users.id = comments.user_id) AS count_1, count_1 desc AS an... ^ [SQL: 'SELECT anon_1.users_id AS anon_1_users_id, anon_1.users_name AS anon_1_users_name, anon_1.count_1 AS anon_1_count_1, anon_1.anon_2 AS anon_1_anon_2, re leases_1.id AS releases_1_id, releases_1.name AS releases_1_name, releases_1.long_name AS releases_1_long_name, releases_1.version AS releases_1_version, relea ses_1.id_prefix AS releases_1_id_prefix, releases_1.branch AS releases_1_branch, releases_1.dist_tag AS releases_1_dist_tag, releases_1.stable_tag AS releases_ 1_stable_tag, releases_1.testing_tag AS releases_1_testing_tag, releases_1.candidate_tag AS releases_1_candidate_tag, releases_1.pending_testing_tag AS release s_1_pending_testing_tag, releases_1.pending_stable_tag AS releases_1_pending_stable_tag, releases_1.override_tag AS releases_1_override_tag, releases_1.state A S releases_1_state, builds_1.id AS builds_1_id, builds_1.nvr AS builds_1_nvr, builds_1.inherited AS builds_1_inherited, builds_1.package_id AS builds_1_package _id, builds_1.release_id AS builds_1_release_id, builds_1.update_id AS builds_1_update_id, packages_1.id AS packages_1_id, packages_1.name AS packages_1_name, packages_1.requirements AS packages_1_requirements, packages_1.stack_id AS packages_1_stack_id, stacks_1.id AS stacks_1_id, stacks_1.name AS stacks_1_name, sta cks_1.description AS stacks_1_description, stacks_1.requirements AS stacks_1_requirements, buildroot_overrides_1.id AS buildroot_overrides_1_id, buildroot_over rides_1.build_id AS buildroot_overrides_1_build_id, buildroot_overrides_1.submitter_id AS buildroot_overrides_1_submitter_id, buildroot_overrides_1.notes AS bu ildroot_overrides_1_notes, buildroot_overrides_1.submission_date AS buildroot_overrides_1_submission_date, buildroot_overrides_1.expiration_date AS buildroot_o verrides_1_expiration_date, buildroot_overrides_1.expired_date AS buildroot_overrides_1_expired_date \nFROM (SELECT users.id AS users_id, users.name AS users_n ame, count(users.id = comments.user_id) AS count_1, count_1 desc AS anon_2 \nFROM users JOIN comments ON users.id = comments.user_id \nWHERE comments.timestamp > %(timestamp_1)s AND users.name != %(name_1)s AND users.name != %(name_2)s GROUP BY users.id, users.name ORDER BY count_1 desc \n LIMIT %(param_1)s) AS anon_ 1 LEFT OUTER JOIN buildroot_overrides AS buildroot_overrides_1 ON anon_1.users_id = buildroot_overrides_1.submitter_id LEFT OUTER JOIN builds AS builds_1 ON bu ilds_1.id = buildroot_overrides_1.build_id LEFT OUTER JOIN releases AS releases_1 ON releases_1.id = builds_1.release_id LEFT OUTER JOIN packages AS packages_1 ON packages_1.id = builds_1.package_id LEFT OUTER JOIN stacks AS stacks_1 ON stacks_1.id = packages_1.stack_id ORDER BY anon_1.anon_2'] [parameters: {'name_2' : 'autoqa', 'name_1': 'bodhi', 'param_1': 5, 'timestamp_1': datetime.datetime(2015, 4, 20, 18, 59, 41, 509054)}] ``` |