Changeset: 6a6aa63ae6b4 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6a6aa63ae6b4
Modified Files:
sql/storage/bat/bat_storage.c
sql/storage/store.c
sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.sql
sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.stable.out
sql/test/BugTracker-2010/Tests/huge_nr_of_columns.Bug-2609.sql
sql/test/BugTracker-2012/Tests/huge_table_update.Bug-2803.sql
sql/test/BugTracker-2012/Tests/huge_table_update.Bug-2803.stable.out
Branch: linear-hashing
Log Message:
Merged with Nov2019
diffs (truncated from 19879 to 300 lines):
diff --git a/sql/storage/bat/bat_storage.c b/sql/storage/bat/bat_storage.c
--- a/sql/storage/bat/bat_storage.c
+++ b/sql/storage/bat/bat_storage.c
@@ -775,7 +775,7 @@ dup_idx(sql_trans *tr, sql_idx *i, sql_i
{
int ok = LOG_OK;
- if (!isTable(i->t) || !idx_has_column(i->type))
+ if (!isTable(i->t) || (hash_index(i->type) && list_length(i->columns)
<= 1) || !idx_has_column(i->type))
return ok;
if (i->data) {
int type = (oid_index(ni->type))?TYPE_oid:TYPE_lng;
@@ -892,9 +892,9 @@ append_col(sql_trans *tr, sql_column *c,
static int
append_idx(sql_trans *tr, sql_idx * i, void *ib, int tpe)
{
+ int ok = LOG_OK;
BAT *b = ib;
sql_delta *bat;
- int ok = LOG_OK;
if (tpe == TYPE_bat && !BATcount(b))
return ok;
@@ -908,8 +908,8 @@ append_idx(sql_trans *tr, sql_idx * i, v
else {
i->data = bat;
obat = timestamp_delta(oi->data, i->base.stime);
- ok = dup_bat(tr, i->t, obat, bat, type, isNew(i),
isNew(i));
- if(ok != LOG_ERR)
+ ok = dup_bat(tr, i->t, obat, bat, type, isNew(oi),
isNew(i));
+ if(ok == LOG_OK)
i->base.allocated = 1;
}
}
@@ -1053,7 +1053,7 @@ delete_tab(sql_trans *tr, sql_table * t,
sql_idx *i = n->data;
sql_delta *bat;
- if (!isTable(i->t) || !idx_has_column(i->type))
+ if (!isTable(i->t) || (hash_index(i->type) &&
list_length(i->columns) <= 1) || !idx_has_column(i->type))
continue;
if (!i->data) {
sql_idx *oi = tr_find_idx(tr->parent, i);
@@ -1136,7 +1136,7 @@ count_idx(sql_trans *tr, sql_idx *i, int
{
sql_delta *b;
- if (!isTable(i->t) || !idx_has_column(i->type))
+ if (!isTable(i->t) || (hash_index(i->type) && list_length(i->columns)
<= 1) || !idx_has_column(i->type))
return 0;
if (!i->data) {
sql_idx *oi = tr_find_idx(tr->parent, i);
@@ -1189,7 +1189,7 @@ count_idx_upd(sql_trans *tr, sql_idx *i)
{
sql_delta *b;
- if (!isTable(i->t) || !idx_has_column(i->type))
+ if (!isTable(i->t) || (hash_index(i->type) && list_length(i->columns)
<= 1) || !idx_has_column(i->type))
return 0;
if (!i->data) {
sql_idx *oi = tr_find_idx(tr->parent, i);
@@ -1220,7 +1220,7 @@ count_upd(sql_trans *tr, sql_table *t)
for( n = t->idxs.set->h; n; n = n->next) {
sql_idx *i = n->data;
- if (!isTable(i->t) || !idx_has_column(i->type))
+ if (!isTable(i->t) || (hash_index(i->type) &&
list_length(i->columns) <= 1) || !idx_has_column(i->type))
continue;
if (count_idx_upd(tr, i))
return 1;
@@ -2055,7 +2055,7 @@ clear_col(sql_trans *tr, sql_column *c)
static BUN
clear_idx(sql_trans *tr, sql_idx *i)
{
- if (!isTable(i->t) || !idx_has_column(i->type))
+ if (!isTable(i->t) || (hash_index(i->type) && list_length(i->columns)
<= 1) || !idx_has_column(i->type))
return 0;
if (!i->data || !i->base.allocated) {
int type = (oid_index(i->type))?TYPE_oid:TYPE_lng;
@@ -2064,7 +2064,7 @@ clear_idx(sql_trans *tr, sql_idx *i)
if(!bat)
return 0;
obat = timestamp_delta(oi->data, i->base.stime);
- if(dup_bat(tr, i->t, obat, bat, type, isNew(i), isNew(i)))
+ if(dup_bat(tr, i->t, obat, bat, type, isNew(oi), isNew(i)))
return 0;
i->base.allocated = 1;
}
@@ -2279,7 +2279,7 @@ gtr_update_table(sql_trans *tr, sql_tabl
sql_idx *ci = n->data;
/* some indices have no bats */
- if (!isTable(ci->t) || !idx_has_column(ci->type))
+ if (!isTable(ci->t) || (hash_index(ci->type) &&
list_length(ci->columns) <= 1) || !idx_has_column(ci->type))
continue;
if (!ci->base.wtime || ci->base.wtime <=
ci->base.allocated)
continue;
@@ -2858,7 +2858,7 @@ update_table(sql_trans *tr, sql_table *f
sql_idx *oi = m->data;
/* some indices have no bats */
- if (!oi->data) {
+ if (!oi->data || (hash_index(oi->type) &&
list_length(oi->columns) <= 1) || !idx_has_column(oi->type)) {
ci->data = NULL;
ci->base.allocated = 0;
continue;
diff --git a/sql/storage/store.c b/sql/storage/store.c
--- a/sql/storage/store.c
+++ b/sql/storage/store.c
@@ -3616,6 +3616,22 @@ trans_init(sql_trans *tr, backend_stack
assert(0);
}
}
+ if (pt->idxs.set)
+ for (i = pt->idxs.set->h, j =
t->idxs.set->h; i && j; i = i->next, j = j->next ) {
+ sql_idx *pc = i->data; /*
parent transactions column */
+ sql_idx *c = j->data;
+
+ if (pc->base.id == c->base.id) {
+ c->base.rtime =
c->base.wtime = 0;
+ c->base.stime =
pc->base.wtime;
+ if (!istmp &&
!c->base.allocated)
+ c->data = NULL;
+ assert (istmp ||
!c->base.allocated);
+ } else {
+ /* for now assert */
+ assert(0);
+ }
+ }
} else {
/* for now assert */
assert(0);
diff --git
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.sql
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.sql
---
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.sql
+++
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.sql
@@ -1,1 +1,1 @@
-select cast(
1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(
1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1
+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+
(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(
1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1
+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+
(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
)))))))))))))))))))))))))))))))))))))) as bigint);
+select cast(
1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
as bigint);
diff --git
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.stable.out
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.stable.out
---
a/sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.stable.out
+++
b/sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.stable.out
@@ -1,36 +1,73 @@
stdout of test 'huge_expression_and_column_name.SF-921173` in directory
'sql/test/BugDay_2005-10-06_2.9.3` itself:
-# 16:51:09 >
-# 16:51:09 > mserver5
"--config=/home/niels/scratch/monetdb/Linux-i686/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=4 --set
"monet_mod_path=/home/niels/scratch/monetdb/Linux-i686/lib/MonetDB5:/home/niels/scratch/monetdb/Linux-i686/lib/MonetDB5/lib:/home/niels/scratch/monetdb/Linux-i686/lib/MonetDB5/bin"
--set "gdk_dbfarm=/home/niels/scratch/monetdb/Linux-i686/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=30596 --set
xrpc_port=46487 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugDay_2005-10-06_2.9.3" --set mal_listing=0
"--dbinit= include sql;" ; echo ; echo Over..
-# 16:51:09 >
+# 17:01:01 >
+# 17:01:01 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=37658" "--set"
"mapi_usock=/var/tmp/mtest-380657/.s.monetdb.37658" "--forcemito"
"--dbpath=/home/ferreira/repositories/MonetDB-Nov2019/BUILD/var/MonetDB/mTests_sql_test_BugDay_2005-10-06_2.9.3"
"--set" "embedded_c=true"
+# 17:01:01 >
-# MonetDB server v5.17.0, based on kernel v1.35.0
-# Serving database 'mTests_src_test_BugDay_2005-10-06_2.9.3', using 4 threads
-# Compiled for i686-pc-linux-gnu/32bit with 32bit OIDs dynamically linked
-# Detected 993.930 MiB (1042210816 bytes) main-memory.
-# Copyright (c) 1993-July 2008 CWI.
-# Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved
-# Visit http://monetdb.cwi.nl/ for further information
-# Listening for connection requests on
mapi:monetdb://localhost.localdomain:30596/
-# MonetDB/SQL module v2.35.0 loaded
+# MonetDB 5 server v11.35.6 (hg id: f15578e26681)
+# This is an unreleased version
+# Serving database 'mTests_sql_test_BugDay_2005-10-06_2.9.3', using 8 threads
+# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
+# Found 15.498 GiB available main-memory of which we use 12.631 GiB
+# Copyright (c) 1993 - July 2008 CWI.
+# Copyright (c) August 2008 - 2020 MonetDB B.V., all rights reserved
+# Visit https://www.monetdb.org/ for further information
+# Listening for connection requests on
mapi:monetdb://localhost.localdomain:37658/
+# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-380657/.s.monetdb.37658
+# MonetDB/GIS module loaded
+# SQL catalog created, loading sql scripts once
+# loading sql script: 09_like.sql
+# loading sql script: 10_math.sql
+# loading sql script: 12_url.sql
+# loading sql script: 13_date.sql
+# loading sql script: 14_inet.sql
+# loading sql script: 15_querylog.sql
+# loading sql script: 16_tracelog.sql
+# loading sql script: 17_temporal.sql
+# loading sql script: 18_index.sql
+# loading sql script: 20_vacuum.sql
+# loading sql script: 21_dependency_views.sql
+# loading sql script: 22_clients.sql
+# loading sql script: 23_skyserver.sql
+# loading sql script: 25_debug.sql
+# loading sql script: 26_sysmon.sql
+# loading sql script: 27_rejects.sql
+# loading sql script: 39_analytics.sql
+# loading sql script: 39_analytics_hge.sql
+# loading sql script: 40_geom.sql
+# loading sql script: 40_json.sql
+# loading sql script: 40_json_hge.sql
+# loading sql script: 41_md5sum.sql
+# loading sql script: 45_uuid.sql
+# loading sql script: 46_profiler.sql
+# loading sql script: 51_sys_schema_extension.sql
+# loading sql script: 60_wlcr.sql
+# loading sql script: 61_wlcr.sql
+# loading sql script: 72_fits.sql
+# loading sql script: 74_netcdf.sql
+# loading sql script: 75_lidar.sql
+# loading sql script: 75_shp.sql
+# loading sql script: 75_storagemodel.sql
+# loading sql script: 80_statistics.sql
+# loading sql script: 80_udf.sql
+# loading sql script: 80_udf_hge.sql
+# loading sql script: 85_bam.sql
+# loading sql script: 90_generator.sql
+# loading sql script: 90_generator_hge.sql
+# loading sql script: 99_system.sql
+# MonetDB/SQL module loaded
-#function user.main():void;
-# clients.quit();
-#end main;
-
+# 17:01:02 >
+# 17:01:02 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-380657" "--port=37658"
+# 17:01:02 >
-# 16:51:10 >
-# 16:51:10 > mclient -lsql -i --host=localhost --port=30596
-# 16:51:10 >
-
-#select cast(
1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+
(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(
1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1
+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+
(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(
1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1
+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
))))))))))))))))))))))))))))))))))))))) as bigint);
+#select cast(
1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1+(1))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
as bigint);
% . # table_name
% %1 # name
% bigint # type
-% 4 # length
-[ 2001 ]
-
+% 3 # length
+[ 101 ]
# 16:51:10 >
# 16:51:10 > Done.
diff --git a/sql/test/BugTracker-2010/Tests/huge_nr_of_columns.Bug-2609.sql
b/sql/test/BugTracker-2010/Tests/huge_nr_of_columns.Bug-2609.sql
--- a/sql/test/BugTracker-2010/Tests/huge_nr_of_columns.Bug-2609.sql
+++ b/sql/test/BugTracker-2010/Tests/huge_nr_of_columns.Bug-2609.sql
@@ -1,4 +1,3 @@
-create table crash_q (q0 char(1) not null,q1 char(1) not null,q2 char(1) not
null,q3 char(1) not null,q4 char(1) not null,q5 char(1) not null,q6 char(1) not
null,q7 char(1) not null,q8 char(1) not null,q9 char(1) not null,q10 char(1)
not null,q11 char(1) not null,q12 char(1) not null,q13 char(1) not null,q14
char(1) not null,q15 char(1) not null,q16 char(1) not null,q17 char(1) not
null,q18 char(1) not null,q19 char(1) not null,q20 char(1) not null,q21 char(1)
not null,q22 char(1) not null,q23 char(1) not null,q24 char(1) not null,q25
char(1) not null,q26 char(1) not null,q27 char(1) not null,q28 char(1) not
null,q29 char(1) not null,q30 char(1) not null,q31 char(1) not null,q32 char(1)
not null,q33 char(1) not null,q34 char(1) not null,q35 char(1) not null,q36
char(1) not null,q37 char(1) not null,q38 char(1) not null,q39 char(1) not
null,q40 char(1) not null,q41 char(1) not null,q42 char(1) not null,q43 char(1)
not null,q44 char(1) not null,q45 char(1) not null,q46 char(1) not nul
l,q47 char(1) not null,q48 char(1) not null,q49 char(1) not null,q50 char(1)
not null,q51 char(1) not null,q52 char(1) not null,q53 char(1) not null,q54
char(1) not null,q55 char(1) not null,q56 char(1) not null,q57 char(1) not
null,q58 char(1) not null,q59 char(1) not null,q60 char(1) not null,q61 char(1)
not null,q62 char(1) not null,q63 char(1) not null,q64 char(1) not null,q65
char(1) not null,q66 char(1) not null,q67 char(1) not null,q68 char(1) not
null,q69 char(1) not null,q70 char(1) not null,q71 char(1) not null,q72 char(1)
not null,q73 char(1) not null,q74 char(1) not null,q75 char(1) not null,q76
char(1) not null,q77 char(1) not null,q78 char(1) not null,q79 char(1) not
null,q80 char(1) not null,q81 char(1) not null,q82 char(1) not null,q83 char(1)
not null,q84 char(1) not null,q85 char(1) not null,q86 char(1) not null,q87
char(1) not null,q88 char(1) not null,q89 char(1) not null,q90 char(1) not
null,q91 char(1) not null,q92 char(1) not null,q93 char(1) not null,q94 char
(1) not null,q95 char(1) not null,q96 char(1) not null,q97 char(1) not
null,q98 char(1) not null,q99 char(1) not null,q100 char(1) not null,q101
char(1) not null,q102 char(1) not null,q103 char(1) not null,q104 char(1) not
null,q105 char(1) not null,q106 char(1) not null,q107 char(1) not null,q108
char(1) not null,q109 char(1) not null,q110 char(1) not null,q111 char(1) not
null,q112 char(1) not null,q113 char(1) not null,q114 char(1) not null,q115
char(1) not null,q116 char(1) not null,q117 char(1) not null,q118 char(1) not
null,q119 char(1) not null,q120 char(1) not null,q121 char(1) not null,q122
char(1) not null,q123 char(1) not null,q124 char(1) not null,q125 char(1) not
null,q126 char(1) not null,q127 char(1) not null,q128 char(1) not null,q129
char(1) not null,q130 char(1) not null,q131 char(1) not null,q132 char(1) not
null,q133 char(1) not null,q134 char(1) not null,q135 char(1) not null,q136
char(1) not null,q137 char(1) not null,q138 char(1) not null,q139 char(1) not
null
,q140 char(1) not null,q141 char(1) not null,q142 char(1) not null,q143
char(1) not null,q144 char(1) not null,q145 char(1) not null,q146 char(1) not
null,q147 char(1) not null,q148 char(1) not null,q149 char(1) not null,q150
char(1) not null,q151 char(1) not null,q152 char(1) not null,q153 char(1) not
null,q154 char(1) not null,q155 char(1) not null,q156 char(1) not null,q157
char(1) not null,q158 char(1) not null,q159 char(1) not null,q160 char(1) not
null,q161 char(1) not null,q162 char(1) not null,q163 char(1) not null,q164
char(1) not null,q165 char(1) not null,q166 char(1) not null,q167 char(1) not
null,q168 char(1) not null,q169 char(1) not null,q170 char(1) not null,q171
char(1) not null,q172 char(1) not null,q173 char(1) not null,q174 char(1) not
null,q175 char(1) not null,q176 char(1) not null,q177 char(1) not null,q178
char(1) not null,q179 char(1) not null,q180 char(1) not null,q181 char(1) not
null,q182 char(1) not null,q183 char(1) not null,q184 char(1) not null,q185 c
har(1) not null,q186 char(1) not null,q187 char(1) not null,q188 char(1) not
null,q189 char(1) not null,q190 char(1) not null,q191 char(1) not null,q192
char(1) not null,q193 char(1) not null,q194 char(1) not null,q195 char(1) not
null,q196 char(1) not null,q197 char(1) not null,q198 char(1) not null,q199
char(1) not null,q200 char(1) not null,q201 char(1) not null,q202 char(1) not
null,q203 char(1) not null,q204 char(1) not null,q205 char(1) not null,q206
char(1) not null,q207 char(1) not null,q208 char(1) not null,q209 char(1) not
null,q210 char(1) not null,q211 char(1) not null,q212 char(1) not null,q213
char(1) not null,q214 char(1) not null,q215 char(1) not null,q216 char(1) not
null,q217 char(1) not null,q218 char(1) not null,q219 char(1) not null,q220
char(1) not null,q221 char(1) not null,q222 char(1) not null,q223 char(1) not
null,q224 char(1) not null,q225 char(1) not null,q226 char(1) not null,q227
char(1) not null,q228 char(1) not null,q229 char(1) not null,q230 char(1)
not null,q231 char(1) not null,q232 char(1) not null,q233 char(1) not
null,q234 char(1) not null,q235 char(1) not null,q236 char(1) not null,q237
char(1) not null,q238 char(1) not null,q239 char(1) not null,q240 char(1) not
null,q241 char(1) not null,q242 char(1) not null,q243 char(1) not null,q244
char(1) not null,q245 char(1) not null,q246 char(1) not null,q247 char(1) not
null,q248 char(1) not null,q249 char(1) not null,q250 char(1) not null,q251
char(1) not null,q252 char(1) not null,q253 char(1) not null,q254 char(1) not
null,q255 char(1) not null,q256 char(1) not null,q257 char(1) not null,q258
char(1) not null,q259 char(1) not null,q260 char(1) not null,q261 char(1) not
null,q262 char(1) not null,q263 char(1) not null,q264 char(1) not null,q265
char(1) not null,q266 char(1) not null,q267 char(1) not null,q268 char(1) not
null,q269 char(1) not null,q270 char(1) not null,q271 char(1) not null,q272
char(1) not null,q273 char(1) not null,q274 char(1) not null,q275 char(1) not
nul
l,q276 char(1) not null,q277 char(1) not null,q278 char(1) not null,q279
char(1) not null,q280 char(1) not null,q281 char(1) not null,q282 char(1) not
null,q283 char(1) not null,q284 char(1) not null,q285 char(1) not null,q286
char(1) not null,q287 char(1) not null,q288 char(1) not null,q289 char(1) not
null,q290 char(1) not null,q291 char(1) not null,q292 char(1) not null,q293
char(1) not null,q294 char(1) not null,q295 char(1) not null,q296 char(1) not
null,q297 char(1) not null,q298 char(1) not null,q299 char(1) not null,q300
char(1) not null,q301 char(1) not null,q302 char(1) not null,q303 char(1) not
null,q304 char(1) not null,q305 char(1) not null,q306 char(1) not null,q307
char(1) not null,q308 char(1) not null,q309 char(1) not null,q310 char(1) not
null,q311 char(1) not null,q312 char(1) not null,q313 char(1) not null,q314
char(1) not null,q315 char(1) not null,q316 char(1) not null,q317 char(1) not
null,q318 char(1) not null,q319 char(1) not null,q320 char(1) not null,q321
char(1) not null,q322 char(1) not null,q323 char(1) not null,q324 char(1) not
null,q325 char(1) not null,q326 char(1) not null,q327 char(1) not null,q328
char(1) not null,q329 char(1) not null,q330 char(1) not null,q331 char(1) not
null,q332 char(1) not null,q333 char(1) not null,q334 char(1) not null,q335
char(1) not null,q336 char(1) not null,q337 char(1) not null,q338 char(1) not
null,q339 char(1) not null,q340 char(1) not null,q341 char(1) not null,q342
char(1) not null,q343 char(1) not null,q344 char(1) not null,q345 char(1) not
null,q346 char(1) not null,q347 char(1) not null,q348 char(1) not null,q349
char(1) not null,q350 char(1) not null,q351 char(1) not null,q352 char(1) not
null,q353 char(1) not null,q354 char(1) not null,q355 char(1) not null,q356
char(1) not null,q357 char(1) not null,q358 char(1) not null,q359 char(1) not
null,q360 char(1) not null,q361 char(1) not null,q362 char(1) not null,q363
char(1) not null,q364 char(1) not null,q365 char(1) not null,q366 char(1)
not null,q367 char(1) not null,q368 char(1) not null,q369 char(1) not
null,q370 char(1) not null,q371 char(1) not null,q372 char(1) not null,q373
char(1) not null,q374 char(1) not null,q375 char(1) not null,q376 char(1) not
null,q377 char(1) not null,q378 char(1) not null,q379 char(1) not null,q380
char(1) not null,q381 char(1) not null,q382 char(1) not null,q383 char(1) not
null,q384 char(1) not null,q385 char(1) not null,q386 char(1) not null,q387
char(1) not null,q388 char(1) not null,q389 char(1) not null,q390 char(1) not
null,q391 char(1) not null,q392 char(1) not null,q393 char(1) not null,q394
char(1) not null,q395 char(1) not null,q396 char(1) not null,q397 char(1) not
null,q398 char(1) not null,q399 char(1) not null,q400 char(1) not null,q401
char(1) not null,q402 char(1) not null,q403 char(1) not null,q404 char(1) not
null,q405 char(1) not null,q406 char(1) not null,q407 char(1) not null,q408
char(1) not null,q409 char(1) not null,q410 char(1) not null,q411 char(1) not nu
ll,q412 char(1) not null,q413 char(1) not null,q414 char(1) not null,q415
char(1) not null,q416 char(1) not null,q417 char(1) not null,q418 char(1) not
null,q419 char(1) not null,q420 char(1) not null,q421 char(1) not null,q422
char(1) not null,q423 char(1) not null,q424 char(1) not null,q425 char(1) not
null,q426 char(1) not null,q427 char(1) not null,q428 char(1) not null,q429
char(1) not null,q430 char(1) not null,q431 char(1) not null,q432 char(1) not
null,q433 char(1) not null,q434 char(1) not null,q435 char(1) not null,q436
char(1) not null,q437 char(1) not null,q438 char(1) not null,q439 char(1) not
null,q440 char(1) not null,q441 char(1) not null,q442 char(1) not null,q443
char(1) not null,q444 char(1) not null,q445 char(1) not null,q446 char(1) not
null,q447 char(1) not null,q448 char(1) not null,q449 char(1) not null,q450
char(1) not null,q451 char(1) not null,q452 char(1) not null,q453 char(1) not
null,q454 char(1) not null,q455 char(1) not null,q456 char(1) not null,q457
char(1) not null,q458 char(1) not null,q459 char(1) not null,q460 char(1) not
null,q461 char(1) not null,q462 char(1) not null,q463 char(1) not null,q464
char(1) not null,q465 char(1) not null,q466 char(1) not null,q467 char(1) not
null,q468 char(1) not null,q469 char(1) not null,q470 char(1) not null,q471
char(1) not null,q472 char(1) not null,q473 char(1) not null,q474 char(1) not
null,q475 char(1) not null,q476 char(1) not null,q477 char(1) not null,q478
char(1) not null,q479 char(1) not null,q480 char(1) not null,q481 char(1) not
null,q482 char(1) not null,q483 char(1) not null,q484 char(1) not null,q485
char(1) not null,q486 char(1) not null,q487 char(1) not null,q488 char(1) not
null,q489 char(1) not null,q490 char(1) not null,q491 char(1) not null,q492
char(1) not null,q493 char(1) not null,q494 char(1) not null,q495 char(1) not
null,q496 char(1) not null,q497 char(1) not null,q498 char(1) not null,q499
char(1) not null,q500 char(1) not null,q501 char(1) not null,q502 char(1
) not null,q503 char(1) not null,q504 char(1) not null,q505 char(1) not
null,q506 char(1) not null,q507 char(1) not null,q508 char(1) not null,q509
char(1) not null,q510 char(1) not null,q511 char(1) not null,q512 char(1) not
null,q513 char(1) not null,q514 char(1) not null,q515 char(1) not null,q516
char(1) not null,q517 char(1) not null,q518 char(1) not null,q519 char(1) not
null,q520 char(1) not null,q521 char(1) not null,q522 char(1) not null,q523
char(1) not null,q524 char(1) not null,q525 char(1) not null,q526 char(1) not
null,q527 char(1) not null,q528 char(1) not null,q529 char(1) not null,q530
char(1) not null,q531 char(1) not null,q532 char(1) not null,q533 char(1) not
null,q534 char(1) not null,q535 char(1) not null,q536 char(1) not null,q537
char(1) not null,q538 char(1) not null,q539 char(1) not null,q540 char(1) not
null,q541 char(1) not null,q542 char(1) not null,q543 char(1) not null,q544
char(1) not null,q545 char(1) not null,q546 char(1) not null,q547 char(1) not n
ull,q548 char(1) not null,q549 char(1) not null,q550 char(1) not null,q551
char(1) not null,q552 char(1) not null,q553 char(1) not null,q554 char(1) not
null,q555 char(1) not null,q556 char(1) not null,q557 char(1) not null,q558
char(1) not null,q559 char(1) not null,q560 char(1) not null,q561 char(1) not
null,q562 char(1) not null,q563 char(1) not null,q564 char(1) not null,q565
char(1) not null,q566 char(1) not null,q567 char(1) not null,q568 char(1) not
null,q569 char(1) not null,q570 char(1) not null,q571 char(1) not null,q572
char(1) not null,q573 char(1) not null,q574 char(1) not null,q575 char(1) not
null,q576 char(1) not null,q577 char(1) not null,q578 char(1) not null,q579
char(1) not null,q580 char(1) not null,q581 char(1) not null,q582 char(1) not
null,q583 char(1) not null,q584 char(1) not null,q585 char(1) not null,q586
char(1) not null,q587 char(1) not null,q588 char(1) not null,q589 char(1) not
null,q590 char(1) not null,q591 char(1) not null,q592 char(1) not null,q59
3 char(1) not null,q594 char(1) not null,q595 char(1) not null,q596 char(1)
not null,q597 char(1) not null,q598 char(1) not null,q599 char(1) not null,q600
char(1) not null,q601 char(1) not null,q602 char(1) not null,q603 char(1) not
null,q604 char(1) not null,q605 char(1) not null,q606 char(1) not null,q607
char(1) not null,q608 char(1) not null,q609 char(1) not null,q610 char(1) not
null,q611 char(1) not null,q612 char(1) not null,q613 char(1) not null,q614
char(1) not null,q615 char(1) not null,q616 char(1) not null,q617 char(1) not
null,q618 char(1) not null,q619 char(1) not null,q620 char(1) not null,q621
char(1) not null,q622 char(1) not null,q623 char(1) not null,q624 char(1) not
null,q625 char(1) not null,q626 char(1) not null,q627 char(1) not null,q628
char(1) not null,q629 char(1) not null,q630 char(1) not null,q631 char(1) not
null,q632 char(1) not null,q633 char(1) not null,q634 char(1) not null,q635
char(1) not null,q636 char(1) not null,q637 char(1) not null,q638 char(
1) not null,q639 char(1) not null,q640 char(1) not null,q641 char(1) not
null,q642 char(1) not null,q643 char(1) not null,q644 char(1) not null,q645
char(1) not null,q646 char(1) not null,q647 char(1) not null,q648 char(1) not
null,q649 char(1) not null,q650 char(1) not null,q651 char(1) not null,q652
char(1) not null,q653 char(1) not null,q654 char(1) not null,q655 char(1) not
null,q656 char(1) not null,q657 char(1) not null,q658 char(1) not null,q659
char(1) not null,q660 char(1) not null,q661 char(1) not null,q662 char(1) not
null,q663 char(1) not null,q664 char(1) not null,q665 char(1) not null,q666
char(1) not null,q667 char(1) not null,q668 char(1) not null,q669 char(1) not
null,q670 char(1) not null,q671 char(1) not null,q672 char(1) not null,q673
char(1) not null,q674 char(1) not null,q675 char(1) not null,q676 char(1) not
null,q677 char(1) not null,q678 char(1) not null,q679 char(1) not null,q680
char(1) not null,q681 char(1) not null,q682 char(1) not null,q683 char(1) not
null,q684 char(1) not null,q685 char(1) not null,q686 char(1) not null,q687
char(1) not null,q688 char(1) not null,q689 char(1) not null,q690 char(1) not
null,q691 char(1) not null,q692 char(1) not null,q693 char(1) not null,q694
char(1) not null,q695 char(1) not null,q696 char(1) not null,q697 char(1) not
null,q698 char(1) not null,q699 char(1) not null,q700 char(1) not null,q701
char(1) not null,q702 char(1) not null,q703 char(1) not null,q704 char(1) not
null,q705 char(1) not null,q706 char(1) not null,q707 char(1) not null,q708
char(1) not null,q709 char(1) not null,q710 char(1) not null,q711 char(1) not
null,q712 char(1) not null,q713 char(1) not null,q714 char(1) not null,q715
char(1) not null,q716 char(1) not null,q717 char(1) not null,q718 char(1) not
null,q719 char(1) not null,q720 char(1) not null,q721 char(1) not null,q722
char(1) not null,q723 char(1) not null,q724 char(1) not null,q725 char(1) not
null,q726 char(1) not null,q727 char(1) not null,q728 char(1) not null,q7
29 char(1) not null,q730 char(1) not null,q731 char(1) not null,q732 char(1)
not null,q733 char(1) not null,q734 char(1) not null,q735 char(1) not null,q736
char(1) not null,q737 char(1) not null,q738 char(1) not null,q739 char(1) not
null,q740 char(1) not null,q741 char(1) not null,q742 char(1) not null,q743
char(1) not null,q744 char(1) not null,q745 char(1) not null,q746 char(1) not
null,q747 char(1) not null,q748 char(1) not null,q749 char(1) not null,q750
char(1) not null,q751 char(1) not null,q752 char(1) not null,q753 char(1) not
null,q754 char(1) not null,q755 char(1) not null,q756 char(1) not null,q757
char(1) not null,q758 char(1) not null,q759 char(1) not null,q760 char(1) not
null,q761 char(1) not null,q762 char(1) not null,q763 char(1) not null,q764
char(1) not null,q765 char(1) not null,q766 char(1) not null,q767 char(1) not
null,q768 char(1) not null,q769 char(1) not null,q770 char(1) not null,q771
char(1) not null,q772 char(1) not null,q773 char(1) not null,q774 char
(1) not null,q775 char(1) not null,q776 char(1) not null,q777 char(1) not
null,q778 char(1) not null,q779 char(1) not null,q780 char(1) not null,q781
char(1) not null,q782 char(1) not null,q783 char(1) not null,q784 char(1) not
null,q785 char(1) not null,q786 char(1) not null,q787 char(1) not null,q788
char(1) not null,q789 char(1) not null,q790 char(1) not null,q791 char(1) not
null,q792 char(1) not null,q793 char(1) not null,q794 char(1) not null,q795
char(1) not null,q796 char(1) not null,q797 char(1) not null,q798 char(1) not
null,q799 char(1) not null,q800 char(1) not null,q801 char(1) not null,q802
char(1) not null,q803 char(1) not null,q804 char(1) not null,q805 char(1) not
null,q806 char(1) not null,q807 char(1) not null,q808 char(1) not null,q809
char(1) not null,q810 char(1) not null,q811 char(1) not null,q812 char(1) not
null,q813 char(1) not null,q814 char(1) not null,q815 char(1) not null,q816
char(1) not null,q817 char(1) not null,q818 char(1) not null,unique (q0,q1,q2
,q3,q4,q5,q6,q7,q8,q9,q10,q11,q12,q13,q14,q15,q16,q17,q18,q19,q20,q21,q22,q23,q24,q25,q26,q27,q28,q29,q30,q31,q32,q33,q34,q35,q36,q37,q38,q39,q40,q41,q42,q43,q44,q45,q46,q47,q48,q49,q50,q51,q52,q53,q54,q55,q56,q57,q58,q59,q60,q61,q62,q63,q64,q65,q66,q67,q68,q69,q70,q71,q72,q73,q74,q75,q76,q77,q78,q79,q80,q81,q82,q83,q84,q85,q86,q87,q88,q89,q90,q91,q92,q93,q94,q95,q96,q97,q98,q99,q100,q101,q102,q103,q104,q105,q106,q107,q108,q109,q110,q111,q112,q113,q114,q115,q116,q117,q118,q119,q120,q121,q122,q123,q124,q125,q126,q127,q128,q129,q130,q131,q132,q133,q134,q135,q136,q137,q138,q139,q140,q141,q142,q143,q144,q145,q146,q147,q148,q149,q150,q151,q152,q153,q154,q155,q156,q157,q158,q159,q160,q161,q162,q163,q164,q165,q166,q167,q168,q169,q170,q171,q172,q173,q174,q175,q176,q177,q178,q179,q180,q181,q182,q183,q184,q185,q186,q187,q188,q189,q190,q191,q192,q193,q194,q195,q196,q197,q198,q199,q200,q201,q202,q203,q204,q205,q206,q207,q208,q209,q210,q211,q212,q213,q214,q215,q216,q217,q218,q219,q220,q221,q222,
q223,q224,q225,q226,q227,q228,q229,q230,q231,q232,q233,q234,q235,q236,q237,q238,q239,q240,q241,q242,q243,q244,q245,q246,q247,q248,q249,q250,q251,q252,q253,q254,q255,q256,q257,q258,q259,q260,q261,q262,q263,q264,q265,q266,q267,q268,q269,q270,q271,q272,q273,q274,q275,q276,q277,q278,q279,q280,q281,q282,q283,q284,q285,q286,q287,q288,q289,q290,q291,q292,q293,q294,q295,q296,q297,q298,q299,q300,q301,q302,q303,q304,q305,q306,q307,q308,q309,q310,q311,q312,q313,q314,q315,q316,q317,q318,q319,q320,q321,q322,q323,q324,q325,q326,q327,q328,q329,q330,q331,q332,q333,q334,q335,q336,q337,q338,q339,q340,q341,q342,q343,q344,q345,q346,q347,q348,q349,q350,q351,q352,q353,q354,q355,q356,q357,q358,q359,q360,q361,q362,q363,q364,q365,q366,q367,q368,q369,q370,q371,q372,q373,q374,q375,q376,q377,q378,q379,q380,q381,q382,q383,q384,q385,q386,q387,q388,q389,q390,q391,q392,q393,q394,q395,q396,q397,q398,q399,q400,q401,q402,q403,q404,q405,q406,q407,q408,q409,q410,q411,q412,q413,q414,q415,q416,q417,q418,q419,q420,q421,q4
22,q423,q424,q425,q426,q427,q428,q429,q430,q431,q432,q433,q434,q435,q436,q437,q438,q439,q440,q441,q442,q443,q444,q445,q446,q447,q448,q449,q450,q451,q452,q453,q454,q455,q456,q457,q458,q459,q460,q461,q462,q463,q464,q465,q466,q467,q468,q469,q470,q471,q472,q473,q474,q475,q476,q477,q478,q479,q480,q481,q482,q483,q484,q485,q486,q487,q488,q489,q490,q491,q492,q493,q494,q495,q496,q497,q498,q499,q500,q501,q502,q503,q504,q505,q506,q507,q508,q509,q510,q511,q512,q513,q514,q515,q516,q517,q518,q519,q520,q521,q522,q523,q524,q525,q526,q527,q528,q529,q530,q531,q532,q533,q534,q535,q536,q537,q538,q539,q540,q541,q542,q543,q544,q545,q546,q547,q548,q549,q550,q551,q552,q553,q554,q555,q556,q557,q558,q559,q560,q561,q562,q563,q564,q565,q566,q567,q568,q569,q570,q571,q572,q573,q574,q575,q576,q577,q578,q579,q580,q581,q582,q583,q584,q585,q586,q587,q588,q589,q590,q591,q592,q593,q594,q595,q596,q597,q598,q599,q600,q601,q602,q603,q604,q605,q606,q607,q608,q609,q610,q611,q612,q613,q614,q615,q616,q617,q618,q619,q620,q621
,q622,q623,q624,q625,q626,q627,q628,q629,q630,q631,q632,q633,q634,q635,q636,q637,q638,q639,q640,q641,q642,q643,q644,q645,q646,q647,q648,q649,q650,q651,q652,q653,q654,q655,q656,q657,q658,q659,q660,q661,q662,q663,q664,q665,q666,q667,q668,q669,q670,q671,q672,q673,q674,q675,q676,q677,q678,q679,q680,q681,q682,q683,q684,q685,q686,q687,q688,q689,q690,q691,q692,q693,q694,q695,q696,q697,q698,q699,q700,q701,q702,q703,q704,q705,q706,q707,q708,q709,q710,q711,q712,q713,q714,q715,q716,q717,q718,q719,q720,q721,q722,q723,q724,q725,q726,q727,q728,q729,q730,q731,q732,q733,q734,q735,q736,q737,q738,q739,q740,q741,q742,q743,q744,q745,q746,q747,q748,q749,q750,q751,q752,q753,q754,q755,q756,q757,q758,q759,q760,q761,q762,q763,q764,q765,q766,q767,q768,q769,q770,q771,q772,q773,q774,q775,q776,q777,q778,q779,q780,q781,q782,q783,q784,q785,q786,q787,q788,q789,q790,q791,q792,q793,q794,q795,q796,q797,q798,q799,q800,q801,q802,q803,q804,q805,q806,q807,q808,q809,q810,q811,q812,q813,q814,q815,q816,q817,q818));
-insert into crash_q
values('a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a
','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a'
,'a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a',
'a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a');
+create table crash_q (q0 char(1) not null,q1 char(1) not null,q2 char(1) not
null,q3 char(1) not null,q4 char(1) not null,q5 char(1) not null,q6 char(1) not
null,q7 char(1) not null,q8 char(1) not null,q9 char(1) not null,q10 char(1)
not null,q11 char(1) not null,q12 char(1) not null,q13 char(1) not null,q14
char(1) not null,q15 char(1) not null,q16 char(1) not null,q17 char(1) not
null,q18 char(1) not null,q19 char(1) not null,q20 char(1) not null,q21 char(1)
not null,q22 char(1) not null,q23 char(1) not null,q24 char(1) not null,q25
char(1) not null,q26 char(1) not null,q27 char(1) not null,q28 char(1) not
null,q29 char(1) not null,q30 char(1) not null,q31 char(1) not null,q32 char(1)
not null,q33 char(1) not null,q34 char(1) not null,q35 char(1) not null,q36
char(1) not null,q37 char(1) not null,q38 char(1) not null,q39 char(1) not
null,q40 char(1) not null,q41 char(1) not null,q42 char(1) not null,q43 char(1)
not null,q44 char(1) not null,q45 char(1) not null,q46 char(1) not nul
l,q47 char(1) not null,q48 char(1) not null,q49 char(1) not null,q50 char(1)
not null,q51 char(1) not null,q52 char(1) not null,q53 char(1) not null,q54
char(1) not null,q55 char(1) not null,q56 char(1) not null,q57 char(1) not
null,q58 char(1) not null,q59 char(1) not null,q60 char(1) not null,q61 char(1)
not null,q62 char(1) not null,q63 char(1) not null,q64 char(1) not null,q65
char(1) not null,q66 char(1) not null,q67 char(1) not null,q68 char(1) not
null,q69 char(1) not null,q70 char(1) not null,q71 char(1) not null,q72 char(1)
not null,q73 char(1) not null,q74 char(1) not null,q75 char(1) not null,q76
char(1) not null,q77 char(1) not null,q78 char(1) not null,q79 char(1) not
null,q80 char(1) not null,q81 char(1) not null,q82 char(1) not null,q83 char(1)
not null,q84 char(1) not null,q85 char(1) not null,q86 char(1) not null,q87
char(1) not null,q88 char(1) not null,q89 char(1) not null,q90 char(1) not
null,q91 char(1) not null,q92 char(1) not null,q93 char(1) not null,q94 char
(1) not null,q95 char(1) not null,q96 char(1) not null,q97 char(1) not
null,q98 char(1) not null,q99 char(1) not null,unique
(q0,q1,q2,q3,q4,q5,q6,q7,q8,q9,q10,q11,q12,q13,q14,q15,q16,q17,q18,q19,q20,q21,q22,q23,q24,q25,q26,q27,q28,q29,q30,q31,q32,q33,q34,q35,q36,q37,q38,q39,q40,q41,q42,q43,q44,q45,q46,q47,q48,q49,q50,q51,q52,q53,q54,q55,q56,q57,q58,q59,q60,q61,q62,q63,q64,q65,q66,q67,q68,q69,q70,q71,q72,q73,q74,q75,q76,q77,q78,q79,q80,q81,q82,q83,q84,q85,q86,q87,q88,q89,q90,q91,q92,q93,q94,q95,q96,q97,q98,q99));
+insert into crash_q
values('a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a','a');
drop table crash_q ;
-
diff --git a/sql/test/BugTracker-2012/Tests/huge_table_update.Bug-2803.sql
b/sql/test/BugTracker-2012/Tests/huge_table_update.Bug-2803.sql
--- a/sql/test/BugTracker-2012/Tests/huge_table_update.Bug-2803.sql
+++ b/sql/test/BugTracker-2012/Tests/huge_table_update.Bug-2803.sql
@@ -100,4907 +100,7 @@ a95 integer,
a96 integer,
a97 integer,
a98 integer,
-a99 integer,
-a100 integer,
-a101 integer,
-a102 integer,
-a103 integer,
-a104 integer,
-a105 integer,
-a106 integer,
-a107 integer,
-a108 integer,
-a109 integer,
-a110 integer,
-a111 integer,
-a112 integer,
-a113 integer,
-a114 integer,
-a115 integer,
-a116 integer,
-a117 integer,
-a118 integer,
-a119 integer,
-a120 integer,
-a121 integer,
-a122 integer,
-a123 integer,
-a124 integer,
-a125 integer,
-a126 integer,
-a127 integer,
-a128 integer,
-a129 integer,
-a130 integer,
-a131 integer,
-a132 integer,
-a133 integer,
-a134 integer,
-a135 integer,
-a136 integer,
-a137 integer,
-a138 integer,
-a139 integer,
-a140 integer,
-a141 integer,
-a142 integer,
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
