CSV File Scan cannot read a csv with more than 512 columns

[kunwp1]

[chenlica]

@Ma77Ball Can you take a look, as you worked on a similar issue before? You can include the corresponding issue and PR.

[Ma77Ball]

This is mentioned in this issue #3825. I created a fixed branch but haven't raised a PR yet, as the design hasn't been agreed upon.

[chenlica]

Please drive the effort to finish this PR soon.

[Ma77Ball]

@kunwp1 and @chenlica, please refer to this pr to fix the issue. I added some notification, error, and test handling to finalize this feature.

[chenlica]

Thanks. Let's do the discussion in #4669 .