Mysql - Value limit for mathematical operations

Asked

Viewed 142 times

0

I am in doubt about the following situation:

I have two values not stored in table.

Valor 1: 9223372036854775806 (Onde este é o valor máximo de um tipo de dado BIGINT)
Valor 2: 9999999999999999999999999999999999999999999999999999999999999999999999999999999 (Um número qualquer gigantesco)

When performing the following operation...

SELECT 9223372036854775807 + 1

The following error occurs:

Error Code: 1690. BIGINT value is out of range in '(9223372036854775807 + 1)'

Already in the following operation, it works normally...

SELECT 9999999999999999999999999999999999999999999999999999999999999999999999999999999 +1

Upshot:

10000000000000000000000000000000000000000000000000000000000000000000000000000000

I ask you...

If the limit for BIGINT is 9223372036854775807, pq no error occurs in the second operation?

  • (just to know) The second select does not work on SQL Server, gives error: ... está fora do intervalo de representação numérica do computador (a precisão máxima é 38)

  • In this case, they are being performed in Mysql.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.