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
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.