Re: SQL Property Graph Queries (SQL/PGQ)

Junwang Zhao <zhjwpku@gmail.com>

From: Junwang Zhao <zhjwpku@gmail.com>

To: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>

Cc: Vik Fearing <vik@postgresfriends.org>, Ajay Pal <ajay.pal.k@gmail.com>, Imran Zaheer <imran.zhir@gmail.com>, Peter Eisentraut <peter@eisentraut.org>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2025-02-10T15:00:05Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix some typos and make small stylistic improvements
- 5282bf535e47 19 (unreleased) landed
Cleanup users and roles in graph_table_rls test
- 040a56be4bcc 19 (unreleased) landed
Dump labels in reproducible order
- c9babbc8816a 19 (unreleased) landed
SQL Property Graph Queries (SQL/PGQ)
- 2f094e7ac691 19 (unreleased) landed
Factor out constructSetOpTargetlist() from transformSetOperationTree()
- 8c2b30487cc7 19 (unreleased) landed
Sort out table_open vs. relation_open in rewriter
- d537f59fbbfc 19 (unreleased) landed
Rename grammar nonterminal to simplify reuse
- 8080f44f96a9 19 (unreleased) landed
Make ecpg parse.pl more robust with braces
- 7f88553ceaca 19 (unreleased) landed
Don't lock partitions pruned by initial pruning
- 525392d5727f 18.0 cited
Remove pg_regex_collation
- 792b2c7e6d92 18.0 cited
Use auxv to check for CRC32 instructions on ARM.
- aac831cafa6f 18.0 cited
Fix inappropriate uses of atol()
- f5a1311fccd2 18.0 cited
Remove unnecessary array object_classes[] in dependency.c
- ef5e2e90859a 17.0 cited

Attachments

v10-0011-do-not-use-default-COLLATE.patch (application/octet-stream) patch v10-0011
v10-0012-trivial-refactor-of-property-graph-object-addres.patch (application/octet-stream) patch v10-0012
v10-0010-adapt-property-graph-to-more-intuitive-titles.patch (application/octet-stream) patch v10-0010
v10-0008-Document-fixes.patch (application/octet-stream) patch v10-0008
v10-0009-WIP-Do-not-print-empty-columns-table-for-a-prope.patch (application/octet-stream) patch v10-0009
v10-0007-RLS-tests.patch (application/octet-stream) patch v10-0007
v10-0006-Property-collation-and-edge-vertex-link-support.patch (application/octet-stream) patch v10-0006
v10-0005-Access-permissions-on-property-graph.patch (application/octet-stream) patch v10-0005
v10-0004-Fixes-following-issues.patch (application/octet-stream) patch v10-0004
v10-0003-Support-cyclic-path-pattern.patch (application/octet-stream) patch v10-0003
v10-0002-support-WHERE-clause-in-graph-pattern.patch (application/octet-stream) patch v10-0002
v10-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch (application/octet-stream) patch v10-0001

Hi Ashutosh,

On Mon, Feb 10, 2025 at 2:14 PM Ashutosh Bapat
<ashutosh.bapat.oss@gmail.com> wrote:
>
> On Thu, Feb 6, 2025 at 8:22 PM Junwang Zhao <zhjwpku@gmail.com> wrote:
> > > >
> > >
> > > I see you have added some negative tests - object not found tests, but
> > > I didn't see positive tests. Hence I haven't added those changes in
> > > the attached patchset. But we certainly need those changes. You may
> > > want to submit a patch with positive tests. That code needs to be
> > > fixed before committing anyway.
> >
> > The attached file adds the positive tests.
>
> Hi Junwang,
> Thanks for the patch, but please post it as a separate patch in the
> full patch-set, otherwise CFBot gets confused.

Ok, see the attached.

0001-0009 are the original patches of 20250127 with rebase of master
0010 fix ci error due to `Show more-intuitive titles for psql
commands`, see a14707da564e
0011 fix ci error due to unstable collation tests, we should not
depend on pg_catalog."default", I observed 002_pg_upgrade.pl failure
caused by this.
0012 trivial refactor of property graph object address

>
> --
> Best Wishes,
> Ashutosh Bapat

-- 
Regards
Junwang Zhao