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@aklaver.com