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 : filter_single_col_idx_big.test

--disable_warnings

CREATE TABLE t1(
  col1_idx INT DEFAULT NULL,
  col2_idx INT DEFAULT NULL,
  col3 INT DEFAULT NULL,
  col4 INT NOT NULL,
  vc VARCHAR(20),
  vc_ft VARCHAR(20),
  KEY(col1_idx),
  KEY(col2_idx),
  FULLTEXT(vc_ft)
) ENGINE=myisam;

CREATE TABLE t2(
  col1_idx INT DEFAULT NULL,
  col2_idx INT DEFAULT NULL,
  col3 INT DEFAULT NULL,
  KEY(col1_idx),
  KEY(col2_idx)
) ENGINE=myisam;

insert into t1 values (1,1,1,1,'america', 'america'),(2,2,2,2,'england','england');

let $iteration= 0;
let $i= 2;
while ($iteration < 6)
{
  eval insert into t1 select col1_idx+$i, col2_idx+$i, col3+$i, col4+$i, vc, vc_ft from t1;
  let $i=$i*2;  
  inc $iteration;
}

insert into t1 select col1_idx, col2_idx, col3, col4, 'america', 'america' from t1;
insert into t1 select col1_idx, col2_idx, col3, col4, 'england america', 'england america' from t1;
insert ignore into t1 select col1_idx, col2_idx, col3, col4, 'germany england america', 'germany england america' from t1;

insert into t1 select col1_idx, col2_idx, col3, col4, 'norway sweden', 'norway sweden' from t1 limit 5;

insert into t2 select col1_idx,col2_idx,col3 from t1;

analyze table t1;
analyze table t2;

--source include/cond_filter_queries.inc
--enable_warnings

DROP TABLE t1,t2;

--echo #
--echo # Bug#18446462: ASSERT `ROWS >= 0.0' AT
--echo #               COST_MODEL_SERVER::ROW_EVALUATE_COST IN 
--echo #               OPT_COSTMODEL.H
--echo #

# 10 rows
create table t10 (pk int primary key, i int);
insert into t10 values (1,1);
insert into t10 select pk+1, i from t10;
insert into t10 select pk+2, i from t10;
insert into t10 select pk+4, i from t10;
insert into t10 select pk+8, i from t10 limit 2;

# 19 rows
create table t19 (pk int primary key, i int);
insert into t19 values (1,1);
insert into t19 select pk+1, i from t19;
insert into t19 select pk+2, i from t19;
insert into t19 select pk+4, i from t19;
insert into t19 select pk+8, i from t19;
insert into t19 select pk+16, i from t19 limit 3;

# 25 rows
create table t25 (pk int primary key, i int);
insert into t25 values (1,1);
insert into t25 select pk+1, i from t25;
insert into t25 select pk+2, i from t25;
insert into t25 select pk+4, i from t25;
insert into t25 select pk+8, i from t25;
insert into t25 select pk+16, i from t25 limit 9;

set @optimizer_switch_saved=@@optimizer_switch;
set optimizer_switch='derived_merge=off';
--disable_query_log
--disable_result_log
ANALYZE TABLE t10, t19, t25;
--enable_result_log
--enable_query_log

EXPLAIN SELECT * FROM (
SELECT t10_1.*
FROM t10 AS t10_1,
     t10 AS t10_2,
     t10 AS t10_3,
     t10 AS t10_4,
     t10 AS t10_5,
     t10 AS t10_6,
     t25 AS t25_1, 
     t25 AS t25_2,
     t19
) AS d;

set optimizer_switch=@optimizer_switch_saved;

DROP TABLE t10;
DROP TABLE t19;
DROP TABLE t25;