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 | : 18.224.70.193
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_wl946_main.result
drop table if exists t1, t1sum; select @@session.time_zone; @@session.time_zone SYSTEM set time_zone = '+00:00'; select @@session.time_zone; @@session.time_zone +00:00 # create query summary table create table t1sum ( pk int primary key, cnt int unsigned not null, crc bigint unsigned ) engine=myisam; # PART 1: data load and queries # create table prec 3 create table t1 ( a int not null, b year not null default '2000', c date not null default '2000-01-02', d time(3) not null default '10:11:12.123', e datetime(3) not null default '2000-01-02 10:11:12.123', f timestamp(3) not null default '2000-01-02 10:11:12.123', primary key using hash (a), index bx (b), index cx (c), index dx (d), index ex (e), index fx (f) ) engine=ndb; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` year(4) NOT NULL DEFAULT '2000', `c` date NOT NULL DEFAULT '2000-01-02', `d` time(3) NOT NULL DEFAULT '10:11:12.123', `e` datetime(3) NOT NULL DEFAULT '2000-01-02 10:11:12.123', `f` timestamp(3) NOT NULL DEFAULT '2000-01-02 10:11:12.123', PRIMARY KEY (`a`) USING HASH, KEY `bx` (`b`), KEY `cx` (`c`), KEY `dx` (`d`), KEY `ex` (`e`), KEY `fx` (`f`) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 Attributes: a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY b Year NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000 c Date NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02 d Time2(3) NOT NULL AT=FIXED ST=MEMORY DEFAULT 10:11:12.123 e Datetime2(3) NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02/10:11:12.123 f Timestamp2(3) NOT NULL AT=FIXED ST=MEMORY DEFAULT 946807872.123 Indexes: bx(b) - OrderedIndex cx(c) - OrderedIndex dx(d) - OrderedIndex ex(e) - OrderedIndex fx(f) - OrderedIndex # test defaults insert into t1(a) values (0); select * from t1; a b c d e f 0 2000 2000-01-02 10:11:12.123 2000-01-02 10:11:12.123 2000-01-02 10:11:12.123 delete from t1; # load data load data local infile 'suite/ndb/data/wl946_main3.dat' into table t1 fields terminated by ',' lines terminated by '\n'; # check contents select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1; count(*) sum(crc32(concat(a,b,c,d,e,f))) 500 1099869477618 # verify ndb_select_all create temporary table t1tmp1 ( x char(255) ) engine=myisam; load data infile 'DUMP_FILE1' into table t1tmp1; delete from t1tmp1 where x not regexp '^[0-9]*,'; select x from t1tmp1 into outfile 'DUMP_FILE2'; create temporary table t1tmp2 ( a int primary key, b char(40), c char(40), d char(40), e char(40), f char(40) ) engine=myisam; load data infile 'DUMP_FILE2' into table t1tmp2 fields terminated by ',' lines terminated by '\n'; update t1tmp2 set f = replace(f, '\r', ''); select count(*), sum(crc32(concat(a,b,c,d,e,unix_timestamp(f)))) from t1; count(*) sum(crc32(concat(a,b,c,d,e,unix_timestamp(f)))) 500 1042802316591 select count(*), sum(crc32(concat(a,b,c,d,replace(e,'/',' '),f))) from t1tmp2; count(*) sum(crc32(concat(a,b,c,d,replace(e,'/',' '),f))) 500 1042802316591 drop table t1tmp1; drop table t1tmp2; # index queries select * from t1 where b = '2011'; a b c d e f 379 2011 2007-12-01 -13:38:50.785 8321-12-27 21:08:47.878 1979-12-28 20:02:06.999 select * from t1 where c = '2007-12-01'; a b c d e f 379 2011 2007-12-01 -13:38:50.785 8321-12-27 21:08:47.878 1979-12-28 20:02:06.999 select * from t1 where d = '-13:38:50.785'; a b c d e f 379 2011 2007-12-01 -13:38:50.785 8321-12-27 21:08:47.878 1979-12-28 20:02:06.999 select * from t1 where e = '8321-12-27 21:08:47.878'; a b c d e f 379 2011 2007-12-01 -13:38:50.785 8321-12-27 21:08:47.878 1979-12-28 20:02:06.999 select * from t1 where f = '1979-12-28 20:02:06.999'; a b c d e f 379 2011 2007-12-01 -13:38:50.785 8321-12-27 21:08:47.878 1979-12-28 20:02:06.999 select sum(cnt), sum(crc32(concat(cnt,crc))) from t1sum; sum(cnt) sum(crc32(concat(cnt,crc))) 69971 828138701178 # check results via myisam alter table t1 engine=myisam; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` year(4) NOT NULL DEFAULT '2000', `c` date NOT NULL DEFAULT '2000-01-02', `d` time(3) NOT NULL DEFAULT '10:11:12.123', `e` datetime(3) NOT NULL DEFAULT '2000-01-02 10:11:12.123', `f` timestamp(3) NOT NULL DEFAULT '2000-01-02 10:11:12.123', PRIMARY KEY (`a`) USING HASH, KEY `bx` (`b`), KEY `cx` (`c`), KEY `dx` (`d`), KEY `ex` (`e`), KEY `fx` (`f`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1; count(*) sum(crc32(concat(a,b,c,d,e,f))) 500 1099869477618 select * from t1 where b = '2011'; a b c d e f 379 2011 2007-12-01 -13:38:50.785 8321-12-27 21:08:47.878 1979-12-28 20:02:06.999 select * from t1 where c = '2007-12-01'; a b c d e f 379 2011 2007-12-01 -13:38:50.785 8321-12-27 21:08:47.878 1979-12-28 20:02:06.999 select * from t1 where d = '-13:38:50.785'; a b c d e f 379 2011 2007-12-01 -13:38:50.785 8321-12-27 21:08:47.878 1979-12-28 20:02:06.999 select * from t1 where e = '8321-12-27 21:08:47.878'; a b c d e f 379 2011 2007-12-01 -13:38:50.785 8321-12-27 21:08:47.878 1979-12-28 20:02:06.999 select * from t1 where f = '1979-12-28 20:02:06.999'; a b c d e f 379 2011 2007-12-01 -13:38:50.785 8321-12-27 21:08:47.878 1979-12-28 20:02:06.999 select sum(cnt), sum(crc32(concat(cnt,crc))) from t1sum; sum(cnt) sum(crc32(concat(cnt,crc))) 69971 828138701178 # drop table prec 3 drop table t1; # create table prec 6 create table t1 ( a int not null, b year not null default '2000', c date not null default '2000-01-02', d time(6) not null default '10:11:12.123456', e datetime(6) not null default '2000-01-02 10:11:12.123456', f timestamp(6) not null default '2000-01-02 10:11:12.123456', primary key using hash (a), index bx (b), index cx (c), index dx (d), index ex (e), index fx (f) ) engine=ndb; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` year(4) NOT NULL DEFAULT '2000', `c` date NOT NULL DEFAULT '2000-01-02', `d` time(6) NOT NULL DEFAULT '10:11:12.123456', `e` datetime(6) NOT NULL DEFAULT '2000-01-02 10:11:12.123456', `f` timestamp(6) NOT NULL DEFAULT '2000-01-02 10:11:12.123456', PRIMARY KEY (`a`) USING HASH, KEY `bx` (`b`), KEY `cx` (`c`), KEY `dx` (`d`), KEY `ex` (`e`), KEY `fx` (`f`) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 Attributes: a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY b Year NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000 c Date NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02 d Time2(6) NOT NULL AT=FIXED ST=MEMORY DEFAULT 10:11:12.123456 e Datetime2(6) NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02/10:11:12.123456 f Timestamp2(6) NOT NULL AT=FIXED ST=MEMORY DEFAULT 946807872.123456 Indexes: bx(b) - OrderedIndex cx(c) - OrderedIndex dx(d) - OrderedIndex ex(e) - OrderedIndex fx(f) - OrderedIndex # test defaults insert into t1(a) values (0); select * from t1; a b c d e f 0 2000 2000-01-02 10:11:12.123456 2000-01-02 10:11:12.123456 2000-01-02 10:11:12.123456 delete from t1; # load data load data local infile 'suite/ndb/data/wl946_main6.dat' into table t1 fields terminated by ',' lines terminated by '\n'; # check contents select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1; count(*) sum(crc32(concat(a,b,c,d,e,f))) 500 1091780159996 # verify ndb_select_all create temporary table t1tmp1 ( x char(255) ) engine=myisam; load data infile 'DUMP_FILE1' into table t1tmp1; delete from t1tmp1 where x not regexp '^[0-9]*,'; select x from t1tmp1 into outfile 'DUMP_FILE2'; create temporary table t1tmp2 ( a int primary key, b char(40), c char(40), d char(40), e char(40), f char(40) ) engine=myisam; load data infile 'DUMP_FILE2' into table t1tmp2 fields terminated by ',' lines terminated by '\n'; update t1tmp2 set f = replace(f, '\r', ''); select count(*), sum(crc32(concat(a,b,c,d,e,unix_timestamp(f)))) from t1; count(*) sum(crc32(concat(a,b,c,d,e,unix_timestamp(f)))) 500 1102908582969 select count(*), sum(crc32(concat(a,b,c,d,replace(e,'/',' '),f))) from t1tmp2; count(*) sum(crc32(concat(a,b,c,d,replace(e,'/',' '),f))) 500 1102908582969 drop table t1tmp1; drop table t1tmp2; # index queries select * from t1 where b = '1984'; a b c d e f 95 1984 2099-12-21 15:11:51.840792 1917-01-19 09:13:16.715589 2032-03-16 20:53:59.869710 select * from t1 where c = '2099-12-21'; a b c d e f 95 1984 2099-12-21 15:11:51.840792 1917-01-19 09:13:16.715589 2032-03-16 20:53:59.869710 select * from t1 where d = '15:11:51.840792'; a b c d e f 95 1984 2099-12-21 15:11:51.840792 1917-01-19 09:13:16.715589 2032-03-16 20:53:59.869710 select * from t1 where e = '1917-01-19 09:13:16.715589'; a b c d e f 95 1984 2099-12-21 15:11:51.840792 1917-01-19 09:13:16.715589 2032-03-16 20:53:59.869710 select * from t1 where f = '2032-03-16 20:53:59.869710'; a b c d e f 95 1984 2099-12-21 15:11:51.840792 1917-01-19 09:13:16.715589 2032-03-16 20:53:59.869710 select sum(cnt), sum(crc32(concat(cnt,crc))) from t1sum; sum(cnt) sum(crc32(concat(cnt,crc))) 69575 874482681592 # check results via myisam alter table t1 engine=myisam; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` year(4) NOT NULL DEFAULT '2000', `c` date NOT NULL DEFAULT '2000-01-02', `d` time(6) NOT NULL DEFAULT '10:11:12.123456', `e` datetime(6) NOT NULL DEFAULT '2000-01-02 10:11:12.123456', `f` timestamp(6) NOT NULL DEFAULT '2000-01-02 10:11:12.123456', PRIMARY KEY (`a`) USING HASH, KEY `bx` (`b`), KEY `cx` (`c`), KEY `dx` (`d`), KEY `ex` (`e`), KEY `fx` (`f`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1; count(*) sum(crc32(concat(a,b,c,d,e,f))) 500 1091780159996 select * from t1 where b = '1984'; a b c d e f 95 1984 2099-12-21 15:11:51.840792 1917-01-19 09:13:16.715589 2032-03-16 20:53:59.869710 select * from t1 where c = '2099-12-21'; a b c d e f 95 1984 2099-12-21 15:11:51.840792 1917-01-19 09:13:16.715589 2032-03-16 20:53:59.869710 select * from t1 where d = '15:11:51.840792'; a b c d e f 95 1984 2099-12-21 15:11:51.840792 1917-01-19 09:13:16.715589 2032-03-16 20:53:59.869710 select * from t1 where e = '1917-01-19 09:13:16.715589'; a b c d e f 95 1984 2099-12-21 15:11:51.840792 1917-01-19 09:13:16.715589 2032-03-16 20:53:59.869710 select * from t1 where f = '2032-03-16 20:53:59.869710'; a b c d e f 95 1984 2099-12-21 15:11:51.840792 1917-01-19 09:13:16.715589 2032-03-16 20:53:59.869710 select sum(cnt), sum(crc32(concat(cnt,crc))) from t1sum; sum(cnt) sum(crc32(concat(cnt,crc))) 69575 874482681592 # drop table prec 6 drop table t1; # PART 2: backup and restore # create table prec 3 create table t1 ( a int not null, b year not null default '2000', c date not null default '2000-01-02', d time(3) not null default '10:11:12.123', e datetime(3) not null default '2000-01-02 10:11:12.123', f timestamp(3) not null default '2000-01-02 10:11:12.123', primary key using hash (a), index bx (b), index cx (c), index dx (d), index ex (e), index fx (f) ) engine=ndb; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` year(4) NOT NULL DEFAULT '2000', `c` date NOT NULL DEFAULT '2000-01-02', `d` time(3) NOT NULL DEFAULT '10:11:12.123', `e` datetime(3) NOT NULL DEFAULT '2000-01-02 10:11:12.123', `f` timestamp(3) NOT NULL DEFAULT '2000-01-02 10:11:12.123', PRIMARY KEY (`a`) USING HASH, KEY `bx` (`b`), KEY `cx` (`c`), KEY `dx` (`d`), KEY `ex` (`e`), KEY `fx` (`f`) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 Attributes: a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY b Year NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000 c Date NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02 d Time2(3) NOT NULL AT=FIXED ST=MEMORY DEFAULT 10:11:12.123 e Datetime2(3) NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02/10:11:12.123 f Timestamp2(3) NOT NULL AT=FIXED ST=MEMORY DEFAULT 946807872.123 Indexes: bx(b) - OrderedIndex cx(c) - OrderedIndex dx(d) - OrderedIndex ex(e) - OrderedIndex fx(f) - OrderedIndex # load data load data local infile 'suite/ndb/data/wl946_main3.dat' into table t1 fields terminated by ',' lines terminated by '\n'; # run backup # drop table prec 3 drop table t1; # restore meta from backup show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` year(4) NOT NULL DEFAULT '2000', `c` date NOT NULL DEFAULT '2000-01-02', `d` time(3) NOT NULL DEFAULT '10:11:12.123', `e` datetime(3) NOT NULL DEFAULT '2000-01-02 10:11:12.123', `f` timestamp(3) NOT NULL DEFAULT '2000-01-02 10:11:12.123', PRIMARY KEY (`a`) USING HASH, KEY `bx` (`b`), KEY `cx` (`c`), KEY `dx` (`d`), KEY `ex` (`e`), KEY `fx` (`f`) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 Attributes: a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY b Year NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000 c Date NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02 d Time2(3) NOT NULL AT=FIXED ST=MEMORY DEFAULT 10:11:12.123 e Datetime2(3) NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02/10:11:12.123 f Timestamp2(3) NOT NULL AT=FIXED ST=MEMORY DEFAULT 946807872.123 Indexes: bx(b) - OrderedIndex cx(c) - OrderedIndex dx(d) - OrderedIndex ex(e) - OrderedIndex fx(f) - OrderedIndex # restore data from backup # check contents select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1; count(*) sum(crc32(concat(a,b,c,d,e,f))) 500 1099869477618 # drop table prec 3 drop table t1; # create table prec 6 create table t1 ( a int not null, b year not null default '2000', c date not null default '2000-01-02', d time(6) not null default '10:11:12.123456', e datetime(6) not null default '2000-01-02 10:11:12.123456', f timestamp(6) not null default '2000-01-02 10:11:12.123456', primary key using hash (a), index bx (b), index cx (c), index dx (d), index ex (e), index fx (f) ) engine=ndb; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` year(4) NOT NULL DEFAULT '2000', `c` date NOT NULL DEFAULT '2000-01-02', `d` time(6) NOT NULL DEFAULT '10:11:12.123456', `e` datetime(6) NOT NULL DEFAULT '2000-01-02 10:11:12.123456', `f` timestamp(6) NOT NULL DEFAULT '2000-01-02 10:11:12.123456', PRIMARY KEY (`a`) USING HASH, KEY `bx` (`b`), KEY `cx` (`c`), KEY `dx` (`d`), KEY `ex` (`e`), KEY `fx` (`f`) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 Attributes: a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY b Year NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000 c Date NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02 d Time2(6) NOT NULL AT=FIXED ST=MEMORY DEFAULT 10:11:12.123456 e Datetime2(6) NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02/10:11:12.123456 f Timestamp2(6) NOT NULL AT=FIXED ST=MEMORY DEFAULT 946807872.123456 Indexes: bx(b) - OrderedIndex cx(c) - OrderedIndex dx(d) - OrderedIndex ex(e) - OrderedIndex fx(f) - OrderedIndex # load data load data local infile 'suite/ndb/data/wl946_main6.dat' into table t1 fields terminated by ',' lines terminated by '\n'; # run backup # drop table prec 6 drop table t1; # restore meta from backup show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` year(4) NOT NULL DEFAULT '2000', `c` date NOT NULL DEFAULT '2000-01-02', `d` time(6) NOT NULL DEFAULT '10:11:12.123456', `e` datetime(6) NOT NULL DEFAULT '2000-01-02 10:11:12.123456', `f` timestamp(6) NOT NULL DEFAULT '2000-01-02 10:11:12.123456', PRIMARY KEY (`a`) USING HASH, KEY `bx` (`b`), KEY `cx` (`c`), KEY `dx` (`d`), KEY `ex` (`e`), KEY `fx` (`f`) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 Attributes: a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY b Year NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000 c Date NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02 d Time2(6) NOT NULL AT=FIXED ST=MEMORY DEFAULT 10:11:12.123456 e Datetime2(6) NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02/10:11:12.123456 f Timestamp2(6) NOT NULL AT=FIXED ST=MEMORY DEFAULT 946807872.123456 Indexes: bx(b) - OrderedIndex cx(c) - OrderedIndex dx(d) - OrderedIndex ex(e) - OrderedIndex fx(f) - OrderedIndex # restore data from backup # check contents select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1; count(*) sum(crc32(concat(a,b,c,d,e,f))) 500 1091780159996 # check contents truncated to prec 3 drop table if exists t1tmp; create temporary table t1tmp ( x char(255) ) engine=myisam; insert into t1tmp select concat(a,b,c,left(d,length(d)-3),left(e,length(e)-3),left(f,length(f)-3)) from t1; select count(*), sum(crc32(x)) from t1tmp; count(*) sum(crc32(x)) 500 992449343770 drop table t1tmp; # drop table prec 6 drop table t1; # PART 3: restore with data promote and demote # create table prec 6 create table t1 ( a int not null, b year not null default '2000', c date not null default '2000-01-02', d time(6) not null default '10:11:12.123456', e datetime(6) not null default '2000-01-02 10:11:12.123456', f timestamp(6) not null default '2000-01-02 10:11:12.123456', primary key using hash (a), index bx (b), index cx (c), index dx (d), index ex (e), index fx (f) ) engine=ndb; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` year(4) NOT NULL DEFAULT '2000', `c` date NOT NULL DEFAULT '2000-01-02', `d` time(6) NOT NULL DEFAULT '10:11:12.123456', `e` datetime(6) NOT NULL DEFAULT '2000-01-02 10:11:12.123456', `f` timestamp(6) NOT NULL DEFAULT '2000-01-02 10:11:12.123456', PRIMARY KEY (`a`) USING HASH, KEY `bx` (`b`), KEY `cx` (`c`), KEY `dx` (`d`), KEY `ex` (`e`), KEY `fx` (`f`) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 Attributes: a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY b Year NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000 c Date NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02 d Time2(6) NOT NULL AT=FIXED ST=MEMORY DEFAULT 10:11:12.123456 e Datetime2(6) NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02/10:11:12.123456 f Timestamp2(6) NOT NULL AT=FIXED ST=MEMORY DEFAULT 946807872.123456 Indexes: bx(b) - OrderedIndex cx(c) - OrderedIndex dx(d) - OrderedIndex ex(e) - OrderedIndex fx(f) - OrderedIndex # restore data from backup with promote # check contents select count(*), sum(crc32(replace(concat(a,b,c,d,e,f),".000","."))) from t1; count(*) sum(crc32(replace(concat(a,b,c,d,e,f),".000","."))) 500 1099869477618 # drop table prec 6 drop table t1; # create table prec 3 create table t1 ( a int not null, b year not null default '2000', c date not null default '2000-01-02', d time(3) not null default '10:11:12.123', e datetime(3) not null default '2000-01-02 10:11:12.123', f timestamp(3) not null default '2000-01-02 10:11:12.123', primary key using hash (a), index bx (b), index cx (c), index dx (d), index ex (e), index fx (f) ) engine=ndb; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) NOT NULL, `b` year(4) NOT NULL DEFAULT '2000', `c` date NOT NULL DEFAULT '2000-01-02', `d` time(3) NOT NULL DEFAULT '10:11:12.123', `e` datetime(3) NOT NULL DEFAULT '2000-01-02 10:11:12.123', `f` timestamp(3) NOT NULL DEFAULT '2000-01-02 10:11:12.123', PRIMARY KEY (`a`) USING HASH, KEY `bx` (`b`), KEY `cx` (`c`), KEY `dx` (`d`), KEY `ex` (`e`), KEY `fx` (`f`) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1 Attributes: a Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY b Year NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000 c Date NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02 d Time2(3) NOT NULL AT=FIXED ST=MEMORY DEFAULT 10:11:12.123 e Datetime2(3) NOT NULL AT=FIXED ST=MEMORY DEFAULT 2000-01-02/10:11:12.123 f Timestamp2(3) NOT NULL AT=FIXED ST=MEMORY DEFAULT 946807872.123 Indexes: bx(b) - OrderedIndex cx(c) - OrderedIndex dx(d) - OrderedIndex ex(e) - OrderedIndex fx(f) - OrderedIndex # restore data from backup with demote # check contents truncated to prec 3 select count(*), sum(crc32(concat(a,b,c,d,e,f))) from t1; count(*) sum(crc32(concat(a,b,c,d,e,f))) 500 992449343770 set time_zone = default; select @@session.time_zone; @@session.time_zone SYSTEM drop table t1, t1sum;
Close