Case 1: multithreaded backup + multithreaded restore
"Create tables for backup"
Warnings:
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
Warning	1681	Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.

Starting backup
Backup started
"Update tables during backup"

"Wait for backup to complete"
Waiting for backup to complete
Backup completed
"Drop tables after backup completes"
"Restoring metadata"
"Restoring backup on node 1"
"Restoring backup on node 2"
"Print restored rows"
use test;
select * from t0 order by id;
id	val
1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8
9	9
10	12345
select * from t1 order by val;
val
NULL
2
3
4
5
6
7
8
9
11
select * from t2 order by id;
id
1
3
4
5
6
7
8
9
10
22
select * from t3 order by id;
id	val
1	9
2	8
3	33
4	6
5	5
6	4
7	3
8	2
9	1
10	NULL
select * from t4 order by id;
id	val
1	11001
2	11001
3	11001
4	44
5	11001
6	11001
7	11001
8	11001
9	11001
10	11001
select id, sha1(val) from t5 order by id;
id	sha1(val)
1	0b35a3e0949353117c55151be416c64481dc9778
2	0f5f3d3783159438eff81e6b3c8911480daf7eac
3	7b48e60fd747fc37363da73d3140ba0a41ae862a
4	ea7dffff542a062f6e41c69afac9576d7e97634c
5	266d8973914802f093f698a58224566ca2a664bc
6	4a8284d4be6c4c063a910760610c8754ca1234a3
7	c1bd312a4dd67884e66d15671d38c854e99c8021
8	d8ff0788ec90b18f9d51ecad46274e75aaf4b99f
9	139101d8480a9a68e4e1256ed300aad365725fbc
10	NULL
select * from t6 order by id;
id	val
1	1
2	2
3	3
4	4
5	5
6	66
7	7
8	8
9	9
10	NULL
select * from t7 order by id;
id	val1	val2
1	9	9
2	8	8
3	7	7
4	6	6
5	5	5
6	4	4
7	77	3
8	2	2
9	1	1
10	10	NULL
select id, sha1(val) from t8 order by id;
id	sha1(val)
1	025bd54db3f70cdac283a9653518c14f3d331602
2	360252745cb517637959a9ba6cb7a789cf05fa98
3	e315b8015984d48b3d1777787d8b629bd77454cf
4	946a83f98e3f05c3d94f0c7f2e7131324245797c
5	66f223928b25272f115396aa099fb38efbfe3885
6	125d03fac5bb972ef45466e36d25fd219bf09b36
7	cf47dcc87c1ca726f74a86a4aac57d453703facc
8	61984ed58e8de9ab388e62b54ced499e7336e82e
9	ac1bc0da10ddfceab57a04d09524ffde6eb83cf9
10	NULL
select * from t9 order by auto;
auto	string	vstring	tiny	short	medium	long_int	longlong	real_float	real_double	real_decimal	utiny	ushort	umedium	ulong	ulonglong	bits	options	flags	date_field	year_field	time_field	date_time
1	bbbb	bbbb	-22	-22	-22	-22	-22	22.2	22.2200	22.2200	22	00022	22	22	22		two	two	1922-02-22	1922	22:22:22	1922-02-22 22:22:22
2	8888	8888	-8	-8	-8	-8	-8	8.8	8.8000	8.8000	8	00008	8	8	8	
	one	one	1988-08-08	1988	08:08:08	1988-08-08 08:08:08
3	7777	7777	-7	-7	-7	-7	-7	7.7	7.7000	7.7000	7	00007	7	7	7	
	one	one	1977-07-07	1977	07:07:07	1977-07-07 07:07:07
4	6666	6666	-6	-6	-6	-6	-6	6.6	6.6000	6.6000	6	00006	6	6	6	
	one	one	1966-06-06	1966	06:06:06	1966-06-06 06:06:06
5	5555	5555	-5	-5	-5	-5	-5	5.5	5.5000	5.5000	5	00005	5	5	5	
	one	one	1955-05-05	1955	05:05:05	1955-05-05 05:05:05
