Author: srowen
Date: Wed Dec 3 10:06:54 2008
New Revision: 722991
URL: http://svn.apache.org/viewvc?rev=722991&view=rev
Log:
Fix MAHOUT-101 for real: need to reference item ID column from prefs table
Modified:
lucene/mahout/trunk/core/src/main/java/org/apache/mahout/cf/taste/impl/recommender/slopeone/jdbc/MySQLJDBCDiffStorage.java
Modified:
lucene/mahout/trunk/core/src/main/java/org/apache/mahout/cf/taste/impl/recommender/slopeone/jdbc/MySQLJDBCDiffStorage.java
URL:
http://svn.apache.org/viewvc/lucene/mahout/trunk/core/src/main/java/org/apache/mahout/cf/taste/impl/recommender/slopeone/jdbc/MySQLJDBCDiffStorage.java?rev=722991&r1=722990&r2=722991&view=diff
==============================================================================
---
lucene/mahout/trunk/core/src/main/java/org/apache/mahout/cf/taste/impl/recommender/slopeone/jdbc/MySQLJDBCDiffStorage.java
(original)
+++
lucene/mahout/trunk/core/src/main/java/org/apache/mahout/cf/taste/impl/recommender/slopeone/jdbc/MySQLJDBCDiffStorage.java
Wed Dec 3 10:06:54 2008
@@ -104,9 +104,9 @@
// getRecommendableItemsSQL
"SELECT id FROM " +
"(SELECT " + itemIDAColumn + " AS id FROM " + diffsTable + ", " +
dataModel.getPreferenceTable() +
- " WHERE " + itemIDBColumn + " = id AND " +
dataModel.getUserIDColumn() + "=? UNION DISTINCT" +
+ " WHERE " + itemIDBColumn + " = " + dataModel.getItemIDColumn() + "
AND " + dataModel.getUserIDColumn() + "=? UNION DISTINCT" +
" SELECT " + itemIDBColumn + " AS id FROM " + diffsTable + ", " +
dataModel.getPreferenceTable() +
- " WHERE " + itemIDAColumn + " = id AND " +
dataModel.getUserIDColumn() +
+ " WHERE " + itemIDAColumn + " = " + dataModel.getItemIDColumn() + "
AND " + dataModel.getUserIDColumn() +
"=?) possible_item_ids WHERE id NOT IN (SELECT " +
dataModel.getItemIDColumn() + " FROM " + dataModel.getPreferenceTable() +
" WHERE " + dataModel.getUserIDColumn() + "=?)",
// deleteDiffsSQL
