Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 3.148.250.110
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
suite /
ndb /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
bug36547.result
455
B
-rw-r--r--
loaddata_autocom_ndb.result
740
B
-rw-r--r--
ndb_add_partition.result
13.36
KB
-rw-r--r--
ndb_addnode_restart.result
384
B
-rw-r--r--
ndb_addnode_restart2.result
454
B
-rw-r--r--
ndb_alter_table.result
19.49
KB
-rw-r--r--
ndb_alter_table2.result
685
B
-rw-r--r--
ndb_alter_table3.result
1.48
KB
-rw-r--r--
ndb_alter_table_backup.result
1.76
KB
-rw-r--r--
ndb_alter_table_dml.result
1.83
KB
-rw-r--r--
ndb_alter_table_error.result
664
B
-rw-r--r--
ndb_alter_table_online.result
29.02
KB
-rw-r--r--
ndb_alter_table_online2.result
3.21
KB
-rw-r--r--
ndb_alter_table_online_multi.r...
2
KB
-rw-r--r--
ndb_auto_increment.result
11.49
KB
-rw-r--r--
ndb_autoinc.result
2.69
KB
-rw-r--r--
ndb_backup_rate.result
912
B
-rw-r--r--
ndb_basic.result
32.68
KB
-rw-r--r--
ndb_bitfield.result
8.39
KB
-rw-r--r--
ndb_blob.result
26.47
KB
-rw-r--r--
ndb_blob_big.result
1.24
KB
-rw-r--r--
ndb_blob_partition.result
9.03
KB
-rw-r--r--
ndb_bug13563280.result
224
B
-rw-r--r--
ndb_bug14166590.result
416
B
-rw-r--r--
ndb_bug17624736.result
1.71
KB
-rw-r--r--
ndb_bug17719439.result
439
B
-rw-r--r--
ndb_bug19390895.result
1.67
KB
-rw-r--r--
ndb_bug26793.result
286
B
-rw-r--r--
ndb_bug31477.result
1.85
KB
-rw-r--r--
ndb_bulk_delete.result
1.87
KB
-rw-r--r--
ndb_bushy_joins.result
88.95
KB
-rw-r--r--
ndb_cache.result
9.35
KB
-rw-r--r--
ndb_cache2.result
13.9
KB
-rw-r--r--
ndb_cache_multi.result
2.44
KB
-rw-r--r--
ndb_cache_multi2.result
3.04
KB
-rw-r--r--
ndb_cache_trans.result
6.65
KB
-rw-r--r--
ndb_charset.result
5.77
KB
-rw-r--r--
ndb_checksum.result
38
B
-rw-r--r--
ndb_column_properties.result
16.01
KB
-rw-r--r--
ndb_condition_pushdown.result
131.71
KB
-rw-r--r--
ndb_config.result
3.36
KB
-rw-r--r--
ndb_config2.result
475
B
-rw-r--r--
ndb_create_table.result
1.02
KB
-rw-r--r--
ndb_cursor.result
792
B
-rw-r--r--
ndb_database.result
1.25
KB
-rw-r--r--
ndb_dbug_lock.result
1.64
KB
-rw-r--r--
ndb_dbug_tc_select.result
6.71
KB
-rw-r--r--
ndb_dd_alter.result
28.43
KB
-rw-r--r--
ndb_dd_basic.result
21.17
KB
-rw-r--r--
ndb_dd_bug12581213.result
334
B
-rw-r--r--
ndb_dd_ddl.result
5.94
KB
-rw-r--r--
ndb_dd_disk2memory.result
15.44
KB
-rw-r--r--
ndb_dd_dump.result
15.97
KB
-rw-r--r--
ndb_dd_initial_lg.result
941
B
-rw-r--r--
ndb_dd_restore_check_tablespac...
8.3
KB
-rw-r--r--
ndb_dd_restore_compat.result
3.73
KB
-rw-r--r--
ndb_dd_sql_features.result
22.62
KB
-rw-r--r--
ndb_ddl_open_trans.result
1.44
KB
-rw-r--r--
ndb_disconnect_ddl.result
291
B
-rw-r--r--
ndb_discover_db.result
1.92
KB
-rw-r--r--
ndb_dist_priv.result
6.36
KB
-rw-r--r--
ndb_dist_priv_bug_13340854.res...
248
B
-rw-r--r--
ndb_err4012.result
2.22
KB
-rw-r--r--
ndb_error_reporter.result
5.61
KB
-rw-r--r--
ndb_fired_trigger_shortage.res...
694
B
-rw-r--r--
ndb_fk_addnode.result
1.39
KB
-rw-r--r--
ndb_fk_alter.result
8.34
KB
-rw-r--r--
ndb_fk_bugs.result
27.58
KB
-rw-r--r--
ndb_fk_build.result
2.31
KB
-rw-r--r--
ndb_fk_cascade_delete.result
4.82
KB
-rw-r--r--
ndb_fk_cascade_delete_multi.re...
2.56
KB
-rw-r--r--
ndb_fk_cascade_update.result
1.66
KB
-rw-r--r--
ndb_fk_create_drop.result
4.8
KB
-rw-r--r--
ndb_fk_db.result
7.18
KB
-rw-r--r--
ndb_fk_deferred_cascade.result
2.82
KB
-rw-r--r--
ndb_fk_disable.result
11.64
KB
-rw-r--r--
ndb_fk_is.result
8.49
KB
-rw-r--r--
ndb_fk_locase.result
2.44
KB
-rw-r--r--
ndb_fk_locking.result
1.47
KB
-rw-r--r--
ndb_fk_multi_column.result
2.04
KB
-rw-r--r--
ndb_fk_mysqldump.result
2.93
KB
-rw-r--r--
ndb_fk_mysqldump2.result
72
B
-rw-r--r--
ndb_fk_no_fk.result
30.14
KB
-rw-r--r--
ndb_fk_no_fk_legacy.result
2.77
KB
-rw-r--r--
ndb_fk_noaction.result
5.68
KB
-rw-r--r--
ndb_fk_resources.result
2.58
KB
-rw-r--r--
ndb_fk_restore.result
14.08
KB
-rw-r--r--
ndb_fk_restrict.result
6.82
KB
-rw-r--r--
ndb_fk_self_ref.result
3.74
KB
-rw-r--r--
ndb_fk_setdefault.result
1.03
KB
-rw-r--r--
ndb_fk_setnull.result
3.23
KB
-rw-r--r--
ndb_global_schema_lock.result
3.6
KB
-rw-r--r--
ndb_global_schema_lock_error.r...
1.88
KB
-rw-r--r--
ndb_grant.result
17.65
KB
-rw-r--r--
ndb_hashmap.result
624
B
-rw-r--r--
ndb_hidden_pk.result
10.55
KB
-rw-r--r--
ndb_index.result
17.84
KB
-rw-r--r--
ndb_index_ordered.result
16.73
KB
-rw-r--r--
ndb_index_stat.result
17.74
KB
-rw-r--r--
ndb_index_stat_partitions.resu...
3.82
KB
-rw-r--r--
ndb_index_stat_restart.result
2.2
KB
-rw-r--r--
ndb_index_unique.result
20.29
KB
-rw-r--r--
ndb_insert.result
36.52
KB
-rw-r--r--
ndb_join_pushdown_bka.result
949.68
KB
-rw-r--r--
ndb_join_pushdown_default.resu...
865.61
KB
-rw-r--r--
ndb_join_pushdown_nobnl.result
864.87
KB
-rw-r--r--
ndb_join_pushdown_none.result
865.08
KB
-rw-r--r--
ndb_limit.result
1.99
KB
-rw-r--r--
ndb_load.result
2.66
KB
-rw-r--r--
ndb_loaddatalocal.result
1.57
KB
-rw-r--r--
ndb_lock.result
4.17
KB
-rw-r--r--
ndb_lock_table.result
205
B
-rw-r--r--
ndb_many_fragments.result
26.72
KB
-rw-r--r--
ndb_mgm.result
5.7
KB
-rw-r--r--
ndb_mgmd.result
198
B
-rw-r--r--
ndb_minmax.result
1.47
KB
-rw-r--r--
ndb_multi.result
8.83
KB
-rw-r--r--
ndb_multi_row.result
1.33
KB
-rw-r--r--
ndb_multi_update_delete.result
1.83
KB
-rw-r--r--
ndb_native_default_support.res...
50.29
KB
-rw-r--r--
ndb_one_fragment.result
4.05
KB
-rw-r--r--
ndb_optimize_table.result
2
KB
-rw-r--r--
ndb_optimized_node_selection.r...
1017
B
-rw-r--r--
ndb_partition_error.result
1.44
KB
-rw-r--r--
ndb_partition_error2.result
150
B
-rw-r--r--
ndb_partition_hash.result
890
B
-rw-r--r--
ndb_partition_key.result
8.82
KB
-rw-r--r--
ndb_partition_list.result
2.31
KB
-rw-r--r--
ndb_partition_range.result
7.91
KB
-rw-r--r--
ndb_print_file.result
709
B
-rw-r--r--
ndb_rbwr.result
0
B
-rw-r--r--
ndb_read_multi_range.result
15
KB
-rw-r--r--
ndb_reconnect.result
1.7
KB
-rw-r--r--
ndb_rename.result
910
B
-rw-r--r--
ndb_replace.result
3.64
KB
-rw-r--r--
ndb_restore_bug17916243.result
537
B
-rw-r--r--
ndb_restore_compat_downward.re...
132.43
KB
-rw-r--r--
ndb_restore_compat_endianness....
10.97
KB
-rw-r--r--
ndb_restore_conv_lossy_charbin...
15.46
KB
-rw-r--r--
ndb_restore_conv_lossy_integra...
20.72
KB
-rw-r--r--
ndb_restore_conv_more.result
56.57
KB
-rw-r--r--
ndb_restore_conv_padding.resul...
6.14
KB
-rw-r--r--
ndb_restore_conv_promotion.res...
23.26
KB
-rw-r--r--
ndb_restore_discover.result
540
B
-rw-r--r--
ndb_restore_misc.result
25.16
KB
-rw-r--r--
ndb_restore_print.result
9.8
KB
-rw-r--r--
ndb_restore_schema_blobs.resul...
6.44
KB
-rw-r--r--
ndb_restore_schema_partitions....
13.25
KB
-rw-r--r--
ndb_restore_schema_rewrites.re...
12.22
KB
-rw-r--r--
ndb_restore_schema_subsets.res...
95.9
KB
-rw-r--r--
ndb_restore_schema_tolerance.r...
4.53
KB
-rw-r--r--
ndb_restore_undolog.result
18.76
KB
-rw-r--r--
ndb_row_count.result
5.19
KB
-rw-r--r--
ndb_row_format.result
1.74
KB
-rw-r--r--
ndb_select_count.result
334
B
-rw-r--r--
ndb_share.result
11.29
KB
-rw-r--r--
ndb_short_sigs.result
2.54
KB
-rw-r--r--
ndb_single_user.result
4.01
KB
-rw-r--r--
ndb_sp.result
1.17
KB
-rw-r--r--
ndb_spj_dict.result
11.63
KB
-rw-r--r--
ndb_sql_allow_batching.result
918
B
-rw-r--r--
ndb_startup.result
358
B
-rw-r--r--
ndb_statistics0.result
16.23
KB
-rw-r--r--
ndb_statistics1.result
15.99
KB
-rw-r--r--
ndb_subquery.result
9.29
KB
-rw-r--r--
ndb_suma_handover.result
427
B
-rw-r--r--
ndb_temporary.result
949
B
-rw-r--r--
ndb_tmp_table_and_DDL.result
3.11
KB
-rw-r--r--
ndb_transaction.result
4.62
KB
-rw-r--r--
ndb_trigger.result
9.38
KB
-rw-r--r--
ndb_truncate.result
425
B
-rw-r--r--
ndb_types.result
4.91
KB
-rw-r--r--
ndb_update.result
2.97
KB
-rw-r--r--
ndb_update_no_read.result
11.23
KB
-rw-r--r--
ndb_view.result
597
B
-rw-r--r--
ndb_wait_until_ready.result
533
B
-rw-r--r--
ndb_wl946_main.result
19.39
KB
-rw-r--r--
ndb_wl946_post.result
3.7
KB
-rw-r--r--
ndb_wl946_pre.result
6.62
KB
-rw-r--r--
ndbapi-examples.result
3.34
KB
-rw-r--r--
ndbinfo.result
44.04
KB
-rw-r--r--
ndbinfo_cache.result
775
B
-rw-r--r--
ndbinfo_dump.result
95
B
-rw-r--r--
ndbinfo_upgrade.result
382
B
-rw-r--r--
ps_7ndb.result
103.05
KB
-rw-r--r--
strict_autoinc_5ndb.result
894
B
-rw-r--r--
wl10837.result
524
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : ndb_restore_conv_more.result
# bug#17275798 create table t1 ( a int unsigned primary key, b char(20), c int unsigned ) engine=ndb; # restore canned backup select sum(1),sum(isnull(b)),min(b),max(b) from t1; sum(1) sum(isnull(b)) min(b) max(b) 100 15 +z3kg ZOOa2 drop table t1; # bug#17395298 create table t1 ( a int primary key, b text, c int ) engine=ndb; insert into t1 values (1,repeat('a',1000),10); insert into t1 values (2,repeat('b',2000),20); insert into t1 values (3,repeat('c',3000),30); # run backup rename table t1 to t1old; create table t1 ( a int primary key, c int, b text ) engine=ndb; # run restore select count(*) from t1 x, t1old y where x.a = y.a and x.b = y.b and x.c = y.c; count(*) 3 drop table t1old; drop table t1; # bug#17235051 : char<->binary # plain restore create table t1 ( c1 char(10), c2 varchar(100), c3 varchar(1000), b1 binary(10), b2 varbinary(100), b3 varbinary(1000), d varchar(8000), a int unsigned primary key ) engine=ndb; insert into t1 values ('aaa1','bbb1','ccc1','ddd1','eee1','fff1',repeat('x',2000),1), ('aaa2','bbb2','ccc2','ddd2','eee2','fff2',repeat('y',4000),2), ('aaa3','bbb3','ccc3','ddd3','eee3','fff3',repeat('z',6000),3); select a, trim(trailing char(0) from c1) as c1,c2,c3, trim(trailing char(0) from b1) as b1,b2,b3 from t1 order by a; a c1 c2 c3 b1 b2 b3 1 aaa1 bbb1 ccc1 ddd1 eee1 fff1 2 aaa2 bbb2 ccc2 ddd2 eee2 fff2 3 aaa3 bbb3 ccc3 ddd3 eee3 fff3 # run backup drop table t1; create table t1 ( b1 char(10), b2 varchar(100), b3 varchar(1000), c1 binary(10), c2 varbinary(100), c3 varbinary(1000), d varchar(8000), a int unsigned primary key ) engine=ndb; # run restore select a, trim(trailing char(0) from c1) as c1,c2,c3, trim(trailing char(0) from b1) as b1,b2,b3 from t1 order by a; a c1 c2 c3 b1 b2 b3 1 aaa1 bbb1 ccc1 ddd1 eee1 fff1 2 aaa2 bbb2 ccc2 ddd2 eee2 fff2 3 aaa3 bbb3 ccc3 ddd3 eee3 fff3 drop table t1; # staging restore create table t1 ( c1 char(10), c2 varchar(100), c3 varchar(1000), b1 binary(10), b2 varbinary(100), b3 varbinary(1000), d varchar(8000), a int unsigned primary key ) engine=ndb; insert into t1 values ('aaa1','bbb1','ccc1','ddd1','eee1','fff1',repeat('x',2000),1), ('aaa2','bbb2','ccc2','ddd2','eee2','fff2',repeat('y',4000),2), ('aaa3','bbb3','ccc3','ddd3','eee3','fff3',repeat('z',6000),3); select a, trim(trailing char(0) from c1) as c1,c2,c3, trim(trailing char(0) from b1) as b1,b2,b3 from t1 order by a; a c1 c2 c3 b1 b2 b3 1 aaa1 bbb1 ccc1 ddd1 eee1 fff1 2 aaa2 bbb2 ccc2 ddd2 eee2 fff2 3 aaa3 bbb3 ccc3 ddd3 eee3 fff3 # run backup drop table t1; create table t1 ( b1 char(10), b2 varchar(100), b3 varchar(1000), c1 binary(10), c2 varbinary(100), c3 varbinary(1000), d text, a int unsigned primary key ) engine=ndb; # run restore select a, trim(trailing char(0) from c1) as c1,c2,c3, trim(trailing char(0) from b1) as b1,b2,b3 from t1 order by a; a c1 c2 c3 b1 b2 b3 1 aaa1 bbb1 ccc1 ddd1 eee1 fff1 2 aaa2 bbb2 ccc2 ddd2 eee2 fff2 3 aaa3 bbb3 ccc3 ddd3 eee3 fff3 drop table t1; # create tablespace create logfile group lg1 add undofile 'undofile1.dat' initial_size 8M undo_buffer_size 1M engine=ndb; create tablespace ts1 add datafile 'datafile1.dat' use logfile group lg1 initial_size 96M engine=ndb; # bug#17235051 : char<->text create table t1 ( b text, c varchar(8000), d text, a int unsigned primary key ) engine=ndb; insert into t1 values (repeat('a',3333),repeat('b',5555),repeat('c',7777),1); insert into t1 values (repeat('d',7777),repeat('e',5555),repeat('f',3333),2); insert into t1 values (null,repeat('h',5555),repeat('i',3333),3); insert into t1 values (repeat('j',7777),null,repeat('l',3333),4); insert into t1 values (repeat('m',7777),repeat('n',5555),null,5); select count(*),sum(crc32(concat(a,ifnull(b,'x'),ifnull(c,'y'),ifnull(d,'z')))) from t1; count(*) sum(crc32(concat(a,ifnull(b,'x'),ifnull(c,'y'),ifnull(d,'z')))) 5 12314487834 # run backup drop table t1; create table t1 ( b varchar(8000), c text, d text, a int unsigned primary key ) engine=ndb; # run restore select count(*),sum(crc32(concat(a,ifnull(b,'x'),ifnull(c,'y'),ifnull(d,'z')))) from t1; count(*) sum(crc32(concat(a,ifnull(b,'x'),ifnull(c,'y'),ifnull(d,'z')))) 5 12314487834 drop table t1; # bug#17235051 : remap columns and missing columns create table t1 ( x int, a int primary key auto_increment, b int, c bigint, y int, d varchar(8000) ) engine=ndb; insert into t1 (x,b,c,d) values (1,10,100,repeat('d',30)); insert into t1 (x,b,c,d) select x*2,b*3,c*4,concat(d,d) from t1; insert into t1 (x,b,c,d) select x*2,b*3,c*4,concat(d,d) from t1; insert into t1 (x,b,c,d) select x*2,b*3,c*4,concat(d,d) from t1; insert into t1 (x,b,c,d) select x*2,b*3,c*4,concat(d,d) from t1; insert into t1 (x,b,c,d) select x*2,b*3,c*4,concat(d,d) from t1; insert into t1 (x,b,c,d) select x*2,b*3,c*4,concat(d,d) from t1; insert into t1 (x,b,c,d) select x*2,b*3,c*4,concat(d,d) from t1; insert into t1 (x,b,c,d) select x*2,b*3,c*4,concat(d,d) from t1; select count(*),max(a),max(b),max(c),max(length(d)) from t1; count(*) max(a) max(b) max(c) max(length(d)) 256 256 65610 6553600 7680 # run backup rename table t1 to t1old; create table t1 ( d text, z char(10), b int, w char(10), c bigint, a int primary key auto_increment ) engine=ndb; # run restore select count(*),max(a),max(b),max(c),max(length(d)) from t1; count(*) max(a) max(b) max(c) max(length(d)) 256 256 65610 6553600 7680 select count(*) from t1 x, t1old y where x.a = y.a and x.b = y.b and x.c = y.c and x.d = y.d; count(*) 256 drop table t1old; drop table t1; # bug#17235051 : lossy conversions create table t1 ( a char(1) primary key, b text, c varchar(10) ) engine=ndb; insert into t1 values ('a',concat('x',repeat('a',1000)),'0123456789'); insert into t1 values ('b',concat('y',repeat('b',2000)),'012345'); insert into t1 values ('c',concat('z',repeat('c',3000)),'01234'); select a,length(b),trim(trailing a from b),c from t1 order by a; a length(b) trim(trailing a from b) c a 1001 x 0123456789 b 2001 y 012345 c 3001 z 01234 # run backup drop table t1; create table t1 ( a char(1) primary key, b varchar(2001), c varchar(5) ) engine=ndb; # run restore select a,length(b),trim(trailing a from b),c from t1 order by a; a length(b) trim(trailing a from b) c a 1001 x 01234 b 2001 y 01234 c 2001 z 01234 drop table t1; # bug#17235051 : char<->text + disk data create table t1old ( a int unsigned primary key auto_increment, b text, c varchar(8000), d text, e varchar(20), f int ) engine=ndb; insert into t1old (b,c,d,e,f) values (repeat('b',20),repeat('c',30),repeat('d',40),'e',1); insert into t1old (b,c,d,e,f) select concat(b,c),concat(c,d),concat(d,b),concat(e,'e'),2*f from t1old; insert into t1old (b,c,d,e,f) select concat(b,c),concat(c,d),concat(d,b),concat(e,'e'),2*f from t1old; insert into t1old (b,c,d,e,f) select concat(b,c),concat(c,d),concat(d,b),concat(e,'e'),2*f from t1old; insert into t1old (b,c,d,e,f) select concat(b,c),concat(c,d),concat(d,b),concat(e,'e'),2*f from t1old; insert into t1old (b,c,d,e,f) select concat(b,c),concat(c,d),concat(d,b),concat(e,'e'),2*f from t1old; insert into t1old (b,c,d,e,f) select concat(b,c),concat(c,d),concat(d,b),concat(e,'e'),2*f from t1old; insert into t1old (b,c,d,e,f) select concat(b,c),concat(c,d),concat(d,b),concat(e,'e'),2*f from t1old; insert into t1old (b,c,d,e,f) select concat(b,c),concat(c,d),concat(d,b),concat(e,'e'),2*f from t1old; select count(*),max(length(b)),max(length(c)),max(length(d)),max(length(e)),max(f) from t1old; count(*) max(length(b)) max(length(c)) max(length(d)) max(length(e)) max(f) 256 7680 7690 7670 9 256 # restore mem->mem create table t1 ( a int unsigned primary key auto_increment, b text, c varchar(8000), d text, e varchar(20), f int ) engine=ndb; insert into t1 select * from t1old; select count(*) from t1 x, t1old y where x.a = y.a and x.b = y.b and x.c = y.c and x.d = y.d and x.e = y.e and x.f = y.f; count(*) 256 # run backup drop table t1; create table t1 ( e varchar(20), f int, a int unsigned primary key auto_increment, b varchar(8000), c text, d text ) engine=ndb; # run restore select count(*) from t1 x, t1old y where x.a = y.a and x.b = y.b and x.c = y.c and x.d = y.d and x.e = y.e and x.f = y.f; count(*) 256 drop table t1; # restore disk->disk create table t1 ( a int unsigned primary key auto_increment, b text, c varchar(8000), d text, e varchar(20), f int ) engine=ndb tablespace ts1 storage disk; insert into t1 select * from t1old; select count(*) from t1 x, t1old y where x.a = y.a and x.b = y.b and x.c = y.c and x.d = y.d and x.e = y.e and x.f = y.f; count(*) 256 # run backup drop table t1; create table t1 ( e varchar(20), f int, a int unsigned primary key auto_increment, b varchar(8000), c text, d text ) engine=ndb tablespace ts1 storage disk; # run restore select count(*) from t1 x, t1old y where x.a = y.a and x.b = y.b and x.c = y.c and x.d = y.d and x.e = y.e and x.f = y.f; count(*) 256 drop table t1; drop table t1old; # bug#17235051 : hybrid failure create table t1 ( a int primary key, b varchar(5000), c varchar(5000) ) engine=ndb; insert into t1 values (1,null,null); select * from t1; a b c 1 NULL NULL # run backup drop table t1; create table t1 ( a int primary key, b text, c varchar(10000) ) engine=ndb; # run restore select * from t1; a b c 1 NULL NULL drop table t1; # Ignore dynamic column diffs between staging and 'main' # If backed-up had dynamic (due to online alter), and # new does not (due to lack of alter), staging table # should not care. create table t1( a int unsigned primary key, b varchar(6144) ) engine=ndb; # alter causing varchar to become 'dynamic' alter table t1 add column c int; Warnings: Warning 1478 Converted FIXED field 'c' to DYNAMIC to enable on-line ADD COLUMN show warnings; Level Code Message Warning 1478 Converted FIXED field 'c' to DYNAMIC to enable on-line ADD COLUMN insert into t1 values (1,repeat('b',2000), 10); insert into t1 values (2,repeat('t',2000), 20); insert into t1 values (3,repeat('g',2000), 30); # run backup rename table t1 to t1old; # create t1 with text + without alter (not dynamic by default) create table t1( a int unsigned primary key, b text, c int ) engine=ndb; # run restore select count(*) from t1 x, t1old y where x.a = y.a and x.b = y.b and x.c = y.c; count(*) 3 drop table t1old; drop table t1; # bug#18875137: ndb_restore type conversions # run restore with lossy conversions create table text2text (pk int primary key, t1 tinytext, t2 text, t3 mediumtext, t4 longtext, t5 tinytext, t6 text, t7 mediumtext, t8 longtext, t9 tinytext, t10 text, t11 mediumtext, t12 longtext, t13 tinytext, t14 text, t15 mediumtext, t16 longtext)engine=NDB; insert into text2text values(1, REPEAT("A",255), REPEAT("A",5000), REPEAT("A",65536), REPEAT("A", 30000), REPEAT("A",255), REPEAT("A",5000), REPEAT("A",65537), REPEAT("A", 30000), REPEAT("A",255), REPEAT("A",5000), REPEAT("A",65540), REPEAT("A", 30000), NULL, NULL, NULL, NULL); insert into text2text values(2, "", "", "", "", "", "", "", "", "", "", "", "", NULL, NULL, NULL, NULL); insert into text2text values(3, REPEAT(" -,.;",51), REPEAT(" -,.;",1000), REPEAT(" -,.;",2000), REPEAT(" -,.;", 6000), REPEAT(" -,.;",51), REPEAT(" -,.;",1000), REPEAT(" -,.;",2001), REPEAT(" -,.;", 6000), REPEAT(" -,.;",51), REPEAT(" -,.;",1000), REPEAT(" -,.;",2002), REPEAT(" -,.;", 6000), NULL, NULL, NULL, NULL); insert into text2text values(4, REPEAT("12345",51), REPEAT("12345",1000), REPEAT("12345",2000), REPEAT("12345", 6000), REPEAT("12345",51), REPEAT("12345",1000), REPEAT("12345",2001), REPEAT("12345", 6000), REPEAT("12345",51), REPEAT("12345",1000), REPEAT("12345",2002), REPEAT("12345", 6000), NULL, NULL, NULL, NULL); insert into text2text values(5, REPEAT("abcde",51), REPEAT("abcde",1000), REPEAT("abcde",2000), REPEAT("abcde", 6000), REPEAT("abcde",51), REPEAT("abcde",1000), REPEAT("abcde",2001), REPEAT("abcde", 6000), REPEAT("abcde",51), REPEAT("abcde",1000), REPEAT("abcde",2002), REPEAT("abcde", 6000), NULL, NULL, NULL, NULL); insert into text2text values(6, REPEAT(" ",51), REPEAT(" ",1000), REPEAT(" ",2000), REPEAT(" ", 6000), REPEAT(" ",51), REPEAT(" ",1000), REPEAT(" ",2001), REPEAT(" ", 6000), REPEAT(" ",51), REPEAT(" ",1000), REPEAT(" ",2002), REPEAT(" ", 6000), NULL, NULL, NULL, NULL); insert into text2text values(7, REPEAT("a%d4 ",51), REPEAT("a%d4 ",1000), REPEAT("a%d4 ",2000), REPEAT("a%d4 ", 6000), REPEAT("a%d4 ",51), REPEAT("a%d4 ",1000), REPEAT("a%d4 ",2001), REPEAT("a%d4 ", 6000), REPEAT("a%d4 ",51), REPEAT("a%d4 ",1000), REPEAT("a%d4 ",2002), REPEAT("a%d4 ", 6000), NULL, NULL, NULL, NULL); insert into text2text values(8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); # run backup drop table text2text; create table text2text (pk int primary key, t1 text, t2 mediumtext, t3 longtext, t4 tinytext, t5 mediumtext, t6 longtext, t7 tinytext, t8 text, t9 longtext, t10 tinytext, t11 text, t12 mediumtext, t13 text, t14 mediumtext, t15 longtext, t16 tinytext)engine=NDB; # run restore # run ndb_select_all to print restored table 1 255:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 5000:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 65536:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 256:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 255:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 5000:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 256:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 30000:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 255:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 256:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 65540:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 30000:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA [NULL] [NULL] [NULL] [NULL] 2 0: 0: 0: 0: 0: 0: 0: 0: 0: 0: 0: 0: [NULL] [NULL] [NULL] [NULL] 3 255: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 5000: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 10000: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 256: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 255: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 5000: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 256: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 30000: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 255: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 256: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 10010: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 30000: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; [NULL] [NULL] [NULL] [NULL] 4 255:123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345 5000:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 10000:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 256:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 255:123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345 5000:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 256:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 30000:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 255:123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345 256:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 10010:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 30000:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 [NULL] [NULL] [NULL] [NULL] 5 255:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcde 5000:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 10000:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 256:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 255:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcde 5000:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 256:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 30000:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 255:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcde 256:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 10010:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 30000:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea [NULL] [NULL] [NULL] [NULL] 6 255: 5000: 10000: 256: 255: 5000: 256: 30000: 255: 256: 10010: 30000: [NULL] [NULL] [NULL] [NULL] 7 255:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 5000:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 10000:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 256:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 255:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 5000:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 256:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 30000:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 255:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 256:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 10010:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 30000:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a [NULL] [NULL] [NULL] [NULL] 8 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 8 rows returned NDBT_ProgramExit: 0 - OK pk t1 t2 t3 t4 t5 t6 t7 t8 t9 t10 t11 t12 t13 t14 t15 t16 # run select query to see truncation in mysqld select LENGTH(t1), LENGTH(t2), LENGTH(t3), LENGTH(t4), LENGTH(t5), LENGTH(t6), LENGTH(t7), LENGTH(t8), LENGTH(t9), LENGTH(t10), LENGTH(t11), LENGTH(t12) from text2text order by pk; LENGTH(t1) LENGTH(t2) LENGTH(t3) LENGTH(t4) LENGTH(t5) LENGTH(t6) LENGTH(t7) LENGTH(t8) LENGTH(t9) LENGTH(t10) LENGTH(t11) LENGTH(t12) 255 5000 65536 255 255 5000 255 30000 255 255 65535 30000 0 0 0 0 0 0 0 0 0 0 0 0 255 5000 10000 255 255 5000 255 30000 255 255 10010 30000 255 5000 10000 255 255 5000 255 30000 255 255 10010 30000 255 5000 10000 255 255 5000 255 30000 255 255 10010 30000 255 5000 10000 255 255 5000 255 30000 255 255 10010 30000 255 5000 10000 255 255 5000 255 30000 255 255 10010 30000 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Warnings: Warning 1265 Truncated value from TEXT field 't4' Warning 1265 Truncated value from TEXT field 't7' Warning 1265 Truncated value from TEXT field 't10' Warning 1265 Truncated value from TEXT field 't11' Warning 1265 Truncated value from TEXT field 't4' Warning 1265 Truncated value from TEXT field 't7' Warning 1265 Truncated value from TEXT field 't10' Warning 1265 Truncated value from TEXT field 't4' Warning 1265 Truncated value from TEXT field 't7' Warning 1265 Truncated value from TEXT field 't10' Warning 1265 Truncated value from TEXT field 't4' Warning 1265 Truncated value from TEXT field 't7' Warning 1265 Truncated value from TEXT field 't10' Warning 1265 Truncated value from TEXT field 't4' Warning 1265 Truncated value from TEXT field 't7' Warning 1265 Truncated value from TEXT field 't10' Warning 1265 Truncated value from TEXT field 't4' Warning 1265 Truncated value from TEXT field 't7' Warning 1265 Truncated value from TEXT field 't10' # run restore with no lossy conversions drop table text2text; create table text2text (pk int primary key, t1 text, t2 mediumtext, t3 longtext, t4 tinytext, t5 mediumtext, t6 longtext, t7 tinytext, t8 text, t9 longtext, t10 tinytext, t11 text, t12 mediumtext, t13 text, t14 mediumtext, t15 longtext, t16 tinytext)engine=NDB; # run restore # ndb_restore fails with error 1 # ndb_restore fails with error 1 # restore NULL values into non-nullable columns drop table text2text; create table text2text (pk int primary key, t1 text not null, t2 mediumtext not null, t3 longtext not null, t4 tinytext not null, t5 mediumtext not null, t6 longtext not null, t7 tinytext not null, t8 text not null, t9 longtext not null, t10 tinytext not null, t11 text not null, t12 mediumtext not null, t13 text not null, t14 mediumtext not null, t15 longtext not null, t16 tinytext not null)engine=NDB; # run restore # ndb_restore fails with error 1 # ndb_restore fails with error 1 # restore to text column with different charset drop table text2text; create table text2text (pk int primary key, t1 text character set utf8, t2 mediumtext character set utf8, t3 longtext character set utf8, t4 tinytext character set utf8, t5 mediumtext character set utf8, t6 longtext character set utf8, t7 tinytext character set utf8, t8 text character set utf8, t9 longtext character set utf8, t10 tinytext character set utf8, t11 text character set utf8, t12 mediumtext character set utf8, t13 text character set utf8, t14 mediumtext character set utf8, t15 longtext character set utf8, t16 tinytext character set utf8)engine=NDB; # run restore # ndb_restore fails with error 1 # ndb_restore fails with error 1 # restore with mix of staging and built-in conversions drop table text2text; create table text2text (pk mediumint primary key, t1 text, t2 mediumtext, t3 longtext, t4 tinytext, t5 mediumtext, t6 longtext, t7 tinytext, t8 text, t9 longtext, t10 tinytext, t11 text, t12 mediumtext, t13 text, t14 mediumtext, t15 longtext, t16 tinytext)engine=NDB; # run restore # run ndb_select_all to print restored table 1 255:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 5000:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 65536:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 256:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 255:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 5000:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 256:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 30000:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 255:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 256:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 65540:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA 30000:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA [NULL] [NULL] [NULL] [NULL] 2 0: 0: 0: 0: 0: 0: 0: 0: 0: 0: 0: 0: [NULL] [NULL] [NULL] [NULL] 3 255: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 5000: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 10000: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 256: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 255: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 5000: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 256: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 30000: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 255: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 256: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 10010: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; 30000: -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; -,.; [NULL] [NULL] [NULL] [NULL] 4 255:123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345 5000:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 10000:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 256:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 255:123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345 5000:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 256:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 30000:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 255:123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345 256:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 10010:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 30000:1234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451234512345123451 [NULL] [NULL] [NULL] [NULL] 5 255:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcde 5000:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 10000:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 256:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 255:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcde 5000:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 256:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 30000:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 255:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcde 256:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 10010:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea 30000:abcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdeabcdea [NULL] [NULL] [NULL] [NULL] 6 255: 5000: 10000: 256: 255: 5000: 256: 30000: 255: 256: 10010: 30000: [NULL] [NULL] [NULL] [NULL] 7 255:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 5000:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 10000:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 256:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 255:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 5000:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 256:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 30000:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 255:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 256:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 10010:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a 30000:a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a%d4 a [NULL] [NULL] [NULL] [NULL] 8 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 8 rows returned NDBT_ProgramExit: 0 - OK pk t1 t2 t3 t4 t5 t6 t7 t8 t9 t10 t11 t12 t13 t14 t15 t16 drop table text2text; # restore with pk built-in conversion and blob staging conversion create table text2text(id char(10) primary key, val text)engine=ndb; insert into text2text values("1111111111", REPEAT("A", 500)); insert into text2text values("2222222222", REPEAT("B", 500)); # run backup drop table text2text; create table text2text(id varchar(5) primary key, val mediumtext)engine=ndb; # run restore # run ndb_select_all to print restored table "11111" 500:AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA "22222" 500:BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB 2 rows returned NDBT_ProgramExit: 0 - OK id val # ndb_restore TEXT -> TINYTEXT truncation with utf8 drop table text2text; set character_set_client=utf8; create table text2text(id int primary key, val text character set utf8)engine=ndb; insert into text2text values(11111, REPEAT(UNHEX("E38182"), 100)); insert into text2text values(22222, CONCAT("A",REPEAT(UNHEX("E38182"), 100))); # run backup drop table text2text; create table text2text(id int primary key, val tinytext character set utf8)engine=ndb; # run restore # run ndb_select_all to see charset-aware truncation in ndb 11111 255:あああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああああ # run mysql select to see charset-aware truncation in mysqld # truncation in pk-based read select length(val), char_length(val) from text2text where id = 22222; length(val) char_length(val) 253 85 Warnings: Warning 1265 Truncated value from TEXT field 'val' # truncation in scan select length(val), char_length(val) from text2text order by id; length(val) char_length(val) 255 85 253 85 Warnings: Warning 1265 Truncated value from TEXT field 'val' drop table text2text; # drop tablespace alter tablespace ts1 drop datafile 'datafile1.dat' engine=ndb; drop tablespace ts1 engine=ndb; drop logfile group lg1 engine=ndb;
Close
