Changeset: 77a801b1562b for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=77a801b1562b
Added Files:
        
sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.sql
        
sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.stable.err
        
sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.stable.out
        sql/test/pg_regress/Tests/oid.stable.err.int128
Removed Files:
        sql/test/pg_regress/Tests/oid.stable.err.64bit.int128
Modified Files:
        sql/backends/monet5/sql.c
        
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-1.sql.in
        
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-2.sql.in
        
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-3.sql.in
        
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-0.sql.in
        
sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-4.sql.in
        sql/test/BugTracker-2013/Tests/copy-into-compressed-bz2.Bug-3351.sql.in
        sql/test/BugTracker-2013/Tests/copy-into-compressed-gz.Bug-3351.sql.in
        sql/test/BugTracker-2013/Tests/copy-into-compressed.Bug-3351.sql.in
        sql/test/BugTracker-2013/Tests/segfault_in_aggregation.Bug-3225.sql.in
        sql/test/BugTracker-2015/Tests/copy_into.Bug-3813.sql.in
        sql/test/BugTracker-2016/Tests/All
        
sql/test/BugTracker-2016/Tests/min-max-uuid-column-wrong-results.Bug-3953.sql.in
        
sql/test/BugTracker-2016/Tests/wrong-nonil-property-with-copy-binary-into.Bug-3937.sql.in
        testing/Mtest.py.in
Branch: Jun2016
Log Message:

Merge with Jul2015 branch.


diffs (truncated from 430 to 300 lines):

