1** Setup ** 2SET @session_max_join_size = @@SESSION.sql_max_join_size; 3SET @global_max_join_size = @@GLOBAL.sql_max_join_size; 4SET @session_sql_big_selects = @@SESSION.sql_big_selects; 5CREATE TEMPORARY TABLE t1(a varchar(20) not null, b varchar(20)); 6CREATE TEMPORARY TABLE t2(a varchar(20) null, b varchar(20)); 7INSERT INTO t1 VALUES('aa','bb'); 8INSERT INTO t1 VALUES('aa1','bb'); 9INSERT INTO t1 VALUES('aa2','bb'); 10INSERT INTO t1 VALUES('aa3','bb'); 11INSERT INTO t1 VALUES('aa4','bb'); 12INSERT INTO t2 VALUES('aa','bb'); 13INSERT INTO t2 VALUES('aa1','bb'); 14INSERT INTO t2 VALUES('aa2','bb'); 15INSERT INTO t2 VALUES('aa3','bb'); 16INSERT INTO t2 VALUES('aa4','bb'); 17'#--------------------FN_DYNVARS_161_01-------------------------#' 18SET SESSION sql_max_join_size=9; 19Warnings: 20Warning 1287 '@@sql_max_join_size' is deprecated and will be removed in a future release. Please use '@@max_join_size' instead 21SELECT * FROM t1 INNER JOIN t2 ON t1.a = t2.a; 22ERROR 42000: 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 23Expected error The SELECT would examine more than MAX_JOIN_SIZE rows. 24'#--------------------FN_DYNVARS_161_02-------------------------#' 25SET SESSION SQL_BIG_SELECTS = 1; 26SELECT * FROM t1 INNER JOIN t2 ON t1.a = t2.a; 27a b a b 28aa bb aa bb 29aa1 bb aa1 bb 30aa2 bb aa2 bb 31aa3 bb aa3 bb 32aa4 bb aa4 bb 33This should work 34SET SESSION sql_max_join_size=DEFAULT; 35Warnings: 36Warning 1287 '@@sql_max_join_size' is deprecated and will be removed in a future release. Please use '@@max_join_size' instead 37DELETE FROM t2 WHERE a = 'aa4'; 38SELECT * FROM t1 INNER JOIN t2 ON t1.a = t2.a; 39a b a b 40aa bb aa bb 41aa1 bb aa1 bb 42aa2 bb aa2 bb 43aa3 bb aa3 bb 44This should work 45'#----------------------------FN_DYNVARS_136_05-------------------------#' 46SET GLOBAL sql_max_join_size = 4; 47Warnings: 48Warning 1287 '@@sql_max_join_size' is deprecated and will be removed in a future release. Please use '@@max_join_size' instead 49** Connecting con_int1 using root ** 50** Connection con_int1 ** 51SELECT @@SESSION.sql_max_join_size; 52@@SESSION.sql_max_join_size 534 544 Expected 55SET SESSION sql_max_join_size = 2; 56Warnings: 57Warning 1287 '@@sql_max_join_size' is deprecated and will be removed in a future release. Please use '@@max_join_size' instead 58** Connecting con_int2 using root ** 59** Connection con_int2 ** 60SELECT @@SESSION.sql_max_join_size; 61@@SESSION.sql_max_join_size 624 634 Expected 64SET SESSION sql_max_join_size = 10; 65Warnings: 66Warning 1287 '@@sql_max_join_size' is deprecated and will be removed in a future release. Please use '@@max_join_size' instead 67** Connection con_int2 ** 68SELECT @@SESSION.sql_max_join_size; 69@@SESSION.sql_max_join_size 7010 7110 Expected 72** Connection con_int1 ** 73SELECT @@SESSION.sql_max_join_size; 74@@SESSION.sql_max_join_size 752 762 Expected 77SELECT @@GLOBAL.sql_max_join_size; 78@@GLOBAL.sql_max_join_size 794 804 Expected 81** Connection default ** 82Disconnecting Connections con_int1, con_int2 83SET @@SESSION.sql_max_join_size = @session_max_join_size; 84Warnings: 85Warning 1287 '@@sql_max_join_size' is deprecated and will be removed in a future release. Please use '@@max_join_size' instead 86SET @@GLOBAL.sql_max_join_size = @global_max_join_size ; 87Warnings: 88Warning 1287 '@@sql_max_join_size' is deprecated and will be removed in a future release. Please use '@@max_join_size' instead 89SET @@SESSION.sql_big_selects = @session_sql_big_selects; 90DROP TABLE t1; 91DROP TABLE t2; 92