Changeset: 8b85ed265a74 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8b85ed265a74
Removed Files:
sql/test/BugTracker-2017/Tests/default-insert-update.Bug-6249.sql
sql/test/BugTracker-2017/Tests/default-insert-update.Bug-6249.stable.err
sql/test/BugTracker-2017/Tests/default-insert-update.Bug-6249.stable.out
Modified Files:
gdk/gdk_hash.c
gdk/gdk_imprints.c
sql/server/rel_schema.c
sql/server/rel_updates.c
sql/server/sql_parser.y
sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.sql
sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.sql
sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.sql
sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.sql
sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out
sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.sql
sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.stable.out
sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.sql
sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.stable.out
sql/test/BugTracker-2014/Tests/select-having.Bug-3458.sql
sql/test/BugTracker-2015/Tests/cardinality.Bug-3761.sql
sql/test/BugTracker-2015/Tests/cardinality.Bug-3761.stable.out
sql/test/BugTracker-2017/Tests/All
sql/test/bugs/Tests/crash_order_by.sql
sql/test/bugs/Tests/simple_view.sql
sql/test/bugs/insert_delete-bug-sf-904025.sql
Branch: Dec2016
Log Message:
merged
diffs (truncated from 604 to 300 lines):
diff --git a/gdk/gdk_hash.c b/gdk/gdk_hash.c
--- a/gdk/gdk_hash.c
+++ b/gdk/gdk_hash.c
@@ -202,17 +202,16 @@ BATcheckhash(BAT *b)
Hash *h;
Heap *hp;
const char *nme = BBP_physical(b->batCacheid);
- const char *ext = b->batCacheid > 0 ? "thash" : "hhash";
int fd;
b->thash = NULL;
if ((hp = GDKzalloc(sizeof(*hp))) != NULL &&
(hp->farmid = BBPselectfarm(b->batRole, b->ttype,
hashheap)) >= 0 &&
(hp->filename = GDKmalloc(strlen(nme) + 12)) != NULL) {
- sprintf(hp->filename, "%s.%s", nme, ext);
+ sprintf(hp->filename, "%s.thash", nme);
/* check whether a persisted hash can be found */
- if ((fd = GDKfdlocate(hp->farmid, nme, "rb+", ext)) >=
0) {
+ if ((fd = GDKfdlocate(hp->farmid, nme, "rb+", "thash"))
>= 0) {
size_t hdata[HASH_HEADER_SIZE];
struct stat st;
@@ -226,7 +225,7 @@ BATcheckhash(BAT *b)
hdata[4] == (size_t) BATcount(b) &&
fstat(fd, &st) == 0 &&
st.st_size >= (off_t) (hp->size = hp->free
= (hdata[1] + hdata[2]) * hdata[3] + HASH_HEADER_SIZE * SIZEOF_SIZE_T) &&
- HEAPload(hp, nme, ext, 0) == GDK_SUCCEED) {
+ HEAPload(hp, nme, "thash", 0) ==
GDK_SUCCEED) {
h->lim = (BUN) hdata[1];
h->type = ATOMtype(b->ttype);
h->mask = (BUN) (hdata[2] - 1);
@@ -260,7 +259,7 @@ BATcheckhash(BAT *b)
GDKfree(h);
close(fd);
/* unlink unusable file */
- GDKunlink(hp->farmid, BATDIR, nme, ext);
+ GDKunlink(hp->farmid, BATDIR, nme, "thash");
}
GDKfree(hp->filename);
}
@@ -338,7 +337,6 @@ BAThash(BAT *b, BUN masksize)
Hash *h = NULL;
Heap *hp;
const char *nme = BBP_physical(b->batCacheid);
- const char *ext = b->batCacheid > 0 ? "thash" : "hhash";
BATiter bi = bat_iterator(b);
ALGODEBUG fprintf(stderr, "#BAThash: create hash(%s#" BUNFMT
");\n", BATgetId(b), BATcount(b));
@@ -350,7 +348,7 @@ BAThash(BAT *b, BUN masksize)
return GDK_FAIL;
}
hp->dirty = TRUE;
- sprintf(hp->filename, "%s.%s", nme, ext);
+ sprintf(hp->filename, "%s.thash", nme);
/* cnt = 0, hopefully there is a proper capacity from
* which we can derive enough information */
@@ -581,7 +579,7 @@ HASHdestroy(BAT *b)
GDKunlink(BBPselectfarm(b->batRole, b->ttype, hashheap),
BATDIR,
BBP_physical(b->batCacheid),
- b->batCacheid > 0 ? "thash" : "hhash");
+ "thash");
} else if (b->thash) {
bat p = VIEWtparent(b);
BAT *hp = NULL;
diff --git a/gdk/gdk_imprints.c b/gdk/gdk_imprints.c
--- a/gdk/gdk_imprints.c
+++ b/gdk/gdk_imprints.c
@@ -208,7 +208,6 @@ BATcheckimprints(BAT *b)
Imprints *imprints;
Heap *hp;
str nme = BBP_physical(b->batCacheid);
- const char *ext = b->batCacheid > 0 ? "timprints" : "himprints";
b->timprints = NULL;
if ((hp = GDKzalloc(sizeof(Heap))) != NULL &&
@@ -216,10 +215,10 @@ BATcheckimprints(BAT *b)
(hp->filename = GDKmalloc(strlen(nme) + 12)) != NULL) {
int fd;
- sprintf(hp->filename, "%s.%s", nme, ext);
+ sprintf(hp->filename, "%s.timprints", nme);
/* check whether a persisted imprints index
* can be found */
- if ((fd = GDKfdlocate(hp->farmid, nme, "rb", ext)) >=
0) {
+ if ((fd = GDKfdlocate(hp->farmid, nme, "rb",
"timprints")) >= 0) {
size_t hdata[4];
struct stat st;
size_t pages;
@@ -240,7 +239,7 @@ BATcheckimprints(BAT *b)
hdata[2] *
sizeof(cchdc_t) +
sizeof(uint64_t) /*
padding for alignment */
+ 4 * SIZEOF_SIZE_T)
&&
- HEAPload(hp, nme, b->batCacheid > 0 ?
"timprints" : "himprints", 0) == GDK_SUCCEED) {
+ HEAPload(hp, nme, "timprints", 0) ==
GDK_SUCCEED) {
/* usable */
imprints->imprints = hp;
imprints->bits = (bte) (hdata[0] &
0xFF);
@@ -261,7 +260,7 @@ BATcheckimprints(BAT *b)
GDKfree(imprints);
close(fd);
/* unlink unusable file */
- GDKunlink(hp->farmid, BATDIR, nme, ext);
+ GDKunlink(hp->farmid, BATDIR, nme, "timprints");
}
GDKfree(hp->filename);
}
@@ -342,8 +341,7 @@ BATimprints(BAT *b)
MT_lock_unset(&GDKimprintsLock(b->batCacheid));
return GDK_FAIL;
}
- sprintf(imprints->imprints->filename, "%s.%cimprints", nme,
- b->batCacheid > 0 ? 't' : 'h');
+ sprintf(imprints->imprints->filename, "%s.timprints", nme);
pages = (((size_t) BATcount(b) * b->twidth) + IMPS_PAGE - 1) /
IMPS_PAGE;
imprints->imprints->farmid = BBPselectfarm(b->batRole, b->ttype,
imprintsheap);
@@ -472,9 +470,9 @@ BATimprints(BAT *b)
((size_t *) imprints->imprints->base)[2] = (size_t)
imprints->dictcnt;
((size_t *) imprints->imprints->base)[3] = (size_t) BATcount(b);
if ((BBP_status(b->batCacheid) & BBPEXISTING) &&
- HEAPsave(imprints->imprints, nme, b->batCacheid > 0 ?
"timprints" : "himprints") == GDK_SUCCEED &&
+ HEAPsave(imprints->imprints, nme, "timprints") ==
GDK_SUCCEED &&
(fd = GDKfdlocate(imprints->imprints->farmid, nme, "rb+",
- b->batCacheid > 0 ? "timprints" :
"himprints")) >= 0) {
+ "timprints")) >= 0) {
ALGODEBUG fprintf(stderr, "#BATimprints: persisting
imprints\n");
/* add version number */
((size_t *) imprints->imprints->base)[0] |= (size_t)
IMPRINTS_VERSION << 8;
@@ -610,7 +608,7 @@ IMPSremove(BAT *b)
* (size_t *) imprints->imprints->base & (1 << 16))
fprintf(stderr, "#IMPSremove: removing persisted
imprints\n");
if (HEAPdelete(imprints->imprints, BBP_physical(b->batCacheid),
- b->batCacheid > 0 ? "timprints" : "himprints"))
+ "timprints"))
IODEBUG fprintf(stderr, "#IMPSremove(%s): imprints
heap\n", BATgetId(b));
GDKfree(imprints->imprints);
diff --git a/sql/server/rel_updates.c b/sql/server/rel_updates.c
--- a/sql/server/rel_updates.c
+++ b/sql/server/rel_updates.c
@@ -23,12 +23,6 @@ insert_value(mvc *sql, sql_column *c, sq
{
if (s->token == SQL_NULL) {
return exp_atom(sql->sa, atom_general(sql->sa, &c->type, NULL));
- } else if (s->token == SQL_DEFAULT) {
- if (c->def) {
- return rel_parse_val(sql, sa_message(sql->sa, "select
CAST(%s AS %s);", c->def, c->type.type->sqlname), sql->emode);
- } else {
- return sql_error(sql, 02, "INSERT INTO: column '%s' has
no valid default value", c->base.name);
- }
} else {
int is_last = 0;
exp_kind ek = {type_value, card_value, FALSE};
@@ -977,19 +971,11 @@ update_table(mvc *sql, dlist *qname, dli
int status = sql->session->status;
exp_kind ek = {type_value,
(single)?card_column:card_relation, FALSE};
- if(single && a->token == SQL_DEFAULT) {
- char *colname =
assignment->h->next->data.sval;
- sql_column *col = mvc_bind_column(sql,
t, colname);
- if (col->def) {
- v = rel_parse_val(sql,
sa_message(sql->sa, "select CAST(%s AS %s);", col->def,
col->type.type->sqlname), sql->emode);
- } else {
- return sql_error(sql, 02,
"UPDATE: column '%s' has no valid default value", col->base.name);
- }
- } else if (single) {
+ if (single)
v = rel_value_exp(sql, &rel_val, a,
sql_sel, ek);
- } else {
+ else
rel_val = rel_subquery(sql, NULL, a,
ek, APPLY_JOIN);
- }
+
if (!v) {
sql->errstr[0] = 0;
sql->session->status = status;
diff --git a/sql/server/sql_parser.y b/sql/server/sql_parser.y
--- a/sql/server/sql_parser.y
+++ b/sql/server/sql_parser.y
@@ -2822,7 +2822,6 @@ simple_atom:
insert_atom:
simple_atom
- | DEFAULT { $$ = _symbol_create(SQL_DEFAULT, NULL ); }
;
value:
@@ -2843,12 +2842,7 @@ assignment_commalist:
;
assignment:
- column '=' DEFAULT
- { dlist *l = L();
- append_symbol(l, _symbol_create(SQL_DEFAULT, NULL ) );
- append_string(l, $1);
- $$ = _symbol_create_list( SQL_ASSIGN, l); }
- | column '=' search_condition
+ column '=' search_condition
{ dlist *l = L();
append_symbol(l, $3 );
append_string(l, $1);
diff --git a/sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.sql
b/sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.sql
--- a/sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.sql
+++ b/sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552.sql
@@ -47,7 +47,7 @@ 5717 "queue" 2000 "create view sys.queue
6368 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false 0
6380 "storagemodelinput" 2000 NULL 0 true 0 false 0
6428 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false 0
-6438 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxiliary column denotes
the maximum space if all non-sorted columns\n-- would be augmented with a hash
(rare situation)\ncreate view sys.tablestoragemodel\nas select
""schema"",""table"",max(count) as ""count"",\n\tsum(columnsize) as
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as
hashes,\n\tsum("imprints") as "imprints",\n\tsum(case when sorted = false then
8 * count else 0 end) as auxiliary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 false 0
+6438 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxiliary column denotes
the maximum space if all non-sorted columns\n-- would be augmented with a hash
(rare situation)\ncreate view sys.tablestoragemodel\nas select
""schema"",""table"",max(count) as ""count"",\n\tsum(columnsize) as
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as
hashes,\n\tsum(""imprints"") as ""imprints"",\n\tsum(case when sorted = false
then 8 * count else 0 end) as auxiliary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 false 0
6453 "statistics" 2000 NULL 0 true 0 false 0
6616 "systemfunctions" 2000 NULL 0 true 0 false 0
diff --git a/sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.sql
b/sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.sql
--- a/sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.sql
+++ b/sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.sql
@@ -47,7 +47,7 @@ 5717 "queue" 2000 "create view sys.queue
6368 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false 0
6380 "storagemodelinput" 2000 NULL 0 true 0 false 0
6428 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false 0
-6438 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxiliary column denotes
the maximum space if all non-sorted columns\n-- would be augmented with a hash
(rare situation)\ncreate view sys.tablestoragemodel\nas select
""schema"",""table"",max(count) as ""count"",\n\tsum(columnsize) as
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as
hashes,\n\tsum("imprints") as "imprints",\n\tsum(case when sorted = false then
8 * count else 0 end) as auxiliary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 false 0
+6438 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxiliary column denotes
the maximum space if all non-sorted columns\n-- would be augmented with a hash
(rare situation)\ncreate view sys.tablestoragemodel\nas select
""schema"",""table"",max(count) as ""count"",\n\tsum(columnsize) as
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as
hashes,\n\tsum(""imprints"") as ""imprints"",\n\tsum(case when sorted = false
then 8 * count else 0 end) as auxiliary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 false 0
6453 "statistics" 2000 NULL 0 true 0 false 0
6616 "systemfunctions" 2000 NULL 0 true 0 false 0
diff --git
a/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.sql
b/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.sql
---
a/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.sql
+++
b/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.sql
@@ -47,7 +47,7 @@ 5717 "queue" 2000 "create view sys.queue
6368 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false 0
6380 "storagemodelinput" 2000 NULL 0 true 0 false 0
6428 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false 0
-6438 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxiliary column denotes
the maximum space if all non-sorted columns\n-- would be augmented with a hash
(rare situation)\ncreate view sys.tablestoragemodel\nas select
""schema"",""table"",max(count) as ""count"",\n\tsum(columnsize) as
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as
hashes,\n\tsum("imprints") as "imprints",\n\tsum(case when sorted = false then
8 * count else 0 end) as auxiliary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 false 0
+6438 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxiliary column denotes
the maximum space if all non-sorted columns\n-- would be augmented with a hash
(rare situation)\ncreate view sys.tablestoragemodel\nas select
""schema"",""table"",max(count) as ""count"",\n\tsum(columnsize) as
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as
hashes,\n\tsum(""imprints"") as ""imprints"",\n\tsum(case when sorted = false
then 8 * count else 0 end) as auxiliary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 false 0
6453 "statistics" 2000 NULL 0 true 0 false 0
6616 "systemfunctions" 2000 NULL 0 true 0 false 0
diff --git a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.sql
b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.sql
--- a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.sql
+++ b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.sql
@@ -47,7 +47,7 @@ 5717 "queue" 2000 "create view sys.queue
6368 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false 0
6380 "storagemodelinput" 2000 NULL 0 true 0 false 0
6428 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false 0
-6438 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxiliary column denotes
the maximum space if all non-sorted columns\n-- would be augmented with a hash
(rare situation)\ncreate view sys.tablestoragemodel\nas select
""schema"",""table"",max(count) as ""count"",\n\tsum(columnsize) as
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as
hashes,\n\tsum("imprints") as "imprints",\n\tsum(case when sorted = false then
8 * count else 0 end) as auxiliary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 false 0
+6438 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxiliary column denotes
the maximum space if all non-sorted columns\n-- would be augmented with a hash
(rare situation)\ncreate view sys.tablestoragemodel\nas select
""schema"",""table"",max(count) as ""count"",\n\tsum(columnsize) as
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as
hashes,\n\tsum(""imprints"") as ""imprints"",\n\tsum(case when sorted = false
then 8 * count else 0 end) as auxiliary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 false 0
6453 "statistics" 2000 NULL 0 true 0 false 0
6616 "systemfunctions" 2000 NULL 0 true 0 false 0
diff --git
a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out
b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out
--- a/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out
+++ b/sql/test/BugTracker-2012/Tests/predicate_select.Bug-3090.stable.out
@@ -51,7 +51,7 @@ Ready.
% sys.tbls, sys.tbls, sys.tbls, sys.tbls, sys.tbls,
sys.tbls, sys.tbls, sys.tbls # table_name
% name, schema_id, query, type, system, commit_action,
readonly, temporary # name
% varchar, int, varchar, smallint, boolean,
smallint, boolean, smallint # type
-% 17, 4, 379, 1, 5, 1, 5, 1 # length
+% 17, 4, 526, 1, 5, 1, 5, 1 # length
[ "schemas", 2000, NULL, 0, true, 0, false, 0 ]
[ "types", 2000, NULL, 0, true, 0, false, 0 ]
[ "functions", 2000, NULL, 0, true, 0, false, 0 ]
@@ -89,7 +89,7 @@ Ready.
[ "storage", 2000, "create view sys.storage as select * from
sys.storage();", 1, true, 0, false, 0 ]
[ "storagemodelinput", 2000, NULL, 0, true, 0, false, 0
]
[ "storagemodel", 2000, "create view sys.storagemodel as select * from
sys.storagemodel();", 1, true, 0, false, 0 ]
-[ "tablestoragemodel", 2000, "-- A summary of the table storage requirement
is is available as a table view.\n-- The auxiliary column denotes the maximum
space if all non-sorted columns\n-- would be augmented with a hash (rare
situation)\ncreate view sys.tablestoragemodel\nas select
\"schema\",\"table\",max(count) as \"count\",\n\tsum(columnsize) as
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as hashes,\n\tsum(",
1, true, 0, false, 0 ]
+[ "tablestoragemodel", 2000, "-- A summary of the table storage requirement
is is available as a table view.\n-- The auxiliary column denotes the maximum
space if all non-sorted columns\n-- would be augmented with a hash (rare
situation)\ncreate view sys.tablestoragemodel\nas select
\"schema\",\"table\",max(count) as \"count\",\n\tsum(columnsize) as
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as
hashes,\n\tsum(\"imprints\") as \"imprints\",\n\tsum(case when sorted = false
then 8 * count else 0 end) as auxiliary\nfrom sys.storagemodel() group by
\"schema\",\"table\";", 1, true, 0, false, 0 ]
[ "statistics", 2000, NULL, 0, true, 0, false, 0
]
[ "systemfunctions", 2000, NULL, 0, true, 0, false, 0
]
diff --git a/sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.sql
b/sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.sql
--- a/sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.sql
+++ b/sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.sql
@@ -47,7 +47,7 @@ 5717 "queue" 2000 "create view sys.queue
6368 "storage" 2000 "create view sys.storage as select * from
sys.storage();" 1 true 0 false 0
6380 "storagemodelinput" 2000 NULL 0 true 0 false 0
6428 "storagemodel" 2000 "create view sys.storagemodel as select * from
sys.storagemodel();" 1 true 0 false 0
-6438 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxiliary column denotes
the maximum space if all non-sorted columns\n-- would be augmented with a hash
(rare situation)\ncreate view sys.tablestoragemodel\nas select
""schema"",""table"",max(count) as ""count"",\n\tsum(columnsize) as
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as
hashes,\n\tsum("imprints") as "imprints",\n\tsum(case when sorted = false then
8 * count else 0 end) as auxiliary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 false 0
+6438 "tablestoragemodel" 2000 "-- A summary of the table storage
requirement is is available as a table view.\n-- The auxiliary column denotes
the maximum space if all non-sorted columns\n-- would be augmented with a hash
(rare situation)\ncreate view sys.tablestoragemodel\nas select
""schema"",""table"",max(count) as ""count"",\n\tsum(columnsize) as
columnsize,\n\tsum(heapsize) as heapsize,\n\tsum(hashes) as
hashes,\n\tsum(""imprints"") as ""imprints"",\n\tsum(case when sorted = false
then 8 * count else 0 end) as auxiliary\nfrom sys.storagemodel() group by
""schema"",""table"";" 1 true 0 false 0
6453 "statistics" 2000 NULL 0 true 0 false 0
6616 "systemfunctions" 2000 NULL 0 true 0 false 0
diff --git
a/sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.stable.out
b/sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.stable.out
--- a/sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.stable.out
+++ b/sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.stable.out
@@ -50,8 +50,8 @@ Ready.
#2086 "idxs" 2000 NULL 0 true 0 false 0
[ 40 ]
#select sys.median(cast (id as double)) from tbls;
-% sys.L3 # table_name
-% L2 # name
+% sys.L5 # table_name
+% L4 # name
% double # type
% 24 # length
[ 5183 ]
diff --git a/sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.sql
b/sql/test/BugTracker-2013/Tests/swapped_likejoin.Bug-3375.sql
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