6	4444	4444	-4	-4	-4	-4	-4	4.4	4.4000	4.4000	4	00004	4	4	4	
	one	one	1944-04-04	1944	04:04:04	1944-04-04 04:04:04
7	3333	3333	-3	-3	-3	-3	-3	3.3	3.3000	3.3000	3	00003	3	3	3	
	one	one	1933-03-03	1933	03:03:03	1933-03-03 03:03:03
8	2222	2222	-2	-2	-2	-2	-2	2.2	2.2000	2.2000	2	00002	2	2	2	
	one	one	1922-02-02	1922	02:02:02	1922-02-02 02:02:02
9	1111	1111	-1	-1	-1	-1	-1	1.1	1.1000	1.1000	1	00001	1	1	1	
	one	one	1911-01-01	1911	01:01:01	1911-01-01 01:01:01
10	NULL	NULL	10	10	10	10	10	10.1	NULL	NULL	10	00010	10	10	10	NULL	two	two	NULL	NULL	NULL	NULL
"Drop tables after backup completes"
Case 2: multithreaded snapshotstart backup + multithreaded restore
"Create tables for backup"
Warnings:
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
Warning	1681	Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.

Starting SNAPSHOTSTART backup
Backup started
"Update tables during backup"

"Wait for backup to complete"
Waiting for backup to complete
Backup completed
"Drop tables after backup completes"
"Restoring metadata"
"Restoring backup on node 1"
"Restoring backup on node 2"
"Print restored rows"
use test;
select * from t0 order by id;
id	val
1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8
9	9
10	NULL
select * from t1 order by val;
val
NULL
1
2
3
4
5
6
7
8
9
select * from t2 order by id;
id
1
2
3
4
5
6
7
8
9
10
select * from t3 order by id;
id	val
1	9
2	8
3	7
4	6
5	5
6	4
7	3
8	2
9	1
10	NULL
select * from t4 order by id;
id	val
1	11001
2	11001
3	11001
4	11001
5	11001
6	11001
7	11001
8	11001
9	11001
10	11001
select id, sha1(val) from t5 order by id;
id	sha1(val)
1	0b35a3e0949353117c55151be416c64481dc9778
2	0f5f3d3783159438eff81e6b3c8911480daf7eac
3	7b48e60fd747fc37363da73d3140ba0a41ae862a
4	ea7dffff542a062f6e41c69afac9576d7e97634c
5	8a96558c6361531c5f387582e5f6cd732332262b
6	4a8284d4be6c4c063a910760610c8754ca1234a3
7	c1bd312a4dd67884e66d15671d38c854e99c8021
8	d8ff0788ec90b18f9d51ecad46274e75aaf4b99f
9	139101d8480a9a68e4e1256ed300aad365725fbc
10	NULL
select * from t6 order by id;
id	val
1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8
9	9
10	NULL
select * from t7 order by id;
id	val1	val2
1	9	9
2	8	8
3	7	7
4	6	6
5	5	5
6	4	4
7	3	3
8	2	2
9	1	1
10	10	NULL
select id, sha1(val) from t8 order by id;
id	sha1(val)
1	025bd54db3f70cdac283a9653518c14f3d331602
2	360252745cb517637959a9ba6cb7a789cf05fa98
3	e315b8015984d48b3d1777787d8b629bd77454cf
4	946a83f98e3f05c3d94f0c7f2e7131324245797c
5	66f223928b25272f115396aa099fb38efbfe3885
6	125d03fac5bb972ef45466e36d25fd219bf09b36
7	cf47dcc87c1ca726f74a86a4aac57d453703facc
8	f8f5538687ac9a4294a44de553d46dd798524504
9	ac1bc0da10ddfceab57a04d09524ffde6eb83cf9
10	NULL
select * from t9 order by auto;
auto	string	vstring	tiny	short	medium	long_int	longlong	real_float	real_double	real_decimal	utiny	ushort	umedium	ulong	ulonglong	bits	options	flags	date_field	year_field	time_field	date_time
1	9999	9999	-9	-9	-9	-9	-9	9.9	9.9000	9.9000	9	00009	9	9	9	
	one	one	1999-09-09	1999	09:09:09	1999-09-09 09:09:09
