LIMIT first offset 0 or 1 ? and other LIMIT problems

["Angel Behar" <abehar@xxxxxxxxxxxxxxxxx>]

Hi, I'm running mysql 3.23.16-alpha-log w/o a problem, but now I'm confused
about the LIMIT feature.  Must I use 0 as the first offset or use 1, the
following query ruturns five rows that match the criteria :

mysql> SELECT codigo from muebles where cve_dpto='1' AND cve_clase = '10'
AND cve_familia='02' AND agotado='D' LIMIT 1,10;
+--------+
| codigo |
+--------+
| 181129 |
| 181145 |
| 181161 |
| 181201 |
| 181463 |
+--------+
5 rows in set (0.02 sec)

The exactly same query , but with offset 0 or without an offset returns 6
rows :

mysql> SELECT codigo from muebles where cve_dpto='1' AND cve_clase = '10'
AND cve_familia='02' AND agotado='D' LIMIT 0,10;
+--------+
| codigo |
+--------+
| 181031 |
| 181129 |
| 181145 |
| 181161 |
| 181201 |
| 181463 |
+--------+
6 rows in set (0.02 sec)

So, I have the same problem when only match 1, 2 or 3 rows and for example
if I run another query wich matched 398 rows, the limit clause only works
with the first 15 offsets, lets say :
SELECT * from ropa where cve_depto='3' AND cve_clase ='03' AND
cve_familia='001' GROUP BY codigo LIMIT 160,10 returns 0 rows.

If any one can give an advice, I'll appreciate.

Thanks in advance.




-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php"; before
posting. To request this thread, e-mail mysql-thread60396@xxxxxxxxxxxxxxx

To unsubscribe, send a message to:
    <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php