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.138.119.75
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_alter_table_online.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 ############################################################# # Author: Martin # Date: 2007-07 # Purpose: basic online alter test ############################################################## # Change Author: Jonathan # Date 2006-08-28 # Purpose: Add more testing for online alter ############################################################## --source include/have_multi_ndb.inc --disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings # Create utiltity table used to hold the output from ndb_show_table CREATE TEMPORARY TABLE IF NOT EXISTS ndb_show_tables_results ( id INT, type VARCHAR(20), state VARCHAR(20), logging VARCHAR(20), _database VARCHAR(255), _schema VARCHAR(20), name VARCHAR(255) ); ###################################### # basic online alter tests ###################################### --echo ******************************* --echo * basic online alter tests --echo ******************************* CREATE TABLE t1 (a INT UNSIGNED KEY, b INT UNSIGNED) ROW_FORMAT=DYNAMIC ENGINE NDB; INSERT INTO t1 values (1,1); --source ndb_show_tables_result.inc set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%'); --echo ******************************* --echo * Alter Table online add column --echo ******************************* --echo * Add column c as CHAR --echo ******************************* ALTER TABLE t1 ADD c CHAR(19); --source ndb_show_tables_result.inc select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%'; INSERT INTO t1 values (2,1,"a"); SELECT * FROM t1 ORDER BY a; UPDATE t1 SET c='b' where a = 2; SELECT * FROM t1 ORDER BY a; DROP TABLE t1; --echo ******************************* --echo * Alter Table online add column --echo ******************************* --echo * Add column c as nullable INT --echo ******************************* CREATE TABLE t1 (a INT UNSIGNED KEY, b VARCHAR(19)) ENGINE NDB; INSERT INTO t1 values (1,"a"); --source ndb_show_tables_result.inc set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%'); ALTER TABLE t1 ADD c INT; --source ndb_show_tables_result.inc select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%'; INSERT INTO t1 values (2,"a",1); SELECT * FROM t1 ORDER BY a; UPDATE t1 SET c = 2 where a = 2; SELECT * FROM t1 ORDER BY a; DROP TABLE t1; --echo ******************************* --echo * Alter Table online add column --echo ******************************* --echo * Add column c as nullable INT --echo ******************************* CREATE TABLE t1 (a INT UNSIGNED KEY, b INT COLUMN_FORMAT DYNAMIC) ENGINE NDB; INSERT INTO t1 values (1,1); --source ndb_show_tables_result.inc set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%'); ALTER TABLE t1 ADD c INT; --source ndb_show_tables_result.inc select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%'; INSERT INTO t1 values (2,1,1); SELECT * FROM t1 ORDER BY a; UPDATE t1 SET c = 2 where a = 2; SELECT * FROM t1 ORDER BY a; --echo ******************************* --echo * Create online Index ci --echo ******************************* CREATE INDEX ci on t1(c) algorithm=inplace; --source ndb_show_tables_result.inc select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%'; --echo ******************************* --echo * Create offline Index ci2 --echo ******************************* CREATE INDEX ci2 on t1(c) algorithm=copy; --source ndb_show_tables_result.inc select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%'; set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%'); --echo ******************************* --echo * Drop online Index ci --echo ******************************* DROP INDEX ci on t1 algorithm=inplace; --source ndb_show_tables_result.inc select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%'; --echo ******************************* --echo * Drop offline Index ci2 --echo ******************************* DROP INDEX ci2 on t1 algorithm=copy; --source ndb_show_tables_result.inc select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%'; DROP TABLE t1; --echo ******************************* --echo * The following ALTER operations are not supported on-line --echo ******************************* --echo * Not supported Test#1 --echo ******************************* CREATE TABLE t1 (a INT UNSIGNED KEY, b INT UNSIGNED) ROW_FORMAT=FIXED ENGINE NDB; INSERT INTO t1 values (1,1); --source ndb_show_tables_result.inc set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%'); --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ADD c CHAR(19); --source ndb_show_tables_result.inc select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%'; ALTER TABLE t1 ADD c CHAR(19); INSERT INTO t1 values (2,1,"a"); SELECT * FROM t1 ORDER BY a; UPDATE t1 SET c = 'b' where a = 2; SELECT * FROM t1 ORDER BY a; DROP TABLE t1; --echo ******************************* --echo * Not supported Test#2 --echo ******************************* CREATE TABLE t1 (a INT UNSIGNED KEY, b INT UNSIGNED) ROW_FORMAT=DYNAMIC ENGINE NDB; INSERT INTO t1 values (1,1); --source ndb_show_tables_result.inc set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%'); --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ADD c CHAR(19) DEFAULT 17; --source ndb_show_tables_result.inc select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%'; ALTER TABLE t1 ADD c CHAR(19) DEFAULT 17; INSERT INTO t1 values (2,1,"a"); SELECT * FROM t1 ORDER BY a; UPDATE t1 SET c = 'b' where a = 2; SELECT * FROM t1 ORDER BY a; --echo ******************************* --echo * Not supported Test#3 --echo ******************************* --source ndb_show_tables_result.inc set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%'); --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ADD d INT AFTER b; --source ndb_show_tables_result.inc select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%'; ALTER TABLE t1 ADD d INT AFTER b; --source ndb_show_tables_result.inc select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%'; INSERT INTO t1 VALUES(3,1,1,'b'); SELECT * FROM t1 ORDER BY a; UPDATE t1 SET d = 2 where a = 3; SELECT * FROM t1 ORDER BY a; --echo ******************************* --echo * Not supported Test#4 --echo ******************************* --source ndb_show_tables_result.inc set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%'); --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ENGINE MYISAM; --source ndb_show_tables_result.inc select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%'; DROP TABLE t1; --echo ******************************* --echo * Not supported Test#5 --echo ******************************* CREATE TABLE t1 (a INT UNSIGNED KEY, b INT UNSIGNED) ROW_FORMAT=DYNAMIC ENGINE NDB; INSERT INTO t1 values (1,1); --source ndb_show_tables_result.inc set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%'); --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ADD c TIMESTAMP; --source ndb_show_tables_result.inc select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%'; ALTER TABLE t1 ADD c TIMESTAMP DEFAULT '2014-11-27 22:45:17'; INSERT INTO t1 values (2,2,'2007-09-19 18:46:02'); SELECT * FROM t1 ORDER BY a; UPDATE t1 SET c = '2007-10-22 16:35:06' where a = 2; SELECT * FROM t1 ORDER BY a; DROP TABLE t1; --echo ******************************* --echo * Not supported Test#6 --echo ******************************* CREATE TABLE t1 (a INT UNSIGNED KEY, b INT UNSIGNED) ROW_FORMAT=DYNAMIC ENGINE NDB; INSERT INTO t1 values (1,1); --source ndb_show_tables_result.inc set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%'); --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ADD c CHAR(19) NOT NULL; --source ndb_show_tables_result.inc select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%'; ALTER TABLE t1 ADD c CHAR(19) NOT NULL; INSERT INTO t1 values (2,1,"a"); SELECT * FROM t1 ORDER BY a; UPDATE t1 SET c = 'b' where a = 2; SELECT * FROM t1 ORDER BY a; DROP TABLE t1; --echo ******************************* --echo * Not supported Test#7 --echo ******************************* CREATE TABLE t1 (a INT UNSIGNED KEY, b INT UNSIGNED) ROW_FORMAT=DYNAMIC ENGINE NDB; INSERT INTO t1 values (1,1); --source ndb_show_tables_result.inc set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%'); --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ADD c CHAR(19) COLUMN_FORMAT FIXED; --source ndb_show_tables_result.inc select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%'; ALTER TABLE t1 ADD c CHAR(19) COLUMN_FORMAT FIXED; INSERT INTO t1 values (2,1,"a"); SELECT * FROM t1 ORDER BY a; UPDATE t1 SET c = 'b' WHERE a = 2; SELECT * FROM t1 ORDER BY a; DROP TABLE t1; --echo ******************************* --echo * Not supported Test#8 --echo * Ndb doesn't support renaming attributes on-line --echo ******************************* CREATE TABLE t1 ( auto int(5) unsigned NOT NULL auto_increment, string char(10), vstring varchar(10), bin binary(2), vbin varbinary(7), tiny tinyint(4) DEFAULT '0' NOT NULL , short smallint(6) DEFAULT '1' NOT NULL , medium mediumint(8) DEFAULT '0' NOT NULL, long_int int(11) DEFAULT '0' NOT NULL, longlong bigint(13) DEFAULT '0' NOT NULL, real_float float(13,1) DEFAULT 0.0 NOT NULL, real_double double(16,4), real_decimal decimal(16,4), utiny tinyint(3) unsigned DEFAULT '0' NOT NULL, ushort smallint(5) unsigned zerofill DEFAULT '00000' NOT NULL, umedium mediumint(8) unsigned DEFAULT '0' NOT NULL, ulong int(11) unsigned DEFAULT '0' NOT NULL, ulonglong bigint(13) unsigned DEFAULT '0' NOT NULL, bits bit(3), options enum('zero','one','two','three','four') not null, flags set('zero','one','two','three','four') not null, date_field date, year_field year, time_field time, date_time datetime, time_stamp timestamp, PRIMARY KEY (auto) ) engine=ndb; --source ndb_show_tables_result.inc set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%'); --error ER_ALTER_OPERATION_NOT_SUPPORTED alter table t1 algorithm=inplace, change tiny new_tiny tinyint(4) DEFAULT '0' NOT NULL; --source ndb_show_tables_result.inc select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%'; alter table t1 change tiny new_tiny tinyint(4) DEFAULT '0' NOT NULL; create index i1 on t1(medium); alter table t1 add index i2(new_tiny); drop index i1 on t1; --source ndb_show_tables_result.inc select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%'; DROP TABLE t1; ##################################### # Adding dropping primary key ###################################### # Bug:31233 ###################################### --echo **************************************** --echo * Adding dropping primary key --echo **************************************** CREATE TABLE t1 (a INT UNSIGNED NOT NULL) ENGINE NDB; --source show_primary_keys.inc --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ADD PRIMARY KEY (a); ALTER TABLE t1 algorithm=copy, ADD PRIMARY KEY (a); --source show_primary_keys.inc --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, DROP PRIMARY KEY; ALTER TABLE t1 algorithm=copy, DROP PRIMARY KEY; --source show_primary_keys.inc --error ER_ALTER_OPERATION_NOT_SUPPORTED CREATE UNIQUE INDEX pk ON t1(a) algorithm=inplace; CREATE UNIQUE INDEX pk ON t1(a) algorithm=copy; --source show_primary_keys.inc --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, DROP INDEX PK; ALTER TABLE t1 algorithm=copy, DROP INDEX PK; --source show_primary_keys.inc DROP TABLE t1; CREATE TABLE t1 (a INT UNSIGNED) ENGINE NDB; --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ADD b INT UNIQUE; ALTER TABLE t1 algorithm=copy, ADD b INT UNIQUE; --source show_primary_keys.inc --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ADD c INT NOT NULL UNIQUE; ALTER TABLE t1 algorithm=copy, ADD c INT NOT NULL UNIQUE; --source show_primary_keys.inc DROP TABLE t1; ###################################### # Alter dynmaic table, add TEXT column ###################################### # Bug:30205 ###################################### --echo **************************************** --echo * Add column c as nullable TEXT and BLOB --echo **************************************** CREATE TABLE t1 (a INT UNSIGNED AUTO_INCREMENT KEY, b INT DEFAULT 2 COLUMN_FORMAT DYNAMIC) ENGINE NDB; --source ndb_show_tables_result.inc set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%'); let $v=5; disable_query_log; while ($v) { INSERT INTO t1 VALUES(NULL, DEFAULT); dec $v; } enable_query_log; --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ADD c TEXT; --source ndb_show_tables_result.inc select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%'; --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ADD d BLOB; --source ndb_show_tables_result.inc select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%'; DROP TABLE t1; ###################################### # Alter dynmaic table, add column ###################################### CREATE TABLE t1 (a INT UNSIGNED AUTO_INCREMENT KEY, b INT COLUMN_FORMAT DYNAMIC) ENGINE NDB; let $v=5; disable_query_log; while ($v) { --eval INSERT INTO t1 VALUES(NULL, $v); dec $v; } enable_query_log; --source ndb_show_tables_result.inc set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%'); --echo ******************************* --echo * Add column c as nullable FLOAT --echo ******************************* ALTER TABLE t1 algorithm=inplace, ADD c FLOAT; let $v=5; disable_query_log; while ($v) { --eval INSERT INTO t1 VALUES(NULL, $v, -3.402823466E+38); dec $v; } enable_query_log; --echo ******************************* --echo * Add column d as nullable DOUBLE --echo ******************************* ALTER TABLE t1 algorithm=inplace, ADD d DOUBLE UNSIGNED; let $v=5; disable_query_log; while ($v) { --eval INSERT INTO t1 VALUES(NULL, $v, -3.402823466E+38, 1.7976931348623E+308); dec $v; } enable_query_log; --echo ******************************* --echo * Add column e as nullable DECIMAL --echo ******************************* ALTER TABLE t1 algorithm=inplace, ADD e DECIMAL(5,2); let $v=5; disable_query_log; while ($v) { --eval INSERT INTO t1 VALUES(NULL, $v, -3.402823466E+38, 1.7976931348623E+308, 345.21); dec $v; } enable_query_log; --echo ******************************* --echo * Add column f as nullable DATETIME --echo ******************************* ALTER TABLE t1 algorithm=inplace, ADD f DATETIME; let $v=5; disable_query_log; while ($v) { --eval INSERT INTO t1 VALUES(NULL, $v, -3.402823466E+38, 1.7976931348623E+308, 345.21, '1000-01-01 00:00:00'); dec $v; } enable_query_log; --echo ******************************* --echo * Add column g as nullable BINARY --echo ******************************* ALTER TABLE t1 ADD g BINARY(4); let $v=5; disable_query_log; while ($v) { --eval INSERT INTO t1 VALUES(NULL, $v, -3.402823466E+38, 1.7976931348623E+308, 345.21, '1000-01-01 00:00:00', '0101'); dec $v; } enable_query_log; --source ndb_show_tables_result.inc select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%'; SELECT COUNT(*) FROM t1 WHERE c IS NULL; SELECT COUNT(*) FROM t1 WHERE d IS NULL; SELECT COUNT(*) FROM t1 WHERE e IS NULL; SELECT COUNT(*) FROM t1 WHERE f IS NULL; SELECT COUNT(*) FROM t1 WHERE g IS NULL; UPDATE t1 SET c = 3.402823466E+38, d = 1.2686868689898E+308, e = 666.66, f = '2007-10-23 23:23:23', g = '1111' WHERE a = 1; SELECT * FROM t1 WHERE a = 1 or a = 10 or a = 20 or a = 30 ORDER BY a; ############################## # Backup and restore section # ############################## --echo ********************************* --echo * Backup and restore tables w/ new column --echo ********************************* --source include/ndb_backup.inc DROP TABLE t1; --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -m -r --print --print_meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT --exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -r --print --print_meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT source show_varpart.inc; DROP TABLE t1; ################################### # Disk Data Error testing section # ################################### --echo ********************************* --echo * Disk Data error testing --echo ********************************* set default_storage_engine=ndb; CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'undofile.dat' INITIAL_SIZE 16M UNDO_BUFFER_SIZE = 1M; CREATE TABLESPACE ts1 ADD DATAFILE 'datafile.dat' USE LOGFILE GROUP lg1 INITIAL_SIZE 12M ENGINE NDB; CREATE TABLE t1 (pk1 INT NOT NULL PRIMARY KEY, b INT COLUMN_FORMAT DYNAMIC) TABLESPACE ts1 STORAGE DISK ENGINE=NDB; --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, CHANGE b b_1 INT COLUMN_FORMAT DYNAMIC; --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ADD COLUMN c INT COLUMN_FORMAT DYNAMIC; --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ADD COLUMN d FLOAT COLUMN_FORMAT DYNAMIC; --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ADD COLUMN e DOUBLE COLUMN_FORMAT DYNAMIC; --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ADD COLUMN f DATETIME COLUMN_FORMAT DYNAMIC; --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ADD COLUMN g DECIMAL(5,2) COLUMN_FORMAT DYNAMIC; --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ADD COLUMN h CHAR(20) COLUMN_FORMAT DYNAMIC; --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ADD COLUMN h VARCHAR(20) COLUMN_FORMAT DYNAMIC; --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ADD COLUMN h BINARY(20) COLUMN_FORMAT DYNAMIC; --error ER_ALTER_OPERATION_NOT_SUPPORTED ALTER TABLE t1 algorithm=inplace, ADD COLUMN h VARBINARY(20) COLUMN_FORMAT DYNAMIC; DROP TABLE t1; # # bug#42549 # create table t1 (a int primary key, b int) storage disk tablespace ts1 engine = ndb; --error ER_ALTER_OPERATION_NOT_SUPPORTED alter table t1 algorithm=inplace, add column c0 int null column_format DYNAMIC; alter table t1 algorithm=inplace, add column c1 int null column_format DYNAMIC storage memory; drop table t1; create table t1 (a int primary key, b int storage disk) tablespace ts1 engine = ndb; alter table t1 algorithm=inplace, add column c0 int null column_format DYNAMIC; alter table t1 algorithm=inplace, add column c1 int null column_format DYNAMIC storage memory; drop table t1; ALTER TABLESPACE ts1 DROP DATAFILE 'datafile.dat' ENGINE = NDB; DROP TABLESPACE ts1 ENGINE = NDB; DROP LOGFILE GROUP lg1 ENGINE =NDB; ############################## # ROW_FORMAT testing section # ############################## --echo ******************** --echo * ROW_FORMAT testing --echo ******************** # Bug:30276, should issue a warning CREATE TABLE t1 (pk1 INT NOT NULL PRIMARY KEY, b INT COLUMN_FORMAT DYNAMIC)ROW_FORMAT=FIXED ENGINE=NDB; source show_attributes.inc; DROP TABLE t1; CREATE TABLE t1 (pk1 INT NOT NULL COLUMN_FORMAT FIXED PRIMARY KEY, b INT COLUMN_FORMAT FIXED)ROW_FORMAT=DYNAMIC ENGINE=NDB; source show_attributes.inc; DROP TABLE t1; --echo ******************** --echo * bug#44695 ALTER TABLE during START BACKUP crashes mysqld --echo ******************** # Testing failure of online alter during ongoing backup CREATE TABLE t1(k INT NOT NULL PRIMARY KEY AUTO_INCREMENT) ROW_FORMAT=DYNAMIC ENGINE=NDB; # create some data to slow down backup INSERT INTO t1 VALUES (NULL); INSERT INTO t1 SELECT NULL FROM t1; INSERT INTO t1 SELECT NULL FROM t1; INSERT INTO t1 SELECT NULL FROM t1; INSERT INTO t1 SELECT NULL FROM t1; INSERT INTO t1 SELECT NULL FROM t1; INSERT INTO t1 SELECT NULL FROM t1; INSERT INTO t1 SELECT NULL FROM t1; INSERT INTO t1 SELECT NULL FROM t1; INSERT INTO t1 SELECT NULL FROM t1; INSERT INTO t1 SELECT NULL FROM t1; INSERT INTO t1 SELECT NULL FROM t1; INSERT INTO t1 SELECT NULL FROM t1; INSERT INTO t1 SELECT NULL FROM t1; INSERT INTO t1 SELECT NULL FROM t1; SELECT COUNT(*) FROM t1; --exec $NDB_MGM --no-defaults --ndb-connectstring="$NDB_CONNECTSTRING" -e "start backup nowait" >> $NDB_TOOLS_OUTPUT --disable_warnings --error 0,762,1296 ALTER TABLE t1 algorithm=inplace, ADD b INT; # waut for backup to complete --sleep 10 --enable_warnings DROP TABLE t1, ndb_show_tables_results; # # test alter of table with many attributes # let $i=499; let $separator=; let $sql=create table t1 (; while ($i) { let $sql=$sql$separator c$i int; let $separator=,; dec $i; } let $sql=$sql, c501 varchar(10000); let $sql=$sql, primary key using hash(c1)) engine=ndb; eval $sql; # eval the sql and create the table insert into t1 (c1) values (1), (2), (3); alter table t1 algorithm=copy, modify c1 int auto_increment; alter table t1 algorithm=inplace, add column c500 bit(1) column_format DYNAMIC; --error ER_TOO_BIG_ROWSIZE alter table t1 algorithm=copy, add column c502 varchar(2000); --error ER_TOO_BIG_ROWSIZE alter table t1 algorithm=inplace, add column c502 varchar(2000); delete from t1; drop table t1; # # Bug #13830980 MYSQL COMPLAINS OF NOT SUPPORTING ALTER ONLINE EVEN WHEN VALID OPTIONS ARE USED # create table t1(a int(10) unsigned not null auto_increment, b varchar(20) default 'x', c varchar(20) default null, primary key (a) ) engine=ndbcluster; --error ER_ALTER_OPERATION_NOT_SUPPORTED alter table t1 algorithm=inplace, add e varchar(20) default 'x' column_format dynamic; alter table t1 algorithm=inplace, add e varchar(20) default null column_format dynamic; drop table t1; # # Bug #12755722 61528: INNODB BACKEND CRASHES ON ALTER TABLE STATEMENT (MYSQL SERVER HAS GONE AWAY # CREATE TABLE categorylinks ( cl_from int(10) unsigned NOT NULL DEFAULT '0', cl_to varbinary(255) NOT NULL DEFAULT '', cl_sortkey varbinary(70) NOT NULL DEFAULT '', cl_timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, UNIQUE KEY cl_from (cl_from,cl_to), KEY cl_sortkey (cl_to,cl_sortkey,cl_from), KEY cl_timestamp (cl_to,cl_timestamp) ) ENGINE=ndb DEFAULT CHARSET=binary; ALTER TABLE categorylinks CHANGE COLUMN cl_sortkey cl_sortkey varbinary(230) NOT NULL default '', ADD COLUMN cl_sortkey_prefix varchar(255) binary NOT NULL default '', ADD COLUMN cl_collation varbinary(32) NOT NULL default '', ADD COLUMN cl_type ENUM('page', 'subcat', 'file') NOT NULL default 'page', ADD INDEX (cl_collation), DROP INDEX cl_sortkey, ADD INDEX cl_sortkey (cl_to, cl_type, cl_sortkey, cl_from); SHOW CREATE TABLE categorylinks; DROP TABLE categorylinks;
Close
