On 29 January 2018 at 16:44, Bruce Momjian <br...@momjian.us> wrote: > I think the question is how does it handle cases it doesn't support? > Does it give wrong answers? Does it give a helpful error message? Can > you summarize that?
I'm happy to report that it gives correct answers to every known MERGE test, except * where it hits a concurrency issue and throws SQLCODE = ERRCODE_T_R_SERIALIZATION_FAILURE and the standard text for that * where it hits an unsupported feature and throws SQLCODE = ERRCODE_FEATURE_NOT_SUPPORTED, with appropriate text but of course Robert is correct and everything benefits from further review. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
