Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

View File Name : range_with_memory_limit.test

--echo # Bug#17769777 EXCESSIVE MEMORY CONSUMPTION WITH MANY AND / BETWEEN
--echo #              ITEMS
--echo # Bug#17413040 USING MANY WHERE CONDITIONS MAKES RANGE SCAN DISABLED

CREATE TABLE t1 (
a INT,
b INT,
KEY (a)
)ENGINE=INNODB;

INSERT INTO t1 VALUES (0, 0), (1, 1), (2, 2), (3, 3), (4, 4), (5, 5), (6, 6),
(7, 7), (8, 8), (9, 9);

ANALYZE TABLE t1;
SET RANGE_OPTIMIZER_MAX_MEM_SIZE= 100;
EXPLAIN SELECT DISTINCT a FROM t1 WHERE (a, b) IN ((0, 0), (1, 1));
SET RANGE_OPTIMIZER_MAX_MEM_SIZE= DEFAULT;
EXPLAIN SELECT DISTINCT a FROM t1 WHERE (a, b) IN ((0, 0), (1, 1));

DROP TABLE t1;

--source include/force_myisam_default.inc

#Running the entire test suite for range queries to increase the test
#coverage
SET RANGE_OPTIMIZER_MAX_MEM_SIZE= 50;
--source include/range.inc
SET RANGE_OPTIMIZER_MAX_MEM_SIZE= DEFAULT;

--echo # End of test for Bug#17769777 and Bug#17413040