Author: srowen
Date: Wed Dec 3 10:04:59 2008
New Revision: 722989
URL: http://svn.apache.org/viewvc?rev=722989&view=rev
Log:
Fix MAHOUT-101: mismatch between "AS" alias name and references in
getRecommandableItemsSQL
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=722989&r1=722988&r2=722989&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:04:59 2008
@@ -104,9 +104,9 @@
// getRecommendableItemsSQL
"SELECT id FROM " +
"(SELECT " + itemIDAColumn + " AS id FROM " + diffsTable + ", " +
dataModel.getPreferenceTable() +
- " WHERE " + itemIDBColumn + " = item_id AND " +
dataModel.getUserIDColumn() + "=? UNION DISTINCT" +
+ " WHERE " + itemIDBColumn + " = id AND " +
dataModel.getUserIDColumn() + "=? UNION DISTINCT" +
" SELECT " + itemIDBColumn + " AS id FROM " + diffsTable + ", " +
dataModel.getPreferenceTable() +
- " WHERE " + itemIDAColumn + " = item_id AND " +
dataModel.getUserIDColumn() +
+ " WHERE " + itemIDAColumn + " = id AND " +
dataModel.getUserIDColumn() +
"=?) possible_item_ids WHERE id NOT IN (SELECT " +
dataModel.getItemIDColumn() + " FROM " + dataModel.getPreferenceTable() +
" WHERE " + dataModel.getUserIDColumn() + "=?)",
// deleteDiffsSQL
