This code seems to generate a wrong request
items = RssItem.select(AND(SnapShot.q.day == today,
SnapShot.q.category == catid),
join=(LEFTJOINOn(RssItem, SnapShot,
RssItem.q.id == SnapShot.q.rssitemID),
LEFTJOINOn(RssItem, Rss,
RssItem.q.rssID == Rss.q.id)),
orderBy='-rank')
This is the request generated by this abouve code.
SELECT rss_item.id, rss_item.itemhash, rss_item.link, rss_item.title,
rss_item.summary, rss_item.updated, rss_item.rate, rss_item.rss_id,
rss_item.relations_updated FROM rss_item LEFT JOIN snap_shot ON
((rss_item.id) = (snap_shot.rssitem_id)) rss_item LEFT JOIN rss ON
((rss_item.rss_id) = (rss.id)) WHERE (((snap_shot.day) =
('2007-01-30')) AND ((snap_shot.category) = (1))) ORDER BY rank DESC
And it should be generating this sql request (without "rss_item"
between the two joins)
SELECT rss_item.id, rss_item.itemhash, rss_item.link, rss_item.title,
rss_item.summary, rss_item.updated, rss_item.rate, rss_item.rss_id,
rss_item.relations_updated FROM rss_item LEFT JOIN snap_shot ON
((rss_item.id) = (snap_shot.rssitem_id)) LEFT JOIN rss ON
((rss_item.rss_id) = (rss.id)) WHERE (((snap_shot.day) =
('2007-01-30')) AND ((snap_shot.category) = (1))) ORDER BY rank DESC
Is it a bug or am I doing something wrong ?
-fred-
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
