Skip navigation links

Learn about new MySQL releases, technical articles, events and more.

Subscribe Now »
MySQL 5.1: st_join_table Struct Reference

st_join_table Struct Reference

#include <sql_select.h>

Collaboration diagram for st_join_table:

Collaboration graph
[legend]
List of all members.

Public Member Functions

 st_join_table ()
void cleanup ()
bool is_using_loose_index_scan ()

Public Attributes

TABLE * table
KEYUSE * keyuse
SQL_SELECT * select
COND * select_cond
QUICK_SELECT_I * quick
Item ** on_expr_ref
COND_EQUAL * cond_equal
st_join_table * first_inner
bool found
bool not_null_compl
st_join_table * last_inner
st_join_table * first_upper
st_join_table * first_unmatched
const char * info
Read_record_func read_first_record
Next_select_func next_select
READ_RECORD read_record
double worst_seeks
key_map const_keys
key_map checked_keys
key_map needed_reg
key_map keys
ha_rows records
ha_rows found_records
ha_rows read_time
table_map dependent
table_map key_dependent
uint use_quick
uint index
uint status
uint used_fields
uint used_fieldlength
uint used_blobs
enum join_type type
bool cached_eq_ref_table
bool eq_ref_table
bool not_used_in_distinct
bool sorted
TABLE_REF ref
JOIN_CACHE cache
JOIN * join
nested_join_map embedding_map

Detailed Description

Definition at line 107 of file sql_select.h.

Constructor & Destructor Documentation

st_join_table::st_join_table (  )  [inline]

Definition at line 108 of file sql_select.h.

00108 {}                          /* Remove gcc warning */

Member Function Documentation

void JOIN_TAB::cleanup (  ) 

Definition at line 5812 of file sql_select.cc.

References st_join_cache::buff, cache, end_read_record(), HA_EXTRA_NO_KEYREAD, quick, read_record, and x_free.

Referenced by JOIN::cleanup(), and JOIN::destroy().

05813 {
05814   delete select;
05815   select= 0;
05816   delete quick;
05817   quick= 0;
05818   x_free(cache.buff);
05819   cache.buff= 0;
05820   if (table)
05821   {
05822     if (table->key_read)
05823     {
05824       table->key_read= 0;
05825       table->file->extra(HA_EXTRA_NO_KEYREAD);
05826     }
05827     table->file->ha_index_or_rnd_end();
05828     /*
05829       We need to reset this for next select
05830       (Tested in part_of_refkey)
05831     */
05832     table->reginfo.join_tab= 0;
05833   }
05834   end_read_record(&read_record);
05835 }

Here is the call graph for this function:

Here is the caller graph for this function:

bool st_join_table::is_using_loose_index_scan (  )  [inline]

Definition at line 160 of file sql_select.h.

References QUICK_SELECT_I::get_type(), QUICK_SELECT_I::QS_TYPE_GROUP_MIN_MAX, SQL_SELECT::quick, and select.

Referenced by JOIN::exec().

00161   {
00162     return (select && select->quick &&
00163             (select->quick->get_type() ==
00164              QUICK_SELECT_I::QS_TYPE_GROUP_MIN_MAX));
00165   }

Here is the call graph for this function:

Here is the caller graph for this function:

Member Data Documentation

JOIN_CACHE st_join_table::cache

Definition at line 154 of file sql_select.h.

Referenced by cleanup(), flush_cached_records(), join_init_cache(), make_simple_join(), read_cached_record(), and sub_select_cache().

bool st_join_table::cached_eq_ref_table

Definition at line 151 of file sql_select.h.

Referenced by eq_ref_table().

key_map st_join_table::checked_keys

Definition at line 128 of file sql_select.h.

Referenced by make_join_statistics().

COND_EQUAL* st_join_table::cond_equal

Definition at line 115 of file sql_select.h.

Referenced by make_outerjoin_info().

key_map st_join_table::const_keys

Definition at line 127 of file sql_select.h.

Referenced by add_group_and_distinct_keys(), and make_join_statistics().

table_map st_join_table::dependent

Definition at line 146 of file sql_select.h.

Referenced by find_best(), join_tab_cmp(), join_tab_cmp_straight(), and make_join_statistics().

nested_join_map st_join_table::embedding_map

Definition at line 157 of file sql_select.h.

Referenced by check_interleaving_with_nj(), and make_join_statistics().

bool st_join_table::eq_ref_table

Definition at line 151 of file sql_select.h.

Referenced by eq_ref_table().

st_join_table* st_join_table::first_inner

Definition at line 116 of file sql_select.h.

