| Server IP : 112.74.42.100 / Your IP : 216.73.216.142 Web Server : nginx/1.20.2 System : Linux iZwz96lx4pjqiy84w4hni7Z 5.10.134-17.3.al8.x86_64 #1 SMP Thu Oct 31 14:29:57 CST 2024 x86_64 User : www ( 1000) PHP Version : 8.0.26 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 : ON | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/mysql-test/t/ |
Upload File : |
# This test checks various optimizer-related functions using # the debug-sync facility. --source include/have_debug_sync.inc --echo --echo BUG#11763382 Assertion 'inited==INDEX' on SELECT MAX(...) --echo CREATE TABLE t(i INT NOT NULL PRIMARY KEY, f INT) ENGINE = InnoDB; INSERT INTO t VALUES (1,1),(2,2); BEGIN; UPDATE t SET f=100 WHERE i=2; --connect (con1,localhost,root,,) set optimizer_switch='semijoin=off,subquery_materialization_cost_based=off'; SET DEBUG_SYNC='before_index_end_in_subselect WAIT_FOR callit'; --send SELECT f FROM t WHERE i IN ( SELECT i FROM t ) --connection default let $show_statement= SHOW PROCESSLIST; let $field= State; let $condition= = 'debug sync point: before_index_end_in_subselect'; --source include/wait_show_condition.inc --connect (con2,localhost,root,,) --send SELECT MAX(i) FROM t FOR UPDATE --connect (con3,localhost,root,,) --send SELECT MAX(i) FROM t FOR UPDATE --connection default let $wait_condition= SELECT COUNT(*) = 2 FROM information_schema.processlist WHERE state = 'Optimizing' and info = 'SELECT MAX(i) FROM t FOR UPDATE'; --source include/wait_condition.inc SET DEBUG_SYNC='now SIGNAL callit'; COMMIT; --connection con1 --reap SET DEBUG_SYNC='RESET'; --connection con2 --reap --connection con3 --reap --connection default DROP TABLE t; --disconnect con1 --disconnect con2 --disconnect con3 --echo # End of BUG#56080