The CSV file read as a record failed when a nillable field was empty

[daneshk]

Description

If a record has a nullable field and we don't provide a value for that field in the CSV content, the application fails with an error.

Record type and CSV file does not match.

Expected:
Should not fail and assign () value for that field

Steps to Reproduce

Run the below sample

Sample code:

public function main() returns error? {
    stream<Person, io:Error?> streamValue = check io:fileReadCsvAsStream("test1.csv");
    check from Person p in streamValue
    do {
        io:println(p);
    };
}

type Person record {|
    int id;
    string? name;
    int age;
|};

Sample CSV file

"id","name","age"
1,"Alice",20
2,,12

Version

1.6.1

Environment Details (with versions)

No response

[github-actions]

This issue is NOT closed with a proper Reason/ label. Make sure to add proper reason label before closing. Please add or leave a comment with the proper reason label now.

      - Reason/EngineeringMistake - The issue occurred due to a mistake made in the past.
      - Reason/Regression - The issue has introduced a regression.
      - Reason/MultipleComponentInteraction - Issue occured due to interactions in multiple components.
      - Reason/Complex - Issue occurred due to complex scenario.
      - Reason/Invalid - Issue is invalid.
      - Reason/Other - None of the above cases.