Bug displaying fractional seconds in `IntervalMonthDayNano`

[alamb]

    thank you @Jefffrey 

there's a bug while displaying IntervalMonthDayNano

❯ select interval '0.0001 second';
+----------------------------------------------------+
| IntervalMonthDayNano("100000")                     |
+----------------------------------------------------+
| 0 years 0 mons 0 days 0 hours 0 mins 0.100000 secs |
+----------------------------------------------------+
1 row in set. Query took 0.002 seconds.

i checked the underline value it's correct (month: 0, day: 0, nanos: 100000)
i think this is the display issue

Originally posted by @waitingkuo in #4186 (review)

[alamb]

I think this will be fixed by apache/arrow-rs#3093 (in the next release after arrow 27.0.0)

[waitingkuo]

@alamb just found another bug while displaying fraction seconds

❯ select interval '-0.0001 second';
+-------------------------------------------------------+
| IntervalMonthDayNano("-100000")                       |
+-------------------------------------------------------+
| 0 years -1 mons -1 days 0 hours 0 mins 0.-100000 secs |
+-------------------------------------------------------+
1 row in set. Query took 0.002 seconds.

do you prefer submit another issue? I think it's arrow-rs's prettyprint issue as well

[waitingkuo]

@alamb i submit another issue #4237 since negative value isn't pure display issue
the 0.-10000 secs is the display issue
and the -1 mons and -1 days is the parsing issue

[Jefffrey]

Resolved by apache/arrow-rs#3491 via arrow-rs v31 update #4927

DataFusion CLI v16.0.0
❯ select interval '-0.0001 second';
+--------------------------------------------------------+
| IntervalMonthDayNano("18446744073709451616")           |
+--------------------------------------------------------+
| 0 years 0 mons 0 days 0 hours 0 mins -0.000100000 secs |
+--------------------------------------------------------+
1 row in set. Query took 0.002 seconds.
❯

[alamb]

❤️