EXPLAIN ANALYZE breaks with a recommendation query. To reproduce the problem, first load the MovieLens dataset and then perform the following queries:
CREATE RECOMMENDER MovieRec ON ml_ratings USERS FROM userid ITEMS FROM itemid EVENTS FROM ratingval USING itemcoscf;
Then execute the following:
EXPLAIN ANALYZE SELECT * FROM ml_ratings RECOMMEND itemid TO userid ON ratingval USING itemcoscf WHERE userid = 1 ORDER BY ratingval LIMIT 10;
The back-end ends unexpectedly and returns a segmentation fault.
Note that EXPLAIN alone works just fine.
EXPLAIN ANALYZE breaks with a recommendation query. To reproduce the problem, first load the MovieLens dataset and then perform the following queries:
CREATE RECOMMENDER MovieRec ON ml_ratings USERS FROM userid ITEMS FROM itemid EVENTS FROM ratingval USING itemcoscf;
Then execute the following:
EXPLAIN ANALYZE SELECT * FROM ml_ratings RECOMMEND itemid TO userid ON ratingval USING itemcoscf WHERE userid = 1 ORDER BY ratingval LIMIT 10;
The back-end ends unexpectedly and returns a segmentation fault.
Note that EXPLAIN alone works just fine.