diff --git a/sql/backends/monet5/sql.c b/sql/backends/monet5/sql.c
--- a/sql/backends/monet5/sql.c
+++ b/sql/backends/monet5/sql.c
@@ -3519,12 +3519,23 @@ mvc_bin_import_table_wrap(Client cntxt, 
 
        for (i = pci->retc + 2, n = t->columns.set->h; i < pci->argc && n; i++, 
n = n->next) {
                sql_column *col = n->data;
+               const char *fname = *getArgReference_str(stk, pci, i);
+               size_t flen = strlen(fname);
+               char *fn;
 
                if (ATOMvarsized(col->type.type->localtype) && 
col->type.type->localtype != TYPE_str)
                        throw(SQL, "sql", "Failed to attach file %s", 
*getArgReference_str(stk, pci, i));
-               f = fopen(*getArgReference_str(stk, pci, i), "r");
-               if (f == NULL)
-                       throw(SQL, "sql", "Failed to open file %s", 
*getArgReference_str(stk, pci, i));
+               fn = GDKmalloc(flen + 1);
+               GDKstrFromStr((unsigned char *) fn, (const unsigned char *) 
fname, flen);
+               if (fn == NULL)
+                       throw(SQL, "sql", MAL_MALLOC_FAIL);
+               f = fopen(fn, "r");
+               if (f == NULL) {
+                       msg = createException(SQL, "sql", "Failed to open file 
%s", fn);
+                       GDKfree(fn);
+                       return msg;
+               }
+               GDKfree(fn);
                fclose(f);
        }
 
diff --git 
a/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-1.sql.in
 
b/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-1.sql.in
--- 
a/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-1.sql.in
+++ 
b/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-1.sql.in
@@ -9,7 +9,7 @@ CREATE TABLE "t1" (
 );
 
 
-COPY 1025 RECORDS INTO t0  FROM 
'$TSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING  DELIMITERS  
'\t';
+COPY 1025 RECORDS INTO t0  FROM 
'$QTSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING  DELIMITERS  
'\t';
 select count(*) from t0;
 
 INSERT INTO t1 (d1) SELECT d0 FROM t0;
diff --git 
a/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-2.sql.in
 
b/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-2.sql.in
--- 
a/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-2.sql.in
+++ 
b/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-2.sql.in
@@ -9,7 +9,7 @@ CREATE TABLE "t1" (
 );
 
 
-COPY 1025 RECORDS INTO t0  FROM 
'$TSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING  DELIMITERS  
'\t';
+COPY 1025 RECORDS INTO t0  FROM 
'$QTSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING  DELIMITERS  
'\t';
 select count(*) from t0;
 
 INSERT INTO t1 (d1) SELECT d0 FROM t0;
diff --git 
a/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-3.sql.in
 
b/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-3.sql.in
--- 
a/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-3.sql.in
+++ 
b/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-3.sql.in
@@ -9,7 +9,7 @@ CREATE TABLE "t1" (
 );
 
 
-COPY 1025 RECORDS INTO t0  FROM 
'$TSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING  DELIMITERS  
'\t';
+COPY 1025 RECORDS INTO t0  FROM 
'$QTSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING  DELIMITERS  
'\t';
 select count(*) from t0;
 
 INSERT INTO t1 (d1) SELECT d0 FROM t0;
diff --git 
a/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-0.sql.in
 
b/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-0.sql.in
--- 
a/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-0.sql.in
+++ 
b/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-0.sql.in
@@ -9,7 +9,7 @@ CREATE TABLE "t1" (
 );
 
 
-COPY 1024 RECORDS INTO t0  FROM 
'$TSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING  DELIMITERS  
'\t';
+COPY 1024 RECORDS INTO t0  FROM 
'$QTSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING  DELIMITERS  
'\t';
 select count(*) from t0;
 
 INSERT INTO t1 (d1) SELECT d0 FROM t0;
diff --git 
a/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-4.sql.in
 
b/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-4.sql.in
--- 
a/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-4.sql.in
+++ 
b/sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-4.sql.in
@@ -9,7 +9,7 @@ CREATE TABLE "t1" (
 );
 
 
-COPY 1025 RECORDS INTO t0  FROM 
'$TSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING  DELIMITERS  
'\t';
+COPY 1025 RECORDS INTO t0  FROM 
'$QTSTSRCDIR/updating_non-loaded_columns.SF-2864313.data' USING  DELIMITERS  
'\t';
 select count(*) from t0;
 
 INSERT INTO t1 (d1) SELECT d0 FROM t0;
diff --git 
a/sql/test/BugTracker-2013/Tests/copy-into-compressed-bz2.Bug-3351.sql.in 
b/sql/test/BugTracker-2013/Tests/copy-into-compressed-bz2.Bug-3351.sql.in
--- a/sql/test/BugTracker-2013/Tests/copy-into-compressed-bz2.Bug-3351.sql.in
+++ b/sql/test/BugTracker-2013/Tests/copy-into-compressed-bz2.Bug-3351.sql.in
@@ -2,7 +2,7 @@ start transaction;
 
 create table test3351 (i integer);
 
-copy into test3351 from '$TSTSRCDIR/test3351.csv.bz2';
+copy into test3351 from '$QTSTSRCDIR/test3351.csv.bz2';
 select * from test3351;
 delete from test3351;
 
diff --git 
a/sql/test/BugTracker-2013/Tests/copy-into-compressed-gz.Bug-3351.sql.in 
b/sql/test/BugTracker-2013/Tests/copy-into-compressed-gz.Bug-3351.sql.in
--- a/sql/test/BugTracker-2013/Tests/copy-into-compressed-gz.Bug-3351.sql.in
+++ b/sql/test/BugTracker-2013/Tests/copy-into-compressed-gz.Bug-3351.sql.in
@@ -2,7 +2,7 @@ start transaction;
 
 create table test3351 (i integer);
 
-copy into test3351 from '$TSTSRCDIR/test3351.csv.gz';
+copy into test3351 from '$QTSTSRCDIR/test3351.csv.gz';
 select * from test3351;
 delete from test3351;
 
diff --git 
a/sql/test/BugTracker-2013/Tests/copy-into-compressed.Bug-3351.sql.in 
b/sql/test/BugTracker-2013/Tests/copy-into-compressed.Bug-3351.sql.in
--- a/sql/test/BugTracker-2013/Tests/copy-into-compressed.Bug-3351.sql.in
+++ b/sql/test/BugTracker-2013/Tests/copy-into-compressed.Bug-3351.sql.in
@@ -2,7 +2,7 @@ start transaction;
 
 create table test3351 (i integer);
 
-copy into test3351 from '$TSTSRCDIR/test3351.csv';
+copy into test3351 from '$QTSTSRCDIR/test3351.csv';
 select * from test3351;
 delete from test3351;
 
diff --git 
a/sql/test/BugTracker-2013/Tests/segfault_in_aggregation.Bug-3225.sql.in 
b/sql/test/BugTracker-2013/Tests/segfault_in_aggregation.Bug-3225.sql.in
--- a/sql/test/BugTracker-2013/Tests/segfault_in_aggregation.Bug-3225.sql.in
+++ b/sql/test/BugTracker-2013/Tests/segfault_in_aggregation.Bug-3225.sql.in
@@ -1,5 +1,5 @@
 create table t3225 ("eId" BIGINT, "timeInsert" TIMESTAMP, "uId" BIGINT);
-copy into t3225 from '$TSTSRCDIR/segfault_in_aggregation.Bug-3225.data' USING 
DELIMITERS '\t','\n';
+copy into t3225 from '$QTSTSRCDIR/segfault_in_aggregation.Bug-3225.data' USING 
DELIMITERS '\t','\n';
 select "eId", count(*) from t3225 where "uId" = 312459 group by "eId";
 select "eId", min("timeInsert"), max("timeInsert"), count(*) from t3225 where 
"uId" = 312459 and "eId" = 1000761 group by "eId";
 select "eId", min("timeInsert"), max("timeInsert"), count(*) from t3225 where 
"uId" = 312459 and "eId" = 1000763 group by "eId";
diff --git a/sql/test/BugTracker-2015/Tests/copy_into.Bug-3813.sql.in 
b/sql/test/BugTracker-2015/Tests/copy_into.Bug-3813.sql.in
--- a/sql/test/BugTracker-2015/Tests/copy_into.Bug-3813.sql.in
+++ b/sql/test/BugTracker-2015/Tests/copy_into.Bug-3813.sql.in
@@ -1,7 +1,7 @@
 START TRANSACTION;
 
 CREATE TABLE bug3813 ("playerID" STRING, "yearID" INTEGER, stint INTEGER, 
"teamID" STRING, "lgID" STRING, "G" INTEGER, "AB" INTEGER, "R" INTEGER, "H" 
INTEGER, "X2B" INTEGER, "X3B" INTEGER, "HR" INTEGER, "RBI" INTEGER, "SB" 
INTEGER, "CS" INTEGER, "BB" INTEGER, "SO" INTEGER, "IBB" INTEGER, "HBP" 
INTEGER, "SH" INTEGER, "SF" INTEGER, "GIDP" INTEGER);
-COPY INTO bug3813 FROM '$TSTSRCDIR/batting.csv.gz' USING DELIMITERS 
',','\n','"' NULL AS '';
+COPY INTO bug3813 FROM '$QTSTSRCDIR/batting.csv.gz' USING DELIMITERS 
',','\n','"' NULL AS '';
 SELECT COUNT(*) FROM bug3813;
 
 ROLLBACK;
diff --git a/sql/test/BugTracker-2016/Tests/All 
b/sql/test/BugTracker-2016/Tests/All
--- a/sql/test/BugTracker-2016/Tests/All
+++ b/sql/test/BugTracker-2016/Tests/All
@@ -24,3 +24,4 @@ decimal_vs_integer.Bug-3941
 foreign_key.Bug-3938
 rename_exps.Bug-3974
 join-with-references-2sides-crashes.Bug-3980
+memory-consumption-query-PLAN-25joins.Bug-3972
diff --git 
a/sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.sql
 
b/sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.sql
new file mode 100644
--- /dev/null
+++ 
b/sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.sql
@@ -0,0 +1,90 @@
+START TRANSACTION;
+CREATE TABLE Table1 (T1PKCOL bigint, T1COLa1 TEXT, T1COLa2 TEXT, T1COLa3 TEXT, 
T1COLa4 TEXT, T1COLa5 TEXT, T1COLa6 TEXT, T1COLa7 TEXT, T1COLa8 TEXT, T1COLa9 
TEXT, T1COLa10 TEXT, T1COLa11 TEXT, T1COLa12 TEXT, T1COLa13 TEXT, T1COLa14 
TEXT, T1COLa15 TEXT, T1COLa16 TEXT, T1COLa17 TEXT, T1COLa18 TEXT, T1COLa19 
TEXT, T1COLa20 TEXT, T1COLa21 TEXT, T1COLa22 TEXT, T1COLa23 TEXT, T1COLa24 
TEXT, T1COLa25 TEXT, T1COLa26 TEXT, T1COLa27 TEXT, T1COLa28 TEXT, T1COLa29 
TEXT, T1COLa30 TEXT, T1COLa31 TEXT, T1COLa32 TEXT, T1COLa33 TEXT, T1COLa34 
TEXT, T1COLa35 TEXT, T1COLa36 TEXT, T1COLa37 TEXT, T1COLa38 TEXT, T1COLa39 
TEXT, T1COLa40 TEXT, T1COLa41 TEXT, T1COLa42 TEXT, T1COLa43 TEXT, T1COLa44 
TEXT, T1COLa45 TEXT, T1COLa46 TEXT, T1COLa47 TEXT, T1COLa48 TEXT, T1COLa49 
TEXT, T1COLa50 TEXT, T1COLa51 INT, T1COLa52 INT, T1COLa53 INT, T1COLa54 INT, 
T1COLa55 INT, T1COLa56 INT, T1COLa57 INT, T1COLa58 INT, T1COLa59 INT, T1COLa60 
INT, T1COLa61 INT, T1COLa62 INT, T1COLa63 INT, T1COLa64 INT, T1COLa65 INT, 
T1COLa66 
 DOUBLE, T1COLa67 DOUBLE, T1COLa68 DOUBLE, T1COLa69 DOUBLE, T1COLa70 DOUBLE, 
T1COLa71 DOUBLE, T1COLa72 DOUBLE, T1COLa73 DOUBLE, T1COLa74 DOUBLE, T1COLa75 
DOUBLE, T1COLa76 DOUBLE, T1COLa77 DOUBLE, T1COLa78 DOUBLE, T1COLa79 DOUBLE, 
T1COLa80 DOUBLE, T1COLa81 DATE, T1COLa82 DATE, T1COLa83 DATE, T1COLa84 DATE, 
T1COLa85 DATE, T1COLa86 DATE, T1COLa87 DATE, T1COLa88 DATE, T1COLa89 DATE, 
T1COLa90 DATE, T1COLa91 TIMESTAMP, T1COLa92 TIMESTAMP, T1COLa93 TIMESTAMP, 
T1COLa94 TIMESTAMP, T1COLa95 TIMESTAMP, T1COLa96 TIMESTAMP, T1COLa97 TIMESTAMP, 
T1COLa98 TIMESTAMP, T1COLa99 TIMESTAMP, T1COLa100 TIMESTAMP, T1COLa101 TINYINT, 
T1COLa102 TINYINT, T1COLa103 TINYINT, T1COLa104 TINYINT, T1COLa105 TINYINT, 
T1COLa106 TINYINT, T1COLa107 TINYINT, T1COLa108 TINYINT, T1COLa109 TINYINT, 
T1COLa110 TINYINT, T1COLa111 BIGINT, T1COLa112 BIGINT, T1COLa113 BIGINT, 
T1COLa114 BIGINT, T1COLa115 BIGINT, T1COLa116 BIGINT, T1COLa117 BIGINT, 
T1COLa118 BIGINT, T1COLa119 BIGINT, T1COLa120 BIGINT, T1COLa121 TEXT, T1COLa122 
TEXT
 , T1COLa123 TEXT, T1COLa124 TEXT, T1COLa125 TEXT, T1COLa126 TEXT, T1COLa127 
TEXT, T1COLa128 TEXT, T1COLa129 TEXT, T1COLa130 TEXT, T1COLa131 TINYINT, 
T1COLa132 TINYINT, T1COLa133 TINYINT, T1COLa134 TINYINT, T1COLa135 TINYINT, 
T1COLa136 TINYINT, T1COLa137 TINYINT, T1COLa138 TINYINT, T1COLa139 TINYINT, 
T1COLa140 TINYINT, T1COLa141 INT, T1COLa142 INT, T1COLa143 INT, T1COLa144 INT, 
T1COLa145 INT, T1COLa146 INT, T1COLa147 INT, T1COLa148 INT, T1COLa149 INT, 
T1COLa150 INT, T1COLb1 TEXT, T1COLb2 TEXT, T1COLb3 TEXT, T1COLb4 TEXT, T1COLb5 
TEXT, T1COLb6 TEXT, T1COLb7 TEXT, T1COLb8 TEXT, T1COLb9 TEXT, T1COLb10 TEXT, 
T1COLb11 TEXT, T1COLb12 TEXT, T1COLb13 TEXT, T1COLb14 TEXT, T1COLb15 TEXT, 
T1COLb16 TEXT, T1COLb17 TEXT, T1COLb18 TEXT, T1COLb19 TEXT, T1COLb20 TEXT, 
T1COLb21 TEXT, T1COLb22 TEXT, T1COLb23 TEXT, T1COLb24 TEXT, T1COLb25 TEXT, 
T1COLb26 TEXT, T1COLb27 TEXT, T1COLb28 TEXT, T1COLb29 TEXT, T1COLb30 TEXT, 
T1COLb31 TEXT, T1COLb32 TEXT, T1COLb33 TEXT, T1COLb34 TEXT, T1COLb35 TEXT, 
T1COLb36 TE
 XT, T1COLb37 TEXT, T1COLb38 TEXT, T1COLb39 TEXT, T1COLb40 TEXT, T1COLb41 TEXT, 
T1COLb42 TEXT, T1COLb43 TEXT, T1COLb44 TEXT, T1COLb45 TEXT, T1COLb46 TEXT, 
T1COLb47 TEXT, T1COLb48 TEXT, T1COLb49 TEXT, T1COLb50 TEXT, T1COLb51 INT, 
T1COLb52 INT, T1COLb53 INT, T1COLb54 INT, T1COLb55 INT, T1COLb56 INT, T1COLb57 
INT, T1COLb58 INT, T1COLb59 INT, T1COLb60 INT, T1COLb61 INT, T1COLb62 INT, 
T1COLb63 INT, T1COLb64 INT, T1COLb65 INT, T1COLb66 DOUBLE, T1COLb67 DOUBLE, 
T1COLb68 DOUBLE, T1COLb69 DOUBLE, T1COLb70 DOUBLE, T1COLb71 DOUBLE, T1COLb72 
DOUBLE, T1COLb73 DOUBLE, T1COLb74 DOUBLE, T1COLb75 DOUBLE, T1COLb76 DOUBLE, 
T1COLb77 DOUBLE, T1COLb78 DOUBLE, T1COLb79 DOUBLE, T1COLb80 DOUBLE, T1COLb81 
DATE, T1COLb82 DATE, T1COLb83 DATE, T1COLb84 DATE, T1COLb85 DATE, T1COLb86 
DATE, T1COLb87 DATE, T1COLb88 DATE, T1COLb89 DATE, T1COLb90 DATE, T1COLb91 
TIMESTAMP, T1COLb92 TIMESTAMP, T1COLb93 TIMESTAMP, T1COLb94 TIMESTAMP, T1COLb95 
TIMESTAMP, T1COLb96 TIMESTAMP, T1COLb97 TIMESTAMP, T1COLb98 TIMESTAMP, T1COLb99
  TIMESTAMP, T1COLb100 TIMESTAMP, T1COLb101 TINYINT, T1COLb102 TINYINT, 
T1COLb103 TINYINT, T1COLb104 TINYINT, T1COLb105 TINYINT, T1COLb106 TINYINT, 
T1COLb107 TINYINT, T1COLb108 TINYINT, T1COLb109 TINYINT, T1COLb110 TINYINT, 
T1COLb111 BIGINT, T1COLb112 BIGINT, T1COLb113 BIGINT, T1COLb114 BIGINT, 
T1COLb115 BIGINT, T1COLb116 BIGINT, T1COLb117 BIGINT, T1COLb118 BIGINT, 
T1COLb119 BIGINT, T1COLb120 BIGINT, T1COLb121 TEXT, T1COLb122 TEXT, T1COLb123 
TEXT, T1COLb124 TEXT, T1COLb125 TEXT, T1COLb126 TEXT, T1COLb127 TEXT, T1COLb128 
TEXT, T1COLb129 TEXT, T1COLb130 TEXT, T1COLb131 TINYINT, T1COLb132 TINYINT, 
T1COLb133 TINYINT, T1COLb134 TINYINT, T1COLb135 TINYINT, T1COLb136 TINYINT, 
T1COLb137 TINYINT, T1COLb138 TINYINT, T1COLb139 TINYINT, T1COLb140 TINYINT, 
T1COLb141 INT, T1COLb142 INT, T1COLb143 INT, T1COLb144 INT, T1COLb145 INT, 
T1COLb146 INT, T1COLb147 INT, T1COLb148 INT, T1COLb149 INT, T1COLb150 INT, 
T1COLc1 TEXT, T1COLc2 TEXT, T1COLc3 TEXT, T1COLc4 TEXT, T1COLc5 TEXT, T1COLc6 
TEXT, T1COLc7 TE
 XT, T1COLc8 TEXT, T1COLc9 TEXT, T1COLc10 TEXT, T1COLc11 TEXT, T1COLc12 TEXT, 
T1COLc13 TEXT, T1COLc14 TEXT, T1COLc15 TEXT, T1COLc16 TEXT, T1COLc17 TEXT, 
T1COLc18 TEXT, T1COLc19 TEXT, T1COLc20 TEXT, T1COLc21 TEXT, T1COLc22 TEXT, 
T1COLc23 TEXT, T1COLc24 TEXT, T1COLc25 TEXT, T1COLc26 TEXT, T1COLc27 TEXT, 
T1COLc28 TEXT, T1COLc29 TEXT, T1COLc30 TEXT, T1COLc31 TEXT, T1COLc32 TEXT, 
T1COLc33 TEXT, T1COLc34 TEXT, T1COLc35 TEXT, T1COLc36 TEXT, T1COLc37 TEXT, 
T1COLc38 TEXT, T1COLc39 TEXT, T1COLc40 TEXT, T1COLc41 TEXT, T1COLc42 TEXT, 
T1COLc43 TEXT, T1COLc44 TEXT, T1COLc45 TEXT, T1COLc46 TEXT, T1COLc47 TEXT, 
T1COLc48 TEXT, T1COLc49 TEXT, T1COLc50 TEXT, T1COLc51 INT, T1COLc52 INT, 
T1COLc53 INT, T1COLc54 INT, T1COLc55 INT, T1COLc56 INT, T1COLc57 INT, T1COLc58 
INT, T1COLc59 INT, T1COLc60 INT, T1COLc61 INT, T1COLc62 INT, T1COLc63 INT, 
T1COLc64 INT, T1COLc65 INT, T1COLc66 DOUBLE, T1COLc67 DOUBLE, T1COLc68 DOUBLE, 
T1COLc69 DOUBLE, T1COLc70 DOUBLE, T1COLc71 DOUBLE, T1COLc72 DOUBLE, T1COLc73 
DOUBLE, T1CO
 Lc74 DOUBLE, T1COLc75 DOUBLE, T1COLc76 DOUBLE, T1COLc77 DOUBLE, T1COLc78 
DOUBLE, T1COLc79 DOUBLE, T1COLc80 DOUBLE, T1COLc81 DATE, T1COLc82 DATE, 
T1COLc83 DATE, T1COLc84 DATE, T1COLc85 DATE, T1COLc86 DATE, T1COLc87 DATE, 
T1COLc88 DATE, T1COLc89 DATE, T1COLc90 DATE, T1COLc91 TIMESTAMP, T1COLc92 
TIMESTAMP, T1COLc93 TIMESTAMP, T1COLc94 TIMESTAMP, T1COLc95 TIMESTAMP, T1COLc96 
TIMESTAMP, T1COLc97 TIMESTAMP, T1COLc98 TIMESTAMP, T1COLc99 TIMESTAMP, 
T1COLc100 TIMESTAMP, T1COLc101 TINYINT, T1COLc102 TINYINT, T1COLc103 TINYINT, 
T1COLc104 TINYINT, T1COLc105 TINYINT, T1COLc106 TINYINT, T1COLc107 TINYINT, 
T1COLc108 TINYINT, T1COLc109 TINYINT, T1COLc110 TINYINT, T1COLc111 BIGINT, 
T1COLc112 BIGINT, T1COLc113 BIGINT, T1COLc114 BIGINT, T1COLc115 BIGINT, 
T1COLc116 BIGINT, T1COLc117 BIGINT, T1COLc118 BIGINT, T1COLc119 BIGINT, 
T1COLc120 BIGINT, T1COLc121 TEXT, T1COLc122 TEXT, T1COLc123 TEXT, T1COLc124 
TEXT, T1COLc125 TEXT, T1COLc126 TEXT, T1COLc127 TEXT, T1COLc128 TEXT, T1COLc129 
TEXT, T1COLc130 TEXT, T
 1COLc131 TINYINT, T1COLc132 TINYINT, T1COLc133 TINYINT, T1COLc134 TINYINT, 
T1COLc135 TINYINT, T1COLc136 TINYINT, T1COLc137 TINYINT, T1COLc138 TINYINT, 
T1COLc139 TINYINT, T1COLc140 TINYINT, T1COLc141 INT, T1COLc142 INT, T1COLc143 
INT, T1COLc144 INT, T1COLc145 INT, T1COLc146 INT, T1COLc147 INT, T1COLc148 INT, 
T1COLc149 INT, T1COLc150 INT, T1COLd1 TEXT, T1COLd2 TEXT, T1COLd3 TEXT, T1COLd4 
TEXT, T1COLd5 TEXT, T1COLd6 TEXT, T1COLd7 TEXT, T1COLd8 TEXT, T1COLd9 TEXT, 
T1COLd10 TEXT, T1COLd11 TEXT, T1COLd12 TEXT, T1COLd13 TEXT, T1COLd14 TEXT, 
T1COLd15 TEXT, T1COLd16 TEXT, T1COLd17 TEXT, T1COLd18 TEXT, T1COLd19 TEXT, 
T1COLd20 TEXT, T1COLd21 TEXT, T1COLd22 TEXT, T1COLd23 TEXT, T1COLd24 TEXT, 
T1COLd25 TEXT, T1COLd26 TEXT, T1COLd27 TEXT, T1COLd28 TEXT, T1COLd29 TEXT, 
T1COLd30 TEXT, T1COLd31 TEXT, T1COLd32 TEXT, T1COLd33 TEXT, T1COLd34 TEXT, 
T1COLd35 TEXT, T1COLd36 TEXT, T1COLd37 TEXT, T1COLd38 TEXT, T1COLd39 TEXT, 
T1COLd40 TEXT, T1COLd41 TEXT, T1COLd42 TEXT, T1COLd43 TEXT, T1COLd44 TEXT, 
T1COLd4
 5 TEXT, T1COLd46 TEXT, T1COLd47 TEXT, T1COLd48 TEXT, T1COLd49 TEXT, T1COLd50 
TEXT, T1COLd51 INT, T1COLd52 INT, T1COLd53 INT, T1COLd54 INT, T1COLd55 INT, 
T1COLd56 INT, T1COLd57 INT, T1COLd58 INT, T1COLd59 INT, T1COLd60 INT, T1COLd61 
INT, T1COLd62 INT, T1COLd63 INT, T1COLd64 INT, T1COLd65 INT, T1COLd66 DOUBLE, 
T1COLd67 DOUBLE, T1COLd68 DOUBLE, T1COLd69 DOUBLE, T1COLd70 DOUBLE, T1COLd71 
DOUBLE, T1COLd72 DOUBLE, T1COLd73 DOUBLE, T1COLd74 DOUBLE, T1COLd75 DOUBLE, 
T1COLd76 DOUBLE, T1COLd77 DOUBLE, T1COLd78 DOUBLE, T1COLd79 DOUBLE, T1COLd80 
DOUBLE, T1COLd81 DATE, T1COLd82 DATE, T1COLd83 DATE, T1COLd84 DATE, T1COLd85 
DATE, T1COLd86 DATE, T1COLd87 DATE, T1COLd88 DATE, T1COLd89 DATE, T1COLd90 
DATE, T1COLd91 TIMESTAMP, T1COLd92 TIMESTAMP, T1COLd93 TIMESTAMP, T1COLd94 
TIMESTAMP, T1COLd95 TIMESTAMP, T1COLd96 TIMESTAMP, T1COLd97 TIMESTAMP, T1COLd98 
TIMESTAMP, T1COLd99 TIMESTAMP, T1COLd100 TIMESTAMP, T1COLd101 TINYINT, 
T1COLd102 TINYINT, T1COLd103 TINYINT, T1COLd104 TINYINT, T1COLd105 TINYINT, T1C
 OLd106 TINYINT, T1COLd107 TINYINT, T1COLd108 TINYINT, T1COLd109 TINYINT, 
T1COLd110 TINYINT, T1COLd111 BIGINT, T1COLd112 BIGINT, T1COLd113 BIGINT, 
T1COLd114 BIGINT, T1COLd115 BIGINT, T1COLd116 BIGINT, T1COLd117 BIGINT, 
T1COLd118 BIGINT, T1COLd119 BIGINT, T1COLd120 BIGINT, T1COLd121 TEXT, T1COLd122 
TEXT, T1COLd123 TEXT, T1COLd124 TEXT, T1COLd125 TEXT, T1COLd126 TEXT, T1COLd127 
TEXT, T1COLd128 TEXT, T1COLd129 TEXT, T1COLd130 TEXT, T1COLd131 TINYINT, 
T1COLd132 TINYINT, T1COLd133 TINYINT, T1COLd134 TINYINT, T1COLd135 TINYINT, 
T1COLd136 TINYINT, T1COLd137 TINYINT, T1COLd138 TINYINT, T1COLd139 TINYINT, 
T1COLd140 TINYINT, T1COLd141 INT, T1COLd142 INT, T1COLd143 INT, T1COLd144 INT, 
T1COLd145 INT, T1COLd146 INT, T1COLd147 INT, T1COLd148 INT, T1COLd149 INT, 
T1COLd150 INT, T1LASTCOL TEXT, PRIMARY KEY(T1PKCOL));
+CREATE TABLE Table2 (T2PKCOL bigint, T2COLa1 TEXT, T2COLa2 TEXT, T2COLa3 TEXT, 
T2COLa4 TEXT, T2COLa5 TEXT, T2COLa6 TEXT, T2COLa7 TEXT, T2COLa8 TEXT, T2COLa9 
TEXT, T2COLa10 TEXT, T2COLa11 TEXT, T2COLa12 TEXT, T2COLa13 TEXT, T2COLa14 
TEXT, T2COLa15 TEXT, T2COLa16 TEXT, T2COLa17 TEXT, T2COLa18 TEXT, T2COLa19 
TEXT, T2COLa20 TEXT, T2COLa21 TEXT, T2COLa22 TEXT, T2COLa23 TEXT, T2COLa24 
TEXT, T2COLa25 TEXT, T2COLa26 TEXT, T2COLa27 TEXT, T2COLa28 TEXT, T2COLa29 
TEXT, T2COLa30 TEXT, T2COLa31 TEXT, T2COLa32 TEXT, T2COLa33 TEXT, T2COLa34 
TEXT, T2COLa35 TEXT, T2COLa36 TEXT, T2COLa37 TEXT, T2COLa38 TEXT, T2COLa39 
TEXT, T2COLa40 TEXT, T2COLa41 TEXT, T2COLa42 TEXT, T2COLa43 TEXT, T2COLa44 
TEXT, T2COLa45 TEXT, T2COLa46 TEXT, T2COLa47 TEXT, T2COLa48 TEXT, T2COLa49 
TEXT, T2COLa50 TEXT, T2COLa51 INT, T2COLa52 INT, T2COLa53 INT, T2COLa54 INT, 
T2COLa55 INT, T2COLa56 INT, T2COLa57 INT, T2COLa58 INT, T2COLa59 INT, T2COLa60 
INT, T2COLa61 INT, T2COLa62 INT, T2COLa63 INT, T2COLa64 INT, T2COLa65 INT, 
T2COLa66 
 DOUBLE, T2COLa67 DOUBLE, T2COLa68 DOUBLE, T2COLa69 DOUBLE, T2COLa70 DOUBLE, 
T2COLa71 DOUBLE, T2COLa72 DOUBLE, T2COLa73 DOUBLE, T2COLa74 DOUBLE, T2COLa75 
DOUBLE, T2COLa76 DOUBLE, T2COLa77 DOUBLE, T2COLa78 DOUBLE, T2COLa79 DOUBLE, 
T2COLa80 DOUBLE, T2COLa81 DATE, T2COLa82 DATE, T2COLa83 DATE, T2COLa84 DATE, 
T2COLa85 DATE, T2COLa86 DATE, T2COLa87 DATE, T2COLa88 DATE, T2COLa89 DATE, 
T2COLa90 DATE, T2COLa91 TIMESTAMP, T2COLa92 TIMESTAMP, T2COLa93 TIMESTAMP, 
T2COLa94 TIMESTAMP, T2COLa95 TIMESTAMP, T2COLa96 TIMESTAMP, T2COLa97 TIMESTAMP, 
T2COLa98 TIMESTAMP, T2COLa99 TIMESTAMP, T2COLa100 TIMESTAMP, T2COLa101 TINYINT, 
T2COLa102 TINYINT, T2COLa103 TINYINT, T2COLa104 TINYINT, T2COLa105 TINYINT, 
T2COLa106 TINYINT, T2COLa107 TINYINT, T2COLa108 TINYINT, T2COLa109 TINYINT, 
T2COLa110 TINYINT, T2COLa111 BIGINT, T2COLa112 BIGINT, T2COLa113 BIGINT, 
T2COLa114 BIGINT, T2COLa115 BIGINT, T2COLa116 BIGINT, T2COLa117 BIGINT, 
T2COLa118 BIGINT, T2COLa119 BIGINT, T2COLa120 BIGINT, T2COLa121 TEXT, T2COLa122 
TEXT
 , T2COLa123 TEXT, T2COLa124 TEXT, T2COLa125 TEXT, T2COLa126 TEXT, T2COLa127 
TEXT, T2COLa128 TEXT, T2COLa129 TEXT, T2COLa130 TEXT, T2COLa131 TINYINT, 
T2COLa132 TINYINT, T2COLa133 TINYINT, T2COLa134 TINYINT, T2COLa135 TINYINT, 
T2COLa136 TINYINT, T2COLa137 TINYINT, T2COLa138 TINYINT, T2COLa139 TINYINT, 
T2COLa140 TINYINT, T2COLa141 INT, T2COLa142 INT, T2COLa143 INT, T2COLa144 INT, 
T2COLa145 INT, T2COLa146 INT, T2COLa147 INT, T2COLa148 INT, T2COLa149 INT, 
T2COLa150 INT, T2COLb1 TEXT, T2COLb2 TEXT, T2COLb3 TEXT, T2COLb4 TEXT, T2COLb5 
TEXT, T2COLb6 TEXT, T2COLb7 TEXT, T2COLb8 TEXT, T2COLb9 TEXT, T2COLb10 TEXT, 
T2COLb11 TEXT, T2COLb12 TEXT, T2COLb13 TEXT, T2COLb14 TEXT, T2COLb15 TEXT, 
T2COLb16 TEXT, T2COLb17 TEXT, T2COLb18 TEXT, T2COLb19 TEXT, T2COLb20 TEXT, 
T2COLb21 TEXT, T2COLb22 TEXT, T2COLb23 TEXT, T2COLb24 TEXT, T2COLb25 TEXT, 
T2COLb26 TEXT, T2COLb27 TEXT, T2COLb28 TEXT, T2COLb29 TEXT, T2COLb30 TEXT, 
T2COLb31 TEXT, T2COLb32 TEXT, T2COLb33 TEXT, T2COLb34 TEXT, T2COLb35 TEXT, 
T2COLb36 TE
 XT, T2COLb37 TEXT, T2COLb38 TEXT, T2COLb39 TEXT, T2COLb40 TEXT, T2COLb41 TEXT, 
T2COLb42 TEXT, T2COLb43 TEXT, T2COLb44 TEXT, T2COLb45 TEXT, T2COLb46 TEXT, 
T2COLb47 TEXT, T2COLb48 TEXT, T2COLb49 TEXT, T2COLb50 TEXT, T2COLb51 INT, 
T2COLb52 INT, T2COLb53 INT, T2COLb54 INT, T2COLb55 INT, T2COLb56 INT, T2COLb57 
INT, T2COLb58 INT, T2COLb59 INT, T2COLb60 INT, T2COLb61 INT, T2COLb62 INT, 
T2COLb63 INT, T2COLb64 INT, T2COLb65 INT, T2COLb66 DOUBLE, T2COLb67 DOUBLE, 
T2COLb68 DOUBLE, T2COLb69 DOUBLE, T2COLb70 DOUBLE, T2COLb71 DOUBLE, T2COLb72 
DOUBLE, T2COLb73 DOUBLE, T2COLb74 DOUBLE, T2COLb75 DOUBLE, T2COLb76 DOUBLE, 
T2COLb77 DOUBLE, T2COLb78 DOUBLE, T2COLb79 DOUBLE, T2COLb80 DOUBLE, T2COLb81 
DATE, T2COLb82 DATE, T2COLb83 DATE, T2COLb84 DATE, T2COLb85 DATE, T2COLb86 
DATE, T2COLb87 DATE, T2COLb88 DATE, T2COLb89 DATE, T2COLb90 DATE, T2COLb91 
TIMESTAMP, T2COLb92 TIMESTAMP, T2COLb93 TIMESTAMP, T2COLb94 TIMESTAMP, T2COLb95 
TIMESTAMP, T2COLb96 TIMESTAMP, T2COLb97 TIMESTAMP, T2COLb98 TIMESTAMP, T2COLb99
  TIMESTAMP, T2COLb100 TIMESTAMP, T2COLb101 TINYINT, T2COLb102 TINYINT, 
T2COLb103 TINYINT, T2COLb104 TINYINT, T2COLb105 TINYINT, T2COLb106 TINYINT, 
T2COLb107 TINYINT, T2COLb108 TINYINT, T2COLb109 TINYINT, T2COLb110 TINYINT, 
T2COLb111 BIGINT, T2COLb112 BIGINT, T2COLb113 BIGINT, T2COLb114 BIGINT, 
T2COLb115 BIGINT, T2COLb116 BIGINT, T2COLb117 BIGINT, T2COLb118 BIGINT, 
T2COLb119 BIGINT, T2COLb120 BIGINT, T2COLb121 TEXT, T2COLb122 TEXT, T2COLb123 
TEXT, T2COLb124 TEXT, T2COLb125 TEXT, T2COLb126 TEXT, T2COLb127 TEXT, T2COLb128 
TEXT, T2COLb129 TEXT, T2COLb130 TEXT, T2COLb131 TINYINT, T2COLb132 TINYINT, 
T2COLb133 TINYINT, T2COLb134 TINYINT, T2COLb135 TINYINT, T2COLb136 TINYINT, 
T2COLb137 TINYINT, T2COLb138 TINYINT, T2COLb139 TINYINT, T2COLb140 TINYINT, 
T2COLb141 INT, T2COLb142 INT, T2COLb143 INT, T2COLb144 INT, T2COLb145 INT, 
T2COLb146 INT, T2COLb147 INT, T2COLb148 INT, T2COLb149 INT, T2COLb150 INT, 
T2COLc1 TEXT, T2COLc2 TEXT, T2COLc3 TEXT, T2COLc4 TEXT, T2COLc5 TEXT, T2COLc6 
TEXT, T2COLc7 TE
 XT, T2COLc8 TEXT, T2COLc9 TEXT, T2COLc10 TEXT, T2COLc11 TEXT, T2COLc12 TEXT, 
T2COLc13 TEXT, T2COLc14 TEXT, T2COLc15 TEXT, T2COLc16 TEXT, T2COLc17 TEXT, 
T2COLc18 TEXT, T2COLc19 TEXT, T2COLc20 TEXT, T2COLc21 TEXT, T2COLc22 TEXT, 
T2COLc23 TEXT, T2COLc24 TEXT, T2COLc25 TEXT, T2COLc26 TEXT, T2COLc27 TEXT, 
T2COLc28 TEXT, T2COLc29 TEXT, T2COLc30 TEXT, T2COLc31 TEXT, T2COLc32 TEXT, 
T2COLc33 TEXT, T2COLc34 TEXT, T2COLc35 TEXT, T2COLc36 TEXT, T2COLc37 TEXT, 
T2COLc38 TEXT, T2COLc39 TEXT, T2COLc40 TEXT, T2COLc41 TEXT, T2COLc42 TEXT, 
T2COLc43 TEXT, T2COLc44 TEXT, T2COLc45 TEXT, T2COLc46 TEXT, T2COLc47 TEXT, 
T2COLc48 TEXT, T2COLc49 TEXT, T2COLc50 TEXT, T2COLc51 INT, T2COLc52 INT, 
T2COLc53 INT, T2COLc54 INT, T2COLc55 INT, T2COLc56 INT, T2COLc57 INT, T2COLc58 
INT, T2COLc59 INT, T2COLc60 INT, T2COLc61 INT, T2COLc62 INT, T2COLc63 INT, 
T2COLc64 INT, T2COLc65 INT, T2COLc66 DOUBLE, T2COLc67 DOUBLE, T2COLc68 DOUBLE, 
T2COLc69 DOUBLE, T2COLc70 DOUBLE, T2COLc71 DOUBLE, T2COLc72 DOUBLE, T2COLc73 
DOUBLE, T2CO
 Lc74 DOUBLE, T2COLc75 DOUBLE, T2COLc76 DOUBLE, T2COLc77 DOUBLE, T2COLc78 
DOUBLE, T2COLc79 DOUBLE, T2COLc80 DOUBLE, T2COLc81 DATE, T2COLc82 DATE, 
T2COLc83 DATE, T2COLc84 DATE, T2COLc85 DATE, T2COLc86 DATE, T2COLc87 DATE, 
T2COLc88 DATE, T2COLc89 DATE, T2COLc90 DATE, T2COLc91 TIMESTAMP, T2COLc92 
TIMESTAMP, T2COLc93 TIMESTAMP, T2COLc94 TIMESTAMP, T2COLc95 TIMESTAMP, T2COLc96 
TIMESTAMP, T2COLc97 TIMESTAMP, T2COLc98 TIMESTAMP, T2COLc99 TIMESTAMP, 
T2COLc100 TIMESTAMP, T2COLc101 TINYINT, T2COLc102 TINYINT, T2COLc103 TINYINT, 
T2COLc104 TINYINT, T2COLc105 TINYINT, T2COLc106 TINYINT, T2COLc107 TINYINT, 
T2COLc108 TINYINT, T2COLc109 TINYINT, T2COLc110 TINYINT, T2COLc111 BIGINT, 
T2COLc112 BIGINT, T2COLc113 BIGINT, T2COLc114 BIGINT, T2COLc115 BIGINT, 
T2COLc116 BIGINT, T2COLc117 BIGINT, T2COLc118 BIGINT, T2COLc119 BIGINT, 
T2COLc120 BIGINT, T2COLc121 TEXT, T2COLc122 TEXT, T2COLc123 TEXT, T2COLc124 
TEXT, T2COLc125 TEXT, T2COLc126 TEXT, T2COLc127 TEXT, T2COLc128 TEXT, T2COLc129 
TEXT, T2COLc130 TEXT, T
 2COLc131 TINYINT, T2COLc132 TINYINT, T2COLc133 TINYINT, T2COLc134 TINYINT, 
T2COLc135 TINYINT, T2COLc136 TINYINT, T2COLc137 TINYINT, T2COLc138 TINYINT, 
T2COLc139 TINYINT, T2COLc140 TINYINT, T2COLc141 INT, T2COLc142 INT, T2COLc143 
INT, T2COLc144 INT, T2COLc145 INT, T2COLc146 INT, T2COLc147 INT, T2COLc148 INT, 
T2COLc149 INT, T2COLc150 INT, T2COLd1 TEXT, T2COLd2 TEXT, T2COLd3 TEXT, T2COLd4 
TEXT, T2COLd5 TEXT, T2COLd6 TEXT, T2COLd7 TEXT, T2COLd8 TEXT, T2COLd9 TEXT, 
T2COLd10 TEXT, T2COLd11 TEXT, T2COLd12 TEXT, T2COLd13 TEXT, T2COLd14 TEXT, 
T2COLd15 TEXT, T2COLd16 TEXT, T2COLd17 TEXT, T2COLd18 TEXT, T2COLd19 TEXT, 
T2COLd20 TEXT, T2COLd21 TEXT, T2COLd22 TEXT, T2COLd23 TEXT, T2COLd24 TEXT, 
T2COLd25 TEXT, T2COLd26 TEXT, T2COLd27 TEXT, T2COLd28 TEXT, T2COLd29 TEXT, 
T2COLd30 TEXT, T2COLd31 TEXT, T2COLd32 TEXT, T2COLd33 TEXT, T2COLd34 TEXT, 
T2COLd35 TEXT, T2COLd36 TEXT, T2COLd37 TEXT, T2COLd38 TEXT, T2COLd39 TEXT, 
T2COLd40 TEXT, T2COLd41 TEXT, T2COLd42 TEXT, T2COLd43 TEXT, T2COLd44 TEXT, 
T2COLd4
 5 TEXT, T2COLd46 TEXT, T2COLd47 TEXT, T2COLd48 TEXT, T2COLd49 TEXT, T2COLd50 
TEXT, T2COLd51 INT, T2COLd52 INT, T2COLd53 INT, T2COLd54 INT, T2COLd55 INT, 
T2COLd56 INT, T2COLd57 INT, T2COLd58 INT, T2COLd59 INT, T2COLd60 INT, T2COLd61 
INT, T2COLd62 INT, T2COLd63 INT, T2COLd64 INT, T2COLd65 INT, T2COLd66 DOUBLE, 
T2COLd67 DOUBLE, T2COLd68 DOUBLE, T2COLd69 DOUBLE, T2COLd70 DOUBLE, T2COLd71 
DOUBLE, T2COLd72 DOUBLE, T2COLd73 DOUBLE, T2COLd74 DOUBLE, T2COLd75 DOUBLE, 
T2COLd76 DOUBLE, T2COLd77 DOUBLE, T2COLd78 DOUBLE, T2COLd79 DOUBLE, T2COLd80 
DOUBLE, T2COLd81 DATE, T2COLd82 DATE, T2COLd83 DATE, T2COLd84 DATE, T2COLd85 
DATE, T2COLd86 DATE, T2COLd87 DATE, T2COLd88 DATE, T2COLd89 DATE, T2COLd90 
DATE, T2COLd91 TIMESTAMP, T2COLd92 TIMESTAMP, T2COLd93 TIMESTAMP, T2COLd94 
TIMESTAMP, T2COLd95 TIMESTAMP, T2COLd96 TIMESTAMP, T2COLd97 TIMESTAMP, T2COLd98 
TIMESTAMP, T2COLd99 TIMESTAMP, T2COLd100 TIMESTAMP, T2COLd101 TINYINT, 
T2COLd102 TINYINT, T2COLd103 TINYINT, T2COLd104 TINYINT, T2COLd105 TINYINT, T2C
 OLd106 TINYINT, T2COLd107 TINYINT, T2COLd108 TINYINT, T2COLd109 TINYINT, 
T2COLd110 TINYINT, T2COLd111 BIGINT, T2COLd112 BIGINT, T2COLd113 BIGINT, 
T2COLd114 BIGINT, T2COLd115 BIGINT, T2COLd116 BIGINT, T2COLd117 BIGINT, 
T2COLd118 BIGINT, T2COLd119 BIGINT, T2COLd120 BIGINT, T2COLd121 TEXT, T2COLd122 
TEXT, T2COLd123 TEXT, T2COLd124 TEXT, T2COLd125 TEXT, T2COLd126 TEXT, T2COLd127 
TEXT, T2COLd128 TEXT, T2COLd129 TEXT, T2COLd130 TEXT, T2COLd131 TINYINT, 
T2COLd132 TINYINT, T2COLd133 TINYINT, T2COLd134 TINYINT, T2COLd135 TINYINT, 
T2COLd136 TINYINT, T2COLd137 TINYINT, T2COLd138 TINYINT, T2COLd139 TINYINT, 
T2COLd140 TINYINT, T2COLd141 INT, T2COLd142 INT, T2COLd143 INT, T2COLd144 INT, 
T2COLd145 INT, T2COLd146 INT, T2COLd147 INT, T2COLd148 INT, T2COLd149 INT, 
T2COLd150 INT, T2LASTCOL TEXT, PRIMARY KEY(T2PKCOL));
+CREATE TABLE Table3 (T3PKCOL bigint, T3COLa1 TEXT, T3COLa2 TEXT, T3COLa3 TEXT, 
T3COLa4 TEXT, T3COLa5 TEXT, T3COLa6 TEXT, T3COLa7 TEXT, T3COLa8 TEXT, T3COLa9 
TEXT, T3COLa10 TEXT, T3COLa11 TEXT, T3COLa12 TEXT, T3COLa13 TEXT, T3COLa14 
TEXT, T3COLa15 TEXT, T3COLa16 TEXT, T3COLa17 TEXT, T3COLa18 TEXT, T3COLa19 
TEXT, T3COLa20 TEXT, T3COLa21 TEXT, T3COLa22 TEXT, T3COLa23 TEXT, T3COLa24 
TEXT, T3COLa25 TEXT, T3COLa26 TEXT, T3COLa27 TEXT, T3COLa28 TEXT, T3COLa29 
TEXT, T3COLa30 TEXT, T3COLa31 TEXT, T3COLa32 TEXT, T3COLa33 TEXT, T3COLa34 
TEXT, T3COLa35 TEXT, T3COLa36 TEXT, T3COLa37 TEXT, T3COLa38 TEXT, T3COLa39 
TEXT, T3COLa40 TEXT, T3COLa41 TEXT, T3COLa42 TEXT, T3COLa43 TEXT, T3COLa44 
TEXT, T3COLa45 TEXT, T3COLa46 TEXT, T3COLa47 TEXT, T3COLa48 TEXT, T3COLa49 
TEXT, T3COLa50 TEXT, T3COLa51 INT, T3COLa52 INT, T3COLa53 INT, T3COLa54 INT, 
T3COLa55 INT, T3COLa56 INT, T3COLa57 INT, T3COLa58 INT, T3COLa59 INT, T3COLa60 
INT, T3COLa61 INT, T3COLa62 INT, T3COLa63 INT, T3COLa64 INT, T3COLa65 INT, 
T3COLa66 
 DOUBLE, T3COLa67 DOUBLE, T3COLa68 DOUBLE, T3COLa69 DOUBLE, T3COLa70 DOUBLE, 
T3COLa71 DOUBLE, T3COLa72 DOUBLE, T3COLa73 DOUBLE, T3COLa74 DOUBLE, T3COLa75 
DOUBLE, T3COLa76 DOUBLE, T3COLa77 DOUBLE, T3COLa78 DOUBLE, T3COLa79 DOUBLE, 
T3COLa80 DOUBLE, T3COLa81 DATE, T3COLa82 DATE, T3COLa83 DATE, T3COLa84 DATE, 
T3COLa85 DATE, T3COLa86 DATE, T3COLa87 DATE, T3COLa88 DATE, T3COLa89 DATE, 
T3COLa90 DATE, T3COLa91 TIMESTAMP, T3COLa92 TIMESTAMP, T3COLa93 TIMESTAMP, 
T3COLa94 TIMESTAMP, T3COLa95 TIMESTAMP, T3COLa96 TIMESTAMP, T3COLa97 TIMESTAMP, 
T3COLa98 TIMESTAMP, T3COLa99 TIMESTAMP, T3COLa100 TIMESTAMP, T3COLa101 TINYINT, 
T3COLa102 TINYINT, T3COLa103 TINYINT, T3COLa104 TINYINT, T3COLa105 TINYINT, 
T3COLa106 TINYINT, T3COLa107 TINYINT, T3COLa108 TINYINT, T3COLa109 TINYINT, 
T3COLa110 TINYINT, T3COLa111 BIGINT, T3COLa112 BIGINT, T3COLa113 BIGINT, 
T3COLa114 BIGINT, T3COLa115 BIGINT, T3COLa116 BIGINT, T3COLa117 BIGINT, 
T3COLa118 BIGINT, T3COLa119 BIGINT, T3COLa120 BIGINT, T3COLa121 TEXT, T3COLa122 
TEXT
 , T3COLa123 TEXT, T3COLa124 TEXT, T3COLa125 TEXT, T3COLa126 TEXT, T3COLa127 
TEXT, T3COLa128 TEXT, T3COLa129 TEXT, T3COLa130 TEXT, T3COLa131 TINYINT, 
T3COLa132 TINYINT, T3COLa133 TINYINT, T3COLa134 TINYINT, T3COLa135 TINYINT, 
T3COLa136 TINYINT, T3COLa137 TINYINT, T3COLa138 TINYINT, T3COLa139 TINYINT, 
T3COLa140 TINYINT, T3COLa141 INT, T3COLa142 INT, T3COLa143 INT, T3COLa144 INT, 
T3COLa145 INT, T3COLa146 INT, T3COLa147 INT, T3COLa148 INT, T3COLa149 INT, 
T3COLa150 INT, T3COLb1 TEXT, T3COLb2 TEXT, T3COLb3 TEXT, T3COLb4 TEXT, T3COLb5 
TEXT, T3COLb6 TEXT, T3COLb7 TEXT, T3COLb8 TEXT, T3COLb9 TEXT, T3COLb10 TEXT, 
T3COLb11 TEXT, T3COLb12 TEXT, T3COLb13 TEXT, T3COLb14 TEXT, T3COLb15 TEXT, 
T3COLb16 TEXT, T3COLb17 TEXT, T3COLb18 TEXT, T3COLb19 TEXT, T3COLb20 TEXT, 
T3COLb21 TEXT, T3COLb22 TEXT, T3COLb23 TEXT, T3COLb24 TEXT, T3COLb25 TEXT, 
T3COLb26 TEXT, T3COLb27 TEXT, T3COLb28 TEXT, T3COLb29 TEXT, T3COLb30 TEXT, 
T3COLb31 TEXT, T3COLb32 TEXT, T3COLb33 TEXT, T3COLb34 TEXT, T3COLb35 TEXT, 
T3COLb36 TE
 XT, T3COLb37 TEXT, T3COLb38 TEXT, T3COLb39 TEXT, T3COLb40 TEXT, T3COLb41 TEXT, 
T3COLb42 TEXT, T3COLb43 TEXT, T3COLb44 TEXT, T3COLb45 TEXT, T3COLb46 TEXT, 
T3COLb47 TEXT, T3COLb48 TEXT, T3COLb49 TEXT, T3COLb50 TEXT, T3COLb51 INT, 
T3COLb52 INT, T3COLb53 INT, T3COLb54 INT, T3COLb55 INT, T3COLb56 INT, T3COLb57 
INT, T3COLb58 INT, T3COLb59 INT, T3COLb60 INT, T3COLb61 INT, T3COLb62 INT, 
T3COLb63 INT, T3COLb64 INT, T3COLb65 INT, T3COLb66 DOUBLE, T3COLb67 DOUBLE, 
T3COLb68 DOUBLE, T3COLb69 DOUBLE, T3COLb70 DOUBLE, T3COLb71 DOUBLE, T3COLb72 
DOUBLE, T3COLb73 DOUBLE, T3COLb74 DOUBLE, T3COLb75 DOUBLE, T3COLb76 DOUBLE, 
T3COLb77 DOUBLE, T3COLb78 DOUBLE, T3COLb79 DOUBLE, T3COLb80 DOUBLE, T3COLb81 
DATE, T3COLb82 DATE, T3COLb83 DATE, T3COLb84 DATE, T3COLb85 DATE, T3COLb86 
DATE, T3COLb87 DATE, T3COLb88 DATE, T3COLb89 DATE, T3COLb90 DATE, T3COLb91 
TIMESTAMP, T3COLb92 TIMESTAMP, T3COLb93 TIMESTAMP, T3COLb94 TIMESTAMP, T3COLb95 
TIMESTAMP, T3COLb96 TIMESTAMP, T3COLb97 TIMESTAMP, T3COLb98 TIMESTAMP, T3COLb99
  TIMESTAMP, T3COLb100 TIMESTAMP, T3COLb101 TINYINT, T3COLb102 TINYINT, 
T3COLb103 TINYINT, T3COLb104 TINYINT, T3COLb105 TINYINT, T3COLb106 TINYINT, 
T3COLb107 TINYINT, T3COLb108 TINYINT, T3COLb109 TINYINT, T3COLb110 TINYINT, 
T3COLb111 BIGINT, T3COLb112 BIGINT, T3COLb113 BIGINT, T3COLb114 BIGINT, 
T3COLb115 BIGINT, T3COLb116 BIGINT, T3COLb117 BIGINT, T3COLb118 BIGINT, 
T3COLb119 BIGINT, T3COLb120 BIGINT, T3COLb121 TEXT, T3COLb122 TEXT, T3COLb123 
TEXT, T3COLb124 TEXT, T3COLb125 TEXT, T3COLb126 TEXT, T3COLb127 TEXT, T3COLb128 
TEXT, T3COLb129 TEXT, T3COLb130 TEXT, T3COLb131 TINYINT, T3COLb132 TINYINT, 
T3COLb133 TINYINT, T3COLb134 TINYINT, T3COLb135 TINYINT, T3COLb136 TINYINT, 
T3COLb137 TINYINT, T3COLb138 TINYINT, T3COLb139 TINYINT, T3COLb140 TINYINT, 
T3COLb141 INT, T3COLb142 INT, T3COLb143 INT, T3COLb144 INT, T3COLb145 INT, 
T3COLb146 INT, T3COLb147 INT, T3COLb148 INT, T3COLb149 INT, T3COLb150 INT, 
T3COLc1 TEXT, T3COLc2 TEXT, T3COLc3 TEXT, T3COLc4 TEXT, T3COLc5 TEXT, T3COLc6 
TEXT, T3COLc7 TE
 XT, T3COLc8 TEXT, T3COLc9 TEXT, T3COLc10 TEXT, T3COLc11 TEXT, T3COLc12 TEXT, 
T3COLc13 TEXT, T3COLc14 TEXT, T3COLc15 TEXT, T3COLc16 TEXT, T3COLc17 TEXT, 
T3COLc18 TEXT, T3COLc19 TEXT, T3COLc20 TEXT, T3COLc21 TEXT, T3COLc22 TEXT, 
T3COLc23 TEXT, T3COLc24 TEXT, T3COLc25 TEXT, T3COLc26 TEXT, T3COLc27 TEXT, 
T3COLc28 TEXT, T3COLc29 TEXT, T3COLc30 TEXT, T3COLc31 TEXT, T3COLc32 TEXT, 
T3COLc33 TEXT, T3COLc34 TEXT, T3COLc35 TEXT, T3COLc36 TEXT, T3COLc37 TEXT, 
T3COLc38 TEXT, T3COLc39 TEXT, T3COLc40 TEXT, T3COLc41 TEXT, T3COLc42 TEXT, 
T3COLc43 TEXT, T3COLc44 TEXT, T3COLc45 TEXT, T3COLc46 TEXT, T3COLc47 TEXT, 
T3COLc48 TEXT, T3COLc49 TEXT, T3COLc50 TEXT, T3COLc51 INT, T3COLc52 INT, 
T3COLc53 INT, T3COLc54 INT, T3COLc55 INT, T3COLc56 INT, T3COLc57 INT, T3COLc58 
INT, T3COLc59 INT, T3COLc60 INT, T3COLc61 INT, T3COLc62 INT, T3COLc63 INT, 
T3COLc64 INT, T3COLc65 INT, T3COLc66 DOUBLE, T3COLc67 DOUBLE, T3COLc68 DOUBLE, 
T3COLc69 DOUBLE, T3COLc70 DOUBLE, T3COLc71 DOUBLE, T3COLc72 DOUBLE, T3COLc73 
DOUBLE, T3CO
 Lc74 DOUBLE, T3COLc75 DOUBLE, T3COLc76 DOUBLE, T3COLc77 DOUBLE, T3COLc78 
DOUBLE, T3COLc79 DOUBLE, T3COLc80 DOUBLE, T3COLc81 DATE, T3COLc82 DATE, 
T3COLc83 DATE, T3COLc84 DATE, T3COLc85 DATE, T3COLc86 DATE, T3COLc87 DATE, 
T3COLc88 DATE, T3COLc89 DATE, T3COLc90 DATE, T3COLc91 TIMESTAMP, T3COLc92 
TIMESTAMP, T3COLc93 TIMESTAMP, T3COLc94 TIMESTAMP, T3COLc95 TIMESTAMP, T3COLc96 
TIMESTAMP, T3COLc97 TIMESTAMP, T3COLc98 TIMESTAMP, T3COLc99 TIMESTAMP, 
T3COLc100 TIMESTAMP, T3COLc101 TINYINT, T3COLc102 TINYINT, T3COLc103 TINYINT, 
T3COLc104 TINYINT, T3COLc105 TINYINT, T3COLc106 TINYINT, T3COLc107 TINYINT, 
T3COLc108 TINYINT, T3COLc109 TINYINT, T3COLc110 TINYINT, T3COLc111 BIGINT, 
T3COLc112 BIGINT, T3COLc113 BIGINT, T3COLc114 BIGINT, T3COLc115 BIGINT, 
T3COLc116 BIGINT, T3COLc117 BIGINT, T3COLc118 BIGINT, T3COLc119 BIGINT, 
T3COLc120 BIGINT, T3COLc121 TEXT, T3COLc122 TEXT, T3COLc123 TEXT, T3COLc124 
TEXT, T3COLc125 TEXT, T3COLc126 TEXT, T3COLc127 TEXT, T3COLc128 TEXT, T3COLc129 
TEXT, T3COLc130 TEXT, T
 3COLc131 TINYINT, T3COLc132 TINYINT, T3COLc133 TINYINT, T3COLc134 TINYINT, 
T3COLc135 TINYINT, T3COLc136 TINYINT, T3COLc137 TINYINT, T3COLc138 TINYINT, 
T3COLc139 TINYINT, T3COLc140 TINYINT, T3COLc141 INT, T3COLc142 INT, T3COLc143 
INT, T3COLc144 INT, T3COLc145 INT, T3COLc146 INT, T3COLc147 INT, T3COLc148 INT, 
T3COLc149 INT, T3COLc150 INT, T3COLd1 TEXT, T3COLd2 TEXT, T3COLd3 TEXT, T3COLd4 
TEXT, T3COLd5 TEXT, T3COLd6 TEXT, T3COLd7 TEXT, T3COLd8 TEXT, T3COLd9 TEXT, 
T3COLd10 TEXT, T3COLd11 TEXT, T3COLd12 TEXT, T3COLd13 TEXT, T3COLd14 TEXT, 
T3COLd15 TEXT, T3COLd16 TEXT, T3COLd17 TEXT, T3COLd18 TEXT, T3COLd19 TEXT, 
T3COLd20 TEXT, T3COLd21 TEXT, T3COLd22 TEXT, T3COLd23 TEXT, T3COLd24 TEXT, 
T3COLd25 TEXT, T3COLd26 TEXT, T3COLd27 TEXT, T3COLd28 TEXT, T3COLd29 TEXT, 
T3COLd30 TEXT, T3COLd31 TEXT, T3COLd32 TEXT, T3COLd33 TEXT, T3COLd34 TEXT, 
T3COLd35 TEXT, T3COLd36 TEXT, T3COLd37 TEXT, T3COLd38 TEXT, T3COLd39 TEXT, 
T3COLd40 TEXT, T3COLd41 TEXT, T3COLd42 TEXT, T3COLd43 TEXT, T3COLd44 TEXT, 
T3COLd4
 5 TEXT, T3COLd46 TEXT, T3COLd47 TEXT, T3COLd48 TEXT, T3COLd49 TEXT, T3COLd50 
TEXT, T3COLd51 INT, T3COLd52 INT, T3COLd53 INT, T3COLd54 INT, T3COLd55 INT, 
T3COLd56 INT, T3COLd57 INT, T3COLd58 INT, T3COLd59 INT, T3COLd60 INT, T3COLd61 
INT, T3COLd62 INT, T3COLd63 INT, T3COLd64 INT, T3COLd65 INT, T3COLd66 DOUBLE, 
T3COLd67 DOUBLE, T3COLd68 DOUBLE, T3COLd69 DOUBLE, T3COLd70 DOUBLE, T3COLd71 
DOUBLE, T3COLd72 DOUBLE, T3COLd73 DOUBLE, T3COLd74 DOUBLE, T3COLd75 DOUBLE, 
T3COLd76 DOUBLE, T3COLd77 DOUBLE, T3COLd78 DOUBLE, T3COLd79 DOUBLE, T3COLd80 
DOUBLE, T3COLd81 DATE, T3COLd82 DATE, T3COLd83 DATE, T3COLd84 DATE, T3COLd85 
DATE, T3COLd86 DATE, T3COLd87 DATE, T3COLd88 DATE, T3COLd89 DATE, T3COLd90 
DATE, T3COLd91 TIMESTAMP, T3COLd92 TIMESTAMP, T3COLd93 TIMESTAMP, T3COLd94 
TIMESTAMP, T3COLd95 TIMESTAMP, T3COLd96 TIMESTAMP, T3COLd97 TIMESTAMP, T3COLd98 
TIMESTAMP, T3COLd99 TIMESTAMP, T3COLd100 TIMESTAMP, T3COLd101 TINYINT, 
T3COLd102 TINYINT, T3COLd103 TINYINT, T3COLd104 TINYINT, T3COLd105 TINYINT, T3C
 OLd106 TINYINT, T3COLd107 TINYINT, T3COLd108 TINYINT, T3COLd109 TINYINT, 
T3COLd110 TINYINT, T3COLd111 BIGINT, T3COLd112 BIGINT, T3COLd113 BIGINT, 
T3COLd114 BIGINT, T3COLd115 BIGINT, T3COLd116 BIGINT, T3COLd117 BIGINT, 
T3COLd118 BIGINT, T3COLd119 BIGINT, T3COLd120 BIGINT, T3COLd121 TEXT, T3COLd122 
TEXT, T3COLd123 TEXT, T3COLd124 TEXT, T3COLd125 TEXT, T3COLd126 TEXT, T3COLd127 
TEXT, T3COLd128 TEXT, T3COLd129 TEXT, T3COLd130 TEXT, T3COLd131 TINYINT, 
T3COLd132 TINYINT, T3COLd133 TINYINT, T3COLd134 TINYINT, T3COLd135 TINYINT, 
T3COLd136 TINYINT, T3COLd137 TINYINT, T3COLd138 TINYINT, T3COLd139 TINYINT, 
T3COLd140 TINYINT, T3COLd141 INT, T3COLd142 INT, T3COLd143 INT, T3COLd144 INT, 
T3COLd145 INT, T3COLd146 INT, T3COLd147 INT, T3COLd148 INT, T3COLd149 INT, 
T3COLd150 INT, T3LASTCOL TEXT, PRIMARY KEY(T3PKCOL));
+CREATE TABLE Table4 (T4PKCOL bigint, T4COLa1 TEXT, T4COLa2 TEXT, T4COLa3 TEXT, 
T4COLa4 TEXT, T4COLa5 TEXT, T4COLa6 TEXT, T4COLa7 TEXT, T4COLa8 TEXT, T4COLa9 
TEXT, T4COLa10 TEXT, T4COLa11 TEXT, T4COLa12 TEXT, T4COLa13 TEXT, T4COLa14 
TEXT, T4COLa15 TEXT, T4COLa16 TEXT, T4COLa17 TEXT, T4COLa18 TEXT, T4COLa19 
TEXT, T4COLa20 TEXT, T4COLa21 TEXT, T4COLa22 TEXT, T4COLa23 TEXT, T4COLa24 
TEXT, T4COLa25 TEXT, T4COLa26 TEXT, T4COLa27 TEXT, T4COLa28 TEXT, T4COLa29 
TEXT, T4COLa30 TEXT, T4COLa31 TEXT, T4COLa32 TEXT, T4COLa33 TEXT, T4COLa34 
TEXT, T4COLa35 TEXT, T4COLa36 TEXT, T4COLa37 TEXT, T4COLa38 TEXT, T4COLa39 
TEXT, T4COLa40 TEXT, T4COLa41 TEXT, T4COLa42 TEXT, T4COLa43 TEXT, T4COLa44 
TEXT, T4COLa45 TEXT, T4COLa46 TEXT, T4COLa47 TEXT, T4COLa48 TEXT, T4COLa49 
TEXT, T4COLa50 TEXT, T4COLa51 INT, T4COLa52 INT, T4COLa53 INT, T4COLa54 INT, 
T4COLa55 INT, T4COLa56 INT, T4COLa57 INT, T4COLa58 INT, T4COLa59 INT, T4COLa60 
INT, T4COLa61 INT, T4COLa62 INT, T4COLa63 INT, T4COLa64 INT, T4COLa65 INT, 
T4COLa66 
 DOUBLE, T4COLa67 DOUBLE, T4COLa68 DOUBLE, T4COLa69 DOUBLE, T4COLa70 DOUBLE, 
T4COLa71 DOUBLE, T4COLa72 DOUBLE, T4COLa73 DOUBLE, T4COLa74 DOUBLE, T4COLa75 
DOUBLE, T4COLa76 DOUBLE, T4COLa77 DOUBLE, T4COLa78 DOUBLE, T4COLa79 DOUBLE, 
T4COLa80 DOUBLE, T4COLa81 DATE, T4COLa82 DATE, T4COLa83 DATE, T4COLa84 DATE, 
T4COLa85 DATE, T4COLa86 DATE, T4COLa87 DATE, T4COLa88 DATE, T4COLa89 DATE, 
T4COLa90 DATE, T4COLa91 TIMESTAMP, T4COLa92 TIMESTAMP, T4COLa93 TIMESTAMP, 
T4COLa94 TIMESTAMP, T4COLa95 TIMESTAMP, T4COLa96 TIMESTAMP, T4COLa97 TIMESTAMP, 
T4COLa98 TIMESTAMP, T4COLa99 TIMESTAMP, T4COLa100 TIMESTAMP, T4COLa101 TINYINT, 
T4COLa102 TINYINT, T4COLa103 TINYINT, T4COLa104 TINYINT, T4COLa105 TINYINT, 
T4COLa106 TINYINT, T4COLa107 TINYINT, T4COLa108 TINYINT, T4COLa109 TINYINT, 
T4COLa110 TINYINT, T4COLa111 BIGINT, T4COLa112 BIGINT, T4COLa113 BIGINT, 
T4COLa114 BIGINT, T4COLa115 BIGINT, T4COLa116 BIGINT, T4COLa117 BIGINT, 
T4COLa118 BIGINT, T4COLa119 BIGINT, T4COLa120 BIGINT, T4COLa121 TEXT, T4COLa122 
TEXT
 , T4COLa123 TEXT, T4COLa124 TEXT, T4COLa125 TEXT, T4COLa126 TEXT, T4COLa127 
TEXT, T4COLa128 TEXT, T4COLa129 TEXT, T4COLa130 TEXT, T4COLa131 TINYINT, 
T4COLa132 TINYINT, T4COLa133 TINYINT, T4COLa134 TINYINT, T4COLa135 TINYINT, 
T4COLa136 TINYINT, T4COLa137 TINYINT, T4COLa138 TINYINT, T4COLa139 TINYINT, 
T4COLa140 TINYINT, T4COLa141 INT, T4COLa142 INT, T4COLa143 INT, T4COLa144 INT, 
T4COLa145 INT, T4COLa146 INT, T4COLa147 INT, T4COLa148 INT, T4COLa149 INT, 
T4COLa150 INT, T4COLb1 TEXT, T4COLb2 TEXT, T4COLb3 TEXT, T4COLb4 TEXT, T4COLb5 
TEXT, T4COLb6 TEXT, T4COLb7 TEXT, T4COLb8 TEXT, T4COLb9 TEXT, T4COLb10 TEXT, 
T4COLb11 TEXT, T4COLb12 TEXT, T4COLb13 TEXT, T4COLb14 TEXT, T4COLb15 TEXT, 
T4COLb16 TEXT, T4COLb17 TEXT, T4COLb18 TEXT, T4COLb19 TEXT, T4COLb20 TEXT, 
T4COLb21 TEXT, T4COLb22 TEXT, T4COLb23 TEXT, T4COLb24 TEXT, T4COLb25 TEXT, 
T4COLb26 TEXT, T4COLb27 TEXT, T4COLb28 TEXT, T4COLb29 TEXT, T4COLb30 TEXT, 
T4COLb31 TEXT, T4COLb32 TEXT, T4COLb33 TEXT, T4COLb34 TEXT, T4COLb35 TEXT, 
T4COLb36 TE
 XT, T4COLb37 TEXT, T4COLb38 TEXT, T4COLb39 TEXT, T4COLb40 TEXT, T4COLb41 TEXT, 
T4COLb42 TEXT, T4COLb43 TEXT, T4COLb44 TEXT, T4COLb45 TEXT, T4COLb46 TEXT, 
T4COLb47 TEXT, T4COLb48 TEXT, T4COLb49 TEXT, T4COLb50 TEXT, T4COLb51 INT, 
T4COLb52 INT, T4COLb53 INT, T4COLb54 INT, T4COLb55 INT, T4COLb56 INT, T4COLb57 
INT, T4COLb58 INT, T4COLb59 INT, T4COLb60 INT, T4COLb61 INT, T4COLb62 INT, 
T4COLb63 INT, T4COLb64 INT, T4COLb65 INT, T4COLb66 DOUBLE, T4COLb67 DOUBLE, 
T4COLb68 DOUBLE, T4COLb69 DOUBLE, T4COLb70 DOUBLE, T4COLb71 DOUBLE, T4COLb72 
DOUBLE, T4COLb73 DOUBLE, T4COLb74 DOUBLE, T4COLb75 DOUBLE, T4COLb76 DOUBLE, 
T4COLb77 DOUBLE, T4COLb78 DOUBLE, T4COLb79 DOUBLE, T4COLb80 DOUBLE, T4COLb81 
DATE, T4COLb82 DATE, T4COLb83 DATE, T4COLb84 DATE, T4COLb85 DATE, T4COLb86 
DATE, T4COLb87 DATE, T4COLb88 DATE, T4COLb89 DATE, T4COLb90 DATE, T4COLb91 
TIMESTAMP, T4COLb92 TIMESTAMP, T4COLb93 TIMESTAMP, T4COLb94 TIMESTAMP, T4COLb95 
TIMESTAMP, T4COLb96 TIMESTAMP, T4COLb97 TIMESTAMP, T4COLb98 TIMESTAMP, T4COLb99
  TIMESTAMP, T4COLb100 TIMESTAMP, T4COLb101 TINYINT, T4COLb102 TINYINT, 
T4COLb103 TINYINT, T4COLb104 TINYINT, T4COLb105 TINYINT, T4COLb106 TINYINT, 
T4COLb107 TINYINT, T4COLb108 TINYINT, T4COLb109 TINYINT, T4COLb110 TINYINT, 
T4COLb111 BIGINT, T4COLb112 BIGINT, T4COLb113 BIGINT, T4COLb114 BIGINT, 
T4COLb115 BIGINT, T4COLb116 BIGINT, T4COLb117 BIGINT, T4COLb118 BIGINT, 
T4COLb119 BIGINT, T4COLb120 BIGINT, T4COLb121 TEXT, T4COLb122 TEXT, T4COLb123 
TEXT, T4COLb124 TEXT, T4COLb125 TEXT, T4COLb126 TEXT, T4COLb127 TEXT, T4COLb128 
TEXT, T4COLb129 TEXT, T4COLb130 TEXT, T4COLb131 TINYINT, T4COLb132 TINYINT, 
T4COLb133 TINYINT, T4COLb134 TINYINT, T4COLb135 TINYINT, T4COLb136 TINYINT, 
T4COLb137 TINYINT, T4COLb138 TINYINT, T4COLb139 TINYINT, T4COLb140 TINYINT, 
T4COLb141 INT, T4COLb142 INT, T4COLb143 INT, T4COLb144 INT, T4COLb145 INT, 
T4COLb146 INT, T4COLb147 INT, T4COLb148 INT, T4COLb149 INT, T4COLb150 INT, 
T4COLc1 TEXT, T4COLc2 TEXT, T4COLc3 TEXT, T4COLc4 TEXT, T4COLc5 TEXT, T4COLc6 
TEXT, T4COLc7 TE
 XT, T4COLc8 TEXT, T4COLc9 TEXT, T4COLc10 TEXT, T4COLc11 TEXT, T4COLc12 TEXT, 
T4COLc13 TEXT, T4COLc14 TEXT, T4COLc15 TEXT, T4COLc16 TEXT, T4COLc17 TEXT, 
T4COLc18 TEXT, T4COLc19 TEXT, T4COLc20 TEXT, T4COLc21 TEXT, T4COLc22 TEXT, 
T4COLc23 TEXT, T4COLc24 TEXT, T4COLc25 TEXT, T4COLc26 TEXT, T4COLc27 TEXT, 
T4COLc28 TEXT, T4COLc29 TEXT, T4COLc30 TEXT, T4COLc31 TEXT, T4COLc32 TEXT, 
T4COLc33 TEXT, T4COLc34 TEXT, T4COLc35 TEXT, T4COLc36 TEXT, T4COLc37 TEXT, 
T4COLc38 TEXT, T4COLc39 TEXT, T4COLc40 TEXT, T4COLc41 TEXT, T4COLc42 TEXT, 
T4COLc43 TEXT, T4COLc44 TEXT, T4COLc45 TEXT, T4COLc46 TEXT, T4COLc47 TEXT, 
T4COLc48 TEXT, T4COLc49 TEXT, T4COLc50 TEXT, T4COLc51 INT, T4COLc52 INT, 
T4COLc53 INT, T4COLc54 INT, T4COLc55 INT, T4COLc56 INT, T4COLc57 INT, T4COLc58 
INT, T4COLc59 INT, T4COLc60 INT, T4COLc61 INT, T4COLc62 INT, T4COLc63 INT, 
T4COLc64 INT, T4COLc65 INT, T4COLc66 DOUBLE, T4COLc67 DOUBLE, T4COLc68 DOUBLE, 
T4COLc69 DOUBLE, T4COLc70 DOUBLE, T4COLc71 DOUBLE, T4COLc72 DOUBLE, T4COLc73 
DOUBLE, T4CO
 Lc74 DOUBLE, T4COLc75 DOUBLE, T4COLc76 DOUBLE, T4COLc77 DOUBLE, T4COLc78 
DOUBLE, T4COLc79 DOUBLE, T4COLc80 DOUBLE, T4COLc81 DATE, T4COLc82 DATE, 
T4COLc83 DATE, T4COLc84 DATE, T4COLc85 DATE, T4COLc86 DATE, T4COLc87 DATE, 
T4COLc88 DATE, T4COLc89 DATE, T4COLc90 DATE, T4COLc91 TIMESTAMP, T4COLc92 
TIMESTAMP, T4COLc93 TIMESTAMP, T4COLc94 TIMESTAMP, T4COLc95 TIMESTAMP, T4COLc96 
TIMESTAMP, T4COLc97 TIMESTAMP, T4COLc98 TIMESTAMP, T4COLc99 TIMESTAMP, 
T4COLc100 TIMESTAMP, T4COLc101 TINYINT, T4COLc102 TINYINT, T4COLc103 TINYINT, 
T4COLc104 TINYINT, T4COLc105 TINYINT, T4COLc106 TINYINT, T4COLc107 TINYINT, 
T4COLc108 TINYINT, T4COLc109 TINYINT, T4COLc110 TINYINT, T4COLc111 BIGINT, 
T4COLc112 BIGINT, T4COLc113 BIGINT, T4COLc114 BIGINT, T4COLc115 BIGINT, 
T4COLc116 BIGINT, T4COLc117 BIGINT, T4COLc118 BIGINT, T4COLc119 BIGINT, 
T4COLc120 BIGINT, T4COLc121 TEXT, T4COLc122 TEXT, T4COLc123 TEXT, T4COLc124 
TEXT, T4COLc125 TEXT, T4COLc126 TEXT, T4COLc127 TEXT, T4COLc128 TEXT, T4COLc129 
TEXT, T4COLc130 TEXT, T
 4COLc131 TINYINT, T4COLc132 TINYINT, T4COLc133 TINYINT, T4COLc134 TINYINT, 
T4COLc135 TINYINT, T4COLc136 TINYINT, T4COLc137 TINYINT, T4COLc138 TINYINT, 
T4COLc139 TINYINT, T4COLc140 TINYINT, T4COLc141 INT, T4COLc142 INT, T4COLc143 
INT, T4COLc144 INT, T4COLc145 INT, T4COLc146 INT, T4COLc147 INT, T4COLc148 INT, 
T4COLc149 INT, T4COLc150 INT, T4COLd1 TEXT, T4COLd2 TEXT, T4COLd3 TEXT, T4COLd4 
TEXT, T4COLd5 TEXT, T4COLd6 TEXT, T4COLd7 TEXT, T4COLd8 TEXT, T4COLd9 TEXT, 
T4COLd10 TEXT, T4COLd11 TEXT, T4COLd12 TEXT, T4COLd13 TEXT, T4COLd14 TEXT, 
T4COLd15 TEXT, T4COLd16 TEXT, T4COLd17 TEXT, T4COLd18 TEXT, T4COLd19 TEXT, 
T4COLd20 TEXT, T4COLd21 TEXT, T4COLd22 TEXT, T4COLd23 TEXT, T4COLd24 TEXT, 
T4COLd25 TEXT, T4COLd26 TEXT, T4COLd27 TEXT, T4COLd28 TEXT, T4COLd29 TEXT, 
T4COLd30 TEXT, T4COLd31 TEXT, T4COLd32 TEXT, T4COLd33 TEXT, T4COLd34 TEXT, 
T4COLd35 TEXT, T4COLd36 TEXT, T4COLd37 TEXT, T4COLd38 TEXT, T4COLd39 TEXT, 
T4COLd40 TEXT, T4COLd41 TEXT, T4COLd42 TEXT, T4COLd43 TEXT, T4COLd44 TEXT, 
T4COLd4
 5 TEXT, T4COLd46 TEXT, T4COLd47 TEXT, T4COLd48 TEXT, T4COLd49 TEXT, T4COLd50 
TEXT, T4COLd51 INT, T4COLd52 INT, T4COLd53 INT, T4COLd54 INT, T4COLd55 INT, 
T4COLd56 INT, T4COLd57 INT, T4COLd58 INT, T4COLd59 INT, T4COLd60 INT, T4COLd61 
INT, T4COLd62 INT, T4COLd63 INT, T4COLd64 INT, T4COLd65 INT, T4COLd66 DOUBLE, 
T4COLd67 DOUBLE, T4COLd68 DOUBLE, T4COLd69 DOUBLE, T4COLd70 DOUBLE, T4COLd71 
DOUBLE, T4COLd72 DOUBLE, T4COLd73 DOUBLE, T4COLd74 DOUBLE, T4COLd75 DOUBLE, 
T4COLd76 DOUBLE, T4COLd77 DOUBLE, T4COLd78 DOUBLE, T4COLd79 DOUBLE, T4COLd80 
DOUBLE, T4COLd81 DATE, T4COLd82 DATE, T4COLd83 DATE, T4COLd84 DATE, T4COLd85 
DATE, T4COLd86 DATE, T4COLd87 DATE, T4COLd88 DATE, T4COLd89 DATE, T4COLd90 
DATE, T4COLd91 TIMESTAMP, T4COLd92 TIMESTAMP, T4COLd93 TIMESTAMP, T4COLd94 
TIMESTAMP, T4COLd95 TIMESTAMP, T4COLd96 TIMESTAMP, T4COLd97 TIMESTAMP, T4COLd98 
TIMESTAMP, T4COLd99 TIMESTAMP, T4COLd100 TIMESTAMP, T4COLd101 TINYINT, 
T4COLd102 TINYINT, T4COLd103 TINYINT, T4COLd104 TINYINT, T4COLd105 TINYINT, T4C
 OLd106 TINYINT, T4COLd107 TINYINT, T4COLd108 TINYINT, T4COLd109 TINYINT, 
T4COLd110 TINYINT, T4COLd111 BIGINT, T4COLd112 BIGINT, T4COLd113 BIGINT, 
T4COLd114 BIGINT, T4COLd115 BIGINT, T4COLd116 BIGINT, T4COLd117 BIGINT, 
T4COLd118 BIGINT, T4COLd119 BIGINT, T4COLd120 BIGINT, T4COLd121 TEXT, T4COLd122 
TEXT, T4COLd123 TEXT, T4COLd124 TEXT, T4COLd125 TEXT, T4COLd126 TEXT, T4COLd127 
TEXT, T4COLd128 TEXT, T4COLd129 TEXT, T4COLd130 TEXT, T4COLd131 TINYINT, 
T4COLd132 TINYINT, T4COLd133 TINYINT, T4COLd134 TINYINT, T4COLd135 TINYINT, 
T4COLd136 TINYINT, T4COLd137 TINYINT, T4COLd138 TINYINT, T4COLd139 TINYINT, 
T4COLd140 TINYINT, T4COLd141 INT, T4COLd142 INT, T4COLd143 INT, T4COLd144 INT, 
T4COLd145 INT, T4COLd146 INT, T4COLd147 INT, T4COLd148 INT, T4COLd149 INT, 
T4COLd150 INT, T4LASTCOL TEXT, PRIMARY KEY(T4PKCOL));
+CREATE TABLE Table5 (T5PKCOL bigint, T5COLa1 TEXT, T5COLa2 TEXT, T5COLa3 TEXT, 
T5COLa4 TEXT, T5COLa5 TEXT, T5COLa6 TEXT, T5COLa7 TEXT, T5COLa8 TEXT, T5COLa9 
TEXT, T5COLa10 TEXT, T5COLa11 TEXT, T5COLa12 TEXT, T5COLa13 TEXT, T5COLa14 
TEXT, T5COLa15 TEXT, T5COLa16 TEXT, T5COLa17 TEXT, T5COLa18 TEXT, T5COLa19 
TEXT, T5COLa20 TEXT, T5COLa21 TEXT, T5COLa22 TEXT, T5COLa23 TEXT, T5COLa24 
TEXT, T5COLa25 TEXT, T5COLa26 TEXT, T5COLa27 TEXT, T5COLa28 TEXT, T5COLa29 
TEXT, T5COLa30 TEXT, T5COLa31 TEXT, T5COLa32 TEXT, T5COLa33 TEXT, T5COLa34 
TEXT, T5COLa35 TEXT, T5COLa36 TEXT, T5COLa37 TEXT, T5COLa38 TEXT, T5COLa39 
TEXT, T5COLa40 TEXT, T5COLa41 TEXT, T5COLa42 TEXT, T5COLa43 TEXT, T5COLa44 
TEXT, T5COLa45 TEXT, T5COLa46 TEXT, T5COLa47 TEXT, T5COLa48 TEXT, T5COLa49 
TEXT, T5COLa50 TEXT, T5COLa51 INT, T5COLa52 INT, T5COLa53 INT, T5COLa54 INT, 
T5COLa55 INT, T5COLa56 INT, T5COLa57 INT, T5COLa58 INT, T5COLa59 INT, T5COLa60 
INT, T5COLa61 INT, T5COLa62 INT, T5COLa63 INT, T5COLa64 INT, T5COLa65 INT, 
T5COLa66 
 DOUBLE, T5COLa67 DOUBLE, T5COLa68 DOUBLE, T5COLa69 DOUBLE, T5COLa70 DOUBLE, 
T5COLa71 DOUBLE, T5COLa72 DOUBLE, T5COLa73 DOUBLE, T5COLa74 DOUBLE, T5COLa75 
DOUBLE, T5COLa76 DOUBLE, T5COLa77 DOUBLE, T5COLa78 DOUBLE, T5COLa79 DOUBLE, 
T5COLa80 DOUBLE, T5COLa81 DATE, T5COLa82 DATE, T5COLa83 DATE, T5COLa84 DATE, 
T5COLa85 DATE, T5COLa86 DATE, T5COLa87 DATE, T5COLa88 DATE, T5COLa89 DATE, 
T5COLa90 DATE, T5COLa91 TIMESTAMP, T5COLa92 TIMESTAMP, T5COLa93 TIMESTAMP, 
T5COLa94 TIMESTAMP, T5COLa95 TIMESTAMP, T5COLa96 TIMESTAMP, T5COLa97 TIMESTAMP, 
T5COLa98 TIMESTAMP, T5COLa99 TIMESTAMP, T5COLa100 TIMESTAMP, T5COLa101 TINYINT, 
T5COLa102 TINYINT, T5COLa103 TINYINT, T5COLa104 TINYINT, T5COLa105 TINYINT, 
T5COLa106 TINYINT, T5COLa107 TINYINT, T5COLa108 TINYINT, T5COLa109 TINYINT, 
T5COLa110 TINYINT, T5COLa111 BIGINT, T5COLa112 BIGINT, T5COLa113 BIGINT, 
T5COLa114 BIGINT, T5COLa115 BIGINT, T5COLa116 BIGINT, T5COLa117 BIGINT, 
T5COLa118 BIGINT, T5COLa119 BIGINT, T5COLa120 BIGINT, T5COLa121 TEXT, T5COLa122 
TEXT
 , T5COLa123 TEXT, T5COLa124 TEXT, T5COLa125 TEXT, T5COLa126 TEXT, T5COLa127 
TEXT, T5COLa128 TEXT, T5COLa129 TEXT, T5COLa130 TEXT, T5COLa131 TINYINT, 
T5COLa132 TINYINT, T5COLa133 TINYINT, T5COLa134 TINYINT, T5COLa135 TINYINT, 
T5COLa136 TINYINT, T5COLa137 TINYINT, T5COLa138 TINYINT, T5COLa139 TINYINT, 
T5COLa140 TINYINT, T5COLa141 INT, T5COLa142 INT, T5COLa143 INT, T5COLa144 INT, 
T5COLa145 INT, T5COLa146 INT, T5COLa147 INT, T5COLa148 INT, T5COLa149 INT, 
T5COLa150 INT, T5COLb1 TEXT, T5COLb2 TEXT, T5COLb3 TEXT, T5COLb4 TEXT, T5COLb5 
TEXT, T5COLb6 TEXT, T5COLb7 TEXT, T5COLb8 TEXT, T5COLb9 TEXT, T5COLb10 TEXT, 
T5COLb11 TEXT, T5COLb12 TEXT, T5COLb13 TEXT, T5COLb14 TEXT, T5COLb15 TEXT, 
T5COLb16 TEXT, T5COLb17 TEXT, T5COLb18 TEXT, T5COLb19 TEXT, T5COLb20 TEXT, 
T5COLb21 TEXT, T5COLb22 TEXT, T5COLb23 TEXT, T5COLb24 TEXT, T5COLb25 TEXT, 
T5COLb26 TEXT, T5COLb27 TEXT, T5COLb28 TEXT, T5COLb29 TEXT, T5COLb30 TEXT, 
T5COLb31 TEXT, T5COLb32 TEXT, T5COLb33 TEXT, T5COLb34 TEXT, T5COLb35 TEXT, 
T5COLb36 TE
 XT, T5COLb37 TEXT, T5COLb38 TEXT, T5COLb39 TEXT, T5COLb40 TEXT, T5COLb41 TEXT, 
T5COLb42 TEXT, T5COLb43 TEXT, T5COLb44 TEXT, T5COLb45 TEXT, T5COLb46 TEXT, 
T5COLb47 TEXT, T5COLb48 TEXT, T5COLb49 TEXT, T5COLb50 TEXT, T5COLb51 INT, 
T5COLb52 INT, T5COLb53 INT, T5COLb54 INT, T5COLb55 INT, T5COLb56 INT, T5COLb57 
INT, T5COLb58 INT, T5COLb59 INT, T5COLb60 INT, T5COLb61 INT, T5COLb62 INT, 
T5COLb63 INT, T5COLb64 INT, T5COLb65 INT, T5COLb66 DOUBLE, T5COLb67 DOUBLE, 
T5COLb68 DOUBLE, T5COLb69 DOUBLE, T5COLb70 DOUBLE, T5COLb71 DOUBLE, T5COLb72 
DOUBLE, T5COLb73 DOUBLE, T5COLb74 DOUBLE, T5COLb75 DOUBLE, T5COLb76 DOUBLE, 
T5COLb77 DOUBLE, T5COLb78 DOUBLE, T5COLb79 DOUBLE, T5COLb80 DOUBLE, T5COLb81 
DATE, T5COLb82 DATE, T5COLb83 DATE, T5COLb84 DATE, T5COLb85 DATE, T5COLb86 
DATE, T5COLb87 DATE, T5COLb88 DATE, T5COLb89 DATE, T5COLb90 DATE, T5COLb91 
TIMESTAMP, T5COLb92 TIMESTAMP, T5COLb93 TIMESTAMP, T5COLb94 TIMESTAMP, T5COLb95 
TIMESTAMP, T5COLb96 TIMESTAMP, T5COLb97 TIMESTAMP, T5COLb98 TIMESTAMP, T5COLb99
  TIMESTAMP, T5COLb100 TIMESTAMP, T5COLb101 TINYINT, T5COLb102 TINYINT, 
T5COLb103 TINYINT, T5COLb104 TINYINT, T5COLb105 TINYINT, T5COLb106 TINYINT, 
T5COLb107 TINYINT, T5COLb108 TINYINT, T5COLb109 TINYINT, T5COLb110 TINYINT, 
T5COLb111 BIGINT, T5COLb112 BIGINT, T5COLb113 BIGINT, T5COLb114 BIGINT, 
T5COLb115 BIGINT, T5COLb116 BIGINT, T5COLb117 BIGINT, T5COLb118 BIGINT, 
T5COLb119 BIGINT, T5COLb120 BIGINT, T5COLb121 TEXT, T5COLb122 TEXT, T5COLb123 
TEXT, T5COLb124 TEXT, T5COLb125 TEXT, T5COLb126 TEXT, T5COLb127 TEXT, T5COLb128 
TEXT, T5COLb129 TEXT, T5COLb130 TEXT, T5COLb131 TINYINT, T5COLb132 TINYINT, 
T5COLb133 TINYINT, T5COLb134 TINYINT, T5COLb135 TINYINT, T5COLb136 TINYINT, 
T5COLb137 TINYINT, T5COLb138 TINYINT, T5COLb139 TINYINT, T5COLb140 TINYINT, 
T5COLb141 INT, T5COLb142 INT, T5COLb143 INT, T5COLb144 INT, T5COLb145 INT, 
T5COLb146 INT, T5COLb147 INT, T5COLb148 INT, T5COLb149 INT, T5COLb150 INT, 
T5COLc1 TEXT, T5COLc2 TEXT, T5COLc3 TEXT, T5COLc4 TEXT, T5COLc5 TEXT, T5COLc6 
TEXT, T5COLc7 TE
 XT, T5COLc8 TEXT, T5COLc9 TEXT, T5COLc10 TEXT, T5COLc11 TEXT, T5COLc12 TEXT, 
T5COLc13 TEXT, T5COLc14 TEXT, T5COLc15 TEXT, T5COLc16 TEXT, T5COLc17 TEXT, 
T5COLc18 TEXT, T5COLc19 TEXT, T5COLc20 TEXT, T5COLc21 TEXT, T5COLc22 TEXT, 
T5COLc23 TEXT, T5COLc24 TEXT, T5COLc25 TEXT, T5COLc26 TEXT, T5COLc27 TEXT, 
T5COLc28 TEXT, T5COLc29 TEXT, T5COLc30 TEXT, T5COLc31 TEXT, T5COLc32 TEXT, 
T5COLc33 TEXT, T5COLc34 TEXT, T5COLc35 TEXT, T5COLc36 TEXT, T5COLc37 TEXT, 
T5COLc38 TEXT, T5COLc39 TEXT, T5COLc40 TEXT, T5COLc41 TEXT, T5COLc42 TEXT, 
T5COLc43 TEXT, T5COLc44 TEXT, T5COLc45 TEXT, T5COLc46 TEXT, T5COLc47 TEXT, 
T5COLc48 TEXT, T5COLc49 TEXT, T5COLc50 TEXT, T5COLc51 INT, T5COLc52 INT, 
T5COLc53 INT, T5COLc54 INT, T5COLc55 INT, T5COLc56 INT, T5COLc57 INT, T5COLc58 
INT, T5COLc59 INT, T5COLc60 INT, T5COLc61 INT, T5COLc62 INT, T5COLc63 INT, 
T5COLc64 INT, T5COLc65 INT, T5COLc66 DOUBLE, T5COLc67 DOUBLE, T5COLc68 DOUBLE, 
T5COLc69 DOUBLE, T5COLc70 DOUBLE, T5COLc71 DOUBLE, T5COLc72 DOUBLE, T5COLc73 
DOUBLE, T5CO
 Lc74 DOUBLE, T5COLc75 DOUBLE, T5COLc76 DOUBLE, T5COLc77 DOUBLE, T5COLc78 
DOUBLE, T5COLc79 DOUBLE, T5COLc80 DOUBLE, T5COLc81 DATE, T5COLc82 DATE, 
T5COLc83 DATE, T5COLc84 DATE, T5COLc85 DATE, T5COLc86 DATE, T5COLc87 DATE, 
T5COLc88 DATE, T5COLc89 DATE, T5COLc90 DATE, T5COLc91 TIMESTAMP, T5COLc92 
TIMESTAMP, T5COLc93 TIMESTAMP, T5COLc94 TIMESTAMP, T5COLc95 TIMESTAMP, T5COLc96 
TIMESTAMP, T5COLc97 TIMESTAMP, T5COLc98 TIMESTAMP, T5COLc99 TIMESTAMP, 
T5COLc100 TIMESTAMP, T5COLc101 TINYINT, T5COLc102 TINYINT, T5COLc103 TINYINT, 
T5COLc104 TINYINT, T5COLc105 TINYINT, T5COLc106 TINYINT, T5COLc107 TINYINT, 
T5COLc108 TINYINT, T5COLc109 TINYINT, T5COLc110 TINYINT, T5COLc111 BIGINT, 
T5COLc112 BIGINT, T5COLc113 BIGINT, T5COLc114 BIGINT, T5COLc115 BIGINT, 
T5COLc116 BIGINT, T5COLc117 BIGINT, T5COLc118 BIGINT, T5COLc119 BIGINT, 
T5COLc120 BIGINT, T5COLc121 TEXT, T5COLc122 TEXT, T5COLc123 TEXT, T5COLc124 
TEXT, T5COLc125 TEXT, T5COLc126 TEXT, T5COLc127 TEXT, T5COLc128 TEXT, T5COLc129 
TEXT, T5COLc130 TEXT, T
 5COLc131 TINYINT, T5COLc132 TINYINT, T5COLc133 TINYINT, T5COLc134 TINYINT, 
T5COLc135 TINYINT, T5COLc136 TINYINT, T5COLc137 TINYINT, T5COLc138 TINYINT, 
T5COLc139 TINYINT, T5COLc140 TINYINT, T5COLc141 INT, T5COLc142 INT, T5COLc143 
INT, T5COLc144 INT, T5COLc145 INT, T5COLc146 INT, T5COLc147 INT, T5COLc148 INT, 
T5COLc149 INT, T5COLc150 INT, T5COLd1 TEXT, T5COLd2 TEXT, T5COLd3 TEXT, T5COLd4 
TEXT, T5COLd5 TEXT, T5COLd6 TEXT, T5COLd7 TEXT, T5COLd8 TEXT, T5COLd9 TEXT, 
T5COLd10 TEXT, T5COLd11 TEXT, T5COLd12 TEXT, T5COLd13 TEXT, T5COLd14 TEXT, 
T5COLd15 TEXT, T5COLd16 TEXT, T5COLd17 TEXT, T5COLd18 TEXT, T5COLd19 TEXT, 
T5COLd20 TEXT, T5COLd21 TEXT, T5COLd22 TEXT, T5COLd23 TEXT, T5COLd24 TEXT, 
T5COLd25 TEXT, T5COLd26 TEXT, T5COLd27 TEXT, T5COLd28 TEXT, T5COLd29 TEXT, 
T5COLd30 TEXT, T5COLd31 TEXT, T5COLd32 TEXT, T5COLd33 TEXT, T5COLd34 TEXT, 
T5COLd35 TEXT, T5COLd36 TEXT, T5COLd37 TEXT, T5COLd38 TEXT, T5COLd39 TEXT, 
T5COLd40 TEXT, T5COLd41 TEXT, T5COLd42 TEXT, T5COLd43 TEXT, T5COLd44 TEXT, 
T5COLd4
 5 TEXT, T5COLd46 TEXT, T5COLd47 TEXT, T5COLd48 TEXT, T5COLd49 TEXT, T5COLd50 
TEXT, T5COLd51 INT, T5COLd52 INT, T5COLd53 INT, T5COLd54 INT, T5COLd55 INT, 
T5COLd56 INT, T5COLd57 INT, T5COLd58 INT, T5COLd59 INT, T5COLd60 INT, T5COLd61 
INT, T5COLd62 INT, T5COLd63 INT, T5COLd64 INT, T5COLd65 INT, T5COLd66 DOUBLE, 
T5COLd67 DOUBLE, T5COLd68 DOUBLE, T5COLd69 DOUBLE, T5COLd70 DOUBLE, T5COLd71 
DOUBLE, T5COLd72 DOUBLE, T5COLd73 DOUBLE, T5COLd74 DOUBLE, T5COLd75 DOUBLE, 
T5COLd76 DOUBLE, T5COLd77 DOUBLE, T5COLd78 DOUBLE, T5COLd79 DOUBLE, T5COLd80 
DOUBLE, T5COLd81 DATE, T5COLd82 DATE, T5COLd83 DATE, T5COLd84 DATE, T5COLd85 
DATE, T5COLd86 DATE, T5COLd87 DATE, T5COLd88 DATE, T5COLd89 DATE, T5COLd90 
DATE, T5COLd91 TIMESTAMP, T5COLd92 TIMESTAMP, T5COLd93 TIMESTAMP, T5COLd94 
TIMESTAMP, T5COLd95 TIMESTAMP, T5COLd96 TIMESTAMP, T5COLd97 TIMESTAMP, T5COLd98 
TIMESTAMP, T5COLd99 TIMESTAMP, T5COLd100 TIMESTAMP, T5COLd101 TINYINT, 
T5COLd102 TINYINT, T5COLd103 TINYINT, T5COLd104 TINYINT, T5COLd105 TINYINT, T5C
 OLd106 TINYINT, T5COLd107 TINYINT, T5COLd108 TINYINT, T5COLd109 TINYINT, 
T5COLd110 TINYINT, T5COLd111 BIGINT, T5COLd112 BIGINT, T5COLd113 BIGINT, 
T5COLd114 BIGINT, T5COLd115 BIGINT, T5COLd116 BIGINT, T5COLd117 BIGINT, 
T5COLd118 BIGINT, T5COLd119 BIGINT, T5COLd120 BIGINT, T5COLd121 TEXT, T5COLd122 
TEXT, T5COLd123 TEXT, T5COLd124 TEXT, T5COLd125 TEXT, T5COLd126 TEXT, T5COLd127 
TEXT, T5COLd128 TEXT, T5COLd129 TEXT, T5COLd130 TEXT, T5COLd131 TINYINT, 
T5COLd132 TINYINT, T5COLd133 TINYINT, T5COLd134 TINYINT, T5COLd135 TINYINT, 
T5COLd136 TINYINT, T5COLd137 TINYINT, T5COLd138 TINYINT, T5COLd139 TINYINT, 
T5COLd140 TINYINT, T5COLd141 INT, T5COLd142 INT, T5COLd143 INT, T5COLd144 INT, 
T5COLd145 INT, T5COLd146 INT, T5COLd147 INT, T5COLd148 INT, T5COLd149 INT, 
T5COLd150 INT, T5LASTCOL TEXT, PRIMARY KEY(T5PKCOL));
+CREATE TABLE Table6 (T6PKCOL bigint, T6COLa1 TEXT, T6COLa2 TEXT, T6COLa3 TEXT, 
T6COLa4 TEXT, T6COLa5 TEXT, T6COLa6 TEXT, T6COLa7 TEXT, T6COLa8 TEXT, T6COLa9 
TEXT, T6COLa10 TEXT, T6COLa11 TEXT, T6COLa12 TEXT, T6COLa13 TEXT, T6COLa14 
TEXT, T6COLa15 TEXT, T6COLa16 TEXT, T6COLa17 TEXT, T6COLa18 TEXT, T6COLa19 
TEXT, T6COLa20 TEXT, T6COLa21 TEXT, T6COLa22 TEXT, T6COLa23 TEXT, T6COLa24 
TEXT, T6COLa25 TEXT, T6COLa26 TEXT, T6COLa27 TEXT, T6COLa28 TEXT, T6COLa29 
TEXT, T6COLa30 TEXT, T6COLa31 TEXT, T6COLa32 TEXT, T6COLa33 TEXT, T6COLa34 
TEXT, T6COLa35 TEXT, T6COLa36 TEXT, T6COLa37 TEXT, T6COLa38 TEXT, T6COLa39 
TEXT, T6COLa40 TEXT, T6COLa41 TEXT, T6COLa42 TEXT, T6COLa43 TEXT, T6COLa44 
TEXT, T6COLa45 TEXT, T6COLa46 TEXT, T6COLa47 TEXT, T6COLa48 TEXT, T6COLa49 
TEXT, T6COLa50 TEXT, T6COLa51 INT, T6COLa52 INT, T6COLa53 INT, T6COLa54 INT, 
T6COLa55 INT, T6COLa56 INT, T6COLa57 INT, T6COLa58 INT, T6COLa59 INT, T6COLa60 
INT, T6COLa61 INT, T6COLa62 INT, T6COLa63 INT, T6COLa64 INT, T6COLa65 INT, 
T6COLa66 
 DOUBLE, T6COLa67 DOUBLE, T6COLa68 DOUBLE, T6COLa69 DOUBLE, T6COLa70 DOUBLE, 
T6COLa71 DOUBLE, T6COLa72 DOUBLE, T6COLa73 DOUBLE, T6COLa74 DOUBLE, T6COLa75 
DOUBLE, T6COLa76 DOUBLE, T6COLa77 DOUBLE, T6COLa78 DOUBLE, T6COLa79 DOUBLE, 
T6COLa80 DOUBLE, T6COLa81 DATE, T6COLa82 DATE, T6COLa83 DATE, T6COLa84 DATE, 
T6COLa85 DATE, T6COLa86 DATE, T6COLa87 DATE, T6COLa88 DATE, T6COLa89 DATE, 
T6COLa90 DATE, T6COLa91 TIMESTAMP, T6COLa92 TIMESTAMP, T6COLa93 TIMESTAMP, 
T6COLa94 TIMESTAMP, T6COLa95 TIMESTAMP, T6COLa96 TIMESTAMP, T6COLa97 TIMESTAMP, 
T6COLa98 TIMESTAMP, T6COLa99 TIMESTAMP, T6COLa100 TIMESTAMP, T6COLa101 TINYINT, 
T6COLa102 TINYINT, T6COLa103 TINYINT, T6COLa104 TINYINT, T6COLa105 TINYINT, 
T6COLa106 TINYINT, T6COLa107 TINYINT, T6COLa108 TINYINT, T6COLa109 TINYINT, 
T6COLa110 TINYINT, T6COLa111 BIGINT, T6COLa112 BIGINT, T6COLa113 BIGINT, 
T6COLa114 BIGINT, T6COLa115 BIGINT, T6COLa116 BIGINT, T6COLa117 BIGINT, 
T6COLa118 BIGINT, T6COLa119 BIGINT, T6COLa120 BIGINT, T6COLa121 TEXT, T6COLa122 
TEXT
 , T6COLa123 TEXT, T6COLa124 TEXT, T6COLa125 TEXT, T6COLa126 TEXT, T6COLa127 
TEXT, T6COLa128 TEXT, T6COLa129 TEXT, T6COLa130 TEXT, T6COLa131 TINYINT, 
T6COLa132 TINYINT, T6COLa133 TINYINT, T6COLa134 TINYINT, T6COLa135 TINYINT, 
T6COLa136 TINYINT, T6COLa137 TINYINT, T6COLa138 TINYINT, T6COLa139 TINYINT, 
T6COLa140 TINYINT, T6COLa141 INT, T6COLa142 INT, T6COLa143 INT, T6COLa144 INT, 
T6COLa145 INT, T6COLa146 INT, T6COLa147 INT, T6COLa148 INT, T6COLa149 INT, 
T6COLa150 INT, T6COLb1 TEXT, T6COLb2 TEXT, T6COLb3 TEXT, T6COLb4 TEXT, T6COLb5 
TEXT, T6COLb6 TEXT, T6COLb7 TEXT, T6COLb8 TEXT, T6COLb9 TEXT, T6COLb10 TEXT, 
T6COLb11 TEXT, T6COLb12 TEXT, T6COLb13 TEXT, T6COLb14 TEXT, T6COLb15 TEXT, 
T6COLb16 TEXT, T6COLb17 TEXT, T6COLb18 TEXT, T6COLb19 TEXT, T6COLb20 TEXT, 
T6COLb21 TEXT, T6COLb22 TEXT, T6COLb23 TEXT, T6COLb24 TEXT, T6COLb25 TEXT, 
T6COLb26 TEXT, T6COLb27 TEXT, T6COLb28 TEXT, T6COLb29 TEXT, T6COLb30 TEXT, 
T6COLb31 TEXT, T6COLb32 TEXT, T6COLb33 TEXT, T6COLb34 TEXT, T6COLb35 TEXT, 
T6COLb36 TE
 XT, T6COLb37 TEXT, T6COLb38 TEXT, T6COLb39 TEXT, T6COLb40 TEXT, T6COLb41 TEXT, 
T6COLb42 TEXT, T6COLb43 TEXT, T6COLb44 TEXT, T6COLb45 TEXT, T6COLb46 TEXT, 
T6COLb47 TEXT, T6COLb48 TEXT, T6COLb49 TEXT, T6COLb50 TEXT, T6COLb51 INT, 
T6COLb52 INT, T6COLb53 INT, T6COLb54 INT, T6COLb55 INT, T6COLb56 INT, T6COLb57 
INT, T6COLb58 INT, T6COLb59 INT, T6COLb60 INT, T6COLb61 INT, T6COLb62 INT, 
T6COLb63 INT, T6COLb64 INT, T6COLb65 INT, T6COLb66 DOUBLE, T6COLb67 DOUBLE, 
T6COLb68 DOUBLE, T6COLb69 DOUBLE, T6COLb70 DOUBLE, T6COLb71 DOUBLE, T6COLb72 
DOUBLE, T6COLb73 DOUBLE, T6COLb74 DOUBLE, T6COLb75 DOUBLE, T6COLb76 DOUBLE, 
T6COLb77 DOUBLE, T6COLb78 DOUBLE, T6COLb79 DOUBLE, T6COLb80 DOUBLE, T6COLb81 
DATE, T6COLb82 DATE, T6COLb83 DATE, T6COLb84 DATE, T6COLb85 DATE, T6COLb86 
DATE, T6COLb87 DATE, T6COLb88 DATE, T6COLb89 DATE, T6COLb90 DATE, T6COLb91 
TIMESTAMP, T6COLb92 TIMESTAMP, T6COLb93 TIMESTAMP, T6COLb94 TIMESTAMP, T6COLb95 
TIMESTAMP, T6COLb96 TIMESTAMP, T6COLb97 TIMESTAMP, T6COLb98 TIMESTAMP, T6COLb99
  TIMESTAMP, T6COLb100 TIMESTAMP, T6COLb101 TINYINT, T6COLb102 TINYINT, 
T6COLb103 TINYINT, T6COLb104 TINYINT, T6COLb105 TINYINT, T6COLb106 TINYINT, 
T6COLb107 TINYINT, T6COLb108 TINYINT, T6COLb109 TINYINT, T6COLb110 TINYINT, 
T6COLb111 BIGINT, T6COLb112 BIGINT, T6COLb113 BIGINT, T6COLb114 BIGINT, 
T6COLb115 BIGINT, T6COLb116 BIGINT, T6COLb117 BIGINT, T6COLb118 BIGINT, 
T6COLb119 BIGINT, T6COLb120 BIGINT, T6COLb121 TEXT, T6COLb122 TEXT, T6COLb123 
TEXT, T6COLb124 TEXT, T6COLb125 TEXT, T6COLb126 TEXT, T6COLb127 TEXT, T6COLb128 
TEXT, T6COLb129 TEXT, T6COLb130 TEXT, T6COLb131 TINYINT, T6COLb132 TINYINT, 
T6COLb133 TINYINT, T6COLb134 TINYINT, T6COLb135 TINYINT, T6COLb136 TINYINT, 
T6COLb137 TINYINT, T6COLb138 TINYINT, T6COLb139 TINYINT, T6COLb140 TINYINT, 
T6COLb141 INT, T6COLb142 INT, T6COLb143 INT, T6COLb144 INT, T6COLb145 INT, 
T6COLb146 INT, T6COLb147 INT, T6COLb148 INT, T6COLb149 INT, T6COLb150 INT, 
T6COLc1 TEXT, T6COLc2 TEXT, T6COLc3 TEXT, T6COLc4 TEXT, T6COLc5 TEXT, T6COLc6 
TEXT, T6COLc7 TE
 XT, T6COLc8 TEXT, T6COLc9 TEXT, T6COLc10 TEXT, T6COLc11 TEXT, T6COLc12 TEXT, 
T6COLc13 TEXT, T6COLc14 TEXT, T6COLc15 TEXT, T6COLc16 TEXT, T6COLc17 TEXT, 
T6COLc18 TEXT, T6COLc19 TEXT, T6COLc20 TEXT, T6COLc21 TEXT, T6COLc22 TEXT, 
T6COLc23 TEXT, T6COLc24 TEXT, T6COLc25 TEXT, T6COLc26 TEXT, T6COLc27 TEXT, 
T6COLc28 TEXT, T6COLc29 TEXT, T6COLc30 TEXT, T6COLc31 TEXT, T6COLc32 TEXT, 
T6COLc33 TEXT, T6COLc34 TEXT, T6COLc35 TEXT, T6COLc36 TEXT, T6COLc37 TEXT, 
T6COLc38 TEXT, T6COLc39 TEXT, T6COLc40 TEXT, T6COLc41 TEXT, T6COLc42 TEXT, 
T6COLc43 TEXT, T6COLc44 TEXT, T6COLc45 TEXT, T6COLc46 TEXT, T6COLc47 TEXT, 
T6COLc48 TEXT, T6COLc49 TEXT, T6COLc50 TEXT, T6COLc51 INT, T6COLc52 INT, 
T6COLc53 INT, T6COLc54 INT, T6COLc55 INT, T6COLc56 INT, T6COLc57 INT, T6COLc58 
INT, T6COLc59 INT, T6COLc60 INT, T6COLc61 INT, T6COLc62 INT, T6COLc63 INT, 
T6COLc64 INT, T6COLc65 INT, T6COLc66 DOUBLE, T6COLc67 DOUBLE, T6COLc68 DOUBLE, 
T6COLc69 DOUBLE, T6COLc70 DOUBLE, T6COLc71 DOUBLE, T6COLc72 DOUBLE, T6COLc73 
DOUBLE, T6CO
 Lc74 DOUBLE, T6COLc75 DOUBLE, T6COLc76 DOUBLE, T6COLc77 DOUBLE, T6COLc78 
DOUBLE, T6COLc79 DOUBLE, T6COLc80 DOUBLE, T6COLc81 DATE, T6COLc82 DATE, 
T6COLc83 DATE, T6COLc84 DATE, T6COLc85 DATE, T6COLc86 DATE, T6COLc87 DATE, 
T6COLc88 DATE, T6COLc89 DATE, T6COLc90 DATE, T6COLc91 TIMESTAMP, T6COLc92 
TIMESTAMP, T6COLc93 TIMESTAMP, T6COLc94 TIMESTAMP, T6COLc95 TIMESTAMP, T6COLc96 
TIMESTAMP, T6COLc97 TIMESTAMP, T6COLc98 TIMESTAMP, T6COLc99 TIMESTAMP, 
T6COLc100 TIMESTAMP, T6COLc101 TINYINT, T6COLc102 TINYINT, T6COLc103 TINYINT, 
T6COLc104 TINYINT, T6COLc105 TINYINT, T6COLc106 TINYINT, T6COLc107 TINYINT, 
T6COLc108 TINYINT, T6COLc109 TINYINT, T6COLc110 TINYINT, T6COLc111 BIGINT, 
T6COLc112 BIGINT, T6COLc113 BIGINT, T6COLc114 BIGINT, T6COLc115 BIGINT, 
T6COLc116 BIGINT, T6COLc117 BIGINT, T6COLc118 BIGINT, T6COLc119 BIGINT, 
T6COLc120 BIGINT, T6COLc121 TEXT, T6COLc122 TEXT, T6COLc123 TEXT, T6COLc124 
TEXT, T6COLc125 TEXT, T6COLc126 TEXT, T6COLc127 TEXT, T6COLc128 TEXT, T6COLc129 
TEXT, T6COLc130 TEXT, T
 6COLc131 TINYINT, T6COLc132 TINYINT, T6COLc133 TINYINT, T6COLc134 TINYINT, 
T6COLc135 TINYINT, T6COLc136 TINYINT, T6COLc137 TINYINT, T6COLc138 TINYINT, 
T6COLc139 TINYINT, T6COLc140 TINYINT, T6COLc141 INT, T6COLc142 INT, T6COLc143 
INT, T6COLc144 INT, T6COLc145 INT, T6COLc146 INT, T6COLc147 INT, T6COLc148 INT, 
T6COLc149 INT, T6COLc150 INT, T6COLd1 TEXT, T6COLd2 TEXT, T6COLd3 TEXT, T6COLd4 
TEXT, T6COLd5 TEXT, T6COLd6 TEXT, T6COLd7 TEXT, T6COLd8 TEXT, T6COLd9 TEXT, 
T6COLd10 TEXT, T6COLd11 TEXT, T6COLd12 TEXT, T6COLd13 TEXT, T6COLd14 TEXT, 
T6COLd15 TEXT, T6COLd16 TEXT, T6COLd17 TEXT, T6COLd18 TEXT, T6COLd19 TEXT, 
T6COLd20 TEXT, T6COLd21 TEXT, T6COLd22 TEXT, T6COLd23 TEXT, T6COLd24 TEXT, 
T6COLd25 TEXT, T6COLd26 TEXT, T6COLd27 TEXT, T6COLd28 TEXT, T6COLd29 TEXT, 
T6COLd30 TEXT, T6COLd31 TEXT, T6COLd32 TEXT, T6COLd33 TEXT, T6COLd34 TEXT, 
T6COLd35 TEXT, T6COLd36 TEXT, T6COLd37 TEXT, T6COLd38 TEXT, T6COLd39 TEXT, 
T6COLd40 TEXT, T6COLd41 TEXT, T6COLd42 TEXT, T6COLd43 TEXT, T6COLd44 TEXT, 
T6COLd4
 5 TEXT, T6COLd46 TEXT, T6COLd47 TEXT, T6COLd48 TEXT, T6COLd49 TEXT, T6COLd50 
TEXT, T6COLd51 INT, T6COLd52 INT, T6COLd53 INT, T6COLd54 INT, T6COLd55 INT, 
T6COLd56 INT, T6COLd57 INT, T6COLd58 INT, T6COLd59 INT, T6COLd60 INT, T6COLd61 
INT, T6COLd62 INT, T6COLd63 INT, T6COLd64 INT, T6COLd65 INT, T6COLd66 DOUBLE, 
T6COLd67 DOUBLE, T6COLd68 DOUBLE, T6COLd69 DOUBLE, T6COLd70 DOUBLE, T6COLd71 
DOUBLE, T6COLd72 DOUBLE, T6COLd73 DOUBLE, T6COLd74 DOUBLE, T6COLd75 DOUBLE, 
T6COLd76 DOUBLE, T6COLd77 DOUBLE, T6COLd78 DOUBLE, T6COLd79 DOUBLE, T6COLd80 
DOUBLE, T6COLd81 DATE, T6COLd82 DATE, T6COLd83 DATE, T6COLd84 DATE, T6COLd85 
DATE, T6COLd86 DATE, T6COLd87 DATE, T6COLd88 DATE, T6COLd89 DATE, T6COLd90 
DATE, T6COLd91 TIMESTAMP, T6COLd92 TIMESTAMP, T6COLd93 TIMESTAMP, T6COLd94 
TIMESTAMP, T6COLd95 TIMESTAMP, T6COLd96 TIMESTAMP, T6COLd97 TIMESTAMP, T6COLd98 
TIMESTAMP, T6COLd99 TIMESTAMP, T6COLd100 TIMESTAMP, T6COLd101 TINYINT, 
T6COLd102 TINYINT, T6COLd103 TINYINT, T6COLd104 TINYINT, T6COLd105 TINYINT, T6C
 OLd106 TINYINT, T6COLd107 TINYINT, T6COLd108 TINYINT, T6COLd109 TINYINT, 
T6COLd110 TINYINT, T6COLd111 BIGINT, T6COLd112 BIGINT, T6COLd113 BIGINT, 
T6COLd114 BIGINT, T6COLd115 BIGINT, T6COLd116 BIGINT, T6COLd117 BIGINT, 
T6COLd118 BIGINT, T6COLd119 BIGINT, T6COLd120 BIGINT, T6COLd121 TEXT, T6COLd122 
TEXT, T6COLd123 TEXT, T6COLd124 TEXT, T6COLd125 TEXT, T6COLd126 TEXT, T6COLd127 
TEXT, T6COLd128 TEXT, T6COLd129 TEXT, T6COLd130 TEXT, T6COLd131 TINYINT, 
T6COLd132 TINYINT, T6COLd133 TINYINT, T6COLd134 TINYINT, T6COLd135 TINYINT, 
T6COLd136 TINYINT, T6COLd137 TINYINT, T6COLd138 TINYINT, T6COLd139 TINYINT, 
T6COLd140 TINYINT, T6COLd141 INT, T6COLd142 INT, T6COLd143 INT, T6COLd144 INT, 
T6COLd145 INT, T6COLd146 INT, T6COLd147 INT, T6COLd148 INT, T6COLd149 INT, 
T6COLd150 INT, T6LASTCOL TEXT, PRIMARY KEY(T6PKCOL));
+CREATE TABLE Table7 (T7PKCOL bigint, T7COLa1 TEXT, T7COLa2 TEXT, T7COLa3 TEXT, 
T7COLa4 TEXT, T7COLa5 TEXT, T7COLa6 TEXT, T7COLa7 TEXT, T7COLa8 TEXT, T7COLa9 
TEXT, T7COLa10 TEXT, T7COLa11 TEXT, T7COLa12 TEXT, T7COLa13 TEXT, T7COLa14 
TEXT, T7COLa15 TEXT, T7COLa16 TEXT, T7COLa17 TEXT, T7COLa18 TEXT, T7COLa19 
TEXT, T7COLa20 TEXT, T7COLa21 TEXT, T7COLa22 TEXT, T7COLa23 TEXT, T7COLa24 
TEXT, T7COLa25 TEXT, T7COLa26 TEXT, T7COLa27 TEXT, T7COLa28 TEXT, T7COLa29 
TEXT, T7COLa30 TEXT, T7COLa31 TEXT, T7COLa32 TEXT, T7COLa33 TEXT, T7COLa34 
TEXT, T7COLa35 TEXT, T7COLa36 TEXT, T7COLa37 TEXT, T7COLa38 TEXT, T7COLa39 
TEXT, T7COLa40 TEXT, T7COLa41 TEXT, T7COLa42 TEXT, T7COLa43 TEXT, T7COLa44 
TEXT, T7COLa45 TEXT, T7COLa46 TEXT, T7COLa47 TEXT, T7COLa48 TEXT, T7COLa49 
TEXT, T7COLa50 TEXT, T7COLa51 INT, T7COLa52 INT, T7COLa53 INT, T7COLa54 INT, 
T7COLa55 INT, T7COLa56 INT, T7COLa57 INT, T7COLa58 INT, T7COLa59 INT, T7COLa60 
INT, T7COLa61 INT, T7COLa62 INT, T7COLa63 INT, T7COLa64 INT, T7COLa65 INT, 
T7COLa66 
 DOUBLE, T7COLa67 DOUBLE, T7COLa68 DOUBLE, T7COLa69 DOUBLE, T7COLa70 DOUBLE, 
T7COLa71 DOUBLE, T7COLa72 DOUBLE, T7COLa73 DOUBLE, T7COLa74 DOUBLE, T7COLa75 
DOUBLE, T7COLa76 DOUBLE, T7COLa77 DOUBLE, T7COLa78 DOUBLE, T7COLa79 DOUBLE, 
T7COLa80 DOUBLE, T7COLa81 DATE, T7COLa82 DATE, T7COLa83 DATE, T7COLa84 DATE, 
T7COLa85 DATE, T7COLa86 DATE, T7COLa87 DATE, T7COLa88 DATE, T7COLa89 DATE, 
T7COLa90 DATE, T7COLa91 TIMESTAMP, T7COLa92 TIMESTAMP, T7COLa93 TIMESTAMP, 
T7COLa94 TIMESTAMP, T7COLa95 TIMESTAMP, T7COLa96 TIMESTAMP, T7COLa97 TIMESTAMP, 
T7COLa98 TIMESTAMP, T7COLa99 TIMESTAMP, T7COLa100 TIMESTAMP, T7COLa101 TINYINT, 
T7COLa102 TINYINT, T7COLa103 TINYINT, T7COLa104 TINYINT, T7COLa105 TINYINT, 
T7COLa106 TINYINT, T7COLa107 TINYINT, T7COLa108 TINYINT, T7COLa109 TINYINT, 
T7COLa110 TINYINT, T7COLa111 BIGINT, T7COLa112 BIGINT, T7COLa113 BIGINT, 
T7COLa114 BIGINT, T7COLa115 BIGINT, T7COLa116 BIGINT, T7COLa117 BIGINT, 
T7COLa118 BIGINT, T7COLa119 BIGINT, T7COLa120 BIGINT, T7COLa121 TEXT, T7COLa122 
TEXT
 , T7COLa123 TEXT, T7COLa124 TEXT, T7COLa125 TEXT, T7COLa126 TEXT, T7COLa127 
TEXT, T7COLa128 TEXT, T7COLa129 TEXT, T7COLa130 TEXT, T7COLa131 TINYINT, 
T7COLa132 TINYINT, T7COLa133 TINYINT, T7COLa134 TINYINT, T7COLa135 TINYINT, 
T7COLa136 TINYINT, T7COLa137 TINYINT, T7COLa138 TINYINT, T7COLa139 TINYINT, 
T7COLa140 TINYINT, T7COLa141 INT, T7COLa142 INT, T7COLa143 INT, T7COLa144 INT, 
T7COLa145 INT, T7COLa146 INT, T7COLa147 INT, T7COLa148 INT, T7COLa149 INT, 
T7COLa150 INT, T7COLb1 TEXT, T7COLb2 TEXT, T7COLb3 TEXT, T7COLb4 TEXT, T7COLb5 
TEXT, T7COLb6 TEXT, T7COLb7 TEXT, T7COLb8 TEXT, T7COLb9 TEXT, T7COLb10 TEXT, 
T7COLb11 TEXT, T7COLb12 TEXT, T7COLb13 TEXT, T7COLb14 TEXT, T7COLb15 TEXT, 
T7COLb16 TEXT, T7COLb17 TEXT, T7COLb18 TEXT, T7COLb19 TEXT, T7COLb20 TEXT, 
T7COLb21 TEXT, T7COLb22 TEXT, T7COLb23 TEXT, T7COLb24 TEXT, T7COLb25 TEXT, 
T7COLb26 TEXT, T7COLb27 TEXT, T7COLb28 TEXT, T7COLb29 TEXT, T7COLb30 TEXT, 
T7COLb31 TEXT, T7COLb32 TEXT, T7COLb33 TEXT, T7COLb34 TEXT, T7COLb35 TEXT, 
T7COLb36 TE
 XT, T7COLb37 TEXT, T7COLb38 TEXT, T7COLb39 TEXT, T7COLb40 TEXT, T7COLb41 TEXT, 
T7COLb42 TEXT, T7COLb43 TEXT, T7COLb44 TEXT, T7COLb45 TEXT, T7COLb46 TEXT, 
T7COLb47 TEXT, T7COLb48 TEXT, T7COLb49 TEXT, T7COLb50 TEXT, T7COLb51 INT, 
T7COLb52 INT, T7COLb53 INT, T7COLb54 INT, T7COLb55 INT, T7COLb56 INT, T7COLb57 
INT, T7COLb58 INT, T7COLb59 INT, T7COLb60 INT, T7COLb61 INT, T7COLb62 INT, 
T7COLb63 INT, T7COLb64 INT, T7COLb65 INT, T7COLb66 DOUBLE, T7COLb67 DOUBLE, 
T7COLb68 DOUBLE, T7COLb69 DOUBLE, T7COLb70 DOUBLE, T7COLb71 DOUBLE, T7COLb72 
DOUBLE, T7COLb73 DOUBLE, T7COLb74 DOUBLE, T7COLb75 DOUBLE, T7COLb76 DOUBLE, 
T7COLb77 DOUBLE, T7COLb78 DOUBLE, T7COLb79 DOUBLE, T7COLb80 DOUBLE, T7COLb81 
DATE, T7COLb82 DATE, T7COLb83 DATE, T7COLb84 DATE, T7COLb85 DATE, T7COLb86 
DATE, T7COLb87 DATE, T7COLb88 DATE, T7COLb89 DATE, T7COLb90 DATE, T7COLb91 
TIMESTAMP, T7COLb92 TIMESTAMP, T7COLb93 TIMESTAMP, T7COLb94 TIMESTAMP, T7COLb95 
TIMESTAMP, T7COLb96 TIMESTAMP, T7COLb97 TIMESTAMP, T7COLb98 TIMESTAMP, T7COLb99
  TIMESTAMP, T7COLb100 TIMESTAMP, T7COLb101 TINYINT, T7COLb102 TINYINT, 
T7COLb103 TINYINT, T7COLb104 TINYINT, T7COLb105 TINYINT, T7COLb106 TINYINT, 
T7COLb107 TINYINT, T7COLb108 TINYINT, T7COLb109 TINYINT, T7COLb110 TINYINT, 
T7COLb111 BIGINT, T7COLb112 BIGINT, T7COLb113 BIGINT, T7COLb114 BIGINT, 
T7COLb115 BIGINT, T7COLb116 BIGINT, T7COLb117 BIGINT, T7COLb118 BIGINT, 
T7COLb119 BIGINT, T7COLb120 BIGINT, T7COLb121 TEXT, T7COLb122 TEXT, T7COLb123 
TEXT, T7COLb124 TEXT, T7COLb125 TEXT, T7COLb126 TEXT, T7COLb127 TEXT, T7COLb128 
TEXT, T7COLb129 TEXT, T7COLb130 TEXT, T7COLb131 TINYINT, T7COLb132 TINYINT, 
T7COLb133 TINYINT, T7COLb134 TINYINT, T7COLb135 TINYINT, T7COLb136 TINYINT, 
T7COLb137 TINYINT, T7COLb138 TINYINT, T7COLb139 TINYINT, T7COLb140 TINYINT, 
T7COLb141 INT, T7COLb142 INT, T7COLb143 INT, T7COLb144 INT, T7COLb145 INT, 
T7COLb146 INT, T7COLb147 INT, T7COLb148 INT, T7COLb149 INT, T7COLb150 INT, 
T7COLc1 TEXT, T7COLc2 TEXT, T7COLc3 TEXT, T7COLc4 TEXT, T7COLc5 TEXT, T7COLc6 
TEXT, T7COLc7 TE
 XT, T7COLc8 TEXT, T7COLc9 TEXT, T7COLc10 TEXT, T7COLc11 TEXT, T7COLc12 TEXT, 
T7COLc13 TEXT, T7COLc14 TEXT, T7COLc15 TEXT, T7COLc16 TEXT, T7COLc17 TEXT, 
T7COLc18 TEXT, T7COLc19 TEXT, T7COLc20 TEXT, T7COLc21 TEXT, T7COLc22 TEXT, 
T7COLc23 TEXT, T7COLc24 TEXT, T7COLc25 TEXT, T7COLc26 TEXT, T7COLc27 TEXT, 
T7COLc28 TEXT, T7COLc29 TEXT, T7COLc30 TEXT, T7COLc31 TEXT, T7COLc32 TEXT, 
T7COLc33 TEXT, T7COLc34 TEXT, T7COLc35 TEXT, T7COLc36 TEXT, T7COLc37 TEXT, 
T7COLc38 TEXT, T7COLc39 TEXT, T7COLc40 TEXT, T7COLc41 TEXT, T7COLc42 TEXT, 
T7COLc43 TEXT, T7COLc44 TEXT, T7COLc45 TEXT, T7COLc46 TEXT, T7COLc47 TEXT, 
T7COLc48 TEXT, T7COLc49 TEXT, T7COLc50 TEXT, T7COLc51 INT, T7COLc52 INT, 
T7COLc53 INT, T7COLc54 INT, T7COLc55 INT, T7COLc56 INT, T7COLc57 INT, T7COLc58 
INT, T7COLc59 INT, T7COLc60 INT, T7COLc61 INT, T7COLc62 INT, T7COLc63 INT, 
T7COLc64 INT, T7COLc65 INT, T7COLc66 DOUBLE, T7COLc67 DOUBLE, T7COLc68 DOUBLE, 
T7COLc69 DOUBLE, T7COLc70 DOUBLE, T7COLc71 DOUBLE, T7COLc72 DOUBLE, T7COLc73 
DOUBLE, T7CO
 Lc74 DOUBLE, T7COLc75 DOUBLE, T7COLc76 DOUBLE, T7COLc77 DOUBLE, T7COLc78 
DOUBLE, T7COLc79 DOUBLE, T7COLc80 DOUBLE, T7COLc81 DATE, T7COLc82 DATE, 
T7COLc83 DATE, T7COLc84 DATE, T7COLc85 DATE, T7COLc86 DATE, T7COLc87 DATE, 
T7COLc88 DATE, T7COLc89 DATE, T7COLc90 DATE, T7COLc91 TIMESTAMP, T7COLc92 
TIMESTAMP, T7COLc93 TIMESTAMP, T7COLc94 TIMESTAMP, T7COLc95 TIMESTAMP, T7COLc96 
TIMESTAMP, T7COLc97 TIMESTAMP, T7COLc98 TIMESTAMP, T7COLc99 TIMESTAMP, 
T7COLc100 TIMESTAMP, T7COLc101 TINYINT, T7COLc102 TINYINT, T7COLc103 TINYINT, 
T7COLc104 TINYINT, T7COLc105 TINYINT, T7COLc106 TINYINT, T7COLc107 TINYINT, 
T7COLc108 TINYINT, T7COLc109 TINYINT, T7COLc110 TINYINT, T7COLc111 BIGINT, 
T7COLc112 BIGINT, T7COLc113 BIGINT, T7COLc114 BIGINT, T7COLc115 BIGINT, 
T7COLc116 BIGINT, T7COLc117 BIGINT, T7COLc118 BIGINT, T7COLc119 BIGINT, 
T7COLc120 BIGINT, T7COLc121 TEXT, T7COLc122 TEXT, T7COLc123 TEXT, T7COLc124 
TEXT, T7COLc125 TEXT, T7COLc126 TEXT, T7COLc127 TEXT, T7COLc128 TEXT, T7COLc129 
TEXT, T7COLc130 TEXT, T
 7COLc131 TINYINT, T7COLc132 TINYINT, T7COLc133 TINYINT, T7COLc134 TINYINT, 
T7COLc135 TINYINT, T7COLc136 TINYINT, T7COLc137 TINYINT, T7COLc138 TINYINT, 
T7COLc139 TINYINT, T7COLc140 TINYINT, T7COLc141 INT, T7COLc142 INT, T7COLc143 
INT, T7COLc144 INT, T7COLc145 INT, T7COLc146 INT, T7COLc147 INT, T7COLc148 INT, 
T7COLc149 INT, T7COLc150 INT, T7COLd1 TEXT, T7COLd2 TEXT, T7COLd3 TEXT, T7COLd4 
TEXT, T7COLd5 TEXT, T7COLd6 TEXT, T7COLd7 TEXT, T7COLd8 TEXT, T7COLd9 TEXT, 
T7COLd10 TEXT, T7COLd11 TEXT, T7COLd12 TEXT, T7COLd13 TEXT, T7COLd14 TEXT, 
T7COLd15 TEXT, T7COLd16 TEXT, T7COLd17 TEXT, T7COLd18 TEXT, T7COLd19 TEXT, 
T7COLd20 TEXT, T7COLd21 TEXT, T7COLd22 TEXT, T7COLd23 TEXT, T7COLd24 TEXT, 
T7COLd25 TEXT, T7COLd26 TEXT, T7COLd27 TEXT, T7COLd28 TEXT, T7COLd29 TEXT, 
T7COLd30 TEXT, T7COLd31 TEXT, T7COLd32 TEXT, T7COLd33 TEXT, T7COLd34 TEXT, 
T7COLd35 TEXT, T7COLd36 TEXT, T7COLd37 TEXT, T7COLd38 TEXT, T7COLd39 TEXT, 
T7COLd40 TEXT, T7COLd41 TEXT, T7COLd42 TEXT, T7COLd43 TEXT, T7COLd44 TEXT, 
T7COLd4
 5 TEXT, T7COLd46 TEXT, T7COLd47 TEXT, T7COLd48 TEXT, T7COLd49 TEXT, T7COLd50 
TEXT, T7COLd51 INT, T7COLd52 INT, T7COLd53 INT, T7COLd54 INT, T7COLd55 INT, 
T7COLd56 INT, T7COLd57 INT, T7COLd58 INT, T7COLd59 INT, T7COLd60 INT, T7COLd61 
INT, T7COLd62 INT, T7COLd63 INT, T7COLd64 INT, T7COLd65 INT, T7COLd66 DOUBLE, 
T7COLd67 DOUBLE, T7COLd68 DOUBLE, T7COLd69 DOUBLE, T7COLd70 DOUBLE, T7COLd71 
DOUBLE, T7COLd72 DOUBLE, T7COLd73 DOUBLE, T7COLd74 DOUBLE, T7COLd75 DOUBLE, 
T7COLd76 DOUBLE, T7COLd77 DOUBLE, T7COLd78 DOUBLE, T7COLd79 DOUBLE, T7COLd80 
DOUBLE, T7COLd81 DATE, T7COLd82 DATE, T7COLd83 DATE, T7COLd84 DATE, T7COLd85 
DATE, T7COLd86 DATE, T7COLd87 DATE, T7COLd88 DATE, T7COLd89 DATE, T7COLd90 
DATE, T7COLd91 TIMESTAMP, T7COLd92 TIMESTAMP, T7COLd93 TIMESTAMP, T7COLd94 
TIMESTAMP, T7COLd95 TIMESTAMP, T7COLd96 TIMESTAMP, T7COLd97 TIMESTAMP, T7COLd98 
TIMESTAMP, T7COLd99 TIMESTAMP, T7COLd100 TIMESTAMP, T7COLd101 TINYINT, 
T7COLd102 TINYINT, T7COLd103 TINYINT, T7COLd104 TINYINT, T7COLd105 TINYINT, T7C
 OLd106 TINYINT, T7COLd107 TINYINT, T7COLd108 TINYINT, T7COLd109 TINYINT, 
T7COLd110 TINYINT, T7COLd111 BIGINT, T7COLd112 BIGINT, T7COLd113 BIGINT, 
T7COLd114 BIGINT, T7COLd115 BIGINT, T7COLd116 BIGINT, T7COLd117 BIGINT, 
T7COLd118 BIGINT, T7COLd119 BIGINT, T7COLd120 BIGINT, T7COLd121 TEXT, T7COLd122 
TEXT, T7COLd123 TEXT, T7COLd124 TEXT, T7COLd125 TEXT, T7COLd126 TEXT, T7COLd127 
TEXT, T7COLd128 TEXT, T7COLd129 TEXT, T7COLd130 TEXT, T7COLd131 TINYINT, 
T7COLd132 TINYINT, T7COLd133 TINYINT, T7COLd134 TINYINT, T7COLd135 TINYINT, 
T7COLd136 TINYINT, T7COLd137 TINYINT, T7COLd138 TINYINT, T7COLd139 TINYINT, 
T7COLd140 TINYINT, T7COLd141 INT, T7COLd142 INT, T7COLd143 INT, T7COLd144 INT, 
T7COLd145 INT, T7COLd146 INT, T7COLd147 INT, T7COLd148 INT, T7COLd149 INT, 
T7COLd150 INT, T7LASTCOL TEXT, PRIMARY KEY(T7PKCOL));
+CREATE TABLE Table8 (T8PKCOL bigint, T8COLa1 TEXT, T8COLa2 TEXT, T8COLa3 TEXT, 
T8COLa4 TEXT, T8COLa5 TEXT, T8COLa6 TEXT, T8COLa7 TEXT, T8COLa8 TEXT, T8COLa9 
TEXT, T8COLa10 TEXT, T8COLa11 TEXT, T8COLa12 TEXT, T8COLa13 TEXT, T8COLa14 
TEXT, T8COLa15 TEXT, T8COLa16 TEXT, T8COLa17 TEXT, T8COLa18 TEXT, T8COLa19 
TEXT, T8COLa20 TEXT, T8COLa21 TEXT, T8COLa22 TEXT, T8COLa23 TEXT, T8COLa24 
TEXT, T8COLa25 TEXT, T8COLa26 TEXT, T8COLa27 TEXT, T8COLa28 TEXT, T8COLa29 
TEXT, T8COLa30 TEXT, T8COLa31 TEXT, T8COLa32 TEXT, T8COLa33 TEXT, T8COLa34 
TEXT, T8COLa35 TEXT, T8COLa36 TEXT, T8COLa37 TEXT, T8COLa38 TEXT, T8COLa39 
TEXT, T8COLa40 TEXT, T8COLa41 TEXT, T8COLa42 TEXT, T8COLa43 TEXT, T8COLa44 
TEXT, T8COLa45 TEXT, T8COLa46 TEXT, T8COLa47 TEXT, T8COLa48 TEXT, T8COLa49 
TEXT, T8COLa50 TEXT, T8COLa51 INT, T8COLa52 INT, T8COLa53 INT, T8COLa54 INT, 
T8COLa55 INT, T8COLa56 INT, T8COLa57 INT, T8COLa58 INT, T8COLa59 INT, T8COLa60 
INT, T8COLa61 INT, T8COLa62 INT, T8COLa63 INT, T8COLa64 INT, T8COLa65 INT, 
T8COLa66 
 DOUBLE, T8COLa67 DOUBLE, T8COLa68 DOUBLE, T8COLa69 DOUBLE, T8COLa70 DOUBLE, 
T8COLa71 DOUBLE, T8COLa72 DOUBLE, T8COLa73 DOUBLE, T8COLa74 DOUBLE, T8COLa75 
DOUBLE, T8COLa76 DOUBLE, T8COLa77 DOUBLE, T8COLa78 DOUBLE, T8COLa79 DOUBLE, 
T8COLa80 DOUBLE, T8COLa81 DATE, T8COLa82 DATE, T8COLa83 DATE, T8COLa84 DATE, 
T8COLa85 DATE, T8COLa86 DATE, T8COLa87 DATE, T8COLa88 DATE, T8COLa89 DATE, 
T8COLa90 DATE, T8COLa91 TIMESTAMP, T8COLa92 TIMESTAMP, T8COLa93 TIMESTAMP, 
T8COLa94 TIMESTAMP, T8COLa95 TIMESTAMP, T8COLa96 TIMESTAMP, T8COLa97 TIMESTAMP, 
T8COLa98 TIMESTAMP, T8COLa99 TIMESTAMP, T8COLa100 TIMESTAMP, T8COLa101 TINYINT, 
T8COLa102 TINYINT, T8COLa103 TINYINT, T8COLa104 TINYINT, T8COLa105 TINYINT, 
T8COLa106 TINYINT, T8COLa107 TINYINT, T8COLa108 TINYINT, T8COLa109 TINYINT, 
T8COLa110 TINYINT, T8COLa111 BIGINT, T8COLa112 BIGINT, T8COLa113 BIGINT, 
T8COLa114 BIGINT, T8COLa115 BIGINT, T8COLa116 BIGINT, T8COLa117 BIGINT, 
T8COLa118 BIGINT, T8COLa119 BIGINT, T8COLa120 BIGINT, T8COLa121 TEXT, T8COLa122 
TEXT
 , T8COLa123 TEXT, T8COLa124 TEXT, T8COLa125 TEXT, T8COLa126 TEXT, T8COLa127 
TEXT, T8COLa128 TEXT, T8COLa129 TEXT, T8COLa130 TEXT, T8COLa131 TINYINT, 
T8COLa132 TINYINT, T8COLa133 TINYINT, T8COLa134 TINYINT, T8COLa135 TINYINT, 
T8COLa136 TINYINT, T8COLa137 TINYINT, T8COLa138 TINYINT, T8COLa139 TINYINT, 
T8COLa140 TINYINT, T8COLa141 INT, T8COLa142 INT, T8COLa143 INT, T8COLa144 INT, 
T8COLa145 INT, T8COLa146 INT, T8COLa147 INT, T8COLa148 INT, T8COLa149 INT, 
T8COLa150 INT, T8COLb1 TEXT, T8COLb2 TEXT, T8COLb3 TEXT, T8COLb4 TEXT, T8COLb5 
TEXT, T8COLb6 TEXT, T8COLb7 TEXT, T8COLb8 TEXT, T8COLb9 TEXT, T8COLb10 TEXT, 
T8COLb11 TEXT, T8COLb12 TEXT, T8COLb13 TEXT, T8COLb14 TEXT, T8COLb15 TEXT, 
T8COLb16 TEXT, T8COLb17 TEXT, T8COLb18 TEXT, T8COLb19 TEXT, T8COLb20 TEXT, 
T8COLb21 TEXT, T8COLb22 TEXT, T8COLb23 TEXT, T8COLb24 TEXT, T8COLb25 TEXT, 
T8COLb26 TEXT, T8COLb27 TEXT, T8COLb28 TEXT, T8COLb29 TEXT, T8COLb30 TEXT, 
T8COLb31 TEXT, T8COLb32 TEXT, T8COLb33 TEXT, T8COLb34 TEXT, T8COLb35 TEXT, 
T8COLb36 TE
 XT, T8COLb37 TEXT, T8COLb38 TEXT, T8COLb39 TEXT, T8COLb40 TEXT, T8COLb41 TEXT, 
T8COLb42 TEXT, T8COLb43 TEXT, T8COLb44 TEXT, T8COLb45 TEXT, T8COLb46 TEXT, 
T8COLb47 TEXT, T8COLb48 TEXT, T8COLb49 TEXT, T8COLb50 TEXT, T8COLb51 INT, 
T8COLb52 INT, T8COLb53 INT, T8COLb54 INT, T8COLb55 INT, T8COLb56 INT, T8COLb57 
INT, T8COLb58 INT, T8COLb59 INT, T8COLb60 INT, T8COLb61 INT, T8COLb62 INT, 
T8COLb63 INT, T8COLb64 INT, T8COLb65 INT, T8COLb66 DOUBLE, T8COLb67 DOUBLE, 
T8COLb68 DOUBLE, T8COLb69 DOUBLE, T8COLb70 DOUBLE, T8COLb71 DOUBLE, T8COLb72 
DOUBLE, T8COLb73 DOUBLE, T8COLb74 DOUBLE, T8COLb75 DOUBLE, T8COLb76 DOUBLE, 
T8COLb77 DOUBLE, T8COLb78 DOUBLE, T8COLb79 DOUBLE, T8COLb80 DOUBLE, T8COLb81 
DATE, T8COLb82 DATE, T8COLb83 DATE, T8COLb84 DATE, T8COLb85 DATE, T8COLb86 
DATE, T8COLb87 DATE, T8COLb88 DATE, T8COLb89 DATE, T8COLb90 DATE, T8COLb91 
TIMESTAMP, T8COLb92 TIMESTAMP, T8COLb93 TIMESTAMP, T8COLb94 TIMESTAMP, T8COLb95 
TIMESTAMP, T8COLb96 TIMESTAMP, T8COLb97 TIMESTAMP, T8COLb98 TIMESTAMP, T8COLb99
  TIMESTAMP, T8COLb100 TIMESTAMP, T8COLb101 TINYINT, T8COLb102 TINYINT, 
T8COLb103 TINYINT, T8COLb104 TINYINT, T8COLb105 TINYINT, T8COLb106 TINYINT, 
T8COLb107 TINYINT, T8COLb108 TINYINT, T8COLb109 TINYINT, T8COLb110 TINYINT, 
T8COLb111 BIGINT, T8COLb112 BIGINT, T8COLb113 BIGINT, T8COLb114 BIGINT, 
T8COLb115 BIGINT, T8COLb116 BIGINT, T8COLb117 BIGINT, T8COLb118 BIGINT, 
T8COLb119 BIGINT, T8COLb120 BIGINT, T8COLb121 TEXT, T8COLb122 TEXT, T8COLb123 
TEXT, T8COLb124 TEXT, T8COLb125 TEXT, T8COLb126 TEXT, T8COLb127 TEXT, T8COLb128 
TEXT, T8COLb129 TEXT, T8COLb130 TEXT, T8COLb131 TINYINT, T8COLb132 TINYINT, 
T8COLb133 TINYINT, T8COLb134 TINYINT, T8COLb135 TINYINT, T8COLb136 TINYINT, 
T8COLb137 TINYINT, T8COLb138 TINYINT, T8COLb139 TINYINT, T8COLb140 TINYINT, 
T8COLb141 INT, T8COLb142 INT, T8COLb143 INT, T8COLb144 INT, T8COLb145 INT, 
T8COLb146 INT, T8COLb147 INT, T8COLb148 INT, T8COLb149 INT, T8COLb150 INT, 
T8COLc1 TEXT, T8COLc2 TEXT, T8COLc3 TEXT, T8COLc4 TEXT, T8COLc5 TEXT, T8COLc6 
TEXT, T8COLc7 TE
 XT, T8COLc8 TEXT, T8COLc9 TEXT, T8COLc10 TEXT, T8COLc11 TEXT, T8COLc12 TEXT, 
T8COLc13 TEXT, T8COLc14 TEXT, T8COLc15 TEXT, T8COLc16 TEXT, T8COLc17 TEXT, 
T8COLc18 TEXT, T8COLc19 TEXT, T8COLc20 TEXT, T8COLc21 TEXT, T8COLc22 TEXT, 
T8COLc23 TEXT, T8COLc24 TEXT, T8COLc25 TEXT, T8COLc26 TEXT, T8COLc27 TEXT, 
T8COLc28 TEXT, T8COLc29 TEXT, T8COLc30 TEXT, T8COLc31 TEXT, T8COLc32 TEXT, 
T8COLc33 TEXT, T8COLc34 TEXT, T8COLc35 TEXT, T8COLc36 TEXT, T8COLc37 TEXT, 
T8COLc38 TEXT, T8COLc39 TEXT, T8COLc40 TEXT, T8COLc41 TEXT, T8COLc42 TEXT, 
T8COLc43 TEXT, T8COLc44 TEXT, T8COLc45 TEXT, T8COLc46 TEXT, T8COLc47 TEXT, 
T8COLc48 TEXT, T8COLc49 TEXT, T8COLc50 TEXT, T8COLc51 INT, T8COLc52 INT, 
T8COLc53 INT, T8COLc54 INT, T8COLc55 INT, T8COLc56 INT, T8COLc57 INT, T8COLc58 
INT, T8COLc59 INT, T8COLc60 INT, T8COLc61 INT, T8COLc62 INT, T8COLc63 INT, 
T8COLc64 INT, T8COLc65 INT, T8COLc66 DOUBLE, T8COLc67 DOUBLE, T8COLc68 DOUBLE, 
T8COLc69 DOUBLE, T8COLc70 DOUBLE, T8COLc71 DOUBLE, T8COLc72 DOUBLE, T8COLc73 
DOUBLE, T8CO
 Lc74 DOUBLE, T8COLc75 DOUBLE, T8COLc76 DOUBLE, T8COLc77 DOUBLE, T8COLc78 
DOUBLE, T8COLc79 DOUBLE, T8COLc80 DOUBLE, T8COLc81 DATE, T8COLc82 DATE, 
T8COLc83 DATE, T8COLc84 DATE, T8COLc85 DATE, T8COLc86 DATE, T8COLc87 DATE, 
T8COLc88 DATE, T8COLc89 DATE, T8COLc90 DATE, T8COLc91 TIMESTAMP, T8COLc92 
TIMESTAMP, T8COLc93 TIMESTAMP, T8COLc94 TIMESTAMP, T8COLc95 TIMESTAMP, T8COLc96 
TIMESTAMP, T8COLc97 TIMESTAMP, T8COLc98 TIMESTAMP, T8COLc99 TIMESTAMP, 
T8COLc100 TIMESTAMP, T8COLc101 TINYINT, T8COLc102 TINYINT, T8COLc103 TINYINT, 
T8COLc104 TINYINT, T8COLc105 TINYINT, T8COLc106 TINYINT, T8COLc107 TINYINT, 
T8COLc108 TINYINT, T8COLc109 TINYINT, T8COLc110 TINYINT, T8COLc111 BIGINT, 
T8COLc112 BIGINT, T8COLc113 BIGINT, T8COLc114 BIGINT, T8COLc115 BIGINT, 
T8COLc116 BIGINT, T8COLc117 BIGINT, T8COLc118 BIGINT, T8COLc119 BIGINT, 
T8COLc120 BIGINT, T8COLc121 TEXT, T8COLc122 TEXT, T8COLc123 TEXT, T8COLc124 
TEXT, T8COLc125 TEXT, T8COLc126 TEXT, T8COLc127 TEXT, T8COLc128 TEXT, T8COLc129 
TEXT, T8COLc130 TEXT, T
 8COLc131 TINYINT, T8COLc132 TINYINT, T8COLc133 TINYINT, T8COLc134 TINYINT, 
T8COLc135 TINYINT, T8COLc136 TINYINT, T8COLc137 TINYINT, T8COLc138 TINYINT, 
T8COLc139 TINYINT, T8COLc140 TINYINT, T8COLc141 INT, T8COLc142 INT, T8COLc143 
INT, T8COLc144 INT, T8COLc145 INT, T8COLc146 INT, T8COLc147 INT, T8COLc148 INT, 
T8COLc149 INT, T8COLc150 INT, T8COLd1 TEXT, T8COLd2 TEXT, T8COLd3 TEXT, T8COLd4 
TEXT, T8COLd5 TEXT, T8COLd6 TEXT, T8COLd7 TEXT, T8COLd8 TEXT, T8COLd9 TEXT, 
T8COLd10 TEXT, T8COLd11 TEXT, T8COLd12 TEXT, T8COLd13 TEXT, T8COLd14 TEXT, 
T8COLd15 TEXT, T8COLd16 TEXT, T8COLd17 TEXT, T8COLd18 TEXT, T8COLd19 TEXT, 
T8COLd20 TEXT, T8COLd21 TEXT, T8COLd22 TEXT, T8COLd23 TEXT, T8COLd24 TEXT, 
T8COLd25 TEXT, T8COLd26 TEXT, T8COLd27 TEXT, T8COLd28 TEXT, T8COLd29 TEXT, 
T8COLd30 TEXT, T8COLd31 TEXT, T8COLd32 TEXT, T8COLd33 TEXT, T8COLd34 TEXT, 
T8COLd35 TEXT, T8COLd36 TEXT, T8COLd37 TEXT, T8COLd38 TEXT, T8COLd39 TEXT, 
T8COLd40 TEXT, T8COLd41 TEXT, T8COLd42 TEXT, T8COLd43 TEXT, T8COLd44 TEXT, 
T8COLd4
 5 TEXT, T8COLd46 TEXT, T8COLd47 TEXT, T8COLd48 TEXT, T8COLd49 TEXT, T8COLd50 
TEXT, T8COLd51 INT, T8COLd52 INT, T8COLd53 INT, T8COLd54 INT, T8COLd55 INT, 
T8COLd56 INT, T8COLd57 INT, T8COLd58 INT, T8COLd59 INT, T8COLd60 INT, T8COLd61 
INT, T8COLd62 INT, T8COLd63 INT, T8COLd64 INT, T8COLd65 INT, T8COLd66 DOUBLE, 
T8COLd67 DOUBLE, T8COLd68 DOUBLE, T8COLd69 DOUBLE, T8COLd70 DOUBLE, T8COLd71 
DOUBLE, T8COLd72 DOUBLE, T8COLd73 DOUBLE, T8COLd74 DOUBLE, T8COLd75 DOUBLE, 
T8COLd76 DOUBLE, T8COLd77 DOUBLE, T8COLd78 DOUBLE, T8COLd79 DOUBLE, T8COLd80 
DOUBLE, T8COLd81 DATE, T8COLd82 DATE, T8COLd83 DATE, T8COLd84 DATE, T8COLd85 
DATE, T8COLd86 DATE, T8COLd87 DATE, T8COLd88 DATE, T8COLd89 DATE, T8COLd90 
DATE, T8COLd91 TIMESTAMP, T8COLd92 TIMESTAMP, T8COLd93 TIMESTAMP, T8COLd94 
TIMESTAMP, T8COLd95 TIMESTAMP, T8COLd96 TIMESTAMP, T8COLd97 TIMESTAMP, T8COLd98 
TIMESTAMP, T8COLd99 TIMESTAMP, T8COLd100 TIMESTAMP, T8COLd101 TINYINT, 
T8COLd102 TINYINT, T8COLd103 TINYINT, T8COLd104 TINYINT, T8COLd105 TINYINT, T8C
 OLd106 TINYINT, T8COLd107 TINYINT, T8COLd108 TINYINT, T8COLd109 TINYINT, 
T8COLd110 TINYINT, T8COLd111 BIGINT, T8COLd112 BIGINT, T8COLd113 BIGINT, 
T8COLd114 BIGINT, T8COLd115 BIGINT, T8COLd116 BIGINT, T8COLd117 BIGINT, 
T8COLd118 BIGINT, T8COLd119 BIGINT, T8COLd120 BIGINT, T8COLd121 TEXT, T8COLd122 
TEXT, T8COLd123 TEXT, T8COLd124 TEXT, T8COLd125 TEXT, T8COLd126 TEXT, T8COLd127 
TEXT, T8COLd128 TEXT, T8COLd129 TEXT, T8COLd130 TEXT, T8COLd131 TINYINT, 
T8COLd132 TINYINT, T8COLd133 TINYINT, T8COLd134 TINYINT, T8COLd135 TINYINT, 
T8COLd136 TINYINT, T8COLd137 TINYINT, T8COLd138 TINYINT, T8COLd139 TINYINT, 
T8COLd140 TINYINT, T8COLd141 INT, T8COLd142 INT, T8COLd143 INT, T8COLd144 INT, 
T8COLd145 INT, T8COLd146 INT, T8COLd147 INT, T8COLd148 INT, T8COLd149 INT, 
T8COLd150 INT, T8LASTCOL TEXT, PRIMARY KEY(T8PKCOL));
+CREATE TABLE Table9 (T9PKCOL bigint, T9COLa1 TEXT, T9COLa2 TEXT, T9COLa3 TEXT, 
T9COLa4 TEXT, T9COLa5 TEXT, T9COLa6 TEXT, T9COLa7 TEXT, T9COLa8 TEXT, T9COLa9 
TEXT, T9COLa10 TEXT, T9COLa11 TEXT, T9COLa12 TEXT, T9COLa13 TEXT, T9COLa14 
TEXT, T9COLa15 TEXT, T9COLa16 TEXT, T9COLa17 TEXT, T9COLa18 TEXT, T9COLa19 
TEXT, T9COLa20 TEXT, T9COLa21 TEXT, T9COLa22 TEXT, T9COLa23 TEXT, T9COLa24 
TEXT, T9COLa25 TEXT, T9COLa26 TEXT, T9COLa27 TEXT, T9COLa28 TEXT, T9COLa29 
TEXT, T9COLa30 TEXT, T9COLa31 TEXT, T9COLa32 TEXT, T9COLa33 TEXT, T9COLa34 
TEXT, T9COLa35 TEXT, T9COLa36 TEXT, T9COLa37 TEXT, T9COLa38 TEXT, T9COLa39 
TEXT, T9COLa40 TEXT, T9COLa41 TEXT, T9COLa42 TEXT, T9COLa43 TEXT, T9COLa44 
TEXT, T9COLa45 TEXT, T9COLa46 TEXT, T9COLa47 TEXT, T9COLa48 TEXT, T9COLa49 
TEXT, T9COLa50 TEXT, T9COLa51 INT, T9COLa52 INT, T9COLa53 INT, T9COLa54 INT, 
T9COLa55 INT, T9COLa56 INT, T9COLa57 INT, T9COLa58 INT, T9COLa59 INT, T9COLa60 
INT, T9COLa61 INT, T9COLa62 INT, T9COLa63 INT, T9COLa64 INT, T9COLa65 INT, 
T9COLa66 
 DOUBLE, T9COLa67 DOUBLE, T9COLa68 DOUBLE, T9COLa69 DOUBLE, T9COLa70 DOUBLE, 
T9COLa71 DOUBLE, T9COLa72 DOUBLE, T9COLa73 DOUBLE, T9COLa74 DOUBLE, T9COLa75 
DOUBLE, T9COLa76 DOUBLE, T9COLa77 DOUBLE, T9COLa78 DOUBLE, T9COLa79 DOUBLE, 
T9COLa80 DOUBLE, T9COLa81 DATE, T9COLa82 DATE, T9COLa83 DATE, T9COLa84 DATE, 
T9COLa85 DATE, T9COLa86 DATE, T9COLa87 DATE, T9COLa88 DATE, T9COLa89 DATE, 
T9COLa90 DATE, T9COLa91 TIMESTAMP, T9COLa92 TIMESTAMP, T9COLa93 TIMESTAMP, 
T9COLa94 TIMESTAMP, T9COLa95 TIMESTAMP, T9COLa96 TIMESTAMP, T9COLa97 TIMESTAMP, 
T9COLa98 TIMESTAMP, T9COLa99 TIMESTAMP, T9COLa100 TIMESTAMP, T9COLa101 TINYINT, 
T9COLa102 TINYINT, T9COLa103 TINYINT, T9COLa104 TINYINT, T9COLa105 TINYINT, 
T9COLa106 TINYINT, T9COLa107 TINYINT, T9COLa108 TINYINT, T9COLa109 TINYINT, 
T9COLa110 TINYINT, T9COLa111 BIGINT, T9COLa112 BIGINT, T9COLa113 BIGINT, 
T9COLa114 BIGINT, T9COLa115 BIGINT, T9COLa116 BIGINT, T9COLa117 BIGINT, 
T9COLa118 BIGINT, T9COLa119 BIGINT, T9COLa120 BIGINT, T9COLa121 TEXT, T9COLa122 
TEXT
 , T9COLa123 TEXT, T9COLa124 TEXT, T9COLa125 TEXT, T9COLa126 TEXT, T9COLa127 
TEXT, T9COLa128 TEXT, T9COLa129 TEXT, T9COLa130 TEXT, T9COLa131 TINYINT, 
T9COLa132 TINYINT, T9COLa133 TINYINT, T9COLa134 TINYINT, T9COLa135 TINYINT, 
T9COLa136 TINYINT, T9COLa137 TINYINT, T9COLa138 TINYINT, T9COLa139 TINYINT, 
T9COLa140 TINYINT, T9COLa141 INT, T9COLa142 INT, T9COLa143 INT, T9COLa144 INT, 
T9COLa145 INT, T9COLa146 INT, T9COLa147 INT, T9COLa148 INT, T9COLa149 INT, 
T9COLa150 INT, T9COLb1 TEXT, T9COLb2 TEXT, T9COLb3 TEXT, T9COLb4 TEXT, T9COLb5 
TEXT, T9COLb6 TEXT, T9COLb7 TEXT, T9COLb8 TEXT, T9COLb9 TEXT, T9COLb10 TEXT, 
T9COLb11 TEXT, T9COLb12 TEXT, T9COLb13 TEXT, T9COLb14 TEXT, T9COLb15 TEXT, 
T9COLb16 TEXT, T9COLb17 TEXT, T9COLb18 TEXT, T9COLb19 TEXT, T9COLb20 TEXT, 
T9COLb21 TEXT, T9COLb22 TEXT, T9COLb23 TEXT, T9COLb24 TEXT, T9COLb25 TEXT, 
T9COLb26 TEXT, T9COLb27 TEXT, T9COLb28 TEXT, T9COLb29 TEXT, T9COLb30 TEXT, 
T9COLb31 TEXT, T9COLb32 TEXT, T9COLb33 TEXT, T9COLb34 TEXT, T9COLb35 TEXT, 
T9COLb36 TE
 XT, T9COLb37 TEXT, T9COLb38 TEXT, T9COLb39 TEXT, T9COLb40 TEXT, T9COLb41 TEXT, 
T9COLb42 TEXT, T9COLb43 TEXT, T9COLb44 TEXT, T9COLb45 TEXT, T9COLb46 TEXT, 
T9COLb47 TEXT, T9COLb48 TEXT, T9COLb49 TEXT, T9COLb50 TEXT, T9COLb51 INT, 
T9COLb52 INT, T9COLb53 INT, T9COLb54 INT, T9COLb55 INT, T9COLb56 INT, T9COLb57 
INT, T9COLb58 INT, T9COLb59 INT, T9COLb60 INT, T9COLb61 INT, T9COLb62 INT, 
T9COLb63 INT, T9COLb64 INT, T9COLb65 INT, T9COLb66 DOUBLE, T9COLb67 DOUBLE, 
T9COLb68 DOUBLE, T9COLb69 DOUBLE, T9COLb70 DOUBLE, T9COLb71 DOUBLE, T9COLb72 
DOUBLE, T9COLb73 DOUBLE, T9COLb74 DOUBLE, T9COLb75 DOUBLE, T9COLb76 DOUBLE, 
T9COLb77 DOUBLE, T9COLb78 DOUBLE, T9COLb79 DOUBLE, T9COLb80 DOUBLE, T9COLb81 
DATE, T9COLb82 DATE, T9COLb83 DATE, T9COLb84 DATE, T9COLb85 DATE, T9COLb86 
DATE, T9COLb87 DATE, T9COLb88 DATE, T9COLb89 DATE, T9COLb90 DATE, T9COLb91 
TIMESTAMP, T9COLb92 TIMESTAMP, T9COLb93 TIMESTAMP, T9COLb94 TIMESTAMP, T9COLb95 
TIMESTAMP, T9COLb96 TIMESTAMP, T9COLb97 TIMESTAMP, T9COLb98 TIMESTAMP, T9COLb99
  TIMESTAMP, T9COLb100 TIMESTAMP, T9COLb101 TINYINT, T9COLb102 TINYINT, 
T9COLb103 TINYINT, T9COLb104 TINYINT, T9COLb105 TINYINT, T9COLb106 TINYINT, 
T9COLb107 TINYINT, T9COLb108 TINYINT, T9COLb109 TINYINT, T9COLb110 TINYINT, 
T9COLb111 BIGINT, T9COLb112 BIGINT, T9COLb113 BIGINT, T9COLb114 BIGINT, 
T9COLb115 BIGINT, T9COLb116 BIGINT, T9COLb117 BIGINT, T9COLb118 BIGINT, 
T9COLb119 BIGINT, T9COLb120 BIGINT, T9COLb121 TEXT, T9COLb122 TEXT, T9COLb123 
TEXT, T9COLb124 TEXT, T9COLb125 TEXT, T9COLb126 TEXT, T9COLb127 TEXT, T9COLb128 
TEXT, T9COLb129 TEXT, T9COLb130 TEXT, T9COLb131 TINYINT, T9COLb132 TINYINT, 
T9COLb133 TINYINT, T9COLb134 TINYINT, T9COLb135 TINYINT, T9COLb136 TINYINT, 
T9COLb137 TINYINT, T9COLb138 TINYINT, T9COLb139 TINYINT, T9COLb140 TINYINT, 
T9COLb141 INT, T9COLb142 INT, T9COLb143 INT, T9COLb144 INT, T9COLb145 INT, 
T9COLb146 INT, T9COLb147 INT, T9COLb148 INT, T9COLb149 INT, T9COLb150 INT, 
T9COLc1 TEXT, T9COLc2 TEXT, T9COLc3 TEXT, T9COLc4 TEXT, T9COLc5 TEXT, T9COLc6 
TEXT, T9COLc7 TE
 XT, T9COLc8 TEXT, T9COLc9 TEXT, T9COLc10 TEXT, T9COLc11 TEXT, T9COLc12 TEXT, 
T9COLc13 TEXT, T9COLc14 TEXT, T9COLc15 TEXT, T9COLc16 TEXT, T9COLc17 TEXT, 
T9COLc18 TEXT, T9COLc19 TEXT, T9COLc20 TEXT, T9COLc21 TEXT, T9COLc22 TEXT, 
T9COLc23 TEXT, T9COLc24 TEXT, T9COLc25 TEXT, T9COLc26 TEXT, T9COLc27 TEXT, 
T9COLc28 TEXT, T9COLc29 TEXT, T9COLc30 TEXT, T9COLc31 TEXT, T9COLc32 TEXT, 
T9COLc33 TEXT, T9COLc34 TEXT, T9COLc35 TEXT, T9COLc36 TEXT, T9COLc37 TEXT, 
T9COLc38 TEXT, T9COLc39 TEXT, T9COLc40 TEXT, T9COLc41 TEXT, T9COLc42 TEXT, 
T9COLc43 TEXT, T9COLc44 TEXT, T9COLc45 TEXT, T9COLc46 TEXT, T9COLc47 TEXT, 
T9COLc48 TEXT, T9COLc49 TEXT, T9COLc50 TEXT, T9COLc51 INT, T9COLc52 INT, 
T9COLc53 INT, T9COLc54 INT, T9COLc55 INT, T9COLc56 INT, T9COLc57 INT, T9COLc58 
INT, T9COLc59 INT, T9COLc60 INT, T9COLc61 INT, T9COLc62 INT, T9COLc63 INT, 
T9COLc64 INT, T9COLc65 INT, T9COLc66 DOUBLE, T9COLc67 DOUBLE, T9COLc68 DOUBLE, 
T9COLc69 DOUBLE, T9COLc70 DOUBLE, T9COLc71 DOUBLE, T9COLc72 DOUBLE, T9COLc73 
DOUBLE, T9CO
 Lc74 DOUBLE, T9COLc75 DOUBLE, T9COLc76 DOUBLE, T9COLc77 DOUBLE, T9COLc78 
DOUBLE, T9COLc79 DOUBLE, T9COLc80 DOUBLE, T9COLc81 DATE, T9COLc82 DATE, 
T9COLc83 DATE, T9COLc84 DATE, T9COLc85 DATE, T9COLc86 DATE, T9COLc87 DATE, 
T9COLc88 DATE, T9COLc89 DATE, T9COLc90 DATE, T9COLc91 TIMESTAMP, T9COLc92 
TIMESTAMP, T9COLc93 TIMESTAMP, T9COLc94 TIMESTAMP, T9COLc95 TIMESTAMP, T9COLc96 
TIMESTAMP, T9COLc97 TIMESTAMP, T9COLc98 TIMESTAMP, T9COLc99 TIMESTAMP, 
T9COLc100 TIMESTAMP, T9COLc101 TINYINT, T9COLc102 TINYINT, T9COLc103 TINYINT, 
T9COLc104 TINYINT, T9COLc105 TINYINT, T9COLc106 TINYINT, T9COLc107 TINYINT, 
T9COLc108 TINYINT, T9COLc109 TINYINT, T9COLc110 TINYINT, T9COLc111 BIGINT, 
T9COLc112 BIGINT, T9COLc113 BIGINT, T9COLc114 BIGINT, T9COLc115 BIGINT, 
T9COLc116 BIGINT, T9COLc117 BIGINT, T9COLc118 BIGINT, T9COLc119 BIGINT, 
T9COLc120 BIGINT, T9COLc121 TEXT, T9COLc122 TEXT, T9COLc123 TEXT, T9COLc124 
TEXT, T9COLc125 TEXT, T9COLc126 TEXT, T9COLc127 TEXT, T9COLc128 TEXT, T9COLc129 
TEXT, T9COLc130 TEXT, T
 9COLc131 TINYINT, T9COLc132 TINYINT, T9COLc133 TINYINT, T9COLc134 TINYINT, 
T9COLc135 TINYINT, T9COLc136 TINYINT, T9COLc137 TINYINT, T9COLc138 TINYINT, 
T9COLc139 TINYINT, T9COLc140 TINYINT, T9COLc141 INT, T9COLc142 INT, T9COLc143 
INT, T9COLc144 INT, T9COLc145 INT, T9COLc146 INT, T9COLc147 INT, T9COLc148 INT, 
T9COLc149 INT, T9COLc150 INT, T9COLd1 TEXT, T9COLd2 TEXT, T9COLd3 TEXT, T9COLd4 
TEXT, T9COLd5 TEXT, T9COLd6 TEXT, T9COLd7 TEXT, T9COLd8 TEXT, T9COLd9 TEXT, 
T9COLd10 TEXT, T9COLd11 TEXT, T9COLd12 TEXT, T9COLd13 TEXT, T9COLd14 TEXT, 
T9COLd15 TEXT, T9COLd16 TEXT, T9COLd17 TEXT, T9COLd18 TEXT, T9COLd19 TEXT, 
T9COLd20 TEXT, T9COLd21 TEXT, T9COLd22 TEXT, T9COLd23 TEXT, T9COLd24 TEXT, 
T9COLd25 TEXT, T9COLd26 TEXT, T9COLd27 TEXT, T9COLd28 TEXT, T9COLd29 TEXT, 
T9COLd30 TEXT, T9COLd31 TEXT, T9COLd32 TEXT, T9COLd33 TEXT, T9COLd34 TEXT, 
T9COLd35 TEXT, T9COLd36 TEXT, T9COLd37 TEXT, T9COLd38 TEXT, T9COLd39 TEXT, 
T9COLd40 TEXT, T9COLd41 TEXT, T9COLd42 TEXT, T9COLd43 TEXT, T9COLd44 TEXT, 
T9COLd4
 5 TEXT, T9COLd46 TEXT, T9COLd47 TEXT, T9COLd48 TEXT, T9COLd49 TEXT, T9COLd50 
TEXT, T9COLd51 INT, T9COLd52 INT, T9COLd53 INT, T9COLd54 INT, T9COLd55 INT, 
T9COLd56 INT, T9COLd57 INT, T9COLd58 INT, T9COLd59 INT, T9COLd60 INT, T9COLd61 
INT, T9COLd62 INT, T9COLd63 INT, T9COLd64 INT, T9COLd65 INT, T9COLd66 DOUBLE, 
T9COLd67 DOUBLE, T9COLd68 DOUBLE, T9COLd69 DOUBLE, T9COLd70 DOUBLE, T9COLd71 
DOUBLE, T9COLd72 DOUBLE, T9COLd73 DOUBLE, T9COLd74 DOUBLE, T9COLd75 DOUBLE, 
T9COLd76 DOUBLE, T9COLd77 DOUBLE, T9COLd78 DOUBLE, T9COLd79 DOUBLE, T9COLd80 
DOUBLE, T9COLd81 DATE, T9COLd82 DATE, T9COLd83 DATE, T9COLd84 DATE, T9COLd85 
DATE, T9COLd86 DATE, T9COLd87 DATE, T9COLd88 DATE, T9COLd89 DATE, T9COLd90 
DATE, T9COLd91 TIMESTAMP, T9COLd92 TIMESTAMP, T9COLd93 TIMESTAMP, T9COLd94 
TIMESTAMP, T9COLd95 TIMESTAMP, T9COLd96 TIMESTAMP, T9COLd97 TIMESTAMP, T9COLd98 
TIMESTAMP, T9COLd99 TIMESTAMP, T9COLd100 TIMESTAMP, T9COLd101 TINYINT, 
T9COLd102 TINYINT, T9COLd103 TINYINT, T9COLd104 TINYINT, T9COLd105 TINYINT, T9C
 OLd106 TINYINT, T9COLd107 TINYINT, T9COLd108 TINYINT, T9COLd109 TINYINT, 
T9COLd110 TINYINT, T9COLd111 BIGINT, T9COLd112 BIGINT, T9COLd113 BIGINT, 
T9COLd114 BIGINT, T9COLd115 BIGINT, T9COLd116 BIGINT, T9COLd117 BIGINT, 
T9COLd118 BIGINT, T9COLd119 BIGINT, T9COLd120 BIGINT, T9COLd121 TEXT, T9COLd122 
TEXT, T9COLd123 TEXT, T9COLd124 TEXT, T9COLd125 TEXT, T9COLd126 TEXT, T9COLd127 
TEXT, T9COLd128 TEXT, T9COLd129 TEXT, T9COLd130 TEXT, T9COLd131 TINYINT, 
T9COLd132 TINYINT, T9COLd133 TINYINT, T9COLd134 TINYINT, T9COLd135 TINYINT, 
T9COLd136 TINYINT, T9COLd137 TINYINT, T9COLd138 TINYINT, T9COLd139 TINYINT, 
T9COLd140 TINYINT, T9COLd141 INT, T9COLd142 INT, T9COLd143 INT, T9COLd144 INT, 
T9COLd145 INT, T9COLd146 INT, T9COLd147 INT, T9COLd148 INT, T9COLd149 INT, 
T9COLd150 INT, T9LASTCOL TEXT, PRIMARY KEY(T9PKCOL));
+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, T1
 0COLa62 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, T10
 COLa116 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, T10COL
 b86 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 
T
 INYINT, 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 TEXT
 , 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, T10COLc10
 7 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, T10COLd
 14 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, T10COLd
 76 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, T1
 1COLa62 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, T11
 COLa116 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, T11COL
 b86 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 
T
 INYINT, 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 TEXT
 , 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, T11COLc10
 7 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, T11COLd
 14 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, T11COLd
 76 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, T1
 2COLa62 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, T12
 COLa116 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, T12COL
 b86 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 
T
 INYINT, 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 TEXT
 , 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, T12COLc10
 7 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, T12COLd
 14 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, T12COLd
 76 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));
