[jira] [Resolved] (ARROW-10115) [C++] CSV empty quoted string is treated as NULL

["Antoine Pitrou (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ARROW-10115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Antoine Pitrou resolved ARROW-10115.
------------------------------------
    Fix Version/s: 5.0.0
       Resolution: Fixed

Issue resolved by pull request 10503
[https://github.com/apache/arrow/pull/10503]

> [C++] CSV empty quoted string is treated as NULL
> ------------------------------------------------
>
>                 Key: ARROW-10115
>                 URL: https://issues.apache.org/jira/browse/ARROW-10115
>             Project: Apache Arrow
>          Issue Type: Improvement
>          Components: C++
>    Affects Versions: 1.0.1
>            Reporter: Maciej
>            Assignee: Antoine Pitrou
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 5.0.0
>
>          Time Spent: 1h 10m
>  Remaining Estimate: 0h
>
> When parsing my CSV I have set
> {color:#267f99}ConvertOptions{color}::s{color:#001080}trings_can_be_null{color} to true.
> Now as I have values:
> {code:java}
> 1234,"",345
> {code}
> the string value which is an empty string is treated as NULL.
> I've checked default valeus of {color:#267f99}ConvertOptions{color}::{color:#001080}null_values{color} and there is empty string considered null, but here we have empty quoted string which shouldn't be treated as NULL in my opinion. Similar behavior we have in Postgresql, empty quoted string is not treated as a NULL: https://www.postgresql.org/docs/12/sql-copy.html



--
This message was sent by Atlassian Jira
(v8.3.4#803005)