alexa
Facebook
Twitter
LinkedIn
Instagram
Whatsapp
Call Now
Quick Inquiry

MySQL upgrade causing unexpected results on simple WHERE clauses in Laravel

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.


32 0
7

Write a Comments


* Be the first to Make Comment

GoodFirms Badge
GoodFirms Badge

Fix Your Meeting With Our SEO Consultants in India To Grow Your Business Online