Select query with join sometimes returns empty set

A query in our hostedapi database (dolt version 1.35.10) sometimes returns an empty set when it shouldn't.

```sql
mysql> SELECT email_addresses.* FROM email_addresses JOIN `users` ON email_addresses.id = users.primary_email_fk WHERE users.id = '2a1e3627-6b0d-4788-b3d9-27bb83f059e7';
Empty set (0.01 sec)

mysql> SELECT email_addresses.* FROM email_addresses JOIN `users` ON email_addresses.id = users.primary_email_fk WHERE users.id = '2a1e3627-6b0d-4788-b3d9-27bb83f059e7';
+--------------------------------------+--------------------------------------+-----------------+-------------+---------------------+---------------------+
| id | user_id_fk | address | is_verified | updated_at | created_at |
+--------------------------------------+--------------------------------------+-----------------+-------------+---------------------+---------------------+
| 0e85068d-9afd-448a-be20-48854ebb8baf | 2a1e3627-6b0d-4788-b3d9-27bb83f059e7 | max@dolthub.com | 1 | 2024-02-16 22:32:03 | 2024-02-16 22:32:03 |
+--------------------------------------+--------------------------------------+-----------------+-------------+---------------------+---------------------+
1 row in set (0.00 sec)
```

These are the schemas of the `users` and `email_addresses` tables:
```sql
mysql> show create table users;
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| users | CREATE TABLE `users` (
`id` varchar(36) NOT NULL,
`name` varchar(32) NOT NULL,
`display_name` varchar(128),
`company` varchar(128),
`updated_at` timestamp(6),
`created_at` timestamp(6),
`primary_email_fk` varchar(36),
`saml_provider_id_fk` varchar(36),
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
UNIQUE KEY `name` (`name`),
KEY `primary_email_fk` (`primary_email_fk`),
KEY `saml_provider_id_fk` (`saml_provider_id_fk`),
CONSTRAINT `2gv1aord` FOREIGN KEY (`primary_email_fk`) REFERENCES `email_addresses` (`id`) ON DELETE RESTRICT,
CONSTRAINT `users_saml_provider_id_fk_constraint` FOREIGN KEY (`saml_provider_id_fk`) REFERENCES `saml_identity_providers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> show create table email_addresses;
+-----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| email_addresses | CREATE TABLE `email_addresses` (
`id` varchar(36) NOT NULL,
`user_id_fk` varchar(36),
`address` varchar(320) NOT NULL,
`is_verified` tinyint NOT NULL,
`updated_at` timestamp(6),
`created_at` timestamp(6),
PRIMARY KEY (`id`),
UNIQUE KEY `address` (`address`),
UNIQUE KEY `id` (`id`),
KEY `user_id_fk` (`user_id_fk`),
CONSTRAINT `etjvpu9s` FOREIGN KEY (`user_id_fk`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin |
+-----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
```

The user and email address IDs both exist:
```sql
mysql> select * from users where id = '2a1e3627-6b0d-4788-b3d9-27bb83f059e7';
+--------------------------------------+-------------+--------------+---------+---------------------+---------------------+--------------------------------------+---------------------+
| id | name | display_name | company | updated_at | created_at | primary_email_fk | saml_provider_id_fk |
+--------------------------------------+-------------+--------------+---------+---------------------+---------------------+--------------------------------------+---------------------+
| 2a1e3627-6b0d-4788-b3d9-27bb83f059e7 | max-hoffman | | | 2024-02-16 22:32:03 | 2024-02-16 22:32:03 | 0e85068d-9afd-448a-be20-48854ebb8baf | NULL |
+--------------------------------------+-------------+--------------+---------+---------------------+---------------------+--------------------------------------+---------------------+
1 row in set (0.00 sec)

mysql> select * from email_addresses where id='0e85068d-9afd-448a-be20-48854ebb8baf';
+--------------------------------------+--------------------------------------+-----------------+-------------+---------------------+---------------------+
| id | user_id_fk | address | is_verified | updated_at | created_at |
+--------------------------------------+--------------------------------------+-----------------+-------------+---------------------+---------------------+
| 0e85068d-9afd-448a-be20-48854ebb8baf | 2a1e3627-6b0d-4788-b3d9-27bb83f059e7 | max@dolthub.com | 1 | 2024-02-16 22:32:03 | 2024-02-16 22:32:03 |
+--------------------------------------+--------------------------------------+-----------------+-------------+---------------------+---------------------+
1 row in set (0.00 sec)
```