----- Original Message ----- > From: "Shawn Green (MySQL)" <shawn.l.gr...@oracle.com> > > Simple math (set theory) suggests that all of the values of field1 on > db2.table1 contain only copies or duplicates of the field1 values in > the rows in db1.table1.
Shawn, The "select count(distinct)"s show that db1.table1.field1 has a lot less unique values than db2.table1.field1, so I'm kind of struggling to understand how 3516 unique values can be mapped to a subset of 1063 unique values :-) > SELECT db2.field1, db1.field1 > FROM db2.table1 > LEFT JOIN db1.table1 > ON db2.field1 = db1.field1 > WHERE db1.field1 IS NULL; That's the interesting bit, indeed - if that gives back a more sensible number (logic dictates at least 2053 of the 3516 can not be the same as the 1063) it'll prove that there is indeed a bug somewhere. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
