Re: SQLGetDiagField bug

From: "Inoue,Hiroshi" <hinoue205(at)gmail(dot)com>
To: V T <vova20007(at)gmail(dot)com>
Cc: pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: Re: SQLGetDiagField bug
Date: 2021-10-13 06:40:30
Message-ID: CAFGcedXPeBXcUmW-=3+2dy5YOvGwW14Jk38HrdjOFp=KyhFdyg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

Could you try test drivers on Windows?

regards,
Hiroshi Inoue

2021年10月11日(月) 18:44 Inoue,Hiroshi <hinoue205(at)gmail(dot)com>:

> Hi,
>
> Sorry for the late reply.
> I would take care of this issue.
>
> Thanks.
> Hiroshi Inoue
>
>
> 2021年10月8日(金) 13:24 V T <vova20007(at)gmail(dot)com>:
>
>> 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=2ce1a5acd19052c2525bdd5b2ab02701eb6cba1d;hb=HEAD#l1161
>> "RECISION" should be "PRECISION"
>>
>

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Austin King 2021-10-15 17:52:04 psqlodbc_13_01_0000.zip Issue
Previous Message Inoue,Hiroshi 2021-10-11 09:44:55 Re: SQLGetDiagField bug