apache / apache/datafusion

Numeric overflow should result in query error

Abierto
#17,539 6 comentarios 0 reacciones 1 asignado Reclamado por @EeshanBembi Ver en GitHub
bug
Lenguaje dominante
Rust
Estrellas
9.3k
Forks
2.4k
Merge medio
3 d 11 h
PR fusionados (30 d)
362

Descripción

### Describe the bug

In programming languages it's rather typical that numeric overflows are not a runtime error.

In SQL, it's rather typical that numeric overflows are identified during query execution and are treated as an error.

DataFusion is a SQL engine and therefore should report overflows as query errors. Continuing execution after overflows happened is a correctness issue (query results a wrong result).

### To Reproduce

```shell
cargo run --bin datafusion-cli -- --command "SELECT 10000000000 * 10000000000;"
```

```
datafusion main$ cargo run --bin datafusion-cli -- --command "SELECT 10000000000 * 10000000000;"
Finished `dev` profile [unoptimized + debuginfo] target(s) in 0.17s
Running `target/debug/datafusion-cli --command 'SELECT 10000000000 * 10000000000;'`
DataFusion CLI v50.0.0
+-----------------------------------------+
| Int64(10000000000) * Int64(10000000000) |
+-----------------------------------------+
| 7766279631452241920 |
+-----------------------------------------+
```

### Expected behavior

### PostgreSQL

```
postgres=# SELECT 10000000000 * 10000000000;
ERROR: bigint out of range
```

### Trino
```
trino> SELECT 10000000000 * 10000000000;
Query 20250912_093345_00000_kgiyz failed: bigint multiplication overflow: 10000000000 * 10000000000
```

### Snowflake
```
SELECT 10000000000 * 10000000000 * 10000000000 * 10000000000;
-- Number out of representable range: type FIXED[SB16](38,0){not null}, value 1e+40
```

### Additional context

_No response_

Guía de contribución

Abrir la guía de contribución

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.