Re: SQL Property Graph Queries (SQL/PGQ)

From: Alexander Lakhin <exclusion(at)gmail(dot)com>
To: Peter Eisentraut <peter(at)eisentraut(dot)org>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, assam258(at)gmail(dot)com
Cc: Amit Langote <amitlangote09(at)gmail(dot)com>, Junwang Zhao <zhjwpku(at)gmail(dot)com>, Vik Fearing <vik(at)postgresfriends(dot)org>, Ajay Pal <ajay(dot)pal(dot)k(at)gmail(dot)com>, Imran Zaheer <imran(dot)zhir(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: SQL Property Graph Queries (SQL/PGQ)
Date: 2026-03-21 10:00:00
Message-ID: 34feb4b7-d137-4413-b1fb-f4ec47cf0632@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello hackers,

I've discovered an assertion failure produced with the following script:
CREATE TABLE v1 (id int primary key, t text);
CREATE TABLE v2 (id int primary key, t text);
CREATE TABLE e1_2 (id_1 int, id_2 int, t text);
CREATE PROPERTY GRAPH g1
    VERTEX TABLES (v1, v2)
    EDGE TABLES (
        e1_2 key (id_1, id_2)
            SOURCE KEY (id_1) REFERENCES v1 (id)
            DESTINATION KEY (id_2) REFERENCES v2 (id)
    );

SELECT count(*) FROM GRAPH_TABLE (g1 MATCH ()-> COLUMNS (1 AS one));

#5  0x000056bad84ce223 in ExceptionalCondition (conditionName=conditionName(at)entry=0x56bad85bb5c2 "pf->src_pf &&
pf->dest_pf",
    fileName=fileName(at)entry=0x56bad85bb5ae "rewriteGraphTable.c", lineNumber=lineNumber(at)entry=783) at assert.c:65
#6  0x000056bad8153748 in create_pe_for_element (pf=pf(at)entry=0x5250000c88c0, elemoid=elemoid(at)entry=16421)
    at rewriteGraphTable.c:783
#7  0x000056bad8153932 in get_path_elements_for_path_factor (propgraphid=16406, pf=0x5250000c88c0) at
rewriteGraphTable.c:926
#8  0x000056bad815594d in generate_queries_for_path_pattern (rte=rte(at)entry=0x525000009380, path_pattern=0x525000008df0)
    at rewriteGraphTable.c:334
#9  0x000056bad8156fe3 in rewriteGraphTable (parsetree=parsetree(at)entry=0x525000008bc0, rt_index=rt_index(at)entry=1)
    at rewriteGraphTable.c:121
#10 0x000056bad815bd03 in fireRIRrules (parsetree=0x525000008bc0, activeRIRs=activeRIRs(at)entry=0x0) at rewriteHandler.c:2057
#11 0x000056bad8164bfc in QueryRewrite (parsetree=parsetree(at)entry=0x525000008bc0) at rewriteHandler.c:4627
#12 0x000056bad8228046 in pg_rewrite_query (query=query(at)entry=0x525000008bc0) at postgres.c:821
#13 0x000056bad8228441 in pg_analyze_and_rewrite_fixedparams (parsetree=parsetree(at)entry=0x525000008a30,
    query_string=query_string(at)entry=0x525000007a00 "SELECT count(*) FROM GRAPH_TABLE (g1 MATCH ()-> COLUMNS (1 AS one));",
    paramTypes=paramTypes(at)entry=0x0, numParams=numParams(at)entry=0, queryEnv=queryEnv(at)entry=0x0) at postgres.c:695

Best regards,
Alexander

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Xuneng Zhou 2026-03-21 10:07:16 Re: BUG: Cascading standby fails to reconnect after falling back to archive recovery
Previous Message Amit Kapila 2026-03-21 09:57:40 Re: [Proposal] Adding Log File Capability to pg_createsubscriber