Prepared statement does not work with dates >= 10000/01/01

[kaciakmaciak]

What happens?

In prepared statements, dates (and other data types) are serialised using JSON.stringify. The date values are stringified using Date.prototype.toISOString() fn. See MDN. Everything works fine, as long as the resulting format is YYYY-MM-DDTHH:mm:ss.sssZ or -YYYYYY-MM-DDTHH:mm:ss.sssZ. The things brake when the resulting format is +YYYYYY-MM-DDTHH:mm:ss.sssZ.

To Reproduce

const connection = await duckdbInstance.connect();
const statement = await connection.prepare(`
  SELECT CAST(? AS DATE)
`);
// the following throws
const result = await statement.query(new Date(Date.UTC(10000, 0, 1)));

Please see an example in Codesandbox.

Browser/Environment:

Any

Device:

Any

DuckDB-Wasm Version:

1.28.1-dev242.0

DuckDB-Wasm Deployment:

N/A

Full Name:

Katarina Anton

Affiliation:

Individual