Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1maXwW-0003W5-UJ for pgsql-odbc@arkaria.postgresql.org; Wed, 13 Oct 2021 06:40:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1maXwV-0007r2-L3 for pgsql-odbc@arkaria.postgresql.org; Wed, 13 Oct 2021 06:40:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1maXwV-0007qu-Cp for pgsql-odbc@lists.postgresql.org; Wed, 13 Oct 2021 06:40:47 +0000 Received: from mail-ed1-x52b.google.com ([2a00:1450:4864:20::52b]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1maXwR-0003Pg-1o for pgsql-odbc@lists.postgresql.org; Wed, 13 Oct 2021 06:40:47 +0000 Received: by mail-ed1-x52b.google.com with SMTP id z20so5547577edc.13 for ; Tue, 12 Oct 2021 23:40:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=ZKfepQTWwbcQegYyqWtzuePm3MeTGCDLhEhkeVvNQzA=; b=FweP2k6DkrTQL07aOmAZsDzZpC4mEpt1/daM/jcoVK7Km2vnd9hjJ42ALDYoh5WjMy axbkMk3DAyeB9J9M5hnVj4YygPs1sTJJsKHoEVTzi1KgmejQFYN9zYOGE4V0qats4zZm su0Ezb3PRZSB7VBwBirwMsYZajjGU1feo1QTG/wDAYqgF8ItNRtVH+UkkjQh1Zw09glp oV0z2PB81ilIb7AvFguvfiIh31fOaFzxt8K19UtfF3gFO0m+UTPlYI12Undh5uQZJCTZ inns91nNjH0zH5ZGPsUA9tgEB1XtSijXSPnlWLtAsumMtnojf70ALixx5Bs98KY4d1Y7 EFUQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=ZKfepQTWwbcQegYyqWtzuePm3MeTGCDLhEhkeVvNQzA=; b=YuMN8efejOhp5K+EbY8hsIOZeR+IUow5EPMxvgjMNoH1hBlqDSwCIilDpZNe0lJnC2 vd5K556b/skegw1eU1+kWiuyGp8lJHVIdiWsmZd9WegA+vjfqjoqo84jJ1DKRkBdrNIN x1Y+mG7gEVOdm9+9hV7E8LjGvk9XPA5jp2iYM0F82HxORoEYSvQRJbcEDGU5OOPZOfPi i29zIwp+ywu0R6I5v4C42UtkA4F6FBLvqC/Ez3Rj5x1al4KMu6YLm1YDmzhyppSZeaL3 gQ9v7age0LmrxS+3qqbSUiY8NZH3YDvDGpKWL24/xx4h4gSrOrP9vlYbQGzBwPEoc8YF rfMg== X-Gm-Message-State: AOAM533m7f0zOf5KM68lgyVrhwXkBJSMuPMI97ubS1Aguo8yBFemz5lr qcGu81IjWXcsDcjfQs9huS92Lxxgs4nQek8vfzFR9GbB X-Google-Smtp-Source: ABdhPJyXfqMw/9XKeur985rKG06V42GEpVc/bb8tJD2erQ8wnJWdeJY3Te0RC43SfLT8plSolW4hmyoRa+D06+aY0Lw= X-Received: by 2002:a50:be8a:: with SMTP id b10mr6850818edk.235.1634107242180; Tue, 12 Oct 2021 23:40:42 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: "Inoue,Hiroshi" Date: Wed, 13 Oct 2021 15:40:30 +0900 Message-ID: Subject: Re: SQLGetDiagField bug To: V T Cc: pgsql-odbc@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000b1f30605ce363d38" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b1f30605ce363d38 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, Could you try test drivers on Windows? regards, Hiroshi Inoue 2021=E5=B9=B410=E6=9C=8811=E6=97=A5(=E6=9C=88) 18:44 Inoue,Hiroshi : > 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 : > >> 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" >> > --000000000000b1f30605ce363d38 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

Could you try test drivers on Windo= ws?

regards,
Hiroshi Inoue
2021=E5= =B9=B410=E6=9C=8811=E6=97=A5(=E6=9C=88) 18:44 Inoue,Hiroshi <hinoue205@gmail.com>:
Hi,

Sorry for the late reply.
I would take care of this issue.<= /div>

Thanks.
Hiroshi Inoue


2021=E5=B9=B410=E6=9C=888=E6=97=A5(=E9=87=91) 13:24 V T <vova20007@gmail.com>:
S= QLGetDiagField(SQL_DIAG_NUMBER) with SQL_HANDLE_DBC returns SQL_NO_DATA eve= n if an error record exists.

if I request one of unimplemented info = types
SQL_DATETIME_LITERALS
SQL_STANDARD_CLI_CONFORMANCE
SQL_XOPE= N_CLI_YEAR

=C2=A0 =C2=A0 SQLUINTEGER bitmask;
=C2=A0 =C2=A0 SQLRE= TURN rc;

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

=C2=A0 =C2=A0 =C2=A0 =C2=A0 rc =3D SQLGetDiagFie= ld(SQL_HANDLE_DBC, hdbc, 0, SQL_DIAG_NUMBER, &numRecs, 0, nullptr); // = _ASSERT(rc =3D=3D 0);
=C2=A0 =C2=A0 =C2=A0 =C2=A0 // returns SQL_NO_DATA=

=C2=A0 =C2=A0 =C2=A0 =C2=A0 // but this returns valid message
= =C2=A0 =C2=A0 =C2=A0 =C2=A0 rc =3D SQLGetDiagRec(SQL_HANDLE_DBC, hdbc, 1, N= ULL, NULL, Msg, sizeof(Msg), NULL); _ASSERT(rc =3D=3D 0);
=C2=A0 =C2=A0 = =C2=A0 =C2=A0 __debugbreak();
=C2=A0 =C2=A0 }


Also there is a= typo in function PGAPI_GetTypeInfo(HSTMT hstmt, SQLSMALLINT fSqlType) [inf= o.c]
https://git.postgresql.org/gitweb/?p=3Dpsqlodbc.git;a= =3Dblob;f=3Dinfo.c;h=3D2ce1a5acd19052c2525bdd5b2ab02701eb6cba1d;hb=3DHEAD#l= 1161
"RECISION" should be "PRECISION"
--000000000000b1f30605ce363d38--