Remaining sql/json patches

Edit
Title Remaining sql/json patches
Topic SQL Commands
Created 2023-06-19 08:33:54
Last modified 2024-04-08 09:03:41 (2 weeks, 5 days ago)
Latest email 2024-04-08 09:08:29 (2 weeks, 5 days 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
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