max_join_size error

[ramnujs]

executing this stored procedure will produce an error below:

DROP PROCEDURE IF EXISTS `hotelmgtsystem`.`spSelectRoomEvent`$$
CREATE PROCEDURE `spSelectRoomEvent`(
in pDate date
)
BEGIN
set sql_big_selects=1;
select
if(roomevents.eventtype = 'ENGINEERING JOB',"",concat(Guests.Lastname," ", left(Guests.Firstname,1),".")) as Lastname ,roomevents.`eventdate`,roomevents.roomid ,roomevents.eventtype
from roomevents left join folio on roomevents.eventid = folio.folioid left join guests on guests.accountid = folio.accountid
where roomevents.eventdate >=pDate
And roomevents.eventtype<>'CHECKED OUT' And roomevents.eventtype<>'NO SHOW' and roomevents.eventtype<>'CANCELLED'
order by roomevents.eventid,roomevents.eventdate,roomevents.roomid;
END$$
DELIMITER ;$$

#42000The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay


can someone help me pls?

 

[zekeman]

Did you try the setting of SQL_BIG_SELECTS=1

I've never used this but sounds like somethings to try.