Skip to content

Commit e57dead

Browse files
authored
add test case for cast_timestamp_before_1970 (#3163)
* add test case for cast_timestamp_before_1970 * datafusion/core/tests/sql/timestamp.rs
1 parent 9543d38 commit e57dead

1 file changed

Lines changed: 32 additions & 0 deletions

File tree

‎datafusion/core/tests/sql/timestamp.rs‎

Lines changed: 32 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -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

Comments
 (0)