TBS hasn't changed its behavior on this point.
And it cannot do better because TBS cannot manage SQL statements. It can only pass them to the Database server.
To understand why, look at the following example.
Imagine the MySQL stored procedure:
CREATE PROCEDURE p_display (OUT asked INT)
BEGIN
SELECT * FROM t_books WHERE id=asked;
END
|
With TBS, there is no problem to use the stored procedure:
$TBS->MergeBlock('blk',$conn,'CALL p_display');
But TBS is simply unable to apply an LIMIT clause on this SQL statement.
This is because the statement doesn't support LIMIT. And they are others MySQL statments that doesn't support LIMIT neither. And the problem is the same for other Databases types. It would be too complicated to make a SQL analyzis that could apply a LIMIT statement.