Try: select * from table LIMIT 100;
> Hi
>
> We upgraded our system from 6.4 to the new 6.5 version. The set
> query_limit function is not working
> anymore in 6.5.
>
> db => set query_limit to '100';
> SET VARIABLE
> db => select * from table;
>
> statement is returning all records from the table. What's wrong here?
>
> Herbie
>
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~
> Herbert Liechti E-Mail:
> Herbert.Liechti@thinx.ch
> ThinX networked business services Stahlrain 10, CH-5200
> Brugg
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~
>
>
>