From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | nia(at)p1(dot)tcnet(dot)ne(dot)jp |
Subject: | BUG #18416: Confirmation of Issue with PostgreSQL ODBC Driver for Windows |
Date: | 2024-03-28 23:27:36 |
Message-ID: | 18416-379e9b2e0b472750@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: 18416
Logged by: norihiro kawagoshi
Email address: nia(at)p1(dot)tcnet(dot)ne(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Ribe | 2024-03-29 02:03:31 | Re: BUG #18405: flaw in dump of inherited/dropped constraints |
Previous Message | koderan | 2024-03-28 19:40:54 | Re: BUG #18415: Logical replication errors. |