Comment 3 for bug 1721753

Revision history for this message
Nickolay Ihalainen (ihanick) wrote : Re: Query result changed between 5.6.36-82.0 and 5.6.36-82.1

Hi,

I'm getting exactly the same results for 5.6.36-82.1 as you listed for 5.6.36-82.0.

mysql> SELECT DISTINCT partner0_.organizationOID AS col_0_0_ FROM mad_partner partner0_ WHERE partner0_.OID IN (
    -> 'be067ca5-6cd3-42dc-8a68-a08e9800b195',
    -> 'dff1ffa7-58c2-46f3-9880-9a02e8e9c8ab',
    -> '8c1fb1ae-25e2-49f8-bb6a-65b5716d0d2b',
    -> '7a090a98-08ec-4924-ac1a-d4b45c749cac',
    -> '83031acb-43cd-4c97-963e-8692a007aba5');
+--------------------------------------+
| col_0_0_ |
+--------------------------------------+
| e0f52141-941b-437c-87a5-dff3f4f74999 |
+--------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT DISTINCT partner0_.organizationOID AS col_0_0_ FROM mad_partner partner0_ WHERE partner0_.OID IN (
    -> 'dff1ffa7-58c2-46f3-9880-9a02e8e9c8ab',
    -> '7a090a98-08ec-4924-ac1a-d4b45c749cac',
    -> 'be067ca5-6cd3-42dc-8a68-a08e9800b195');
+--------------------------------------+
| col_0_0_ |
+--------------------------------------+
| e0f52141-941b-437c-87a5-dff3f4f74999 |
+--------------------------------------+
1 row in set (0.00 sec)

mysql> select version();
+-------------+
| version() |
+-------------+
| 5.6.36-82.1 |
+-------------+
1 row in set (0.00 sec)

Could you try to reproduce the issue on single server or verify that data is the same on master and slaves with pt-table-checksum: https://www.percona.com/blog/2015/08/12/mysql-replication-primer-with-pt-table-checksum-and-pt-table-sync/

Thanks,
Nickolay