Some time ago, a customer had a performance issue with an internal process. He was comparing, finding, and reporting the rows that were different between two tables. This is simple if you use a LEFT JOIN and an [crayon-5bb531ff69722715358825-i/]  comparison over the second table in the WHERE clause, but what if the column could be null? That [&]

The post Finding Table Differences on Nullable Columns Using MySQL Generated Columns appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/10/03/finding-table-differences-nullable-columns-using-mysql-generated-columns/