Caused By Org.postgresql.util.psqlexception Error Column Reference Id Is Ambiguous
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists Regional lists Associations User groups Project lists Inactive lists IRC Local User Groups Featured Users International Sites Propaganda Resources Weekly News Re: BUG #7875: org.postgresql.util.PSQLException: ERROR: column reference "e_raci_obj" is ambiguous From: Euler Taveira
problems NetBeans Forums -> Java EE Users View previous topic :: View next topic Author Message Melongo AnnabelPosted via mailing list. Posted: Tue Dec 01, 2009 5:54 am Post subject: Re: Hibernate and Postgres ambigous reference problems Can you change the name 'id' into something else, it might be a reserved word in either Postgres or Hibernate. Thanks. From: Wadi Jalil Maluf
Support Search GitHub This repository Watch 52 Star 706 Fork https://github.com/yourlabs/django-autocomplete-light/issues/442 210 yourlabs/django-autocomplete-light Code Issues 57 Pull requests 12 Projects 0 Pulse Graphs New issue SQL error: 'column reference "id" is ambiguous' #442 Closed Hedde https://issues.apache.org/jira/browse/DRILL-4374 opened this Issue Jun 6, 2015 · 12 comments Projects None yet Labels bug Milestone No milestone Assignees jpic 4 participants Hedde commented caused by Jun 6, 2015 I'll look into this tomorrow but since the update to 2.2.0 I've noticed this issue on sentry; ProgrammingError at /app/model/1/ column reference "id" is ambiguous LINE 1: SELECT (CASE WHEN id='1' THEN 0 END) AS "ordering", "... It complains about validate_values(), as I said I'll caused by org.postgresql.util.psqlexception update this ticket later, but it occurs when saving inlines that have autocomplete fields aidanlister commented Jun 7, 2015 Yeah I'm seeing the same thing: Traceback: File "/usr/local/lib/python3.4/site-packages/django/core/handlers/base.py" in get_response 132. response = wrapped_callback(request, *callback_args, **callback_kwargs) File "/usr/local/lib/python3.4/site-packages/django/views/generic/base.py" in view 71. return self.dispatch(request, *args, **kwargs) File "/usr/local/lib/python3.4/site-packages/braces/views.py" in dispatch 140. request, *args, **kwargs) File "/usr/local/lib/python3.4/site-packages/django/views/generic/base.py" in dispatch 89. return handler(request, *args, **kwargs) File "/usr/local/lib/python3.4/site-packages/django/views/generic/edit.py" in post 272. return super(BaseUpdateView, self).post(request, *args, **kwargs) File "/usr/local/lib/python3.4/site-packages/django/views/generic/edit.py" in post 214. if form.is_valid(): File "/usr/local/lib/python3.4/site-packages/django/forms/forms.py" in is_valid 184. return self.is_bound and not self.errors File "/usr/local/lib/python3.4/site-packages/django/forms/forms.py" in errors 176. self.full_clean() File "/usr/local/lib/python3.4/site-packages/django/forms/forms.py" in full_clean 392. self._clean_fields() File "/usr/local/lib/python3.4/site-packages/django/forms/forms.py" in _clean_fields 407. value = field.clean(value) File "/usr/local/lib/python3.4/site-packages/django/forms/fields.py" in clean 163. self.validate(value) File "/usr/local/lib/python3.4/site-packages/autocomplete_light/fields.py" in validate 61. if value and not self.autocomplete(values=values).validate_values(): File "/usr/local/lib/python3.4/site-packages/autocomplete_light/autocomplete/model.py" in validate_values 172. return len(self.choices_for_values()) == len(self.values) File "/usr/local/lib/python3.4/site-packages/django/db/models/query.py" in __len__ 144. self._fetch_all() File "/usr/local/lib/python3.4/site-packages
query with ambiguous column referencesAgile Board ExportXMLWordPrintableJSON Details Type: Bug Status: In Progress Priority: Major Resolution: Unresolved Affects Version/s: 1.4.0 Fix Version/s: None Component/s: Storage - JDBC Labels: None Description Drill drops table references when rewriting this query, resulting in ambiguous column references. This query: select s.uuid as site_uuid, psc.partner_id, sum(psc.net_revenue_dollars) as revenue from app.public.partner_site_clicks psc join app.public.sites s on psc.site_id = s.id join app.public.partner_click_days pcd on pcd.id = psc.partner_click_day_id where s.generate_revenue_report is true and pcd.`day` = '2016-02-07' group by s.uuid, psc.partner_id; Results in this error: DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query. Trying to run this re-written query: SELECT "site_uuid", "partner_id", SUM("net_revenue_dollars") AS "revenue" FROM ( SELECT "uuid" AS "site_uuid", "partner_id", "net_revenue_dollars" FROM "public"."partner_site_clicks" INNER JOIN "public"."sites" ON "partner_site_clicks"."site_id" = "sites"."id" INNER JOIN "public"."partner_click_days" ON "partner_site_clicks"."partner_click_day_id" = "partner_click_days"."id" WHERE "sites"."generate_revenue_report" IS TRUE AND "partner_click_days"."day" = '2016-02-07' ) AS "t0" GROUP BY "site_uuid", "partner_id" That query fails due to an ambiguous "partner_id" reference as two of the tables have that column. Activity Ascending order - Click to sort in descending order All Comments Work Log History Activity Transitions Hide Permalink Jacques Nadeau added a comment - 18/Feb/16 05:17 Taras Supyk, can you take a look at this? Show Jacques Nadeau added a comment - 18/Feb/16 05:17 Taras Supyk , can you take a look at this? Hide Permalink Jacques Nadeau added a comment - 18/Feb/16 17:50 Another potential similar example from mailing list: SELECT cs.post_id, t.tag_id, cs.language_code, cs.likes_count, cs.comments_count, cs.clippings_count, cs.cr_recency_score FROM redshift.public.card_scores AS cs JOIN redshift.public.taggings AS t ON cs.post_id = t.post_id INNER JOIN redshift.public.min_scale_scores AS mss ON mss.post_id=cs.post_id WHERE cs.cr_recency_score IS NOT NULL AND t.status <> 'unpublished' Then, error raised. 2016-02-18 05:44:26,862 [293aa5c5-4dcd-3cd8-7b40-4847289d71fa:frag:0:0] INFO o.a.d.e.store.jdbc.JdbcRecord