Changeset: 2737d13aca59 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2737d13aca59
Modified Files:
sql/benchmarks/tpch/Tests/13-plan.stable.out
sql/server/rel_optimizer.c
sql/server/rel_schema.c
sql/server/rel_select.c
sql/server/rel_select.h
sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.stable.out
Branch: Jul2015
Log Message:
fixes for bug 3972,
no longer wrap outerjoins with projects.
don't add extra internal columns (recursively)
improve optimizer for this case
diffs (truncated from 387 to 300 lines):
diff --git a/sql/benchmarks/tpch/Tests/13-plan.stable.out
b/sql/benchmarks/tpch/Tests/13-plan.stable.out
--- a/sql/benchmarks/tpch/Tests/13-plan.stable.out
+++ b/sql/benchmarks/tpch/Tests/13-plan.stable.out
@@ -48,21 +48,19 @@ Ready.
% .plan # table_name
% rel # name
% clob # type
-% 227 # length
+% 225 # length
project (
| group by (
| | project (
| | | group by (
-| | | | project (
-| | | | | left outer join (
-| | | | | | table(sys.customer) [ customer.c_custkey NOT NULL HASHCOL ,
customer.%TID% NOT NULL ] COUNT ,
-| | | | | | table(sys.orders) [ orders.o_orderkey NOT NULL HASHCOL ,
orders.o_comment NOT NULL, orders.%orders_o_custkey_fkey NOT NULL JOINIDX
sys.orders.orders_o_custkey_fkey ] COUNT
-| | | | | ) [ orders.%orders_o_custkey_fkey NOT NULL = customer.%TID% NOT NULL
JOINIDX sys.orders.orders_o_custkey_fkey, (char[orders.o_comment NOT NULL] as
orders.o_comment) ! FILTER like (char "%special%requests%", char "") ]
-| | | | ) [ customer.c_custkey NOT NULL HASHCOL , orders.o_orderkey HASHCOL ]
-| | | ) [ customer.c_custkey NOT NULL HASHCOL ] [ customer.c_custkey NOT NULL
HASHCOL , sys.count no nil (orders.o_orderkey HASHCOL ) as L1.L1 ]
-| | ) [ L1 as c_orders.c_count ]
-| ) [ c_orders.c_count ] [ c_orders.c_count, sys.count() NOT NULL as L2.L2 ]
-) [ c_orders.c_count, L2 NOT NULL as L2.custdist ] [ L2.custdist NOT NULL,
c_orders.c_count ]
+| | | | left outer join (
+| | | | | table(sys.customer) [ customer.c_custkey NOT NULL HASHCOL ,
customer.%TID% NOT NULL ] COUNT ,
+| | | | | table(sys.orders) [ orders.o_orderkey NOT NULL HASHCOL ,
orders.o_comment NOT NULL, orders.%orders_o_custkey_fkey NOT NULL JOINIDX
sys.orders.orders_o_custkey_fkey ] COUNT
+| | | | ) [ orders.%orders_o_custkey_fkey NOT NULL = customer.%TID% NOT NULL
JOINIDX sys.orders.orders_o_custkey_fkey, (char[orders.o_comment NOT NULL] as
orders.o_comment) ! FILTER like (char "%special%requests%", char "") ]
+| | | ) [ customer.c_custkey NOT NULL HASHCOL ] [ customer.c_custkey NOT NULL
HASHCOL , sys.count no nil (orders.o_orderkey NOT NULL HASHCOL ) NOT NULL as
L1.L1 ]
+| | ) [ L1 NOT NULL as c_orders.c_count ]
+| ) [ c_orders.c_count NOT NULL ] [ c_orders.c_count NOT NULL, sys.count() NOT
NULL as L2.L2 ]
+) [ c_orders.c_count NOT NULL, L2 NOT NULL as L2.custdist ] [ L2.custdist NOT
NULL, c_orders.c_count NOT NULL ]
# 22:46:32 >
# 22:46:32 > "Done."
diff --git a/sql/server/rel_optimizer.c b/sql/server/rel_optimizer.c
--- a/sql/server/rel_optimizer.c
+++ b/sql/server/rel_optimizer.c
@@ -4900,9 +4900,7 @@ rel_push_project_up(int *changes, mvc *s
if (is_column(e->type) && exp_is_atom(e)) {
list_append(exps, e);
- } else if (e->type == e_column /*||
- e->type == e_func ||
- e->type == e_convert*/) {
+ } else if (e->type == e_column) {
if (e->name && e->name[0] == 'L')
return rel;
list_append(exps, e);
diff --git a/sql/server/rel_schema.c b/sql/server/rel_schema.c
--- a/sql/server/rel_schema.c
+++ b/sql/server/rel_schema.c
@@ -349,6 +349,10 @@ column_constraint_type(mvc *sql, char *n
(void) sql_error(sql, 02, "42000!CONSTRAINT FOREIGN
KEY: could not find referenced PRIMARY KEY in table %s.%s\n", rsname, rtname);
return res;
}
+ if (list_length(rk->columns) != 1) {
+ (void) sql_error(sql, 02, "42000!CONSTRAINT FOREIGN
KEY: not all columns are handled\n");
+ return res;
+ }
fk = mvc_create_fkey(sql, t, name, fkey, rk, ref_actions & 255,
(ref_actions>>8) & 255);
mvc_create_fkc(sql, fk, cs);
res = SQL_OK;
@@ -944,6 +948,25 @@ rel_create_table(mvc *sql, sql_schema *s
/*return NULL;*/ /* never reached as all branches of the above if() end
with return ... */
}
+static void
+rel_add_intern(mvc *sql, sql_rel *rel)
+{
+ if (rel->op == op_project && rel->l && rel->exps &&
!need_distinct(rel)) {
+ list *prjs = rel_projections(sql, rel->l, NULL, 1, 1);
+ node *n;
+
+ for(n=prjs->h; n; n = n->next) {
+ sql_exp *e = n->data;
+
+ if (is_intern(e)) {
+ append(rel->exps, e);
+ n->data = NULL;
+ }
+ }
+ }
+}
+
+
static sql_rel *
rel_create_view(mvc *sql, sql_schema *ss, dlist *qname, dlist *column_spec,
symbol *query, int check, int persistent)
{
diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c
--- a/sql/server/rel_select.c
+++ b/sql/server/rel_select.c
@@ -338,6 +338,18 @@ rel_bind_path(sql_allocator *sa, sql_rel
return path;
}
+static void
+exps_has_nil(list *exps)
+{
+ node *m;
+
+ for (m = exps->h; m; m = m->next) {
+ sql_exp *e = m->data;
+
+ set_has_nil(e);
+ }
+}
+
list *
rel_projections(mvc *sql, sql_rel *rel, char *tname, int settname, int intern )
{
@@ -354,8 +366,12 @@ rel_projections(mvc *sql, sql_rel *rel,
case op_full:
case op_apply:
exps = rel_projections(sql, rel->l, tname, settname, intern );
+ if (rel->op == op_full || rel->op == op_right)
+ exps_has_nil(exps);
if (rel->op != op_apply || (rel->flag == APPLY_LOJ ||
rel->flag == APPLY_JOIN)) {
rexps = rel_projections(sql, rel->r, tname, settname,
intern );
+ if (rel->op == op_full || rel->op == op_left)
+ exps_has_nil(rexps);
exps = list_merge( exps, rexps, (fdup)NULL);
}
return exps;
@@ -979,23 +995,6 @@ rel_sample(sql_allocator *sa, sql_rel *l
return rel;
}
-static char *
-rel_get_name( sql_rel *rel )
-{
- switch(rel->op) {
- case op_table:
- if (rel->r)
- return exp_name(rel->r);
- return NULL;
- case op_basetable:
- return NULL;
- default:
- if (rel->l)
- return rel_get_name(rel->l);
- }
- return NULL;
-}
-
/* ls is the left expression of the select, rs is a simple atom, e is the
select expression.
*/
@@ -1025,8 +1024,7 @@ rel_push_select(mvc *sql, sql_rel *rel,
lrel->op != op_left)
break;
/* pushing through left head of a left join is allowed */
- if (lrel->op == op_left && (
- !n->next || lrel->l != n->next->data))
+ if (lrel->op == op_left && (!n->next || lrel->l !=
n->next->data))
break;
p = lrel;
}
@@ -1040,11 +1038,8 @@ rel_push_select(mvc *sql, sql_rel *rel,
if (p && p != lrel) {
assert(p->op == op_join || p->op == op_left ||
is_semi(p->op));
if (p->l == lrel) {
- assert(p->l != n);
p->l = n;
} else {
- assert(p->op == op_join && p->r == lrel);
- assert(p->r != n);
p->r = n;
}
} else {
@@ -1160,24 +1155,6 @@ static sql_rel * rel_joinquery(mvc *sql,
static sql_rel * rel_crossquery(mvc *sql, sql_rel *rel, symbol *q);
static sql_rel * rel_unionjoinquery(mvc *sql, sql_rel *rel, symbol *sq);
-void
-rel_add_intern(mvc *sql, sql_rel *rel)
-{
- if (rel->op == op_project && rel->l && rel->exps &&
!need_distinct(rel)) {
- list *prjs = rel_projections(sql, rel->l, NULL, 1, 1);
- node *n;
-
- for(n=prjs->h; n; n = n->next) {
- sql_exp *e = n->data;
-
- if (is_intern(e)) {
- append(rel->exps, e);
- n->data = NULL;
- }
- }
- }
-}
-
static sql_rel *
rel_table_optname(mvc *sql, sql_rel *sq, symbol *optname)
{
@@ -1216,7 +1193,6 @@ rel_table_optname(mvc *sql, sql_rel *sq,
}
}
}
- rel_add_intern(sql, sq);
return sq;
}
@@ -2431,7 +2407,7 @@ rel_filter(mvc *sql, sql_rel *rel, list
return sql_error(sql, 02, "SELECT: cannot use non GROUP
BY column in query results without an aggregate function");
}
if (exps_card(r) <= CARD_ATOM /*&& exp_is_atom(rs) */) {
- if (exps_card(l) == exps_card(r)) /* bin compare op */
+ if (exps_card(l) == exps_card(r) || rel->processed) /* bin
compare op */
return rel_select(sql->sa, rel, e);
if (/*is_semi(rel->op) ||*/ is_outerjoin(rel->op)) {
@@ -2512,7 +2488,7 @@ rel_compare_exp_(mvc *sql, sql_rel *rel,
}
if (rs->card <= CARD_ATOM && exp_is_atom(rs) &&
(!rs2 || (rs2->card <= CARD_ATOM && exp_is_atom(rs2)))) {
- if (ls->card == rs->card && !rs2) /* bin compare op */
+ if ((ls->card == rs->card && !rs2) || rel->processed) /* bin
compare op */
return rel_select(sql->sa, rel, e);
if (/*is_semi(rel->op) ||*/ is_outerjoin(rel->op)) {
@@ -5850,26 +5826,6 @@ rel_joinquery_(mvc *sql, sql_rel *rel, s
if (!rel)
return rel;
- if (l_nil || r_nil) { /* add projection for correct NOT NULL */
- list *outexps = new_exp_list(sql->sa), *exps;
- node *m;
-
- exps = rel_projections(sql, t1, rel_get_name(t1), 1, 1);
- for (m = exps->h; m; m = m->next) {
- sql_exp *ls = m->data;
- if (l_nil)
- set_has_nil(ls);
- append(outexps, ls);
- }
- exps = rel_projections(sql, t2, rel_get_name(t2), 1, 1);
- for (m = exps->h; m; m = m->next) {
- sql_exp *rs = m->data;
- if (r_nil)
- set_has_nil(rs);
- append(outexps, rs);
- }
- rel = rel_project(sql->sa, rel, outexps);
- }
} else if (js) { /* using */
char rname[16], *rnme;
dnode *n = js->data.lval->h;
diff --git a/sql/server/rel_select.h b/sql/server/rel_select.h
--- a/sql/server/rel_select.h
+++ b/sql/server/rel_select.h
@@ -30,8 +30,6 @@ extern list * rel_projections(mvc *sql,
extern sql_rel * rel_label( mvc *sql, sql_rel *r, int all);
extern sql_exp *rel_column_exp(mvc *sql, sql_rel **rel, symbol *column_e, int
f);
-extern void rel_add_intern(mvc *sql, sql_rel *rel);
-
extern void rel_select_add_exp(sql_allocator *sa, sql_rel *l, sql_exp *e);
extern sql_rel *rel_select(sql_allocator *sa, sql_rel *l, sql_exp *e);
extern sql_rel *rel_select_copy(sql_allocator *sa, sql_rel *l, list *exps);
diff --git
a/sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.stable.out
b/sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.stable.out
---
a/sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.stable.out
+++
b/sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.stable.out
@@ -77,10 +77,119 @@ Ready.
#CREATE TABLE Table10 (T10PKCOL bigint, T10COLa1 TEXT, T10COLa2 TEXT, T10COLa3
TEXT, T10COLa4 TEXT, T10COLa5 TEXT, T10COLa6 TEXT, T10COLa7 TEXT, T10COLa8
TEXT, T10COLa9 TEXT, T10COLa10 TEXT, T10COLa11 TEXT, T10COLa12 TEXT, T10COLa13
TEXT, T10COLa14 TEXT, T10COLa15 TEXT, T10COLa16 TEXT, T10COLa17 TEXT, T10COLa18
TEXT, T10COLa19 TEXT, T10COLa20 TEXT, T10COLa21 TEXT, T10COLa22 TEXT, T10COLa23
TEXT, T10COLa24 TEXT, T10COLa25 TEXT, T10COLa26 TEXT, T10COLa27 TEXT, T10COLa28
TEXT, T10COLa29 TEXT, T10COLa30 TEXT, T10COLa31 TEXT, T10COLa32 TEXT, T10COLa33
TEXT, T10COLa34 TEXT, T10COLa35 TEXT, T10COLa36 TEXT, T10COLa37 TEXT, T10COLa38
TEXT, T10COLa39 TEXT, T10COLa40 TEXT, T10COLa41 TEXT, T10COLa42 TEXT, T10COLa43
TEXT, T10COLa44 TEXT, T10COLa45 TEXT, T10COLa46 TEXT, T10COLa47 TEXT, T10COLa48
TEXT, T10COLa49 TEXT, T10COLa50 TEXT, T10COLa51 INT, T10COLa52 INT, T10COLa53
INT, T10COLa54 INT, T10COLa55 INT, T10COLa56 INT, T10COLa57 INT, T10COLa58 INT,
T10COLa59 INT, T10COLa60 INT, T10COLa61 INT, T
10COLa62 INT, T10COLa63 INT, T10COLa64 INT, T10COLa65 INT, T10COLa66 DOUBLE,
T10COLa67 DOUBLE, T10COLa68 DOUBLE, T10COLa69 DOUBLE, T10COLa70 DOUBLE,
T10COLa71 DOUBLE, T10COLa72 DOUBLE, T10COLa73 DOUBLE, T10COLa74 DOUBLE,
T10COLa75 DOUBLE, T10COLa76 DOUBLE, T10COLa77 DOUBLE, T10COLa78 DOUBLE,
T10COLa79 DOUBLE, T10COLa80 DOUBLE, T10COLa81 DATE, T10COLa82 DATE, T10COLa83
DATE, T10COLa84 DATE, T10COLa85 DATE, T10COLa86 DATE, T10COLa87 DATE, T10COLa88
DATE, T10COLa89 DATE, T10COLa90 DATE, T10COLa91 TIMESTAMP, T10COLa92 TIMESTAMP,
T10COLa93 TIMESTAMP, T10COLa94 TIMESTAMP, T10COLa95 TIMESTAMP, T10COLa96
TIMESTAMP, T10COLa97 TIMESTAMP, T10COLa98 TIMESTAMP, T10COLa99 TIMESTAMP,
T10COLa100 TIMESTAMP, T10COLa101 TINYINT, T10COLa102 TINYINT, T10COLa103
TINYINT, T10COLa104 TINYINT, T10COLa105 TINYINT, T10COLa106 TINYINT, T10COLa107
TINYINT, T10COLa108 TINYINT, T10COLa109 TINYINT, T10COLa110 TINYINT, T10COLa111
BIGINT, T10COLa112 BIGINT, T10COLa113 BIGINT, T10COLa114 BIGINT, T10COLa115
BIGINT, T1
0COLa116 BIGINT, T10COLa117 BIGINT, T10COLa118 BIGINT, T10COLa119 BIGINT,
T10COLa120 BIGINT, T10COLa121 TEXT, T10COLa122 TEXT, T10COLa123 TEXT,
T10COLa124 TEXT, T10COLa125 TEXT, T10COLa126 TEXT, T10COLa127 TEXT, T10COLa128
TEXT, T10COLa129 TEXT, T10COLa130 TEXT, T10COLa131 TINYINT, T10COLa132 TINYINT,
T10COLa133 TINYINT, T10COLa134 TINYINT, T10COLa135 TINYINT, T10COLa136 TINYINT,
T10COLa137 TINYINT, T10COLa138 TINYINT, T10COLa139 TINYINT, T10COLa140 TINYINT,
T10COLa141 INT, T10COLa142 INT, T10COLa143 INT, T10COLa144 INT, T10COLa145 INT,
T10COLa146 INT, T10COLa147 INT, T10COLa148 INT, T10COLa149 INT, T10COLa150 INT,
T10COLb1 TEXT, T10COLb2 TEXT, T10COLb3 TEXT, T10COLb4 TEXT, T10COLb5 TEXT,
T10COLb6 TEXT, T10COLb7 TEXT, T10COLb8 TEXT, T10COLb9 TEXT, T10COLb10 TEXT,
T10COLb11 TEXT, T10COLb12 TEXT, T10COLb13 TEXT, T10COLb14 TEXT, T10COLb15 TEXT,
T10COLb16 TEXT, T10COLb17 TEXT, T10COLb18 TEXT, T10COLb19 TEXT, T10COLb20 TEXT,
T10COLb21 TEXT, T10COLb22 TEXT, T10COLb23 TEXT, T10COLb24 TEXT,
T10COLb25 TEXT, T10COLb26 TEXT, T10COLb27 TEXT, T10COLb28 TEXT, T10COLb29
TEXT, T10COLb30 TEXT, T10COLb31 TEXT, T10COLb32 TEXT, T10COLb33 TEXT, T10COLb34
TEXT, T10COLb35 TEXT, T10COLb36 TEXT, T10COLb37 TEXT, T10COLb38 TEXT, T10COLb39
TEXT, T10COLb40 TEXT, T10COLb41 TEXT, T10COLb42 TEXT, T10COLb43 TEXT, T10COLb44
TEXT, T10COLb45 TEXT, T10COLb46 TEXT, T10COLb47 TEXT, T10COLb48 TEXT, T10COLb49
TEXT, T10COLb50 TEXT, T10COLb51 INT, T10COLb52 INT, T10COLb53 INT, T10COLb54
INT, T10COLb55 INT, T10COLb56 INT, T10COLb57 INT, T10COLb58 INT, T10COLb59 INT,
T10COLb60 INT, T10COLb61 INT, T10COLb62 INT, T10COLb63 INT, T10COLb64 INT,
T10COLb65 INT, T10COLb66 DOUBLE, T10COLb67 DOUBLE, T10COLb68 DOUBLE, T10COLb69
DOUBLE, T10COLb70 DOUBLE, T10COLb71 DOUBLE, T10COLb72 DOUBLE, T10COLb73 DOUBLE,
T10COLb74 DOUBLE, T10COLb75 DOUBLE, T10COLb76 DOUBLE, T10COLb77 DOUBLE,
T10COLb78 DOUBLE, T10COLb79 DOUBLE, T10COLb80 DOUBLE, T10COLb81 DATE, T10COLb82
DATE, T10COLb83 DATE, T10COLb84 DATE, T10COLb85 DATE, T10CO
Lb86 DATE, T10COLb87 DATE, T10COLb88 DATE, T10COLb89 DATE, T10COLb90 DATE,
T10COLb91 TIMESTAMP, T10COLb92 TIMESTAMP, T10COLb93 TIMESTAMP, T10COLb94
TIMESTAMP, T10COLb95 TIMESTAMP, T10COLb96 TIMESTAMP, T10COLb97 TIMESTAMP,
T10COLb98 TIMESTAMP, T10COLb99 TIMESTAMP, T10COLb100 TIMESTAMP, T10COLb101
TINYINT, T10COLb102 TINYINT, T10COLb103 TINYINT, T10COLb104 TINYINT, T10COLb105
TINYINT, T10COLb106 TINYINT, T10COLb107 TINYINT, T10COLb108 TINYINT, T10COLb109
TINYINT, T10COLb110 TINYINT, T10COLb111 BIGINT, T10COLb112 BIGINT, T10COLb113
BIGINT, T10COLb114 BIGINT, T10COLb115 BIGINT, T10COLb116 BIGINT, T10COLb117
BIGINT, T10COLb118 BIGINT, T10COLb119 BIGINT, T10COLb120 BIGINT, T10COLb121
TEXT, T10COLb122 TEXT, T10COLb123 TEXT, T10COLb124 TEXT, T10COLb125 TEXT,
T10COLb126 TEXT, T10COLb127 TEXT, T10COLb128 TEXT, T10COLb129 TEXT, T10COLb130
TEXT, T10COLb131 TINYINT, T10COLb132 TINYINT, T10COLb133 TINYINT, T10COLb134
TINYINT, T10COLb135 TINYINT, T10COLb136 TINYINT, T10COLb137 TINYINT, T10COLb138
TINYINT, T10COLb139 TINYINT, T10COLb140 TINYINT, T10COLb141 INT, T10COLb142
INT, T10COLb143 INT, T10COLb144 INT, T10COLb145 INT, T10COLb146 INT, T10COLb147
INT, T10COLb148 INT, T10COLb149 INT, T10COLb150 INT, T10COLc1 TEXT, T10COLc2
TEXT, T10COLc3 TEXT, T10COLc4 TEXT, T10COLc5 TEXT, T10COLc6 TEXT, T10COLc7
TEXT, T10COLc8 TEXT, T10COLc9 TEXT, T10COLc10 TEXT, T10COLc11 TEXT, T10COLc12
TEXT, T10COLc13 TEXT, T10COLc14 TEXT, T10COLc15 TEXT, T10COLc16 TEXT, T10COLc17
TEXT, T10COLc18 TEXT, T10COLc19 TEXT, T10COLc20 TEXT, T10COLc21 TEXT, T10COLc22
TEXT, T10COLc23 TEXT, T10COLc24 TEXT, T10COLc25 TEXT, T10COLc26 TEXT, T10COLc27
TEXT, T10COLc28 TEXT, T10COLc29 TEXT, T10COLc30 TEXT, T10COLc31 TEXT, T10COLc32
TEXT, T10COLc33 TEXT, T10COLc34 TEXT, T10COLc35 TEXT, T10COLc36 TEXT, T10COLc37
TEXT, T10COLc38 TEXT, T10COLc39 TEXT, T10COLc40 TEXT, T10COLc41 TEXT, T10COLc42
TEXT, T10COLc43 TEXT, T10COLc44 TEXT, T10COLc45 TEXT, T10COLc46 TEXT, T10COLc47
TEXT, T10COLc48 TEXT, T10COLc49 TEXT, T10COLc50 TEX
T, T10COLc51 INT, T10COLc52 INT, T10COLc53 INT, T10COLc54 INT, T10COLc55 INT,
T10COLc56 INT, T10COLc57 INT, T10COLc58 INT, T10COLc59 INT, T10COLc60 INT,
T10COLc61 INT, T10COLc62 INT, T10COLc63 INT, T10COLc64 INT, T10COLc65 INT,
T10COLc66 DOUBLE, T10COLc67 DOUBLE, T10COLc68 DOUBLE, T10COLc69 DOUBLE,
T10COLc70 DOUBLE, T10COLc71 DOUBLE, T10COLc72 DOUBLE, T10COLc73 DOUBLE,
T10COLc74 DOUBLE, T10COLc75 DOUBLE, T10COLc76 DOUBLE, T10COLc77 DOUBLE,
T10COLc78 DOUBLE, T10COLc79 DOUBLE, T10COLc80 DOUBLE, T10COLc81 DATE, T10COLc82
DATE, T10COLc83 DATE, T10COLc84 DATE, T10COLc85 DATE, T10COLc86 DATE, T10COLc87
DATE, T10COLc88 DATE, T10COLc89 DATE, T10COLc90 DATE, T10COLc91 TIMESTAMP,
T10COLc92 TIMESTAMP, T10COLc93 TIMESTAMP, T10COLc94 TIMESTAMP, T10COLc95
TIMESTAMP, T10COLc96 TIMESTAMP, T10COLc97 TIMESTAMP, T10COLc98 TIMESTAMP,
T10COLc99 TIMESTAMP, T10COLc100 TIMESTAMP, T10COLc101 TINYINT, T10COLc102
TINYINT, T10COLc103 TINYINT, T10COLc104 TINYINT, T10COLc105 TINYINT, T10COLc106
TINYINT, T10COLc1
07 TINYINT, T10COLc108 TINYINT, T10COLc109 TINYINT, T10COLc110 TINYINT,
T10COLc111 BIGINT, T10COLc112 BIGINT, T10COLc113 BIGINT, T10COLc114 BIGINT,
T10COLc115 BIGINT, T10COLc116 BIGINT, T10COLc117 BIGINT, T10COLc118 BIGINT,
T10COLc119 BIGINT, T10COLc120 BIGINT, T10COLc121 TEXT, T10COLc122 TEXT,
T10COLc123 TEXT, T10COLc124 TEXT, T10COLc125 TEXT, T10COLc126 TEXT, T10COLc127
TEXT, T10COLc128 TEXT, T10COLc129 TEXT, T10COLc130 TEXT, T10COLc131 TINYINT,
T10COLc132 TINYINT, T10COLc133 TINYINT, T10COLc134 TINYINT, T10COLc135 TINYINT,
T10COLc136 TINYINT, T10COLc137 TINYINT, T10COLc138 TINYINT, T10COLc139 TINYINT,
T10COLc140 TINYINT, T10COLc141 INT, T10COLc142 INT, T10COLc143 INT, T10COLc144
INT, T10COLc145 INT, T10COLc146 INT, T10COLc147 INT, T10COLc148 INT, T10COLc149
INT, T10COLc150 INT, T10COLd1 TEXT, T10COLd2 TEXT, T10COLd3 TEXT, T10COLd4
TEXT, T10COLd5 TEXT, T10COLd6 TEXT, T10COLd7 TEXT, T10COLd8 TEXT, T10COLd9
TEXT, T10COLd10 TEXT, T10COLd11 TEXT, T10COLd12 TEXT, T10COLd13 TEXT, T10COL
d14 TEXT, T10COLd15 TEXT, T10COLd16 TEXT, T10COLd17 TEXT, T10COLd18 TEXT,
T10COLd19 TEXT, T10COLd20 TEXT, T10COLd21 TEXT, T10COLd22 TEXT, T10COLd23 TEXT,
T10COLd24 TEXT, T10COLd25 TEXT, T10COLd26 TEXT, T10COLd27 TEXT, T10COLd28 TEXT,
T10COLd29 TEXT, T10COLd30 TEXT, T10COLd31 TEXT, T10COLd32 TEXT, T10COLd33 TEXT,
T10COLd34 TEXT, T10COLd35 TEXT, T10COLd36 TEXT, T10COLd37 TEXT, T10COLd38 TEXT,
T10COLd39 TEXT, T10COLd40 TEXT, T10COLd41 TEXT, T10COLd42 TEXT, T10COLd43 TEXT,
T10COLd44 TEXT, T10COLd45 TEXT, T10COLd46 TEXT, T10COLd47 TEXT, T10COLd48 TEXT,
T10COLd49 TEXT, T10COLd50 TEXT, T10COLd51 INT, T10COLd52 INT, T10COLd53 INT,
T10COLd54 INT, T10COLd55 INT, T10COLd56 INT, T10COLd57 INT, T10COLd58 INT,
T10COLd59 INT, T10COLd60 INT, T10COLd61 INT, T10COLd62 INT, T10COLd63 INT,
T10COLd64 INT, T10COLd65 INT, T10COLd66 DOUBLE, T10COLd67 DOUBLE, T10COLd68
DOUBLE, T10COLd69 DOUBLE, T10COLd70 DOUBLE, T10COLd71 DOUBLE, T10COLd72 DOUBLE,
T10COLd73 DOUBLE, T10COLd74 DOUBLE, T10COLd75 DOUBLE, T10COL
d76 DOUBLE, T10COLd77 DOUBLE, T10COLd78 DOUBLE, T10COLd79 DOUBLE, T10COLd80
DOUBLE, T10COLd81 DATE, T10COLd82 DATE, T10COLd83 DATE, T10COLd84 DATE,
T10COLd85 DATE, T10COLd86 DATE, T10COLd87 DATE, T10COLd88 DATE, T10COLd89 DATE,
T10COLd90 DATE, T10COLd91 TIMESTAMP, T10COLd92 TIMESTAMP, T10COLd93 TIMESTAMP,
T10COLd94 TIMESTAMP, T10COLd95 TIMESTAMP, T10COLd96 TIMESTAMP, T10COLd97
TIMESTAMP, T10COLd98 TIMESTAMP, T10COLd99 TIMESTAMP, T10COLd100 TIMESTAMP,
T10COLd101 TINYINT, T10COLd102 TINYINT, T10COLd103 TINYINT, T10COLd104 TINYINT,
T10COLd105 TINYINT, T10COLd106 TINYINT, T10COLd107 TINYINT, T10COLd108 TINYINT,
T10COLd109 TINYINT, T10COLd110 TINYINT, T10COLd111 BIGINT, T10COLd112 BIGINT,
T10COLd113 BIGINT, T10COLd114 BIGINT, T10COLd115 BIGINT, T10COLd116 BIGINT,
T10COLd117 BIGINT, T10COLd118 BIGINT, T10COLd119 BIGINT, T10COLd120 BIGINT,
T10COLd121 TEXT, T10COLd122 TEXT, T10COLd123 TEXT, T10COLd124 TEXT, T10COLd125
TEXT, T10COLd126 TEXT, T10COLd127 TEXT, T10COLd128 TEXT, T10COLd129 TEXT,
T10COLd130 TEXT, T10COLd131 TINYINT, T10COLd132 TINYINT, T10COLd133 TINYINT,
T10COLd134 TINYINT, T10COLd135 TINYINT, T10COLd136 TINYINT, T10COLd137 TINYINT,
T10COLd138 TINYINT, T10COLd139 TINYINT, T10COLd140 TINYINT, T10COLd141 INT,
T10COLd142 INT, T10COLd143 INT, T10COLd144 INT, T10COLd145 INT, T10COLd146 INT,
T10COLd147 INT, T10COLd148 INT, T10COLd149 INT, T10COLd150 INT, T10LASTCOL
TEXT, PRIMARY KEY(T10PKCOL));
#CREATE TABLE Table11 (T11PKCOL bigint, T11COLa1 TEXT, T11COLa2 TEXT, T11COLa3
TEXT, T11COLa4 TEXT, T11COLa5 TEXT, T11COLa6 TEXT, T11COLa7 TEXT, T11COLa8
TEXT, T11COLa9 TEXT, T11COLa10 TEXT, T11COLa11 TEXT, T11COLa12 TEXT, T11COLa13
TEXT, T11COLa14 TEXT, T11COLa15 TEXT, T11COLa16 TEXT, T11COLa17 TEXT, T11COLa18
TEXT, T11COLa19 TEXT, T11COLa20 TEXT, T11COLa21 TEXT, T11COLa22 TEXT, T11COLa23
TEXT, T11COLa24 TEXT, T11COLa25 TEXT, T11COLa26 TEXT, T11COLa27 TEXT, T11COLa28
TEXT, T11COLa29 TEXT, T11COLa30 TEXT, T11COLa31 TEXT, T11COLa32 TEXT, T11COLa33
TEXT, T11COLa34 TEXT, T11COLa35 TEXT, T11COLa36 TEXT, T11COLa37 TEXT, T11COLa38
TEXT, T11COLa39 TEXT, T11COLa40 TEXT, T11COLa41 TEXT, T11COLa42 TEXT, T11COLa43
TEXT, T11COLa44 TEXT, T11COLa45 TEXT, T11COLa46 TEXT, T11COLa47 TEXT, T11COLa48
TEXT, T11COLa49 TEXT, T11COLa50 TEXT, T11COLa51 INT, T11COLa52 INT, T11COLa53
INT, T11COLa54 INT, T11COLa55 INT, T11COLa56 INT, T11COLa57 INT, T11COLa58 INT,
T11COLa59 INT, T11COLa60 INT, T11COLa61 INT, T
11COLa62 INT, T11COLa63 INT, T11COLa64 INT, T11COLa65 INT, T11COLa66 DOUBLE,
T11COLa67 DOUBLE, T11COLa68 DOUBLE, T11COLa69 DOUBLE, T11COLa70 DOUBLE,
T11COLa71 DOUBLE, T11COLa72 DOUBLE, T11COLa73 DOUBLE, T11COLa74 DOUBLE,
T11COLa75 DOUBLE, T11COLa76 DOUBLE, T11COLa77 DOUBLE, T11COLa78 DOUBLE,
T11COLa79 DOUBLE, T11COLa80 DOUBLE, T11COLa81 DATE, T11COLa82 DATE, T11COLa83
DATE, T11COLa84 DATE, T11COLa85 DATE, T11COLa86 DATE, T11COLa87 DATE, T11COLa88
DATE, T11COLa89 DATE, T11COLa90 DATE, T11COLa91 TIMESTAMP, T11COLa92 TIMESTAMP,
T11COLa93 TIMESTAMP, T11COLa94 TIMESTAMP, T11COLa95 TIMESTAMP, T11COLa96
TIMESTAMP, T11COLa97 TIMESTAMP, T11COLa98 TIMESTAMP, T11COLa99 TIMESTAMP,
T11COLa100 TIMESTAMP, T11COLa101 TINYINT, T11COLa102 TINYINT, T11COLa103
TINYINT, T11COLa104 TINYINT, T11COLa105 TINYINT, T11COLa106 TINYINT, T11COLa107
TINYINT, T11COLa108 TINYINT, T11COLa109 TINYINT, T11COLa110 TINYINT, T11COLa111
BIGINT, T11COLa112 BIGINT, T11COLa113 BIGINT, T11COLa114 BIGINT, T11COLa115
BIGINT, T1
1COLa116 BIGINT, T11COLa117 BIGINT, T11COLa118 BIGINT, T11COLa119 BIGINT,
T11COLa120 BIGINT, T11COLa121 TEXT, T11COLa122 TEXT, T11COLa123 TEXT,
T11COLa124 TEXT, T11COLa125 TEXT, T11COLa126 TEXT, T11COLa127 TEXT, T11COLa128
TEXT, T11COLa129 TEXT, T11COLa130 TEXT, T11COLa131 TINYINT, T11COLa132 TINYINT,
T11COLa133 TINYINT, T11COLa134 TINYINT, T11COLa135 TINYINT, T11COLa136 TINYINT,
T11COLa137 TINYINT, T11COLa138 TINYINT, T11COLa139 TINYINT, T11COLa140 TINYINT,
T11COLa141 INT, T11COLa142 INT, T11COLa143 INT, T11COLa144 INT, T11COLa145 INT,
T11COLa146 INT, T11COLa147 INT, T11COLa148 INT, T11COLa149 INT, T11COLa150 INT,
T11COLb1 TEXT, T11COLb2 TEXT, T11COLb3 TEXT, T11COLb4 TEXT, T11COLb5 TEXT,
T11COLb6 TEXT, T11COLb7 TEXT, T11COLb8 TEXT, T11COLb9 TEXT, T11COLb10 TEXT,
T11COLb11 TEXT, T11COLb12 TEXT, T11COLb13 TEXT, T11COLb14 TEXT, T11COLb15 TEXT,
T11COLb16 TEXT, T11COLb17 TEXT, T11COLb18 TEXT, T11COLb19 TEXT, T11COLb20 TEXT,
T11COLb21 TEXT, T11COLb22 TEXT, T11COLb23 TEXT, T11COLb24 TEXT,
T11COLb25 TEXT, T11COLb26 TEXT, T11COLb27 TEXT, T11COLb28 TEXT, T11COLb29
TEXT, T11COLb30 TEXT, T11COLb31 TEXT, T11COLb32 TEXT, T11COLb33 TEXT, T11COLb34
TEXT, T11COLb35 TEXT, T11COLb36 TEXT, T11COLb37 TEXT, T11COLb38 TEXT, T11COLb39
TEXT, T11COLb40 TEXT, T11COLb41 TEXT, T11COLb42 TEXT, T11COLb43 TEXT, T11COLb44
TEXT, T11COLb45 TEXT, T11COLb46 TEXT, T11COLb47 TEXT, T11COLb48 TEXT, T11COLb49
TEXT, T11COLb50 TEXT, T11COLb51 INT, T11COLb52 INT, T11COLb53 INT, T11COLb54
INT, T11COLb55 INT, T11COLb56 INT, T11COLb57 INT, T11COLb58 INT, T11COLb59 INT,
T11COLb60 INT, T11COLb61 INT, T11COLb62 INT, T11COLb63 INT, T11COLb64 INT,
T11COLb65 INT, T11COLb66 DOUBLE, T11COLb67 DOUBLE, T11COLb68 DOUBLE, T11COLb69
DOUBLE, T11COLb70 DOUBLE, T11COLb71 DOUBLE, T11COLb72 DOUBLE, T11COLb73 DOUBLE,
T11COLb74 DOUBLE, T11COLb75 DOUBLE, T11COLb76 DOUBLE, T11COLb77 DOUBLE,
T11COLb78 DOUBLE, T11COLb79 DOUBLE, T11COLb80 DOUBLE, T11COLb81 DATE, T11COLb82
DATE, T11COLb83 DATE, T11COLb84 DATE, T11COLb85 DATE, T11CO
Lb86 DATE, T11COLb87 DATE, T11COLb88 DATE, T11COLb89 DATE, T11COLb90 DATE,
T11COLb91 TIMESTAMP, T11COLb92 TIMESTAMP, T11COLb93 TIMESTAMP, T11COLb94
TIMESTAMP, T11COLb95 TIMESTAMP, T11COLb96 TIMESTAMP, T11COLb97 TIMESTAMP,
T11COLb98 TIMESTAMP, T11COLb99 TIMESTAMP, T11COLb100 TIMESTAMP, T11COLb101
TINYINT, T11COLb102 TINYINT, T11COLb103 TINYINT, T11COLb104 TINYINT, T11COLb105
TINYINT, T11COLb106 TINYINT, T11COLb107 TINYINT, T11COLb108 TINYINT, T11COLb109
TINYINT, T11COLb110 TINYINT, T11COLb111 BIGINT, T11COLb112 BIGINT, T11COLb113
BIGINT, T11COLb114 BIGINT, T11COLb115 BIGINT, T11COLb116 BIGINT, T11COLb117
BIGINT, T11COLb118 BIGINT, T11COLb119 BIGINT, T11COLb120 BIGINT, T11COLb121
TEXT, T11COLb122 TEXT, T11COLb123 TEXT, T11COLb124 TEXT, T11COLb125 TEXT,
T11COLb126 TEXT, T11COLb127 TEXT, T11COLb128 TEXT, T11COLb129 TEXT, T11COLb130
TEXT, T11COLb131 TINYINT, T11COLb132 TINYINT, T11COLb133 TINYINT, T11COLb134
TINYINT, T11COLb135 TINYINT, T11COLb136 TINYINT, T11COLb137 TINYINT, T11COLb138
TINYINT, T11COLb139 TINYINT, T11COLb140 TINYINT, T11COLb141 INT, T11COLb142
INT, T11COLb143 INT, T11COLb144 INT, T11COLb145 INT, T11COLb146 INT, T11COLb147
INT, T11COLb148 INT, T11COLb149 INT, T11COLb150 INT, T11COLc1 TEXT, T11COLc2
TEXT, T11COLc3 TEXT, T11COLc4 TEXT, T11COLc5 TEXT, T11COLc6 TEXT, T11COLc7
TEXT, T11COLc8 TEXT, T11COLc9 TEXT, T11COLc10 TEXT, T11COLc11 TEXT, T11COLc12
TEXT, T11COLc13 TEXT, T11COLc14 TEXT, T11COLc15 TEXT, T11COLc16 TEXT, T11COLc17
TEXT, T11COLc18 TEXT, T11COLc19 TEXT, T11COLc20 TEXT, T11COLc21 TEXT, T11COLc22
TEXT, T11COLc23 TEXT, T11COLc24 TEXT, T11COLc25 TEXT, T11COLc26 TEXT, T11COLc27
TEXT, T11COLc28 TEXT, T11COLc29 TEXT, T11COLc30 TEXT, T11COLc31 TEXT, T11COLc32
TEXT, T11COLc33 TEXT, T11COLc34 TEXT, T11COLc35 TEXT, T11COLc36 TEXT, T11COLc37
TEXT, T11COLc38 TEXT, T11COLc39 TEXT, T11COLc40 TEXT, T11COLc41 TEXT, T11COLc42
TEXT, T11COLc43 TEXT, T11COLc44 TEXT, T11COLc45 TEXT, T11COLc46 TEXT, T11COLc47
TEXT, T11COLc48 TEXT, T11COLc49 TEXT, T11COLc50 TEX
T, T11COLc51 INT, T11COLc52 INT, T11COLc53 INT, T11COLc54 INT, T11COLc55 INT,
T11COLc56 INT, T11COLc57 INT, T11COLc58 INT, T11COLc59 INT, T11COLc60 INT,
T11COLc61 INT, T11COLc62 INT, T11COLc63 INT, T11COLc64 INT, T11COLc65 INT,
T11COLc66 DOUBLE, T11COLc67 DOUBLE, T11COLc68 DOUBLE, T11COLc69 DOUBLE,
T11COLc70 DOUBLE, T11COLc71 DOUBLE, T11COLc72 DOUBLE, T11COLc73 DOUBLE,
T11COLc74 DOUBLE, T11COLc75 DOUBLE, T11COLc76 DOUBLE, T11COLc77 DOUBLE,
T11COLc78 DOUBLE, T11COLc79 DOUBLE, T11COLc80 DOUBLE, T11COLc81 DATE, T11COLc82
DATE, T11COLc83 DATE, T11COLc84 DATE, T11COLc85 DATE, T11COLc86 DATE, T11COLc87
DATE, T11COLc88 DATE, T11COLc89 DATE, T11COLc90 DATE, T11COLc91 TIMESTAMP,
T11COLc92 TIMESTAMP, T11COLc93 TIMESTAMP, T11COLc94 TIMESTAMP, T11COLc95
TIMESTAMP, T11COLc96 TIMESTAMP, T11COLc97 TIMESTAMP, T11COLc98 TIMESTAMP,
T11COLc99 TIMESTAMP, T11COLc100 TIMESTAMP, T11COLc101 TINYINT, T11COLc102
TINYINT, T11COLc103 TINYINT, T11COLc104 TINYINT, T11COLc105 TINYINT, T11COLc106
TINYINT, T11COLc1
07 TINYINT, T11COLc108 TINYINT, T11COLc109 TINYINT, T11COLc110 TINYINT,
T11COLc111 BIGINT, T11COLc112 BIGINT, T11COLc113 BIGINT, T11COLc114 BIGINT,
T11COLc115 BIGINT, T11COLc116 BIGINT, T11COLc117 BIGINT, T11COLc118 BIGINT,
T11COLc119 BIGINT, T11COLc120 BIGINT, T11COLc121 TEXT, T11COLc122 TEXT,
T11COLc123 TEXT, T11COLc124 TEXT, T11COLc125 TEXT, T11COLc126 TEXT, T11COLc127
TEXT, T11COLc128 TEXT, T11COLc129 TEXT, T11COLc130 TEXT, T11COLc131 TINYINT,
T11COLc132 TINYINT, T11COLc133 TINYINT, T11COLc134 TINYINT, T11COLc135 TINYINT,
T11COLc136 TINYINT, T11COLc137 TINYINT, T11COLc138 TINYINT, T11COLc139 TINYINT,
T11COLc140 TINYINT, T11COLc141 INT, T11COLc142 INT, T11COLc143 INT, T11COLc144
INT, T11COLc145 INT, T11COLc146 INT, T11COLc147 INT, T11COLc148 INT, T11COLc149
INT, T11COLc150 INT, T11COLd1 TEXT, T11COLd2 TEXT, T11COLd3 TEXT, T11COLd4
TEXT, T11COLd5 TEXT, T11COLd6 TEXT, T11COLd7 TEXT, T11COLd8 TEXT, T11COLd9
TEXT, T11COLd10 TEXT, T11COLd11 TEXT, T11COLd12 TEXT, T11COLd13 TEXT, T11COL
d14 TEXT, T11COLd15 TEXT, T11COLd16 TEXT, T11COLd17 TEXT, T11COLd18 TEXT,
T11COLd19 TEXT, T11COLd20 TEXT, T11COLd21 TEXT, T11COLd22 TEXT, T11COLd23 TEXT,
T11COLd24 TEXT, T11COLd25 TEXT, T11COLd26 TEXT, T11COLd27 TEXT, T11COLd28 TEXT,
T11COLd29 TEXT, T11COLd30 TEXT, T11COLd31 TEXT, T11COLd32 TEXT, T11COLd33 TEXT,
T11COLd34 TEXT, T11COLd35 TEXT, T11COLd36 TEXT, T11COLd37 TEXT, T11COLd38 TEXT,
T11COLd39 TEXT, T11COLd40 TEXT, T11COLd41 TEXT, T11COLd42 TEXT, T11COLd43 TEXT,
T11COLd44 TEXT, T11COLd45 TEXT, T11COLd46 TEXT, T11COLd47 TEXT, T11COLd48 TEXT,
T11COLd49 TEXT, T11COLd50 TEXT, T11COLd51 INT, T11COLd52 INT, T11COLd53 INT,
T11COLd54 INT, T11COLd55 INT, T11COLd56 INT, T11COLd57 INT, T11COLd58 INT,
T11COLd59 INT, T11COLd60 INT, T11COLd61 INT, T11COLd62 INT, T11COLd63 INT,
T11COLd64 INT, T11COLd65 INT, T11COLd66 DOUBLE, T11COLd67 DOUBLE, T11COLd68
DOUBLE, T11COLd69 DOUBLE, T11COLd70 DOUBLE, T11COLd71 DOUBLE, T11COLd72 DOUBLE,
T11COLd73 DOUBLE, T11COLd74 DOUBLE, T11COLd75 DOUBLE, T11COL
d76 DOUBLE, T11COLd77 DOUBLE, T11COLd78 DOUBLE, T11COLd79 DOUBLE, T11COLd80
DOUBLE, T11COLd81 DATE, T11COLd82 DATE, T11COLd83 DATE, T11COLd84 DATE,
T11COLd85 DATE, T11COLd86 DATE, T11COLd87 DATE, T11COLd88 DATE, T11COLd89 DATE,
T11COLd90 DATE, T11COLd91 TIMESTAMP, T11COLd92 TIMESTAMP, T11COLd93 TIMESTAMP,
T11COLd94 TIMESTAMP, T11COLd95 TIMESTAMP, T11COLd96 TIMESTAMP, T11COLd97
TIMESTAMP, T11COLd98 TIMESTAMP, T11COLd99 TIMESTAMP, T11COLd100 TIMESTAMP,
T11COLd101 TINYINT, T11COLd102 TINYINT, T11COLd103 TINYINT, T11COLd104 TINYINT,
T11COLd105 TINYINT, T11COLd106 TINYINT, T11COLd107 TINYINT, T11COLd108 TINYINT,
T11COLd109 TINYINT, T11COLd110 TINYINT, T11COLd111 BIGINT, T11COLd112 BIGINT,
T11COLd113 BIGINT, T11COLd114 BIGINT, T11COLd115 BIGINT, T11COLd116 BIGINT,
T11COLd117 BIGINT, T11COLd118 BIGINT, T11COLd119 BIGINT, T11COLd120 BIGINT,
T11COLd121 TEXT, T11COLd122 TEXT, T11COLd123 TEXT, T11COLd124 TEXT, T11COLd125
TEXT, T11COLd126 TEXT, T11COLd127 TEXT, T11COLd128 TEXT, T11COLd129 TEXT,
T11COLd130 TEXT, T11COLd131 TINYINT, T11COLd132 TINYINT, T11COLd133 TINYINT,
T11COLd134 TINYINT, T11COLd135 TINYINT, T11COLd136 TINYINT, T11COLd137 TINYINT,
T11COLd138 TINYINT, T11COLd139 TINYINT, T11COLd140 TINYINT, T11COLd141 INT,
T11COLd142 INT, T11COLd143 INT, T11COLd144 INT, T11COLd145 INT, T11COLd146 INT,
T11COLd147 INT, T11COLd148 INT, T11COLd149 INT, T11COLd150 INT, T11LASTCOL
TEXT, PRIMARY KEY(T11PKCOL));
#CREATE TABLE Table12 (T12PKCOL bigint, T12COLa1 TEXT, T12COLa2 TEXT, T12COLa3
TEXT, T12COLa4 TEXT, T12COLa5 TEXT, T12COLa6 TEXT, T12COLa7 TEXT, T12COLa8
TEXT, T12COLa9 TEXT, T12COLa10 TEXT, T12COLa11 TEXT, T12COLa12 TEXT, T12COLa13
TEXT, T12COLa14 TEXT, T12COLa15 TEXT, T12COLa16 TEXT, T12COLa17 TEXT, T12COLa18
TEXT, T12COLa19 TEXT, T12COLa20 TEXT, T12COLa21 TEXT, T12COLa22 TEXT, T12COLa23
TEXT, T12COLa24 TEXT, T12COLa25 TEXT, T12COLa26 TEXT, T12COLa27 TEXT, T12COLa28
TEXT, T12COLa29 TEXT, T12COLa30 TEXT, T12COLa31 TEXT, T12COLa32 TEXT, T12COLa33
TEXT, T12COLa34 TEXT, T12COLa35 TEXT, T12COLa36 TEXT, T12COLa37 TEXT, T12COLa38
TEXT, T12COLa39 TEXT, T12COLa40 TEXT, T12COLa41 TEXT, T12COLa42 TEXT, T12COLa43
TEXT, T12COLa44 TEXT, T12COLa45 TEXT, T12COLa46 TEXT, T12COLa47 TEXT, T12COLa48
TEXT, T12COLa49 TEXT, T12COLa50 TEXT, T12COLa51 INT, T12COLa52 INT, T12COLa53
INT, T12COLa54 INT, T12COLa55 INT, T12COLa56 INT, T12COLa57 INT, T12COLa58 INT,
T12COLa59 INT, T12COLa60 INT, T12COLa61 INT, T
12COLa62 INT, T12COLa63 INT, T12COLa64 INT, T12COLa65 INT, T12COLa66 DOUBLE,
T12COLa67 DOUBLE, T12COLa68 DOUBLE, T12COLa69 DOUBLE, T12COLa70 DOUBLE,
T12COLa71 DOUBLE, T12COLa72 DOUBLE, T12COLa73 DOUBLE, T12COLa74 DOUBLE,
T12COLa75 DOUBLE, T12COLa76 DOUBLE, T12COLa77 DOUBLE, T12COLa78 DOUBLE,
T12COLa79 DOUBLE, T12COLa80 DOUBLE, T12COLa81 DATE, T12COLa82 DATE, T12COLa83
DATE, T12COLa84 DATE, T12COLa85 DATE, T12COLa86 DATE, T12COLa87 DATE, T12COLa88
DATE, T12COLa89 DATE, T12COLa90 DATE, T12COLa91 TIMESTAMP, T12COLa92 TIMESTAMP,
T12COLa93 TIMESTAMP, T12COLa94 TIMESTAMP, T12COLa95 TIMESTAMP, T12COLa96
TIMESTAMP, T12COLa97 TIMESTAMP, T12COLa98 TIMESTAMP, T12COLa99 TIMESTAMP,
T12COLa100 TIMESTAMP, T12COLa101 TINYINT, T12COLa102 TINYINT, T12COLa103
TINYINT, T12COLa104 TINYINT, T12COLa105 TINYINT, T12COLa106 TINYINT, T12COLa107
TINYINT, T12COLa108 TINYINT, T12COLa109 TINYINT, T12COLa110 TINYINT, T12COLa111
BIGINT, T12COLa112 BIGINT, T12COLa113 BIGINT, T12COLa114 BIGINT, T12COLa115
BIGINT, T1
2COLa116 BIGINT, T12COLa117 BIGINT, T12COLa118 BIGINT, T12COLa119 BIGINT,
T12COLa120 BIGINT, T12COLa121 TEXT, T12COLa122 TEXT, T12COLa123 TEXT,
T12COLa124 TEXT, T12COLa125 TEXT, T12COLa126 TEXT, T12COLa127 TEXT, T12COLa128
TEXT, T12COLa129 TEXT, T12COLa130 TEXT, T12COLa131 TINYINT, T12COLa132 TINYINT,
T12COLa133 TINYINT, T12COLa134 TINYINT, T12COLa135 TINYINT, T12COLa136 TINYINT,
T12COLa137 TINYINT, T12COLa138 TINYINT, T12COLa139 TINYINT, T12COLa140 TINYINT,
T12COLa141 INT, T12COLa142 INT, T12COLa143 INT, T12COLa144 INT, T12COLa145 INT,
T12COLa146 INT, T12COLa147 INT, T12COLa148 INT, T12COLa149 INT, T12COLa150 INT,
T12COLb1 TEXT, T12COLb2 TEXT, T12COLb3 TEXT, T12COLb4 TEXT, T12COLb5 TEXT,
T12COLb6 TEXT, T12COLb7 TEXT, T12COLb8 TEXT, T12COLb9 TEXT, T12COLb10 TEXT,
T12COLb11 TEXT, T12COLb12 TEXT, T12COLb13 TEXT, T12COLb14 TEXT, T12COLb15 TEXT,
T12COLb16 TEXT, T12COLb17 TEXT, T12COLb18 TEXT, T12COLb19 TEXT, T12COLb20 TEXT,
T12COLb21 TEXT, T12COLb22 TEXT, T12COLb23 TEXT, T12COLb24 TEXT,
T12COLb25 TEXT, T12COLb26 TEXT, T12COLb27 TEXT, T12COLb28 TEXT, T12COLb29
TEXT, T12COLb30 TEXT, T12COLb31 TEXT, T12COLb32 TEXT, T12COLb33 TEXT, T12COLb34
TEXT, T12COLb35 TEXT, T12COLb36 TEXT, T12COLb37 TEXT, T12COLb38 TEXT, T12COLb39
TEXT, T12COLb40 TEXT, T12COLb41 TEXT, T12COLb42 TEXT, T12COLb43 TEXT, T12COLb44
TEXT, T12COLb45 TEXT, T12COLb46 TEXT, T12COLb47 TEXT, T12COLb48 TEXT, T12COLb49
TEXT, T12COLb50 TEXT, T12COLb51 INT, T12COLb52 INT, T12COLb53 INT, T12COLb54
INT, T12COLb55 INT, T12COLb56 INT, T12COLb57 INT, T12COLb58 INT, T12COLb59 INT,
T12COLb60 INT, T12COLb61 INT, T12COLb62 INT, T12COLb63 INT, T12COLb64 INT,
T12COLb65 INT, T12COLb66 DOUBLE, T12COLb67 DOUBLE, T12COLb68 DOUBLE, T12COLb69
DOUBLE, T12COLb70 DOUBLE, T12COLb71 DOUBLE, T12COLb72 DOUBLE, T12COLb73 DOUBLE,
T12COLb74 DOUBLE, T12COLb75 DOUBLE, T12COLb76 DOUBLE, T12COLb77 DOUBLE,
T12COLb78 DOUBLE, T12COLb79 DOUBLE, T12COLb80 DOUBLE, T12COLb81 DATE, T12COLb82
DATE, T12COLb83 DATE, T12COLb84 DATE, T12COLb85 DATE, T12CO
Lb86 DATE, T12COLb87 DATE, T12COLb88 DATE, T12COLb89 DATE, T12COLb90 DATE,
T12COLb91 TIMESTAMP, T12COLb92 TIMESTAMP, T12COLb93 TIMESTAMP, T12COLb94
TIMESTAMP, T12COLb95 TIMESTAMP, T12COLb96 TIMESTAMP, T12COLb97 TIMESTAMP,
T12COLb98 TIMESTAMP, T12COLb99 TIMESTAMP, T12COLb100 TIMESTAMP, T12COLb101
TINYINT, T12COLb102 TINYINT, T12COLb103 TINYINT, T12COLb104 TINYINT, T12COLb105
TINYINT, T12COLb106 TINYINT, T12COLb107 TINYINT, T12COLb108 TINYINT, T12COLb109
TINYINT, T12COLb110 TINYINT, T12COLb111 BIGINT, T12COLb112 BIGINT, T12COLb113
BIGINT, T12COLb114 BIGINT, T12COLb115 BIGINT, T12COLb116 BIGINT, T12COLb117
BIGINT, T12COLb118 BIGINT, T12COLb119 BIGINT, T12COLb120 BIGINT, T12COLb121
TEXT, T12COLb122 TEXT, T12COLb123 TEXT, T12COLb124 TEXT, T12COLb125 TEXT,
T12COLb126 TEXT, T12COLb127 TEXT, T12COLb128 TEXT, T12COLb129 TEXT, T12COLb130
TEXT, T12COLb131 TINYINT, T12COLb132 TINYINT, T12COLb133 TINYINT, T12COLb134
TINYINT, T12COLb135 TINYINT, T12COLb136 TINYINT, T12COLb137 TINYINT, T12COLb138
TINYINT, T12COLb139 TINYINT, T12COLb140 TINYINT, T12COLb141 INT, T12COLb142
INT, T12COLb143 INT, T12COLb144 INT, T12COLb145 INT, T12COLb146 INT, T12COLb147
INT, T12COLb148 INT, T12COLb149 INT, T12COLb150 INT, T12COLc1 TEXT, T12COLc2
TEXT, T12COLc3 TEXT, T12COLc4 TEXT, T12COLc5 TEXT, T12COLc6 TEXT, T12COLc7
TEXT, T12COLc8 TEXT, T12COLc9 TEXT, T12COLc10 TEXT, T12COLc11 TEXT, T12COLc12
TEXT, T12COLc13 TEXT, T12COLc14 TEXT, T12COLc15 TEXT, T12COLc16 TEXT, T12COLc17
TEXT, T12COLc18 TEXT, T12COLc19 TEXT, T12COLc20 TEXT, T12COLc21 TEXT, T12COLc22
TEXT, T12COLc23 TEXT, T12COLc24 TEXT, T12COLc25 TEXT, T12COLc26 TEXT, T12COLc27
TEXT, T12COLc28 TEXT, T12COLc29 TEXT, T12COLc30 TEXT, T12COLc31 TEXT, T12COLc32
TEXT, T12COLc33 TEXT, T12COLc34 TEXT, T12COLc35 TEXT, T12COLc36 TEXT, T12COLc37
TEXT, T12COLc38 TEXT, T12COLc39 TEXT, T12COLc40 TEXT, T12COLc41 TEXT, T12COLc42
TEXT, T12COLc43 TEXT, T12COLc44 TEXT, T12COLc45 TEXT, T12COLc46 TEXT, T12COLc47
TEXT, T12COLc48 TEXT, T12COLc49 TEXT, T12COLc50 TEX
T, T12COLc51 INT, T12COLc52 INT, T12COLc53 INT, T12COLc54 INT, T12COLc55 INT,
T12COLc56 INT, T12COLc57 INT, T12COLc58 INT, T12COLc59 INT, T12COLc60 INT,
T12COLc61 INT, T12COLc62 INT, T12COLc63 INT, T12COLc64 INT, T12COLc65 INT,
T12COLc66 DOUBLE, T12COLc67 DOUBLE, T12COLc68 DOUBLE, T12COLc69 DOUBLE,
T12COLc70 DOUBLE, T12COLc71 DOUBLE, T12COLc72 DOUBLE, T12COLc73 DOUBLE,
T12COLc74 DOUBLE, T12COLc75 DOUBLE, T12COLc76 DOUBLE, T12COLc77 DOUBLE,
T12COLc78 DOUBLE, T12COLc79 DOUBLE, T12COLc80 DOUBLE, T12COLc81 DATE, T12COLc82
DATE, T12COLc83 DATE, T12COLc84 DATE, T12COLc85 DATE, T12COLc86 DATE, T12COLc87
DATE, T12COLc88 DATE, T12COLc89 DATE, T12COLc90 DATE, T12COLc91 TIMESTAMP,
T12COLc92 TIMESTAMP, T12COLc93 TIMESTAMP, T12COLc94 TIMESTAMP, T12COLc95
TIMESTAMP, T12COLc96 TIMESTAMP, T12COLc97 TIMESTAMP, T12COLc98 TIMESTAMP,
T12COLc99 TIMESTAMP, T12COLc100 TIMESTAMP, T12COLc101 TINYINT, T12COLc102
TINYINT, T12COLc103 TINYINT, T12COLc104 TINYINT, T12COLc105 TINYINT, T12COLc106
TINYINT, T12COLc1
07 TINYINT, T12COLc108 TINYINT, T12COLc109 TINYINT, T12COLc110 TINYINT,
T12COLc111 BIGINT, T12COLc112 BIGINT, T12COLc113 BIGINT, T12COLc114 BIGINT,
T12COLc115 BIGINT, T12COLc116 BIGINT, T12COLc117 BIGINT, T12COLc118 BIGINT,
T12COLc119 BIGINT, T12COLc120 BIGINT, T12COLc121 TEXT, T12COLc122 TEXT,
T12COLc123 TEXT, T12COLc124 TEXT, T12COLc125 TEXT, T12COLc126 TEXT, T12COLc127
TEXT, T12COLc128 TEXT, T12COLc129 TEXT, T12COLc130 TEXT, T12COLc131 TINYINT,
T12COLc132 TINYINT, T12COLc133 TINYINT, T12COLc134 TINYINT, T12COLc135 TINYINT,
T12COLc136 TINYINT, T12COLc137 TINYINT, T12COLc138 TINYINT, T12COLc139 TINYINT,
T12COLc140 TINYINT, T12COLc141 INT, T12COLc142 INT, T12COLc143 INT, T12COLc144
INT, T12COLc145 INT, T12COLc146 INT, T12COLc147 INT, T12COLc148 INT, T12COLc149
INT, T12COLc150 INT, T12COLd1 TEXT, T12COLd2 TEXT, T12COLd3 TEXT, T12COLd4
TEXT, T12COLd5 TEXT, T12COLd6 TEXT, T12COLd7 TEXT, T12COLd8 TEXT, T12COLd9
TEXT, T12COLd10 TEXT, T12COLd11 TEXT, T12COLd12 TEXT, T12COLd13 TEXT, T12COL
d14 TEXT, T12COLd15 TEXT, T12COLd16 TEXT, T12COLd17 TEXT, T12COLd18 TEXT,
T12COLd19 TEXT, T12COLd20 TEXT, T12COLd21 TEXT, T12COLd22 TEXT, T12COLd23 TEXT,
T12COLd24 TEXT, T12COLd25 TEXT, T12COLd26 TEXT, T12COLd27 TEXT, T12COLd28 TEXT,
T12COLd29 TEXT, T12COLd30 TEXT, T12COLd31 TEXT, T12COLd32 TEXT, T12COLd33 TEXT,
T12COLd34 TEXT, T12COLd35 TEXT, T12COLd36 TEXT, T12COLd37 TEXT, T12COLd38 TEXT,
T12COLd39 TEXT, T12COLd40 TEXT, T12COLd41 TEXT, T12COLd42 TEXT, T12COLd43 TEXT,
T12COLd44 TEXT, T12COLd45 TEXT, T12COLd46 TEXT, T12COLd47 TEXT, T12COLd48 TEXT,
T12COLd49 TEXT, T12COLd50 TEXT, T12COLd51 INT, T12COLd52 INT, T12COLd53 INT,
T12COLd54 INT, T12COLd55 INT, T12COLd56 INT, T12COLd57 INT, T12COLd58 INT,
T12COLd59 INT, T12COLd60 INT, T12COLd61 INT, T12COLd62 INT, T12COLd63 INT,
T12COLd64 INT, T12COLd65 INT, T12COLd66 DOUBLE, T12COLd67 DOUBLE, T12COLd68
DOUBLE, T12COLd69 DOUBLE, T12COLd70 DOUBLE, T12COLd71 DOUBLE, T12COLd72 DOUBLE,
T12COLd73 DOUBLE, T12COLd74 DOUBLE, T12COLd75 DOUBLE, T12COL
d76 DOUBLE, T12COLd77 DOUBLE, T12COLd78 DOUBLE, T12COLd79 DOUBLE, T12COLd80
DOUBLE, T12COLd81 DATE, T12COLd82 DATE, T12COLd83 DATE, T12COLd84 DATE,
T12COLd85 DATE, T12COLd86 DATE, T12COLd87 DATE, T12COLd88 DATE, T12COLd89 DATE,
T12COLd90 DATE, T12COLd91 TIMESTAMP, T12COLd92 TIMESTAMP, T12COLd93 TIMESTAMP,
T12COLd94 TIMESTAMP, T12COLd95 TIMESTAMP, T12COLd96 TIMESTAMP, T12COLd97
TIMESTAMP, T12COLd98 TIMESTAMP, T12COLd99 TIMESTAMP, T12COLd100 TIMESTAMP,
T12COLd101 TINYINT, T12COLd102 TINYINT, T12COLd103 TINYINT, T12COLd104 TINYINT,
T12COLd105 TINYINT, T12COLd106 TINYINT, T12COLd107 TINYINT, T12COLd108 TINYINT,
T12COLd109 TINYINT, T12COLd110 TINYINT, T12COLd111 BIGINT, T12COLd112 BIGINT,
T12COLd113 BIGINT, T12COLd114 BIGINT, T12COLd115 BIGINT, T12COLd116 BIGINT,
T12COLd117 BIGINT, T12COLd118 BIGINT, T12COLd119 BIGINT, T12COLd120 BIGINT,
T12COLd121 TEXT, T12COLd122 TEXT, T12COLd123 TEXT, T12COLd124 TEXT, T12COLd125
TEXT, T12COLd126 TEXT, T12COLd127 TEXT, T12COLd128 TEXT, T12COLd129 TEXT,
T12COLd130 TEXT, T12COLd131 TINYINT, T12COLd132 TINYINT, T12COLd133 TINYINT,
T12COLd134 TINYINT, T12COLd135 TINYINT, T12COLd136 TINYINT, T12COLd137 TINYINT,
T12COLd138 TINYINT, T12COLd139 TINYINT, T12COLd140 TINYINT, T12COLd141 INT,
T12COLd142 INT, T12COLd143 INT, T12COLd144 INT, T12COLd145 INT, T12COLd146 INT,
T12COLd147 INT, T12COLd148 INT, T12COLd149 INT, T12COLd150 INT, T12LASTCOL
TEXT, PRIMARY KEY(T12PKCOL));
+#PLAN select
Table1.T1PKCOL,Table1.T1COLa82,Table2.T2COLa10,Table1.T1COLa1,Table1.T1COLa91,a1.T3COLa1
+#FROM Table1
+#LEFT JOIN Table4 ON Table1.T1COLa111 = Table4.T4COLa111
+#LEFT JOIN Table2 ON Table1.T1COLa112 = Table2.T2COLa112
+#LEFT JOIN Table5 ON Table5.T5COLa113=Table2.T2COLa113
+#LEFT JOIN Table6 Lookup1 ON Table1.T1COLa114 = Lookup1.T6PKCOL
+#LEFT JOIN Table2 Lookup2 ON Table1.T1COLb111 = Lookup2.T2COLb111
+#LEFT JOIN Table5 Lookup3 ON Table1.T1COLb112 = Lookup3.T5COLb112
+#LEFT JOIN Table7 Lookup4 ON Table1.T1COLb113 = Lookup4.T7COLb113
+% .plan # table_name
+% rel # name
+% clob # type
+% 283555 # length
+ REF 1 (2)
+left outer join (
+| left outer join (
+| | left outer join (
+| | | left outer join (
+| | | | left outer join (
+| | | | | left outer join (
+| | | | | | left outer join (
+| | | | | | | left outer join (
+| | | | | | | | left outer join (
+| | | | | | | | | left outer join (
+| | | | | | | | | | left outer join (
+| | | | | | | | | | | left outer join (
+| | | | | | | | | | | | left outer join (
+| | | | | | | | | | | | | left outer join (
+| | | | | | | | | | | | | | left outer join (
+| | | | | | | | | | | | | | | left outer join (
+| | | | | | | | | | | | | | | | left outer join (
+| | | | | | | | | | | | | | | | | left outer join (
+| | | | | | | | | | | | | | | | | | left outer join (
+| | | | | | | | | | | | | | | | | | | left outer join (
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
