| Server IP : 185.86.78.101 / Your IP : 216.73.216.213 Web Server : Apache System : Linux 675867-vds-valikoshka1996.gmhost.pp.ua 5.4.0-150-generic #167-Ubuntu SMP Mon May 15 17:35:05 UTC 2023 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 : OFF Directory : /www/server/mysql/mysql-test/r/ |
Upload File : |
RESET MASTER;
include/gtid_utils.inc
include/gtid_step_reset.inc
SET SESSION GTID_NEXT='MASTER_UUID:1';
CREATE TABLE t1( i INT) engine=INNODB;
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1
SET SESSION GTID_NEXT='MASTER_UUID:2';
INSERT INTO t1 VALUES (12);
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-2
SET SESSION GTID_NEXT='MASTER_UUID:3';
INSERT INTO t1 SELECT * FROM t1;
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-3
SET SESSION GTID_NEXT='MASTER_UUID:4';
UPDATE t1 SET i=13 WHERE i=12;
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-4
SET SESSION GTID_NEXT='MASTER_UUID:5';
DELETE FROM t1;
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-5
SET SESSION GTID_NEXT='MASTER_UUID:6';
ALTER TABLE t1 ADD COLUMN other_column INT;
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-6
SET SESSION GTID_NEXT='MASTER_UUID:7';
CREATE INDEX t_index ON t1(i);
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-7
SET SESSION GTID_NEXT='MASTER_UUID:8';
DROP INDEX t_index ON t1;
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-8
SET SESSION GTID_NEXT='MASTER_UUID:9';
RENAME TABLE t1 TO t2;
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-9
SET SESSION GTID_NEXT='MASTER_UUID:10';
DROP TABLE t2;
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-10
SET SESSION GTID_NEXT='MASTER_UUID:11';
CREATE TEMPORARY TABLE t1(i INT);
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-11
SET SESSION GTID_NEXT='MASTER_UUID:12';
DROP TEMPORARY TABLE t1;
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-12
SET SESSION GTID_NEXT='MASTER_UUID:13';
CREATE VIEW v1 as SELECT 1;
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-13
SET SESSION GTID_NEXT='MASTER_UUID:14';
DROP VIEW v1;
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-14
SET SESSION GTID_NEXT='MASTER_UUID:15';
CREATE USER user1;
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-15
SET SESSION GTID_NEXT='MASTER_UUID:16';
ALTER USER user1 IDENTIFIED BY 'passwd';
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-16
SET SESSION GTID_NEXT='MASTER_UUID:17';
GRANT ALL ON *.* TO user1;
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-17
SET SESSION GTID_NEXT='MASTER_UUID:18';
REVOKE ALL PRIVILEGES ON *.* FROM user1;
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-18
SET SESSION GTID_NEXT='MASTER_UUID:19';
DROP USER user1;
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-19
SET SESSION GTID_NEXT='MASTER_UUID:20';
CREATE DATABASE db1;
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-20
SET SESSION GTID_NEXT='MASTER_UUID:21';
ALTER DATABASE db1 DEFAULT CHARACTER SET utf8;
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-21
SET SESSION GTID_NEXT='MASTER_UUID:22';
DROP DATABASE db1;
include/gtid_step_assert.inc [count=1, only_count=0]
SELECT GTID_EXECUTED_FROM_TABLE();
GTID_EXECUTED_FROM_TABLE()
MASTER_UUID:1-22
#
# Bug #21459999 "ASSERTION FAILURE WHEN PREVIOUSLY UNUSED TIME
# ZONE IS USED WITH GTID + NO BINLOG"
CREATE TABLE t1(dt DATETIME) engine=INNODB;
SET SESSION GTID_NEXT='MASTER_UUID:23';
# Below statement caused assertion failure.
INSERT INTO t1 VALUES (CONVERT_TZ('2015-07-01 01:00:00', 'UTC', 'No-such-time-zone'));
SET SESSION GTID_NEXT='AUTOMATIC';
DROP TABLE t1;
include/gtid_utils_end.inc