403Webshell
Server IP : 172.67.216.182  /  Your IP : 172.68.164.132
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/extra/binlog_tests/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /www/server/mysql/src/mysql-test/extra/binlog_tests/enforce_gtid_consistency_tmp_consistent.test
--let $error_code= 0
--let $statement_ends_transaction= 1
--let $gtid_violation= 0
--let $sync_point= before_execute_sql_command

# When CREATE TEMPORARY and DROP TEMPORARY occur *outside* a
# transaction, it is GTID-consistent.

--echo ---- CREATE TEMPORARY outside trx ----
--let $statement= CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB
--source extra/binlog_tests/enforce_gtid_consistency_statement.inc

--echo ---- DROP TEMPORARY outside trx ----
--let $statement= DROP TEMPORARY TABLE t1
--source extra/binlog_tests/enforce_gtid_consistency_statement.inc

# ALTER is always GTID-consistent. In fact, ALTER TEMPORARY does not
# exist.  ALTER without the TEMPORARY keyword can operate on a
# temporary table, but even then it has an implicit commit.

if ($gtid_next != GTID)
{
  --echo ---- ALTER without TEMPORARY, on temp table, in trx ----

  # If gtid_next=GTID, it generates
  # ER_CANT_DO_IMPLICIT_COMMIT_IN_TRX_WHEN_GTID_NEXT_IS_SET.
  CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB;
  --let $pre_statement= BEGIN
  --let $statement= ALTER TABLE t1 ADD COLUMN (b INT)
  --source extra/binlog_tests/enforce_gtid_consistency_statement.inc

  # DROP without TEMPORARY is always GTID-consistent, since it has an
  # implicit commit even if it operates on a temporary table.

  --echo ---- DROP without TEMPORARY, on temp table ----

  --let $pre_statement= BEGIN
  --let $statement= DROP TABLE t1
  --source extra/binlog_tests/enforce_gtid_consistency_statement.inc

  --let $gtid_violation= 0
  DROP TABLE IF EXISTS t1; # May still exist if gtid_violation=1.

  # When SQL_LOG_BIN=0, it is GTID-consistent since nothing is logged.
}

SET SQL_LOG_BIN = 0;

--echo ---- CREATE TEMPORARY in trx, SQL_LOG_BIN=0 (InnoDB, BEGIN) ----
--let $pre_statement= BEGIN
--let $statement= CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB
--source extra/binlog_tests/enforce_gtid_consistency_statement.inc
COMMIT;
DROP TEMPORARY TABLE t1;

--echo ---- CREATE TEMPORARY in trx, SQL_LOG_BIN=0 (MyISAM, BEGIN) ----
--let $pre_statement= BEGIN
--let $statement= CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM
--source extra/binlog_tests/enforce_gtid_consistency_statement.inc
COMMIT;
DROP TEMPORARY TABLE t1;

SET AUTOCOMMIT = 0;

--echo ---- CREATE TEMPORARY in trx, SQL_LOG_BIN=0 (InnoDB, AUTOCOMMIT=0) ----
--let $statement= CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB
--source extra/binlog_tests/enforce_gtid_consistency_statement.inc
COMMIT;
DROP TEMPORARY TABLE t1;
COMMIT;

--echo ---- CREATE TEMPORARY in trx, SQL_LOG_BIN=0 (MyISAM, AUTOCOMMIT=0) ----
--let $statement= CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM
--source extra/binlog_tests/enforce_gtid_consistency_statement.inc
COMMIT;
DROP TEMPORARY TABLE t1;

SET AUTOCOMMIT = 1;

--echo ---- DROP TEMPORARY in trx, SQL_LOG_BIN=0 (InnoDB, BEGIN) ----
CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB;
--let $pre_statement= BEGIN
--let $statement= DROP TEMPORARY TABLE t1
--source extra/binlog_tests/enforce_gtid_consistency_statement.inc
COMMIT;

--echo ---- DROP TEMPORARY in trx, SQL_LOG_BIN=0 (MyISAM, BEGIN) ----
CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM;
--let $pre_statement= BEGIN
--let $statement= DROP TEMPORARY TABLE t1
--source extra/binlog_tests/enforce_gtid_consistency_statement.inc
COMMIT;

SET AUTOCOMMIT = 0;

--echo ---- DROP TEMPORARY in trx, SQL_LOG_BIN=0 (InnoDB, AUTOCOMMIT=0) ----
CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB;
COMMIT;
--let $statement= DROP TEMPORARY TABLE t1
--source extra/binlog_tests/enforce_gtid_consistency_statement.inc
COMMIT;

--echo ---- DROP TEMPORARY in trx, SQL_LOG_BIN=0 (MyISAM, AUTOCOMMIT=0) ----
CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM;
COMMIT;
--let $statement= DROP TEMPORARY TABLE t1
--source extra/binlog_tests/enforce_gtid_consistency_statement.inc
COMMIT;

SET AUTOCOMMIT = 1;

SET SQL_LOG_BIN = 1;

Youez - 2016 - github.com/yon3zu
LinuXploit