Issues with limit

More
3 years 6 months ago #13849 by campbell
campbell created the topic: Issues with limit
We have run into some interesting results with the current version.

First, when running select top 1000 from SQL server using a view to a PGNP linked server we get this Error:

OLE DB provider "PGNP" for linked server "PGNP_LinkServer" returned message "ERROR: syntax error at or near "LIMIT"
LINE 2: ...n.namesid=rel.namesid WHERE js.active LIMIT 10000 LIMIT 1000...


To me it looks like the code added two limit statements to the end of the query. If I take the Top statement away it runs normally. This used to run fine in version 1.4.0.3254

Next, When we have a view, the sql statement runs in 11 seconds natively, yet times out pulling rows from the server using the PGNP linked server, and takes 30 to 50 seconds. This is the error I get when it times out:

OLE DB provider "PGNP" for linked server "PGNP_JMS2" returned message "timeout expired
".
Msg 7330, Level 16, State 2, Line 2
Cannot fetch a row from OLE DB provider "PGNP" for linked server "PGNP_LinkServer".


Interestingly enough I can add an outrageous record amount as a limit (example limit 10000) to the postgresql query and it will return in 2 seconds. Maybe an issue with allocating memory?

Other then these issues works great for us.

Thanks,

Please Log in or Create an account to join the conversation.

More
3 years 6 months ago #13850 by Moderator
Moderator replied the topic: Re: Issues with limit
Thank you for letting us know! We are working on fixes now.

Please Log in or Create an account to join the conversation.

More
3 years 4 months ago #13855 by Moderator
Moderator replied the topic: Re: Issues with limit
The issues were fixed. Please obtain latest build from the Download page.

Thank you again for letting us know!

Please Log in or Create an account to join the conversation.

Time to create page: 0.105 seconds
Powered by Kunena Forum