403Webshell
Server IP : 172.67.216.182  /  Your IP : 162.158.88.31
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/binlog/r/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /www/server/mysql/src/mysql-test/suite/binlog/r/binlog_gtid_next_single_stmt_trx_rollback.result
RESET MASTER;
SET GLOBAL GTID_MODE=OFF_PERMISSIVE;
CREATE TABLE t1(c1 INT PRIMARY KEY) ENGINE=MyISAM;
CREATE TABLE t1_c like t1;
CREATE INDEX t_index ON t1(c1);
CREATE TEMPORARY TABLE temp1(c1 INT) ENGINE=MyISAM;
ALTER TABLE temp1 ADD COLUMN other_column INT;
CREATE VIEW v1 as SELECT 1;
CREATE USER user1;
CREATE DATABASE db1;
INSERT INTO t1 VALUES (3);
INSERT INTO t1_c VALUES (1), (2);
SET SESSION GTID_NEXT='MASTER_UUID:1';
CREATE TABLE t1(c1 INT, c2 INT);
ERROR 42S01: Table 't1' already exists
include/assert.inc [rollback gtid MASTER_UUID:1]
SET SESSION GTID_NEXT='MASTER_UUID:2';
ALTER TABLE t2 ADD COLUMN other_column INT;
ERROR 42S02: Table 'test.t2' doesn't exist
include/assert.inc [rollback gtid MASTER_UUID:2]
SET SESSION GTID_NEXT='MASTER_UUID:3';
DROP TABLE t2;
ERROR 42S02: Unknown table 'test.t2'
include/assert.inc [rollback gtid MASTER_UUID:3]
SET SESSION GTID_NEXT='MASTER_UUID:4';
CREATE INDEX t_index ON t1(c1);
ERROR 42000: Duplicate key name 't_index'
include/assert.inc [rollback gtid MASTER_UUID:4]
SET SESSION GTID_NEXT='MASTER_UUID:5';
DROP INDEX t_index2 ON t1;
ERROR 42000: Can't DROP 't_index2'; check that column/key exists
include/assert.inc [rollback gtid MASTER_UUID:5]
SET SESSION GTID_NEXT='MASTER_UUID:6';
RENAME TABLE t3 TO t4;
ERROR HY000: Can't find file: './test/t3.frm' (errno: 2 - No such file or directory)
include/assert.inc [rollback gtid MASTER_UUID:6]
SET SESSION GTID_NEXT='MASTER_UUID:7';
CREATE TEMPORARY TABLE temp1(c1 INT);
ERROR 42S01: Table 'temp1' already exists
include/assert.inc [rollback gtid MASTER_UUID:7]
SET SESSION GTID_NEXT='MASTER_UUID:8';
ALTER TABLE temp1 ADD COLUMN other_column INT;
ERROR 42S21: Duplicate column name 'other_column'
include/assert.inc [rollback gtid MASTER_UUID:8]
SET SESSION GTID_NEXT='MASTER_UUID:9';
DROP TEMPORARY TABLE temp2;
ERROR 42S02: Unknown table 'test.temp2'
include/assert.inc [rollback gtid MASTER_UUID:9]
SET SESSION GTID_NEXT='MASTER_UUID:10';
CREATE DATABASE db1;
ERROR HY000: Can't create database 'db1'; database exists
include/assert.inc [rollback gtid MASTER_UUID:10]
SET SESSION GTID_NEXT='MASTER_UUID:12';
DROP DATABASE db2;
ERROR HY000: Can't drop database 'db2'; database doesn't exist
include/assert.inc [rollback gtid MASTER_UUID:12]
SET SESSION GTID_NEXT='MASTER_UUID:13';
CREATE USER user1;
ERROR HY000: Operation CREATE USER failed for 'user1'@'%'
include/assert.inc [rollback gtid MASTER_UUID:13]
SET SESSION GTID_NEXT='MASTER_UUID:14';
ALTER USER user2 IDENTIFIED BY 'passwd';
ERROR HY000: Operation ALTER USER failed for 'user2'@'%'
include/assert.inc [rollback gtid MASTER_UUID:14]
SET SESSION GTID_NEXT='MASTER_UUID:15';
GRANT ALL ON *.* TO user2;
ERROR 42000: Can't find any matching row in the user table
include/assert.inc [rollback gtid MASTER_UUID:15]
SET SESSION GTID_NEXT='MASTER_UUID:16';
REVOKE ALL PRIVILEGES ON *.* FROM user2;
ERROR 42000: There is no such grant defined for user 'user2' on host '%'
include/assert.inc [rollback gtid MASTER_UUID:16]
SET SESSION GTID_NEXT='MASTER_UUID:17';
DROP USER user2;
ERROR HY000: Operation DROP USER failed for 'user2'@'%'
include/assert.inc [rollback gtid MASTER_UUID:17]
SET SESSION GTID_NEXT='MASTER_UUID:18';
DROP VIEW v2;
ERROR 42S02: Unknown table 'test.v2'
include/assert.inc [rollback gtid MASTER_UUID:18]
SET SESSION GTID_NEXT='MASTER_UUID:19';
CREATE VIEW v1 as SELECT 1;
ERROR 42S01: Table 'v1' already exists
include/assert.inc [rollback gtid MASTER_UUID:19]
SET SESSION GTID_NEXT='MASTER_UUID:20';
INSERT INTO t1 VALUES (3), (2);
ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
include/assert.inc [rollback gtid MASTER_UUID:20]
SET SESSION GTID_NEXT='MASTER_UUID:21';
INSERT INTO t1 SELECT * FROM t1;
ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
include/assert.inc [rollback gtid MASTER_UUID:21]
SET SESSION GTID_NEXT='MASTER_UUID:22';
INSERT INTO t1 VALUES (2), (3);
ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
include/assert.inc [commit gtid MASTER_UUID:22]
SET SESSION GTID_NEXT='MASTER_UUID:23';
INSERT INTO t1 SELECT * FROM t1_c;
ERROR 23000: Duplicate entry '2' for key 'PRIMARY'
include/assert.inc [commit gtid MASTER_UUID:23]
SET SESSION GTID_NEXT='MASTER_UUID:24';
UPDATE t1 SET c1=2 WHERE c1=1;
ERROR 23000: Duplicate entry '2' for key 'PRIMARY'
include/assert.inc [rollback gtid MASTER_UUID:24]
SET SESSION GTID_NEXT='MASTER_UUID:25';
UPDATE t1_c, t1 SET t1_c.c1=3, t1.c1=2 WHERE t1_c.c1=1 AND t1.c1=1;
ERROR 23000: Duplicate entry '2' for key 'PRIMARY'
include/assert.inc [commit gtid MASTER_UUID:25]
SET SESSION GTID_NEXT='MASTER_UUID:26';
UPDATE t1, t1_c SET t1.c1=2, t1_c.c1=3 WHERE t1.c1=1 OR t1_c.c1=1;
ERROR 23000: Duplicate entry '2' for key 'PRIMARY'
include/assert.inc [rollback gtid MASTER_UUID:26]
SET GTID_NEXT = 'AUTOMATIC';
DROP INDEX t_index ON t1;
DROP TABLE t1, t1_c;
DROP TEMPORARY TABLE temp1;
DROP VIEW v1;
DROP USER user1;
SET GLOBAL GTID_MODE=OFF;
DROP DATABASE db1;
RESET MASTER;
SET GLOBAL GTID_MODE=OFF_PERMISSIVE;
CREATE TABLE t1(c1 INT PRIMARY KEY) ENGINE=InnoDB;
CREATE TABLE t1_c like t1;
CREATE INDEX t_index ON t1(c1);
CREATE TEMPORARY TABLE temp1(c1 INT) ENGINE=InnoDB;
ALTER TABLE temp1 ADD COLUMN other_column INT;
CREATE VIEW v1 as SELECT 1;
CREATE USER user1;
CREATE DATABASE db1;
INSERT INTO t1 VALUES (3), (4);
INSERT INTO t1_c VALUES (1), (2), (3);
SET SESSION GTID_NEXT='MASTER_UUID:1';
CREATE TABLE t1(c1 INT, c2 INT);
ERROR 42S01: Table 't1' already exists
include/assert.inc [rollback gtid MASTER_UUID:1]
SET SESSION GTID_NEXT='MASTER_UUID:2';
ALTER TABLE t2 ADD COLUMN other_column INT;
ERROR 42S02: Table 'test.t2' doesn't exist
include/assert.inc [rollback gtid MASTER_UUID:2]
SET SESSION GTID_NEXT='MASTER_UUID:3';
DROP TABLE t2;
ERROR 42S02: Unknown table 'test.t2'
include/assert.inc [rollback gtid MASTER_UUID:3]
SET SESSION GTID_NEXT='MASTER_UUID:4';
CREATE INDEX t_index ON t1(c1);
ERROR 42000: Duplicate key name 't_index'
include/assert.inc [rollback gtid MASTER_UUID:4]
SET SESSION GTID_NEXT='MASTER_UUID:5';
DROP INDEX t_index2 ON t1;
ERROR 42000: Can't DROP 't_index2'; check that column/key exists
include/assert.inc [rollback gtid MASTER_UUID:5]
SET SESSION GTID_NEXT='MASTER_UUID:6';
RENAME TABLE t3 TO t4;
ERROR HY000: Can't find file: './test/t3.frm' (errno: 2 - No such file or directory)
include/assert.inc [rollback gtid MASTER_UUID:6]
SET SESSION GTID_NEXT='MASTER_UUID:7';
CREATE TEMPORARY TABLE temp1(c1 INT);
ERROR 42S01: Table 'temp1' already exists
include/assert.inc [rollback gtid MASTER_UUID:7]
SET SESSION GTID_NEXT='MASTER_UUID:8';
ALTER TABLE temp1 ADD COLUMN other_column INT;
ERROR 42S21: Duplicate column name 'other_column'
include/assert.inc [rollback gtid MASTER_UUID:8]
SET SESSION GTID_NEXT='MASTER_UUID:9';
DROP TEMPORARY TABLE temp2;
ERROR 42S02: Unknown table 'test.temp2'
include/assert.inc [rollback gtid MASTER_UUID:9]
SET SESSION GTID_NEXT='MASTER_UUID:10';
CREATE DATABASE db1;
ERROR HY000: Can't create database 'db1'; database exists
include/assert.inc [rollback gtid MASTER_UUID:10]
SET SESSION GTID_NEXT='MASTER_UUID:12';
DROP DATABASE db2;
ERROR HY000: Can't drop database 'db2'; database doesn't exist
include/assert.inc [rollback gtid MASTER_UUID:12]
SET SESSION GTID_NEXT='MASTER_UUID:13';
CREATE USER user1;
ERROR HY000: Operation CREATE USER failed for 'user1'@'%'
include/assert.inc [rollback gtid MASTER_UUID:13]
SET SESSION GTID_NEXT='MASTER_UUID:14';
ALTER USER user2 IDENTIFIED BY 'passwd';
ERROR HY000: Operation ALTER USER failed for 'user2'@'%'
include/assert.inc [rollback gtid MASTER_UUID:14]
SET SESSION GTID_NEXT='MASTER_UUID:15';
GRANT ALL ON *.* TO user2;
ERROR 42000: Can't find any matching row in the user table
include/assert.inc [rollback gtid MASTER_UUID:15]
SET SESSION GTID_NEXT='MASTER_UUID:16';
REVOKE ALL PRIVILEGES ON *.* FROM user2;
ERROR 42000: There is no such grant defined for user 'user2' on host '%'
include/assert.inc [rollback gtid MASTER_UUID:16]
SET SESSION GTID_NEXT='MASTER_UUID:17';
DROP USER user2;
ERROR HY000: Operation DROP USER failed for 'user2'@'%'
include/assert.inc [rollback gtid MASTER_UUID:17]
SET SESSION GTID_NEXT='MASTER_UUID:18';
DROP VIEW v2;
ERROR 42S02: Unknown table 'test.v2'
include/assert.inc [rollback gtid MASTER_UUID:18]
SET SESSION GTID_NEXT='MASTER_UUID:19';
CREATE VIEW v1 as SELECT 1;
ERROR 42S01: Table 'v1' already exists
include/assert.inc [rollback gtid MASTER_UUID:19]
SET SESSION GTID_NEXT='MASTER_UUID:20';
INSERT INTO t1 VALUES (3), (2);
ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
include/assert.inc [rollback gtid MASTER_UUID:20]
SET SESSION GTID_NEXT='MASTER_UUID:21';
INSERT INTO t1 SELECT * FROM t1;
ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
include/assert.inc [rollback gtid MASTER_UUID:21]
SET SESSION GTID_NEXT='MASTER_UUID:22';
INSERT INTO t1 VALUES (2), (3);
ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
include/assert.inc [rollback gtid MASTER_UUID:22]
SET SESSION GTID_NEXT='MASTER_UUID:23';
INSERT INTO t1 SELECT * FROM t1_c;
ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
include/assert.inc [rollback gtid MASTER_UUID:23]
SET SESSION GTID_NEXT='MASTER_UUID:24';
UPDATE t1 SET c1=3 WHERE c1=4;
ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
include/assert.inc [rollback gtid MASTER_UUID:24]
SET SESSION GTID_NEXT='MASTER_UUID:25';
UPDATE t1_c, t1 SET t1_c.c1=6, t1.c1=3 WHERE t1_c.c1=1 AND t1.c1=4;
ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
include/assert.inc [rollback gtid MASTER_UUID:25]
SET SESSION GTID_NEXT='MASTER_UUID:26';
UPDATE t1, t1_c SET t1.c1=3, t1_c.c1=6 WHERE t1.c1=4 OR t1_c.c1=1;
ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
include/assert.inc [rollback gtid MASTER_UUID:26]
SET GTID_NEXT = 'AUTOMATIC';
DROP INDEX t_index ON t1;
DROP TABLE t1, t1_c;
DROP TEMPORARY TABLE temp1;
DROP VIEW v1;
DROP USER user1;
SET GLOBAL GTID_MODE=OFF;
DROP DATABASE db1;

Youez - 2016 - github.com/yon3zu
LinuXploit