Sep 2019

4 commits
Implement parse_datetime() function
25 Sep 2019Alexander Korotkovmaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1Also in: Support for jsonpath .datetime() method (modified before commit)
Implement jsonpath .datetime() method
25 Sep 2019Alexander Korotkovmaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1Also in: Support for jsonpath .datetime() method (modified before commit)
Allow datetime values in JsonbValue
25 Sep 2019Alexander Korotkovmaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1Also in: Support for jsonpath .datetime() method (landed as posted)
Support for FF1-FF6 datetime format patterns
16 Sep 2019Alexander Korotkovmaster13beta1REL_19_STABLE13beta1REL_18_STABLE13beta1REL_17_STABLE13beta1REL_16_STABLE13beta1REL_15_STABLE13beta1REL_14_STABLE13beta1REL_13_STABLE13beta1Also in: Support for jsonpath .datetime() method (modified before commit)

May 2019

2 commits
Improve error reporting in jsonpath
7 May 2019Alexander Korotkovmaster12beta1REL_19_STABLE12beta1REL_18_STABLE12beta1REL_17_STABLE12beta1REL_16_STABLE12beta1REL_15_STABLE12beta1REL_14_STABLE12beta1REL_13_STABLE12beta1+1 more
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #1941 of 1 reviewer saw the final version

Takes the diagnostic component of #194, correcting remaining errdetail()/errmsg() mistakes, punctuation and expected output after #195; the documentation component landed separately.

  • Tom Lanesaw the final versiontrailerReviews in #183, #190, #192 and #195 shaped the diagnostics and identified the final message-function and punctuation corrections.
Remove word "singleton" out of jsonpath docs
7 May 2019Alexander Korotkovmaster12beta1REL_19_STABLE12beta1REL_18_STABLE12beta1REL_17_STABLE12beta1REL_16_STABLE12beta1REL_15_STABLE12beta1REL_14_STABLE12beta1REL_13_STABLE12beta1+1 more
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #194

Exactly matches the documentation component of #194, replacing singleton terminology in doc/src/sgml/func.sgml; the diagnostic component landed separately.

Apr 2019

1 commit
Minor jsonpath fixes.
17 Apr 2019Tom Lanemaster12beta1REL_19_STABLE12beta1REL_18_STABLE12beta1REL_17_STABLE12beta1REL_16_STABLE12beta1REL_15_STABLE12beta1REL_14_STABLE12beta1REL_13_STABLE12beta1+1 more
LLM analysis, 100% suremodified before commitlight changesfrom patchset #1771 of 1 reviewer saw the final version

Matches John Naylor's Makefile cleanup and diagnostic spelling correction in #177, with an additional explanatory comment beside the internal-error message.

  • Tom Lanesaw the final versioncommittercommitted the patch

Mar - Apr 2019

6 commits
GIN support for @@ and @? jsonpath operators
1 Apr 2019Alexander Korotkovmaster12beta1REL_19_STABLE12beta1REL_18_STABLE12beta1REL_17_STABLE12beta1REL_16_STABLE12beta1REL_15_STABLE12beta1REL_14_STABLE12beta1REL_13_STABLE12beta1+1 more
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #1610 of 2 reviewers saw the final version

Matches the GIN component of #161 apart from the catalog-version bump; its numeric-parsing and non-silent match fixes are separate components.

  • Jonathan Katzsaw an earlier versiontrailerBenchmarks in #117 and #119 reviewed the unindexed GIN attachment in #105 and prompted the subsequent predicate-extraction changes in #161.
  • Pavel Stehulesaw an earlier versiontrailerTesting in #111 covered the unindexed GIN attachment in #105, before #161 materially restricted predicate extraction.
Get rid of jsonpath_gram.h and jsonpath_scanner.h
20 Mar 2019Alexander Korotkovmaster12beta1REL_19_STABLE12beta1REL_18_STABLE12beta1REL_17_STABLE12beta1REL_16_STABLE12beta1REL_15_STABLE12beta1REL_14_STABLE12beta1REL_13_STABLE12beta1+1 more
LLM analysis, 99% surelanded as postedfrom patchset #132

