List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:February 28 2014 11:27am
Subject:Re: how to set "SET SQL_BIG_SELECTS=1" ?
View as plain text  
Am 28.02.2014 12:17, schrieb Madan Thapa:

> After upgrading from mysql 5.0 to mysql 5.1,  i am getting the follwing
> error:
> 
> how to set "SET SQL_BIG_SELECTS=1"?

just type it before your query in question?
as you can see below if you try such things
and they are not supported or you have a typo
you get a crear error, otherwise OK

MariaDB [(none)]> SET SQL_BIG_SELECTS=1;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> SET SQL_BIG_SELEtCTS=1;
ERROR 1193 (HY000): Unknown system variable 'SQL_BIG_SELEtCTS'

> *Warning*: The SELECT would examine more than MAX_JOIN_SIZE rows; check
> your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the
> SELECT is okay query: drupal_get_filename /* Guest : drupal_get_filename */
> SELECT filename FROM system WHERE name = 'user' AND type = 'module' in
> */home/User/public_html/includes/database.mysql.inc* on line *136*


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
how to set "SET SQL_BIG_SELECTS=1" ?Madan Thapa28 Feb 2014
  • Re: how to set "SET SQL_BIG_SELECTS=1" ?Reindl Harald28 Feb 2014
    • Re: how to set "SET SQL_BIG_SELECTS=1" ?Madan Thapa28 Feb 2014
      • Re: how to set "SET SQL_BIG_SELECTS=1" ?Reindl Harald28 Feb 2014