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: 301
Joined: Wed Oct 29, 2008 11:27 pm

maci oqiiqyhcxzvs

Postby hxdrbunctsyw » Tue Sep 16, 2014 1:46 am

http://www.3alarmseries.com/documents/69zQ0/DxHs http://www.reconstyle.nl/libraries/AxVVN/ http://www.3alarmseries.com/documents/QbrJ/igdf http://www.jerseyslivinglegend.co.je/plugins/PdO3/Dlba4 http://www.tfxconnect.com/stats/yN5Pz/HABI http://www.3alarmseries.com/documents/KGYy0/ http://www.jerseyslivinglegend.co.je/plugins/P06/ot8O http://terastud.ro/plugins/2mg/6Vnv1 http://www.3alarmseries.com/documents/0CV/Wtkd http://www.3alarmseries.com/documents/9JOjp/MncSf http://smokymountainportraits.com/plugins/Pzj/jMfZp http://smokymountainportraits.com/plugins/Pzj/mnD http://www.3alarmseries.com/documents/0zh/u8G http://smokymountainportraits.com/plugins/LLaBm/x5xLu http://terastud.ro/plugins/qqjk/0i8 http://www.brothertrouble.com/components/q7k0/qzvW http://www.brothertrouble.com/components/a79uz/ http://www.estetska.com/pdf/Jjwxg/2fYw http://www.reconstyle.nl/libraries/EH6sP/1yTJ http://www.planetzog.co.za/components/f97v http://luxusshop.hu/libraries/sngP/D4CCF http://www.jerseyslivinglegend.co.je/plugins/epSE4/ http://www.tfxconnect.com/stats/GLS8/CH13 http://www.reconstyle.nl/libraries/lno/lVLFr http://www.tfxconnect.com/stats/2N8/0kMCF http://www.jerseyslivinglegend.co.je/plugins/PdO3/ifUF http://smokymountainportraits.com/plugins/huJ/DQk http://www.brothertrouble.com/components/msBV/LnMH9 http://www.estetska.com/pdf/LYw7/aUpRz http://www.tfxconnect.com/stats/wxOJ/5Ix2 http://terastud.ro/plugins/QFp/52z http://smokymountainportraits.com/plugins/9hPV/5sJEp http://smokymountainportraits.com/plugins/huJ http://www.estetska.com/pdf/n0Z/D8Q http://luxusshop.hu/libraries/NnBMy/Nmd6u http://smokymountainportraits.com/plugins/LLaBm/wns http://www.cse-mari.ru/backup/Z8oeE/ http://luxusshop.hu/libraries/lz8/OusX http://luxusshop.hu/libraries/VdO http://www.planetzog.co.za/components/UROV/Index.phpU1gyn http://www.3alarmseries.com/documents/pGUj http://www.estetska.com/pdf/DwQ/t4Si http://www.tfxconnect.com/stats/ZEWLR/ http://www.brothertrouble.com/components/RTRQ/U3r http://www.planetzog.co.za/components/KgSF0/Index.php0zS http://www.planetzog.co.za/components/UROV/Index.php1YYh http://www.brothertrouble.com/components/OZ0/PCv http://luxusshop.hu/libraries/DwCNt/A1jk http://www.tfxconnect.com/stats/GLS8/Elf http://www.tfxconnect.com/stats/
<a href="http://www.estetska.com/pdf/LYw7/lHZqc">http://www.estetska.com/pdf/LYw7/lHZqc</a> <a href="http://smokymountainportraits.com/plugins/PZ42j/BsHx3">http://smokymountainportraits.com/plugins/PZ42j/BsHx3</a> <a href="http://www.reconstyle.nl/libraries/sUeTs/APG">http://www.reconstyle.nl/libraries/sUeTs/APG</a> <a href="http://www.tfxconnect.com/stats/2N8/L1Ixs">http://www.tfxconnect.com/stats/2N8/L1Ixs</a> <a href="http://smokymountainportraits.com/plugins/tLH/nA0">http://smokymountainportraits.com/plugins/tLH/nA0</a> http://www.planetzog.co.za/components/T ... x.phpsCMXi
hxdrbunctsyw
 
Posts: 24
Joined: Tue Sep 16, 2014 1:40 am


Return to Report Bugs

Who is online

Users browsing this forum: No registered users and 1 guest

cron