Bug #165 SET OPTION SQL_BIG_SELECTS=1 not working

• Submitted: 19 Mar 2003 5:30
• Modified: 19 Mar 2003 7:27
• Reporter: [ name withheld ]
• Status: Closed
• Category: MySQL Server: MyISAM storage engine
• Severity: S2 (Serious)
• Version: 4.0.10-4.0.12
• OS: Any (any)
• CPU Architecture: Any

[19 Mar 2003 5:30] [ name withheld ]

Description:
we have an issue with mysql-4.0.10 to 12 (did not try earlier versions) and big_selects.

The sql_big_selects option seems no to affect the work of the mysql-daemon.

The tables are MyISAM, we used your precompiled rpms.

If the max_join_size is set at startup it does not work either.

How to repeat:
This is a snippet from a mysql-session:

mysql> SET max_join_size=100;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT * FROM ringbuf;
ERROR 1104: The SELECT would examine too many records and probably take a very long time. Check your WHERE and use SET OPTION SQL_BIG_SELECTS=1 if the SELECT is ok
mysql> SET OPTION SQL_BIG_SELECTS=1;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT * FROM ringbuf;
ERROR 1104: The SELECT would examine too many records and probably take a very long time. Check your WHERE and use SET OPTION SQL_BIG_SELECTS=1 if the SELECT is ok
mysql>

[19 Mar 2003 7:27] MySQL Verification Team

==== sql/set_var.cc 1.24 vs edited =====
*** /tmp/set_var.cc-1.24-32215  Wed Mar  5 19:43:53 2003
--- edited/sql/set_var.cc       Wed Mar 19 17:09:17 2003
***************
*** 239,245 ****
  #endif
  static sys_var_thd_bit        sys_big_selects("sql_big_selects",
                                        set_option_bit,
!                                       OPTION_BIG_TABLES);
  static sys_var_thd_bit        sys_log_off("sql_log_off",
                                    set_option_bit,
                                    OPTION_LOG_OFF);
--- 239,245 ----
  #endif
  static sys_var_thd_bit        sys_big_selects("sql_big_selects",
                                        set_option_bit,
!                                       OPTION_BIG_SELECTS);
  static sys_var_thd_bit        sys_log_off("sql_log_off",
                                    set_option_bit,
                                    OPTION_LOG_OFF);