[V4MD2] more LIMIT problems

[Heinrich Ruoff]

your question regarding the 1366 is actually entitled
only 23 of the total 1366 records starting with 2 are returned
anyway searching for starting with 1 none of the 2972 records are returned

On 6/14/05, Ruslan Zasukhin <sunshine at public.kherson.ua> wrote:
> On 6/14/05 1:19 PM, "Heinrich Ruoff" <heinrichruoff at gmail.com> wrote:
> 
> > when using LIMIT:
> >
> > "SELECT * FROM tb_bje_artikel WHERE Artikelnummer LIKE '2%' LIMIT 0,23"
> > properly returns 1366 records
> >
> > "SELECT * FROM tb_bje_artikel WHERE Artikelnummer LIKE '1%' LIMIT 0,23"
> > should return 2972 records but returns 0
> >
> > "SELECT * FROM tb_bje_artikel WHERE Artikelnummer LIKE '3%' LIMIT 0,23"
> > should return 48 records but returns 0
> >
> > how is it possible that seaching for "starting with 2" works perfectly
> > but 1 or 3 doesn't work?
> 
> May be send your database to Ivan's email for quick test.
> 
> Actually I wonder, why 1336 is correct, if LIMIT is 23 ?
> 
> 
> --
> Best regards,
> 
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
> 
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
> 
> [I feel the need: the need for speed]
> 
> 
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta
>