[TYPO3-mvc] QueryResult object has issues with offsets and "count" method ?

[Franz Koch]

Hey,

> True, I stumbled upon this too and fixed it in my working copy
> (ordering- and group constraints can be filtered out too).
> But are you sure, that omitting the limit constraint fixes this for you?

yep. As soon as the limit isn't set, everything is fine. I can keep the 
offset and orderings and still get a sql result, but as soon as there is 
a limit in the query, the query result is empty (not a single row is 
returned, but also no SQL error or anything else).

> As long as there is no grouping, COUNT(*) always returns one row anyways..

In my case it doesn't. As soon as there is a limit set, there is NO row 
returned.

> Can you try if it works if you add
> if (isset($statementParts['orderings'])) {
> unset($statementParts['orderings']);
> }
> above the line
> $statement = $this->buildQuery($statementParts, $parameters);

no, it doesn't work - only removing the limit is working.


-- 
kind regards,
Franz Koch