Teradata SQL Assistant Hangs when column contains only Space as values.

Database

Teradata SQL Assistant Hangs when column contains only Space as values.

Hi,

I am using Teradata SQL Assistant 13.11.0.04 .

Database version is 13.10.05.03

Provider version is 13.00.00.02

If any value in the table contain spaces and the datatype of that column is varchar , then my SQL assistant hangs while fetching the result set.


It becomes non responding and then I have to restart it again.

For example , following query ( sel * from test) results in hanging of SQL assistant.

create table test 

( a integer,

b varchar(10));

insert into test values ( 1,'');

Sel * from test;

Can you please suggest what is the root cause of this problem.

Thanks

Chanchal Preet Singh

Tags (1)