Gecko [ www.jdcpatala.org ]

Name	Size	Permission
bugs_no_prot_all.test	610 B	-rw-r--r--
bugs_no_prot_none.test	1.79 KB	-rw-r--r--
bugs_ps_prot_all.test	607 B	-rw-r--r--
bugs_ps_prot_none.test	718 B	-rw-r--r--
charset.test	2.19 KB	-rw-r--r--
debug.test	1010 B	-rw-r--r--
eq_range_statistics.test	3.28 KB	-rw-r--r--
filesort_pack-master.opt	21 B	-rw-r--r--
filesort_pack.test	14.06 KB	-rw-r--r--
filesort_pq-master.opt	21 B	-rw-r--r--
filesort_pq.test	242 B	-rw-r--r--
fulltext.test	875 B	-rw-r--r--
general2_no_prot.test	271 B	-rw-r--r--
general2_ps_prot.test	268 B	-rw-r--r--
general_no_prot_all-master.opt	21 B	-rw-r--r--
general_no_prot_all.test	638 B	-rw-r--r--
general_no_prot_none-master.op...	21 B	-rw-r--r--
general_no_prot_none.test	749 B	-rw-r--r--
general_ps_prot_all.test	635 B	-rw-r--r--
general_ps_prot_none.test	746 B	-rw-r--r--
range_no_prot.test	1.51 KB	-rw-r--r--
range_ps_prot.test	264 B	-rw-r--r--
security_no_prot.test	202 B	-rw-r--r--
security_ps_prot.test	199 B	-rw-r--r--
subquery_no_prot-master.opt	21 B	-rw-r--r--
subquery_no_prot.test	271 B	-rw-r--r--
subquery_ps_prot.test	268 B	-rw-r--r--
temp_table.test	2.89 KB	-rw-r--r--

Code Editor : bugs_no_prot_none.test

#Start server with MyISAM
--source include/force_myisam_default.inc

--disable_query_log
if (`select locate('semijoin', @@optimizer_switch) > 0`) 
{
  set optimizer_switch='semijoin=off';
}
if (`select locate('materialization', @@optimizer_switch) > 0`) 
{
  set optimizer_switch='materialization=off';
}
if (`select locate('index_condition_pushdown', @@optimizer_switch) > 0`) 
{
  set optimizer_switch='index_condition_pushdown=off';
}
if (`select locate('mrr', @@optimizer_switch) > 0`) 
{
  set optimizer_switch='mrr=off';
}
--enable_query_log

if (`SELECT $PS_PROTOCOL + $SP_PROTOCOL + $CURSOR_PROTOCOL
            + $VIEW_PROTOCOL > 0`)
{
   --skip Need normal protocol
}

--source suite/opt_trace/include/bugs.inc

--echo #
--echo # BUG#18365641: SERVER EXIT IN TRACE OF QUICK SELECT
--echo #

CREATE TABLE t1 (  
  pk INT(11),
  i1 INT(11),
  vc VARCHAR(10),  
  vc2 VARCHAR(10),
  PRIMARY KEY (pk), 
  KEY i1 (i1),
  KEY vc (vc)
) ENGINE=InnoDB;

INSERT INTO t1 VALUES (1, -1281753088,'p','r');
INSERT INTO t1 VALUES (4, NULL,'a','i');
INSERT INTO t1 VALUES (5, NULL,'lhtrovamzq','t');
INSERT INTO t1 VALUES (6, 3,'d','RZDUH');
INSERT INTO t1 VALUES (7, 951910400,'z','it\'s');
INSERT INTO t1 VALUES (8, 1067319296,'get','WZJHD');
INSERT INTO t1 VALUES (9, -1666187264,'zqrdcenchy','me');
INSERT INTO t1 VALUES (10, NULL,'what','there');

CREATE TABLE t2 (
  vc VARCHAR(10),
  pk INT(11),
  PRIMARY KEY (pk),
  KEY vc2 (vc)
);

INSERT INTO t2 VALUES ('ukkoeiwsgp',1);

# Opt trace needs to be 'on' to reproduce, but the 
# trace itself is not interesting

EXPLAIN
SELECT *
FROM t1 LEFT JOIN t2
     ON t1.i1 < t2.vc
WHERE t1.vc IN ( 'AVZPQ' )
      OR t1.i1 IS NULL AND t1.pk >= 9;

SELECT *
FROM t1 LEFT JOIN t2
     ON t1.i1 < t2.vc
WHERE t1.vc IN ( 'AVZPQ' )
      OR t1.i1 IS NULL AND t1.pk >= 9;

DROP TABLE t1, t2;

${this.title}

Code Editor : bugs_no_prot_none.test