Advertisement

TrimwebsolutionsTrimwebsolutions

Problem and Solutions

MySQL upgrade causing unexpected results on simple WHERE clauses in Laravel

By M.K. Verma · 2 May 2022

MySQL upgrade causing unexpected results on simple WHERE clauses in Laravel

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.