br1ghtyang / asterixdb

Automatically exported from code.google.com/p/asterixdb
0 stars 0 forks source link

FuzzyJoin doesn't return correct results when lhs and rhs are exchanged in the join predicate #618

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
The test case fuzzyjoin/user-int-aqlplus_1 returns the correct results while 
the test case fuzzyjoin/user-int-aqlplus_3 doesn't return any results.

Original issue reported on code.google.com by icetin...@gmail.com on 23 Aug 2013 at 7:41

GoogleCodeExporter commented 8 years ago
fuzzyjoin/user-int-aqlplus_1:

use dataverse fuzzyjoin;

set simthreshold '.5f';

for $user in dataset('Users')
for $user2 in dataset('Users')
where $user.interests ~= $user2.interests and $user.uid < $user2.uid
order by $user.uid, $user2.uid
return { 'user': $user, 'user2': $user2 }

fuzzyjoin/user-int-aqlplus_3:

use dataverse fuzzyjoin;

set simthreshold '.5f';

for $user in dataset('Users')
for $user2 in dataset('Users')
where $user2.interests ~= $user.interests and $user.uid < $user2.uid
order by $user.uid, $user2.uid
return { 'user': $user, 'user2': $user2 }

Original comment by icetin...@gmail.com on 23 Aug 2013 at 8:25

GoogleCodeExporter commented 8 years ago
The issue was caused by a problem in data loading. The problem is documented in 
issue 650, and the DML file for this test case is fixed.

Original comment by icetin...@gmail.com on 19 Oct 2013 at 12:28