Remaining sql/json patches

Edit
ID 4377
Title Remaining sql/json patches
Topic SQL Commands
Created 2023-06-19 08:33:54
Last modified 2024-04-08 09:03:41 (8 months ago)
Latest email 2024-04-08 09:08:29 (8 months ago)
Status
2024-03: Committed
2024-01: Moved to next CF
2023-11: Moved to next CF
2023-09: Moved to next CF
2023-07: Moved to next CF
Target version
Authors Amit Langote (amitlan), Nikita Glukhov (n.glukhov)
Reviewers Become reviewer
Committer Amit Langote (amitlan)
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4377
git checkout commitfest/cf/4377
Emails
remaining sql/json patches
First at 2023-06-19 08:31:57 by Amit Langote <amitlangote09 at gmail.com>
Latest at 2024-04-08 09:08:29 by Amit Langote <amitlangote09 at gmail.com>
Latest attachment (v51-0001-Fix-JsonExpr-deparsing-to-emit-QUOTES-and-WRAPPE.patch) at 2024-04-07 13:36:38 from Amit Langote <amitlangote09 at gmail.com>
    Attachment (v51-0001-Fix-JsonExpr-deparsing-to-emit-QUOTES-and-WRAPPE.patch) at 2024-04-07 13:36:38 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v50-0001-JSON_TABLE-Add-support-for-NESTED-columns.patch) at 2024-04-05 12:34:58 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-add-test-for-nested-path-clause-json_table.for_v49_0002) at 2024-04-04 07:50:02 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v49-0001-validate-parsing-back-json_table.no-cfbot) at 2024-04-04 06:41:48 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v49-0002-JSON_TABLE-Add-support-for-NESTED-columns.patch) at 2024-04-03 12:38:59 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v48-0001-minor-refactor-transformJsonTableColumns.only_for_v48_0001) at 2024-04-03 07:15:57 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v48-0001-Add-JSON_TABLE-function.patch) at 2024-04-02 13:57:21 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v45-0001-propagate-passing-clause-to-every-json_ta.based_on_v45) at 2024-04-02 13:26:54 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v47-0001-propagate-passing-clause-to-every-json_table_.no-cfbot) at 2024-04-02 06:54:13 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v47-0001-add-more-json_table-tests.no-cfbot) at 2024-04-01 08:56:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v47-0002-JSON_TABLE-Add-support-for-NESTED-columns.patch) at 2024-03-29 14:01:05 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v46-0001-improve-regress-coverage-test-based-on-v46.no-cfbot) at 2024-03-29 03:20:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v46-0001-Add-JSON_TABLE-function.patch) at 2024-03-28 05:23:09 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v45-0001-JSON_TABLE.patch) at 2024-03-21 16:08:11 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v44-0001-Add-SQL-JSON-query-functions.patch) at 2024-03-20 12:53:52 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v43-0002-Many-fixes-and-refactoring.patch) at 2024-03-19 10:45:43 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v42-0001-miscellaneous-fix-based-on-v42.no-cfbot) at 2024-03-11 09:20:38 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v42-0001-minor-refactor-SQL-JSON-query-functions-based.no-cfbot) at 2024-03-07 13:46:40 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (flamegraph.svg) at 2024-03-07 11:02:27 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: No)
    Attachment (v42-0002-Show-function-name-in-TableFuncScan.patch) at 2024-03-07 07:26:08 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (jsonb_33keys.sql) at 2024-03-07 02:50:09 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (sql_json_big_attribute_test.sql) at 2024-03-06 13:22:12 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (memory.txt) at 2024-03-05 21:30:20 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: No)
    Attachment (v41-0002-Show-function-name-in-TableFuncScan.patch) at 2024-03-05 01:21:54 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v40-0002-Show-function-name-in-TableFuncScan.patch) at 2024-03-04 09:40:10 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (sql_json.png) at 2024-02-14 00:00:00 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (v1-0001-handle-various-jsonpath-methods-in-jspI.v39_001_changes) at 2024-02-05 12:27:54 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v1-0001-minor-refactor-coerceJsonFuncExprOutput.no-cfbot) at 2024-01-25 14:39:30 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (minor_fix_v38.diff) at 2024-01-25 09:20:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v39-0002-Show-function-name-in-TableFuncScan.patch) at 2024-01-25 09:09:42 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v38-0002-Show-function-name-in-TableFuncScan.patch) at 2024-01-24 13:11:54 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v37-0006-Show-function-name-in-TableFuncScan.patch) at 2024-01-23 13:46:06 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-minor-refactor-transformJsonFuncExpr.based_on_v36) at 2024-01-23 08:51:55 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v36-0004-Add-jsonpath_exec-APIs-to-use-in-SQL-JSON-query-.patch) at 2024-01-22 14:27:58 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (test_coerce.sql) at 2024-01-22 06:14:07 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (v35-0001-only-allow-Const-node-or-scalar-returning-fun.no-cfbot) at 2024-01-22 00:00:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (0001-Show-function-name-in-TableFuncScan.patch) at 2024-01-18 17:11:18 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v35-0003-Refactor-code-used-by-jsonpath-executor-to-fetch.patch) at 2024-01-18 13:35:41 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v34-0005-Add-a-jsonpath-support-function-jspIsMutable.patch) at 2024-01-18 13:12:57 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-refactor-ExecInitJsonExpr.no-cfnot) at 2024-01-03 10:50:26 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v33-json_table.nocfbot) at 2023-12-22 13:01:05 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v33-0002-Add-json_populate_type-with-support-for-soft-err.patch) at 2023-12-20 08:36:25 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (test.patch) at 2023-12-15 08:36:41 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v32-0001-Add-soft-error-handling-to-some-expression-nodes.patch) at 2023-12-14 08:04:46 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v31-0004-Simplify-productions-for-FORMAT-JSON-ENCODING-na.patch) at 2023-12-08 10:34:29 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-simplify-json_format_clause-by-removing-the-opt-part.patch) at 2023-12-07 18:41:55 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v30-0002-Add-soft-error-handling-to-populate_record_field.patch) at 2023-12-07 12:07:59 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v29-0001-Add-soft-error-handling-to-some-expression-nodes.patch) at 2023-12-07 09:32:06 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-Fix-spurious-tab-characters.patch.nocfbot) at 2023-12-07 08:25:41 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v28-0005-JSON_TABLE-don-t-assign-precedence-to-NESTED-PAT.patch) at 2023-12-06 14:02:21 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v27-0002-Add-soft-error-handling-to-populate_record_field.patch) at 2023-12-05 12:25:01 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-handle-key-words-empty-array-and-empty-object.nocfbot) at 2023-11-28 02:00:56 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (yydata.png) at 2023-11-24 12:27:56 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: No)
    Attachment (ExecInitJsonExpr_minor_refactor.nocfbot) at 2023-11-24 08:41:45 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v26-0002-Add-soft-error-handling-to-populate_record_field.patch) at 2023-11-22 06:09:36 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-Put-keywords-in-right-order.patch.nocfbot) at 2023-11-21 07:09:17 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v25-0005-Claim-SQL-standard-compliance-for-SQL-JSON-featu.patch) at 2023-11-16 06:53:30 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v24-0005-Claim-SQL-standard-compliance-for-SQL-JSON-featu.patch) at 2023-11-15 13:00:41 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001_proerrsafe_attr_v1.patch) at 2023-11-01 12:00:52 from Nikita Malakhov <hukutoc at gmail.com> (Patch: Yes)
    Attachment (v22-0001-add-some-test-refactor-ExecEvalJsonExpr.patch) at 2023-10-18 02:19:43 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v23-0003-1-transformJsonExprCommon-fixup.patch) at 2023-10-16 08:20:58 from Nikita Malakhov <hukutoc at gmail.com> (Patch: Yes)
    Attachment (v23-0001-Add-soft-error-handling-to-some-expression-nodes.patch) at 2023-10-11 12:34:07 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (iocoerce-llvm-fixes.diff) at 2023-10-06 09:23:37 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v22-0002-Add-soft-error-handling-to-populate_record_field.patch) at 2023-09-29 04:57:46 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v21-0001-Add-soft-error-handling-to-some-expression-nodes.patch) at 2023-09-28 04:35:16 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (regression.diffs) at 2023-09-27 14:23:39 from Erik Rijkers <er at xs4all.nl> (Patch: Yes)
    Attachment (v20-0005-Claim-SQL-standard-compliance-for-SQL-JSON-featu.patch) at 2023-09-27 13:55:04 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v19-0001-Add-soft-error-handling-to-some-expression-nodes.patch) at 2023-09-21 12:41:32 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v18-0002-Add-soft-error-handling-to-populate_record_field.patch) at 2023-09-21 08:32:01 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Support-for-soft-error-handling-during-CoerceVia.patch) at 2023-09-19 12:51:39 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Support-for-soft-error-handling-during-CoerceVia.patch) at 2023-09-19 11:56:43 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-0001-fixup-use-struct-ErrorSaveContext-not-Node.notpatch) at 2023-09-19 10:18:49 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (crash_20120918.txt) at 2023-09-18 11:14:52 from Erik Rijkers <er at xs4all.nl> (Patch: No)
    Attachment (v15-0005-Claim-SQL-standard-compliance-for-SQL-JSON-featu.patch) at 2023-09-18 03:15:40 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v14-0005-Claim-SQL-standard-compliance-for-SQL-JSON-featu.patch) at 2023-09-14 08:14:51 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v13-0004-Claim-SQL-standard-compliance-for-SQL-JSON-featu.patch) at 2023-09-01 04:52:15 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Support-soft-error-handling-during-CoerceViaIO-e.patch) at 2023-08-31 12:57:27 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v11-0003-Claim-SQL-standard-compliance-for-SQL-JSON-featu.patch) at 2023-08-04 12:21:49 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (json_func_doc_v1.diff) at 2023-07-27 09:36:35 from "Shinoda, Noriyoshi (HPE Services Japan - FSIP)" <noriyoshi.shinoda at hpe.com> (Patch: Yes)
    Attachment (v10-0002-Rename-a-nonterminal-used-in-SQL-JSON-grammar.patch) at 2023-07-21 10:33:11 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Code-review-for-commit-b6e1157e7d.patch) at 2023-07-20 08:19:02 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-Code-review-for-commit-b6e1157e7d.patch) at 2023-07-19 08:17:21 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v8-0005-Claim-SQL-standard-compliance-for-SQL-JSON-featur.patch) at 2023-07-18 09:11:06 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Unify-JSON-categorize-type-API-and-export-for-ext.patch) at 2023-07-14 07:13:17 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-trivial-fixups.notpatch) at 2023-07-13 16:54:13 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v6-0001-Unify-JSON-categorize-type-API-and-export-for-ext.patch) at 2023-07-13 03:47:27 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v5-0007-Claim-SQL-standard-compliance-for-SQL-JSON-featur.patch) at 2023-07-12 13:23:42 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v4-0003-Unify-JSON-categorize-type-API-and-export-for-ext.patch) at 2023-07-12 09:41:19 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v3-0006-Claim-SQL-standard-compliance-for-SQL-JSON-featur.patch) at 2023-07-10 12:56:27 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v2-0002-Don-t-include-CaseTestExpr-in-JsonValueExpr.forma.patch) at 2023-07-07 12:19:40 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (gram-json-indent.patch.nocfbot) at 2023-07-07 11:30:58 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v1-0001-SQL-JSON-functions.patch) at 2023-06-21 08:25:32 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-SQL-JSON-query-functions.patch) at 2023-06-19 08:31:57 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
History
When Who What
2024-04-08 09:03:41 Amit Langote (amitlan) Closed in commitfest 2024-03 with status: Committed
2024-03-18 12:04:02 Amit Langote (amitlan) Added amitlan as committer
2024-02-01 18:07:45 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
2023-12-04 10:19:38 John Naylor (john.naylor) Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-02 10:00:34 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-03 08:19:46 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2023-07 with status: Moved to next CF
2023-06-19 08:35:09 Amit Langote (amitlan) Changed authors to Amit Langote (amitlan), Nikita Glukhov (n.glukhov)
2023-06-19 08:33:54 Amit Langote (amitlan) Attached mail thread CA+HiwqE4XTdfb1nW=Ojoy_tQSRhYt-q_kb6i5d4xcKyrLC1Nbg@mail.gmail.com
2023-06-19 08:33:54 Amit Langote (amitlan) Created patch record
Edit