model-writtenrun 7788 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Alexander Korotkov opened the thread with a patch forcing strict mode after .** to prevent duplicate results caused by lax-mode array unwrapping, proposing the behavior change for PostgreSQL 14 without backpatching #1.
- Alvaro Herrera objected to switching modes midway and proposed requiring strict mode for .**, while Korotkov considered disabling array unwrapping only for the following accessor #2 #3; Herrera also suggested chaining queries when different modes were needed #5.
- Thomas Kellerer identified himself as the original reporter and advocated documenting the strict-mode recommendation #4; Korotkov agreed documentation needed backpatching and favored preserving behavior because restricting all lax-mode queries would affect cases without duplicate results #6 #7.
- Korotkov posted documentation explaining how recursive selection and automatic array unwrapping produce duplicates, with lax- and strict-mode examples; Tom Lane then polished its wording without changing its substance #8 #9.
- The thread ends with Lane's revision #9, which subsequently landed unchanged as b41645460a and was backpatched through PostgreSQL 12; the execution change was left aside pending further complaints #7.