I have teradata stored procedure which has a query with a group by. The group by has some constants as well.
When I run the query in prod environment, sometimes I get anerror
"SQL_STATE:53003|SQL_CODE:3883|OUT_ERR_MSG:Invalid Group BY constant" . When I re run the query this issue goes off. I am not able to replicate this error in any other environments as well.
Please provide your inputs for the same