On Tuesday 11 March 2003 16:23, zby at post dot cz wrote:
> /usr/sbin/mysqld-max --version
> /usr/sbin/mysqld-max Ver 4.0.11-gamma-Max for pc-linux on i686
> Downloaded and installed:
> MySQL-client-4.0.11-0
> MySQL-shared-4.0.11-0
> MySQL-Max-4.0.11-0
> MySQL-devel-4.0.11-0
> MySQL-server-4.0.11-0
> MySQL-bench-4.0.11-0
> ...started, loaded, running... OK (using innodb)
> *************************************************
> I login to 4.0.11 server from localhost and do:
> select count(*) from A; returned 22662
> select * from A; returned 1000 rows
> set sql_select_limit=5000; OK
> select * from A; returned 5000 rows;
> Then I quit, login again, do the same select right after login
> with no prior changes to the client environtment and: select *
> from A; returns 1000 rows;
>
> I login to 3.23.54a server from localhost and do:
> select count(*) from A; returned 22662
> select * from A; returned 22662 rows
> **************************************************
> As to the Reference Manual out of the rpm package of 4.0.11
> version, SQL_SELECT_LIMIT is a ssesion variable and should be
> initialy (after login) set to 'unlimited'. Why, after login from
> localhost is this variable set to 1000?
> Did I miss something in this reference or is this an error?
> Or I simply misconfigured my server
What is the output of
SELECT @@global.sql_select_limit;
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
