I have a strange problem and no idea where to start debugging it.
I have a normal users table that also contains a UUID column with automatically generated uuids like
563e3b44-7f66-4ba7-b9e0-71bdeab19468 for example (some of the UUIDs start with a number).
I run a simple query like
$users = User::where('uuid', '=', 5)->get(); dd($users);
The expected result would be that there are no results because but the query does return a seemingly random subset of all the users where the UUID starts with the number
mysql is in
strict mode and the DB query that is run is
SELECT * FROM `users` WHERE `uuid` = '5' and `users`.`deleted_at` IS NULL
L5.3 on PHP 7
Does anyone have an idea where and how to look into that?