403Webshell
Server IP : 104.21.38.3  /  Your IP : 162.158.108.34
Web Server : Apache
System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64
User : www ( 1000)
PHP Version : 7.4.33
Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : OFF  |  Sudo : ON  |  Pkexec : ON
Directory :  /www/server/mysql/src/mysql-test/suite/opt_trace/t/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /www/server/mysql/src/mysql-test/suite/opt_trace/t/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;

Youez - 2016 - github.com/yon3zu
LinuXploit