MySQL upgrade causing unexpected results on simple WHERE clauses in Laravel

• Yogesh Kumar
• 02-May-2022
• 0

These don't look the same:

 407254666900930563 

Is platform_server_id a BIGINT or a VARCHAR?

Also, I see inconsistencies in quoting the value.

Here's a guess: When Laravel runs the query without quotes, it sees a number, converts it to DOUBLE. But a Double cannot hold more than about 16 significant digits. You seem to need all 18.

Please use the real numbers -- BIGINT also has a limitation that these numbers are close to.

Please provide SHOW CREATE TABLE; there are other details that may be relevant.

* Be the first to Make Comment