November 2017 - problem with sql common table expressions
We are currently in the process of upgrading to the November 2017 version. I was doing some regression testing for a release after the upgrade and noticed that my applications where I had to do a common table expression in the sql load script are no longer working. There is no error code, it just runs and keeps running ( ran all night).
I've tested the query by itself a few times and it runs fine (runs in less than 15 seconds). I walked through the load script testing sections out. Any help would be appreciated.
I fixed the issue. There were some comments in the sql script that was causing the issue. I was troubleshooting sections and removing comments as I went and it ran fine after that.
