6
6
#ifndef DRIZZLED_TMP_TABLE_H
7
7
#define DRIZZLED_TMP_TABLE_H
10
Table reference in the FROM clause.
12
These table references can be of several types that correspond to
13
different SQL elements. Below we list all types of TableLists with
14
the necessary conditions to determine when a TableList instance
15
belongs to a certain type.
17
1) table (TableList::view == NULL)
19
(TableList::derived == NULL)
20
- subquery - TableList::table is a temp table
21
(TableList::derived != NULL)
22
- information schema table
23
(TableList::schema_table != NULL)
24
NOTICE: for schema tables TableList::field_translation may be != NULL
25
2) view (TableList::view != NULL)
26
- merge (TableList::effective_algorithm == VIEW_ALGORITHM_MERGE)
27
also (TableList::field_translation != NULL)
28
- tmptable (TableList::effective_algorithm == VIEW_ALGORITHM_TMPTABLE)
29
also (TableList::field_translation == NULL)
30
3) nested table reference (TableList::nested_join != NULL)
31
- table sequence - e.g. (t1, t2, t3)
32
TODO: how to distinguish from a JOIN?
34
TODO: how to distinguish from a table sequence?
36
(TableList::natural_join != NULL)
38
(TableList::join_using_fields != NULL)