| 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
| 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 |