Gecko [ www.jdcpatala.org ]

Name	Size	Permission
bug36547.result	455 B	-rw-r--r--
loaddata_autocom_ndb.result	740 B	-rw-r--r--
ndb_add_partition.result	13.36 KB	-rw-r--r--
ndb_addnode_restart.result	384 B	-rw-r--r--
ndb_addnode_restart2.result	454 B	-rw-r--r--
ndb_alter_table.result	19.49 KB	-rw-r--r--
ndb_alter_table2.result	685 B	-rw-r--r--
ndb_alter_table3.result	1.48 KB	-rw-r--r--
ndb_alter_table_backup.result	1.76 KB	-rw-r--r--
ndb_alter_table_dml.result	1.83 KB	-rw-r--r--
ndb_alter_table_error.result	664 B	-rw-r--r--
ndb_alter_table_online.result	29.02 KB	-rw-r--r--
ndb_alter_table_online2.result	3.21 KB	-rw-r--r--
ndb_alter_table_online_multi.r...	2 KB	-rw-r--r--
ndb_auto_increment.result	11.49 KB	-rw-r--r--
ndb_autoinc.result	2.69 KB	-rw-r--r--
ndb_backup_rate.result	912 B	-rw-r--r--
ndb_basic.result	32.68 KB	-rw-r--r--
ndb_bitfield.result	8.39 KB	-rw-r--r--
ndb_blob.result	26.47 KB	-rw-r--r--
ndb_blob_big.result	1.24 KB	-rw-r--r--
ndb_blob_partition.result	9.03 KB	-rw-r--r--
ndb_bug13563280.result	224 B	-rw-r--r--
ndb_bug14166590.result	416 B	-rw-r--r--
ndb_bug17624736.result	1.71 KB	-rw-r--r--
ndb_bug17719439.result	439 B	-rw-r--r--
ndb_bug19390895.result	1.67 KB	-rw-r--r--
ndb_bug26793.result	286 B	-rw-r--r--
ndb_bug31477.result	1.85 KB	-rw-r--r--
ndb_bulk_delete.result	1.87 KB	-rw-r--r--
ndb_bushy_joins.result	88.95 KB	-rw-r--r--
ndb_cache.result	9.35 KB	-rw-r--r--
ndb_cache2.result	13.9 KB	-rw-r--r--
ndb_cache_multi.result	2.44 KB	-rw-r--r--
ndb_cache_multi2.result	3.04 KB	-rw-r--r--
ndb_cache_trans.result	6.65 KB	-rw-r--r--
ndb_charset.result	5.77 KB	-rw-r--r--
ndb_checksum.result	38 B	-rw-r--r--
ndb_column_properties.result	16.01 KB	-rw-r--r--
ndb_condition_pushdown.result	131.71 KB	-rw-r--r--
ndb_config.result	3.36 KB	-rw-r--r--
ndb_config2.result	475 B	-rw-r--r--
ndb_create_table.result	1.02 KB	-rw-r--r--
ndb_cursor.result	792 B	-rw-r--r--
ndb_database.result	1.25 KB	-rw-r--r--
ndb_dbug_lock.result	1.64 KB	-rw-r--r--
ndb_dbug_tc_select.result	6.71 KB	-rw-r--r--
ndb_dd_alter.result	28.43 KB	-rw-r--r--
ndb_dd_basic.result	21.17 KB	-rw-r--r--
ndb_dd_bug12581213.result	334 B	-rw-r--r--
ndb_dd_ddl.result	5.94 KB	-rw-r--r--
ndb_dd_disk2memory.result	15.44 KB	-rw-r--r--
ndb_dd_dump.result	15.97 KB	-rw-r--r--
ndb_dd_initial_lg.result	941 B	-rw-r--r--
ndb_dd_restore_check_tablespac...	8.3 KB	-rw-r--r--
ndb_dd_restore_compat.result	3.73 KB	-rw-r--r--
ndb_dd_sql_features.result	22.62 KB	-rw-r--r--
ndb_ddl_open_trans.result	1.44 KB	-rw-r--r--
ndb_disconnect_ddl.result	291 B	-rw-r--r--
ndb_discover_db.result	1.92 KB	-rw-r--r--
ndb_dist_priv.result	6.36 KB	-rw-r--r--
ndb_dist_priv_bug_13340854.res...	248 B	-rw-r--r--
ndb_err4012.result	2.22 KB	-rw-r--r--
ndb_error_reporter.result	5.61 KB	-rw-r--r--
ndb_fired_trigger_shortage.res...	694 B	-rw-r--r--
ndb_fk_addnode.result	1.39 KB	-rw-r--r--
ndb_fk_alter.result	8.34 KB	-rw-r--r--
ndb_fk_bugs.result	27.58 KB	-rw-r--r--
ndb_fk_build.result	2.31 KB	-rw-r--r--
ndb_fk_cascade_delete.result	4.82 KB	-rw-r--r--
ndb_fk_cascade_delete_multi.re...	2.56 KB	-rw-r--r--
ndb_fk_cascade_update.result	1.66 KB	-rw-r--r--
ndb_fk_create_drop.result	4.8 KB	-rw-r--r--
ndb_fk_db.result	7.18 KB	-rw-r--r--
ndb_fk_deferred_cascade.result	2.82 KB	-rw-r--r--
ndb_fk_disable.result	11.64 KB	-rw-r--r--
ndb_fk_is.result	8.49 KB	-rw-r--r--
ndb_fk_locase.result	2.44 KB	-rw-r--r--
ndb_fk_locking.result	1.47 KB	-rw-r--r--
ndb_fk_multi_column.result	2.04 KB	-rw-r--r--
ndb_fk_mysqldump.result	2.93 KB	-rw-r--r--
ndb_fk_mysqldump2.result	72 B	-rw-r--r--
ndb_fk_no_fk.result	30.14 KB	-rw-r--r--
ndb_fk_no_fk_legacy.result	2.77 KB	-rw-r--r--
ndb_fk_noaction.result	5.68 KB	-rw-r--r--
ndb_fk_resources.result	2.58 KB	-rw-r--r--
ndb_fk_restore.result	14.08 KB	-rw-r--r--
ndb_fk_restrict.result	6.82 KB	-rw-r--r--
ndb_fk_self_ref.result	3.74 KB	-rw-r--r--
ndb_fk_setdefault.result	1.03 KB	-rw-r--r--
ndb_fk_setnull.result	3.23 KB	-rw-r--r--
ndb_global_schema_lock.result	3.6 KB	-rw-r--r--
ndb_global_schema_lock_error.r...	1.88 KB	-rw-r--r--
ndb_grant.result	17.65 KB	-rw-r--r--
ndb_hashmap.result	624 B	-rw-r--r--
ndb_hidden_pk.result	10.55 KB	-rw-r--r--
ndb_index.result	17.84 KB	-rw-r--r--
ndb_index_ordered.result	16.73 KB	-rw-r--r--
ndb_index_stat.result	17.74 KB	-rw-r--r--
ndb_index_stat_partitions.resu...	3.82 KB	-rw-r--r--
ndb_index_stat_restart.result	2.2 KB	-rw-r--r--
ndb_index_unique.result	20.29 KB	-rw-r--r--
ndb_insert.result	36.52 KB	-rw-r--r--
ndb_join_pushdown_bka.result	949.68 KB	-rw-r--r--
ndb_join_pushdown_default.resu...	865.61 KB	-rw-r--r--
ndb_join_pushdown_nobnl.result	864.87 KB	-rw-r--r--
ndb_join_pushdown_none.result	865.08 KB	-rw-r--r--
ndb_limit.result	1.99 KB	-rw-r--r--
ndb_load.result	2.66 KB	-rw-r--r--
ndb_loaddatalocal.result	1.57 KB	-rw-r--r--
ndb_lock.result	4.17 KB	-rw-r--r--
ndb_lock_table.result	205 B	-rw-r--r--
ndb_many_fragments.result	26.72 KB	-rw-r--r--
ndb_mgm.result	5.7 KB	-rw-r--r--
ndb_mgmd.result	198 B	-rw-r--r--
ndb_minmax.result	1.47 KB	-rw-r--r--
ndb_multi.result	8.83 KB	-rw-r--r--
ndb_multi_row.result	1.33 KB	-rw-r--r--
ndb_multi_update_delete.result	1.83 KB	-rw-r--r--
ndb_native_default_support.res...	50.29 KB	-rw-r--r--
ndb_one_fragment.result	4.05 KB	-rw-r--r--
ndb_optimize_table.result	2 KB	-rw-r--r--
ndb_optimized_node_selection.r...	1017 B	-rw-r--r--
ndb_partition_error.result	1.44 KB	-rw-r--r--
ndb_partition_error2.result	150 B	-rw-r--r--
ndb_partition_hash.result	890 B	-rw-r--r--
ndb_partition_key.result	8.82 KB	-rw-r--r--
ndb_partition_list.result	2.31 KB	-rw-r--r--
ndb_partition_range.result	7.91 KB	-rw-r--r--
ndb_print_file.result	709 B	-rw-r--r--
ndb_rbwr.result	0 B	-rw-r--r--
ndb_read_multi_range.result	15 KB	-rw-r--r--
ndb_reconnect.result	1.7 KB	-rw-r--r--
ndb_rename.result	910 B	-rw-r--r--
ndb_replace.result	3.64 KB	-rw-r--r--
ndb_restore_bug17916243.result	537 B	-rw-r--r--
ndb_restore_compat_downward.re...	132.43 KB	-rw-r--r--
ndb_restore_compat_endianness....	10.97 KB	-rw-r--r--
ndb_restore_conv_lossy_charbin...	15.46 KB	-rw-r--r--
ndb_restore_conv_lossy_integra...	20.72 KB	-rw-r--r--
ndb_restore_conv_more.result	56.57 KB	-rw-r--r--
ndb_restore_conv_padding.resul...	6.14 KB	-rw-r--r--
ndb_restore_conv_promotion.res...	23.26 KB	-rw-r--r--
ndb_restore_discover.result	540 B	-rw-r--r--
ndb_restore_misc.result	25.16 KB	-rw-r--r--
ndb_restore_print.result	9.8 KB	-rw-r--r--
ndb_restore_schema_blobs.resul...	6.44 KB	-rw-r--r--
ndb_restore_schema_partitions....	13.25 KB	-rw-r--r--
ndb_restore_schema_rewrites.re...	12.22 KB	-rw-r--r--
ndb_restore_schema_subsets.res...	95.9 KB	-rw-r--r--
ndb_restore_schema_tolerance.r...	4.53 KB	-rw-r--r--
ndb_restore_undolog.result	18.76 KB	-rw-r--r--
ndb_row_count.result	5.19 KB	-rw-r--r--
ndb_row_format.result	1.74 KB	-rw-r--r--
ndb_select_count.result	334 B	-rw-r--r--
ndb_share.result	11.29 KB	-rw-r--r--
ndb_short_sigs.result	2.54 KB	-rw-r--r--
ndb_single_user.result	4.01 KB	-rw-r--r--
ndb_sp.result	1.17 KB	-rw-r--r--
ndb_spj_dict.result	11.63 KB	-rw-r--r--
ndb_sql_allow_batching.result	918 B	-rw-r--r--
ndb_startup.result	358 B	-rw-r--r--
ndb_statistics0.result	16.23 KB	-rw-r--r--
ndb_statistics1.result	15.99 KB	-rw-r--r--
ndb_subquery.result	9.29 KB	-rw-r--r--
ndb_suma_handover.result	427 B	-rw-r--r--
ndb_temporary.result	949 B	-rw-r--r--
ndb_tmp_table_and_DDL.result	3.11 KB	-rw-r--r--
ndb_transaction.result	4.62 KB	-rw-r--r--
ndb_trigger.result	9.38 KB	-rw-r--r--
ndb_truncate.result	425 B	-rw-r--r--
ndb_types.result	4.91 KB	-rw-r--r--
ndb_update.result	2.97 KB	-rw-r--r--
ndb_update_no_read.result	11.23 KB	-rw-r--r--
ndb_view.result	597 B	-rw-r--r--
ndb_wait_until_ready.result	533 B	-rw-r--r--
ndb_wl946_main.result	19.39 KB	-rw-r--r--
ndb_wl946_post.result	3.7 KB	-rw-r--r--
ndb_wl946_pre.result	6.62 KB	-rw-r--r--
ndbapi-examples.result	3.34 KB	-rw-r--r--
ndbinfo.result	44.04 KB	-rw-r--r--
ndbinfo_cache.result	775 B	-rw-r--r--
ndbinfo_dump.result	95 B	-rw-r--r--
ndbinfo_upgrade.result	382 B	-rw-r--r--
ps_7ndb.result	103.05 KB	-rw-r--r--
strict_autoinc_5ndb.result	894 B	-rw-r--r--
wl10837.result	524 B	-rw-r--r--

