| From: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
|---|---|
| To: | Grant Shirreffs <GShirreffs(at)stayinfront(dot)com> |
| Cc: | "pgsql-odbc(at)lists(dot)postgresql(dot)org" <pgsql-odbc(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: SQLGetInfo |
| Date: | 2019-05-16 23:37:40 |
| Message-ID: | 361c63ea-0f3c-a25c-89a8-8e1f6119e32c@dream.email.ne.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Hi Grant,
Thanks for the report.
I would take care of it.
regards,
Hiroshi Inoue
On 2019/05/15 13:03, Grant Shirreffs wrote:
>
> Looking at the code for SQLGetInfo, where it returns data indicating
> the driver capabilities with respect to the ODBC SQL syntax, it looks
> like the implementation is lacking.
>
> Specifically, calls to SQL_NUMERIC_FUNCTIONS, SQL_TIMEDATE_FUNCTIONS
> and SQL_SYSTEM_FUNCTIONS all return 0, even though the convert_escape
> function in convert.c indicates support for almost all ODBC scalar
> functions. Also, SQL_STRING_FUNCTIONS only returns a subset of the
> full string scalar capabilities, and SQL_LIKE_ESCAPE_CLAUSE is just
> flat-out wrong when it says that escaped LIKE clauses are not supported.
>
> Am I missing something here? Is there some reason why these
> capabilities are not reported, or is just a not-finished-yet corner
> from long ago?
>
> I have ‘fixed’ info.c myself, and validated that the correct values
> are returned and work as expected. I am happy to supply the modified
> file if you want to update the codebase.
>
> Regards
>
> Grant Shirreffs
>
---
このメールは、AVG によってウイルス チェックされています。
http://www.avg.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Inoue, Hiroshi | 2019-05-17 00:48:21 | Re: Bound parameters in escaped functions |
| Previous Message | Grant Shirreffs | 2019-05-15 04:03:14 | SQLGetInfo |