The GitHub Actions job "Tests" on airflow.git has succeeded.
Run started by GitHub user kaxil (triggered by kaxil).

Head commit for run:
08f56c320ae0db2ccfbb1a7ec9a95dc1be9eae01 / Kaxil Naik <[email protected]>
AIP-72: Fix floating point imprecision in TI Duration calculation for SQLite

[julianday](https://www.sqlite.org/lang_datefunc.html#:~:text=The%20number%20of%20days%20including%20fractional%20days%20since%20%2D4713%2D11%2D24%2012%3A00%3A00%20Example%3A%202460825.09444444)
 returns timestamps as fractional days. Multiplying this value by 86400 
(seconds in a day) introduces minor floating-point inaccuracies, which can 
cause subtle errors in downstream calculations or assertions.

Example ( [PR 
failure](https://github.com/apache/airflow/actions/runs/12350551354/job/34464066950#step:7:2178)
 ):

```sql
SELECT (julianday('2024-06-01T01:00:00') - julianday('2024-06-01T00:00:00')) * 
86400;
-- Result: 3599.999986588955 (instead of 3600.0)
```

After:

```sql
SELECT CAST(ROUND((julianday('2024-06-01T01:00:00') - 
julianday('2024-06-01T00:00:00')) * 86400) AS INTEGER);
-- Result: 3600
```

Report URL: https://github.com/apache/airflow/actions/runs/12379309771

With regards,
GitHub Actions via GitBox


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to