usage of ^ in logical conditions

Database

usage of ^ in logical conditions

One of our customers provided us their teradata workload for analysis.

There are queries like

SELECT  t1.c1  
, CASE WHEN t1.c2 = '1213845'
AND ^ ( t1.c3 ) IS NULL
AND ( t1.c4 = t1.c5
OR t1.c4 = t1.c6 ) THEN 1
END AS BPN
from t1

We are not able to parse this query since we expected "^" in the conditions in our grammar.



Can some one please validate if the usage ^ is correct or not.

3 REPLIES
Enthusiast

Re: usage of ^ in logical conditions

^ is an issue. Maybe you can double check with the customers if ^ is a typo mistake. In unix it is the match of beginning of a string or line. Business folks can talk in theri own lingo who knows . However it is always close to technology :).

Junior Contributor

Re: usage of ^ in logical conditions

"^" is a logical NOT, a leftover of Teradata's query language before SQL, Tequel.

Re: usage of ^ in logical conditions

Thanks dnoeth, Our customer is more than 60 years old company, so the Tequel connection might just make sense.