One of our customers provided us their teradata workload for analysis.
There are queries like
, 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
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.
^ 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 :).