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.217.142.228
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 /
t /
[ HOME SHELL ]
Name
Size
Permission
Action
bug36547.test
596
B
-rw-r--r--
clusterj.cnf
169
B
-rw-r--r--
clusterj.test
2.28
KB
-rw-r--r--
clusterj_jpa.test
2.71
KB
-rw-r--r--
disabled.def
1.36
KB
-rw-r--r--
have_ndb_dist_priv.inc
944
B
-rw-r--r--
have_ndb_error_insert.inc
931
B
-rw-r--r--
loaddata_autocom_ndb.test
308
B
-rw-r--r--
ndb_add_partition.cnf
594
B
-rw-r--r--
ndb_add_partition.test
13.3
KB
-rw-r--r--
ndb_addnode.cnf
665
B
-rw-r--r--
ndb_addnode.test
5.12
KB
-rw-r--r--
ndb_addnode_restart.cnf
79
B
-rw-r--r--
ndb_addnode_restart.test
299
B
-rw-r--r--
ndb_addnode_restart2.cnf
79
B
-rw-r--r--
ndb_addnode_restart2.test
465
B
-rw-r--r--
ndb_addnode_withbinlog.cnf
869
B
-rw-r--r--
ndb_addnode_withbinlog.test
1.18
KB
-rw-r--r--
ndb_alter_table.test
18.09
KB
-rw-r--r--
ndb_alter_table2.test
1.52
KB
-rw-r--r--
ndb_alter_table3.test
1.68
KB
-rw-r--r--
ndb_alter_table_backup.test
1.73
KB
-rw-r--r--
ndb_alter_table_dml.test
2.8
KB
-rw-r--r--
ndb_alter_table_error.test
1.15
KB
-rw-r--r--
ndb_alter_table_online.test
24.07
KB
-rw-r--r--
ndb_alter_table_online2.test
6.24
KB
-rw-r--r--
ndb_alter_table_online_multi.t...
2.08
KB
-rw-r--r--
ndb_auto_increment.test
12.89
KB
-rw-r--r--
ndb_autoinc.test
2.05
KB
-rw-r--r--
ndb_backup_rate.cnf
286
B
-rw-r--r--
ndb_backup_rate.test
2.35
KB
-rw-r--r--
ndb_basic.test
21.28
KB
-rw-r--r--
ndb_bitfield.test
6.54
KB
-rw-r--r--
ndb_blob.test
18.61
KB
-rw-r--r--
ndb_blob_big.cnf
380
B
-rw-r--r--
ndb_blob_big.test
1.83
KB
-rw-r--r--
ndb_blob_partition.test
4.49
KB
-rw-r--r--
ndb_bug13563280.test
743
B
-rw-r--r--
ndb_bug14166590.cnf
63
B
-rw-r--r--
ndb_bug14166590.test
1.45
KB
-rw-r--r--
ndb_bug17624736.cnf
110
B
-rw-r--r--
ndb_bug17624736.test
2.15
KB
-rw-r--r--
ndb_bug17719439.cnf
63
B
-rw-r--r--
ndb_bug17719439.test
1.34
KB
-rw-r--r--
ndb_bug19390895.cnf
272
B
-rw-r--r--
ndb_bug19390895.test
1.06
KB
-rw-r--r--
ndb_bug26793.test
1.06
KB
-rw-r--r--
ndb_bug31477.test
2.33
KB
-rw-r--r--
ndb_bulk_delete.test
4.13
KB
-rw-r--r--
ndb_bushy_joins.cnf
476
B
-rw-r--r--
ndb_bushy_joins.test
9.03
KB
-rw-r--r--
ndb_cache.cnf
201
B
-rw-r--r--
ndb_cache.test
8.13
KB
-rw-r--r--
ndb_cache2.cnf
23
B
-rw-r--r--
ndb_cache2.test
11.26
KB
-rw-r--r--
ndb_cache_multi.cnf
23
B
-rw-r--r--
ndb_cache_multi.test
2.09
KB
-rw-r--r--
ndb_cache_multi2.cnf
23
B
-rw-r--r--
ndb_cache_multi2.test
4.5
KB
-rw-r--r--
ndb_cache_trans.cnf
23
B
-rw-r--r--
ndb_cache_trans.test
4.85
KB
-rw-r--r--
ndb_charset.test
6.63
KB
-rw-r--r--
ndb_checksum.cnf
50
B
-rw-r--r--
ndb_checksum.test
77
B
-rw-r--r--
ndb_column_properties.test
4.71
KB
-rw-r--r--
ndb_condition_pushdown.test
85.29
KB
-rw-r--r--
ndb_config.test
4.16
KB
-rw-r--r--
ndb_config2.test
514
B
-rw-r--r--
ndb_create_table.test
1005
B
-rw-r--r--
ndb_cursor.test
1.1
KB
-rw-r--r--
ndb_database.test
3.18
KB
-rw-r--r--
ndb_dbug_lock.test
2.15
KB
-rw-r--r--
ndb_dbug_tc_select.test
4.03
KB
-rw-r--r--
ndb_dbug_tc_select_1.inc
1.83
KB
-rw-r--r--
ndb_dbug_tc_select_2.inc
1.91
KB
-rw-r--r--
ndb_dbug_tc_select_3.inc
2.06
KB
-rw-r--r--
ndb_dd_alter.test
9
KB
-rw-r--r--
ndb_dd_basic.test
20.93
KB
-rw-r--r--
ndb_dd_bug12581213.cnf
111
B
-rw-r--r--
ndb_dd_bug12581213.test
580
B
-rw-r--r--
ndb_dd_ddl.test
8.07
KB
-rw-r--r--
ndb_dd_disk2memory.test
10.4
KB
-rw-r--r--
ndb_dd_dump.test
10.79
KB
-rw-r--r--
ndb_dd_initial_lg.cnf
796
B
-rw-r--r--
ndb_dd_initial_lg.test
1.11
KB
-rw-r--r--
ndb_dd_restore_check_tablespac...
12.25
KB
-rw-r--r--
ndb_dd_restore_compat.test
1.13
KB
-rw-r--r--
ndb_dd_sql_features.test
16.35
KB
-rw-r--r--
ndb_ddl_open_trans.test
3.03
KB
-rw-r--r--
ndb_disconnect_ddl.test
1.52
KB
-rw-r--r--
ndb_discover_db-master.opt
43
B
-rw-r--r--
ndb_discover_db.test
3.41
KB
-rw-r--r--
ndb_dist_priv.test
10.53
KB
-rw-r--r--
ndb_dist_priv_bug_13340854.tes...
1.31
KB
-rw-r--r--
ndb_err4012.test
2.79
KB
-rw-r--r--
ndb_error_reporter.ini
288
B
-rw-r--r--
ndb_error_reporter.test
3.3
KB
-rw-r--r--
ndb_fired_trigger_shortage.cnf
60
B
-rw-r--r--
ndb_fired_trigger_shortage.tes...
1.31
KB
-rw-r--r--
ndb_fk_addnode.cnf
931
B
-rw-r--r--
ndb_fk_addnode.test
2.07
KB
-rw-r--r--
ndb_fk_alter.test
3.95
KB
-rw-r--r--
ndb_fk_bugs.test
20.95
KB
-rw-r--r--
ndb_fk_build.test
2.18
KB
-rw-r--r--
ndb_fk_cascade_delete.test
3.86
KB
-rw-r--r--
ndb_fk_cascade_delete_multi.te...
1.96
KB
-rw-r--r--
ndb_fk_cascade_update.test
1.37
KB
-rw-r--r--
ndb_fk_create_drop.test
2.55
KB
-rw-r--r--
ndb_fk_db.test
2.59
KB
-rw-r--r--
ndb_fk_deferred_cascade.test
2.81
KB
-rw-r--r--
ndb_fk_disable.test
11.61
KB
-rw-r--r--
ndb_fk_is.inc
2.59
KB
-rw-r--r--
ndb_fk_is.test
161
B
-rw-r--r--
ndb_fk_locase.cnf
63
B
-rw-r--r--
ndb_fk_locase.test
1.54
KB
-rw-r--r--
ndb_fk_locking.test
2.1
KB
-rw-r--r--
ndb_fk_multi_column.test
1.5
KB
-rw-r--r--
ndb_fk_mysqldump.test
1.32
KB
-rw-r--r--
ndb_fk_mysqldump2.test
1.76
KB
-rw-r--r--
ndb_fk_no_fk.test
25.97
KB
-rw-r--r--
ndb_fk_no_fk_compat.inc
3.94
KB
-rw-r--r--
ndb_fk_no_fk_legacy.test
112
B
-rw-r--r--
ndb_fk_no_fk_ndb-master.opt
49
B
-rw-r--r--
ndb_fk_no_fk_ndb.test
139
B
-rw-r--r--
ndb_fk_noaction.test
4.78
KB
-rw-r--r--
ndb_fk_resources.cnf
91
B
-rw-r--r--
ndb_fk_resources.test
1.44
KB
-rw-r--r--
ndb_fk_restore.inc
2.9
KB
-rw-r--r--
ndb_fk_restore.test
3.63
KB
-rw-r--r--
ndb_fk_restrict.test
5.19
KB
-rw-r--r--
ndb_fk_self_ref.test
3.85
KB
-rw-r--r--
ndb_fk_setdefault.test
982
B
-rw-r--r--
ndb_fk_setnull.test
2.43
KB
-rw-r--r--
ndb_global_schema_lock.test
3.71
KB
-rw-r--r--
ndb_global_schema_lock_error.t...
1.73
KB
-rw-r--r--
ndb_grant.later
10.98
KB
-rw-r--r--
ndb_hashmap.cnf
61
B
-rw-r--r--
ndb_hashmap.test
821
B
-rw-r--r--
ndb_hidden_pk.test
2.76
KB
-rw-r--r--
ndb_index.test
13.42
KB
-rw-r--r--
ndb_index_ordered.test
15.67
KB
-rw-r--r--
ndb_index_stat.test
11.05
KB
-rw-r--r--
ndb_index_stat_enable.inc
1.18
KB
-rw-r--r--
ndb_index_stat_partitions-mast...
70
B
-rw-r--r--
ndb_index_stat_partitions.test
4.27
KB
-rw-r--r--
ndb_index_stat_restart.test
2.47
KB
-rw-r--r--
ndb_index_unique.test
16.63
KB
-rw-r--r--
ndb_init_schema_locks_count.in...
325
B
-rw-r--r--
ndb_insert.test
37.01
KB
-rw-r--r--
ndb_join_pushdown.inc
131.68
KB
-rw-r--r--
ndb_join_pushdown_bka.test
2.98
KB
-rw-r--r--
ndb_join_pushdown_default.test
356
B
-rw-r--r--
ndb_join_pushdown_nobnl.test
464
B
-rw-r--r--
ndb_join_pushdown_none.test
1.15
KB
-rw-r--r--
ndb_jtie.test
1.17
KB
-rw-r--r--
ndb_limit.test
2.44
KB
-rw-r--r--
ndb_load.test
2.33
KB
-rw-r--r--
ndb_loaddatalocal.test
2.63
KB
-rw-r--r--
ndb_lock.test
5.89
KB
-rw-r--r--
ndb_lock_table.test
494
B
-rw-r--r--
ndb_many_fragments.cnf
433
B
-rw-r--r--
ndb_many_fragments.test
1.91
KB
-rw-r--r--
ndb_mgm.cnf
172
B
-rw-r--r--
ndb_mgm.inc
130
B
-rw-r--r--
ndb_mgm.test
7.38
KB
-rw-r--r--
ndb_mgmd.cnf
99
B
-rw-r--r--
ndb_mgmd.test
637
B
-rw-r--r--
ndb_minmax.test
1.48
KB
-rw-r--r--
ndb_multi.test
11.13
KB
-rw-r--r--
ndb_multi_row.test
1.99
KB
-rw-r--r--
ndb_multi_update_delete.test
2.02
KB
-rw-r--r--
ndb_native_default_support.tes...
27.65
KB
-rw-r--r--
ndb_one_fragment.cnf
443
B
-rw-r--r--
ndb_one_fragment.test
3.14
KB
-rw-r--r--
ndb_optimize_table.test
2.65
KB
-rw-r--r--
ndb_optimized_node_selection.t...
1.09
KB
-rw-r--r--
ndb_partition_error.test
2.04
KB
-rw-r--r--
ndb_partition_error2.test
579
B
-rw-r--r--
ndb_partition_hash.test
1.73
KB
-rw-r--r--
ndb_partition_key.test
7.85
KB
-rw-r--r--
ndb_partition_list.test
2.88
KB
-rw-r--r--
ndb_partition_range.test
8.11
KB
-rw-r--r--
ndb_print_file.test
1.35
KB
-rw-r--r--
ndb_rbwr.inc
2.13
KB
-rw-r--r--
ndb_rbwr.test
11.15
KB
-rw-r--r--
ndb_read_multi_range.test
14.9
KB
-rw-r--r--
ndb_reconnect.test
4.03
KB
-rw-r--r--
ndb_rename.test
1.19
KB
-rw-r--r--
ndb_replace.test
4.34
KB
-rw-r--r--
ndb_restart_nostart.inc
147
B
-rw-r--r--
ndb_restart_start.inc
130
B
-rw-r--r--
ndb_restore_bug17916243.test
1.21
KB
-rw-r--r--
ndb_restore_compat_compression...
46
B
-rw-r--r--
ndb_restore_compat_compression...
799
B
-rw-r--r--
ndb_restore_compat_downward.te...
4.21
KB
-rw-r--r--
ndb_restore_compat_endianness....
6.94
KB
-rw-r--r--
ndb_restore_conv_lossy_charbin...
17.35
KB
-rw-r--r--
ndb_restore_conv_lossy_integra...
23.02
KB
-rw-r--r--
ndb_restore_conv_more.test
20.65
KB
-rw-r--r--
ndb_restore_conv_padding.test
9.58
KB
-rw-r--r--
ndb_restore_conv_promotion.tes...
12.91
KB
-rw-r--r--
ndb_restore_discover.test
1.72
KB
-rw-r--r--
ndb_restore_misc.cnf
147
B
-rw-r--r--
ndb_restore_misc.test
27.44
KB
-rw-r--r--
ndb_restore_print.test
6.98
KB
-rw-r--r--
ndb_restore_schema_blobs.test
4.43
KB
-rw-r--r--
ndb_restore_schema_partitions....
15.04
KB
-rw-r--r--
ndb_restore_schema_rewrites.te...
16.47
KB
-rw-r--r--
ndb_restore_schema_subsets.tes...
11.14
KB
-rw-r--r--
ndb_restore_schema_tolerance.t...
6.72
KB
-rw-r--r--
ndb_restore_undolog.cnf
509
B
-rw-r--r--
ndb_restore_undolog.test
16.89
KB
-rw-r--r--
ndb_row_count.test
3.16
KB
-rw-r--r--
ndb_row_format.test
2.28
KB
-rw-r--r--
ndb_schema_locks_count.inc
308
B
-rw-r--r--
ndb_select_count.test
574
B
-rw-r--r--
ndb_share.cnf
652
B
-rw-r--r--
ndb_share.test
9.86
KB
-rw-r--r--
ndb_short_sigs.cnf
170
B
-rw-r--r--
ndb_short_sigs.test
2.7
KB
-rw-r--r--
ndb_show_tables_result.inc
768
B
-rw-r--r--
ndb_single_user-master.opt
32
B
-rw-r--r--
ndb_single_user.test
4.92
KB
-rw-r--r--
ndb_sp.test
1.09
KB
-rw-r--r--
ndb_spj_dict.test
9.25
KB
-rw-r--r--
ndb_sql_allow_batching.test
1.33
KB
-rw-r--r--
ndb_startup.test
2.01
KB
-rw-r--r--
ndb_statistics.inc
3.31
KB
-rw-r--r--
ndb_statistics0.test
613
B
-rw-r--r--
ndb_statistics1.test
612
B
-rw-r--r--
ndb_subquery.test
7.14
KB
-rw-r--r--
ndb_suma_handover.cnf
324
B
-rw-r--r--
ndb_suma_handover.test
1.62
KB
-rw-r--r--
ndb_temporary.test
1.3
KB
-rw-r--r--
ndb_tmp_table_and_DDL.test
603
B
-rw-r--r--
ndb_transaction.test
5.97
KB
-rw-r--r--
ndb_trigger.test
8.98
KB
-rw-r--r--
ndb_truncate.test
1004
B
-rw-r--r--
ndb_types.test
4.9
KB
-rw-r--r--
ndb_update.test
2.94
KB
-rw-r--r--
ndb_update_no_read.test
17.18
KB
-rw-r--r--
ndb_view.test
817
B
-rw-r--r--
ndb_wait_nostart.inc
103
B
-rw-r--r--
ndb_wait_started.inc
84
B
-rw-r--r--
ndb_wait_until_ready.cnf
544
B
-rw-r--r--
ndb_wait_until_ready.test
4.19
KB
-rw-r--r--
ndb_waiter.inc
148
B
-rw-r--r--
ndb_wl946_create.inc
449
B
-rw-r--r--
ndb_wl946_main.test
7.1
KB
-rw-r--r--
ndb_wl946_main_query.inc
66.38
KB
-rw-r--r--
ndb_wl946_post.test
2.67
KB
-rw-r--r--
ndb_wl946_pre.test
2.67
KB
-rw-r--r--
ndb_wl946_pre_query.inc
589
B
-rw-r--r--
ndb_wl946_select_all.inc
1.41
KB
-rw-r--r--
ndbapi-examples.test
3.29
KB
-rw-r--r--
ndbinfo.test
24.32
KB
-rw-r--r--
ndbinfo_cache.cnf
23
B
-rw-r--r--
ndbinfo_cache.test
882
B
-rw-r--r--
ndbinfo_dump.test
780
B
-rw-r--r--
ndbinfo_upgrade.test
1.15
KB
-rw-r--r--
ps_7ndb.test
1.08
KB
-rw-r--r--
show_attributes.inc
664
B
-rw-r--r--
show_indexes.inc
674
B
-rw-r--r--
show_primary_keys.inc
609
B
-rw-r--r--
show_varpart.inc
762
B
-rw-r--r--
strict_autoinc_5ndb.test
356
B
-rw-r--r--
test_debugger.test
267
B
-rw-r--r--
test_mgm.test
262
B
-rw-r--r--
test_mgmd.cnf
232
B
-rw-r--r--
test_mgmd.test
473
B
-rw-r--r--
test_ndbinfo.test
439
B
-rw-r--r--
wl10837.test
274
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : ndb_restore_undolog.test
# The include statement below is a temp one for tests that are yet to #be ported to run with InnoDB, #but needs to be kept for tests that would need MyISAM in future. --source include/force_myisam_default.inc -- source include/have_ndb.inc # Directory containing the saved backup files let $backup_data_dir=$MYSQL_TEST_DIR/suite/ndb/backups; # # The table structure and data list below # ############################################## ##### for basic test with all data type ##### ############################################## # CREATE TABLE t_num ( # t_pk INT PRIMARY KEY, # t_test INT, # t_bit BIT(64), # t_tinyint TINYINT, # t_bool BOOL, # t_smallint SMALLINT, # t_mediumint MEDIUMINT, # t_int INT, # t_bigint BIGINT, # t_float FLOAT, # t_double DOUBLE, # t_decimal DECIMAL (37, 16) # ) ENGINE=NDBCLUSTER; # # INSERT INTO t_num VALUE ( # 1, # 1, # b'1010101010101010101010101010101010101010101010101010101010101010', # 125, # 1, # 32765, # 8388606, # 2147483647, # 9223372036854775807, # 1e+20, # 1e+150, # '331.0000000000' # ); # INSERT INTO t_num VALUE ( # 2, # 1, # b'1010101010101010101010101010101010101010101010101010101010101010', # 125, # 1, # 32765, # 8388606, # 2147483647, # 9223372036854775807, # 1e+20, # 1e+150, # '331.0000000000' # ); # CREATE TABLE t_datetime ( # t_pk INT PRIMARY KEY, # t_test INT, # t_date DATE, # t_datetime DATETIME, # t_timestamp TIMESTAMP, # t_time TIME, # t_year YEAR # ) ENGINE=NDBCLUSTER; # # INSERT INTO t_datetime VALUE ( # 1, # 1, # '1998-01-01', # '2006-08-10 10:11:12', # 20021029165106, # '19:38:34', # 2155 # ); # INSERT INTO t_datetime VALUE ( # 2, # 1, # '1998-01-01', # '2006-08-10 10:11:12', # 20021029165106, # '19:38:34', # 2155 # ); # # CREATE TABLE t_string_1 ( # t_pk INT PRIMARY KEY, # t_test INT, # t_char CHAR(255), # t_varchar VARCHAR(655), # t_binary BINARY(255), # t_varbinary VARBINARY(6553) # ) ENGINE=NDBCLUSTER; # # CREATE TABLE t_string_2 ( # t_pk INT PRIMARY KEY, # t_test INT, # t_tinyblob TINYBLOB, # t_tinytext TINYTEXT, # t_blob BLOB, # t_text TEXT, # t_mediumblob MEDIUMBLOB, # t_mediumtext MEDIUMTEXT, # t_longblob LONGBLOB, # t_longtext LONGTEXT, # t_enum ENUM('001001','001004','001010','001018','001019','001020','001021','001027','001028','001029','001030','001031','001100','002003','002004','002005','002007')DEFAULT '001001' NOT NULL, # t_set SET('a','B') # ) ENGINE=NDBCLUSTER; # # INSERT INTO t_string_1 VALUE ( # 1, # 1, # 'abcdefghijklmn', # 'abcdefghijklmnabcdefghijklmnabcdefghijklmnabcdefghijklmn', # 0x612020, # 0x4100 # ); # INSERT INTO t_string_1 VALUE ( # 2, # 1, # 'abcdefghijklmn', # 'abcdefghijklmnabcdefghijklmnabcdefghijklmnabcdefghijklmn', # 0x612020, # 0x4100 # ); # # INSERT INTO t_string_2 VALUE ( # 1, # 1, # 'abcdefghijklmnabcdefghijklmn', # 'abcdefghijklmnabcdefghijklmn', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # '001001', # 'a' # ); # # INSERT INTO t_string_2 VALUE ( # 2, # 1, # 'abcdefghijklmnabcdefghijklmn', # 'abcdefghijklmnabcdefghijklmn', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # '001001', # 'a' # ); # # CREATE TABLE t_gis ( # t_pk INT PRIMARY KEY, # t_test INT, # t_point POINT, # t_linestring LINESTRING, # t_polygon POLYGON, # t_multipoint MULTIPOINT, # t_multilinestring MULTILINESTRING, # t_multipolygon MULTIPOLYGON, # t_geometrycollection GEOMETRYCOLLECTION, # t_geometry GEOMETRY # ) ENGINE=NDBCLUSTER; # # INSERT INTO t_gis VALUE ( # 1, # 1, # ST_PointFromText('POINT(10 10)'), # ST_LineStringFromText('LINESTRING(10 10,20 10,20 20,10 20,10 10)'), # ST_PolyFromText('POLYGON((0 0,50 0,50 50,0 50,0 0), (10 10,20 10,20 20,10 20,10 10))'), # ST_MPointFromText('MULTIPOINT(1 1,11 11,11 21,21 21)'), # ST_MLineFromText('MULTILINESTRING((10 48,10 21,10 0))'), # ST_MPolyFromText('MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))'), # ST_GeomCollFromText('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0,10 10))'), # ST_MPolyFromText('MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))') # ); # # INSERT INTO t_gis VALUE ( # 3, # 1, # ST_PointFromText('POINT(10 10)'), # ST_LineStringFromText('LINESTRING(10 10,20 10,20 20,10 20,10 10)'), # ST_PolyFromText('POLYGON((0 0,50 0,50 50,0 50,0 0), (10 10,20 10,20 20,10 20,10 10))'), # ST_MPointFromText('MULTIPOINT(1 1,11 11,11 21,21 21)'), # ST_MLineFromText('MULTILINESTRING((10 48,10 21,10 0))'), # ST_MPolyFromText('MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))'), # ST_GeomCollFromText('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0,10 10))'), # ST_MPolyFromText('MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))') # ); # # INSERT INTO t_gis VALUE ( # 2, # 1, # ST_PointFromWKB(ST_AsWKB(ST_PointFromText('POINT(10 20)'))), # ST_LineStringFromWKB(LineString(Point(10, 10), Point(40, 10))), # ST_PolyFromWKB(Polygon(LineString(Point(0, 0), Point(30, 0), Point(30, 30), Point(0, 0)))), # ST_MPointFromWKB(MultiPoint(Point(3, 6), Point(4, 10))), # ST_MLineFromWKB(MultiLineString(LineString(Point(1, 2), Point(3, 5)), LineString(Point(2, 5), Point(5, 8), Point(21, 7)))), # ST_MPolyFromWKB(MultiPolygon(Polygon(LineString(Point(0, 3), Point(3, 3), Point(3, 0), Point(0, 3))))), # ST_GeometryFromWKB(GeometryCollection(Point(44, 6), LineString(Point(3, 6), Point(7, 9)))), # ST_GeometryFromWKB(GeometryCollection(Point(44, 6), LineString(Point(3, 6), Point(7, 9)))) # ); # # INSERT INTO t_gis VALUE ( # 4, # 1, # ST_PointFromWKB(ST_AsWKB(ST_PointFromText('POINT(10 20)'))), # ST_LineStringFromWKB(LineString(Point(10, 10), Point(40, 10))), # ST_PolyFromWKB(Polygon(LineString(Point(0, 0), Point(30, 0), Point(30, 30), Point(0, 0)))), # ST_MPointFromWKB(MultiPoint(Point(3, 6), Point(4, 10))), # ST_MLineFromWKB(MultiLineString(LineString(Point(1, 2), Point(3, 5)), LineString(Point(2, 5), Point(5, 8), Point(21, 7)))), # ST_MPolyFromWKB(MultiPolygon(Polygon(LineString(Point(0, 3), Point(3, 3), Point(3, 0), Point(0, 3))))), # ST_GeometryFromWKB(GeometryCollection(Point(44, 6), LineString(Point(3, 6), Point(7, 9)))), # ST_GeometryFromWKB(GeometryCollection(Point(44, 6), LineString(Point(3, 6), Point(7, 9)))) # ); # # ####################################### ###### for multi entries ############# ####################################### # CREATE TABLE t_string_3 ( # t_pk INT NOT NULL PRIMARY KEY, # t_longblob LONGBLOB # ) ENGINE=NDB; # #delimiter |; # # CREATE PROCEDURE test_proc1() # BEGIN # DECLARE tmp INT DEFAULT 5000; # WHILE tmp > 1 DO # INSERT INTO t_string_3 VALUES ( # tmp, # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789'); # SET tmp = tmp -1; # END WHILE; # END; # # delimiter ;| # # INSERT INTO t_string_3 VALUE ( # 1, # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789'); # # call test_proc1(); # ########################################## ##### for disk data and order index ##### ########################################## # CREATE LOGFILE GROUP lg1 # ADD UNDOFILE 'undofile.dat' # INITIAL_SIZE 16M # UNDO_BUFFER_SIZE = 1M # ENGINE=NDB; # # CREATE TABLESPACE ts1 # ADD DATAFILE 'datafile.dat' # USE LOGFILE GROUP lg1 # INITIAL_SIZE 12M # ENGINE NDB; # # CREATE TABLE t_string_4 ( # t_pk INT NOT NULL PRIMARY KEY, # t_test INT, # t_name CHAR(30), # t_blob BLOB, # t_text TEXT, # INDEX (t_pk,t_name) # ) # TABLESPACE ts1 STORAGE DISK # ENGINE=NDB; # # INSERT INTO t_string_4 VALUE ( # 1, # 1, # 'name1', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789'); # INSERT INTO t_string_4 VALUE ( # 2, # 1, # 'name2', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789'); # ########################################## ############## for long blob ############ ########################################## # # CREATE TABLE t_string_5 ( # t_pk INT NOT NULL PRIMARY KEY, # t_longblob LONGBLOB, # t_longtext LONGTEXT # ) ENGINE=NDB; # ##### b1 length 128k ###### # # set @b1 = '01234567012345670123456701234567'; # set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1); # set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1); # set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1); # set @b1 = concat(@b1,@b1,@b1,@b1,@b1,@b1,@b1,@b1); # # INSERT INTO t_string_5 VALUES(1,@b1,@b1); # INSERT INTO t_string_5 VALUES(2,@b1,@b1); # ####################################### ### Operations during backup #### ####################################### # ######## for basic test with all data type ######## # # DELETE FROM t_num WHERE t_pk=2; # DELETE FROM t_datetime WHERE t_pk=2; # DELETE FROM t_string_1 WHERE t_pk=2; # DELETE FROM t_string_2 WHERE t_pk=2; # DELETE FROM t_gis WHERE t_pk=3; # DELETE FROM t_gis WHERE t_pk=4; # # # INSERT INTO t_num VALUE ( # 2, # 2, # b'1010101010101010101010101010101010101010101010101010101010101010', # 125, # 1, # 32765, # 8388606, # 2147483647, # 9223372036854775807, # 1e+20, # 1e+150, # '331.0000000000' # ); # INSERT INTO t_datetime VALUE ( # 2, # 2, # '1998-01-01', # '2006-08-10 10:11:12', # 20021029165106, # '19:38:34', # 2155 # ); # # INSERT INTO t_string_1 VALUE ( # 2, # 2, # 'abcdefghijklmn', # 'abcdefghijklmnabcdefghijklmnabcdefghijklmnabcdefghijklmn', # 0x612020, # 0x4100 # ); # # INSERT INTO t_string_2 VALUE ( # 2, # 2, # 'abcdefghijklmnabcdefghijklmn', # 'abcdefghijklmnabcdefghijklmn', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # '001001', # 'a' # ); # # # INSERT INTO t_gis VALUE ( # 3, # 2, # ST_PointFromText('POINT(10 10)'), # ST_LineStringFromText('LINESTRING(10 10,20 10,20 20,10 20,10 10)'), # ST_PolyFromText('POLYGON((0 0,50 0,50 50,0 50,0 0), (10 10,20 10,20 20,10 20,10 10))'), # ST_MPointFromText('MULTIPOINT(1 1,11 11,11 21,21 21)'), # ST_MLineFromText('MULTILINESTRING((10 48,10 21,10 0))'), # ST_MPolyFromText('MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))'), # ST_GeomCollFromText('GEOMETRYCOLLECTION(POINT(0 0), LINESTRING(0 0,10 10))'), # ST_MPolyFromText('MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))') # ); # # # INSERT INTO t_gis VALUE ( # 4, # 2, # ST_PointFromWKB(ST_AsWKB(ST_PointFromText('POINT(10 20)'))), # ST_LineStringFromWKB(LineString(Point(10, 10), Point(40, 10))), # ST_PolyFromWKB(Polygon(LineString(Point(0, 0), Point(30, 0), Point(30, 30), Point(0, 0)))), # ST_MPointFromWKB(MultiPoint(Point(3, 6), Point(4, 10))), # ST_MLineFromWKB(MultiLineString(LineString(Point(1, 2), Point(3, 5)), LineString(Point(2, 5), Point(5, 8), Point(21, 7)))), # ST_MPolyFromWKB(MultiPolygon(Polygon(LineString(Point(0, 3), Point(3, 3), Point(3, 0), Point(0, 3))))), # ST_GeometryFromWKB(GeometryCollection(Point(44, 6), LineString(Point(3, 6), Point(7, 9)))), # ST_GeometryFromWKB(GeometryCollection(Point(44, 6), LineString(Point(3, 6), Point(7, 9)))) # ); # # # UPDATE t_num SET t_test=3 WHERE t_pk=1; # UPDATE t_datetime SET t_test=3 WHERE t_pk=1; # UPDATE t_string_1 SET t_test=3 WHERE t_pk=1; # UPDATE t_string_2 SET t_test=3 WHERE t_pk=1; # UPDATE t_gis SET t_test=3 WHERE t_pk=1; # UPDATE t_gis SET t_test=3 WHERE t_pk=2; # # ######### multi undo log entries ######## # # DELETE FROM t_string_3 WHERE t_pk>1; # ######### disk table and ordered index ######## # # DELETE FROM t_string_4 WHERE t_pk=2; # INSERT INTO t_string_4 VALUE ( # 2, # 2, # 'name2', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789', # 'a123456789b123456789c123456789d123456789e123456789f123456789g123456789' # ); # UPDATE t_string_4 SET t_test=3 WHERE t_pk=1; # ######## long blob ######## # # DELETE FROM t_string_5 WHERE t_pk>1; # # # # # # ###################################################### ##### Restore backup files (from little endian) ###### ###################################################### --disable_warnings USE test; DROP TABLE IF EXISTS t_num,t_datetime,t_string_1,t_string_2,t_gis,t_string_3,t_string_4,t_string_5; --enable_warnings --exec $NDB_RESTORE --no-defaults -b 1 -n 1 -m -r $backup_data_dir/51_undolog_le >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b 1 -n 2 -r $backup_data_dir/51_undolog_le >> $NDB_TOOLS_OUTPUT --sorted_result SHOW TABLES; SHOW CREATE TABLE t_num; SHOW CREATE TABLE t_datetime; SHOW CREATE TABLE t_string_1; SHOW CREATE TABLE t_string_2; SHOW CREATE TABLE t_gis; SHOW CREATE TABLE t_string_3; SHOW CREATE TABLE t_string_4; SHOW CREATE TABLE t_string_5; SELECT * FROM t_datetime ORDER by t_pk; SELECT t_pk,t_test,hex(t_bit),t_tinyint,t_bool,t_smallint,t_mediumint,t_int,t_bigint,t_float,t_double,t_decimal FROM t_num ORDER by t_pk; SELECT t_pk,t_test,t_char,t_varchar,hex(t_binary),hex(t_varbinary) FROM t_string_1 ORDER by t_pk; SELECT * FROM t_string_2 ORDER by t_pk; SELECT t_pk,t_test,ST_AsText(t_point), ST_AsText(t_linestring),ST_AsText(t_polygon) FROM t_gis ORDER by t_pk; SELECT t_pk,t_test,ST_AsText(t_multipoint), ST_AsText(t_multilinestring),ST_AsText(t_multipolygon) FROM t_gis ORDER by t_pk; SELECT t_pk,t_test,ST_AsText(t_geometrycollection), ST_AsText(t_geometry) FROM t_gis ORDER by t_pk; SELECT COUNT(*) FROM t_string_3 ORDER BY t_pk; SELECT * FROM t_string_4 ORDER BY t_pk; SELECT t_pk,LENGTH(t_longblob),LENGTH(t_longtext) FROM t_string_5 ORDER BY t_pk; DROP TABLE IF EXISTS t_num,t_datetime,t_string_1,t_string_2,t_gis,t_string_3,t_string_4,t_string_5; ALTER TABLESPACE ts1 DROP DATAFILE 'datafile.dat' ENGINE = NDB; DROP TABLESPACE ts1 ENGINE = NDB; DROP LOGFILE GROUP lg1 ENGINE =NDB; # # Restore backup files (from big endian) # USE test; --exec $NDB_RESTORE --no-defaults -b 1 -n 1 -m -r $backup_data_dir/51_undolog_be >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b 1 -n 2 -r $backup_data_dir/51_undolog_be >> $NDB_TOOLS_OUTPUT --sorted_result SHOW TABLES; SHOW CREATE TABLE t_num; SHOW CREATE TABLE t_datetime; SHOW CREATE TABLE t_string_1; SHOW CREATE TABLE t_string_2; SHOW CREATE TABLE t_gis; SHOW CREATE TABLE t_string_3; SHOW CREATE TABLE t_string_4; SHOW CREATE TABLE t_string_5; SELECT * FROM t_datetime ORDER by t_pk; SELECT t_pk,t_test,hex(t_bit),t_tinyint,t_bool,t_smallint,t_mediumint,t_int,t_bigint,t_float,t_double,t_decimal FROM t_num ORDER by t_pk; SELECT t_pk,t_test,t_char,t_varchar,hex(t_binary),hex(t_varbinary) FROM t_string_1 ORDER by t_pk; SELECT * FROM t_string_2 ORDER by t_pk; SELECT t_pk,t_test,ST_AsText(t_point), ST_AsText(t_linestring),ST_AsText(t_polygon) FROM t_gis ORDER by t_pk; SELECT t_pk,t_test,ST_AsText(t_multipoint), ST_AsText(t_multilinestring),ST_AsText(t_multipolygon) FROM t_gis ORDER by t_pk; SELECT t_pk,t_test,ST_AsText(t_geometrycollection), ST_AsText(t_geometry) FROM t_gis ORDER by t_pk; SELECT COUNT(*) FROM t_string_3 ORDER BY t_pk; SELECT * FROM t_string_4 ORDER BY t_pk; SELECT t_pk,LENGTH(t_longblob),LENGTH(t_longtext) FROM t_string_5 ORDER BY t_pk; DROP TABLE IF EXISTS t_num,t_datetime,t_string_1,t_string_2,t_gis,t_string_3,t_string_4,t_string_5; ALTER TABLESPACE ts1 DROP DATAFILE 'datafile.dat' ENGINE = NDB; DROP TABLESPACE ts1 ENGINE = NDB; DROP LOGFILE GROUP lg1 ENGINE =NDB; ## end of test ##
Close