614 lines
19 KiB
Plaintext
614 lines
19 KiB
Plaintext
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 as nowait"
|
||
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 backup as nowait,snapshotstart"
|
||
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 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 as nowait"
|
||
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 backup as nowait,snapshotstart"
|
||
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 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
|