[V4MD2] SELECT LIMIT

[Ivan Smahin]

Hello Heinrich,

Monday, June 13, 2005, 1:04:12 PM, you wrote:

HR> after update from 2.0.3 to 2.0.4 fc5
HR> the first recordCount is reported correctly
HR> ("SELECT * FROM tb_bje_artikel LIMIT 0,4")

HR> but "SELECT * FROM tb_bje_artikel LIMIT 8,12"
HR> returns an recordCount of 12 instead of 4

This is wrong.
"... LIMIT 8,12" means - 12 records starting after 8 position (9).

So we have 12 records

Try it - you can easy see affecyed rows
SELECT RecID, * FROM tb_bje_artikel LIMIT 8,12


-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua