41
41
SET @@session.max_join_size=8;
42
42
## Since total joins are more than max_join_size value so error will occur ##
43
43
SELECT * FROM t1 INNER JOIN t2 ON t1.id = t2.id;
45
45
'#--------------------FN_DYNVARS_079_03-------------------------#'
46
46
## Setting global value of variable ##
47
47
SET @@global.max_join_size=8;