TST/COMPAT: update csv test to infer time with pyarrow>=6.0
Closes #44231
Thanks @jorisvandenbossche. This has now starting failing on master and so I guess probably 1.3.x too. Will milestone 1.3.5 for backport. > Thanks @jorisvandenbossche. This has now starting failing on master and so I guess probably 1.3.x too. Will milestone 1.3.5 for backport.

The new pyarrow engine should only be present on master, so I guess backport is not needed.

@jorisvandenbossche Do you know if pyarrow will add an option to configure this auto-inference? Good point.

I am not aware of any discussion about an option to turn it off (looking at https://issues.apache.org/jira/browse/ARROW-11247 now) The sdist 3.10 build was failing (unrelated I suppose), is that a know failure ? (I don't directly see an issue about it)