|
--disable_abort_on_error
|
|
--source include/master-slave.inc
|
--source include/have_log_bin.inc
|
--source include/have_binlog_format_statement.inc
|
|
--connection master
|
set binlog_alter_two_phase=YES;
|
|
--connection slave
|
STOP SLAVE;
|
set global slave_parallel_threads=8;
|
|
--connection slave
|
RESET SLAVE;
|
--source include/start_slave.inc
|
--connection master
|
|
CREATE TABLE CC (pk int auto_increment, col_int_nokey int , col_int_key int, col_date_key DATE, col_date_nokey DATE , col_time_key time, col_time_nokey time , col_datetime_key datetime, col_datetime_nokey datetime , col_varchar_key varchar(1), col_varchar_nokey varchar(1) , PRIMARY KEY (pk), KEY (col_int_key), KEY (col_date_key), KEY (col_time_key), KEY (col_datetime_key), KEY (col_varchar_key, col_int_key)) ;
|
CREATE TABLE DD (pk int auto_increment, col_int_nokey int , col_int_key int, col_date_key DATE, col_date_nokey DATE , col_time_key time, col_time_nokey time , col_datetime_key datetime, col_datetime_nokey datetime , col_varchar_key varchar(1), col_varchar_nokey varchar(1) , PRIMARY KEY (pk), KEY (col_int_key), KEY (col_date_key), KEY (col_time_key), KEY (col_datetime_key), KEY (col_varchar_key, col_int_key)) ;
|
ALTER ONLINE IGNORE TABLE `DD` /*!100301 WAIT 8 */ ADD CONSTRAINT CHECK (ecol9 < ncol8) ;
|
|
CREATE TEMPORARY TABLE tmp17 AS SELECT VAR_SAMP( `col_date_key` ) AS field1, COUNT( `col_varchar_nokey` ) OVER ( ) AS field2, SUM( CEILING( `col_int_nokey` ) ) AS field3, BIT_AND( ( LEFT( `col_int_key`, '19:19:12.057882' ) ) ) OVER ( ) AS field4, SUM( POW( ( TAN( `col_varchar_nokey` ) ), -13886 ) ) OVER ( ) AS field5 FROM `A` ORDER BY MONTH( `col_varchar_nokey` ), CONCAT( ( LAST_DAY( ( LN( `col_datetime_nokey` ) ) ) ), -4602678819172646912, ( BIN( 'a' ) ), ( REVERSE( `col_int_key` ) ), 0 ) ;
|
DROP TABLE IF EXISTS tmp17 ;
|
SELECT DISTINCT AVG( 'f' ) OVER ( ) AS field1, BIT_AND( ( ~ ( @A := ( MID( ( @A := ( PI( ) ) ), `col_time_nokey`, `col_date_key` ) ) ) ) ) AS field2 FROM `A` ORDER BY `col_int_nokey`, SUBSTR( -1193 FROM ( FIELD( ( LOG10( `col_varchar_nokey` ) ), 'igwegcnfeuvrgnecpthmhffqbythjwpukqubzpomntrddrwhzjtqvbjiklcekxqyoxsolbxthdcprswpjxixmvfwmsyseblwcvumvyvbitxqjxdzdytunqvvrmpyxrencqhuyrfluezqekmqpwutxnzddrbjycyoyqbzsoxvillooqxuvoxcgohdbytybwcqxdwtqrebgjzbycekyjgbpmqadutr' ) ) FOR ( ~ `col_datetime_nokey` ) ) ;
|
CREATE TABLE tmp18 AS SELECT DISTINCT GROUP_CONCAT( ~ ( EXPORT_SET( ( IF( `col_date_key`, ( CONCAT( `col_time_nokey` ) ), ( EXP( ( 31919 ) ) ) ) ), `col_datetime_key`, ( DATE_ADD( `col_time_key`, INTERVAL '2016-04-24 21:49:54.010640' SECOND ) ), `col_time_nokey` ) ), @A := ( NULLIF( `col_varchar_nokey`, -26791 ) ) ) AS field1 FROM `CC` ORDER BY DEGREES( `col_date_key` ), NULLIF( `col_date_key`, '2025-06-08 00:05:54.016021' ) LIMIT 84 ;
|
DROP TABLE IF EXISTS tmp18 ;
|
SELECT DISTINCT MIN( CHARACTER_LENGTH( ( FORMAT( ( `col_time_key` XOR 4876553971512115200 ), 6 ) ) ) ) OVER ( ) AS field1, SUM( @A := `pk` ) OVER ( ) AS field2, MIN( `col_int_nokey` AND '13:25:41.008917' ) OVER ( ) AS field3 FROM `C` ORDER BY ELT( `col_time_key`, `col_datetime_key` ), REVERSE( ( ( NULLIF( -24314, ( IFNULL( '16:03:40.034680', NULL ) ) ) ) ^ -5419519201586970624 ) ) LIMIT 235 ;
|
ALTER IGNORE TABLE t8 RENAME TO `CC` ;
|
CREATE TEMPORARY TABLE tmp19 AS SELECT MIN( @A := 'm' ) OVER ( ) AS field1 FROM `D` ORDER BY @A := `col_date_key` LIMIT 131 ;
|
DROP TABLE IF EXISTS tmp19 ;
|
SELECT DISTINCT NULLIF( -21153, '1972-03-07' ) AS field1 FROM `CC` ;
|
SELECT MIN( LTRIM( 0 ) ) OVER ( ) AS field1, VAR_POP( `col_int_nokey` ) AS field2 FROM `BB` LIMIT 28 ;
|
SELECT DISTINCT SEC_TO_TIME( `col_time_key` ) AS field1 FROM `AA` ;
|
SELECT MIN( @A := ( `col_time_nokey` & ( ( IFNULL( `col_time_key`, ( LEFT( ( @A := -4167 ), 13003 ) ) ) ) % '2035-08-03 03:40:01.041119' ( MONTHNAME( ( ( '2000-05-02' ^ `col_varchar_key` ) * 4105031060348207104 `col_time_key` < ( `col_date_key` - ( LOG10( ( `col_date_key` LIKE '16:59:24.037522' ) ) ) INTERVAL( ( TIMESTAMP( ( ATAN( 'wegcnfeuvrgnecpthmhffqbythjwpukqubzpomntrddrwhzjtqvbjiklcekxqyoxsolbx' ) ), NULL ) ), ( TIMESTAMP( -7401, `col_varchar_nokey` ) ), 0, 21489, -1528972073492283392, `col_varchar_nokey`, `col_int_nokey` ) ) ) ) ) <= `col_datetime_nokey` ) ) ) OVER ( ) AS field1, VARIANCE( `col_time_nokey` ) AS field2 FROM `C` ORDER BY LOG( ( FLOOR( `col_int_nokey` ) ) ), '10:53:40.014539' OR `col_varchar_nokey` LIMIT 21 ;
|
SELECT STDDEV_POP( `col_time_nokey` ) AS field1 FROM `E` ORDER BY @A := `pk` ;
|
SELECT DISTINCT BIT_AND( ( 21132 MOD `col_datetime_nokey` GREATEST( ( ELT( `col_datetime_nokey`, `col_time_key`, `col_datetime_nokey`, 783, ( HEX( `pk` ) ), 'gcnfeuvrgnecpthmhffqbythjwpukqubzpomntrddrwhzjtqvbjiklcekxqyoxsolbxthdcprswpjxixmvfwmsyseblwcvumvyvbitxqjxdzdytunqvvrmpyxrencqhuyrfluezqekmqpwutxnzddrbjycyoyqbzsoxvillooqxuvox', 25889, `col_date_nokey`, ( LOG( ( LN( 'cnfeuvrgnecpthmhffqbythjwpukqubzpomntrddrwhzjtqvbjiklcekxqyoxsolbxthdcprs' ) ) ) ), ( @A := `col_int_key` ) ) ), ( DAY( ( IF( ( SUBSTR( ( EXPORT_SET( `col_time_nokey`, ( ( IF( ( ( NULLIF( 3564317630087036928, NULL ) ) ), ( NULLIF( ( 'nfeuvrgnecpthmhffqbythjwpukqubzpomntrddrwhzjtqvbjiklcekxqyoxsolbxthdcprswpjxixmvfwmsyseblwcvumvyvbitx' * `col_int_key` 'feuvrgnecpthmhffqbythjwpukqubzpomntrd' <=> '2009-09-16 20:49:09.064033' ), ( FROM_UNIXTIME( `col_time_key`, -24108 ) ) ) ), '1986-11-12' ) ) % `pk` ( LOCATE( ( ADDTIME( ( IFNULL( '02:50:08.059257', ( 'i' MOD `col_datetime_nokey` ISNULL( ( TRIM( 0 FROM '1982-02-01' ) ) ) ) ) ), ( IFNULL( ( ASCII( '21:17:07.014776' ) ), `col_varchar_nokey` ) ) ) ), `pk` ) ) LIKE `col_int_key` ), ( IF( ( COS( ( CHAR_LENGTH( `col_varchar_key` ) ) ) ), `col_time_key`, '2022-04-20 02:42:26.064997' ) ), '08:59:59.053900', 'euvrgnecpthmhffqbythjwpukqubzpomntrddrwhzjtqvbjiklcekxqyoxsolbxthdcprswpjxixmvfwmsyseblwcvumvyvbitxqjxdzdytunqvvrmpyxrencqhuyrfluezqekmqpwutxnzddrbjycyoyqbzsoxvillooqxuvoxcgohdbytybwcqxdwtqrebgjzbycekyjgbpmqadut' ) ) FROM `col_time_nokey` ) ), `col_time_key`, `col_varchar_key` ) ) ) ) ) ) ) OVER ( ) AS field1, STDDEV_SAMP( NULL ) AS field2, ( TO_SECONDS( `pk` ) ) AS field3 FROM `BB` ORDER BY `col_time_nokey` ^ ( @A := ( LOWER( `col_date_key` ) ) ) ;
|
SELECT `col_date_key` ^ ( IF( ( @A := '2015-03-02 02:51:15.065237' ), `pk`, '2016-06-13 06:17:52.024413' ) ) AS field1, BIT_AND( `col_varchar_nokey` ) OVER ( ) AS field2 FROM `B` ;
|
ALTER TABLE t9 ADD CONSTRAINT CHECK (ecol7 LIKE icol1) ;
|
SELECT @A := '17:41:55.029354' AS field1, BIT_AND( `col_varchar_key` ) OVER ( ) AS field2 FROM `A` ORDER BY 'uvrgnecpthmhffqbythjwpukqubzpomntrddrwhzjtqvbjiklcekxqyoxsolbxthdcprswpjxixmvfwmsyseblwcvumvyvbitxqjxdzdytunqvv' XOR '2020-01-12 22:50:49.017673', - 'n' '2030-05-11 05:59:51.002763' <=> ( REVERSE( ( TIME_FORMAT( ( @A := 'q' ), `col_varchar_nokey` ) ) ) ) LIMIT 91 ;
|
SELECT DISTINCT BIT_AND( `col_int_key` ) OVER ( ) AS field1, VAR_SAMP( `pk` ) AS field2, BIT_OR( `col_date_key` ) OVER ( ) AS field3, SUM( -2603925009550278656 && 0 ) AS field4 FROM `DD` ORDER BY @A := `col_varchar_key` ;
|
CREATE TABLE tmp20 AS SELECT BIT_LENGTH( ( IF( `col_date_nokey`, ( CONV( `col_varchar_key`, 91, 253 ) ), 5909567136040222720 ) ) ) AS field1 FROM `CC` LIMIT 165 ;
|
DROP TABLE IF EXISTS tmp20 ;
|
SELECT AVG( 'vrgnecpthmhffqbythjwpukqubzpomntrddrwhzjtqvbjiklcekxqyoxsolbxthdcprswpjxixmvfwmsyseblwcvumvyvbitxqjxdzdytunqvvrmpyxrenc' ) OVER ( ) AS field1, DATE_SUB( 6627328326652395520, INTERVAL ( ( ! ( TIMESTAMPDIFF( HOUR, ( ( NULLIF( ( CURRENT_TIMESTAMP() ), `col_time_nokey` ) ) && `col_varchar_nokey` ), `pk` ) ) ) DIV 0 ( ( NULLIF( `col_int_nokey`, `col_varchar_key` ) ) AND ( ( IFNULL( `col_datetime_key`, `col_datetime_key` ) ) NOT LIKE ( 'h' SOUNDS LIKE ( @A := NULL ) ) ) ) > '2032-05-25' ) HOUR_SECOND ) AS field2 FROM `DD` ORDER BY `col_time_key` + `col_int_nokey` 0 > 'a' LIMIT 142 ;
|
SELECT DISTINCT WEEK( `col_date_nokey`, 1 ) AS field1 FROM `E` ;
|
ROLLBACK ;
|
SELECT GROUP_CONCAT( `col_time_nokey` OR 2721, DATEDIFF( 'y', '1984-04-05 03:11:24.053925' ) ) AS field1, AVG( -3348707797926674432 ) OVER ( ) AS field2 FROM `A` ORDER BY IF( ( NULLIF( `col_time_key`, 'rgnecpthmhffqbythjwpukqubzpomntrddrwhzjtqvbjiklcekxqyoxsolbxthdcprswpjxixmvfwmsyseblwcvumvyv' ) ), NULL, ( TRIM( ( EXP( `col_int_key` ) ) FROM NULL ) ) ) LIMIT 34 ;
|
|
SELECT DISTINCT @A := '22:46:23.005895' AS field1, BIT_AND( `col_int_nokey` ) OVER ( ) AS field2 FROM `CC` ORDER BY ABS( '13:38:08.043401' ) LIMIT 147 ;
|
CREATE OR REPLACE TABLE t7 (icol3 INT UNSIGNED NULL ) ROW_FORMAT = REDUNDANT ;
|
SELECT DISTINCT BIT_AND( -8643533584830824448 ) OVER ( ) AS field1 FROM `DD` ;
|
SELECT -29920 OR 14256 AS field1, LPAD( ( IF( 'gnecpthmhffqbythjwpukqubzpomntrddrwhzjtqvbjiklcekxqyoxsolbxthdcprswpjxixmvfwmsyseblwcvumvyvbitxqjxdzdytunqvvrmpyxrencqhuyrfluezqekmqpwutxnzddrbjycyoyqbzsoxvillooqxuvoxcgohdbytybwcqxdwtqrebgjzbycekyjgbpmqadutrqluyxhrdodxqqjw', `col_datetime_key`, ( MOD( 'z', ( IF( `col_date_nokey`, `col_date_nokey`, `col_varchar_nokey` ) ) ) ) ) ), 'r', 20401 ) AS field2 FROM `BB` ORDER BY LOG( ( 'a' NOT LIKE ( `col_time_key` ) ) ) ;
|
SELECT DISTINCT BIT_AND( `col_date_key` ) OVER ( ) AS field1, STD( 0 ) AS field2, `col_date_key` && ( '2011-11-17 22:27:51.056551' ) AS field3 FROM `E` ;
|
|
SELECT ! `col_int_nokey` AS field1, COUNT( `col_date_nokey` ) OVER ( ) AS field2 FROM `B` ORDER BY IFNULL( 'd', ( ( UCASE( `col_datetime_nokey` ) ) ) ), CURDATE() ;
|
ALTER TABLE t10 REMOVE PARTITIONING ;
|
CREATE TEMPORARY TABLE tmp21 AS SELECT IF( '1982-06-01', ( IF( ( @A := ( ( IFNULL( `col_int_nokey`, `col_int_key` ) ) / ( @A := `col_datetime_key` ) '1991-04-02' <= ( CURRENT_TIME() ) ) ), `col_varchar_nokey`, NULL ) ), ( ACOS( ( FORMAT( `pk`, 7, 'en_US' ) ) ) ) ) AS field1, @A := ( ( LCASE( ( @A := `col_int_nokey` ) ) ) >> `col_datetime_key` ) AS field2 FROM `A` ORDER BY POSITION( 'i' IN ( NULLIF( ( ( LOCALTIME() ) ), ( 'ecpthmhffqbythjwpukqubzpomntrddrwhzjtqvbjiklcekxqyoxsolbxthdcprswpjxixmvfwmsyseblwcvumvyvbitxqjxdzdytunqvvrmpyxrencqhuyrfluezqekmqpwutxnzddrbjycyoyqbzsoxvillooqxuvoxcgoh' << 'z' ) ) ) ) ;
|
DROP TABLE IF EXISTS tmp21 ;
|
SELECT STD( -28456 ) AS field1, BIT_COUNT( -3781334837130952704 ) AS field2 FROM `C` LIMIT 173 ;
|
SELECT GROUP_CONCAT( LOCATE( ( CURRENT_TIME ), 0 ), @A := '20:06:08.001003' ) AS field1 FROM `D` LIMIT 243 ;
|
CREATE TABLE `A` LIKE `D` ;
|
ALTER IGNORE TABLE t8 ADD FOREIGN KEY (tcol5) REFERENCES t8 (tscol9) ON UPDATE SET DEFAULT, DROP CONSTRAINT IF EXISTS s ;
|
ALTER TABLE `B` DROP COLUMN IF EXISTS tcol6, ALGORITHM=INPLACE, RENAME TO t9, DROP INDEX ind7, DROP CONSTRAINT f ;
|
SELECT ( REPEAT( '2035-12-11', '20:50:12.006349' ) ) MOD '19:31:27.009867' `col_varchar_key` > ( - ( 'i' XOR `col_datetime_nokey` ) `col_datetime_key` IN ( ( WEEKOFYEAR( ( SIGN( '2013-05-28 18:14:15.043293' ) ) ) ), ( NULLIF( ( NULLIF( ( IFNULL( ( NULLIF( ( SIN( `col_varchar_nokey` ) ), 'thmhffqbythjwpukqubzpomntrddrwhzjtqvbjiklcekxqyoxsolbxthdcprswpjxixmvfwmsyseblwcvumvyvbitxqjxdzdytunqvvrmpyxrencqhuyrfluezqekmqpwu' ) ), 'hmhffqbythjwpukqubzpomntrddrwhzjtqvbjiklcekxqyoxsolbxthdcprswpjxixmvfwmsyseblwcvumvyvbitxqjxdzdytunqvvrmpyxrencqhuyrfluezqekmqpwutxnzddrbjycyoyqbzsoxvillooqxuvoxcgohdbytybwcqxdwtqrebgjzbycekyjgbpmqadutrqluyxhrdodxqqjwasfkv' ) ), '17:07:22.006036' ) ), ( QUOTE( ( NULLIF( `col_date_key`, ( IFNULL( `col_datetime_nokey`, '1980-02-09' ) ) ) ) ) ) ) ), 'mhffqbythjwpukqubzpomntrddrwhzjtqvbjiklcekxqyoxsolbxthdcprswpjxixmvfwmsyseblwcvumvyvbitxqjxdzdytunqvvrmpyxrencqhuyrfluezqek' ) ) AS field1 FROM `CC` ;
|
ALTER IGNORE TABLE `CC` MODIFY COLUMN scol4 VARCHAR(60460) NOT NULL FIRST, LOCK=NONE ;
|
SELECT BIT_OR( `pk` ) OVER ( ) AS field1 FROM `DD` ;
|
|
ALTER TABLE `DD` DROP CONSTRAINT IF EXISTS n, DROP FOREIGN KEY e ;
|
show binlog events;
|
|
--sync_slave_with_master
|
show tables;
|
--source include/rpl_end.inc
|
|
|
Bug
Major
MDEV-11675 Lag Free Alter On Slave
