From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: nia@p1.tcnet.ne.jp
Subject: BUG #18416: Confirmation of Issue with PostgreSQL ODBC Driver for Windows
Date: Thu, 28 Mar 2024 23:27:36 +0000
Message-ID: <18416-379e9b2e0b472750@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18416
Logged by: norihiro kawagoshi
Email address: nia@p1.tcnet.ne.jp
PostgreSQL version: 14.6
Operating system: Windows10
Description:
I apologize for the inconvenience, but I would like to request your
assistance in checking an issue related to the PostgreSQL ODBC.
Our current environment is as follows:
OS：Windows10
PostgreSQL version： 14.7
ODBC version：PostgreSQL Unicode 16.00
SOFT:Microsoft ACCESS for office 365 (16.012624.20422) 32Bit
am reaching out to you regarding an issue I have encountered while using
Microsoft Access to create a linked table to a PostgreSQL VIEW and
executing
a specific SQL query, which resulted in an error. I would like to inquire
about the cause of this error.
The SQL query that generates the error is as follows:
SELECT left(tseisan_v_test_a.[A1],3) AS leftkansu, tseisan_v_test_b.[A1]
FROM tseisan_v_test_a LEFT JOIN tseisan_v_test_b ON tseisan_v_test_a.[A1]
=
tseisan_v_test_b.[A1]
WHERE left(tseisan_v_test_a.[A1],3)='110';
When I execute the above query, I receive the following error message:
"ODBC--call failed. ERROR: syntax error at or near ")"; Error while
executing the query (#1)."
I have confirmed that the condition WHERE
left(tseisan_v_test_a.[A1],3)='110' executes correctly without the LEFT
JOIN. However, when I try to use the LEFT or RIGHT functions after
performing a LEFT JOIN, an error occurs. On the other hand, I have
verified
that the MID function can be used without issues. Additionally, I have
confirmed that the same SQL statement does not generate an error when
processed in PGADMIN, suggesting that the problem may be specific to
Access.
I suspect that the ODBC driver may not be able to interpret the use of the
LEFT function within the WHERE clause following a LEFT JOIN. If the
problem
lies with the ODBC driver, I kindly request that it be corrected.
I appreciate your attention to this matter and look forward to your prompt
response.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, nia@p1.tcnet.ne.jp
Subject: Re: BUG #18416: Confirmation of Issue with PostgreSQL ODBC Driver for Windows
In-Reply-To: <18416-379e9b2e0b472750@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox