Re: SQLGetInfo

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: Raw Message | Whole Thread | 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

In response to

  • SQLGetInfo at 2019-05-15 04:03:14 from Grant Shirreffs

Browse pgsql-odbc by date

  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