2	8888	8888	-8	-8	-8	-8	-8	8.8	8.8000	8.8000	8	00008	8	8	8	
	one	one	1988-08-08	1988	08:08:08	1988-08-08 08:08:08
3	7777	7777	-7	-7	-7	-7	-7	7.7	7.7000	7.7000	7	00007	7	7	7	
	one	one	1977-07-07	1977	07:07:07	1977-07-07 07:07:07
4	6666	6666	-6	-6	-6	-6	-6	6.6	6.6000	6.6000	6	00006	6	6	6	
	one	one	1966-06-06	1966	06:06:06	1966-06-06 06:06:06
5	5555	5555	-5	-5	-5	-5	-5	5.5	5.5000	5.5000	5	00005	5	5	5	
	one	one	1955-05-05	1955	05:05:05	1955-05-05 05:05:05
6	4444	4444	-4	-4	-4	-4	-4	4.4	4.4000	4.4000	4	00004	4	4	4	
	one	one	1944-04-04	1944	04:04:04	1944-04-04 04:04:04
7	3333	3333	-3	-3	-3	-3	-3	3.3	3.3000	3.3000	3	00003	3	3	3	
	one	one	1933-03-03	1933	03:03:03	1933-03-03 03:03:03
8	2222	2222	-2	-2	-2	-2	-2	2.2	2.2000	2.2000	2	00002	2	2	2	
	one	one	1922-02-02	1922	02:02:02	1922-02-02 02:02:02
9	1111	1111	-1	-1	-1	-1	-1	1.1	1.1000	1.1000	1	00001	1	1	1	
	one	one	1911-01-01	1911	01:01:01	1911-01-01 01:01:01
10	NULL	NULL	10	10	10	10	10	10.1	NULL	NULL	10	00010	10	10	10	NULL	two	two	NULL	NULL	NULL	NULL
"Drop tables after backup completes"
Case 3: multithreaded backup + single-threaded restore
"Create tables for backup"
Warnings:
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
Warning	1681	Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.

Starting backup
Backup started
"Update tables during backup"

"Wait for backup to complete"
Waiting for backup to complete
Backup completed
"Drop tables after backup completes"
"Restoring metadata"
"Restoring multithreaded backup parts serially on node 1"
"Restoring multithreaded backup parts serially on node 2"
"Print restored rows"
use test;
select * from t0 order by id;
id	val
1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8
9	9
10	12345
select * from t1 order by val;
val
NULL
2
3
4
5
6
7
8
9
11
select * from t2 order by id;
id
1
3
4
5
6
7
8
9
10
22
select * from t3 order by id;
id	val
1	9
2	8
3	33
4	6
5	5
6	4
7	3
8	2
9	1
10	NULL
select * from t4 order by id;
id	val
1	11001
2	11001
3	11001
4	44
5	11001
6	11001
7	11001
8	11001
9	11001
10	11001
select id, sha1(val) from t5 order by id;
id	sha1(val)
1	0b35a3e0949353117c55151be416c64481dc9778
2	0f5f3d3783159438eff81e6b3c8911480daf7eac
3	7b48e60fd747fc37363da73d3140ba0a41ae862a
4	ea7dffff542a062f6e41c69afac9576d7e97634c
5	266d8973914802f093f698a58224566ca2a664bc
6	4a8284d4be6c4c063a910760610c8754ca1234a3
7	c1bd312a4dd67884e66d15671d38c854e99c8021
8	d8ff0788ec90b18f9d51ecad46274e75aaf4b99f
9	139101d8480a9a68e4e1256ed300aad365725fbc
10	NULL
select * from t6 order by id;
id	val
1	1
2	2
3	3
4	4
5	5
6	66
7	7
8	8
9	9
10	NULL
select * from t7 order by id;
id	val1	val2
1	9	9
2	8	8
3	7	7
4	6	6
5	5	5
6	4	4
7	77	3
8	2	2
9	1	1
10	10	NULL
select id, sha1(val) from t8 order by id;
id	sha1(val)
1	025bd54db3f70cdac283a9653518c14f3d331602
2	360252745cb517637959a9ba6cb7a789cf05fa98
3	e315b8015984d48b3d1777787d8b629bd77454cf
4	946a83f98e3f05c3d94f0c7f2e7131324245797c
5	66f223928b25272f115396aa099fb38efbfe3885
6	125d03fac5bb972ef45466e36d25fd219bf09b36
7	cf47dcc87c1ca726f74a86a4aac57d453703facc
8	61984ed58e8de9ab388e62b54ced499e7336e82e
9	ac1bc0da10ddfceab57a04d09524ffde6eb83cf9
10	NULL
select * from t9 order by auto;
auto	string	vstring	tiny	short	medium	long_int	longlong	real_float	real_double	real_decimal	utiny	ushort	umedium	ulong	ulonglong	bits	options	flags	date_field	year_field	time_field	date_time
1	bbbb	bbbb	-22	-22	-22	-22	-22	22.2	22.2200	22.2200	22	00022	22	22	22		two	two	1922-02-22	1922	22:22:22	1922-02-22 22:22:22
2	8888	8888	-8	-8	-8	-8	-8	8.8	8.8000	8.8000	8	00008	8	8	8	
	one	one	1988-08-08	1988	08:08:08	1988-08-08 08:08:08
