DB-Library error 102

[ohadle]

Having defined a new Sybase IQ SERVER and FOREIGN TABLE, I run a query and get this error:

postgres=> SELECT * FROM sap.bla_table
LIMIT 100
;
ERROR:  DB-Library error: DB #: 102, DB Msg: General SQL Server error: Check messages from the SQL Server, OS #: -1, OS Msg: , Level: 15

Also tried setting the server's tds_version to 5.0 but that didn't help.

[Smtgr14]

Error 102 is a syntax error on the MSSQL side.
Can you run

ALTER SERVER [SERVER NAME] 
   OPTIONS (ADD msg_handler 'notice');

Try your query again and post the output.

[ohadle]

Slightly different now:

NOTICE:  DB-Library notice: Msg #: 21, Msg state: 0, Msg: TDS: unexpected token 56, Server: [some-url.com:3000], Process: , Line: 0, Level: 10
NOTICE:  DB-Library notice: Msg #: 102, Msg state: 0, Msg: SQL Anywhere Error -131: Syntax error near 'use' on line 1, Server: [some-url.com:3000], Process: , Line: 0, Level: 15
ERROR:  DB-Library error: DB #: 102, DB Msg: General SQL Server error: Check messages from the SQL Server, OS #: -1, OS Msg: , Level: 15

[GeoffMontee]

It looks like the syntax error is with "USE":

NOTICE:  DB-Library notice: Msg #: 102, Msg state: 0, Msg: SQL Anywhere Error -131: Syntax error near 'use' on line 1, Server: [some-url.com:3000], Process: , Line: 0, Level: 15

In the most recent version of tds_fdw, it only sends the use keyword if the dbuse foreign server option is set to 1, and the default value is 0. Otherwise, it selects the database at connection time.

What version of tds_fdw are you using? I would suggest using either 1.0.8 if you want a stable release or the master branch if you want to test out WHERE and column pushdowns.

[ohadle]

I'm not really sure, but I do see a repo clone I did here :) From Aug. 14 (commit ef2afe1).
The dbuse option isn't set.

BTW it's a Sybase IQ server if that's relevant.