From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: kristone@hotmail.com
Subject: BUG #18606: syntax error at or near "ROWS"
Date: Mon, 09 Sep 2024 07:40:41 +0000
Message-ID: <18606-7a775256cbcf4c1e@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18606
Logged by: Kristian Ivarsson
Email address: kristone@hotmail.com
PostgreSQL version: 16.4
Operating system: Microsoft Windows 10 Enterprise Version 10.0.19044
Description:
Using installed version16.4 (even though SQL_DBMS_NAME says version 16.0.4)
with driver PSQLODBC35W.DLL version 13.02.0000)
This error occurs only with some statements when using binding parameters
through ODBC
This statement is an example of when the error occurs
```SELECT "Id","Begin","End","Logfile" FROM "ServerSession" ORDER BY "Begin"
ASC OFFSET ? ROWS FETCH FIRST ? ROW ONLY```
but some more complex SQL statements (with ```OFFSET ? ROWS FETCH FIRST ?
ROW ONLY```) works just fine
Having fixed values (e.g. ```OFFSET 100 ROWS FETCH FIRST 10 ROW ONLY```)
works just fine
I still haven't figured out the pattern what the differences really are that
make some statements to work and some not to work (I haved dugged into the
open source code at all (yet))
/ Kristian
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, kristone@hotmail.com
Subject: Re: BUG #18606: syntax error at or near "ROWS"
In-Reply-To: <18606-7a775256cbcf4c1e@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox