saygoodbyye opened a new issue, #1302:
URL: https://github.com/apache/age/issues/1302
**Describe the bug**
Server crashes when executing the following SQL-script
**How are you accessing AGE (Command line, driver, etc.)?**
Accessing AGE through command line.
**What data setup do we need to do?**
Apache AGE (PG15 branch) with PostgreSQL (REL_15_STABLE).
**What is the command that caused the error?**
```pgsql
CREATE EXTENSION age;
SET search_path TO ag_catalog;
SELECT create_graph('cypher_unwind');
SELECT * FROM cypher('cypher_unwind', $$
CREATE (agtype {name: 'node1', a: [1, 2, 3]}),
(m {name: 'node2', a: [4, 5, 6]}),
(o {name: 'node3', a: [7, 8, 9]}),
(n)-[:KNOWS]->(m),
(m)-[:KNOWS]->(o)
$$) as (i agtype);
SELECT * FROM cypher('cypher_unwind', $$
MATCH (n)
WITH n.a AS a
UNWIND a AS i
RETURN *
$$) as (i agtype, j agtype);
```
backtrace:
```
#0 pg_detoast_datum (datum=0x0) at fmgr.c:1710
#1 0x00007f602f73878f in age_unnest (fcinfo=0x55c451aee4b0) at
src/backend/utils/adt/agtype.c:10656
#2 0x000055c450a0893a in ExecMakeFunctionResultSet (fcache=0x55c451aed938,
econtext=econtext@entry=0x55c451aecc58, argContext=0x55c451b392f0,
isNull=0x55c451aed2f1,
isDone=isDone@entry=0x55c451aed35c) at execSRF.c:624
#3 0x000055c450a33e35 in ExecProjectSRF (node=node@entry=0x55c451aecb40,
continuing=continuing@entry=false) at nodeProjectSet.c:175
#4 0x000055c450a33f4f in ExecProjectSet (pstate=<optimized out>) at
nodeProjectSet.c:105
#5 0x000055c4509fd71a in ExecProcNode (node=node@entry=0x55c451aecb40) at
../../../src/include/executor/executor.h:262
#6 0x000055c4509fd7aa in ExecutePlan (estate=estate@entry=0x55c451aec8d0,
planstate=0x55c451aecb40, use_parallel_mode=<optimized out>,
operation=operation@entry=CMD_SELECT,
sendTuples=sendTuples@entry=true, numberTuples=numberTuples@entry=0,
direction=ForwardScanDirection, dest=0x55c451b779e8, execute_once=true) at
execMain.c:1636
#7 0x000055c4509fe569 in standard_ExecutorRun (queryDesc=0x55c451b4fc30,
direction=ForwardScanDirection, count=0, execute_once=true) at execMain.c:363
#8 0x000055c4509fe699 in ExecutorRun
(queryDesc=queryDesc@entry=0x55c451b4fc30,
direction=direction@entry=ForwardScanDirection, count=count@entry=0,
execute_once=<optimized out>)
at execMain.c:307
#9 0x000055c450ba5fdf in PortalRunSelect
(portal=portal@entry=0x55c451a90380, forward=forward@entry=true, count=0,
count@entry=9223372036854775807, dest=dest@entry=0x55c451b779e8)
at pquery.c:924
#10 0x000055c450ba7861 in PortalRun (portal=portal@entry=0x55c451a90380,
count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true,
run_once=run_once@entry=true,
dest=dest@entry=0x55c451b779e8, altdest=altdest@entry=0x55c451b779e8,
qc=0x7ffe78a311d0) at pquery.c:768
#11 0x000055c450ba39ed in exec_simple_query (
query_string=query_string@entry=0x55c451a19970 "SELECT * FROM
cypher('cypher_unwind', $$\n MATCH (n)\n WITH n.a AS a\n UNWIND a AS
i\n RETURN *\n$$) as (i agtype, j agtype);") at postgres.c:1250
#12 0x000055c450ba5851 in PostgresMain (dbname=<optimized out>,
username=<optimized out>) at postgres.c:4598
#13 0x000055c450b0a832 in BackendRun (port=port@entry=0x55c451a40bf0) at
postmaster.c:4514
#14 0x000055c450b0c842 in BackendStartup (port=port@entry=0x55c451a40bf0) at
postmaster.c:4242
#15 0x000055c450b0ca7b in ServerLoop () at postmaster.c:1809
#16 0x000055c450b0e050 in PostmasterMain (argc=argc@entry=3,
argv=argv@entry=0x55c451a10df0) at postmaster.c:1481
#17 0x000055c450a5adb8 in main (argc=3, argv=0x55c451a10df0) at main.c:202
```
**Expected behavior**
Expected ERROR to be shown or sql query to be succesfully executed
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscr...@age.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
