public inbox for [email protected]  

help / color / mirror / Atom feed

SQLGetDiagField bug
3+ messages / 2 participants
[nested] [flat]

* SQLGetDiagField bug
@ 2021-10-06 23:22 V T <[email protected]>
  2021-10-11 09:44 ` Re: SQLGetDiagField bug Inoue,Hiroshi <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: V T @ 2021-10-06 23:22 UTC (permalink / raw)
  To: [email protected]

SQLGetDiagField(SQL_DIAG_NUMBER) with SQL_HANDLE_DBC returns SQL_NO_DATA
even if an error record exists.

if I request one of unimplemented info types
SQL_DATETIME_LITERALS
SQL_STANDARD_CLI_CONFORMANCE
SQL_XOPEN_CLI_YEAR

    SQLUINTEGER bitmask;
    SQLRETURN rc;

    rc = SQLGetInfo(hdbc, SQL_DATETIME_LITERALS, &bitmask, sizeof(bitmask),
NULL); // _ASSERT(rc == 0);
    if (rc != SQL_SUCCESS)
    {
        SQLLEN numRecs;
        SQLCHAR Msg[SQL_MAX_MESSAGE_LENGTH + 1];

        rc = SQLGetDiagField(SQL_HANDLE_DBC, hdbc, 0, SQL_DIAG_NUMBER,
&numRecs, 0, nullptr); // _ASSERT(rc == 0);
        // returns SQL_NO_DATA

        // but this returns valid message
        rc = SQLGetDiagRec(SQL_HANDLE_DBC, hdbc, 1, NULL, NULL, Msg,
sizeof(Msg), NULL); _ASSERT(rc == 0);
        __debugbreak();
    }


Also there is a typo in function PGAPI_GetTypeInfo(HSTMT hstmt, SQLSMALLINT
fSqlType) [info.c]
https://git.postgresql.org/gitweb/?p=psqlodbc.git;a=blob;f=info.c;h=2ce1a5acd19052c2525bdd5b2ab02701...
"RECISION" should be "PRECISION"


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: SQLGetDiagField bug
  2021-10-06 23:22 SQLGetDiagField bug V T <[email protected]>
@ 2021-10-11 09:44 ` Inoue,Hiroshi <[email protected]>
  2021-10-13 06:40   ` Re: SQLGetDiagField bug Inoue,Hiroshi <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Inoue,Hiroshi @ 2021-10-11 09:44 UTC (permalink / raw)
  To: V T <[email protected]>; +Cc: [email protected]

Hi,

Sorry for the late reply.
I would take care of this issue.

Thanks.
Hiroshi Inoue


2021年10月8日(金) 13:24 V T <[email protected]>:

> SQLGetDiagField(SQL_DIAG_NUMBER) with SQL_HANDLE_DBC returns SQL_NO_DATA
> even if an error record exists.
>
> if I request one of unimplemented info types
> SQL_DATETIME_LITERALS
> SQL_STANDARD_CLI_CONFORMANCE
> SQL_XOPEN_CLI_YEAR
>
>     SQLUINTEGER bitmask;
>     SQLRETURN rc;
>
>     rc = SQLGetInfo(hdbc, SQL_DATETIME_LITERALS, &bitmask,
> sizeof(bitmask), NULL); // _ASSERT(rc == 0);
>     if (rc != SQL_SUCCESS)
>     {
>         SQLLEN numRecs;
>         SQLCHAR Msg[SQL_MAX_MESSAGE_LENGTH + 1];
>
>         rc = SQLGetDiagField(SQL_HANDLE_DBC, hdbc, 0, SQL_DIAG_NUMBER,
> &numRecs, 0, nullptr); // _ASSERT(rc == 0);
>         // returns SQL_NO_DATA
>
>         // but this returns valid message
>         rc = SQLGetDiagRec(SQL_HANDLE_DBC, hdbc, 1, NULL, NULL, Msg,
> sizeof(Msg), NULL); _ASSERT(rc == 0);
>         __debugbreak();
>     }
>
>
> Also there is a typo in function PGAPI_GetTypeInfo(HSTMT hstmt,
> SQLSMALLINT fSqlType) [info.c]
>
> https://git.postgresql.org/gitweb/?p=psqlodbc.git;a=blob;f=info.c;h=2ce1a5acd19052c2525bdd5b2ab02701...
> "RECISION" should be "PRECISION"
>


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: SQLGetDiagField bug
  2021-10-06 23:22 SQLGetDiagField bug V T <[email protected]>
  2021-10-11 09:44 ` Re: SQLGetDiagField bug Inoue,Hiroshi <[email protected]>
@ 2021-10-13 06:40   ` Inoue,Hiroshi <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: Inoue,Hiroshi @ 2021-10-13 06:40 UTC (permalink / raw)
  To: V T <[email protected]>; +Cc: [email protected]

Hi,

Could you try test drivers on Windows?

regards,
Hiroshi Inoue

2021年10月11日(月) 18:44 Inoue,Hiroshi <[email protected]>:

> Hi,
>
> Sorry for the late reply.
> I would take care of this issue.
>
> Thanks.
> Hiroshi Inoue
>
>
> 2021年10月8日(金) 13:24 V T <[email protected]>:
>
>> SQLGetDiagField(SQL_DIAG_NUMBER) with SQL_HANDLE_DBC returns SQL_NO_DATA
>> even if an error record exists.
>>
>> if I request one of unimplemented info types
>> SQL_DATETIME_LITERALS
>> SQL_STANDARD_CLI_CONFORMANCE
>> SQL_XOPEN_CLI_YEAR
>>
>>     SQLUINTEGER bitmask;
>>     SQLRETURN rc;
>>
>>     rc = SQLGetInfo(hdbc, SQL_DATETIME_LITERALS, &bitmask,
>> sizeof(bitmask), NULL); // _ASSERT(rc == 0);
>>     if (rc != SQL_SUCCESS)
>>     {
>>         SQLLEN numRecs;
>>         SQLCHAR Msg[SQL_MAX_MESSAGE_LENGTH + 1];
>>
>>         rc = SQLGetDiagField(SQL_HANDLE_DBC, hdbc, 0, SQL_DIAG_NUMBER,
>> &numRecs, 0, nullptr); // _ASSERT(rc == 0);
>>         // returns SQL_NO_DATA
>>
>>         // but this returns valid message
>>         rc = SQLGetDiagRec(SQL_HANDLE_DBC, hdbc, 1, NULL, NULL, Msg,
>> sizeof(Msg), NULL); _ASSERT(rc == 0);
>>         __debugbreak();
>>     }
>>
>>
>> Also there is a typo in function PGAPI_GetTypeInfo(HSTMT hstmt,
>> SQLSMALLINT fSqlType) [info.c]
>>
>> https://git.postgresql.org/gitweb/?p=psqlodbc.git;a=blob;f=info.c;h=2ce1a5acd19052c2525bdd5b2ab02701...
>> "RECISION" should be "PRECISION"
>>
>


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2021-10-13 06:40 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-10-06 23:22 SQLGetDiagField bug V T <[email protected]>
2021-10-11 09:44 ` Inoue,Hiroshi <[email protected]>
2021-10-13 06:40   ` Inoue,Hiroshi <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox