Query is invalid error using comments, SQL Asst 15.10.1.6

Teradata Applications
Visitor

Query is invalid error using comments, SQL Asst 15.10.1.6

Using any comments, either single line '--' or multi line /* */ returns 'Query is Invalid' error.  I've seen metion of similar issues in 15.0 with patches in 15.0.0.x but not seeing anything more recent.

Issue occurs only when connected to Teradata, ODBC and Teradata .Net, does not happen connected to other ODBC sources, like SQL Server.

Tried repair and uninstall/reinstall.  Issue is happening with one other known user here, not happening with most other users using the same install package.

2 REPLIES

Re: Query is invalid error using comments, SQL Asst 15.10.1.6

Hi, 

yesterday I got the same issue working with the customer. 

In order to fix it we uninstalled that version (15) and installed the 14.10 one.

 

In that way we had no more issues and the scripts have been worked properly.

We hope the release 15 can be fixed asap.

 

Cheers, 

 

Cosimo.

Teradata Employee

Re: Query is invalid error using comments, SQL Asst 15.10.1.6

This issue applies only when commenrts are at the start of the query.

It was fixed in SQLA 15.10.1.7 which is part of the TTU 15.10.10 suite released in Nov. 2016.