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.140.247.39
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_index_ordered.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, test1, test2; --enable_warnings # # Simple test to show use of ordered indexes # CREATE TABLE t1 ( a int unsigned NOT NULL PRIMARY KEY, b int unsigned not null, c int unsigned, KEY(b) ) engine=ndbcluster; insert t1 values(1, 2, 3), (2,3, 5), (3, 4, 6), (4, 5, 8), (5,6, 2), (6,7, 2); select * from t1 order by b; select * from t1 where b >= 4 order by b; select * from t1 where b = 4 order by b; select * from t1 where b > 4 order by b; select * from t1 where b < 4 order by b; select * from t1 where b <= 4 order by b; # Test of reset_bounds select tt1.* from t1 as tt1, t1 as tt2 use index(b) where tt1.b = tt2.b order by tt1.b; select a, b, c from t1 where a!=2 and c=6; select a, b, c from t1 where a!=2 order by a; # # Here we should add some "explain select" to verify that the ordered index is # used for these queries. # # # Update using ordered index scan # update t1 set c = 3 where b = 3; select * from t1 order by a; update t1 set c = 10 where b >= 6; select * from t1 order by a; update t1 set c = 11 where b < 5; select * from t1 order by a; update t1 set c = 12 where b > 0; select * from t1 order by a; update t1 set c = 13 where b <= 3; select * from t1 order by a; update t1 set b = b + 1 where b > 4 and b < 7; select * from t1 order by a; # Update primary key update t1 set a = a + 10 where b > 1 and b < 7; select * from t1 order by a; # # Delete using ordered index scan # drop table t1; CREATE TABLE t1 ( a int unsigned NOT NULL PRIMARY KEY, b int unsigned not null, c int unsigned, KEY(b) ) engine=ndbcluster; insert t1 values(1, 2, 13), (2,3, 13), (3, 4, 12), (4, 5, 12), (5,6, 12), (6,7, 12); delete from t1 where b = 3; select * from t1 order by a; delete from t1 where b >= 6; select * from t1 order by a; delete from t1 where b < 4; select * from t1 order by a; delete from t1 where b > 5; select * from t1 order by a; delete from t1 where b <= 4; select * from t1 order by a; drop table t1; # #multi part key # CREATE TABLE t1 ( a int unsigned NOT NULL PRIMARY KEY, b int unsigned not null, c int unsigned not null ) engine = ndb; create index a1 on t1 (b, c); insert into t1 values (1, 2, 13); insert into t1 values (2,3, 13); insert into t1 values (3, 4, 12); insert into t1 values (4, 5, 12); insert into t1 values (5,6, 12); insert into t1 values (6,7, 12); insert into t1 values (7, 2, 1); insert into t1 values (8,3, 6); insert into t1 values (9, 4, 12); insert into t1 values (14, 5, 4); insert into t1 values (15,5,5); insert into t1 values (16,5, 6); insert into t1 values (17,4,4); insert into t1 values (18,1, 7); select * from t1 order by a; select * from t1 where b<=5 order by a; select * from t1 where b<=5 and c=0; insert into t1 values (19,4, 0); select * from t1 where b<=5 and c=0; select * from t1 where b=4 and c<=5 order by a; select * from t1 where b<=4 and c<=5 order by a; select * from t1 where b<=5 and c=0 or b<=5 and c=2; select count(*) from t1 where b = 0; select count(*) from t1 where b = 1; drop table t1; # # Indexing NULL values # CREATE TABLE t1 ( a int unsigned NOT NULL PRIMARY KEY, b int unsigned, c int unsigned, KEY bc(b,c) ) engine = ndb; insert into t1 values(1,1,1),(2,NULL,2),(3,NULL,NULL),(4,4,NULL); select * from t1 use index (bc) where b IS NULL order by a; select * from t1 use index (bc)order by a; select * from t1 use index (bc) order by a; select * from t1 use index (PRIMARY) where b IS NULL order by a; select * from t1 use index (bc) where b IS NULL order by a; select * from t1 use index (bc) where b IS NULL and c IS NULL order by a; select * from t1 use index (bc) where b IS NULL and c = 2 order by a; select * from t1 use index (bc) where b < 4 order by a; select * from t1 use index (bc) where b IS NOT NULL order by a; drop table t1; # # Order by again, including descending. # create table t1 ( a int unsigned primary key, b int unsigned, c char(10), key bc (b, c) ) engine=ndb; insert into t1 values(1,1,'a'),(2,2,'b'),(3,3,'c'),(4,4,'d'),(5,5,'e'); insert into t1 select a*7,10*b,'f' from t1; insert into t1 select a*13,10*b,'g' from t1; insert into t1 select a*17,10*b,'h' from t1; insert into t1 select a*19,10*b,'i' from t1; insert into t1 select a*23,10*b,'j' from t1; insert into t1 select a*29,10*b,'k' from t1; # select b, c from t1 where b <= 10 and c <'f' order by b, c; select b, c from t1 where b <= 10 and c <'f' order by b desc, c desc; # select b, c from t1 where b=4000 and c<'k' order by b, c; select b, c from t1 where b=4000 and c<'k' order by b desc, c desc; select b, c from t1 where 1000<=b and b<=100000 and c<'j' order by b, c; select b, c from t1 where 1000<=b and b<=100000 and c<'j' order by b desc, c desc; # select min(b), max(b) from t1; # drop table t1; # # Bug #6435 CREATE TABLE test1 ( SubscrID int(11) NOT NULL auto_increment, UsrID int(11) NOT NULL default '0', PRIMARY KEY (SubscrID), KEY idx_usrid (UsrID) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1; INSERT INTO test1 VALUES (2,224),(3,224),(1,224); CREATE TABLE test2 ( SbclID int(11) NOT NULL auto_increment, SbcrID int(11) NOT NULL default '0', PRIMARY KEY (SbclID), KEY idx_sbcrid (SbcrID) ) ENGINE=ndbcluster DEFAULT CHARSET=latin1; INSERT INTO test2 VALUES (3,2),(1,1),(2,1),(4,2); select * from test1 order by 1; select * from test2 order by 1; SELECT s.SubscrID,l.SbclID FROM test1 s left JOIN test2 l ON l.SbcrID=s.SubscrID WHERE s.UsrID=224 order by 1, 2; drop table test1; drop table test2; # bug#7424 + bug#7725 create table t1 ( pk int primary key, dt datetime not null, da date not null, ye year not null, ti time not null, ts timestamp not null, index(dt), index(da), index(ye), index(ti), index(ts) ) engine=ndb; insert into t1 (pk,dt,da,ye,ti,ts) values (1, '1901-05-05 23:00:59', '1901-05-05', '1901', '23:00:59', '2001-01-01 23:00:59'), (2, '1912-09-05 13:00:59', '1912-09-05', '1912', '13:00:59', '2001-01-01 13:00:59'), (3, '1945-12-31 00:00:00', '1945-12-31', '1945', '00:00:00', '2001-01-01 00:00:00'), (4, '1955-12-31 00:00:00', '1955-12-31', '1955', '00:00:00', '2001-01-01 00:00:00'), (5, '1963-06-06 06:06:06', '1963-06-06', '1963', '06:06:06', '2001-01-01 06:06:06'), (6, '1993-06-06 06:06:06', '1993-06-06', '1993', '06:06:06', '2001-01-01 06:06:06'), (7, '2001-01-01 10:11:10', '2001-01-01', '2001', '10:11:10', '2001-01-01 10:11:10'), (8, '2001-01-01 10:11:11', '2001-01-01', '2001', '10:11:11', '2001-01-01 10:11:11'), (9, '2005-01-31 23:59:59', '2005-01-31', '2005', '23:59:59', '2001-01-01 23:59:59'); # datetime select count(*)-9 from t1 use index (dt) where dt > '1900-01-01 00:00:00'; select count(*)-6 from t1 use index (dt) where dt >= '1955-12-31 00:00:00'; select count(*)-5 from t1 use index (dt) where dt > '1955-12-31 00:00:00'; select count(*)-5 from t1 use index (dt) where dt < '1970-03-03 22:22:22'; select count(*)-7 from t1 use index (dt) where dt < '2001-01-01 10:11:11'; select count(*)-8 from t1 use index (dt) where dt <= '2001-01-01 10:11:11'; select count(*)-9 from t1 use index (dt) where dt <= '2055-01-01 00:00:00'; # date select count(*)-9 from t1 use index (da) where da > '1900-01-01'; select count(*)-6 from t1 use index (da) where da >= '1955-12-31'; select count(*)-5 from t1 use index (da) where da > '1955-12-31'; select count(*)-5 from t1 use index (da) where da < '1970-03-03'; select count(*)-6 from t1 use index (da) where da < '2001-01-01'; select count(*)-8 from t1 use index (da) where da <= '2001-01-02'; select count(*)-9 from t1 use index (da) where da <= '2055-01-01'; # year select count(*)-9 from t1 use index (ye) where ye > '1900'; select count(*)-6 from t1 use index (ye) where ye >= '1955'; select count(*)-5 from t1 use index (ye) where ye > '1955'; select count(*)-5 from t1 use index (ye) where ye < '1970'; select count(*)-6 from t1 use index (ye) where ye < '2001'; select count(*)-8 from t1 use index (ye) where ye <= '2001'; select count(*)-9 from t1 use index (ye) where ye <= '2055'; # time select count(*)-9 from t1 use index (ti) where ti >= '00:00:00'; select count(*)-7 from t1 use index (ti) where ti > '00:00:00'; select count(*)-7 from t1 use index (ti) where ti > '05:05:05'; select count(*)-5 from t1 use index (ti) where ti > '06:06:06'; select count(*)-5 from t1 use index (ti) where ti < '10:11:11'; select count(*)-6 from t1 use index (ti) where ti <= '10:11:11'; select count(*)-8 from t1 use index (ti) where ti < '23:59:59'; select count(*)-9 from t1 use index (ti) where ti <= '23:59:59'; # timestamp select count(*)-9 from t1 use index (ts) where ts >= '2001-01-01 00:00:00'; select count(*)-7 from t1 use index (ts) where ts > '2001-01-01 00:00:00'; select count(*)-7 from t1 use index (ts) where ts > '2001-01-01 05:05:05'; select count(*)-5 from t1 use index (ts) where ts > '2001-01-01 06:06:06'; select count(*)-5 from t1 use index (ts) where ts < '2001-01-01 10:11:11'; select count(*)-6 from t1 use index (ts) where ts <= '2001-01-01 10:11:11'; select count(*)-8 from t1 use index (ts) where ts < '2001-01-01 23:59:59'; select count(*)-9 from t1 use index (ts) where ts <= '2001-01-01 23:59:59'; drop table t1; # decimal (not the new 5.0 thing) create table t1 ( a int primary key, s decimal(12), t decimal(12, 5), u decimal(12) unsigned, v decimal(12, 5) unsigned, key (s), key (t), key (u), key (v) ) engine=ndb; # insert into t1 values ( 0, -000000000007, -0000061.00003, 000000000061, 0000965.00042), ( 1, -000000000007, -0000061.00042, 000000000061, 0000965.00003), ( 2, -071006035767, 4210253.00024, 000000000001, 0000001.84488), ( 3, 000000007115, 0000000.77607, 000077350625, 0000018.00013), ( 4, -000000068391, -0346486.00000, 000000005071, 0005334.00002), ( 5, -521579890459, -1936874.00001, 000000000154, 0000003.00018), ( 6, -521579890459, -1936874.00018, 000000000154, 0000003.00001), ( 7, 000000000333, 0000051.39140, 000000907958, 0788643.08374), ( 8, 000042731229, 0000009.00000, 000000000009, 6428667.00000), ( 9, -000008159769, 0000918.00004, 000096951421, 7607730.00008); # select count(*)- 5 from t1 use index (s) where s < -000000000007; select count(*)- 7 from t1 use index (s) where s <= -000000000007; select count(*)- 2 from t1 use index (s) where s = -000000000007; select count(*)- 5 from t1 use index (s) where s >= -000000000007; select count(*)- 3 from t1 use index (s) where s > -000000000007; # select count(*)- 4 from t1 use index (t) where t < -0000061.00003; select count(*)- 5 from t1 use index (t) where t <= -0000061.00003; select count(*)- 1 from t1 use index (t) where t = -0000061.00003; select count(*)- 6 from t1 use index (t) where t >= -0000061.00003; select count(*)- 5 from t1 use index (t) where t > -0000061.00003; # select count(*)- 2 from t1 use index (u) where u < 000000000061; select count(*)- 4 from t1 use index (u) where u <= 000000000061; select count(*)- 2 from t1 use index (u) where u = 000000000061; select count(*)- 8 from t1 use index (u) where u >= 000000000061; select count(*)- 6 from t1 use index (u) where u > 000000000061; # select count(*)- 5 from t1 use index (v) where v < 0000965.00042; select count(*)- 6 from t1 use index (v) where v <= 0000965.00042; select count(*)- 1 from t1 use index (v) where v = 0000965.00042; select count(*)- 5 from t1 use index (v) where v >= 0000965.00042; select count(*)- 4 from t1 use index (v) where v > 0000965.00042; drop table t1; # mysqld 5.0.13 crash, no bug# create table t1 (a int, c varchar(10), primary key using hash (a), index(c)) engine=ndb; insert into t1 (a, c) values (1,'aaa'),(3,'bbb'); select count(*) from t1 where c<'bbb'; drop table t1; # index stats v4: old v2 tests are not meaningful and are removed # End of 4.1 tests # bug#24039 create table t1 (a int primary key) engine = ndb; insert into t1 values (1), (2), (3); begin; delete from t1 where a > 1; rollback; select * from t1 order by a; begin; delete from t1 where a > 1; rollback; begin; select * from t1 order by a; delete from t1 where a > 2; select * from t1 order by a; delete from t1 where a > 1; select * from t1 order by a; delete from t1 where a > 0; select * from t1 order by a; rollback; select * from t1 order by a; delete from t1; drop table t1; # bug#24820 CREATE INDEX ....USING HASH on NDB table creates ordered index, not HASH index --error ER_UNSUPPORTED_EXTENSION create table nationaldish (DishID int(10) unsigned NOT NULL AUTO_INCREMENT, CountryCode char(3) NOT NULL, DishTitle varchar(64) NOT NULL, calories smallint(5) unsigned DEFAULT NULL, PRIMARY KEY (DishID), INDEX i USING HASH (countrycode,calories) ) ENGINE=ndbcluster; create table nationaldish (DishID int(10) unsigned NOT NULL AUTO_INCREMENT, CountryCode char(3) NOT NULL, DishTitle varchar(64) NOT NULL, calories smallint(5) unsigned DEFAULT NULL, PRIMARY KEY (DishID) ) ENGINE=ndbcluster; --error ER_UNSUPPORTED_EXTENSION create index i on nationaldish(countrycode,calories) using hash; drop table nationaldish; # bug#42857 Got error 4541 -IndexBound has no bound information- from NDBCLUSTER # Test that query returns results expected drop table if exists t1; create table t1(c1 varchar(20) primary key, c2 char(20)) engine=ndbcluster; insert into t1(c1,c2) values ('ddd','jg'); select * from t1 where (c2 < 'b' AND c1 <> 'g') OR (c2 <> 'a' AND c1 <> 'd'); drop table t1; # bug#45053 xfrm buffer overflow in TUX # 3*1024 = 3072 = max bytes in MySQL key --disable_warnings drop table if exists t1; --enable_warnings create table t1 ( a int unsigned, b varchar(1024) not null, primary key using hash (a), index x1 (b) ) engine = ndbcluster default charset = utf8 collate = utf8_unicode_ci; insert into t1 values (1,'a'),(2,'y'),(3,'z'); select * from t1 where b = 'b'; select * from t1 where b = 'a'; drop table t1; # bug#57396 MRR empty range sets wrong index attr id --echo # bug#57396 create table t1 (a int not null, b int not null, primary key (b,a)) engine=ndb; insert into t1(a,b) values(0,0); select * from t1 where b < 8 or b >= 8; drop table t1; # bug#56853 missing shrink varchar in index bound dist key check --echo # bug#56853 create table t1 ( x varchar(16) not null, primary key (x) ) character set latin1 collate latin1_swedish_ci engine ndb partition by key (x) partitions 8; # like % works here insert into t1 (x) values ('aaa'); insert into t1 (x) values ('bbb'); insert into t1 (x) values ('ccc'); insert into t1 (x) values ('ddd'); select x from t1 where x like 'aa%'; select x from t1 where x like 'aa_'; select x from t1 where x like 'bb%'; select x from t1 where x like 'bb_'; select x from t1 where x like 'cc%'; select x from t1 where x like 'cc_'; select x from t1 where x like 'dd%'; select x from t1 where x like 'dd_'; drop table t1; # show same bug with like % create table t1 ( x varchar(4) not null, primary key (x) ) character set latin1 collate latin1_swedish_ci engine ndb partition by key (x) partitions 8; insert into t1 (x) values ('aaaa'); insert into t1 (x) values ('bbbb'); insert into t1 (x) values ('cccc'); insert into t1 (x) values ('dddd'); select x from t1 where x like 'aaa%'; select x from t1 where x like 'aaa_'; select x from t1 where x like 'bbb%'; select x from t1 where x like 'bbb_'; select x from t1 where x like 'ccc%'; select x from t1 where x like 'ccc_'; select x from t1 where x like 'ddd%'; select x from t1 where x like 'ddd_'; drop table t1;
Close