| Server IP : 104.21.38.3 / Your IP : 172.70.143.3 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/mysql-test/suite/binlog/r/ |
Upload File : |
RESET MASTER;
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1);
SELECT WAIT_FOR_EXECUTED_GTID_SET('Incorrect_value');
ERROR HY000: Malformed GTID set specification 'Incorrect_value'.
SELECT WAIT_FOR_EXECUTED_GTID_SET('Incorrect_value', 5);
ERROR HY000: Malformed GTID set specification 'Incorrect_value'.
SELECT WAIT_FOR_EXECUTED_GTID_SET(NULL, 5);
ERROR HY000: Malformed GTID set specification 'NULL'.
SELECT WAIT_FOR_EXECUTED_GTID_SET();
ERROR 42000: Incorrect parameter count in the call to native function 'WAIT_FOR_EXECUTED_GTID_SET'
SELECT WAIT_FOR_EXECUTED_GTID_SET('NULL', 5, 5);
ERROR 42000: Incorrect parameter count in the call to native function 'WAIT_FOR_EXECUTED_GTID_SET'
DROP TABLE t1;
Test WAIT_FOR_EXECUTED_GTID_SET function with negative timeout value.
When SQL_MODE is strict, then it will throw WRONG_ARGUMENTS
error.
SET @save_sql_mode=@@SESSION.SQL_MODE;
SET @@SESSION.SQL_MODE="STRICT_ALL_TABLES";
Warnings:
Warning 3135 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.
SELECT WAIT_FOR_EXECUTED_GTID_SET('MASTER_UUID:100', -1);;
ERROR HY000: Incorrect arguments to WAIT_FOR_EXECUTED_GTID_SET.
SET @@SESSION.SQL_MODE="";
SELECT WAIT_FOR_EXECUTED_GTID_SET('MASTER_UUID:100', -1);;
WAIT_FOR_EXECUTED_GTID_SET('MASTER_UUID:100', -1)
NULL
Warnings:
Warning 1210 Incorrect arguments to WAIT_FOR_EXECUTED_GTID_SET.
SET @@SESSION.SQL_MODE=@save_sql_mode;
Warnings:
Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.
Test WAIT_FOR_EXECUTED_GTID_SET function with fractional timeout value.
Earlier(before fix), 0.4 is read as integer value '0' and the function
hanged forever (or till all the specified gtids are executed).
Now(after fix) 0.4 will be read as doube 0.4 and will waitfor
atleast 0.4 seconds (or till all the specified gtids are executed).
Also check that function returns 1 if timeout has been executed.
include/assert.inc [WAIT_FOR_EXECUTED_GTID_SET returns 1 if the timeout has been exceeded.]