403Webshell
Server IP : 45.40.142.9  /  Your IP : 216.73.216.250
Web Server : Apache
System : Linux s45-40-142-9.secureserver.net 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64
User : bayspec ( 506)
PHP Version : 5.6.40
Disable Function : NONE
MySQL : ON  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : ON  |  Pkexec : ON
Directory :  /usr/share/mysql-test/t/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /usr/share/mysql-test/t/synchronization.test
# Save the initial number of concurrent sessions
--source include/count_sessions.inc

#
# Test for Bug#2385 CREATE TABLE LIKE lacks locking on source and destination
#                   table
#

--disable_warnings
DROP TABLE IF EXISTS t1,t2;
--enable_warnings

connect (con1,localhost,root,,);
connect (con2,localhost,root,,);

# locking of source:

CREATE TABLE t1 (x1 INT);
let $1= 10;
while ($1)
{
  connection con1;
    send ALTER TABLE t1 CHANGE x1 x2 INT;
  connection con2;
    CREATE TABLE t2 LIKE t1;
    replace_result x1 xx x2 xx;
    SHOW CREATE TABLE t2;
    DROP TABLE t2;
  connection con1;
    reap;
    send ALTER TABLE t1 CHANGE x2 x1 INT;
  connection con2;
    CREATE TABLE t2 LIKE t1;
    replace_result x1 xx x2 xx;
    SHOW CREATE TABLE t2;
    DROP TABLE t2;
  connection con1;
    reap;
  dec $1;
}
DROP TABLE t1;

connection default;
disconnect con1;
disconnect con2;

# End of 4.1 tests

# Wait till we reached the initial number of concurrent sessions
--source include/wait_until_count_sessions.inc

Youez - 2016 - github.com/yon3zu
LinuXploit