3	7777	7777	-7	-7	-7	-7	-7	7.7	7.7000	7.7000	7	00007	7	7	7	
	one	one	1977-07-07	1977	07:07:07	1977-07-07 07:07:07
4	6666	6666	-6	-6	-6	-6	-6	6.6	6.6000	6.6000	6	00006	6	6	6	
	one	one	1966-06-06	1966	06:06:06	1966-06-06 06:06:06
5	5555	5555	-5	-5	-5	-5	-5	5.5	5.5000	5.5000	5	00005	5	5	5	
	one	one	1955-05-05	1955	05:05:05	1955-05-05 05:05:05
6	4444	4444	-4	-4	-4	-4	-4	4.4	4.4000	4.4000	4	00004	4	4	4	
	one	one	1944-04-04	1944	04:04:04	1944-04-04 04:04:04
7	3333	3333	-3	-3	-3	-3	-3	3.3	3.3000	3.3000	3	00003	3	3	3	
	one	one	1933-03-03	1933	03:03:03	1933-03-03 03:03:03
8	2222	2222	-2	-2	-2	-2	-2	2.2	2.2000	2.2000	2	00002	2	2	2	
	one	one	1922-02-02	1922	02:02:02	1922-02-02 02:02:02
9	1111	1111	-1	-1	-1	-1	-1	1.1	1.1000	1.1000	1	00001	1	1	1	
	one	one	1911-01-01	1911	01:01:01	1911-01-01 01:01:01
10	NULL	NULL	10	10	10	10	10	10.1	NULL	NULL	10	00010	10	10	10	NULL	two	two	NULL	NULL	NULL	NULL
"Drop tables after backup completes"
Case 4: multithreaded snapshotstart backup + single-threaded restore
"Create tables for backup"
Warnings:
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
Warning	1681	Specifying number of digits for floating point data types is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.
Warning	1681	Integer display width is deprecated and will be removed in a future release.

Starting SNAPSHOTSTART backup
Backup started
"Update tables during backup"

