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 | : 13.59.196.41
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_read_multi_range.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 --disable_warnings DROP TABLE IF EXISTS t1, t2, r1; --enable_warnings # # Basic test to see that batching is working # create table t1 ( a int primary key, b int not null, c int not null, index(b), unique index using hash(c) ) engine = ndb; --source suite/ndb/include/ndb_init_execute_count.inc insert into t1 values (1,2,1),(2,3,2),(3,4,3),(4,5,4), (5,2,12),(6,3,11),(7,4,10),(8,5,9), (9,2,8),(10,3,7),(11,4,6),(12,5,5); --source suite/ndb/include/ndb_execute_count.inc ## # In ps-protocol, server will adds calls to execute(Commit) # (these are optimized away by ndbapi, since there is nothing to commit) # and these generates a diff in execute-count # To not have to investigate problem futher, I simply set autocommit=off # (and back further down where we don't track execute-count any longer) # It would probably be good to changes these tests to instead use frazers new # ndbapi counters, and instead measure #round-trips set autocommit=off; # batch on primary key --source suite/ndb/include/ndb_init_execute_count.inc create table r1 as select * from t1 where a in (2,8,12); --source suite/ndb/include/ndb_execute_count.inc select * from r1 order by a; drop table r1; # batch on ordered index --source suite/ndb/include/ndb_init_execute_count.inc create table r1 as select * from t1 where b in (1,2,5); --source suite/ndb/include/ndb_execute_count.inc select * from r1 order by a; drop table r1; # batch on unique hash index --source suite/ndb/include/ndb_init_execute_count.inc create table r1 as select * from t1 where c in (2,8,12); --source suite/ndb/include/ndb_execute_count.inc select * from r1 order by a; drop table r1; # batch mixed --source suite/ndb/include/ndb_init_execute_count.inc create table r1 as select * from t1 where a in (2,8) or (a > 11) or (a <= 1); --source suite/ndb/include/ndb_execute_count.inc select * from r1 order by a; drop table r1; # batch on primary key, missing values --source suite/ndb/include/ndb_init_execute_count.inc create table r1 as select * from t1 where a in (33,8,12); --source suite/ndb/include/ndb_execute_count.inc select * from r1 order by a; drop table r1; --source suite/ndb/include/ndb_init_execute_count.inc create table r1 as select * from t1 where a in (2,33,8,12,34); --source suite/ndb/include/ndb_execute_count.inc select * from r1 order by a; drop table r1; # batch on ordered index, missing values --source suite/ndb/include/ndb_init_execute_count.inc create table r1 as select * from t1 where b in (1,33,5); --source suite/ndb/include/ndb_execute_count.inc select * from r1 order by a; drop table r1; --source suite/ndb/include/ndb_init_execute_count.inc select * from t1 force index(b) where b in (1,33,5) order by a; --source suite/ndb/include/ndb_execute_count.inc --source suite/ndb/include/ndb_init_execute_count.inc create table r1 as select * from t1 where b in (45,1,33,5,44); --source suite/ndb/include/ndb_execute_count.inc select * from r1 order by a; drop table r1; --source suite/ndb/include/ndb_init_execute_count.inc select * from t1 force index(b) where b in (45,22) order by a; --source suite/ndb/include/ndb_execute_count.inc # batch on unique hash index, missing values --source suite/ndb/include/ndb_init_execute_count.inc create table r1 as select * from t1 where c in (2,8,33); --source suite/ndb/include/ndb_execute_count.inc select * from r1 order by a; drop table r1; --source suite/ndb/include/ndb_init_execute_count.inc create table r1 as select * from t1 where c in (13,2,8,33,12); --source suite/ndb/include/ndb_execute_count.inc select * from r1 order by a; drop table r1; --source suite/ndb/include/ndb_init_execute_count.inc select * from t1 where a in (33,8,12) order by a; --source suite/ndb/include/ndb_execute_count.inc --source suite/ndb/include/ndb_init_execute_count.inc select * from t1 where a in (33,34,35) order by a; --source suite/ndb/include/ndb_execute_count.inc --source suite/ndb/include/ndb_init_execute_count.inc select * from t1 where a in (2,8) or (a > 11) or (a <= 1) order by a; --source suite/ndb/include/ndb_execute_count.inc --source suite/ndb/include/ndb_init_execute_count.inc select * from t1 where b in (6,7) or (b <= 5) or (b >= 10) order by b,a; --source suite/ndb/include/ndb_execute_count.inc --source suite/ndb/include/ndb_init_execute_count.inc select * from t1 where c in (13,2,8,33,12) order by c,a; --source suite/ndb/include/ndb_execute_count.inc drop table t1; set autocommit=on; # # Somewhat more complicated # create table t1 ( a int not null, b int not null, c int not null, d int not null, e int not null, primary key (a,b,c,d), index (d) ) engine = ndb; --source suite/ndb/include/ndb_init_execute_count.inc insert into t1 values (1,2,1,1,1),(2,3,2,3,1),(3,4,3,1,1),(4,5,4,7,1), (5,2,12,12,1),(6,3,11,1,1),(7,4,10,3,1),(8,5,9,5,1), (9,2,8,6,1),(10,3,7,5,1),(11,4,6,3,1),(12,5,5,2,1), (1,2,1,2,1), (1,2,1,3,1), (1,2,1,4,1), (1,2,1,5,1); --source suite/ndb/include/ndb_execute_count.inc # batch on primary key --source suite/ndb/include/ndb_init_execute_count.inc create table r1 as select * from t1 where a=1 and b=2 and c=1 and d in (1,4,3,2); --source suite/ndb/include/ndb_execute_count.inc select * from r1 order by a,b,c,d; drop table r1; # batched update ordered index, one value for all update t1 set e = 100 where d in (12,6,7); select * from t1 where d in (12,6,7) order by a,b,c,d; select * from t1 where d not in (12,6,7) and e = 100; # batched update primary key, one value for all update t1 set e = 101 where a=1 and b=2 and c=1 and d in (1,4,3,2); select * from t1 where a=1 and b=2 and c=1 and d in (1,4,3,2) order by a,b,c,d; select * from t1 where not (a=1 and b=2 and c=1 and d in (1,4,3,2)) and e=101; # batched update ordered index, different values update t1 set e = (case d when 12 then 112 when 6 then 106 when 7 then 107 end) where d in (12,6,7); select * from t1 where d in (12,6,7) order by a,b,c,d; # batched update primary key, different values update t1 set e = (case d when 1 then 111 when 4 then 444 when 3 then 333 when 2 then 222 end) where a=1 and b=2 and c=1 and d in (1,4,3,2); select * from t1 where a=1 and b=2 and c=1 and d in (1,4,3,2) order by a,b,c,d; # batched delete delete from t1 where d in (12,6,7); select * from t1 where d in (12,6,7); drop table t1; # null handling create table t1 ( a int not null primary key, b int, c int, d int, unique index (b), index(c) ) engine = ndb; insert into t1 values (1,null,1,1), (2,2,2,2), (3,null,null,3), (4,4,null,4), (5,null,5,null), (6,6,6,null), (7,null,null,null), (8,8,null,null), (9,null,9,9), (10,10,10,10), (11,null,null,11), (12,12,null,12), (13,null,13,null), (14,14,14,null), (15,null,null,null), (16,16,null,null); create table t2 as select * from t1 where a in (5,6,7,8,9,10); select * from t2 order by a; drop table t2; create table t2 as select * from t1 where b in (5,6,7,8,9,10); select * from t2 order by a; drop table t2; create table t2 as select * from t1 where c in (5,6,7,8,9,10); select * from t2 order by a; drop table t2; drop table t1; # bug17729 CREATE TABLE t1 ( a int(11) NOT NULL, b int(11) NOT NULL, c datetime default NULL, PRIMARY KEY (a), KEY idx_bc (b,c) ) ENGINE=ndbcluster; INSERT INTO t1 VALUES (406989,67,'2006-02-23 17:08:46'), (150078,67,'2005-10-26 11:17:45'), (406993,67,'2006-02-27 11:20:57'), (245655,67,'2005-12-08 15:59:08'), (406994,67,'2006-02-27 11:26:46'), (256,67,NULL), (398341,67,'2006-02-20 04:48:44'), (254,67,NULL),(1120,67,NULL), (406988,67,'2006-02-23 17:07:22'), (255,67,NULL), (398340,67,'2006-02-20 04:38:53'),(406631,67,'2006-02-23 10:49:42'), (245653,67,'2005-12-08 15:59:07'),(406992,67,'2006-02-24 16:47:18'), (245654,67,'2005-12-08 15:59:08'),(406995,67,'2006-02-28 11:55:00'), (127261,67,'2005-10-13 12:17:58'),(406991,67,'2006-02-24 16:42:32'), (245652,67,'2005-12-08 15:58:27'),(398545,67,'2006-02-20 04:53:13'), (154504,67,'2005-10-28 11:53:01'),(9199,67,NULL),(1,67,'2006-02-23 15:01:35'), (223456,67,NULL),(4101,67,NULL),(1133,67,NULL), (406990,67,'2006-02-23 18:01:45'),(148815,67,'2005-10-25 15:34:17'), (148812,67,'2005-10-25 15:30:01'),(245651,67,'2005-12-08 15:58:27'), (154503,67,'2005-10-28 11:52:38'); create table t11 engine = ndbcluster select * from t1 where b = 67 AND (c IS NULL OR c > NOW()) order by 3 asc; create table t12 engine = ndbcluster select * from t1 where b = 67 AND (c IS NULL OR c > NOW()) order by 3 desc; create table t21 select * from t1 where b = 67 AND (c IS NULL OR c > '2005-12-08') order by 3 asc; create table t22 engine = ndbcluster select * from t1 where b = 67 AND (c IS NULL OR c > '2005-12-08') order by 3 desc; select * from t11 order by 1,2,3; select * from t12 order by 1,2,3; select * from t21 order by 1,2,3; select * from t22 order by 1,2,3; # join tests select t12.a from t11, t12 where t11.a in(255,256) and t11.a = t12.a and t11.c is null order by t12.a; update t22 set c = '2005-12-08 15:58:27' where a = 255; select * from t22 order by 1,2,3; select t21.* from t21,t22 where t21.a = t22.a and t22.a in (select t12.a from t11, t12 where t11.a in(255,256) and t11.a = t12.a and t11.c is null) and t22.c is null order by t21.a; delete from t22 where a > 245651; update t22 set b = a + 1; select * from t22 order by 1,2,3; select t21.c, count(*) from t21 inner join t22 using (a) where t22.b in (2,256,257,1121,1134,4102,9200,223457,245652) group by t21.c order by t21.c; DROP TABLE t1, t11, t12, t21, t22; # bug#19956 CREATE TABLE t1 (id varchar(255) NOT NULL, tag int(11) NOT NULL, doc text NOT NULL, type varchar(150) NOT NULL, modified timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) ENGINE=ndbcluster; INSERT INTO t1 VALUES ('sakila',1,'Some text goes here','text',CURRENT_TIMESTAMP); SELECT id, tag, doc, type FROM t1 WHERE id IN ('flipper','orka'); SELECT id, tag, doc, type FROM t1 WHERE id IN ('flipper','sakila'); DROP TABLE t1; #bug#25522 CREATE TABLE t1 ( var1 int(2) NOT NULL, var2 int(2) NOT NULL, PRIMARY KEY (var1) ) ENGINE=ndbcluster DEFAULT CHARSET=ascii CHECKSUM=1; CREATE TABLE t2 ( var1 int(2) NOT NULL, var2 int(2) NOT NULL, PRIMARY KEY (var1) ) ENGINE=ndbcluster DEFAULT CHARSET=ascii CHECKSUM=1; DELIMITER |; CREATE TRIGGER testtrigger AFTER UPDATE ON t1 FOR EACH ROW BEGIN REPLACE INTO t2 SELECT * FROM t1 WHERE t1.var1 = NEW.var1;END| DELIMITER ;| INSERT INTO t1 VALUES (1,1),(2,2),(3,3); UPDATE t1 SET var2 = 9 WHERE var1 IN(1,2,3); DROP TRIGGER testtrigger; DROP TABLE t1, t2; #bug#25821 create table t1 (a int, b int, primary key (a), key ab (a,b)) engine=ndbcluster; insert into t1 values (1,1), (10,10); select * from t1 use index (ab) where a in(1,10) order by a; create table t2 (a int, b int, primary key (a,b)) engine=ndbcluster partition by key(a); insert into t2 values (1,1), (10,10); select * from t2 where a in (1,10) order by a; drop table t1, t2; #bug#30337 create table t1 (id int primary key) engine ndb; insert into t1 values (1), (2), (3); create table t2 (id int primary key) engine ndb; insert into t2 select id from t1; delimiter |; create trigger kaboom after delete on t1 for each row begin delete from t2 where id=old.id; end| delimiter ;| select * from t1 order by id; delete from t1 where id in (1,2); select * from t2 order by id; drop trigger kaboom; drop table t1; #bug#31874 create table t1 ( a int not null primary key, b int ) engine = ndb; insert into t1 values (7,2),(8,3),(10,4); update t1 set b = 5 where a in (7,8) or a >= 10; select * from t1 order by a; delete from t1 where a in (7,8) or a >= 10; select * from t1 order by a; drop table t1; #bug#35137 - self join + mrr create table t1 (a int primary key, b int, key b_idx (b)) engine ndb; insert into t1 values(1,1), (2,2), (3,3), (4,4), (5,5); select one.a from t1 one left join t1 two on (two.b = one.b) where one.a in (3, 4) order by a; drop table t1; create table t1 (a varchar(1536) not null, b varchar(1532) not null, c int, primary key (a,b)) engine=ndb; insert into t1 values ('a', 'a', 1), ('b', 'b', 2), ('c', 'c', 3), ('d', 'd', 4), ('e', 'e', 5), ('f', 'f', 6), ('g', 'g', 7), ('h', 'h', 8), ('i', 'i', 9), ('j', 'j', 10), ('k', 'k', 11), ('l', 'l', 12), ('m', 'm', 13), ('n', 'n', 14), ('o', 'o', 15), ('p', 'p', 16), ('q', 'q', 17), ('r', 'r', 18), ('s', 's', 19), ('t', 't', 20), ('u', 'u', 21), ('v', 'v', 22), ('w', 'w', 23), ('x', 'x', 24); select * from t1 where (a >= 'aa' and b >= 'x' and a <= 'c' and b <= 'c') or (a = 'd') or (a = 'e') or (a = 'f') or (a > 'g' and a < 'ii') or (a >= 'j' and b >= 'x' and a <= 'k' and b <= 'k') or (a = 'm' and b = 'm') or (a = 'v') order by a asc, b asc; drop table t1, t2; ######################## # Check propper reinit of a mrr executed multiple time as part of a join. # The mrr access is driven by a scan and executed as for every tuple # in the scaned table. # # In certain queries the optimizer don't read the entire mrr result set # before it fetch the next tuple from the scanned table. # The next mrr operation would then still have an open scan which wasn't # cleaned up as expected. This may cause all available NdbOperation, # NdbTransaction or lock objects to be consumed before the operation # could finish. ##################### create table t1 (pk int primary key, a int) engine=ndb; create table t2 (pk int primary key, a int) engine=ndb; insert into t2 values (0,0), (1,1), (2,2), (3,3), (4,4), (5,5), (6,6), (7,7), (8,8), (9,9); ## # 10^4 cross product on t2 creates 10.000 rows: # Insert volume has been tunes to insert only 3.000 # of these as this is sufficient to produce an 'out of connection objects' ## insert into t1 select t1.a + t2.a*10 + t3.a*100 + t4.a*1000, (t1.a + t2.a*10 + t3.a*100 + t4.a*1000) / 1000 from t2 as t1, t2 as t2, t2 as t3, t2 as t4 where (t1.a + t2.a*10 + t3.a*100 + t4.a*1000) < 3000; # Execute a 'scan(t1) join mrr(t2)' # - 'DISTINCT t1.pk' will cause optimizer to stop fetching mrr(t2) # when the first matching 't2.a = t1.a' is found. # - 'LEFT JOIN' is to ensure that 'Using join buffer' is *not* used # set optimizer_switch='block_nested_loop=off'; explain SELECT DISTINCT STRAIGHT_JOIN t1.pk FROM t1 LEFT JOIN t2 ON t2.a = t1.a AND t2.pk != 6; --disable_result_log SELECT DISTINCT STRAIGHT_JOIN t1.pk FROM t1 LEFT JOIN t2 ON t2.a = t1.a AND t2.pk != 6; --enable_result_log set optimizer_switch='block_nested_loop=default'; drop table t1, t2;
Close