@@ -1433,3 +1433,35 @@ async fn timestamp_array_add_interval() -> Result<()> {
14331433 assert_batches_eq ! ( expected, & actual) ;
14341434 Ok ( ( ) )
14351435}
1436+
1437+ #[ tokio:: test]
1438+ async fn cast_timestamp_before_1970 ( ) -> Result < ( ) > {
1439+ // this is a repro for issue #3082
1440+ let ctx = SessionContext :: new ( ) ;
1441+
1442+ let sql = "select cast('1969-01-01T00:00:00Z' as timestamp);" ;
1443+ let actual = execute_to_batches ( & ctx, sql) . await ;
1444+ let expected = vec ! [
1445+ "+-------------------------------------------------------------------+" ,
1446+ "| CAST(Utf8(\" 1969-01-01T00:00:00Z\" ) AS Timestamp(Nanosecond, None)) |" ,
1447+ "+-------------------------------------------------------------------+" ,
1448+ "| 1969-01-01 00:00:00 |" ,
1449+ "+-------------------------------------------------------------------+" ,
1450+ ] ;
1451+
1452+ assert_batches_eq ! ( expected, & actual) ;
1453+
1454+ let sql = "select cast('1969-01-01T00:00:00.1Z' as timestamp);" ;
1455+ let actual = execute_to_batches ( & ctx, sql) . await ;
1456+ let expected = vec ! [
1457+ "+---------------------------------------------------------------------+" ,
1458+ "| CAST(Utf8(\" 1969-01-01T00:00:00.1Z\" ) AS Timestamp(Nanosecond, None)) |" ,
1459+ "+---------------------------------------------------------------------+" ,
1460+ "| 1969-01-01 00:00:00.100 |" ,
1461+ "+---------------------------------------------------------------------+" ,
1462+ ] ;
1463+
1464+ assert_batches_eq ! ( expected, & actual) ;
1465+
1466+ Ok ( ( ) )
1467+ }
0 commit comments