"Wait for backup to complete"
Waiting for backup to complete
Backup completed
"Drop tables after backup completes"
"Restoring metadata"
"Restoring multithreaded backup parts serially on node 1"
"Restoring multithreaded backup parts serially on node 2"
"Print restored rows"
use test;
select * from t0 order by id;
id	val
1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8
9	9
10	NULL
select * from t1 order by val;
val
NULL
1
2
3
4
5
6
7
8
9
select * from t2 order by id;
id
1
2
3
4
5
6
7
8
9
10
select * from t3 order by id;
id	val
1	9
2	8
3	7
4	6
5	5
6	4
7	3
8	2
9	1
10	NULL
select * from t4 order by id;
id	val
1	11001
2	11001
3	11001
4	11001
5	11001
6	11001
7	11001
8	11001
9	11001
10	11001
select id, sha1(val) from t5 order by id;
id	sha1(val)
1	0b35a3e0949353117c55151be416c64481dc9778
2	0f5f3d3783159438eff81e6b3c8911480daf7eac
3	7b48e60fd747fc37363da73d3140ba0a41ae862a
4	ea7dffff542a062f6e41c69afac9576d7e97634c
5	8a96558c6361531c5f387582e5f6cd732332262b
6	4a8284d4be6c4c063a910760610c8754ca1234a3
7	c1bd312a4dd67884e66d15671d38c854e99c8021
8	d8ff0788ec90b18f9d51ecad46274e75aaf4b99f
9	139101d8480a9a68e4e1256ed300aad365725fbc
10	NULL
select * from t6 order by id;
id	val
1	1
2	2
3	3
4	4
5	5
6	6
7	7
8	8
9	9
10	NULL
select * from t7 order by id;
id	val1	val2
1	9	9
2	8	8
3	7	7
4	6	6
5	5	5
6	4	4
7	3	3
8	2	2
9	1	1
10	10	NULL
select id, sha1(val) from t8 order by id;
id	sha1(val)
1	025bd54db3f70cdac283a9653518c14f3d331602
2	360252745cb517637959a9ba6cb7a789cf05fa98
3	e315b8015984d48b3d1777787d8b629bd77454cf
4	946a83f98e3f05c3d94f0c7f2e7131324245797c
5	66f223928b25272f115396aa099fb38efbfe3885
6	125d03fac5bb972ef45466e36d25fd219bf09b36
7	cf47dcc87c1ca726f74a86a4aac57d453703facc
8	f8f5538687ac9a4294a44de553d46dd798524504
9	ac1bc0da10ddfceab57a04d09524ffde6eb83cf9
10	NULL
select * from t9 order by auto;
auto	string	vstring	tiny	short	medium	long_int	longlong	real_float	real_double	real_decimal	utiny	ushort	umedium	ulong	ulonglong	bits	options	flags	date_field	year_field	time_field	date_time
1	9999	9999	-9	-9	-9	-9	-9	9.9	9.9000	9.9000	9	00009	9	9	9	
	one	one	1999-09-09	1999	09:09:09	1999-09-09 09:09:09
2	8888	8888	-8	-8	-8	-8	-8	8.8	8.8000	8.8000	8	00008	8	8	8	
	one	one	1988-08-08	1988	08:08:08	1988-08-08 08:08:08
3	7777	7777	-7	-7	-7	-7	-7	7.7	7.7000	7.7000	7	00007	7	7	7	
	one	one	1977-07-07	1977	07:07:07	1977-07-07 07:07:07
4	6666	6666	-6	-6	-6	-6	-6	6.6	6.6000	6.6000	6	00006	6	6	6	
	one	one	1966-06-06	1966	06:06:06	1966-06-06 06:06:06
5	5555	5555	-5	-5	-5	-5	-5	5.5	5.5000	5.5000	5	00005	5	5	5	
	one	one	1955-05-05	1955	05:05:05	1955-05-05 05:05:05
6	4444	4444	-4	-4	-4	-4	-4	4.4	4.4000	4.4000	4	00004	4	4	4	
	one	one	1944-04-04	1944	04:04:04	1944-04-04 04:04:04
7	3333	3333	-3	-3	-3	-3	-3	3.3	3.3000	3.3000	3	00003	3	3	3	
	one	one	1933-03-03	1933	03:03:03	1933-03-03 03:03:03
8	2222	2222	-2	-2	-2	-2	-2	2.2	2.2000	2.2000	2	00002	2	2	2	
	one	one	1922-02-02	1922	02:02:02	1922-02-02 02:02:02
9	1111	1111	-1	-1	-1	-1	-1	1.1	1.1000	1.1000	1	00001	1	1	1	
	one	one	1911-01-01	1911	01:01:01	1911-01-01 01:01:01
10	NULL	NULL	10	10	10	10	10	10.1	NULL	NULL	10	00010	10	10	10	NULL	two	two	NULL	NULL	NULL	NULL
"Drop tables after backup completes"
Case 5: restore backup with missing part