the load_data_ignore_ddi1.test doesn't restore the state.

the bb-10.4-release branch.

spider/regression/e1121.load_data_ignore_ddi1 w4 [ pass ] 116
MTR's internal check of the test case 'spider/regression/e1121.load_data_ignore_ddi1' failed.
This means that the test case does not preserve the state that existed
before the test case was executed. Most likely the test case did not
do a proper clean-up. It could also be caused by the previous test run
by this thread, if the server wasn't restarted.
This is the diff of the states of the servers before and after the
test case was executed:
mysqltest: Logging to '/dev/shm/var/4/tmp/check-mysqld_1_1.log'.
mysqltest: Results saved in '/dev/shm/var/4/tmp/check-mysqld_1_1.result'.
mysqltest: Connecting to server localhost:16060 (socket /dev/shm/var/tmp/4/mysqld.1.1.sock) as 'root', connection 'default', attempt 0 ...
mysqltest: ... Connected.
mysqltest: Start processing test commands from './include/check-testcase.test' ...
mysqltest: ... Done processing test commands.
— /dev/shm/var/4/tmp/check-mysqld_1_1.result 2021-10-30 04:40:56.318705318 +0000
+++ /dev/shm/var/4/tmp/check-mysqld_1_1.reject 2021-10-30 04:40:56.558685299 +0000
@@ -564,6 +564,123 @@
SLOW_QUERY_LOG_FILE /dev/shm/var/4/mysqld.1.1/mysqld-slow.log
SOCKET /dev/shm/var/tmp/4/mysqld.1.1.sock
SORT_BUFFER_SIZE 262144
+SPIDER_AUTO_INCREMENT_MODE -1
+SPIDER_BGS_FIRST_READ -1
+SPIDER_BGS_MODE -1
+SPIDER_BGS_SECOND_READ -1
+SPIDER_BKA_ENGINE
+SPIDER_BKA_MODE -1
+SPIDER_BKA_TABLE_NAME_TYPE -1
+SPIDER_BLOCK_SIZE 16384
+SPIDER_BULK_SIZE -1
+SPIDER_BULK_UPDATE_MODE -1
+SPIDER_BULK_UPDATE_SIZE -1
+SPIDER_CASUAL_READ -1
+SPIDER_CONNECT_ERROR_INTERVAL 1
+SPIDER_CONNECT_MUTEX OFF
+SPIDER_CONNECT_RETRY_COUNT 1000
+SPIDER_CONNECT_RETRY_INTERVAL 1000
+SPIDER_CONNECT_TIMEOUT -1
+SPIDER_CONN_RECYCLE_MODE 0
+SPIDER_CONN_RECYCLE_STRICT 0
+SPIDER_CONN_WAIT_TIMEOUT 10
+SPIDER_CRD_BG_MODE -1
+SPIDER_CRD_INTERVAL -1
+SPIDER_CRD_MODE -1
+SPIDER_CRD_SYNC -1
+SPIDER_CRD_TYPE -1
+SPIDER_CRD_WEIGHT -1
+SPIDER_DELETE_ALL_ROWS_TYPE -1
+SPIDER_DIRECT_DUP_INSERT -1
+SPIDER_DIRECT_ORDER_LIMIT -1
+SPIDER_DRY_ACCESS OFF
+SPIDER_ERROR_READ_MODE -1
+SPIDER_ERROR_WRITE_MODE -1
+SPIDER_FIRST_READ -1
+SPIDER_FORCE_COMMIT 1
+SPIDER_GENERAL_LOG OFF
+SPIDER_INDEX_HINT_PUSHDOWN OFF
+SPIDER_INIT_SQL_ALLOC_SIZE -1
+SPIDER_INTERNAL_LIMIT -1
+SPIDER_INTERNAL_OFFSET -1
+SPIDER_INTERNAL_OPTIMIZE -1
+SPIDER_INTERNAL_OPTIMIZE_LOCAL -1
+SPIDER_INTERNAL_SQL_LOG_OFF -1
+SPIDER_INTERNAL_UNLOCK OFF
+SPIDER_INTERNAL_XA OFF
+SPIDER_INTERNAL_XA_ID_TYPE 0
+SPIDER_INTERNAL_XA_SNAPSHOT 0
+SPIDER_LOAD_CRD_AT_STARTUP -1
+SPIDER_LOAD_STS_AT_STARTUP -1
+SPIDER_LOCAL_LOCK_TABLE OFF
+SPIDER_LOCK_EXCHANGE OFF
+SPIDER_LOG_RESULT_ERRORS 0
+SPIDER_LOG_RESULT_ERROR_WITH_SQL 0
+SPIDER_LOW_MEM_READ -1
+SPIDER_MAX_CONNECTIONS 0
+SPIDER_MAX_ORDER -1
+SPIDER_MULTI_SPLIT_READ -1
+SPIDER_NET_READ_TIMEOUT -1
+SPIDER_NET_WRITE_TIMEOUT -1
+SPIDER_PING_INTERVAL_AT_TRX_START 3600
+SPIDER_QUICK_MODE -1
+SPIDER_QUICK_PAGE_BYTE -1
+SPIDER_QUICK_PAGE_SIZE -1
+SPIDER_READ_ONLY_MODE -1
+SPIDER_REMOTE_ACCESS_CHARSET
+SPIDER_REMOTE_AUTOCOMMIT -1
+SPIDER_REMOTE_DEFAULT_DATABASE
+SPIDER_REMOTE_SQL_LOG_OFF -1
+SPIDER_REMOTE_TIME_ZONE
+SPIDER_REMOTE_TRX_ISOLATION -1
+SPIDER_REMOTE_WAIT_TIMEOUT -1
+SPIDER_RESET_SQL_ALLOC -1
+SPIDER_SAME_SERVER_LINK OFF
+SPIDER_SECOND_READ -1
+SPIDER_SELECT_COLUMN_MODE -1
+SPIDER_SELUPD_LOCK_MODE -1
+SPIDER_SEMI_SPLIT_READ -1
+SPIDER_SEMI_SPLIT_READ_LIMIT -1
+SPIDER_SEMI_TABLE_LOCK 1
+SPIDER_SEMI_TABLE_LOCK_CONNECTION -1
+SPIDER_SEMI_TRX ON
+SPIDER_SEMI_TRX_ISOLATION -1
+SPIDER_SKIP_DEFAULT_CONDITION -1
+SPIDER_SKIP_PARALLEL_SEARCH -1
+SPIDER_SLAVE_TRX_ISOLATION -1
+SPIDER_SPLIT_READ -1
+SPIDER_STORE_LAST_CRD -1
+SPIDER_STORE_LAST_STS -1
+SPIDER_STS_BG_MODE -1
+SPIDER_STS_INTERVAL -1
+SPIDER_STS_MODE -1
+SPIDER_STS_SYNC -1
+SPIDER_SUPPORT_XA ON
+SPIDER_SYNC_AUTOCOMMIT ON
+SPIDER_SYNC_SQL_MODE ON
+SPIDER_SYNC_TRX_ISOLATION ON
+SPIDER_TABLE_CRD_THREAD_COUNT 10
+SPIDER_TABLE_INIT_ERROR_INTERVAL 1
+SPIDER_TABLE_STS_THREAD_COUNT 10
+SPIDER_UDF_CT_BULK_INSERT_INTERVAL -1
+SPIDER_UDF_CT_BULK_INSERT_ROWS -1
+SPIDER_UDF_DS_BULK_INSERT_ROWS -1
+SPIDER_UDF_DS_TABLE_LOOP_MODE -1
+SPIDER_UDF_DS_USE_REAL_TABLE -1
+SPIDER_UDF_TABLE_LOCK_MUTEX_COUNT 20
+SPIDER_UDF_TABLE_MON_MUTEX_COUNT 20
+SPIDER_USE_ALL_CONNS_SNAPSHOT OFF
+SPIDER_USE_COND_OTHER_THAN_PK_FOR_UPDATE 1
+SPIDER_USE_CONSISTENT_SNAPSHOT OFF
+SPIDER_USE_DEFAULT_DATABASE ON
+SPIDER_USE_FLASH_LOGS OFF
+SPIDER_USE_HANDLER -1
+SPIDER_USE_PUSHDOWN_UDF 0
+SPIDER_USE_SNAPSHOT_WITH_FLUSH_TABLES 0
+SPIDER_USE_TABLE_CHARSET -1
+SPIDER_VERSION 3.3.15
+SPIDER_WAIT_TIMEOUT 604800
+SPIDER_XA_REGISTER_MODE 1
SQL_AUTO_IS_NULL OFF
SQL_BIG_SELECTS ON
SQL_BUFFER_RESULT OFF
mysqltest: Result length mismatch