Re: SQL Property Graph Queries (SQL/PGQ) - Mailing list pgsql-hackers

From Alexander Lakhin
Subject Re: SQL Property Graph Queries (SQL/PGQ)
Date
Msg-id 34feb4b7-d137-4413-b1fb-f4ec47cf0632@gmail.com
Whole thread Raw
In response to Re: SQL Property Graph Queries (SQL/PGQ)  (Peter Eisentraut <peter@eisentraut.org>)
Responses Re: SQL Property Graph Queries (SQL/PGQ)
List 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@entry=0x56bad85bb5c2 "pf->src_pf && 
pf->dest_pf",
     fileName=fileName@entry=0x56bad85bb5ae "rewriteGraphTable.c", lineNumber=lineNumber@entry=783) at assert.c:65
#6  0x000056bad8153748 in create_pe_for_element (pf=pf@entry=0x5250000c88c0, elemoid=elemoid@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@entry=0x525000009380,
path_pattern=0x525000008df0)
     at rewriteGraphTable.c:334
#9  0x000056bad8156fe3 in rewriteGraphTable (parsetree=parsetree@entry=0x525000008bc0, rt_index=rt_index@entry=1)
     at rewriteGraphTable.c:121
#10 0x000056bad815bd03 in fireRIRrules (parsetree=0x525000008bc0, activeRIRs=activeRIRs@entry=0x0) at
rewriteHandler.c:2057
#11 0x000056bad8164bfc in QueryRewrite (parsetree=parsetree@entry=0x525000008bc0) at rewriteHandler.c:4627
#12 0x000056bad8228046 in pg_rewrite_query (query=query@entry=0x525000008bc0) at postgres.c:821
#13 0x000056bad8228441 in pg_analyze_and_rewrite_fixedparams (parsetree=parsetree@entry=0x525000008a30,
     query_string=query_string@entry=0x525000007a00 "SELECT count(*) FROM GRAPH_TABLE (g1 MATCH ()-> COLUMNS (1 AS
one));",
     paramTypes=paramTypes@entry=0x0, numParams=numParams@entry=0, queryEnv=queryEnv@entry=0x0) at postgres.c:695

Best regards,
Alexander



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [Proposal] Adding Log File Capability to pg_createsubscriber
Next
From: Xuneng Zhou
Date:
Subject: Re: BUG: Cascading standby fails to reconnect after falling back to archive recovery