+
+/*
+This query may not be meaningful as this involves some unnecessary joins. But 
as per our business use case, we have queries with 25+ joins that involves 
select columns or criteria from each and every table in the query. 
+*/
+
+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
+LEFT JOIN Table8 Lookup5 ON Table1.T1COLb114  = Lookup5.T8COLb114
+LEFT JOIN Table6 Lookup11 ON Table4.T4COLb111  = Lookup11.T6PKCOL
+LEFT JOIN Table2 Lookup21 ON Table4.T4COLb112  = Lookup21.T2COLb112
+LEFT JOIN Table5 Lookup31 ON Table5.T5COLb113  = Lookup31.T5PKCOL
+LEFT JOIN Table7 Lookup41 ON Table4.T4COLb114  = Lookup41.T7PKCOL
+LEFT JOIN Table8 Lookup51 ON Table4.T4COLb115  = Lookup51.T8PKCOL
+LEFT JOIN Table6 CLookup1 ON Table2.T2COLc111  = CLookup1.T6PKCOL
+LEFT JOIN Table2 CLookup2 ON Table2.T2COLc112  = CLookup2.T2PKCOL
+LEFT JOIN Table5 CLookup3 ON Table2.T2COLc113  = CLookup3.T5PKCOL
+LEFT JOIN Table7 CLookup4 ON Table2.T2COLc114  = CLookup4.T7PKCOL
+LEFT JOIN Table8 CLookup5 ON Table2.T2COLc115  = CLookup5.T8PKCOL
+
+LEFT JOIN Table9 on Table1.T1PKCOL  = Table9.T9COLa111
+LEFT JOIN Table10 ON Table9.T9PKCOL  = Table10.T10PKCOL
+LEFT JOIN Table11 ON Table9.T9PKCOL  = Table11.T11PKCOL
+
+LEFT JOIN Table3 a1 ON a1.T3PKCOL = Table1.T1COLd111
+LEFT JOIN Table3 a2 ON a2.T3PKCOL = Table1.T1COLd112
+LEFT JOIN Table3 a3 ON a3.T3PKCOL = Table1.T1COLd113
+LEFT JOIN Table12 ON Table12.T12COLA1 = Table1.T1COLA1
+WHERE
+(
+Table1.T1COLd1  ILIKE '%a%'
+OR
+Table1.T1COLa1  ILIKE '%a%'
+OR
+Table1.T1COLb1  ILIKE '%a%'
+OR
+Table1.T1COLa11 ILIKE '%business%'
+OR
+Table1.T1COLc91 >= '2016-03-21 05:00:00'
+OR
+Table1.T1COLa101 = 1
+OR
+Table1.T1COLa12 ILIKE '%Vijay%'
+OR
+( Table2.T2COLa1 NOT ILIKE '%gmail%'   AND Table2.T2COLa1 NOT ILIKE '%yahoo%' )
+OR
+Table2.T2COLa1 ILIKE '%efequitygroup.com%'
+OR
+Table4.T4COLa1 ='Customer'
+OR
+Table4.T4COLa2 IS NOT NULL
+OR
+Table2.T2COLa81 >= '2009-08-31'
+OR
+(
+Table5.T5COLa1 = 'BAT' OR Table5.T5COLa2 ILIKE '%AUSTRALIA%'  OR 
Table5.T5COLa2 ILIKE '%Monet%'  AND (Table5.T5COLa3 = 'Facebook')
+
+AND Table5.T5COLa5 = 'new' AND Table5.T5COLa81 > '2015-07-30'
+)
+OR
+(
+(Table10.T10COLa1 <> 'Completed' and Table9.T9COLa1 = 'Tasks' and 
Table9.T9COLa91>='2012-01-01 04:32:27' and Table10.T10COLa91<='2013-01-01 
04:32:27')
+OR
+( Table9.T9COLa1 = 'Events' and Table11.T11COLa91 >= '2012-01-01 04:32:27' and 
Table11.T11COLa91 <= '2013-01-01 04:32:27' ) or (Table9.T9COLa1 = 'Calls' and 
Table10.T10COLa91 >= '2012-01-01 04:32:27' and Table10.T10COLa91 <= '2013-01-01 
04:32:27' )
+)
+)
+AND
+Table1.T1COLD111 IN 
(15842000014793046,15842000017701488,15842000000024019,15842000000074007,15842000009358096,15842000010487625,15842000006731919,15842000002590112,15842000000019001,15842000014923682,15842000027547249)
 OR Table12.T12COLA1 IN (15842000280111951,15842000280163015)
+ORDER BY Table2.T2COLa82 DESC LIMIT 10 OFFSET 0;
+
+ROLLBACK;
diff --git 
a/sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.stable.err
 
b/sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.stable.err
new file mode 100644
--- /dev/null
+++ 
b/sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.stable.err
@@ -0,0 +1,37 @@
+stderr of test 'memory-consumption-query-PLAN-25joins.Bug-3972` in directory 
'sql/test/BugTracker-2016` itself:
+
+
+# 18:24:13 >  
+# 18:24:13 >  "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" 
"mapi_open=true" "--set" "mapi_port=33186" "--set" 
"mapi_usock=/var/tmp/mtest-23646/.s.monetdb.33186" "--set" "monet_prompt=" 
"--forcemito" "--set" "mal_listing=2" 
"--dbpath=/export/scratch2/zhang/monet-install/Jul2015/debug/var/MonetDB/mTests_sql_test_BugTracker-2016"
 "--set" "mal_listing=0" "--set" "embedded_r=yes"
+# 18:24:13 >  
+
+# builtin opt  gdk_dbpath = 
/export/scratch2/zhang/monet-install/Jul2015/debug/var/monetdb5/dbfarm/demo
+# builtin opt  gdk_debug = 0
+# builtin opt  gdk_vmtrim = no
+# builtin opt  monet_prompt = >
+# builtin opt  monet_daemon = no
+# builtin opt  mapi_port = 50000
+# builtin opt  mapi_open = false
+# builtin opt  mapi_autosense = false
+# builtin opt  sql_optimizer = default_pipe
+# builtin opt  sql_debug = 0
+# cmdline opt  gdk_nr_threads = 0
+# cmdline opt  mapi_open = true
+# cmdline opt  mapi_port = 33186
+# cmdline opt  mapi_usock = /var/tmp/mtest-23646/.s.monetdb.33186
+# cmdline opt  monet_prompt = 
+# cmdline opt  mal_listing = 2
+# cmdline opt  gdk_dbpath = 
/export/scratch2/zhang/monet-install/Jul2015/debug/var/MonetDB/mTests_sql_test_BugTracker-2016
+# cmdline opt  mal_listing = 0
+# cmdline opt  embedded_r = yes
+# cmdline opt  gdk_debug = 536870922
+
+# 18:24:14 >  
+# 18:24:14 >  "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" 
"--host=/var/tmp/mtest-23646" "--port=33186"
+# 18:24:14 >  
+
+
+# 18:25:53 >  
+# 18:25:53 >  "Done."
+# 18:25:53 >  
+
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
new file mode 100644
--- /dev/null
+++ 
b/sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.stable.out
@@ -0,0 +1,86 @@
+stdout of test 'memory-consumption-query-PLAN-25joins.Bug-3972` in directory 
'sql/test/BugTracker-2016` itself:
+
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to