Referenced by JOIN::exec(), make_join_readinfo(), make_join_select(), and make_outerjoin_info().

st_join_table* st_join_table::first_unmatched

Definition at line 121 of file sql_select.h.

Referenced by create_sort_index(), evaluate_join_record(), evaluate_null_complemented_join_record(), and make_simple_join().

st_join_table* st_join_table::first_upper

Definition at line 120 of file sql_select.h.

Referenced by add_found_match_trig_cond(), evaluate_join_record(), and make_outerjoin_info().

bool st_join_table::found

Definition at line 117 of file sql_select.h.

Referenced by add_found_match_trig_cond(), evaluate_join_record(), evaluate_null_complemented_join_record(), and sub_select().

ha_rows st_join_table::found_records

Definition at line 138 of file sql_select.h.

Referenced by best_access_path(), create_sort_index(), and join_tab_cmp().

uint st_join_table::index

Definition at line 147 of file sql_select.h.

Referenced by join_read_const_table(), join_read_first(), join_read_last(), make_join_readinfo(), select_describe(), and test_if_skip_sort_order().

const char* st_join_table::info

Definition at line 122 of file sql_select.h.

Referenced by join_read_const_table(), make_join_statistics(), make_simple_join(), select_describe(), and JOIN::test_in_subselect().

JOIN* st_join_table::join

Definition at line 155 of file sql_select.h.

Referenced by add_not_null_conds(), check_interleaving_with_nj(), cmp_buffer_with_ref(), create_sort_index(), join_ft_read_first(), join_init_read_record(), join_read_always_key(), join_read_const(), join_read_const_table(), join_read_last_key(), make_join_statistics(), make_simple_join(), restore_prev_nj_state(), test_if_quick_select(), test_if_skip_sort_order(), and update_ref_and_keys().

table_map st_join_table::key_dependent

Definition at line 146 of file sql_select.h.

Referenced by add_key_field(), find_best(), and make_join_statistics().

key_map st_join_table::keys

Definition at line 130 of file sql_select.h.

Referenced by add_key_field(), get_best_combination(), make_join_statistics(), make_simple_join(), select_describe(), and test_if_quick_select().

KEYUSE* st_join_table::keyuse

Definition at line 110 of file sql_select.h.

Referenced by best_access_path(), JOIN::exec(), and test_if_skip_sort_order().

st_join_table* st_join_table::last_inner

Definition at line 119 of file sql_select.h.

Referenced by create_sort_index(), evaluate_join_record(), evaluate_null_complemented_join_record(), make_outerjoin_info(), and make_simple_join().

key_map st_join_table::needed_reg

Definition at line 129 of file sql_select.h.

Referenced by make_join_statistics().

Next_select_func st_join_table::next_select

Definition at line 124 of file sql_select.h.

Referenced by do_select(), end_update(), evaluate_join_record(), evaluate_null_complemented_join_record(), flush_cached_records(), make_join_readinfo(), Sensitive_cursor::open(), and sub_select().

bool st_join_table::not_null_compl

Definition at line 118 of file sql_select.h.

Referenced by evaluate_null_complemented_join_record().

bool st_join_table::not_used_in_distinct

Definition at line 151 of file sql_select.h.

Referenced by evaluate_join_record(), make_simple_join(), and Sensitive_cursor::open().

Item** st_join_table::on_expr_ref

Definition at line 114 of file sql_select.h.

Referenced by get_best_combination(), join_read_const_table(), make_join_select(), make_join_statistics(), make_outerjoin_info(), make_simple_join(), and remove_const().

QUICK_SELECT_I* st_join_table::quick

Definition at line 113 of file sql_select.h.

Referenced by best_access_path(), cleanup(), create_sort_index(), make_join_readinfo(), make_simple_join(), and safe_update_on_fly().

Read_record_func st_join_table::read_first_record

Definition at line 123 of file sql_select.h.

Referenced by create_sort_index(), make_join_readinfo(), make_simple_join(), and test_if_skip_sort_order().

READ_RECORD st_join_table::read_record

Definition at line 125 of file sql_select.h.

Referenced by cleanup(), evaluate_join_record(), JOIN::exec(), flush_cached_records(), join_init_read_record(), join_read_first(), join_read_last(), make_join_readinfo(), make_simple_join(), and test_if_skip_sort_order().

ha_rows st_join_table::read_time

Definition at line 144 of file sql_select.h.

Referenced by best_access_path().

ha_rows st_join_table::records

Definition at line 133 of file sql_select.h.

Referenced by best_access_path(), and create_sort_index().

TABLE_REF st_join_table::ref

Definition at line 153 of file sql_select.h.

Referenced by add_not_null_conds(), add_ref_to_table_cond(), cmp_buffer_with_ref(), create_ref_for_key(), create_sort_index(), end_send(), eq_ref_table(), subselect_indexsubquery_engine::exec(), subselect_uniquesubquery_engine::exec(), get_best_combination(), join_ft_read_first(), join_read_always_key(), join_read_always_key_or_null(), join_read_const(), join_read_const_table(), join_read_key(), join_read_last_key(), join_read_next_same(), join_read_next_same_or_null(), join_read_prev_same(), make_join_readinfo(), make_simple_join(), part_of_refkey(), subselect_indexsubquery_engine::print(), subselect_uniquesubquery_engine::print(), safe_index_read(), safe_update_on_fly(), select_describe(), test_if_skip_sort_order(), and update_depend_map().

SQL_SELECT* st_join_table::select

Definition at line 111 of file sql_select.h.

Referenced by add_ref_to_table_cond(), create_sort_index(), end_send(), error_if_full_join(), JOIN::exec(), flush_cached_records(), is_using_loose_index_scan(), join_init_read_record(), make_join_readinfo(), make_simple_join(), select_describe(), test_if_quick_select(), and test_if_skip_sort_order().

COND* st_join_table::select_cond

Definition at line 112 of file sql_select.h.

Referenced by add_not_null_conds(), add_ref_to_table_cond(), create_sort_index(), end_send(), evaluate_join_record(), evaluate_null_complemented_join_record(), JOIN::exec(), and make_simple_join().

bool st_join_table::sorted

Definition at line 152 of file sql_select.h.

Referenced by JOIN::exec(), join_read_always_key(), join_read_first(), join_read_key(), join_read_last_key(), and make_join_readinfo().

uint st_join_table::status

Definition at line 148 of file sql_select.h.

TABLE* st_join_table::table

Definition at line 109 of file sql_select.h.

Referenced by add_not_null_conds(), add_ref_to_table_cond(), best_access_path(), calc_used_field_length(), check_interleaving_with_nj(), JOIN::cleanup(), cmp_buffer_with_ref(), create_ref_for_key(), create_sort_index(), end_send(), eq_ref_table(), evaluate_join_record(), evaluate_null_complemented_join_record(), JOIN::exec(), subselect_indexsubquery_engine::exec(), subselect_uniquesubquery_engine::exec(), find_best(), flush_cached_records(), get_best_combination(), greedy_search(), join_ft_read_first(), join_init_read_record(), join_read_always_key(), join_read_const(), join_read_const_table(), join_read_first(), join_read_key(), join_read_last(), join_read_last_key(), join_read_system(), join_tab_cmp(), join_tab_cmp_straight(), make_join_readinfo(), make_join_statistics(), make_outerjoin_info(), make_simple_join(), Sensitive_cursor::open(), optimize_straight_join(), subselect_indexsubquery_engine::print(), subselect_uniquesubquery_engine::print(), remove_const(), restore_prev_nj_state(), safe_index_read(), safe_update_on_fly(), select_describe(), sub_select(), test_if_skip_sort_order(), TEST_join(), update_const_equal_items(), and subselect_uniquesubquery_engine::~subselect_uniquesubquery_engine().

enum join_type st_join_table::type

Definition at line 150 of file sql_select.h.

Referenced by add_not_null_conds(), create_ref_for_key(), create_sort_index(), eq_ref_table(), error_if_full_join(), get_best_combination(), join_read_const_table(), make_join_readinfo(), make_simple_join(), safe_update_on_fly(), select_describe(), and test_if_skip_sort_order().

uint st_join_table::use_quick

Definition at line 147 of file sql_select.h.

Referenced by flush_cached_records(), make_join_readinfo(), select_describe(), and sub_select_cache().

uint st_join_table::used_blobs

Definition at line 149 of file sql_select.h.

Referenced by calc_used_field_length(), and join_init_cache().

uint st_join_table::used_fieldlength

Definition at line 149 of file sql_select.h.

Referenced by cache_record_length(), calc_used_field_length(), and join_init_cache().

uint st_join_table::used_fields

Definition at line 149 of file sql_select.h.

Referenced by calc_used_field_length(), and join_init_cache().

double st_join_table::worst_seeks

Definition at line 126 of file sql_select.h.

Referenced by best_access_path().

The documentation for this struct was generated from the following files:
Generated on Sat Sep 9 23:38:54 2006 for MySQL 5.1 by  doxygen 1.4.7