[BUG] Issues found by Spark UT Framework on RapidsCastSuite

[binmahone]

Describe the bug

Spark UT Framework enabled RapidsCastSuite (https://github.com/NVIDIA/spark-rapids/pull/10743), with the following test cases explicitly excluded:

• [x] #10794 Break UT "Process Infinity, -Infinity, NaN in case insensitive manner"
• [ ] cast string "1582-10-15 23:59:59.0" not correct to "1582-10-15 18:09:39.0". Break UT: "cast timestamp without time zone to timestamp with local time zone"
• [ ] cast "0001-01-01 05:50:20" as timestamp_ntz not correct to "0001-01-01T05:50:20" Break UT: "cast timestamp with local time zone to timestamp without timezone"
• [ ] string being cast to a day-time interval does not have a valid format, or out of acceptable range or overflow issue. Break UT "Cast string to day-time interval"
• [ ] string format provided for the cast operation was invalid. Break UT: "Take into account day-time interval fields in cast"
• [x] #10809 Break UT "casting to fixed-precision decimals"
• [x] IExampleBaseType is not presumably a user-defined type, not annotated with @SQLUserDefinedType or registed with UDTRegistration. Break UT "cast from a derived user-defined type to a base type"
• [ ] Incorrect evaluation: cast(2015 as timestamp), actual: 2015-01-01 00:00:00.0, expected: 2015-01-01 04:00:00.0 Break UT "cast string to timestamp", related to Timezone
• [ ] Incorrect evaluation: cast(12345 as date), actual: null, expected: 345-01-01 Break UT "cast string to date", plugin doesn't support year more than 4 digits.

These excluded test cases needs further investigating!!! Notice: Other test cases in this suite may pass with falling back!

Steps/Code to reproduce bug

1. Compile everything with mvn -Dbuildver=330 install -DskipTests
2. Pick a test case name in the above table
3. Go to RapidsTestSettings and find the line starting with ".exclude" and containing the test case name, comment it out
4. Run the Suite then you'll see one failed test case. E.g. mvn -nsu -Dbuildver=330 -pl tests -Dsuites="org.apache.spark.sql.rapids.suites.RapidsXXXSuite" test (replace RapidsXXXSuite with the right name in issue header). ALWAYS double check if your suite name coincide with in source code, as it may contain typos!

Expected behavior The suite can pass without excluding any test case.

[mattahrens]

Initial scope is triaging unit test failures to determine priorities of individual issues.