MIME-Version: 1.0
References: 
 <CALAVXY5JMTkKvXWDEOyBwVb1t2M1-pqop7oNpkZC6bQgTskEcw@mail.gmail.com>
In-Reply-To: 
 <CALAVXY5JMTkKvXWDEOyBwVb1t2M1-pqop7oNpkZC6bQgTskEcw@mail.gmail.com>
From: "Inoue,Hiroshi" <hinoue205@gmail.com>
Date: Mon, 11 Oct 2021 18:44:55 +0900
Message-ID: 
 <CAFGcedV_Utcv2RJuQSeMDyX0VWhQLR3npvfY=vcGhQEBdzcQiQ@mail.gmail.com>
Subject: Re: SQLGetDiagField bug
To: V T <vova20007@gmail.com>
Cc: pgsql-odbc@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000087959a05ce109523"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFGcedV_Utcv2RJuQSeMDyX0VWhQLR3npvfY%3DvcGhQEBdzcQiQ%40mail.gmail.com>
Precedence: bulk

--00000000000087959a05ce109523
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

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

Thanks.
Hiroshi Inoue


2021=E5=B9=B410=E6=9C=888=E6=97=A5(=E9=87=91) 13:24 V T <vova20007@gmail.co=
m>:

> 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 =3D SQLGetInfo(hdbc, SQL_DATETIME_LITERALS, &bitmask,
> sizeof(bitmask), NULL); // _ASSERT(rc =3D=3D 0);
>     if (rc !=3D SQL_SUCCESS)
>     {
>         SQLLEN numRecs;
>         SQLCHAR Msg[SQL_MAX_MESSAGE_LENGTH + 1];
>
>         rc =3D SQLGetDiagField(SQL_HANDLE_DBC, hdbc, 0, SQL_DIAG_NUMBER,
> &numRecs, 0, nullptr); // _ASSERT(rc =3D=3D 0);
>         // returns SQL_NO_DATA
>
>         // but this returns valid message
>         rc =3D SQLGetDiagRec(SQL_HANDLE_DBC, hdbc, 1, NULL, NULL, Msg,
> sizeof(Msg), NULL); _ASSERT(rc =3D=3D 0);
>         __debugbreak();
>     }
>
>
> Also there is a typo in function PGAPI_GetTypeInfo(HSTMT hstmt,
> SQLSMALLINT fSqlType) [info.c]
>
> https://git.postgresql.org/gitweb/?p=3Dpsqlodbc.git;a=3Dblob;f=3Dinfo.c;h=
=3D2ce1a5acd19052c2525bdd5b2ab02701eb6cba1d;hb=3DHEAD#l1161
> "RECISION" should be "PRECISION"
>

--00000000000087959a05ce109523
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<div><br></div><div>Sorry for the late reply.</div><div=
>I would take care of this issue.</div><div><br></div><div>Thanks.</div><di=
v>Hiroshi Inoue</div><div><br></div></div><br><div class=3D"gmail_quote"><d=
iv dir=3D"ltr" class=3D"gmail_attr">2021=E5=B9=B410=E6=9C=888=E6=97=A5(=E9=
=87=91) 13:24 V T &lt;<a href=3D"mailto:vova20007@gmail.com">vova20007@gmai=
l.com</a>&gt;:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0=
px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><=
div dir=3D"ltr">SQLGetDiagField(SQL_DIAG_NUMBER) with SQL_HANDLE_DBC return=
s SQL_NO_DATA even if an error record exists.<br><br>if I request one of un=
implemented info types <br>SQL_DATETIME_LITERALS<br>SQL_STANDARD_CLI_CONFOR=
MANCE<br>SQL_XOPEN_CLI_YEAR<br><br>=C2=A0 =C2=A0 SQLUINTEGER bitmask;<br>=
=C2=A0 =C2=A0 SQLRETURN rc;<br><br>=C2=A0 =C2=A0 rc =3D SQLGetInfo(hdbc, SQ=
L_DATETIME_LITERALS, &amp;bitmask, sizeof(bitmask), NULL); // _ASSERT(rc =
=3D=3D 0);<br>=C2=A0 =C2=A0 if (rc !=3D SQL_SUCCESS)<br>=C2=A0 =C2=A0 {<br>=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 SQLLEN numRecs;<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =
SQLCHAR Msg[SQL_MAX_MESSAGE_LENGTH + 1];<br><br>=C2=A0 =C2=A0 =C2=A0 =C2=A0=
 rc =3D SQLGetDiagField(SQL_HANDLE_DBC, hdbc, 0, SQL_DIAG_NUMBER, &amp;numR=
ecs, 0, nullptr); // _ASSERT(rc =3D=3D 0);<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 /=
/ returns SQL_NO_DATA<br><br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 // but this return=
s valid message<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 rc =3D SQLGetDiagRec(SQL_HAN=
DLE_DBC, hdbc, 1, NULL, NULL, Msg, sizeof(Msg), NULL); _ASSERT(rc =3D=3D 0)=
;<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 __debugbreak();<br>=C2=A0 =C2=A0 }<br><br>=
<br>Also there is a typo in function PGAPI_GetTypeInfo(HSTMT hstmt, SQLSMAL=
LINT fSqlType) [info.c]<br><a href=3D"https://git.postgresql.org/gitweb/?p=
=3Dpsqlodbc.git;a=3Dblob;f=3Dinfo.c;h=3D2ce1a5acd19052c2525bdd5b2ab02701eb6=
cba1d;hb=3DHEAD#l1161" target=3D"_blank">https://git.postgresql.org/gitweb/=
?p=3Dpsqlodbc.git;a=3Dblob;f=3Dinfo.c;h=3D2ce1a5acd19052c2525bdd5b2ab02701e=
b6cba1d;hb=3DHEAD#l1161</a><br>&quot;RECISION&quot; should be &quot;PRECISI=
ON&quot;</div>
</blockquote></div>

--00000000000087959a05ce109523--