Hallo, what I have is this: /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 Thank you for a note back. Zbynek ZDRAZIL -- Ziskejte kvalitu, kterou si zasluhujete. Za minimalni mesicni poplatek vam nabizime Antivir, Antispam nebo dalsi kapacitu pro vas Mailbox. Vice na: http://sluzby.volny.cz/product/postpaid/ --------------------------------------------------------------------- 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