The following error occurs when retrieving the Cypher aggregate function result.
I tested in AgensGraph v2.12.
agens@bitnine31:~$ agens testdb -p 5500
agens (10.4, server 12.8)
WARNING: agens major version 10, server major version 12.
Some psql features might not work.
Type "help" for help.
testdb=# match(a:person) return min(a.born);
ERROR: numeric field overflow
DETAIL: A field with precision 0, scale 12 must round to an absolute value less than 10^-12.
testdb=# match(a:person) return max(a.born);
ERROR: numeric field overflow
DETAIL: A field with precision 0, scale 12 must round to an absolute value less than 10^-12.
testdb=# match(a:person) where a.name in ['Keanu Reeves','Carrie-Anne Moss'] return stDev(a.born);
ERROR: numeric field overflow
DETAIL: A field with precision 0, scale 1020 must round to an absolute value less than 10^-1020.
When returning using the min, max, avg, and stDev functions in Cypher, the following error occurs in common.
ERROR: numeric field overflow
DETAIL: A field with precision 0, scale 1020 must round to an absolute value less than 10^-1020.
Hello.
The following error occurs when retrieving the Cypher aggregate function result.
I tested in AgensGraph v2.12.
agens@bitnine31:~$ agens testdb -p 5500 agens (10.4, server 12.8) WARNING: agens major version 10, server major version 12. Some psql features might not work. Type "help" for help.
create graph testgraph; set graph_path=testgraph; testdb=# CREATE (Keanu:Person {name:'Keanu Reeves', born:1964}) testdb-# CREATE (Carrie:Person {name:'Carrie-Anne Moss', born:1967}) testdb-# CREATE (Laurence:Person {name:'Laurence Fishburne', born:1961}) testdb-# CREATE (Hugo:Person {name:'Hugo Weaving', born:1960}) testdb-# CREATE (AndyW:Person {name:'Andy Wachowski', born:1967}) testdb-# CREATE (LanaW:Person {name:'Lana Wachowski', born:1965}) testdb-# CREATE (JoelS:Person {name:'Joel Silver', born:1952});
testdb=# match(a:person) return min(a.born); ERROR: numeric field overflow DETAIL: A field with precision 0, scale 12 must round to an absolute value less than 10^-12. testdb=# match(a:person) return max(a.born); ERROR: numeric field overflow DETAIL: A field with precision 0, scale 12 must round to an absolute value less than 10^-12. testdb=# match(a:person) where a.name in ['Keanu Reeves','Carrie-Anne Moss'] return stDev(a.born); ERROR: numeric field overflow DETAIL: A field with precision 0, scale 1020 must round to an absolute value less than 10^-1020.
When returning using the min, max, avg, and stDev functions in Cypher, the following error occurs in common. ERROR: numeric field overflow DETAIL: A field with precision 0, scale 1020 must round to an absolute value less than 10^-1020.
please check.