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.