title: MySQL upgrade causing unexpected results on simple WHERE clauses
body: <p>I'm upgrading my Laravel app to use MySQL 8.0.23 from 8.0.20, and I see an issue with WHERE clauses that produce unexpected results.</p>
  <pre><code>SELECT * FROM guilds 
      WHERE platform_id = 1 
      AND platform_server_id = '407254666900930563';
  </code></pre>
  <p>Running ^ directly on the MySQL server produces the record I'm looking for (regardless of whether <code>40725...</code> is an <code>int</code> or a <code>string</code>). However, using it through Laravel's Eloquent Query Builder, it is not finding the record.  Here's the eloquent code.</p>
  <pre><code>// Won't find it if it's a string, will if it's an int
  $serverId = '407254666900930563';
  Server::where('platform_id', 1)
      -&gt;where('platform_server_id', $serverId)
      -&gt;first()
  </code></pre>
  <p>The data is here:</p>
  <p><a href="https://i.stack.imgur.com/mKkw9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mKkw9.png" alt="enter image description here" /></a></p>
  <p>I've verified in the DB that <code>platform_id</code> does indeed = 1 (verified by running the SQL directly).</p>
  <p>Here's my MySQL config on the Laravel side.</p>
  <pre><code>'charset' =&gt; 'utf8mb4',
  'collation' =&gt; 'utf8mb4_unicode_ci',
  'prefix' =&gt; '',
  'prefix_indexes' =&gt; true,
  'strict' =&gt; true,
  'engine' =&gt; null,
  'options' =&gt; extension_loaded('pdo_mysql') ? array_filter([
      PDO::MYSQL_ATTR_SSL_CA =&gt; env('MYSQL_ATTR_SSL_CA'),
  ]) : [],
  'modes'  =&gt; [
      /**
       * Disabled because of a group by we need
       */
      //'ONLY_FULL_GROUP_BY',
  
      'STRICT_TRANS_TABLES',
      'NO_ZERO_IN_DATE',
      'NO_ZERO_DATE',
      'ERROR_FOR_DIVISION_BY_ZERO',
      'NO_ENGINE_SUBSTITUTION',
  ]
  </code></pre>
  <p>I've looked through MySQL changelogs and am not seeing what could be causing this.  Does anyone have any ideas about what I should investigate?</p>
  <p>CREATE TABLE statement is:</p>
  <pre><code>CREATE TABLE `guilds` (
    `id` bigint unsigned NOT NULL AUTO_INCREMENT,
    `platform_id` bigint unsigned NOT NULL,
    `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `platform_server_id` bigint unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `guilds_platform_id_platform_server_id_unique` (`platform_id`,`platform_server_id`),
    KEY `guilds_platform_server_id_index` (`platform_server_id`),
  ) ENGINE=InnoDB AUTO_INCREMENT=691420 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  </code></pre>