mariadb/mysql-test/suite/rpl/r/rpl_show_slave_status.result
Kristian Nielsen 23c48474f7 MDEV-33212: mysqldump uses MASTER_LOG_POS with dump-slave
The patch for MDEV-15530 incorrectly added a column in the middle of SHOW
SLAVE STATUS output. This is wrong, as it breaks backwards compatibility
with existing applications and scripts. In this case, it even broke
mariadb-dump, which is included in the server source tree!

Revert the incorrect change, putting the new Replicate_Rewrite_DB at the end
of SHOW SLAVE STATUS output.

Add a testcase for the mariadb-dump --dump-slave wrong output problem. Also
add a testcase rpl.rpl_show_slave_status to hopefully prevent any future
incorrect additions to SHOW SLAVE STATUS.

Signed-off-by: Kristian Nielsen <knielsen@knielsen-hq.org>
2024-03-08 15:23:42 +01:00

75 lines
1.9 KiB
Text

include/master-slave.inc
[connection master]
*
* The purpose of this test is to prevent incorrect additions to SHOW
* SLAVE STATUS, which has happened several times in the past.
*
* We must never, _ever_, add extra rows to this output of SHOW SLAVE
* STATUS, except at the very end, as this breaks backwards compatibility
* with applications or scripts that parse the output. This also means that
* we cannot add _any_ new rows in a GA version if a different row was
* already added in a later MariaDB version, as this would make it impossible
* to merge the change up while preserving the order of rows.
*
connection slave;
SHOW SLAVE STATUS;
Slave_IO_State #
Master_Host #
Master_User #
Master_Port #
Connect_Retry #
Master_Log_File #
Read_Master_Log_Pos #
Relay_Log_File #
Relay_Log_Pos #
Relay_Master_Log_File #
Slave_IO_Running #
Slave_SQL_Running #
Replicate_Do_DB #
Replicate_Ignore_DB #
Replicate_Do_Table #
Replicate_Ignore_Table #
Replicate_Wild_Do_Table #
Replicate_Wild_Ignore_Table #
Last_Errno #
Last_Error #
Skip_Counter #
Exec_Master_Log_Pos #
Relay_Log_Space #
Until_Condition #
Until_Log_File #
Until_Log_Pos #
Master_SSL_Allowed #
Master_SSL_CA_File #
Master_SSL_CA_Path #
Master_SSL_Cert #
Master_SSL_Cipher #
Master_SSL_Key #
Seconds_Behind_Master #
Master_SSL_Verify_Server_Cert #
Last_IO_Errno #
Last_IO_Error #
Last_SQL_Errno #
Last_SQL_Error #
Replicate_Ignore_Server_Ids #
Master_Server_Id #
Master_SSL_Crl #
Master_SSL_Crlpath #
Using_Gtid #
Gtid_IO_Pos #
Replicate_Do_Domain_Ids #
Replicate_Ignore_Domain_Ids #
Parallel_Mode #
SQL_Delay #
SQL_Remaining_Delay #
Slave_SQL_Running_State #
Slave_DDL_Groups #
Slave_Non_Transactional_Groups #
Slave_Transactional_Groups #
Replicate_Rewrite_DB #
*
* When modifying this test after adding a column to SHOW SLAVE STATUS,
* _only_ additions at the end are allowed, the column number of existing
* columns must _not_ change!
*
include/rpl_end.inc