SQL window missworking : select count(*) from Informix dblink returns wrong number of rows

[GDA]

Issue description:
the statement select count(*) from Informix via dblink, does not work fine if it is launched in SQL-window.

Examples:
SELECT COUNT(1) FROM "systables"@DBL_KPD ;
SELECT * FROM "systables"@DBL_KPD ;

When running in command-window the results are always correct;
When running in sql-window the 2nd query returns a wrong number of records (less). This happen when we run the queies in 2 separated windows as well as when running together in the same window.

PS.
Even more strange,if in the same sql-window we run in this order the following

SELECT * FROM "systables"@DBL_KPD ;
SELECT COUNT(1) FROM (SELECT * FROM "systables"@DBL_KPD) ;

then the first select seems to work fine.

If we open a new sql window and we run together but with inverted order then the result of "select * " turns to be wrong!

SELECT COUNT(1) FROM (SELECT * FROM "systables"@DBL_KPD) ;
SELECT * FROM "systables"@DBL_KPD ;

-----------------------
My PSD-settings :

PL/SQL Developer
Version 9.0.6.1665
01.79638 - 50 user license
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4.194.304 kB (4.194.304 available)
Paging file : 4.194.304 kB (4.194.304 available)
Virtual memory : 2.097.024 kB (1.688.900 available)

Parameters
C:\Program Files (x86)\PLSQL Developer\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: False

 

[Marco Kalter]

You are running into a known transparent gateway bug. In the current 10.0 version we have a workaround whereby you can add the NoTableDescribe parameter in the Params.ini file in the PL/SQL Developer installation directory:

NoTableDescribe=1