Hi, Thanks for the clarification. from my testing, the current implementation generates invalid code when multiple header assignments are used, so rejecting the syntax avoids the issue for now.
That said, supporting multiple COUNT assignments could be useful, but it would need changes in the code generation. It might be worth checking how this is handled in the SQL standard or other precompilers.
> After applying the patch and rebuilding ecpg, the same statement is now rejected > during preprocessing with a syntax error. So the patch works as expected.
His patch may work well, but I'm unclear whether it's the correct way to fix. See my question [1]:
``` IIUC, there is another approach, allowing to specify multiple COUNT clause in the SET/GET DESCRIPTOR. E.g., ```
We may have to follow SQL standard or other precompilers like Pro*C. (Not sure we should spend the effort for the investigation though)
