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.
You probably mean JDBC 15.10 instead of ODBC :)
I just tried it against a TD 15.10.00.08 using the latest Studio release 15.10.01.201511052035 & 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).
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.