connector-x icon indicating copy to clipboard operation
connector-x copied to clipboard

Cannot load timestamp from oracle when before '1677-09-22 00:00:00'

Open lscheilling opened this issue 1 year ago • 1 comments

What language are you using?

Python

What version are you using?

Python 3.9 connectorx==0.3.4a1

What database are you using?

OracleDB

What dataframe are you using?

Polars

Can you describe your bug?

Seems to not be able to load timestamps before 1677-09-22 00:00:00

What are the steps to reproduce the behavior?

import connectorx as cx

connection = "oracle://..."

cx.read_sql(connection, "SELECT timestamp '1677-09-22 00:00:00' FROM table", return_type="polars2") # works
cx.read_sql(connection, "SELECT timestamp '1677-09-21 00:00:00' FROM table", return_type="polars2") # fails

Error: pyo3_runtime.PanicException: out of range DateTime

Database setup if the error only happens on specific data or data type

Included in example above (no specific table needed for this query)

Example query / code
import connectorx as cx

connection = "oracle://..."

cx.read_sql(connection, "SELECT timestamp '1677-09-22 00:00:00' FROM table", return_type="polars2") # works
cx.read_sql(connection, "SELECT timestamp '1677-09-21 00:00:00' FROM table", return_type="polars2") # fails
cx.read_sql(connection, "SELECT timestamp '1677-09-22 00:00:00' FROM table", return_type="polars") # works
cx.read_sql(connection, "SELECT timestamp '1677-09-21 00:00:00' FROM table", return_type="polars") # fails

What is the error?

pyo3_runtime.PanicException: out of range DateTime

lscheilling avatar Sep 09 '24 11:09 lscheilling