Matches the combined grammar/scanner compilation and header removal in #132. Differences are rebasing over the already-renamed JsonPathString typedef and corresponding whitespace, confirmed against the commit's parent.

Rename typedef in jsonpath_scan.l from "keyword" to "JsonPathKeyword"
19 Mar 2019Alexander Korotkovmaster12beta1REL_19_STABLE12beta1REL_18_STABLE12beta1REL_17_STABLE12beta1REL_16_STABLE12beta1REL_15_STABLE12beta1REL_14_STABLE12beta1REL_13_STABLE12beta1+1 more
LLM analysis, 100% suremodified before commitlight changesfrom patchset #1261 of 1 reviewer saw the final version

Revises the typedef fix in #126 from KeyWord to the unique JsonPathKeyword requested in #127, with accompanying indentation changes.

  • Tom Lanesaw the final versionLLM analysis, 100% sureIn #127, Tom reviewed the attached rename and requested a globally unique typedef to avoid debugger ambiguity, which the commit adopts.
Fix make rules for jsonpath grammar making them similar to SQL grammar
17 Mar 2019Alexander Korotkovmaster12beta1REL_19_STABLE12beta1REL_18_STABLE12beta1REL_17_STABLE12beta1REL_16_STABLE12beta1REL_15_STABLE12beta1REL_14_STABLE12beta1REL_13_STABLE12beta1+1 more
LLM analysis, 100% surewritten from the discussion, no matching patch

Implements the generated-file cleanup and dependency corrections discussed in #106, #108 and #109. In #113, Alexander says this fix is already pushed before attaching a different Windows-only patch.

Numeric error suppression in jsonpath
16 Mar 2019Alexander Korotkovmaster12beta1REL_19_STABLE12beta1REL_18_STABLE12beta1REL_17_STABLE12beta1REL_16_STABLE12beta1REL_15_STABLE12beta1REL_14_STABLE12beta1REL_13_STABLE12beta1+1 more
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #1031 of 1 reviewer saw the final version

The numeric-suppression component of #103 has identical added and removed lines, introducing optional-error numeric APIs without PG_TRY/PG_CATCH; the core component landed separately.

  • Tomas Vondrasaw the final versiontrailerAlexander reports in #104 that Tomas completed an off-list review of both final patches in #103 with no remaining notes.
Partial implementation of SQL/JSON path language
16 Mar 2019Alexander Korotkovmaster12beta1REL_19_STABLE12beta1REL_18_STABLE12beta1REL_17_STABLE12beta1REL_16_STABLE12beta1REL_15_STABLE12beta1REL_14_STABLE12beta1REL_13_STABLE12beta1+1 more
LLM analysis, 100% surepart of a posted patchsetlight changesfrom patchset #1032 of 4 reviewers saw the final version

Matches the core implementation component of #103, with catalog OID assignments, a catversion bump and minor datetime-note wording changes; numeric suppression landed separately.

  • Tomas Vondrasaw the final versiontrailerTomas repeatedly reviewed and tested the engine, including valgrind testing in #98, with final off-list review of #103 confirmed in #104.
  • Andrew Dunstansaw an earlier versiontrailerAndrew reviewed representation and datetime handling in #10 and NaN serialization in #99, before the pointer-helper and interrupt changes in #102.
  • Pavel Stehulesaw an earlier versiontrailerPavel reported testing the initial jsonpath implementation in #2 and #4, before substantial interface and error-handling rework.
  • Alexander Korotkovsaw the final versiontrailerAlexander reviewed the earlier implementation in #49 and #53, revised the final submission and reviewed the committed version as committer.

Credits across 13 commits

Author
Alexander Korotkov3 LLM11
Nikita Glukhov7
Oleg Bartunov5
Teodor Sigaev5
Liudmila Mantrova3
John NaylorLLM1
Reviewer
Anastasia Lubennikova4
Peter Eisentraut4
Pavel Stehule2
Tom Lanecommitter2
Tomas Vondra2
Alexander Korotkov1
Andrew Dunstan1
Jonathan S. Katz1
Reported by
Tom Lane2
Jeff Janes1
Committer
Alexander Korotkov12
Tom Lane1

N LLM means N of the credits come from LLM analysis, not from commit trailers.