BUG #13502: parser misconstrues table alias

From: floriparob(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13502: parser misconstrues table alias
Date: 2015-07-16 02:33:21
Message-ID: 20150716023321.2307.19959@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13502
Logged by: Robert Stone
Email address: floriparob(at)gmail(dot)com
PostgreSQL version: 9.4.4
Operating system: Debian stretch/sid
Description:

I aliased a table using the letters TO and the parser pulled an error.
Happens in psql as well as the JDBC driver.
By altering the table alias to TOL overcame the problem.

dinkumerp=# SELECT TO.tol_id, TO.lang_code, SL.lang_name, TO.no_list_text,
TO.table_comment FROM supported_languages SL, tables_opt_list TO WHERE
TO.lang_code = SL.lang_code AND TO.table_key = 'COA' ORDER BY TO.lang_code;
ERROR: syntax error at or near "TO"
LINE 1: SELECT TO.tol_id, TO.lang_code, SL.lang_name, TO.no_list_tex...

PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc-4.9.real
(Debian 4.9.2-20) 4.9.2, 64-bit
(1 row)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2015-07-16 03:19:25 Re: BUG #13502: parser misconstrues table alias
Previous Message Michael Paquier 2015-07-16 01:10:42 Re: [BUGS] 9.4.4 max_wal_sendersについて