diff options
author | Monty <monty@mariadb.org> | 2021-10-06 12:34:54 +0300 |
---|---|---|
committer | Sergei Petrunia <sergey@mariadb.com> | 2023-01-30 15:24:15 +0200 |
commit | 7d0bef6cd7be6a2764be05071b4ea78729698f6b (patch) | |
tree | f406e8ee1ac8c50a5750734d4b440ecfea48fc4d /mysql-test/suite/sys_vars/r/max_join_size_func.result | |
parent | fc0c157aaa0b1603a321890c6c43b4b6b5e3b2e3 (diff) | |
download | mariadb-git-7d0bef6cd7be6a2764be05071b4ea78729698f6b.tar.gz |
Fixed bug in SQL_SELECT_LIMITbb-11.0-jan23-rebase-try2
We where comparing costs when we should be comparing number of rows
that will be examined
Diffstat (limited to 'mysql-test/suite/sys_vars/r/max_join_size_func.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/max_join_size_func.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/suite/sys_vars/r/max_join_size_func.result b/mysql-test/suite/sys_vars/r/max_join_size_func.result index cacc918ea02..d46b89d1f44 100644 --- a/mysql-test/suite/sys_vars/r/max_join_size_func.result +++ b/mysql-test/suite/sys_vars/r/max_join_size_func.result @@ -39,19 +39,19 @@ id name id name connect test_con1, localhost, root,,; connection test_con1; ## Setting value of max_join_size ## -SET @@session.max_join_size=8; +SET @@session.max_join_size=4; ## Since total joins are more than max_join_size value so error will occur ## SELECT * FROM t1 INNER JOIN t2 ON t1.id = t2.id; ERROR 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 '#--------------------FN_DYNVARS_079_03-------------------------#' ## Setting global value of variable ## -SET @@global.max_join_size=8; +SET @@global.max_join_size=4; connect test_con2, localhost, root,,; connection test_con2; ## Verifying value of max_join_size ## SELECT @@global.max_join_size; @@global.max_join_size -8 +4 ## Since total joins are more than max_join_size value so error will occur ## SELECT * FROM t1 INNER JOIN t2 ON t1.id = t2.id; ERROR 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 |