�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2FSRC%2F'>SRC</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2F'>mariadb-11.7.2</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2F'>mysql-test</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fmain%2F'>main</a>/</p><hr><h3>✏️ Editing: fast_prefix_index_fetch_innodb.test</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>-- source include/have_innodb.inc
--disable_service_connection

SET @save_innodb_stats_persistent=@@GLOBAL.innodb_stats_persistent;
SET GLOBAL innodb_stats_persistent = OFF;

--echo # Create a table with a large varchar field that we index the prefix
--echo # of and ensure we only trigger cluster lookups when we expect it.
create table prefixinno (
       id int not null,
       fake_id int not null,
       bigfield varchar(4096),
       primary key(id),
       index bigfield_idx (bigfield(32)),
       index fake_id_bigfield_prefix (fake_id, bigfield(32))
) engine=innodb;

insert into prefixinno values (1, 1001, repeat(&#039;a&#039;, 1)),
                              (8, 1008, repeat(&#039;b&#039;, 8)),
                              (24, 1024, repeat(&#039;c&#039;, 24)),
                              (31, 1031, repeat(&#039;d&#039;, 31)),
                              (32, 1032, repeat(&#039;x&#039;, 32)),
                              (33, 1033, repeat(&#039;y&#039;, 33)),
                              (128, 1128, repeat(&#039;z&#039;, 128));

select * from prefixinno;

--echo # Eligible for optimization.
select id, bigfield from prefixinno where bigfield = repeat(&#039;d&#039;, 31);

--echo # Eligible for optimization, access via fake_id only.
select id, bigfield from prefixinno where fake_id = 1031;

--echo # Not eligible for optimization, access via fake_id of big row.
select id, bigfield from prefixinno where fake_id = 1033;

--echo # Not eligible for optimization.
select id, bigfield from prefixinno where bigfield = repeat(&#039;x&#039;, 32);
select id, bigfield from prefixinno where bigfield = repeat(&#039;y&#039;, 33);

select id, bigfield from prefixinno where bigfield = repeat(&#039;b&#039;, 8);
select id, bigfield from prefixinno where bigfield = repeat(&#039;c&#039;, 24);
select id, bigfield from prefixinno where bigfield = repeat(&#039;z&#039;, 128);
select id, bigfield from prefixinno where fake_id = 1033;

drop table prefixinno;

--echo # Multi-byte handling case

SET NAMES utf8mb4;
CREATE TABLE t1(
	f1 varchar(10) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_BIN,
	INDEX (f1(3)))ENGINE=INNODB;

INSERT INTO t1 VALUES(&#039;a&#039;), (&#039;cccc&#039;), (&#039;až&#039;), (&#039;cčc&#039;), (&#039;ggᵷg&#039;), (&#039;¢¢&#039;);
INSERT INTO t1 VALUES(&#039;தமிழ்&#039;), (&#039;🐱🌑&#039;), (&#039;🌒&#039;), (&#039;🌑&#039;);
INSERT INTO t1 VALUES(&#039;😊me&#039;), (&#039;eu€&#039;), (&#039;ls¢&#039;);

--echo # Eligible - record length is shorter than prefix
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 = &#039;a&#039;;

--echo # Not eligible - record length longer than prefix length
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 like &#039;c%&#039;;

--echo # Eligible - record length shorter than prefix length
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 = &#039;až&#039;;

--echo # Not eligible - record length longer than prefix length
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 = &#039;தமிழ்&#039;;

--echo # Not eligible - record length longer than prefix length
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 like &#039;ggᵷ%&#039;;

--echo # Not eligible - record length longer than prefix length
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 like &#039;😊%&#039;;

--echo # Not eligible - record length longer than prefix length
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 = &#039;ls¢&#039;;

--echo # Eligible - record length shorter than prefix length
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 like &#039;¢¢%&#039;;

--echo # Eligible - record length shorter than prefix length
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 like &#039;🐱🌑%&#039;;

--echo # Not eligible - record length longer than prefix length
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 like &#039;🌑%&#039;;

--echo # Not eligible - record length longer than prefix length
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 like &#039;🌒%&#039;;

DROP TABLE t1;

--echo # Multi-byte with minimum character length &gt; 1 bytes

CREATE TABLE t1(
	f1 varchar(10) CHARACTER SET UTF16 COLLATE UTF16_BIN,
	INDEX (f1(3)))ENGINE=INNODB;

INSERT INTO t1 VALUES(&#039;a&#039;), (&#039;cccc&#039;), (&#039;až&#039;), (&#039;cčc&#039;), (&#039;ggᵷg&#039;), (&#039;¢¢&#039;);
INSERT INTO t1 VALUES(&#039;தமிழ்&#039;), (&#039;🐱🌑&#039;), (&#039;🌒&#039;), (&#039;🌑&#039;);
INSERT INTO t1 VALUES(&#039;😊me&#039;), (&#039;eu€&#039;), (&#039;ls¢&#039;);

--echo # Eligible - record length is shorter than prefix
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 = &#039;a&#039;;

--echo # Not eligible - record length longer than prefix length
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 like &#039;c%&#039;;

--echo # Eligible - record length shorter than prefix length
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 = &#039;až&#039;;

--echo # Not eligible - record length longer than prefix length
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 = &#039;தமிழ்&#039;;

--echo # Not eligible - record length longer than prefix length
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 like &#039;ggᵷ%&#039;;

--echo # Not eligible - record length longer than prefix length
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 like &#039;😊%&#039;;

--echo # Not eligible - record length longer than prefix length
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 = &#039;ls¢&#039;;

--echo # Eligible - record length shorter than prefix length
SELECT f1 FROM t1 FORCE INDEX(`f1`) WHERE f1 like &#039;¢¢%&#039;;

--echo # Eligible - record length shorter than prefix length
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 like &#039;🐱🌑%&#039;;

--echo # Eligible - record length is shorter than prefix length
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 like &#039;🌑%&#039;;

--echo # Eligible - record length is shorter than prefix length
SELECT f1 FROM t1 FORCE INDEX (`f1`) WHERE f1 like &#039;🌒%&#039;;

DROP TABLE t1;

CREATE TABLE t1(
	col1 INT,
	col2 BLOB DEFAULT NULL,
	INDEX `idx1`(col2(4), col1))ENGINE=INNODB;
INSERT INTO t1 VALUES (2, &#039;test&#039;), (3, repeat(&#039;test1&#039;, 2000));
INSERT INTO t1(col1) VALUES(1);

--echo # Eligible - record length is shorter than prefix length
SELECT col1 FROM t1 FORCE INDEX (`idx1`) WHERE col2 is NULL;

--echo # Not eligible - record length longer than prefix index
SELECT col1 FROM t1 FORCE INDEX (`idx1`) WHERE col2 like &#039;test1%&#039;;

DROP TABLE t1;

--echo #
--echo # MDEV-20464 Division by 0 in row_search_with_covering_prefix()
--echo #
CREATE TABLE t1 (f1 INT, f2 INT AS (f1), f3 INT AS (f1), f4 INT AS (f1),
                 KEY (f1,f2,f3)) ENGINE=InnoDB;
INSERT INTO t1 (f1) VALUES (NULL),(0);
SELECT f1, MAX(f3), COUNT(f4) FROM t1 GROUP BY f1;
DROP TABLE t1;

--echo #
--echo # MDEV-23600 Division by 0 in row_search_with_covering_prefix()
--echo #
CREATE TABLE t(c POINT UNIQUE) ENGINE=InnoDB;
INSERT t SET c=POINT(1,1);
SELECT * FROM t WHERE c &gt; (SELECT MAX(c) FROM t);
DROP TABLE t;

--echo #
--echo # MDEV-12486 Wrong results with innodb_prefix_index_cluster_optimization
--echo #
CREATE TABLE wp_blogs (
  blog_id bigint(20) NOT NULL auto_increment,
  site_id bigint(20) NOT NULL default &#039;0&#039;,
  domain varchar(200) NOT NULL default &#039;&#039;,
  path varchar(100) NOT NULL default &#039;&#039;,
  registered datetime NOT NULL default &#039;0000-00-00 00:00:00&#039;,
  last_updated datetime NOT NULL default &#039;0000-00-00 00:00:00&#039;,
  public tinyint(2) NOT NULL default &#039;1&#039;,
  archived tinyint(2) NOT NULL default &#039;0&#039;,
  mature tinyint(2) NOT NULL default &#039;0&#039;,
  spam tinyint(2) NOT NULL default &#039;0&#039;,
  deleted tinyint(2) NOT NULL default &#039;0&#039;,
  lang_id int(11) NOT NULL default &#039;0&#039;,
  PRIMARY KEY  (blog_id),
  KEY domain (domain(50),path(5)),
  KEY lang_id (lang_id)
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

INSERT INTO wp_blogs (domain, path) VALUES
(&#039;domain.no&#039;, &#039;/fondsinvesteringer/&#039;), (&#039;domain.no&#039;, &#039;/&#039;),
(&#039;foo&#039;, &#039;bar&#039;), (&#039;bar&#039;, &#039;foo&#039;), (&#039;foo&#039;, &#039;foo&#039;), (&#039;bar&#039;, &#039;bar&#039;),
(&#039;foo&#039;, &#039;foobar&#039;), (&#039;bar&#039;, &#039;foobar&#039;), (&#039;foobar&#039;, &#039;foobar&#039;);

SELECT blog_id FROM wp_blogs WHERE domain IN (&#039;domain.no&#039;)
AND path IN ( &#039;/fondsinvesteringer/&#039;, &#039;/&#039; );

DROP TABLE wp_blogs;

SET GLOBAL innodb_stats_persistent = @save_innodb_stats_persistent;
--enable_service_connection
</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fmain'>🔙 Back</a></p>