Code Editor : ndb_index.result

drop table if exists t1;
CREATE TABLE t1 (
PORT varchar(16) NOT NULL,
ACCESSNODE varchar(16) NOT NULL,
POP varchar(48) NOT NULL,
ACCESSTYPE int unsigned NOT NULL,
CUSTOMER_ID varchar(20) collate latin1_bin NOT NULL,
PROVIDER varchar(16),
TEXPIRE int unsigned,
NUM_IP int unsigned,
LEASED_NUM_IP int unsigned,
LOCKED_IP int unsigned,
STATIC_DNS int unsigned,
SUSPENDED_SERVICE int unsigned,
SUSPENDED_REASON int unsigned,
BGP_COMMUNITY int unsigned,
INDEX CUSTOMER_ID_INDEX(CUSTOMER_ID),
INDEX FQPN_INDEX(POP,ACCESSNODE,PORT),
PRIMARY KEY(POP,ACCESSNODE,PORT,ACCESSTYPE)
) engine=ndbcluster;
INSERT INTO t1 VALUES ('port67', 'node78', 'pop98', 1, 'kllopmn', 'pr_43', 121212, 1, 2, 3, 8, NULL, NULL, NULL);
INSERT INTO t1 VALUES ('port67', 'node78', 'pop99', 2, 'klkighh', 'pr_44', 121213, 3, 3, 6, 7, NULL, NULL, NULL);
INSERT INTO t1 VALUES ('port79', 'node79', 'pop79', 2, 'kpongfaa', 'pr_44', 981213, 2, 4, 10, 11, 2, 99, 1278);
select port, accessnode, pop, accesstype  from t1 where port='port67' order by accesstype;
port	accessnode	pop	accesstype
port67	node78	pop98	1
port67	node78	pop99	2
select port, accessnode, pop, accesstype  from t1 where port='foo';
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype  from t1 where accessnode='node78' order by accesstype;
port	accessnode	pop	accesstype
port67	node78	pop98	1
port67	node78	pop99	2
select port, accessnode, pop, accesstype  from t1 where accessnode='foo';
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype  from t1 where pop='pop98';
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode, pop, accesstype  from t1 where pop='pop98';
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode, pop, accesstype  from t1 where pop='pop98';
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode, pop, accesstype  from t1 where pop='pop98' order by accesstype;
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode, pop, accesstype  from t1 where pop='foo';
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype  from t1 where accesstype=1;
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode, pop, accesstype  from t1 where accesstype=2 order by port;
port	accessnode	pop	accesstype
port67	node78	pop99	2
port79	node79	pop79	2
select port, accessnode, pop, accesstype  from t1 where accesstype=98 order by port;
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype  from t1 where customer_id='kllopmn';
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode, pop, accesstype  from t1 where customer_id='KLLOPMN';
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype  from t1 where customer_id='kLLoPMn';
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype  from t1 where customer_id='foo';
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype  from t1 where provider='pr_43';
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode, pop, accesstype  from t1 where provider='foo';
port	accessnode	pop	accesstype
select port, accessnode from t1 where texpire=121212;
port	accessnode
port67	node78
select port, accessnode from t1 where texpire=2323;
port	accessnode
select port, accessnode, pop, accesstype  from t1 where num_ip=1;
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode, pop, accesstype  from t1 where num_ip=89;
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype  from t1 where leased_num_ip=2;
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode, pop, accesstype  from t1 where leased_num_ip=89;
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype  from t1 where locked_ip=3;
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode, pop, accesstype  from t1 where locked_ip=89;
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype  from t1 where static_dns=8;
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode, pop, accesstype  from t1 where static_dns=89;
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype  from t1 where suspended_service=8;
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype  from t1 where suspended_service=89;
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype  from t1 where suspended_reason=NULL;
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype  from t1 where suspended_reason=89;
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype  from t1 where suspended_reason=0;
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype  from t1 where bgp_community=NULL;
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype  from t1 where bgp_community=89;
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype  from t1 where bgp_community=0;
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype from t1 where port='port67' and accessnode='node78' and pop='pop98' and accesstype=1;
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode, pop, accesstype from t1 where port='port67' and accesstype=1 and accessnode='node78' and pop='pop98';
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode, pop, accesstype from t1 where pop='pop98' and port='port67' and accesstype=1 and accessnode='node78';
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode from t1 where port='foo' and accessnode='foo' and pop='foo' and accesstype=99;
port	accessnode
select port, accessnode, pop, accesstype from t1 where port='port67' and pop='pop98' and accesstype=1;
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode, pop, accesstype from t1 where accesstype=1 and accessnode='node78' and pop='pop98';
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode, pop, accesstype from t1 where  port='port67' and accesstype=1 and accessnode='node78';
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode from t1 where port='foo' and accessnode='foo' and pop='foo';
port	accessnode
select port, accessnode, pop, accesstype  from t1 where customer_id='kllopmn';
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode, pop, accesstype  from t1 where customer_id='kllopmn' and accesstype=1;
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode, pop, accesstype  from t1 where customer_id='kllopmn' and accesstype=2;
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype  from t1 where accesstype=2 and customer_id='kllopmn';
port	accessnode	pop	accesstype
select port, accessnode, pop, accesstype  from t1 where pop='pop98' and accessnode='node78' and port='port67';
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode, pop, accesstype  from t1 where pop='pop98' and accessnode='node78' and port='port67' and customer_id='kllopmn';
port	accessnode	pop	accesstype
port67	node78	pop98	1
select port, accessnode, pop, accesstype  from t1 where pop='pop98' and accessnode='node78' and port='port67' and customer_id='foo';
port	accessnode	pop	accesstype
drop table t1;
create table t1 (
a int not null primary key,
c00 int not null, c01 int not null, c02 int not null, c03 int not null, c04 int not null, c05 int not null, c06 int not null, c07 int not null,
c10 int not null, c11 int not null, c12 int not null, c13 int not null, c14 int not null, c15 int not null, c16 int not null, c17 int not null,
c20 int not null, c21 int not null, c22 int not null, c23 int not null, c24 int not null, c25 int not null, c26 int not null, c27 int not null,
c30 int not null, c31 int not null, c32 int not null, c33 int not null, c34 int not null, c35 int not null, c36 int not null, c37 int not null,
c40 int not null, c41 int not null, c42 int not null, c43 int not null, c44 int not null, c45 int not null, c46 int not null, c47 int not null,
c50 int not null, c51 int not null, c52 int not null, c53 int not null, c54 int not null, c55 int not null, c56 int not null, c57 int not null,
c60 int not null, c61 int not null, c62 int not null, c63 int not null, c64 int not null, c65 int not null, c66 int not null, c67 int not null,
c70 int not null, c71 int not null, c72 int not null, c73 int not null, c74 int not null, c75 int not null, c76 int not null, c77 int not null,
unique (c00), unique (c01), unique (c02), unique (c03), unique (c04), unique (c05), unique (c06), unique (c07),
unique (c10), unique (c11), unique (c12), unique (c13), unique (c14), unique (c15), unique (c16), unique (c17),
unique (c20), unique (c21), unique (c22), unique (c23), unique (c24), unique (c25), unique (c26), unique (c27),
unique (c30), unique (c31), unique (c32), unique (c33), unique (c34), unique (c35), unique (c36), unique (c37),
unique (c40), unique (c41), unique (c42), unique (c43), unique (c44), unique (c45), unique (c46), unique (c47),
unique (c50), unique (c51), unique (c52), unique (c53), unique (c54), unique (c55), unique (c56), unique (c57),
unique (c60), unique (c61), unique (c62), unique (c63), unique (c64), unique (c65), unique (c66), unique (c67),
unique (c70), unique (c71), unique (c72), unique (c73), unique (c74), unique (c75), unique (c76)) engine = ndb;
drop table t1;
CREATE TABLE t1 (
a INT NOT NULL AUTO_INCREMENT ,
b INT NOT NULL ,
c VARCHAR ( 11 ) NOT NULL ,
PRIMARY KEY ( a ) ,
INDEX ( b )
) ENGINE = NDB;
INSERT INTO t1 (a ,b ,c) VALUES 
(NULL , '1', 'test'), (NULL , '2', 'test'), (NULL , '1', 'test'), 
(NULL , '2', 'test'), (NULL , '3', 'test'), (NULL , '4', 'test'), 
(NULL , '5', 'test'), (NULL , '6', 'test'), (NULL , '1', 'test'),
(NULL , '1', 'test');
explain select count(a) from t1 group by a;
id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	p0,p1,p2,p3,p4,p5,p6,p7	index	NULL	PRIMARY	4	NULL	10	100.00	NULL
Warnings:
Note	1003	/* select#1 */ select count(`test`.`t1`.`a`) AS `count(a)` from `test`.`t1` group by `test`.`t1`.`a`
explain select count(a) from t1 FORCE INDEX FOR GROUP BY (PRIMARY) group by a;
id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	p0,p1,p2,p3,p4,p5,p6,p7	index	NULL	PRIMARY	4	NULL	10	100.00	NULL
Warnings:
Note	1003	/* select#1 */ select count(`test`.`t1`.`a`) AS `count(a)` from `test`.`t1` FORCE INDEX FOR GROUP BY (PRIMARY) group by `test`.`t1`.`a`
explain select count(b) from t1 group by b;
id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	p0,p1,p2,p3,p4,p5,p6,p7	index	NULL	b	4	NULL	10	100.00	NULL
Warnings:
Note	1003	/* select#1 */ select count(`test`.`t1`.`b`) AS `count(b)` from `test`.`t1` group by `test`.`t1`.`b`
explain select count(b) from t1 FORCE INDEX FOR GROUP BY (b) group by b;
id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	p0,p1,p2,p3,p4,p5,p6,p7	index	NULL	b	4	NULL	10	100.00	NULL
Warnings:
Note	1003	/* select#1 */ select count(`test`.`t1`.`b`) AS `count(b)` from `test`.`t1` FORCE INDEX FOR GROUP BY (`b`) group by `test`.`t1`.`b`
explain select distinct a from t1;
id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	p0,p1,p2,p3,p4,p5,p6,p7	ALL	NULL	NULL	NULL	NULL	10	100.00	NULL
Warnings:
Note	1003	/* select#1 */ select distinct `test`.`t1`.`a` AS `a` from `test`.`t1`
explain select distinct a from t1 group by a;
id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	p0,p1,p2,p3,p4,p5,p6,p7	index	NULL	PRIMARY	4	NULL	10	100.00	NULL
Warnings:
Note	1003	/* select#1 */ select `test`.`t1`.`a` AS `a` from `test`.`t1` group by `test`.`t1`.`a`
explain select distinct b from t1;
id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	p0,p1,p2,p3,p4,p5,p6,p7	index	NULL	b	4	NULL	10	100.00	NULL
Warnings:
Note	1003	/* select#1 */ select distinct `test`.`t1`.`b` AS `b` from `test`.`t1`
explain select distinct b from t1 group by b;
id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	p0,p1,p2,p3,p4,p5,p6,p7	index	NULL	b	4	NULL	10	100.00	NULL
Warnings:
Note	1003	/* select#1 */ select `test`.`t1`.`b` AS `b` from `test`.`t1` group by `test`.`t1`.`b`
select count(a) from t1 group by a;
count(a)
1
1
1
1
1
1
1
1
1
1
select count(a) from t1 FORCE INDEX FOR GROUP BY (PRIMARY) group by a;
count(a)
1
1
1
1
1
1
1
1
1
1
select count(b) from t1 group by b;
count(b)
1
1
1
1
2
4
select count(b) from t1 FORCE INDEX FOR GROUP BY (b) group by b;
count(b)
1
1
1
1
2
4
select distinct a from t1;
a
1
10
2
3
4
5
6
7
8
9
select distinct a from t1 group by a;
a
1
10
2
3
4
5
6
7
8
9
select distinct b from t1;
b
1
2
3
4
5
6
select distinct b from t1 group by b;
b
1
2
3
4
5
6
drop table t1;
create table t1(vc varchar(16), i int, vc2 varchar(1024)
, PRIMARY KEY(vc,vc2) USING HASH
, KEY i1(i)
, KEY i2(vc)
)  ENGINE=ndbcluster;
insert into t1 values
('1',1,'1'), ('2',2,'2'), ('3',3,'3'), ('4',1,'4'), ('5',2,'5'),
('6',3,'6'), ('7',1,'7'), ('8',2,'8'), ('9',3,'9'), ('10',1,'10'), 
('11',2,'11'), ('12',3,'12'), ('13',1,'13'), ('14',2,'14'), ('15',3,'15'),
('16',1,'16'), ('17',2,'17'), ('x',3,'x'), ('y',1,'y'), ('z',2,'z'),
('1000',3,'1000'), ('2000',3,'2000'), ('10000',3,'10000');
insert into t1 select concat(vc, '-0'), i, concat(vc2,'-0') from t1;
insert into t1 select concat(vc, '-1'), i, concat(vc2,'-1') from t1;
insert into t1 select concat('#-', vc), 0, concat('2-',vc2) from t1;
insert into t1 select concat('$-', vc), 0, concat('3-',vc2) from t1;
insert into t1 select concat('%-', vc), 0, concat('4-',vc2) from t1;
analyze table t1;
Table	Op	Msg_type	Msg_text
test.t1	analyze	status	OK
As testcase for bug#58280, query should 'index_merge i1,i2'
explain
select i,vc from t1
where i>=1 or vc > '0';
id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	p0,p1,p2,p3,p4,p5,p6,p7	index_merge	PRIMARY,i1,i2	i1,i2	5,18	NULL	#	#	Using sort_union(i1,i2); Using where with pushed condition ((`test`.`t1`.`i` >= 1) or (`test`.`t1`.`vc` > '0'))
Warnings:
Note	1003	/* select#1 */ select `test`.`t1`.`i` AS `i`,`test`.`t1`.`vc` AS `vc` from `test`.`t1` where ((`test`.`t1`.`i` >= 1) or (`test`.`t1`.`vc` > '0'))
select i,vc from t1
where i>=1 or vc > '0';
i	vc
1	1
1	1-0
1	1-0-1
1	1-1
1	10
1	10-0
1	10-0-1
1	10-1
1	13
1	13-0
1	13-0-1
1	13-1
1	16
1	16-0
1	16-0-1
1	16-1
1	4
1	4-0
1	4-0-1
1	4-1
1	7
1	7-0
1	7-0-1
1	7-1
1	y
1	y-0
1	y-0-1
1	y-1
2	11
2	11-0
2	11-0-1
2	11-1
2	14
2	14-0
2	14-0-1
2	14-1
2	17
2	17-0
2	17-0-1
2	17-1
2	2
2	2-0
2	2-0-1
2	2-1
2	5
2	5-0
2	5-0-1
2	5-1
2	8
2	8-0
2	8-0-1
2	8-1
2	z
2	z-0
2	z-0-1
2	z-1
3	1000
3	1000-0
3	1000-0-1
3	1000-1
3	10000
3	10000-0
3	10000-0-1
3	10000-1
3	12
3	12-0
3	12-0-1
3	12-1
3	15
3	15-0
3	15-0-1
3	15-1
3	2000
3	2000-0
3	2000-0-1
3	2000-1
3	3
3	3-0
3	3-0-1
3	3-1
3	6
3	6-0
3	6-0-1
3	6-1
3	9
3	9-0
3	9-0-1
3	9-1
3	x
3	x-0
3	x-0-1
3	x-1
create table t2(vc varchar(16), i int, vc2 varchar(1024)
, KEY i1(i)
, KEY i2(vc)
)  ENGINE=ndbcluster;
insert into t2 select * from t1;
analyze table t2;
Table	Op	Msg_type	Msg_text
test.t2	analyze	status	OK
As testcase for bug#58280, query should 'index_merge i1,i2'
explain
select i,vc from t2
where i>=1 or vc > '0';
id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t2	p0,p1,p2,p3,p4,p5,p6,p7	index_merge	i1,i2	i1,i2	5,19	NULL	#	#	Using sort_union(i1,i2); Using where with pushed condition ((`test`.`t2`.`i` >= 1) or (`test`.`t2`.`vc` > '0'))
Warnings:
Note	1003	/* select#1 */ select `test`.`t2`.`i` AS `i`,`test`.`t2`.`vc` AS `vc` from `test`.`t2` where ((`test`.`t2`.`i` >= 1) or (`test`.`t2`.`vc` > '0'))
select i,vc from t2
where i>=1 or vc > '0';
i	vc
1	1
1	1-0
1	1-0-1
1	1-1
1	10
1	10-0
1	10-0-1
1	10-1
1	13
1	13-0
1	13-0-1
1	13-1
1	16
1	16-0
1	16-0-1
1	16-1
1	4
1	4-0
1	4-0-1
1	4-1
1	7
1	7-0
1	7-0-1
1	7-1
1	y
1	y-0
1	y-0-1
1	y-1
2	11
2	11-0
2	11-0-1
2	11-1
2	14
2	14-0
2	14-0-1
2	14-1
2	17
2	17-0
2	17-0-1
2	17-1
2	2
2	2-0
2	2-0-1
2	2-1
2	5
2	5-0
2	5-0-1
2	5-1
2	8
2	8-0
2	8-0-1
2	8-1
2	z
2	z-0
2	z-0-1
2	z-1
3	1000
3	1000-0
3	1000-0-1
3	1000-1
3	10000
3	10000-0
3	10000-0-1
3	10000-1
3	12
3	12-0
3	12-0-1
3	12-1
3	15
3	15-0
3	15-0-1
3	15-1
3	2000
3	2000-0
3	2000-0-1
3	2000-1
3	3
3	3-0
3	3-0-1
3	3-1
3	6
3	6-0
3	6-0-1
3	6-1
3	9
3	9-0
3	9-0-1
3	9-1
3	x
3	x-0
3	x-0-1
3	x-1
drop table t1, t2;
CREATE TABLE inleveroverzicht (
id int(11) NOT NULL auto_increment,
klantid int(11) NOT NULL default '0',
productcode varchar(255) NOT NULL default '0',
aantal int(11) NOT NULL default '0',
PRIMARY KEY  (id),
KEY klantid (klantid),
KEY `klantid/productcode` (klantid,productcode)
) ENGINE=NDBCLUSTER DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ;
INSERT INTO inleveroverzicht (id, klantid, productcode, aantal) VALUES 
(33, 31, '15674', 11),
(32, 31, '0001256', 1);
SELECT * from inleveroverzicht ORDER BY id;
id	klantid	productcode	aantal
32	31	0001256	1
33	31	15674	11
TRUNCATE TABLE inleveroverzicht;
SELECT * from inleveroverzicht  ORDER BY id;
id	klantid	productcode	aantal
DROP TABLE inleveroverzicht;
CREATE TABLE indexmerge(
`id` bigint(20) unsigned NOT NULL,
`similar_id` bigint(20) unsigned NOT NULL,
`similarity` varchar(512) NOT NULL,
PRIMARY KEY (`id`,`similar_id`),
KEY `fk_similar_id` (`similar_id`),
KEY `ix_id_similarity` (`id`,`similarity`) USING BTREE
) ENGINE=ndb CHARACTER SET utf8;
insert into indexmerge values(1, 2, REPEAT("A",512));
insert into indexmerge values(2, 1, REPEAT("B",512));
insert into indexmerge values(3, 4, REPEAT("C",512));
insert into indexmerge values(4, 3, REPEAT("D",512));
insert into indexmerge values(5, 6, REPEAT("E",512));
insert into indexmerge values(6, 5, REPEAT("F",512));
insert into indexmerge values(7, 8, REPEAT("G",512));
insert into indexmerge values(8, 7, REPEAT("H",512));
insert into indexmerge values(9, 0, REPEAT("I",512));
insert into indexmerge values(0, 9, REPEAT("J",512));
delete quick from indexmerge where id = 2 or similar_id = 2;
drop table indexmerge;

${this.title}

Code Editor : ndb_index.result