csv import fails when parse an empty string as a date

[sterin501]

Guidelines

apoc.import.csv fails when parse an empty string as a date
But empty string and int process fine the same procedure .

Expected Behavior (Mandatory)

Empty or null date in the csv should import like empty string and empty int

Actual Behavior (Mandatory)

Failed to invoke procedure apoc.import.csv: Caused by: org.neo4j.exceptions.TemporalParseException: Text cannot be parsed to a Date
""
^

How to Reproduce the Problem

Simple Dataset (where it's possibile)

pass.csv

id:ID,:LABEL,str:STRING,int:INT,date:DATE
1,lab,hello,1,2020-01-01
2,lab,world,2,2020-01-01
3,lab,,,2020-01-01

fail.csv

id:ID,:LABEL,str:STRING,int:INT,date:DATE
1,lab,hello,1,2020-01-01
2,lab,world,2,2020-01-01
3,lab,,,

Steps (Mandatory)

1 .CALL apoc.import.csv([{fileName: 'pass.csv', labels:[]}], [], {nullValues: ['']})`
works fine in ignoring the blank strings skipping the attribute creation.

However,
2 . CALL apoc.import.csv([{fileName: 'fail.csv', labels:[]}], [], {nullValues: ['']})
will fail with

Failed to invoke procedure apoc.import.csv: Caused by: org.neo4j.exceptions.TemporalParseException: Text cannot be parsed to a Date
""
^

Screenshots (where it's possibile)

Specifications (Mandatory)

4.4.4

Versions

• OS:ubuntu
• Neo4j:4.4.4
• Neo4j-Apoc:apoc-4.4.0.1-all.jar