linked server fails to parse statement with boolean field

Report PGNP bugs.

linked server fails to parse statement with boolean field

Postby datarequests » Tue Jul 12, 2011 9:11 am

This seems like a bug. I am querying against a PGSQL server from MS SQL Server via a linked server using PGNP-1.3.0.2232. The query returns this error message:
OLE DB provider "PGNP" for linked server "<servername>" returned message
"** ERROR: Failed to parse statement:
select item_id
from item
where (item.withdrawn is false)".

The query runs as-is when it is run directly on the PGNP server. It also runs as-is using a different linked server based on psqlodbc_09_00_0200. So I think that syntax should be fully acceptable to PGNP. The fix I have used is to change the query in the where clause to: where (item.withdrawn = 'f'). But I don't think I should have to do that. It looks to me like PGNP is not handling the boolean keywords properly.
datarequests
 
Posts: 1
Joined: Tue Jul 12, 2011 8:55 am

Re: linked server fails to parse statement with boolean field

Postby Moderator » Wed Jul 13, 2011 7:53 am

Yes, this is a bug in the provider. We are working on a fix.
User avatar
Moderator
Site Admin
 
Posts: 306
Joined: Wed Oct 29, 2008 11:27 pm


Return to Report Bugs

Who is online

Users browsing this forum: No registered users and 1 guest

cron