apoc.export.csv.query() does not register duration.inSeconds formatting

[edtky]

Guidelines

Please note that GitHub issues are only meant for bug reports/feature requests. If you have questions on how to use APOC, please ask on the Neo4j Discussion Forum instead of creating an issue here.

Expected Behavior (Mandatory)

CALL apoc.export.csv.query(" ... ... RETURN duration.inSeconds(a.timeStamp, b.timeStamp) ..." )
should return "P0M0DT2651S" in the csv file (only seconds)

Actual Behavior (Mandatory)

wrongly returns "PT44M11S" in csv file (minutes and seconds)
(when queried directly on Neo4j, it correctly returns "P0M0DT930S" on the dashboard)

How to Reproduce the Problem

Simple Dataset (where it's possible)

//Insert here a set of Cypher statements that helps us to reproduce the problem

Steps (Mandatory)

Screenshots (where it's possible)

Specifications (Mandatory)

Currently used versions

Versions

• OS:
• Neo4j:
• Neo4j-Apoc:

[vboulaye]

Hi,
I tried to work on this issue.
I managed to reproduce it (I made a test in dba589c).

But I cannot figure out how the dashboard is working: the output from csv.query is calling the toString() from DurationValuè which is always computing an hour/minute component from the seconds in the duration.

[enriquezrene]

@vboulaye
The issue is DurationValue.toString is invoking prettyPrint() which transforms seconds to hours, minutes.

[enriquezrene]

I think the following PR might work #1322
I took the changes from your commit. @vboulaye

[fbiville]

I managed to reproduce it (I made a test in dba589c).

Based on a slightly updated variant of this test, the Java API of Neo4j and Cypher-Shell return 1 value: "PT9H5M35.353S".
Neo4j Browser returns another P0M0DT32735.353000000S.
It might be a driver issue.

[conker84]

@fbiville any news on this?