I have a more thousand lines "with as" sql. When I try to run it I've got a message: "Expression must have same datatype as corresponding expression", but I cannot get any info where is it and which field is not the same type. In a normal sql I can get it, but in with as I cannot. Yes I know "with as" is not the best practice, but I have to port an old sql to a new environment.
Is there any trick to get where is it?
question from:https://stackoverflow.com/questions/66048247/oracle-psql-getting-reason-of-error-in-a-with-as-expression
