Thread

RE: [GENERAL] urgent: problems with query_limit

Jackson, DeJuan <djackson@cpsgroup.com> — 1999-06-30T22:17:58Z

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
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ~
> 
> 
>