Bug in ODBC driver 15.10


Bug in ODBC driver 15.10

When issueing the following statement

select case when (1 = 0) then 1 else 0 end;

in Teradata Studio 15.00.02 using ODBC Driver Version 15.10 I receive the following weird message:

Executed as Single statement.  Failed [ 
Elapsed time = 00:00:00.000

STATEMENT 1: Select Statement failed.

When issueing the same statement using ODBC driver version 14 I get the correct result of '1'.

Any ideas? Looks like a bug to me.

Tags (3)

Re: Bug in ODBC driver 15.10

Well... result would be 0, not 1. Except that, all true.


Re: Bug in ODBC driver 15.10

You probably mean JDBC 15.10 instead of ODBC :)

I just tried it against a TD using the latest Studio release & the built-in JDBC and it worked as expected, same for ODBC & SQL Assistant.

Can you try it using BTEQ? If it still fails it's probably a parser bug (which might have been fixed already).

Re: Bug in ODBC driver 15.10

Yes, it is the JDBC driver.

I am currently at a point where I believe there may be a general problem that prevents the 15.10 drivers from working on my computer. Other, simple statements are not successful either. I may try to replace them with a newly downloaded version from the TD site.