On 5/30/23 8:53 AM, Marc Millas wrote:
Thanks Adrian, but if the query becomes more complex, for example with a few joins more, then even casting doesn't work. This comes from a prod environment and even casting NULLs (which is more than strange, BTW) generates absurd errors. Too my understanding it looks like the parser did not parse the select distinct as we think he does.
Per Hubert we will need to see the complex query to be able to troubleshoot it.
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx
