Re: SQL Property Graph Queries (SQL/PGQ)
| От | Alexander Lakhin |
|---|---|
| Тема | Re: SQL Property Graph Queries (SQL/PGQ) |
| Дата | |
| Msg-id | 34feb4b7-d137-4413-b1fb-f4ec47cf0632@gmail.com обсуждение исходный текст |
| Ответ на | Re: SQL Property Graph Queries (SQL/PGQ) (Peter Eisentraut <peter@eisentraut.org>) |
| Ответы |
Re: SQL Property Graph Queries (SQL/PGQ)
|
| Список | 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 по дате отправления: