[RDBO] limit and offset with one-to-many relationship

[Uwe Voelker]

Hello John,




Also the following warning occurs:



But I'm using only one "one to many" relationship, not more than one.







SELECT DISTINCT products.*
FROM products LEFT JOIN prices ON (products.id = prices.product_id)
WHERE prices.region = 'DE'
LIMIT 1, 1


In a simple query the LIMIT is working, but not in an join.








Good bye,
Uwe

using limit and offset does not work with an one-to-many relationship. The attached script (which requires the rest of the files from my earlier postet example.tgz) returns always the same tupel. WARNING: Fetching sub-objects via more than one "one to many" relationship in a single query may produce many redundant rows, and the query may be slow. If you're sure you want to do this, you can silence this warning by using the "multi_many_ok" parameter Update: Ah, when I remove the empty with_objects arrayref, the warning goes away. I see, this could get complicated/impossible when doing an selection (prices.region = 'DE') and pre-fetching objects (require_objects). But is there a way to do the following in RDBO: RDBO has no problems with the FROM and WHERE line, but I don't know how to achieve the SELECT and LIMIT. Thanks for fixing all the other errors. I finally got a chance to checkout your changes (after the SF cvs was down quite some time). So, the count is already working in the above situation, but I need the limit to (for paging results).

offset-limit.pl
Description: Perl program