On 8 March 2016 at 08:56, Igal @ Lucee.org <igal@lucee.org> wrote:
I'm not sure why it was not accepted at the end?
The biggest issue, though it might not be clear from that thread, is that what exactly it means to "return generated keys" is poorly defined by JDBC, and not necessarily the same thing as "return the PRIMARY KEY".
Should we return the DEFAULT on a UNIQUE column, for example?
IMO other vendors' drivers should be tested for behaviour in a variety of cases. Ideally the JDBC test suite too. Then specify the exact behaviour of what we need to satisfy the JDBC driver's requirements and anything else that might be related.