Google Git
Sign in
apache/age/HEAD/./regress/expected/cypher_set.out
blob: 239234ed6c4df3603de168c78e1261af39caf207 [file]
/*
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
* distributed with this work for additional information
* regarding copyright ownership. The ASF licenses this file
* to you under the Apache License, Version 2.0 (the
* "License"); you may not use this file except in compliance
* with the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing,
* software distributed under the License is distributed on an
* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
* KIND, either express or implied. See the License for the
* specific language governing permissions and limitations
* under the License.
*/
LOAD 'age';
SET search_path TO ag_catalog;
SELECT create_graph('cypher_set');
NOTICE: graph "cypher_set" has been created
create_graph
--------------
(1 row)
SELECT * FROM cypher('cypher_set', $$CREATE (:v)$$) AS (a agtype);
a
---
(0 rows)
SELECT * FROM cypher('cypher_set', $$CREATE (:v {i: 0, j: 5, a: 0})$$) AS (a agtype);
a
---
(0 rows)
SELECT * FROM cypher('cypher_set', $$CREATE (:v {i: 1})$$) AS (a agtype);
a
---
(0 rows)
--Simple SET test case
SELECT * FROM cypher('cypher_set', $$MATCH (n) SET n.i = 3$$) AS (a agtype);
a
---
(0 rows)
SELECT * FROM cypher('cypher_set', $$MATCH (n) WHERE n.j = 5 SET n.i = NULL RETURN n$$) AS (a agtype);
a
-------------------------------------------------------------------------------
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "j": 5}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set', $$MATCH (n) RETURN n$$) AS (a agtype);
a
-------------------------------------------------------------------------------
{"id": 844424930131969, "label": "v", "properties": {"i": 3}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": 3}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "j": 5}}::vertex
(3 rows)
SELECT * FROM cypher('cypher_set', $$MATCH (n) SET n.i = NULL RETURN n$$) AS (a agtype);
a
-------------------------------------------------------------------------------
{"id": 844424930131969, "label": "v", "properties": {}}::vertex
{"id": 844424930131971, "label": "v", "properties": {}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "j": 5}}::vertex
(3 rows)
SELECT * FROM cypher('cypher_set', $$MATCH (n) RETURN n$$) AS (a agtype);
a
-------------------------------------------------------------------------------
{"id": 844424930131969, "label": "v", "properties": {}}::vertex
{"id": 844424930131971, "label": "v", "properties": {}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "j": 5}}::vertex
(3 rows)
SELECT * FROM cypher('cypher_set', $$MATCH (n) SET n.i = 3 RETURN n$$) AS (a agtype);
a
---------------------------------------------------------------------------------------
{"id": 844424930131969, "label": "v", "properties": {"i": 3}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": 3}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 3, "j": 5}}::vertex
(3 rows)
SELECT * FROM cypher('cypher_set', $$MATCH (n) RETURN n$$) AS (a agtype);
a
---------------------------------------------------------------------------------------
{"id": 844424930131969, "label": "v", "properties": {"i": 3}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": 3}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 3, "j": 5}}::vertex
(3 rows)
--Test assigning properties to rand() and pi()
SELECT * FROM cypher('cypher_set', $$MATCH (n) SET n.i = rand() RETURN n.i < 1 AND n.i >= 0$$) AS (a agtype);
a
------
true
true
true
(3 rows)
SELECT * FROM cypher('cypher_set', $$MATCH (n) SET n.i = pi() RETURN n$$) AS (a agtype);
a
-------------------------------------------------------------------------------------------------------
{"id": 844424930131969, "label": "v", "properties": {"i": 3.141592653589793}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": 3.141592653589793}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 3.141592653589793, "j": 5}}::vertex
(3 rows)
--Handle Inheritance
SELECT * FROM cypher('cypher_set', $$CREATE ()$$) AS (a agtype);
a
---
(0 rows)
SELECT * FROM cypher('cypher_set', $$MATCH (n) SET n.i = 3 RETURN n$$) AS (a agtype);
a
---------------------------------------------------------------------------------------
{"id": 281474976710657, "label": "", "properties": {"i": 3}}::vertex
{"id": 844424930131969, "label": "v", "properties": {"i": 3}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": 3}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 3, "j": 5}}::vertex
(4 rows)
SELECT * FROM cypher('cypher_set', $$MATCH (n) RETURN n$$) AS (a agtype);
a
---------------------------------------------------------------------------------------
{"id": 281474976710657, "label": "", "properties": {"i": 3}}::vertex
{"id": 844424930131969, "label": "v", "properties": {"i": 3}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": 3}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 3, "j": 5}}::vertex
(4 rows)
--Validate Paths are updated
SELECT * FROM cypher('cypher_set', $$MATCH (n) CREATE (n)-[:e {j:20}]->(:other_v {k:10}) RETURN n$$) AS (a agtype);
a
---------------------------------------------------------------------------------------
{"id": 281474976710657, "label": "", "properties": {"i": 3}}::vertex
{"id": 844424930131969, "label": "v", "properties": {"i": 3}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": 3}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 3, "j": 5}}::vertex
(4 rows)
SELECT * FROM cypher('cypher_set', $$MATCH p=(n)-[]->() SET n.i = 50 RETURN p$$) AS (a agtype);
a
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[{"id": 281474976710657, "label": "", "properties": {"i": 50}}::vertex, {"id": 1125899906842625, "label": "e", "end_id": 1407374883553281, "start_id": 281474976710657, "properties": {"j": 20}}::edge, {"id": 1407374883553281, "label": "other_v", "properties": {"k": 10}}::vertex]::path
[{"id": 844424930131969, "label": "v", "properties": {"i": 50}}::vertex, {"id": 1125899906842626, "label": "e", "end_id": 1407374883553282, "start_id": 844424930131969, "properties": {"j": 20}}::edge, {"id": 1407374883553282, "label": "other_v", "properties": {"k": 10}}::vertex]::path
[{"id": 844424930131971, "label": "v", "properties": {"i": 50}}::vertex, {"id": 1125899906842627, "label": "e", "end_id": 1407374883553283, "start_id": 844424930131971, "properties": {"j": 20}}::edge, {"id": 1407374883553283, "label": "other_v", "properties": {"k": 10}}::vertex]::path
[{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 50, "j": 5}}::vertex, {"id": 1125899906842628, "label": "e", "end_id": 1407374883553284, "start_id": 844424930131970, "properties": {"j": 20}}::edge, {"id": 1407374883553284, "label": "other_v", "properties": {"k": 10}}::vertex]::path
(4 rows)
--Edges
SELECT * FROM cypher('cypher_set', $$MATCH ()-[n]-(:other_v) SET n.i = 3 RETURN n$$) AS (a agtype);
a
----------------------------------------------------------------------------------------------------------------------------------------
{"id": 1125899906842625, "label": "e", "end_id": 1407374883553281, "start_id": 281474976710657, "properties": {"i": 3, "j": 20}}::edge
{"id": 1125899906842626, "label": "e", "end_id": 1407374883553282, "start_id": 844424930131969, "properties": {"i": 3, "j": 20}}::edge
{"id": 1125899906842627, "label": "e", "end_id": 1407374883553283, "start_id": 844424930131971, "properties": {"i": 3, "j": 20}}::edge
{"id": 1125899906842628, "label": "e", "end_id": 1407374883553284, "start_id": 844424930131970, "properties": {"i": 3, "j": 20}}::edge
(4 rows)
SELECT * FROM cypher('cypher_set', $$MATCH ()-[n]->(:other_v) RETURN n$$) AS (a agtype);
a
----------------------------------------------------------------------------------------------------------------------------------------
{"id": 1125899906842625, "label": "e", "end_id": 1407374883553281, "start_id": 281474976710657, "properties": {"i": 3, "j": 20}}::edge
{"id": 1125899906842626, "label": "e", "end_id": 1407374883553282, "start_id": 844424930131969, "properties": {"i": 3, "j": 20}}::edge
{"id": 1125899906842628, "label": "e", "end_id": 1407374883553284, "start_id": 844424930131970, "properties": {"i": 3, "j": 20}}::edge
{"id": 1125899906842627, "label": "e", "end_id": 1407374883553283, "start_id": 844424930131971, "properties": {"i": 3, "j": 20}}::edge
(4 rows)
SELECT * FROM cypher('cypher_set', $$
MATCH (n {j: 5})
SET n.y = 50
SET n.z = 99
RETURN n
$$) AS (a agtype);
a
----------------------------------------------------------------------------------------------------------
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 50, "j": 5, "y": 50, "z": 99}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set', $$
MATCH (n {j: 5})
SET n.y = 53
SET n.y = 50
SET n.z = 99
SET n.arr = [n.y, n.z]
RETURN n
$$) AS (a agtype);
a
---------------------------------------------------------------------------------------------------------------------------
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 50, "j": 5, "y": 50, "z": 99, "arr": [50, 99]}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set', $$
MATCH (n {j: 5})
REMOVE n.arr
RETURN n
$$) AS (a agtype);
a
----------------------------------------------------------------------------------------------------------
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 50, "j": 5, "y": 50, "z": 99}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set', $$
MATCH (n {j: 5})
RETURN n
$$) AS (a agtype);
a
----------------------------------------------------------------------------------------------------------
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 50, "j": 5, "y": 50, "z": 99}}::vertex
(1 row)
--Create a loop and see that set can work after create
SELECT * FROM cypher('cypher_set', $$
MATCH (n {j: 5})
CREATE p=(n)-[e:e {j:34}]->(n)
SET n.y = 99
RETURN n, p
$$) AS (a agtype, b agtype);
a | b
----------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 50, "j": 5, "y": 99, "z": 99}}::vertex | [{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 50, "j": 5, "y": 99, "z": 99}}::vertex, {"id": 1125899906842629, "label": "e", "end_id": 844424930131970, "start_id": 844424930131970, "properties": {"j": 34}}::edge, {"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 50, "j": 5, "y": 99, "z": 99}}::vertex]::path
(1 row)
--Create a loop and see that set can work after create
SELECT * FROM cypher('cypher_set', $$
CREATE ()-[e:e {j:34}]->()
SET e.y = 99
RETURN e
$$) AS (a agtype);
a
----------------------------------------------------------------------------------------------------------------------------------------
{"id": 1125899906842630, "label": "e", "end_id": 281474976710659, "start_id": 281474976710658, "properties": {"j": 34, "y": 99}}::edge
(1 row)
SELECT * FROM cypher('cypher_set', $$
MATCH (n)
MATCH (n)-[e:e {j:34}]->()
SET n.y = 1
RETURN n
$$) AS (a agtype);
a
---------------------------------------------------------------------------------------------------------
{"id": 281474976710658, "label": "", "properties": {"y": 1}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 50, "j": 5, "y": 1, "z": 99}}::vertex
(2 rows)
SELECT * FROM cypher('cypher_set', $$
MATCH (n)
MATCH ()-[e:e {j:34}]->(n)
SET n.y = 2
RETURN n
$$) AS (a agtype);
a
---------------------------------------------------------------------------------------------------------
{"id": 281474976710659, "label": "", "properties": {"y": 2}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 50, "j": 5, "y": 2, "z": 99}}::vertex
(2 rows)
-- Test that SET works with nodes(path) and relationships(path)
SELECT * FROM cypher('cypher_set', $$
MATCH p=(n)-[e:e {j:34}]->()
WITH nodes(p) AS ns
WITH ns[0] AS n
SET n.k = 99
SET n.k = 999
RETURN n
$$) AS (a agtype);
a
-------------------------------------------------------------------------------------------------------------------
{"id": 281474976710658, "label": "", "properties": {"k": 999, "y": 1}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 50, "j": 5, "k": 999, "y": 2, "z": 99}}::vertex
(2 rows)
SELECT * FROM cypher('cypher_set', $$
MATCH p=(n)-[e:e {j:34}]->()
WITH relationships(p) AS rs
WITH rs[0] AS r
SET r.l = 99
SET r.l = 999
RETURN r
$$) AS (a agtype);
a
--------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 1125899906842630, "label": "e", "end_id": 281474976710659, "start_id": 281474976710658, "properties": {"j": 34, "l": 999, "y": 99}}::edge
{"id": 1125899906842629, "label": "e", "end_id": 844424930131970, "start_id": 844424930131970, "properties": {"j": 34, "l": 999}}::edge
(2 rows)
SELECT * FROM cypher('cypher_set', $$
MATCH p=(n)-[e:e {j:34}]->()
REMOVE n.k, e.l
RETURN p
$$) AS (a agtype);
a
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[{"id": 281474976710658, "label": "", "properties": {"y": 1}}::vertex, {"id": 1125899906842630, "label": "e", "end_id": 281474976710659, "start_id": 281474976710658, "properties": {"j": 34, "y": 99}}::edge, {"id": 281474976710659, "label": "", "properties": {"y": 2}}::vertex]::path
[{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 50, "j": 5, "y": 2, "z": 99}}::vertex, {"id": 1125899906842629, "label": "e", "end_id": 844424930131970, "start_id": 844424930131970, "properties": {"j": 34}}::edge, {"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 50, "j": 5, "y": 2, "z": 99}}::vertex]::path
(2 rows)
SELECT * FROM cypher('cypher_set', $$MATCH (n)-[]->(n) SET n.y = 99 RETURN n$$) AS (a agtype);
a
----------------------------------------------------------------------------------------------------------
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 50, "j": 5, "y": 99, "z": 99}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set', $$MATCH (n) MATCH (n)-[]->(m) SET n.t = 150 RETURN n$$) AS (a agtype);
a
--------------------------------------------------------------------------------------------------------------------
{"id": 281474976710658, "label": "", "properties": {"t": 150, "y": 1}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 50, "j": 5, "t": 150, "y": 99, "z": 99}}::vertex
{"id": 281474976710657, "label": "", "properties": {"i": 50, "t": 150}}::vertex
{"id": 844424930131969, "label": "v", "properties": {"i": 50, "t": 150}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": 50, "t": 150}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 50, "j": 5, "t": 150, "y": 99, "z": 99}}::vertex
(6 rows)
-- prepared statements
PREPARE p_1 AS SELECT * FROM cypher('cypher_set', $$MATCH (n) SET n.i = 3 RETURN n $$) AS (a agtype);
EXECUTE p_1;
a
-------------------------------------------------------------------------------------------------------------------
{"id": 281474976710659, "label": "", "properties": {"i": 3, "y": 2}}::vertex
{"id": 281474976710658, "label": "", "properties": {"i": 3, "t": 150, "y": 1}}::vertex
{"id": 281474976710657, "label": "", "properties": {"i": 3, "t": 150}}::vertex
{"id": 844424930131969, "label": "v", "properties": {"i": 3, "t": 150}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": 3, "t": 150}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 3, "j": 5, "t": 150, "y": 99, "z": 99}}::vertex
{"id": 1407374883553281, "label": "other_v", "properties": {"i": 3, "k": 10}}::vertex
{"id": 1407374883553282, "label": "other_v", "properties": {"i": 3, "k": 10}}::vertex
{"id": 1407374883553283, "label": "other_v", "properties": {"i": 3, "k": 10}}::vertex
{"id": 1407374883553284, "label": "other_v", "properties": {"i": 3, "k": 10}}::vertex
(10 rows)
EXECUTE p_1;
a
-------------------------------------------------------------------------------------------------------------------
{"id": 281474976710659, "label": "", "properties": {"i": 3, "y": 2}}::vertex
{"id": 281474976710658, "label": "", "properties": {"i": 3, "t": 150, "y": 1}}::vertex
{"id": 281474976710657, "label": "", "properties": {"i": 3, "t": 150}}::vertex
{"id": 844424930131969, "label": "v", "properties": {"i": 3, "t": 150}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": 3, "t": 150}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 3, "j": 5, "t": 150, "y": 99, "z": 99}}::vertex
{"id": 1407374883553281, "label": "other_v", "properties": {"i": 3, "k": 10}}::vertex
{"id": 1407374883553282, "label": "other_v", "properties": {"i": 3, "k": 10}}::vertex
{"id": 1407374883553283, "label": "other_v", "properties": {"i": 3, "k": 10}}::vertex
{"id": 1407374883553284, "label": "other_v", "properties": {"i": 3, "k": 10}}::vertex
(10 rows)
PREPARE p_2 AS SELECT * FROM cypher('cypher_set', $$MATCH (n) SET n.i = $var_name RETURN n $$, $1) AS (a agtype);
EXECUTE p_2('{"var_name": 4}');
a
-------------------------------------------------------------------------------------------------------------------
{"id": 281474976710659, "label": "", "properties": {"i": 4, "y": 2}}::vertex
{"id": 281474976710658, "label": "", "properties": {"i": 4, "t": 150, "y": 1}}::vertex
{"id": 281474976710657, "label": "", "properties": {"i": 4, "t": 150}}::vertex
{"id": 844424930131969, "label": "v", "properties": {"i": 4, "t": 150}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": 4, "t": 150}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 4, "j": 5, "t": 150, "y": 99, "z": 99}}::vertex
{"id": 1407374883553281, "label": "other_v", "properties": {"i": 4, "k": 10}}::vertex
{"id": 1407374883553282, "label": "other_v", "properties": {"i": 4, "k": 10}}::vertex
{"id": 1407374883553283, "label": "other_v", "properties": {"i": 4, "k": 10}}::vertex
{"id": 1407374883553284, "label": "other_v", "properties": {"i": 4, "k": 10}}::vertex
(10 rows)
EXECUTE p_2('{"var_name": 6}');
a
-------------------------------------------------------------------------------------------------------------------
{"id": 281474976710659, "label": "", "properties": {"i": 6, "y": 2}}::vertex
{"id": 281474976710658, "label": "", "properties": {"i": 6, "t": 150, "y": 1}}::vertex
{"id": 281474976710657, "label": "", "properties": {"i": 6, "t": 150}}::vertex
{"id": 844424930131969, "label": "v", "properties": {"i": 6, "t": 150}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": 6, "t": 150}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 6, "j": 5, "t": 150, "y": 99, "z": 99}}::vertex
{"id": 1407374883553281, "label": "other_v", "properties": {"i": 6, "k": 10}}::vertex
{"id": 1407374883553282, "label": "other_v", "properties": {"i": 6, "k": 10}}::vertex
{"id": 1407374883553283, "label": "other_v", "properties": {"i": 6, "k": 10}}::vertex
{"id": 1407374883553284, "label": "other_v", "properties": {"i": 6, "k": 10}}::vertex
(10 rows)
CREATE FUNCTION set_test()
RETURNS TABLE(vertex agtype)
LANGUAGE plpgsql
VOLATILE
AS $BODY$
BEGIN
RETURN QUERY SELECT * FROM cypher('cypher_set', $$MATCH (n) SET n.i = 7 RETURN n $$) AS (a agtype);
END
$BODY$;
SELECT set_test();
set_test
-------------------------------------------------------------------------------------------------------------------
{"id": 281474976710659, "label": "", "properties": {"i": 7, "y": 2}}::vertex
{"id": 281474976710658, "label": "", "properties": {"i": 7, "t": 150, "y": 1}}::vertex
{"id": 281474976710657, "label": "", "properties": {"i": 7, "t": 150}}::vertex
{"id": 844424930131969, "label": "v", "properties": {"i": 7, "t": 150}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": 7, "t": 150}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 7, "j": 5, "t": 150, "y": 99, "z": 99}}::vertex
{"id": 1407374883553281, "label": "other_v", "properties": {"i": 7, "k": 10}}::vertex
{"id": 1407374883553282, "label": "other_v", "properties": {"i": 7, "k": 10}}::vertex
{"id": 1407374883553283, "label": "other_v", "properties": {"i": 7, "k": 10}}::vertex
{"id": 1407374883553284, "label": "other_v", "properties": {"i": 7, "k": 10}}::vertex
(10 rows)
SELECT set_test();
set_test
-------------------------------------------------------------------------------------------------------------------
{"id": 281474976710659, "label": "", "properties": {"i": 7, "y": 2}}::vertex
{"id": 281474976710658, "label": "", "properties": {"i": 7, "t": 150, "y": 1}}::vertex
{"id": 281474976710657, "label": "", "properties": {"i": 7, "t": 150}}::vertex
{"id": 844424930131969, "label": "v", "properties": {"i": 7, "t": 150}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": 7, "t": 150}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 7, "j": 5, "t": 150, "y": 99, "z": 99}}::vertex
{"id": 1407374883553281, "label": "other_v", "properties": {"i": 7, "k": 10}}::vertex
{"id": 1407374883553282, "label": "other_v", "properties": {"i": 7, "k": 10}}::vertex
{"id": 1407374883553283, "label": "other_v", "properties": {"i": 7, "k": 10}}::vertex
{"id": 1407374883553284, "label": "other_v", "properties": {"i": 7, "k": 10}}::vertex
(10 rows)
--
-- Updating multiple fields
--
SELECT * FROM cypher('cypher_set', $$MATCH (n) SET n.i = 3, n.j = 5 RETURN n $$) AS (a agtype);
a
-------------------------------------------------------------------------------------------------------------------
{"id": 281474976710659, "label": "", "properties": {"i": 3, "j": 5, "y": 2}}::vertex
{"id": 281474976710658, "label": "", "properties": {"i": 3, "j": 5, "t": 150, "y": 1}}::vertex
{"id": 281474976710657, "label": "", "properties": {"i": 3, "j": 5, "t": 150}}::vertex
{"id": 844424930131969, "label": "v", "properties": {"i": 3, "j": 5, "t": 150}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": 3, "j": 5, "t": 150}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 3, "j": 5, "t": 150, "y": 99, "z": 99}}::vertex
{"id": 1407374883553281, "label": "other_v", "properties": {"i": 3, "j": 5, "k": 10}}::vertex
{"id": 1407374883553282, "label": "other_v", "properties": {"i": 3, "j": 5, "k": 10}}::vertex
{"id": 1407374883553283, "label": "other_v", "properties": {"i": 3, "j": 5, "k": 10}}::vertex
{"id": 1407374883553284, "label": "other_v", "properties": {"i": 3, "j": 5, "k": 10}}::vertex
(10 rows)
SELECT * FROM cypher('cypher_set', $$MATCH (n)-[m]->(n) SET m.y = n.y RETURN n, m$$) AS (a agtype, b agtype);
a | b
-------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": 3, "j": 5, "t": 150, "y": 99, "z": 99}}::vertex | {"id": 1125899906842629, "label": "e", "end_id": 844424930131970, "start_id": 844424930131970, "properties": {"j": 34, "y": 99}}::edge
(1 row)
--Errors
SELECT * FROM cypher('cypher_set', $$SET n.i = NULL$$) AS (a agtype);
ERROR: SET cannot be the first clause in a Cypher query
LINE 1: SELECT * FROM cypher('cypher_set', $$SET n.i = NULL$$) AS (a...
^
SELECT * FROM cypher('cypher_set', $$MATCH (n) SET wrong_var.i = 3$$) AS (a agtype);
ERROR: undefined reference to variable wrong_var in SET clause
LINE 1: ...ELECT * FROM cypher('cypher_set', $$MATCH (n) SET wrong_var....
^
SELECT * FROM cypher('cypher_set', $$MATCH (n) SET i = 3$$) AS (a agtype);
ERROR: SET clause expects a map
LINE 1: ...ELECT * FROM cypher('cypher_set', $$MATCH (n) SET i = 3$$) A...
^
--
-- SET refactor regression tests
--
-- INSERT INTO
CREATE TABLE tbl (result agtype);
SELECT * FROM cypher('cypher_set', $$CREATE (u:vertices) $$) AS (result agtype);
result
--------
(0 rows)
SELECT * FROM cypher('cypher_set', $$CREATE (u:begin)-[:edge]->(v:end) $$) AS (result agtype);
result
--------
(0 rows)
SELECT * FROM cypher('cypher_set', $$MATCH (u:vertices) return u $$) AS (result agtype);
result
-------------------------------------------------------------------------
{"id": 1688849860263937, "label": "vertices", "properties": {}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set', $$MATCH (u:begin)-[:edge]->(v:end) return u, v $$) AS (u agtype, v agtype);
u | v
----------------------------------------------------------------------+--------------------------------------------------------------------
{"id": 1970324836974593, "label": "begin", "properties": {}}::vertex | {"id": 2533274790395905, "label": "end", "properties": {}}::vertex
(1 row)
INSERT INTO tbl (SELECT * FROM cypher('cypher_set', $$MATCH (u:vertices) SET u.i = 7 return u $$) AS (result agtype));
INSERT INTO tbl (SELECT * FROM cypher('cypher_set', $$MATCH (u:vertices) SET u.i = 13 return u $$) AS (result agtype));
SELECT * FROM tbl;
result
--------------------------------------------------------------------------------
{"id": 1688849860263937, "label": "vertices", "properties": {"i": 7}}::vertex
{"id": 1688849860263937, "label": "vertices", "properties": {"i": 13}}::vertex
(2 rows)
SELECT * FROM cypher('cypher_set', $$MATCH (u:vertices) return u $$) AS (result agtype);
result
--------------------------------------------------------------------------------
{"id": 1688849860263937, "label": "vertices", "properties": {"i": 13}}::vertex
(1 row)
BEGIN;
SELECT * FROM cypher('cypher_set', $$MATCH (u:vertices) SET u.i = 1, u.j = 3, u.k = 5 return u $$) AS (result agtype);
result
-----------------------------------------------------------------------------------------------
{"id": 1688849860263937, "label": "vertices", "properties": {"i": 1, "j": 3, "k": 5}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set', $$MATCH (u:vertices) return u $$) AS (result agtype);
result
-----------------------------------------------------------------------------------------------
{"id": 1688849860263937, "label": "vertices", "properties": {"i": 1, "j": 3, "k": 5}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set', $$MATCH (u:vertices) SET u.i = 2, u.j = 4, u.k = 6 return u $$) AS (result agtype);
result
-----------------------------------------------------------------------------------------------
{"id": 1688849860263937, "label": "vertices", "properties": {"i": 2, "j": 4, "k": 6}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set', $$MATCH (u:vertices) return u $$) AS (result agtype);
result
-----------------------------------------------------------------------------------------------
{"id": 1688849860263937, "label": "vertices", "properties": {"i": 2, "j": 4, "k": 6}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set', $$MATCH (u:vertices) SET u.i = 3, u.j = 6, u.k = 9 return u $$) AS (result agtype);
result
-----------------------------------------------------------------------------------------------
{"id": 1688849860263937, "label": "vertices", "properties": {"i": 3, "j": 6, "k": 9}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set', $$MATCH (u:vertices) return u $$) AS (result agtype);
result
-----------------------------------------------------------------------------------------------
{"id": 1688849860263937, "label": "vertices", "properties": {"i": 3, "j": 6, "k": 9}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set', $$MATCH (u:begin)-[:edge]->(v:end) SET u.i = 1, v.i = 2, u.j = 3, v.j = 4 return u, v $$) AS (u agtype, v agtype);
u | v
------------------------------------------------------------------------------------+----------------------------------------------------------------------------------
{"id": 1970324836974593, "label": "begin", "properties": {"i": 1, "j": 3}}::vertex | {"id": 2533274790395905, "label": "end", "properties": {"i": 2, "j": 4}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set', $$MATCH (u:begin)-[:edge]->(v:end) return u, v $$) AS (u agtype, v agtype);
u | v
------------------------------------------------------------------------------------+----------------------------------------------------------------------------------
{"id": 1970324836974593, "label": "begin", "properties": {"i": 1, "j": 3}}::vertex | {"id": 2533274790395905, "label": "end", "properties": {"i": 2, "j": 4}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set', $$MATCH (u:begin)-[:edge]->(v:end) SET u.i = 2, v.i = 1, u.j = 4, v.j = 3 return u, v $$) AS (u agtype, v agtype);
u | v
------------------------------------------------------------------------------------+----------------------------------------------------------------------------------
{"id": 1970324836974593, "label": "begin", "properties": {"i": 2, "j": 4}}::vertex | {"id": 2533274790395905, "label": "end", "properties": {"i": 1, "j": 3}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set', $$MATCH (u:begin)-[:edge]->(v:end) return u, v $$) AS (u agtype, v agtype);
u | v
------------------------------------------------------------------------------------+----------------------------------------------------------------------------------
{"id": 1970324836974593, "label": "begin", "properties": {"i": 2, "j": 4}}::vertex | {"id": 2533274790395905, "label": "end", "properties": {"i": 1, "j": 3}}::vertex
(1 row)
END;
SELECT * FROM cypher('cypher_set', $$MATCH (u:vertices) return u $$) AS (result agtype);
result
-----------------------------------------------------------------------------------------------
{"id": 1688849860263937, "label": "vertices", "properties": {"i": 3, "j": 6, "k": 9}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set', $$MATCH (u:begin)-[:edge]->(v:end) return u, v $$) AS (u agtype, v agtype);
u | v
------------------------------------------------------------------------------------+----------------------------------------------------------------------------------
{"id": 1970324836974593, "label": "begin", "properties": {"i": 2, "j": 4}}::vertex | {"id": 2533274790395905, "label": "end", "properties": {"i": 1, "j": 3}}::vertex
(1 row)
-- test lists
SELECT * FROM cypher('cypher_set', $$MATCH (n) SET n.i = [3, 'test', [1, 2, 3], {id: 1}, 1.0, 1.0::numeric] RETURN n$$) AS (a agtype);
a
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 281474976710659, "label": "", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 5, "y": 2}}::vertex
{"id": 281474976710658, "label": "", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 5, "t": 150, "y": 1}}::vertex
{"id": 281474976710657, "label": "", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 5, "t": 150}}::vertex
{"id": 844424930131969, "label": "v", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 5, "t": 150}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 5, "t": 150}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 5, "t": 150, "y": 99, "z": 99}}::vertex
{"id": 1407374883553281, "label": "other_v", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 5, "k": 10}}::vertex
{"id": 1407374883553282, "label": "other_v", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 5, "k": 10}}::vertex
{"id": 1407374883553283, "label": "other_v", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 5, "k": 10}}::vertex
{"id": 1407374883553284, "label": "other_v", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 5, "k": 10}}::vertex
{"id": 1688849860263937, "label": "vertices", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 6, "k": 9}}::vertex
{"id": 1970324836974593, "label": "begin", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 4}}::vertex
{"id": 2533274790395905, "label": "end", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 3}}::vertex
(13 rows)
SELECT * FROM cypher('cypher_set', $$MATCH (n) RETURN n$$) AS (a agtype);
a
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 281474976710659, "label": "", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 5, "y": 2}}::vertex
{"id": 281474976710658, "label": "", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 5, "t": 150, "y": 1}}::vertex
{"id": 281474976710657, "label": "", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 5, "t": 150}}::vertex
{"id": 844424930131969, "label": "v", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 5, "t": 150}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 5, "t": 150}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 5, "t": 150, "y": 99, "z": 99}}::vertex
{"id": 1407374883553281, "label": "other_v", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 5, "k": 10}}::vertex
{"id": 1407374883553282, "label": "other_v", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 5, "k": 10}}::vertex
{"id": 1407374883553283, "label": "other_v", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 5, "k": 10}}::vertex
{"id": 1407374883553284, "label": "other_v", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 5, "k": 10}}::vertex
{"id": 1688849860263937, "label": "vertices", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 6, "k": 9}}::vertex
{"id": 1970324836974593, "label": "begin", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 4}}::vertex
{"id": 2533274790395905, "label": "end", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 3}}::vertex
(13 rows)
-- test that lists get updated in paths
SELECT * FROM cypher('cypher_set', $$MATCH p=(u:begin)-[:edge]->(v:end) SET u.i = [1, 2, 3] return u, p $$) AS (u agtype, p agtype);
u | p
--------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 1970324836974593, "label": "begin", "properties": {"i": [1, 2, 3], "j": 4}}::vertex | [{"id": 1970324836974593, "label": "begin", "properties": {"i": [1, 2, 3], "j": 4}}::vertex, {"id": 2251799813685249, "label": "edge", "end_id": 2533274790395905, "start_id": 1970324836974593, "properties": {}}::edge, {"id": 2533274790395905, "label": "end", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 3}}::vertex]::path
(1 row)
SELECT * FROM cypher('cypher_set', $$MATCH p=(u:begin)-[:edge]->(v:end) return u, p $$) AS (u agtype, p agtype);
u | p
--------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 1970324836974593, "label": "begin", "properties": {"i": [1, 2, 3], "j": 4}}::vertex | [{"id": 1970324836974593, "label": "begin", "properties": {"i": [1, 2, 3], "j": 4}}::vertex, {"id": 2251799813685249, "label": "edge", "end_id": 2533274790395905, "start_id": 1970324836974593, "properties": {}}::edge, {"id": 2533274790395905, "label": "end", "properties": {"i": [3, "test", [1, 2, 3], {"id": 1}, 1.0, 1::numeric], "j": 3}}::vertex]::path
(1 row)
-- test empty lists
SELECT * FROM cypher('cypher_set', $$MATCH (n) SET n.i = [] RETURN n$$) AS (a agtype);
a
--------------------------------------------------------------------------------------------------------------------
{"id": 281474976710659, "label": "", "properties": {"i": [], "j": 5, "y": 2}}::vertex
{"id": 281474976710658, "label": "", "properties": {"i": [], "j": 5, "t": 150, "y": 1}}::vertex
{"id": 281474976710657, "label": "", "properties": {"i": [], "j": 5, "t": 150}}::vertex
{"id": 844424930131969, "label": "v", "properties": {"i": [], "j": 5, "t": 150}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": [], "j": 5, "t": 150}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": [], "j": 5, "t": 150, "y": 99, "z": 99}}::vertex
{"id": 1407374883553281, "label": "other_v", "properties": {"i": [], "j": 5, "k": 10}}::vertex
{"id": 1407374883553282, "label": "other_v", "properties": {"i": [], "j": 5, "k": 10}}::vertex
{"id": 1407374883553283, "label": "other_v", "properties": {"i": [], "j": 5, "k": 10}}::vertex
{"id": 1407374883553284, "label": "other_v", "properties": {"i": [], "j": 5, "k": 10}}::vertex
{"id": 1688849860263937, "label": "vertices", "properties": {"i": [], "j": 6, "k": 9}}::vertex
{"id": 1970324836974593, "label": "begin", "properties": {"i": [], "j": 4}}::vertex
{"id": 2533274790395905, "label": "end", "properties": {"i": [], "j": 3}}::vertex
(13 rows)
SELECT * FROM cypher('cypher_set', $$MATCH (n) RETURN n$$) AS (a agtype);
a
--------------------------------------------------------------------------------------------------------------------
{"id": 281474976710659, "label": "", "properties": {"i": [], "j": 5, "y": 2}}::vertex
{"id": 281474976710658, "label": "", "properties": {"i": [], "j": 5, "t": 150, "y": 1}}::vertex
{"id": 281474976710657, "label": "", "properties": {"i": [], "j": 5, "t": 150}}::vertex
{"id": 844424930131969, "label": "v", "properties": {"i": [], "j": 5, "t": 150}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": [], "j": 5, "t": 150}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": [], "j": 5, "t": 150, "y": 99, "z": 99}}::vertex
{"id": 1407374883553281, "label": "other_v", "properties": {"i": [], "j": 5, "k": 10}}::vertex
{"id": 1407374883553282, "label": "other_v", "properties": {"i": [], "j": 5, "k": 10}}::vertex
{"id": 1407374883553283, "label": "other_v", "properties": {"i": [], "j": 5, "k": 10}}::vertex
{"id": 1407374883553284, "label": "other_v", "properties": {"i": [], "j": 5, "k": 10}}::vertex
{"id": 1688849860263937, "label": "vertices", "properties": {"i": [], "j": 6, "k": 9}}::vertex
{"id": 1970324836974593, "label": "begin", "properties": {"i": [], "j": 4}}::vertex
{"id": 2533274790395905, "label": "end", "properties": {"i": [], "j": 3}}::vertex
(13 rows)
-- test maps
SELECT * FROM cypher('cypher_set', $$MATCH (n) SET n.i = {prop1: 3, prop2:'test', prop3: [1, 2, 3], prop4: {id: 1}, prop5: 1.0, prop6:1.0::numeric} RETURN n$$) AS (a agtype);
a
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 281474976710659, "label": "", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 5, "y": 2}}::vertex
{"id": 281474976710658, "label": "", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 5, "t": 150, "y": 1}}::vertex
{"id": 281474976710657, "label": "", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 5, "t": 150}}::vertex
{"id": 844424930131969, "label": "v", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 5, "t": 150}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 5, "t": 150}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 5, "t": 150, "y": 99, "z": 99}}::vertex
{"id": 1407374883553281, "label": "other_v", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 5, "k": 10}}::vertex
{"id": 1407374883553282, "label": "other_v", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 5, "k": 10}}::vertex
{"id": 1407374883553283, "label": "other_v", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 5, "k": 10}}::vertex
{"id": 1407374883553284, "label": "other_v", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 5, "k": 10}}::vertex
{"id": 1688849860263937, "label": "vertices", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 6, "k": 9}}::vertex
{"id": 1970324836974593, "label": "begin", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 4}}::vertex
{"id": 2533274790395905, "label": "end", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 3}}::vertex
(13 rows)
SELECT * FROM cypher('cypher_set', $$MATCH (n) RETURN n$$) AS (a agtype);
a
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 281474976710659, "label": "", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 5, "y": 2}}::vertex
{"id": 281474976710658, "label": "", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 5, "t": 150, "y": 1}}::vertex
{"id": 281474976710657, "label": "", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 5, "t": 150}}::vertex
{"id": 844424930131969, "label": "v", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 5, "t": 150}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 5, "t": 150}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 5, "t": 150, "y": 99, "z": 99}}::vertex
{"id": 1407374883553281, "label": "other_v", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 5, "k": 10}}::vertex
{"id": 1407374883553282, "label": "other_v", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 5, "k": 10}}::vertex
{"id": 1407374883553283, "label": "other_v", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 5, "k": 10}}::vertex
{"id": 1407374883553284, "label": "other_v", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 5, "k": 10}}::vertex
{"id": 1688849860263937, "label": "vertices", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 6, "k": 9}}::vertex
{"id": 1970324836974593, "label": "begin", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 4}}::vertex
{"id": 2533274790395905, "label": "end", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 3}}::vertex
(13 rows)
-- test maps in paths
SELECT * FROM cypher('cypher_set', $$MATCH p=(u:begin)-[:edge]->(v:end) SET u.i = {prop1: 1, prop2: 2, prop3: 3} return u, p $$) AS (u agtype, p agtype);
u | p
-----------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 1970324836974593, "label": "begin", "properties": {"i": {"prop1": 1, "prop2": 2, "prop3": 3}, "j": 4}}::vertex | [{"id": 1970324836974593, "label": "begin", "properties": {"i": {"prop1": 1, "prop2": 2, "prop3": 3}, "j": 4}}::vertex, {"id": 2251799813685249, "label": "edge", "end_id": 2533274790395905, "start_id": 1970324836974593, "properties": {}}::edge, {"id": 2533274790395905, "label": "end", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 3}}::vertex]::path
(1 row)
SELECT * FROM cypher('cypher_set', $$MATCH p=(u:begin)-[:edge]->(v:end) return u, p $$) AS (u agtype, p agtype);
u | p
-----------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 1970324836974593, "label": "begin", "properties": {"i": {"prop1": 1, "prop2": 2, "prop3": 3}, "j": 4}}::vertex | [{"id": 1970324836974593, "label": "begin", "properties": {"i": {"prop1": 1, "prop2": 2, "prop3": 3}, "j": 4}}::vertex, {"id": 2251799813685249, "label": "edge", "end_id": 2533274790395905, "start_id": 1970324836974593, "properties": {}}::edge, {"id": 2533274790395905, "label": "end", "properties": {"i": {"prop1": 3, "prop2": "test", "prop3": [1, 2, 3], "prop4": {"id": 1}, "prop5": 1.0, "prop6": 1::numeric}, "j": 3}}::vertex]::path
(1 row)
-- test empty maps
SELECT * FROM cypher('cypher_set', $$MATCH (n) SET n.i = {} RETURN n$$) AS (a agtype);
a
--------------------------------------------------------------------------------------------------------------------
{"id": 281474976710659, "label": "", "properties": {"i": {}, "j": 5, "y": 2}}::vertex
{"id": 281474976710658, "label": "", "properties": {"i": {}, "j": 5, "t": 150, "y": 1}}::vertex
{"id": 281474976710657, "label": "", "properties": {"i": {}, "j": 5, "t": 150}}::vertex
{"id": 844424930131969, "label": "v", "properties": {"i": {}, "j": 5, "t": 150}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": {}, "j": 5, "t": 150}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": {}, "j": 5, "t": 150, "y": 99, "z": 99}}::vertex
{"id": 1407374883553281, "label": "other_v", "properties": {"i": {}, "j": 5, "k": 10}}::vertex
{"id": 1407374883553282, "label": "other_v", "properties": {"i": {}, "j": 5, "k": 10}}::vertex
{"id": 1407374883553283, "label": "other_v", "properties": {"i": {}, "j": 5, "k": 10}}::vertex
{"id": 1407374883553284, "label": "other_v", "properties": {"i": {}, "j": 5, "k": 10}}::vertex
{"id": 1688849860263937, "label": "vertices", "properties": {"i": {}, "j": 6, "k": 9}}::vertex
{"id": 1970324836974593, "label": "begin", "properties": {"i": {}, "j": 4}}::vertex
{"id": 2533274790395905, "label": "end", "properties": {"i": {}, "j": 3}}::vertex
(13 rows)
SELECT * FROM cypher('cypher_set', $$MATCH (n) RETURN n$$) AS (a agtype);
a
--------------------------------------------------------------------------------------------------------------------
{"id": 281474976710659, "label": "", "properties": {"i": {}, "j": 5, "y": 2}}::vertex
{"id": 281474976710658, "label": "", "properties": {"i": {}, "j": 5, "t": 150, "y": 1}}::vertex
{"id": 281474976710657, "label": "", "properties": {"i": {}, "j": 5, "t": 150}}::vertex
{"id": 844424930131969, "label": "v", "properties": {"i": {}, "j": 5, "t": 150}}::vertex
{"id": 844424930131971, "label": "v", "properties": {"i": {}, "j": 5, "t": 150}}::vertex
{"id": 844424930131970, "label": "v", "properties": {"a": 0, "i": {}, "j": 5, "t": 150, "y": 99, "z": 99}}::vertex
{"id": 1407374883553281, "label": "other_v", "properties": {"i": {}, "j": 5, "k": 10}}::vertex
{"id": 1407374883553282, "label": "other_v", "properties": {"i": {}, "j": 5, "k": 10}}::vertex
{"id": 1407374883553283, "label": "other_v", "properties": {"i": {}, "j": 5, "k": 10}}::vertex
{"id": 1407374883553284, "label": "other_v", "properties": {"i": {}, "j": 5, "k": 10}}::vertex
{"id": 1688849860263937, "label": "vertices", "properties": {"i": {}, "j": 6, "k": 9}}::vertex
{"id": 1970324836974593, "label": "begin", "properties": {"i": {}, "j": 4}}::vertex
{"id": 2533274790395905, "label": "end", "properties": {"i": {}, "j": 3}}::vertex
(13 rows)
--
-- Test entire property update
--
SELECT * FROM create_graph('cypher_set_1');
NOTICE: graph "cypher_set_1" has been created
create_graph
--------------
(1 row)
SELECT * FROM cypher('cypher_set_1', $$ CREATE (a:Andy {name:'Andy', age:36, hungry:true}) $$) AS (a agtype);
a
---
(0 rows)
SELECT * FROM cypher('cypher_set_1', $$ CREATE (a:Peter {name:'Peter', age:34}) $$) AS (a agtype);
a
---
(0 rows)
SELECT * FROM cypher('cypher_set_1', $$ CREATE (a:Kevin {name:'Kevin', age:32, hungry:false}) $$) AS (a agtype);
a
---
(0 rows)
SELECT * FROM cypher('cypher_set_1', $$ CREATE (a:Matt {name:'Matt', city:'Toronto'}) $$) AS (a agtype);
a
---
(0 rows)
SELECT * FROM cypher('cypher_set_1', $$ CREATE (a:Juan {name:'Juan', role:'admin'}) $$) AS (a agtype);
a
---
(0 rows)
SELECT * FROM cypher('cypher_set_1', $$ CREATE (a:Robert {name:'Robert', role:'manager', city:'London'}) $$) AS (a agtype);
a
---
(0 rows)
SELECT * FROM cypher('cypher_set_1',$$ CREATE (a: VertexA {map: {a: 1, b: {c: 2, d: []}, c: [{d: -100, e: []}]}, list: [1, "string", [{a: []}, [[1, 2]]]], bool: true, num: -1.9::numeric, str: "string"})$$) as (a agtype);
a
---
(0 rows)
-- test copying properties between entities
SELECT * FROM cypher('cypher_set_1', $$
MATCH (at {name: 'Andy'}), (pn {name: 'Peter'})
SET at = properties(pn)
RETURN at, pn
$$) AS (at agtype, pn agtype);
at | pn
----------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------
{"id": 844424930131969, "label": "Andy", "properties": {"age": 34, "name": "Peter"}}::vertex | {"id": 1125899906842625, "label": "Peter", "properties": {"age": 34, "name": "Peter"}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set_1', $$
MATCH (at {name: 'Kevin'}), (pn {name: 'Matt'})
SET at = pn
RETURN at, pn
$$) AS (at agtype, pn agtype);
at | pn
-------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------
{"id": 1407374883553281, "label": "Kevin", "properties": {"city": "Toronto", "name": "Matt"}}::vertex | {"id": 1688849860263937, "label": "Matt", "properties": {"city": "Toronto", "name": "Matt"}}::vertex
(1 row)
-- test replacing all properties using a map and =
SELECT * FROM cypher('cypher_set_1', $$
MATCH (m {name: 'Matt'})
SET m = {name: 'Peter Smith', position: 'Entrepreneur', city:NULL}
RETURN m
$$) AS (m agtype);
m
-----------------------------------------------------------------------------------------------------------------------
{"id": 1407374883553281, "label": "Kevin", "properties": {"name": "Peter Smith", "position": "Entrepreneur"}}::vertex
{"id": 1688849860263937, "label": "Matt", "properties": {"name": "Peter Smith", "position": "Entrepreneur"}}::vertex
(2 rows)
-- test removing all properties using an empty map and =
SELECT * FROM cypher('cypher_set_1', $$
MATCH (p {name: 'Juan'})
SET p = {}
RETURN p
$$) AS (p agtype);
p
---------------------------------------------------------------------
{"id": 1970324836974593, "label": "Juan", "properties": {}}::vertex
(1 row)
-- test assigning non-map to an entity
SELECT * FROM cypher('cypher_set_1', $$
MATCH (p {name: 'Peter'})
SET p = "Peter"
RETURN p
$$) AS (p agtype);
ERROR: SET clause expects a map
LINE 3: SET p = "Peter"
^
SELECT * FROM cypher('cypher_set_1', $$
MATCH (p {name: 'Peter'})
SET p = sqrt(4)
RETURN p
$$) AS (p agtype);
ERROR: a map is expected
-- test plus-equal
-- expected: {name:'Rob', age:47, city:London}
SELECT * FROM cypher('cypher_set_1', $$
MATCH (p {name: 'Robert'})
SET p += {name:'Rob', role:NULL, age:47}
RETURN p
$$) AS (p agtype);
p
-----------------------------------------------------------------------------------------------------------------
{"id": 2251799813685249, "label": "Robert", "properties": {"age": 47, "city": "London", "name": "Rob"}}::vertex
(1 row)
-- expected: no change
SELECT * FROM cypher('cypher_set_1', $$
MATCH (p {name: 'Rob'})
SET p += {}
RETURN p
$$) AS (p agtype);
p
-----------------------------------------------------------------------------------------------------------------
{"id": 2251799813685249, "label": "Robert", "properties": {"age": 47, "city": "London", "name": "Rob"}}::vertex
(1 row)
-- test plus-equal with original properties having non-scalar values
SELECT * FROM cypher('cypher_set_1', $$
MATCH (p {map: {}})
SET p += {json: {a: -1, b: ['a', -1, true], c: {d: 'string'}}}
RETURN p
$$) AS (p agtype);
p
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 2533274790395905, "label": "VertexA", "properties": {"map": {"a": 1, "b": {"c": 2, "d": []}, "c": [{"d": -100, "e": []}]}, "num": -1.9::numeric, "str": "string", "bool": true, "json": {"a": -1, "b": ["a", -1, true], "c": {"d": "string"}}, "list": [1, "string", [{"a": []}, [[1, 2]]]]}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set_1', $$
MATCH (p: VertexA {map: {}})
SET p += {list_upd: [1, 2, 3, 4, 5]}
RETURN p
$$) AS (p agtype);
p
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 2533274790395905, "label": "VertexA", "properties": {"map": {"a": 1, "b": {"c": 2, "d": []}, "c": [{"d": -100, "e": []}]}, "num": -1.9::numeric, "str": "string", "bool": true, "json": {"a": -1, "b": ["a", -1, true], "c": {"d": "string"}}, "list": [1, "string", [{"a": []}, [[1, 2]]]], "list_upd": [1, 2, 3, 4, 5]}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set_1', $$
MATCH (p: VertexA)
SET p += {vertex: {id: 281474976710659, label: "", properties: {a: 1, b: [1, 2, 3]}}::vertex}
RETURN p
$$) AS (p agtype);
p
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 2533274790395905, "label": "VertexA", "properties": {"map": {"a": 1, "b": {"c": 2, "d": []}, "c": [{"d": -100, "e": []}]}, "num": -1.9::numeric, "str": "string", "bool": true, "json": {"a": -1, "b": ["a", -1, true], "c": {"d": "string"}}, "list": [1, "string", [{"a": []}, [[1, 2]]]], "vertex": {"id": 281474976710659, "label": "", "properties": {"a": 1, "b": [1, 2, 3]}}::vertex, "list_upd": [1, 2, 3, 4, 5]}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set_1', $$
MATCH (p {map: {}})
SET p += {}
RETURN p
$$) AS (p agtype);
p
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 2533274790395905, "label": "VertexA", "properties": {"map": {"a": 1, "b": {"c": 2, "d": []}, "c": [{"d": -100, "e": []}]}, "num": -1.9::numeric, "str": "string", "bool": true, "json": {"a": -1, "b": ["a", -1, true], "c": {"d": "string"}}, "list": [1, "string", [{"a": []}, [[1, 2]]]], "vertex": {"id": 281474976710659, "label": "", "properties": {"a": 1, "b": [1, 2, 3]}}::vertex, "list_upd": [1, 2, 3, 4, 5]}}::vertex
(1 row)
--
-- Check passing mismatched types with SET
-- Issue 899
--
SELECT * FROM cypher('cypher_set_1', $$
CREATE (x) SET x.n0 = (true OR true) RETURN x
$$) AS (p agtype);
p
--------------------------------------------------------------------------
{"id": 281474976710657, "label": "", "properties": {"n0": true}}::vertex
(1 row)
SELECT * FROM cypher('cypher_set_1', $$
CREATE (x) SET x.n0 = (true OR false), x.n1 = (false AND false), x.n2 = (false = false) RETURN x
$$) AS (p agtype);
p
---------------------------------------------------------------------------------------------------
{"id": 281474976710658, "label": "", "properties": {"n0": true, "n1": false, "n2": true}}::vertex
(1 row)
--
-- Issue 1634: Setting all properties with map object causes error
--
SELECT * FROM create_graph('issue_1634');
NOTICE: graph "issue_1634" has been created
create_graph
--------------
(1 row)
-- this did not work and was fixed
SELECT * FROM cypher('issue_1634', $$ WITH {first: 'jon', last: 'snow'} AS map
MERGE (v:PERSION {id: '1'})
SET v=map
RETURN v,map $$) as (v agtype, map agtype);
v | map
-----------------------------------------------------------------------------------------------------+----------------------------------
{"id": 844424930131969, "label": "PERSION", "properties": {"last": "snow", "first": "jon"}}::vertex | {"last": "snow", "first": "jon"}
(1 row)
-- these 2 did work and are added as extra tests
SELECT * FROM cypher('issue_1634', $$ MATCH (u) DELETE (u) $$) AS (u agtype);
u
---
(0 rows)
SELECT * FROM cypher('issue_1634', $$ WITH {first: 'jon', last: 'snow'} AS map
MERGE (v:PERSION {id: '1'})
SET v.first=map.first, v.last=map.last
RETURN v,map $$) as (v agtype, map agtype);
v | map
----------------------------------------------------------------------------------------------------------------+----------------------------------
{"id": 844424930131970, "label": "PERSION", "properties": {"id": "1", "last": "snow", "first": "jon"}}::vertex | {"last": "snow", "first": "jon"}
(1 row)
SELECT * FROM cypher('issue_1634', $$ MATCH (u) DELETE (u) $$) AS (u agtype);
u
---
(0 rows)
SELECT * FROM cypher('issue_1634', $$ MERGE (v:PERSION {id: '1'})
SET v={first: 'jon', last: 'snow'}
RETURN v $$) as (v agtype);
v
-----------------------------------------------------------------------------------------------------
{"id": 844424930131971, "label": "PERSION", "properties": {"last": "snow", "first": "jon"}}::vertex
(1 row)
SELECT * FROM cypher('issue_1634', $$ MATCH (u) DELETE (u) $$) AS (u agtype);
u
---
(0 rows)
--
-- Issue 1884: column reference is ambiguous when using same variable in
-- SET expression and RETURN clause
--
-- These tests cover:
-- 1. "column reference is ambiguous" error when variable is used in both
-- SET expression RHS (e.g., SET n.prop = n) and RETURN clause
-- 2. "Invalid AGT header value" error caused by incorrect offset calculation
-- when nested VERTEX/EDGE/PATH values are serialized in properties
--
-- Tests use isolated data to keep output manageable and avoid cumulative nesting
--
SELECT * FROM create_graph('issue_1884');
NOTICE: graph "issue_1884" has been created
create_graph
--------------
(1 row)
-- ============================================================================
-- Test Group A: Basic "column reference is ambiguous" fix (Issue 1884)
-- ============================================================================
-- Test A1: Core issue - SET n.prop = n with RETURN n (the original bug)
SELECT * FROM cypher('issue_1884', $$
CREATE (n:TestA1 {name: 'A1'})
SET n.self = n
RETURN n
$$) AS (result agtype);
result
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 844424930131969, "label": "TestA1", "properties": {"name": "A1", "self": {"id": 844424930131969, "label": "TestA1", "properties": {"name": "A1"}}::vertex}}::vertex
(1 row)
-- Test A2: Multiple variables in SET and RETURN
SELECT * FROM cypher('issue_1884', $$
CREATE (a:TestA2 {name: 'A'})-[e:LINK {w: 1}]->(b:TestA2 {name: 'B'})
SET a.edge = e, b.edge = e
RETURN a, e, b
$$) AS (a agtype, e agtype, b agtype);
a | e | b
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 1125899906842625, "label": "TestA2", "properties": {"edge": {"id": 1407374883553281, "label": "LINK", "end_id": 1125899906842626, "start_id": 1125899906842625, "properties": {"w": 1}}::edge, "name": "A"}}::vertex | {"id": 1407374883553281, "label": "LINK", "end_id": 1125899906842626, "start_id": 1125899906842625, "properties": {"w": 1}}::edge | {"id": 1125899906842626, "label": "TestA2", "properties": {"edge": {"id": 1407374883553281, "label": "LINK", "end_id": 1125899906842626, "start_id": 1125899906842625, "properties": {"w": 1}}::edge, "name": "B"}}::vertex
(1 row)
-- Test A3: SET edge property to node reference
SELECT * FROM cypher('issue_1884', $$
CREATE (a:TestA3 {name: 'X'})-[e:REL]->(b:TestA3 {name: 'Y'})
SET e.src = a, e.dst = b
RETURN e
$$) AS (e agtype);
e
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 1970324836974593, "label": "REL", "end_id": 1688849860263938, "start_id": 1688849860263937, "properties": {"dst": {"id": 1688849860263938, "label": "TestA3", "properties": {"name": "Y"}}::vertex, "src": {"id": 1688849860263937, "label": "TestA3", "properties": {"name": "X"}}::vertex}}::edge
(1 row)
-- ============================================================================
-- Test Group B: Nested VERTEX/EDGE/PATH serialization (offset error fix)
-- ============================================================================
-- Test B1: Vertex nested in vertex property (tests VERTEX serialization)
SELECT * FROM cypher('issue_1884', $$
CREATE (n:TestB1 {val: 1})
SET n.copy = n
RETURN n
$$) AS (result agtype);
result
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 2251799813685249, "label": "TestB1", "properties": {"val": 1, "copy": {"id": 2251799813685249, "label": "TestB1", "properties": {"val": 1}}::vertex}}::vertex
(1 row)
-- Verify nested vertex can be read back
SELECT * FROM cypher('issue_1884', $$
MATCH (n:TestB1)
RETURN n.copy
$$) AS (copy agtype);
copy
-------------------------------------------------------------------------------
{"id": 2251799813685249, "label": "TestB1", "properties": {"val": 1}}::vertex
(1 row)
-- Test B2: Edge nested in node property (tests EDGE serialization)
SELECT * FROM cypher('issue_1884', $$
CREATE (a:TestB2 {name: 'start'})-[e:B2REL {x: 100}]->(b:TestB2 {name: 'end'})
SET a.myEdge = e
RETURN a
$$) AS (a agtype);
a
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 2533274790395905, "label": "TestB2", "properties": {"name": "start", "myEdge": {"id": 2814749767106561, "label": "B2REL", "end_id": 2533274790395906, "start_id": 2533274790395905, "properties": {"x": 100}}::edge}}::vertex
(1 row)
-- Verify nested edge can be read back
SELECT * FROM cypher('issue_1884', $$
MATCH (n:TestB2 {name: 'start'})
RETURN n.myEdge
$$) AS (edge agtype);
edge
--------------------------------------------------------------------------------------------------------------------------------------
{"id": 2814749767106561, "label": "B2REL", "end_id": 2533274790395906, "start_id": 2533274790395905, "properties": {"x": 100}}::edge
(1 row)
-- Test B3: Path nested in node property (tests PATH serialization)
-- First create the pattern
SELECT * FROM cypher('issue_1884', $$
CREATE (a:TestB3)-[e:B3REL]->(b:TestB3)
RETURN a
$$) AS (a agtype);
a
-----------------------------------------------------------------------
{"id": 3096224743817217, "label": "TestB3", "properties": {}}::vertex
(1 row)
-- Then match the path and set it (MATCH only sees committed data)
SELECT * FROM cypher('issue_1884', $$
MATCH p = (a:TestB3)-[e:B3REL]->(b:TestB3)
SET a.myPath = p
RETURN a
$$) AS (a agtype);
a
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 3096224743817217, "label": "TestB3", "properties": {"myPath": [{"id": 3096224743817217, "label": "TestB3", "properties": {}}::vertex, {"id": 3377699720527873, "label": "B3REL", "end_id": 3096224743817218, "start_id": 3096224743817217, "properties": {}}::edge, {"id": 3096224743817218, "label": "TestB3", "properties": {}}::vertex]::path}}::vertex
(1 row)
-- Verify nested path can be read back
SELECT * FROM cypher('issue_1884', $$
MATCH (n:TestB3)
WHERE n.myPath IS NOT NULL
RETURN n.myPath
$$) AS (path agtype);
path
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[{"id": 3096224743817217, "label": "TestB3", "properties": {}}::vertex, {"id": 3377699720527873, "label": "B3REL", "end_id": 3096224743817218, "start_id": 3096224743817217, "properties": {}}::edge, {"id": 3096224743817218, "label": "TestB3", "properties": {}}::vertex]::path
(1 row)
-- ============================================================================
-- Test Group C: Nested structures in arrays and maps
-- ============================================================================
-- Test C1: Vertex in array
SELECT * FROM cypher('issue_1884', $$
CREATE (n:TestC1 {tag: 'arrtest'})
SET n.arr = [n]
RETURN n
$$) AS (result agtype);
result
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 3659174697238529, "label": "TestC1", "properties": {"arr": [{"id": 3659174697238529, "label": "TestC1", "properties": {"tag": "arrtest"}}::vertex], "tag": "arrtest"}}::vertex
(1 row)
-- Verify array with nested vertex
SELECT * FROM cypher('issue_1884', $$
MATCH (n:TestC1)
RETURN n.arr[0]
$$) AS (elem agtype);
elem
---------------------------------------------------------------------------------------
{"id": 3659174697238529, "label": "TestC1", "properties": {"tag": "arrtest"}}::vertex
(1 row)
-- Test C2: Vertex in map
SELECT * FROM cypher('issue_1884', $$
CREATE (n:TestC2 {tag: 'maptest'})
SET n.obj = {node: n}
RETURN n
$$) AS (result agtype);
result
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 3940649673949185, "label": "TestC2", "properties": {"obj": {"node": {"id": 3940649673949185, "label": "TestC2", "properties": {"tag": "maptest"}}::vertex}, "tag": "maptest"}}::vertex
(1 row)
-- Verify map with nested vertex
SELECT * FROM cypher('issue_1884', $$
MATCH (n:TestC2)
RETURN n.obj.node
$$) AS (node agtype);
node
---------------------------------------------------------------------------------------
{"id": 3940649673949185, "label": "TestC2", "properties": {"tag": "maptest"}}::vertex
(1 row)
-- ============================================================================
-- Test Group D: MERGE and CREATE with self-reference
-- ============================================================================
-- Test D1: MERGE with SET self-reference
SELECT * FROM cypher('issue_1884', $$
MERGE (n:TestD1 {name: 'merged'})
SET n.ref = n
RETURN n
$$) AS (result agtype);
result
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 4222124650659841, "label": "TestD1", "properties": {"ref": {"id": 4222124650659841, "label": "TestD1", "properties": {"name": "merged"}}::vertex, "name": "merged"}}::vertex
(1 row)
-- Test D2: CREATE with SET self-reference
SELECT * FROM cypher('issue_1884', $$
CREATE (n:TestD2 {name: 'created'})
SET n.ref = n
RETURN n
$$) AS (result agtype);
result
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 4503599627370497, "label": "TestD2", "properties": {"ref": {"id": 4503599627370497, "label": "TestD2", "properties": {"name": "created"}}::vertex, "name": "created"}}::vertex
(1 row)
-- ============================================================================
-- Test Group E: Functions with variable references
-- ============================================================================
-- Test E1: id() and label() functions
SELECT * FROM cypher('issue_1884', $$
CREATE (n:TestE1 {name: 'functest'})
SET n.myId = id(n), n.myLabel = label(n)
RETURN n
$$) AS (result agtype);
result
----------------------------------------------------------------------------------------------------------------------------------------
{"id": 4785074604081153, "label": "TestE1", "properties": {"myId": 4785074604081153, "name": "functest", "myLabel": "TestE1"}}::vertex
(1 row)
-- Test E2: nodes() and relationships() with path
-- First create the pattern
SELECT * FROM cypher('issue_1884', $$
CREATE (a:TestE2)-[e:E2REL]->(b:TestE2)
RETURN a
$$) AS (a agtype);
a
-----------------------------------------------------------------------
{"id": 5066549580791809, "label": "TestE2", "properties": {}}::vertex
(1 row)
-- Then match the path and extract nodes/relationships (MATCH only sees committed data)
SELECT * FROM cypher('issue_1884', $$
MATCH p = (a:TestE2)-[e:E2REL]->(b:TestE2)
SET a.pathNodes = nodes(p), a.pathRels = relationships(p)
RETURN a
$$) AS (a agtype);
a
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
{"id": 5066549580791809, "label": "TestE2", "properties": {"pathRels": [{"id": 5348024557502465, "label": "E2REL", "end_id": 5066549580791810, "start_id": 5066549580791809, "properties": {}}::edge], "pathNodes": [{"id": 5066549580791809, "label": "TestE2", "properties": {}}::vertex, {"id": 5066549580791810, "label": "TestE2", "properties": {}}::vertex]}}::vertex
(1 row)
--
-- Clean up
--
DROP TABLE tbl;
DROP FUNCTION set_test;
SELECT drop_graph('cypher_set', true);
NOTICE: drop cascades to 9 other objects
DETAIL: drop cascades to table cypher_set._ag_label_vertex
drop cascades to table cypher_set._ag_label_edge
drop cascades to table cypher_set.v
drop cascades to table cypher_set.e
drop cascades to table cypher_set.other_v
drop cascades to table cypher_set.vertices
drop cascades to table cypher_set.begin
drop cascades to table cypher_set.edge
drop cascades to table cypher_set."end"
NOTICE: graph "cypher_set" has been dropped
drop_graph
------------
(1 row)
SELECT drop_graph('cypher_set_1', true);
NOTICE: drop cascades to 9 other objects
DETAIL: drop cascades to table cypher_set_1._ag_label_vertex
drop cascades to table cypher_set_1._ag_label_edge
drop cascades to table cypher_set_1."Andy"
drop cascades to table cypher_set_1."Peter"
drop cascades to table cypher_set_1."Kevin"
drop cascades to table cypher_set_1."Matt"
drop cascades to table cypher_set_1."Juan"
drop cascades to table cypher_set_1."Robert"
drop cascades to table cypher_set_1."VertexA"
NOTICE: graph "cypher_set_1" has been dropped
drop_graph
------------
(1 row)
SELECT drop_graph('issue_1634', true);
NOTICE: drop cascades to 3 other objects
DETAIL: drop cascades to table issue_1634._ag_label_vertex
drop cascades to table issue_1634._ag_label_edge
drop cascades to table issue_1634."PERSION"
NOTICE: graph "issue_1634" has been dropped
drop_graph
------------
(1 row)
SELECT drop_graph('issue_1884', true);
NOTICE: drop cascades to 19 other objects
DETAIL: drop cascades to table issue_1884._ag_label_vertex
drop cascades to table issue_1884._ag_label_edge
drop cascades to table issue_1884."TestA1"
drop cascades to table issue_1884."TestA2"
drop cascades to table issue_1884."LINK"
drop cascades to table issue_1884."TestA3"
drop cascades to table issue_1884."REL"
drop cascades to table issue_1884."TestB1"
drop cascades to table issue_1884."TestB2"
drop cascades to table issue_1884."B2REL"
drop cascades to table issue_1884."TestB3"
drop cascades to table issue_1884."B3REL"
drop cascades to table issue_1884."TestC1"
drop cascades to table issue_1884."TestC2"
drop cascades to table issue_1884."TestD1"
drop cascades to table issue_1884."TestD2"
drop cascades to table issue_1884."TestE1"
drop cascades to table issue_1884."TestE2"
drop cascades to table issue_1884."E2REL"
NOTICE: graph "issue_1884" has been dropped
drop_graph
------------
(1 row)
--
-- End
--