Toad World® Forums

TDP 3.8.0.575- Sybase IQ statements with trailing g

I think I’ve discovered an issue with Toad Data Point’s editor and connections with Sybase IQ. If you have a trailing ‘g’ character in your statement it will not execute as expected. For example running the following code you would expect the result to have a column name of ‘eGg’. When executing on Sybase the column returned is ‘eG’ and when excuted on MSSQL results return as expected, with column ‘eGg’

tdp_sybase_g.jpeg

DECLARE @a VARCHAR(5)

SET @a = ‘a’

SELECT @a as eGg

TDP 3.8.0.575

Win 10 64BIT

Thanks for reporting the issue.

I created QAT-6985 to track it.

Regards

Aleksey