[datafusion-spark] [SQL] [TEST] IntervalMonthDayNano(0,0,0) give line blank

[davidlghellin]

Describe the bug

When de IntervalMonthDayNano(0,0,0) , the test is line blank

To Reproduce

In one file tests for spark
execute

cargo test --test sqllogictests -- file --complete

query
SELECT INTERVAL '0' SECOND AS iv;

Expected behavior

some value like this (1 sec is => 1.000000000 secs see previous picture):

query ?
SELECT INTERVAL '0' SECOND AS iv;
----
0.000000000 secs

In Apache Spark

Additional context

development PR

[Jefffrey]

In DataFusion itself, it seems an empty MonthDayNano interval is displayed as an empty string.

e.g. this code generates this output:

 let a = ctx.sql("select make_interval()").await?.collect().await?;
 dbg!(a);
 ctx.sql("select make_interval()").await?.show().await?;

• Using this PR branch feat(spark): implement Spark make_interval function #17424 to get an empty MonthDayNano interval

Output:

[datafusion-examples/examples/regexp.rs:42:5] a = [
 RecordBatch {
 schema: Schema {
 fields: [
 Field {
 name: "make_interval()",
 data_type: Interval(
 MonthDayNano,
 ),
 nullable: false,
 dict_id: 0,
 dict_is_ordered: false,
 metadata: {},
 },
 ],
 metadata: {},
 },
 columns: [
 PrimitiveArray<Interval(MonthDayNano)>
 [
 IntervalMonthDayNano {
 months: 0,
 days: 0,
 nanoseconds: 0,
 },
 ],
 ],
 row_count: 1,
 },
]
+-----------------+
| make_interval() |
+-----------------+
| |
+-----------------+

This seems to be because in arrow-rs, if all values are 0 then nothing is written, see:

https://github.com/apache/arrow-rs/blob/2ec77b548d9242bc85ca36f04761d116ceab8963/arrow-cast/src/display.rs#L733-L758

• Related issue: Improve the display of interval types arrow-rs#5914

I'll assume this is an arrow-rs issue and mark as waiting upstream, unless the SLT tests do output formatting of values elsewhere