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 1lz5sv-0002eu-FZ for pgsql-odbc@arkaria.postgresql.org; Thu, 01 Jul 2021 23:14:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lz5su-0000dQ-Eh for pgsql-odbc@arkaria.postgresql.org; Thu, 01 Jul 2021 23:14:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lz4dm-0001Hb-UW for pgsql-odbc@lists.postgresql.org; Thu, 01 Jul 2021 21:54:35 +0000 Received: from mail-eopbgr90084.outbound.protection.outlook.com ([40.107.9.84] helo=FRA01-MR2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lz4de-0007Wz-VV for pgsql-odbc@postgresql.org; Thu, 01 Jul 2021 21:54:33 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=FUT7Nh1uwsG2MUTzd1yJQNmSPam9FEBdQlX5d2tDC1BtlkPdkzlS741W63OMCnxbjYpg+z8pEuZXWuvwm3ik7AewLv7HMIrC2thOJkw2OTIyIUwvpk0E4d82ghqC8MOnEoj4REAzMbrBLZfMSHqyxBvVh8nalP1CCelTo4BxJ3AqlEYoCfCEq9p8c4IMqOxJYyfdyUxehGG9Hl224NffG/DgqJWo+uow7WtcJBvkBQzWD1XVZFzGCNpUZ4HHZ3uangeakZoMuKzmXOY8kVOxsl6KLTc+I6VYdoEM+ajlk1orErBnhjIWTtsH9JjtESuMKSq6zQYAJDs+OrmLE3zLsQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=caAT9uGEf52zW++Q1mj3/xfEuPFbOVk6YI1RHWw/YV8=; b=liFi3oL8NqRNiU5X4NQJPvCRtRhnbb37c/J76FCevvUrrzInpz34IYPMOXKgMZ+4lCQB4C5t2vfDqk9QhCG4B2ng6887UEY/wQ10EXdE4U1Vh8O2W8wyCYUI7zx2I49pa02fhd7XqblczXmFj+W947AgK5R2hrrZqONOFjM0c+YlPMYHqAhKTme3ozydf+YKZSd35JD27/0QUF+Fzc0jZ1MN01mqDpnQdFA9Q0TA7IH80jf6yWlS1K481N7O8QzKp8Gbnm0Yyc7MR91CPuyceBqaZqedpPQ4EVDoTjkmdSj/oBPUY6jyeYofTLzS06qiVB33xXxwh1RGrR0IboxySQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=decision-network.eu; dmarc=pass action=none header.from=decision-network.eu; dkim=pass header.d=decision-network.eu; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=decisionnetwork.onmicrosoft.com; s=selector1-decisionnetwork-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=caAT9uGEf52zW++Q1mj3/xfEuPFbOVk6YI1RHWw/YV8=; b=bx5m2+njxn/L10wSzVMrB2axExqCxwsYEKbIjv4KgKPAi/aDRBlLgZPRwGHJdKa5T7ApZqAWEn4Dzniar63SI1mZD0sqK4keYf/DEknqoxUJpe/kdTDu2tI4cy+dTzykFm8JJZd3SV9+DDnCd/DzLhEsNSMKyGP6lRRMHsxqAY0= Received: from PR0P264MB1355.FRAP264.PROD.OUTLOOK.COM (2603:10a6:102:162::13) by PR0P264MB1769.FRAP264.PROD.OUTLOOK.COM (2603:10a6:102:168::16) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4287.23; Thu, 1 Jul 2021 21:54:23 +0000 Received: from PR0P264MB1355.FRAP264.PROD.OUTLOOK.COM ([fe80::412a:6c85:262f:7be]) by PR0P264MB1355.FRAP264.PROD.OUTLOOK.COM ([fe80::412a:6c85:262f:7be%6]) with mapi id 15.20.4287.023; Thu, 1 Jul 2021 21:54:23 +0000 From: Vincent Fayolle To: "pgsql-odbc@postgresql.org" Subject: ODBC attribute not implemented ? Thread-Topic: ODBC attribute not implemented ? Thread-Index: AdduwMId65qQ4dnOQZCLl87Tvez7Ew== Date: Thu, 1 Jul 2021 21:54:23 +0000 Message-ID: Accept-Language: fr-FR, en-US Content-Language: fr-FR X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: postgresql.org; dkim=none (message not signed) header.d=none;postgresql.org; dmarc=none action=none header.from=decision-network.eu; x-originating-ip: [86.253.25.20] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: a98df40e-d384-4222-c992-08d93cdac9aa x-ms-traffictypediagnostic: PR0P264MB1769: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:7691; x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: qcqMozl47uwZLDwOvxDffZ6YWxjd5/VsiY4hQqV+Mtx6FQv9n56BLeHOgerhTzLA+ag4DeCzemEo5EANnJ7PyGnydqnU9hEQOhsNj98tdPc+JTDMGFEEhPCQsrz62scc2eOkTmYmyBxsM52LJ6SohCe7ID/MW/WBGwxGXDu8/G9tyUqf69GiPCH/ys6TbpkSEgrXDRmEEEUM5ZLNbYdTq+D8v5CSZTPJ72e2/LVxYIbpY1Q6nE2upVfE8JzOubjPRNfrZ8I0NOoOkdibGC7T1gXAsb356oN/B1o0HBzUiV1PxU6ME3DUnGPL1QbR5w3uF3rTxKnakeX8lDh9YDPwmqP1Tb3nwS3NI2ZVlDVpth54tNg8Wp/gtx6RwaOlmEjcE+ATHgqF3Zv/lSt27/TXm4hKIyqzcKHz0+d8C6iVLyDdkQCtI04vQ5raDsDHUhSaNVhwMUqYNdAX2q7WCee3ns2+fdVEbl4l+gQW/ZpxwvUJJPlWaT2ri9CD/jCglTm6u6PNUKv+jWWZh+0GUptFzAm1JIydRClsxcn5CHBJuUsDlNXMCBa++k9grHwb3z/D/nENAWyi/U8VZfXtQ3t7uBZWfpr4BWQRM/USk3rinK7q487jkpQDDbrb3hKn2nJfwF5fJbiERYgK8r7AwRYrxg== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:PR0P264MB1355.FRAP264.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(136003)(346002)(376002)(366004)(39830400003)(396003)(26005)(52536014)(478600001)(64756008)(6506007)(66476007)(66556008)(66446008)(83380400001)(66946007)(76116006)(186003)(55016002)(38100700002)(8676002)(122000001)(86362001)(33656002)(9686003)(3480700007)(66574015)(8936002)(2906002)(6916009)(316002)(7696005)(71200400001)(5660300002);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?9crCZSWyTury8q0JTWxxQ9unjp76DZG1pU1HcXTYDjFRaQf1iDRakpBcyf?= =?iso-8859-1?Q?rTYwNEP3eMmOwWRMbwLD6YaG09VlzpHNckPqKbhTGQ7EG1MbnH2A8sxUhM?= =?iso-8859-1?Q?xasB2gsYS5xIi6TmZIcXqkgKscubZYtX1e7wmVNGYnq9j1/9snxSO7AFRl?= =?iso-8859-1?Q?RqXkTCIzaDxr5xVgsndf5RH8tyl96qFMOo8rIJS0x3cPc2F1kJxRr1UBtb?= =?iso-8859-1?Q?N2jT2+lAT74/wdnJMkXkJLrUj83oYbTWz5R3pqoNnMhE+1AvHHSeplgWGh?= =?iso-8859-1?Q?7vXtRetJsFXlaO3pSv7NYnwI+lozpXz8FoVF/wkpSv6dE8l+bw4Ss+BX6C?= =?iso-8859-1?Q?tDpTMOt0x8i6lQq+9/vg+yzZvbbFUY76kKhqAAy3TxXABmWO13xP1Ap1W2?= =?iso-8859-1?Q?ntfHt/9ndL79vzay/ueAFjxz3+aFhAt6/cYw0SURfwDbmPm/72eb4gzy7s?= =?iso-8859-1?Q?pGUypKWHcupHufLaaCRaLQykWNikVq2HYwHmGT+94J9TSQdaELuP9SqUAW?= =?iso-8859-1?Q?dqPV8YUVSNez4cJtmhxZ671au6ZHwZHdoVG9ZZdDQYEk2RBy9rvOXcSyS2?= =?iso-8859-1?Q?C+hZQB/GXf+jL6+DBZBVmSjNFg1PYT1g5bv8161Vy+TlGxfRrJZV0lheRw?= =?iso-8859-1?Q?4yaDlG7K4DC80Vlsc+vsO8Zn2Qs6igBglyIk+5Um3Ssrq38P53Uls8XDEs?= =?iso-8859-1?Q?j2aDZLfYvmh0DDNd5nEZQl7Ya0esqICEPOsjLFZ+VD1vR9txlvMPCjAJej?= =?iso-8859-1?Q?h58ys4k5MN+I6f6LIbcSKJFRFPrlXTuDsMCfFIk2/QxjDicppVLSYbDi3V?= =?iso-8859-1?Q?A8/F40UxgrGJt2rvK3QiVV0d7jAJyQafDR9xOS6lIckS97uJWys8rx6BiW?= =?iso-8859-1?Q?33mfGZw0SqHWcRf9b3FHVuTz6pBfu8VgsOgxY7Gd5ClZ+hK9u7UsOtnR38?= =?iso-8859-1?Q?QrrknwSMZg8CQ6qoR+AgHxMdlrTGyhB/LRsoEWNc6Nn2GqmEWJ86mjk1NP?= =?iso-8859-1?Q?UF6DgMFmmdggJHus/sB3hKH0j8SIMGgF8uM1aZ0bBiZQd4ba7WtExdE6eB?= =?iso-8859-1?Q?zSEz0KItUzyOyM5k5AnHP3R7jprEOhldhZA8dkFXtwg/BhRdwPXMN7zQHJ?= =?iso-8859-1?Q?AtKhH0UHdI0e4XVooIAUBTc5wvwPahxP6p69kOfgV1/68OibaW8wxPgQlV?= =?iso-8859-1?Q?zXTNJhrCJjndaokVmllR/WjMWH6Ed5qk1o8A/HXRcaOuMo/ZcxwHKfHVKI?= =?iso-8859-1?Q?R9DinLi6mayEMGJKpnKpBIlZq5++5wRrccXjB7SkxQX3rFwzVFt3XS92hU?= =?iso-8859-1?Q?Qa1vWkkxk6rTYsGsDMNKhxyR+IShunCbV0BBOjTmrka8WQk=3D?= x-ms-exchange-transport-forked: True Content-Type: multipart/alternative; boundary="_000_PR0P264MB1355914153A4EAC2194091E1AB009PR0P264MB1355FRAP_" MIME-Version: 1.0 X-OriginatorOrg: decision-network.eu X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: PR0P264MB1355.FRAP264.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: a98df40e-d384-4222-c992-08d93cdac9aa X-MS-Exchange-CrossTenant-originalarrivaltime: 01 Jul 2021 21:54:23.2630 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 65808c95-cc49-437a-8e5e-9002d6db4463 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: M5U1tegyp+yvA+GG1d/BYk4Vk7um7A2+cTVgh+H4dKNe5jxJo0ZkyBn+8WZ7RCvgv4osKYXNuf57FUpH0PvJkoLQngLWamLnFrmStWkCwqg= X-MS-Exchange-Transport-CrossTenantHeadersStamped: PR0P264MB1769 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_PR0P264MB1355914153A4EAC2194091E1AB009PR0P264MB1355FRAP_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello everyone, I have an issue with a standard ODBC (1.0) attribute: SQL_AT= TR_MAX_ROWS When this attribute is set (it is a number), it must limit t= he number of rows returned by the query. When I check the trace, I can see that the use seems OK, and= sent to the driver (here I want to get the first 37 rows of a query) : ODBC: ENTER SQLSetStmtAttr 362 1940794843 tkvercn1 0 DOSSCHT 0x0000000006be30c0 363 1940794843 tkvercn1 0 DOSSCHT 1 364 1940794843 tkvercn1= 0 DOSSCHT 37 365 1940794843 tkvercn1 0 DOSSCHT -6 366 1940794843 tkvercn1 0 = DOSSCHT ODBC: EXIT SQLSetStmtAttr with return code 0 (SQL_SUCCESS) 367 1940794843 t= kvercn1 0 DOSSCHT But the query trace of postgre, we can see that this value o= k 37 lines is not used to limit the query (I have a select *) : 2021-07-01 23:40:43.897 CEST [11396] LOG: ex=E9cute _PLAN00= 0000000054FF00: SELECT * FROM TEST I tried on windows and centos, with the last odbc driver (v1= 3). Can I add something in the odbc.ini or this attribute is not= implemented ? Thanks for you reply... and time ! Vincent --_000_PR0P264MB1355914153A4EAC2194091E1AB009PR0P264MB1355FRAP_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

 

Hello everyone,

 

        &nbs= p;      I have an issue with a standard ODBC (1.0)= attribute: SQL_ATTR_MAX_ROWS

 

        &nbs= p;      When this attribute is set (it is a number= ), it must limit the number of rows returned by the query.

 

        &nbs= p;      When I check the trace, I can see that the= use seems OK, and sent to the driver (here I want to get the first 37 rows= of a query) :

 <= /p>

ODBC: ENTER SQLSetStmtAttr 362 1940794843 tkvercn1 0= DOSSCHT

        &nbs= p;    0x0000000006be30c0 363 1940794843 tkvercn1 0 DOSS= CHT

        &nbs= p;            &= nbsp;        1 <SQL_ATTR_MAX_= ROWS> 364 1940794843 tkvercn1 0 DOSSCHT

        &nbs= p;            &= nbsp;       37 365 1940794843 tkv= ercn1 0 DOSSCHT

        &nbs= p;            &= nbsp;       -6 <SQL_IS_INTEGER> 36= 6 1940794843 tkvercn1 0 DOSSCHT

ODBC: EXIT SQLSetS= tmtAttr with return code 0 (SQL_SUCCESS) 367 1940794843 tkvercn1 0 DOSSCHT<= o:p>

 

        &nbs= p;      But the query trace of postgre, we can see= that this value ok 37 lines is not used to limit the query (I have a = select *) :

 

        &nbs= p;      2021-07-01 23:40:43.897 CEST [11396] LOG:&= nbsp; ex=E9cute _PLAN000000000054FF00: SELECT * FROM TEST

 

        &nbs= p;      I tried on windows and centos, with the la= st odbc driver (v13).

 

        &nbs= p;      Can I add something in the odbc.ini or thi= s attribute is not implemented ?

 

        &nbs= p;      Thanks for you reply… and time = !

 

        &nbs= p;      Vincent

 

 

--_000_PR0P264MB1355914153A4EAC2194091E1AB009PR0P264MB1355FRAP_--